NPER

Description

Calculates the number of periods necessary for a recurring investment based on an interest rate, the amount of payment per period, a present value, a future value and either ordinary annuity or annuity due (type) indicating whether payments are due at the beginning or the end of period.

Signature

NPER('Rate', 'Pmt', 'Pv' [, 'Fv' [, "Type"]])

Parameters

• Rate -> The interest rate

• Pmt -> Payment (in each period): the amount of each payment made (Payments/costs should (but are not required to) be entered as a negative number e.g. -100)

• Pv -> Present value:  the current value of the annuity

• Fv  -> [Optional] - Future value: the future value remaining after the final payment has been made.  If not entered, 'Fv' is set to 0.

• Type -> [Optional] type (1=pmt at beginning of period (Annuity Due), 0=pmt at end of period (Ordinary Annuity)). By default 'Type' is set to 0

Notes

• Argument 'Pv' is the leading input node.

  • A leading input node is a function argument, for which we assume the levels to be correct. All other input nodes need to have the same dimensionality.

• Each input node can be single number

• Providing all inputs with the same dimensionality results in a noticeable performance improvement

Limitations

• All other inputs can not contain levels that are not in the leading input node 'Pv' . 

• All level values that are in the leading input node 'Pv' , must be in all the other input nodes.

Rate

(Interest Rate)

0.045/12

Pmt

(Payment per Period - Amount)

-100

Pv

(Present Value)

5000

Fv

(Future Value)

0

Type

Payment at Beginning of Period (Annuity Due) = 1

Payment at End of Period (Ordinary Annuity) = 0

0

Valsight Formula 

NPER(Rate, Pmt, Pv, Fv, Type)

Result

55.47