I 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
I’ve seen Gartner use RATE for CAGR, and I you could probably use XIRR as well.
Have fun!
Also, if you just want percent change:
=((last-first)/first)
Here’s an Excel spreadsheet that shows you how to use XIRR in Excel to calculate CAGR (the results are consistent with your formula in the blog post). XIRR is cool because you can use irregular periodic payments to calculate CAGR. It’s at http://investexcel.net/3300/how-to-calculate-compound-annual-growth-rate-in-excel/
LikeLike
This website is completely gret. I’ve search these details a great
deal and I view it that is professional, fast to understand.
I congratulate you for this article that I’ll tell to the people around.
I request you to visit the gpa-calculator.co page where each pupil or
university student can calculate ratings
grade point average rating. Thank you!
LikeLike
–
LikeLike