SheetFX
≡
<< Go back to all functions

RATE

The RATE function in Google Sheets is a powerful tool to calculate the interest rate of an annuity investment based on constant-amount periodic payments and the assumption of a constant interest rate. Whether you're planning for long-term investments, mortgage loans, or retirement savings, the RATE function simplifies the calculation. Dive into our comprehensive guide to master its application.

Function Syntax and Parameters

Syntax: RATE(number_of_periods, payment_per_period, present_value, [future_value], [end_or_beginning], [rate_guess])

Parameters:

  • number_of_periods: The total number of payment periods.
  • payment_per_period: The payment amount made per period.
  • present_value: The present value of the investment.
  • future_value [Optional]: The future value you want to attain after the last payment is made. If omitted, it is assumed to be 0.
  • end_or_beginning [Optional]: [Default is 0] Specifies whether the payments are due at the end of a period (0) or at the beginning of a period (1).
  • rate_guess [Optional]: [Default is 0.1] The guess for the interest rate.

Step-by-Step Tutorial

  1. Calculating interest rate with default parameters:

    • Example: =RATE(10, -100, 1000)
    • Result: 0.063841

  2. Calculating interest rate with all parameters:

    • Example: =RATE(5, -100, 1000, 0, 0.1)
    • Result: 0.138185

Use Cases and Scenarios

  1. Investment Planning: Determine the interest rate needed to achieve a specific investment goal.
  2. Loan Amortization: Calculate the interest rate for mortgage loans.
  3. Retirement Savings: Determine the interest rate required to accumulate a desired retirement fund.

Related Functions

  • PV: Calculate the present value of an investment.
  • FV: Calculate the future value of an investment.

Related Articles