Documentation |
Periodic interest rate of annuity
Rate = annurate(NumPeriods, Payment, PresentValue, FutureValue,
Due)
NumPeriods | Number of payment periods. |
Payment | Payment per period. |
PresentValue | Present value of the loan or annuity. |
FutureValue | (Optional) Future value of the loan or annuity. Default = 0. |
Due | (Optional) When payments are due: 0 = end of period (default), or 1 = beginning of period. |
Rate = annurate(NumPeriods, Payment, PresentValue, FutureValue, Due) returns the periodic interest rate paid on a loan or annuity.