RRI function

The RRI function in Excel calculates the equivalent interest rate for an investment based on the beginning value, the ending value, and the number of periods. This function is useful when you want to find the rate of return (interest rate) that would have resulted in the given growth over a specified time period.

Syntax

RRI(nper, pv, fv)

Parameters

1. nper: The total number of periods (e.g., years, months, etc.) for the investment.
2. pv: The present value, or the initial investment amount (entered as a negative number because it’s an outflow).
3. fv: The future value, or the desired value of the investment after the specified number of periods.

How It Works

The RRI function calculates the rate of return using the following formula:

$$RRI = \left( \frac{FV}{PV} \right)^{\frac{1}{nper}} – 1$$

Where:

• FV is the future value of the investment,
• PV is the present value (initial investment),
• nper is the number of periods.

The function uses this formula to compute the rate of return required to turn the initial value into the future value over the given number of periods.

Example

Let’s say you invested $5,000 (present value), and after 10 years, the investment grew to $8,000 (future value). To calculate the annual rate of return, you would use the RRI function as follows:

=RRI(10, -5000, 8000)

In this case:

• 10 represents the number of periods (years),
• -5000 represents the initial investment (entered as a negative value),
• 8000 represents the future value of the investment.

Important Notes

• The pv parameter is typically entered as a negative number because it represents an outflow of cash (your initial investment).
• The fv parameter is entered as a positive number because it represents the future value of the investment.
• The nper parameter should reflect the total number of periods over which the investment grows.

Summary

The RRI function is used to calculate the interest rate or rate of return needed to grow an investment from its present value to its future value over a specified number of periods. It is commonly used in investment analysis and financial planning to understand the rate of growth required to meet future goals.