Enter a formula in cell C9 using the PMT function to calculate the monthly payment on a loan using the assumptions listed in the

Question

3 years ago

13

Enter a formula in cell C9 using the PMT function to calculate the monthly payment on a loan using the assumptions listed in the

Status Quo scenario. In the PMT formula, use C6 as the monthly interest rate (rate), C8 as the total number of payments (nper), and C4 as the loan amount (pv). Enter this formula in cell C9, and then copy the formula to the range D9:F9.

Computers and Technology

1 answer:

Wewaii [24] · Answer 1 · 2022-10-10T11:37:51+03:00

Wewaii [24]3 years ago

8 0

Answer:

=PMT(C6,C8,C4)

Put that in cell c9

Then use the lower right of the cell to drag it from D9:F9