Ask Question

Using cell references, enter a formula in cell b6 to calculate monthly payments for the loan described in this worksheet. omit the optional arguments. use a negative value for the pv argument. font size

+1
Answers (1)
  1. 13 December, 00:12
    0
    On the Formulas tab, in the Function Library group, click the Financial button, and click PMT. Enter B3/12 in the Rate argument box. Enter B4 in the Nper argument box. Enter B2 in the Pv argument box. Click OK.

    Explanation:

    Inside any excel spreadsheet like Microsoft Excel or Libre office Calc.

    While your cursor is present at cell B6, do the following

    On the formulas tab, in the function library group,

    click the financial button

    Then click PMT

    Enter B3/12 in the rate argument box.

    Enter b4 in the Nper argument box. Enter B2 in the argument box.

    Click ok.

    The following assumptions were made:

    the annual interest rate is stored in cell B3

    the number of payments in cell B4

    the loan amount in cell B2.
Know the Answer?
Not Sure About the Answer?
Find an answer to your question 👍 “Using cell references, enter a formula in cell b6 to calculate monthly payments for the loan described in this worksheet. omit the optional ...” in 📗 Computers & Technology if the answers seem to be not correct or there’s no answer. Try a smart search to find answers to similar questions.
Search for Other Answers