Correct Answer:
A. PMT
The correct Excel function for calculating loan payments is PMT. This function determines the periodic payment for a loan or an investment, assuming constant payments and a constant interest rate. It's widely used in financial modeling to understand the regular installments required to repay a debt, considering the principal, interest rate, and number of payment periods.
- FV (Future Value) calculates the value of an investment at the end of a period, not the payment itself.
- PV (Present Value) calculates the current value of a future stream of payments or a single future payment.
- RATE calculates the interest rate per period of an annuity, which is the inverse of what PMT does. Therefore, PMT is the specific and accurate choice for loan payment calculation.