To keep track of an investment such as a mutual fund, you likely want to calculate the CAGR (compound annual growth rate). You can do so in Microsoft Excel using the RRI function and it’s much easier than you might think.

Let’s walk through setting up your data and using the RRI function to calculate the CAGR in Excel.

## Organize the Investment Details

All you need to calculate the CAGR are the periods and the values for each period. List the years in the first column and amounts in the second as shown below.

## Enter the Formula for the RRI Function

Next, select the cell where you want to calculate the CAGR. This is where you’ll enter the formula for the RRI function.

The syntax for the function is `RRI(periods, present value, future value)` where all three arguments are required.

Using our data above, we would use this formula to find the CAGR with the RRI function:

`=RRI(A7,B2,B7)`

A7 contains the number of periods in the investment, B2 contains the present value, and B7 contains the future value.

To format the result as a percentage, go to the Home tab and either click the Percent Style button or choose “Percentage” in the Number Style drop-down box.

As an alternative, you can insert the actual values in the formula instead of the cell references:

`=RRI(5,50,400)`

## Calculating CAGR With a Forumla

While the RRI function does an excellent job of calculating the CAGR of an investment, you can always do the math by hand or enter that formula into Excel to double-check the RRI formula result.

RELATED: Defining and Creating a Formula

To calculate CAGR, you first divide the future value by the present value. Then, raise the result to an exponent of one divided by the number of periods (years). Finally, subtract one from the result.

Here is the formula for CAGR using our above example and cell references in Excel:

`=(B7/B2)^(1/A7)-1`

As you can see in the screenshot below, this formula confirms the result of the RRI function’s formula.

Microsoft Excel is a solid application for keeping track of investments and household finances. So if you’re interested in additional ways it can help you, take a look at these budget functions you can use in Excel.

Sandy Writtenhouse
With her B.S. in Information Technology, Sandy worked for many years in the IT industry as a Project Manager, Department Manager, and PMO Lead. She learned how technology can enrich both professional and personal lives by using the right tools. And, she has shared those suggestions and how-tos on many websites over time. With thousands of articles under her belt, Sandy strives to help others use technology to their advantage.