Financial Toolbox | ![]() ![]() |
Periodic interest rate of annuity
Syntax
Arguments
Description
Rate = annurate(NumPeriods, Payment, PresentValue, FutureValue,
Due)
returns the periodic interest rate paid on a loan or annuity.
Examples
Find the periodic interest rate of a four-year, $5000 loan with a $130 monthly payment made at the end of each month.
(Rate
multiplied by 12 gives an annual interest rate of 11.32% on the loan.)
See Also
amortize
, annuterm
, bndyield
, irr
![]() | amortize | annuterm | ![]() |