- Function InvestmentConstantNumberPeriods(PresentValue, FutureValue, Payment, InterestRate, Type)
InvestmentConstantNumberPeriods
The function InvestmentConstantNumberPeriods
returns the number of
periods for an investment based on periodic, constant payments and a
constant interest rate.
InvestmentConstantNumberPeriods(
PresentValue, ! (input) numerical expression
FutureValue, ! (input) numerical expression
Payment, ! (input) numerical expression
InterestRate, ! (input) numerical expression
Type ! (input) numerical expression
)
Arguments
- PresentValue
The total amount that a series of future payments is worth at this moment. PresentValue must be a real number.
- FutureValue
The cash balance you want to attain after the last payment is made. FutureValue must be a real number.
- Payment
The value of the periodic payment for the investment. Payment must be a real number. Payment and InterestRate cannot both be \(0\).
- InterestRate
The interest rate per period for the investment. InterestRate must be a numerical expression in the range \((-1, 1)\).
- Type
Indicates when payments are due. \(Type = 0\): Payments are due at the end of each period. \(Type = 1\): Payments are due at the beginning of each period.
Return Value
The function
InvestmentConstantNumberPeriods
returns the number of periods for an investment based on periodic, constant payments and a constant interest rate.
Note
The function InvestmentConstantNumberPeriods
is similar to the Excel
function NPER
.
See also
General equations for investments with constant, periodic payments.