CAGR
A end up calculating CAGR a lot in Excel. Exciting for me.
Here’s the macro-template for idiots I’ve finally found success with:
(last/first)^(1/(LastYear-FirstYear))-1
Have fun!
(Source: http://bit.ly/xVhTmM)
A end up calculating CAGR a lot in Excel. Exciting for me.
Here’s the macro-template for idiots I’ve finally found success with:
(last/first)^(1/(LastYear-FirstYear))-1
Have fun!