Hi,
Is there a formula in Excel that returns the Compounded Annual Growth Rate(CAGR)? For example, I have a column with Yearly $ amounts with 10 years of data. With a financial calculator, if I have the starting $ amount, the ending $ dollar amount and the number of years(or periods), I can calculate the CAGR. Can Excel do something similar with the data?
Thanks!
Is there a formula in Excel that returns the Compounded Annual Growth Rate(CAGR)? For example, I have a column with Yearly $ amounts with 10 years of data. With a financial calculator, if I have the starting $ amount, the ending $ dollar amount and the number of years(or periods), I can calculate the CAGR. Can Excel do something similar with the data?
Thanks!