RRI

Get equivalent interest rate for growth

Syntax

EXCEL Copy

=RRI(nper, pv, fv)

Arguments

Parameter	Description
nper	Number of periods.
pv	Present value of investment.
fv	Future value of investment.

Return Value

Calculated interest rate

Details

The RRI function returns an equivalent interest rate for the growth of an investment. For example, to use RRI to calculate equivalent annual compound interest for a 1000 investment worth 1200 after five years you can use a formula like this: In the example shown, the formula in G6 is:

Examples

Example 1

The RRI function returns an equivalent interest rate for the growth of an investment. For example, to use RRI to calculate equivalent annual compound

EXCEL Copy

=RRI(5,1000,1200) // returns 0.037137289

Example 2

In the example shown, the formula in G6 is:

EXCEL Copy

=RRI(B11,C6,C11)

See Also

GEOMEAN