RRI function

The RRI function returns the interest rate needed for an investment to reach a specific value within a given number of periods.

Parts of a RRI function

RRI(number_of_periods, present_value, future_value)

Part	Description
`number_of_periods`	Required. The number of periods.
`present_value`	Required. The present value of the investment
`future_value`	Required. The future value of the investment.

Notes

All values must be positive. Number_of_periods and present_value must be greater than 0.
If future_value is 0, the rate returned is -1 (-100%).

Examples

RRI	Formula
-0.1083343751	`=RRI(10.5, 10, 3)`
0.2599210499	`=RRI(3, 2, 4)`
-1	`=RRI(1, 10, 0)`

Related functions

PDURATION: The PDURATION function returns the number of periods for an investment to reach a specific value at a given rate.

Need more help?

Try these next steps:

Post to the help community Get answers from community members

Financial

Visit the Learning Center

Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and templates. Learn to work on Office files without installing Office, create dynamic project plans and team calendars, auto-organize your inbox, and more.

Clear search

Close search

Google apps

Main menu