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.
NPER('Rate', 'Pmt', 'Pv' [, 'Fv' [, "Type"]])
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
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
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.
In case the costs or payments are entered as a positive number within your model, this function needs to be multiplied by (-1).
(Payment per Period - Amount)
Payment at Beginning of Period (Annuity Due) = 1
Payment at End of Period (Ordinary Annuity) = 0
NPER(Rate, Pmt, Pv, Fv, Type)
You may contact the Valsight Customer Support via: