For Pecoflyer: CAGR formula (XIRR) SHOWN in Workbook
I have a job at work I desperately need help with. I am calculating a Compound Annual Growth Rate for data in the Excel table attached (Copy of CAGR's)
Basically I have four years and revenue data for each year,
I have attempted to use the XIRR formula and keep getting a Number Error message in cell. I have looked at help for this function etc...
Please advise formula to use, I KNOW HOW TO MANUALLY CALCULATE with CAGR MATHEMATICAL EQUATION, but wish to learn how with a formula.
CAGR is a popular data figure, I would find it hard to believe Excel has no formula for such. Help!!! and Big Thanks!!!
Meggen
Last edited by meggenm; 04-14-2014 at 02:20 PM.
Reason: See new attachment with calculation of Cagr (XIRR) in table.
|