Q:

# What is the formula in Excel for calculating CAGR?

A:

The formula for calculating compound annual growth rate (CAGR) in Excel is: = ((FV/PV)^(1/n)) – 1, where "FV" is the ending value, "PV" is the beginning value and "n" is the number of years. CAGR is a measurement of the return on an investment over a defined period of time.

## Keep Learning

CAGR can also be calculated in Excel using the XIRR function which uses the syntax: XIRR(values, dates, guess). The XIRR function allows for the inclusion of multiple values and dates rather than just the ending and beginning value, but must also include a guess at what the final estimate of CAGR will be.

Sources:

## Related Questions

• A: To subtract in Excel, enter the numbers in a cell using the formula =x-y, complete the same formula using the column and row headings of two different cell... Full Answer >
Filed Under:
• A: To enter a basic formula in Excel, enter an equal sign into the cell where you want to place the formula. This signals to Excel that the following input is... Full Answer >
Filed Under:
• A: Use the built-in formula calculations in Excel to help calculate totals. Creating a column of totals allows users to see real-time totals as information is... Full Answer >
Filed Under:
• A: Standard deviation is calculated in Excel by using the formula SDEV(ARRAY), where ARRAY represents the range of numbers for which the standard deviation is... Full Answer >
Filed Under:
PEOPLE SEARCH FOR