# How to Use the IRR Function in Google Sheets

If you need to find the internal rate of return, there is an easy way to do this in Google Sheets using the IRR function.

In this tutorial, I will show you how to use the IRR function in Google Sheets.

## What is the Internal Rate of Return?

The internal rate of return is a performance metric used in finance to determine the expected annual growth of an investment.

Basically, the internal rate of return (IRR) is used to estimate the potential profitability of investments.

## Using the IRR Function in Google Sheets

The best way to calculate the IRR is to use a spreadsheet program like Google Sheets or Excel. Here we will cover how to use this function in Google Sheets, but know that it is a very similar process in Microsoft Excel.

In Google Sheets, we will be using the IRR function. This function calculates the internal rate of return on an investment when provided periodic cash flows.

The syntax of this function is:

=IRR(cashflow_amounts, [rate_guess])

• cashflow_amounts – this argument is an array or range that contains the income or payments of the investment. This must contain at least one negative and one positive amount
• rate_guess – this argument is optional and is set to .1 by default. It is the estimate for what the internal rate of return will be

To show you how to use the IRR function, I will use it to find the internal rate of return on this example data:

In this example, I have 5 years of cashflow_amounts that contain the net income of an investment over a 5 year period. Year zero contains the startup costs of that investment. To use the IRR function to calculate the internal rate of return, I will be setting up my formula like this:

=IRR(B2:B7)

Here is what this looks like in my example:

Here is a step-by-step instruction on how to use this function.

1. First, select the cell where you want to calculate IRR
2. Next, press the equals sign on your keyboard (=) and type IRR. Press tab when you are done
3. Enter the range of cells that contain your cashflow_amounts