Excel functions / Financial

RRI function

The steady growth rate per period that turns one amount into another (CAGR).

Syntax

=RRI(nper, pv, fv)

Arguments

When to use it

RRI gives the steady rate per period that turns a starting value into an ending value over a number of periods: the compound annual growth rate (CAGR) of an investment, a business or a population.

Examples

  1. Yearly growth from 1,000 to 1,500 in 5 years

    ABCDE
    1YearsStartEnd
    25100015008.45%

    In E2: =RRI(A2, B2, C2) → 8.45%

    Try this example

  2. Monthly growth over eight years

    ABCDE
    1MonthsStartEnd
    29610000110000.0993%

    In E2: =RRI(A2, B2, C2) → 0.0993%

    Try this example

Common mistakes

Common questions

How do I calculate CAGR in Excel?

Use =RRI(years, start value, end value), or the equivalent formula =(end/start)^(1/years)-1. Both give the steady yearly rate that turns the start value into the end value.

RRI in other languages

Excel shows function names in its own language. In these languages it also puts a semicolon between arguments where English has a comma.

Translate a whole formula

Try RRI in the playground

Related functions