Excel functions / Financial
RRI function
The steady growth rate per period that turns one amount into another (CAGR).
Syntax
=RRI(nper, pv, fv)
Arguments
nper: How many periods.pv: The starting amount.fv: The final amount.
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
Yearly growth from 1,000 to 1,500 in 5 years
A B C D E 1 Years Start End 2 5 1000 1500 8.45% In E2:
=RRI(A2, B2, C2)→ 8.45%Monthly growth over eight years
A B C D E 1 Months Start End 2 96 10000 11000 0.0993% In E2:
=RRI(A2, B2, C2)→ 0.0993%
Common mistakes
- Reading it as a total. RRI is a rate per period. 8.45% a year for five years is a 50% rise in total.
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.
- Czech: RRI
- Danish: RRI
- Dutch: RRI
- Finnish: TOT.ROI
- French: TAUX.INT.EQUIV
- German: ZSATZINVEST
- Hungarian: MR
- Italian: RIT.INVEST.EFFETT
- Norwegian: REALISERT.AVKASTNING
- Polish: RÓWNOW.STOPA.PROC
- Portuguese (Brazil): TAXAJURO
- Portuguese (Portugal): DEVOLVERTAXAJUROS
- Russian: ЭКВ.СТАВКА
- Spanish: RRI
- Swedish: AVKPÅINVEST
- Turkish: GERÇEKLEŞENYATIRIMGETİRİSİ