ExcelFlux

RRI function

an equivalent interest rate for the growth of an investment.

Financial · Excel 2013+

Where can you use it?

Budgeting, treasury and finance teams. When reviewing a scenario with cash flows, payment periods and rate assumptions, compare the input and output units in the example.

Scenario in the workbook

Find the equivalent compound growth rate per period.

A worked example from the workbook

RowABC
6PeriodsStartEnd
72100121
81100110
94100100
Record 1
=RRI(A7,B7,C7)

Expected result0.1

See the inputs and instructions for all 3 examples

Copyable formulas

English Excel · en-US
=RRI(2,100,121)
Turkish Excel · tr-TR
=GERÇEKLEŞENYATIRIMGETİRİSİ(2;100;121)

Expected result

0.1

Worked examples

Find the equivalent compound growth rate per period.

Open the English sheet. Inputs begin at A6. F7:F9 show the live results and G7:G9 show the original results for comparison.

Row A B C
6 Periods Start End
7 2 100 121
8 1 100 110
9 4 100 100
Case Formula Expected result
Record 1 =RRI(A7,B7,C7) 0.1
Record 2 =RRI(A8,B8,C8) 0.1
Record 3 =RRI(A9,B9,C9) 0
Microsoft Excel reference