Description

EffPrdRateλ() calculates the Effective Period Rate — the interest rate for a single compounding period that, when compounded over all periods in a year, produces the stated annual percentage rate (APR)y. EffPrdRateλ uses this formula:

(1 + AnnualRate) ^ (1 / PeriodsPerYear) -1

This is the inverse of the Effective Annual Rate formula and ensures that compounding math works correctly.

EffPrdRateλ() is an essential financial modeling utility that ensures accurate compounding calculations. It's critical for anyone building models where periodic rates must compound to a known annual rate — which is virtually every loan, investment, or time-value-of-money calculation

Example

Below we are borrowing 10,000 at an APR of 8%. We want to know what the equivalent compounding period rate is. A beginner mistake would be to simply divide the annual rate by the number of compounding periods. In the animation we see that approach, when compounded, produces incorrect results when the compounding period is less than a year.