Google Sheets RATE function

This post will guide you how to use Google Sheets RATE function with syntax and examples in google spreadsheet .


The Google Sheets RATE function returns the interest rate per payment period of an annuity.

The RATE function is a build-in function in Google Sheets and it is categorized as a Financial Function.


The syntax of the RATE function is as below:

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

Where the RATE function arguments are:

  • number_of_periods -This is a required argument. The total number of payments periods in an annuity.
  • payment_per_period – This is a required argument. The amount of the payment made each period.
  • present_value – This is a required argument. The present value of the payments.
  • future_value – This is an optional argument. The future value or a cash balance you want to attain after the last payment is made. If fv is omitted, it is assumed to be 0 (zero), that is, the future value of a loan is 0.
  • end_or_beginning – This is an optional argument. The number 0 (zero) or 1 and indicates when payments are due.
Set type equal to If payments are due
0 or omitted At the end of the period
1 At the beginning of the period
  • Guess – This is an optional argument. An initial guess at the internal rate of return. if it is omitted, and it will be set as 0.1 or 10%.


  • Make sure that you are consistent about the units you use for specifying rate and nper. If you make monthly payments on a four-year loan at an annual interest rate of 12 percent, use 12%/12 for rate and 4*12 for number_of_periods. If you make annual payments on the same loan, use 12 percent for rate and 4 for number_of_periods.

Google Sheets RATE Function Examples

The below examples will show you how to use Google Sheets RATE Function to calculate the interest rate per period of an annuity.

#1 to get the monthly rate of the loan, using the following formula:


google sheets rate function1

See Also: Calculate Interest Rate in Google Sheets

Related Posts

Excel/Google Sheets: Full Row Reference

Excel or Google sheets supports both full row references and full column references. This article will talk about the usage of full row references. Full Row reference is another cell reference in Excel or Google Sheets, which is used to ...

Excel/Google Sheets: Full Column Reference

Full column reference is another cell reference in Excel or Google Sheets, which is used to reference the entire column, for example, if you want to reference the entire column A, you can use the following reference format A: A. ...

Excel/Google Sheets: Expanding Reference

An expanding reference is a reference type in Excel and Google worksheets that extends the range of a cell when a formula is copied to the cell below or to the right. In this article, we will explain how to ...

Excel/Google Sheets: Mixed Reference

In Microsoft Excel Spreadsheet or Google sheets, there is another cell reference, mixed references, where part of the reference is absolute, part of the relative. This article will describe how to use mixed references through specific examples. Mixed Reference When ...

Excel/Google Sheets: Absolute Reference

In Microsoft Excel spreadsheet or Google Sheets, the cell reference is the cell or cell area address or name in the worksheet, the cell reference contains two types of references, namely, relative references and absolute references. Absolute Reference An absolute ...