Which of the following calculates the quarterly payment on a loan of $6000 for 3 years at 9% interest? Payments should be expressed as a negative number.

Financial.Pmt (0.09/4, 3*12, 6000)
Financial.Pmt (0.09/4, 3*4, 6000)
Financial.Pmt(0.09/12, 3*12, 6000)
Financial.Pmt( 0.09/12, 3*4, 6000)

The correct answer is: C. Financial.Pmt(0.09/12, 3*12, 6000)

The Financial.Pmt function calculates the periodic payment for a loan based on the following parameters:

  • Rate: The interest rate per period.
  • Nper: The number of periods.
  • Pmt: The loan amount.
  • Fv: The future value of the loan.
  • Type: The type of payment (0 for end of period, 1 for beginning of period).

In this case, we are given the following information:

  • Rate: 9% per year, compounded quarterly. This means that the interest rate per quarter is 9/4 = 2.25%.
  • Nper: 3 years = 3*12 = 36 quarters.
  • Pmt: $6000.
  • Fv: $0 (we are assuming that the loan will be paid off in full).
  • Type: 0 (end of period payments).

Plugging these values into the Financial.Pmt function, we get:

Financial.Pmt(0.09/12, 3*12, 6000) = -$198.73

The negative sign indicates that this is a payment, not a receipt.

Exit mobile version