SheetFX
≡
<< Go back to all functions

RRI

The RRI function in Google Sheets is a financial tool that calculates the interest rate needed for an investment to reach a specific value within a given number of periods. Whether you're planning for retirement, analyzing investment opportunities, or forecasting future growth, the RRI function can help you make informed decisions.

Function Syntax and Parameters

Syntax: RRI(number_of_periods, present_value, future_value)

Parameters:

  • number_of_periods: The number of periods for the investment or loan.
  • present_value: The present value or initial investment amount.
  • future_value: The desired future value or target amount.

Step-by-Step Tutorial

  1. Calculating interest rate for a fixed investment:

    • Example: =RRI(4, 1000, 1500)
    • Result: This will return the interest rate (compounded per period) required for a $1000 investment to grow to $1500 over 4 periods.

  2. Determining interest rate for a loan payoff:

    • Example: =RRI(12, -10000, 0)
    • Result: This will calculate the interest rate needed to pay off a $10,000 loan over 12 periods.

Use Cases and Scenarios

  1. Financial Planning: Determine the interest rate required to meet a savings goal.
  2. Loan Analysis: Calculate the interest rate needed to pay off a loan within a specific timeframe.
  3. Investment Evaluation: Assess the potential returns on an investment based on a desired future value.

Related Functions

  • FV: Calculate the future value of an investment.
  • PV: Determine the present value of an investment.
  • NPER: Calculate the number of periods needed for an investment to reach a specific value.

Related Articles