contestada

Stella is a bank executive. She is preparing a spreadsheet on the loan repayment schedules of customers. Which function can she use to calculate the periodic payments?

A. What-If analysis

B. PMT

C. Regression Analysis

D. Min

Respuesta :

Diatonic254

The answer is B: PMT

Stella will use the PMT function to calculate the payment for a loan that has constant interest rate and payments. This function is a financial function that can be used to calculate the monthly payment due on a personal loan. The syntax for PMT is =PMT (rate, nper, pv, [fv], [type])


Otras preguntas