Summary

The Excel RRI function returns the equivalent growth rate needed to move from a present value to a future value over a fixed number of periods. Many teams use it as a clean CAGR-style rate for summary reporting.

RRI is useful when you do not need full cash-flow detail. If you only know start value, end value, and period count, RRI gives one normalized growth rate for quick comparison.

This makes RRI practical for portfolio snapshots, strategy review decks, and benchmark checks where a single comparable rate is easier to discuss than a full timeline.

Syntax

=RRI(nper, pv, fv)

Conceptually, RRI solves the missing rate in this compounding identity:

pv * (1 + rate)^nper = fv

If your period unit is years, the output is yearly. If your period unit is months, the output is monthly. The formula does not guess unit for you, so period definition must be explicit in the model.

RRI is not a full cash-flow function. It summarizes growth between two endpoints, so use it when endpoint-based interpretation is appropriate.

Arguments

• nper - Total number of periods.
• pv - Starting value (present value).
• fv - Ending value (future value).

Checks before final interpretation:

• Use clear and consistent period unit (yearly, monthly, etc.).
• Use matching value scale for pv and fv.
• Avoid invalid zero/negative structures that break growth interpretation.
• Validate result by plugging rate back into the compounding equation.

RRI vs Other Functions

RRI is compact, but other functions are better when your model needs richer structure.

Simple rule: use RRI for endpoint summary, IRR for full periodic cash flows, and RATE for payment-based structures.

Using the RRI Function

A practical workflow:

• Define period unit before calculations.
• Enter pv and fv with the same unit scale.
• Run RRI and format output as percentage.
• Compare result with benchmark or policy hurdle.

RRI is especially useful in executive reporting because it normalizes growth into one number. It also helps compare opportunities with different durations once period unit is standardized.

For reliability, test one sensitivity case (for example, higher fv or longer nper) and confirm direction behaves as expected.

Example 1 - 5-Year CAGR Audit

Compute annual equivalent growth from 100 to 150 over 5 years.

=RRI(5,100,150)

Example 2 - Doubling Growth (10yr)

Compute annual rate needed to double value in 10 years.

=RRI(10,100,200)

Example 3 - Performance Benchmark

Convert rate output into a direct benchmark test.

=RRI(5,100,150)>0.07

Example 4 - Yield Spread Calculation

Measure spread versus fixed benchmark rate.

=RRI(5,100,150)-0.05

Conclusion Recap

• Summary: RRI gives one equivalent growth rate from pv to fv across n periods.
• Syntax: =RRI(nper,pv,fv) with explicit period meaning.
• Best use: Endpoint-based CAGR-style comparison and reporting.
• Comparison: Use IRR or RATE when your model includes richer cash-flow/payment structure.
• Best practice: Validate assumptions and benchmark interpretation before final decisions.