Financial Toolbox    
effrr

Effective rate of return

Syntax

Arguments

Rate
Annual percentage rate. Enter as a decimal fraction.
NumPeriods
Number of compounding periods per year, an integer.

Description

Return = effrr(Rate, NumPeriods) calculates the annual effective rate of return. Compounding continuously returns Return equivalent to (e^Rate-1).

Examples

Find the effective annual rate of return based on an annual percentage rate of 9% compounded monthly.

returns

See Also

nomrr


  discrate eomdate