contestada

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.

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 class=

Respuesta :

sweetesthome45

Answer:

=PMT(C6,C8,C4)

Put that in cell c9

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

lhmarianateixeira

In this exercise we have to use excel knowledge, so we have to:

=PMT(C6,C8,C4) in the cell C9 and extended to D9:F9

How is PMT calculated in Excel?

PMT, one of the financial functions, calculates the payment for a loan based on constant payments and a constant interest rate. Use the Excel Formula Coach to figure out a monthly loan payment.

For this we need to put the form as:

=PMT(C6,C8,C4)

See more about excel at brainly.com/question/12788694

Otras preguntas