NPer
NPer( rate,pmt,pv, fv,type )
Returns the number of periods of an annuity with constant periodic payments and a fixed interest rate.
Parameters:
Rate: Interest rate per period.
Pmt: Payment received per period. If you make payments, this is a
negative number. If you receive payments, it is a positive number.
Pv: Present value of the annuity. If you receive a loan, this is
the loan amount as a positive number. If you give a loan, this
is the loan amount as a negative number.
Fv: (Optional) Future value of the annuity at the end of the annuity.
If you receive a loan, this is the final balloon payment as a
negative number. If the receive a final payment at the end, this
is a positive number.
Type: (Optional) Indicates whether payments are at the beginning of the
period.
True = Payments due at beginning of period, with first payment
due immediately.
False = Payments due at end of period. (default)
Comments
Enable comment auto-refresher