Skip to main contentSkip to solution

PV function returns the present value of an investment. The syntax of the function is PV (rate, nper, pmt, fv, type). What does NPER stands for?

Solution

✅ Correct Option: 1

In the PV function syntax PV(rate, nper, pmt, fv, type), each parameter has a specific meaning:

NPER stands for Number of Payment Periods in an annuity.

It represents the total count of payment periods over which the investment or loan will be made. For example, if you have a 5-year loan with monthly payments, nper would be 60 (5 years × 12 months).

The other parameters in the function are:

  • rate: Interest rate per period (Option 2)
  • pmt: Payment amount made each period (Option 3)
  • fv: Future value of the investment
  • type: Timing of payments (beginning or end of period)

Option 4 (First period in the calculation) is incorrect as the function doesn't have a parameter to specify which period to start from; it automatically calculates from the first period.

Keyboard Shortcuts

  • Left arrow: Previous question
  • Right arrow: Next question
  • S key: Jump to solution
  • Q key: Jump to question