Question

The PMT function in MS Excel is used to:

• A. Calculate the total interest on a loan.
• B. Calculate the periodic payment for a loan or investment.
• C. Calculate the future value of an investment.
• D. Calculate the present value of a series of payments.

Hint:

Common Financial Functions in Excel:

• PMT \(\Rightarrow\) Periodic payment amount
• PV \(\Rightarrow\) Present value
• FV \(\Rightarrow\) Future value
• RATE \(\Rightarrow\) Interest rate per period
• NPER \(\Rightarrow\) Number of periods
• IPMT \(\Rightarrow\) Interest portion of a payment
• PPMT \(\Rightarrow\) Principal portion of a payment

Remember: PMT = Payment!

Answer 1

The Correct Option is B

We need to identify the correct purpose of the PMT function in MS Excel.
Step 1: Understand the PMT function.
The PMT function in Excel calculates the payment for a loan based on constant payments and a constant interest rate. It returns the periodic payment amount (principal + interest) for an investment or loan.
Step 2: Syntax of PMT function.
\[ \text{PMT(rate, nper, pv, [fv], [type])} \] Where:

• rate: Interest rate per period
• nper: Total number of payment periods
• pv: Present value (principal amount)
• fv: Future value (optional, default 0)
• type: When payments are due (0 = end of period, 1 = beginning)

Step 3: Analyze each option.

• (A) Calculate the total interest on a loan:
  • Total interest is calculated using other methods or functions like CUMIPMT, not PMT.
  • PMT gives the periodic payment amount, which includes both principal and interest.
• (B) Calculate the periodic payment for a loan or investment:
  • ✓ Correct. PMT returns the fixed periodic payment amount.
• (C) Calculate the future value of an investment:
  • Future value is calculated using the FV function, not PMT.
• (D) Calculate the present value of a series of payments:
  • Present value is calculated using the PV function, not PMT.

Final Answer: (B) Calculate the periodic payment for a loan or investment.