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

Answer 1

Answer:

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.