RRI
Returns an equivalent interest rate for the growth of an investment.
FinancialFinance & Accounting
What it does
Calculates CAGR (Compound Annual Growth Rate).
Syntax
RRI(nper, pv, fv)
Arguments
nper(number) — Periods.pv(number) — Start value.fv(number) — End value.
Examples
Calculate CAGR
Growth from 100 to 200 in 5 years.
FORMULA
=RRI(5, 100, 200)
RESULT
0.1487
SAMPLE DATA
| A | B | C | |
|---|---|---|---|
| 1 | Years | Start | End |
| 2 | 5 | 100 | 200 |