Guesstimating CAGR
I am looking for guesstimating CAGR across long time horizons. eg An investment grew 16X in 25 years, what's the CAGR?
I am looking for ball park figures here.
Trending Content
Career Resources
WSO Free Modeling Series - Now Open Through
April 30, 2024
9 Free Financial Modeling Lessons
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
+Bonus: Get 27 financial modeling templates in swipe file
+Bonus: Get 27 financial modeling templates in swipe file
So for an investment to grow 16x in 25 years, that means that it has doubled four times (2^4 = 16). In 25 years, doubling 4 times means it doubles once every 6.25 years. Using the rule of 72, 72 / 6.25 = ~11.5%, so the CAGR would be ~11.5%. Using quick excel math 16^(1/25)-1 = 11.7% which is pretty close.
Impressed with the math. And amazing to think about how a realistic return like that can get so big in a relatively short span.
That in the words of Buffett, is the power of compounding.
great trick, thanks a ton mate
Download python and put this formula in a module.
def CAGR(endingvalue, beginningvalue, numberofyears): '''Ending value is divided by beginning value. That number is raised to the (1/#of years). 1 is subtracted from tis number. ''' return (endingvalue/beginningvalue)**(1/numberofyears)-1
This was the answer I got after I made this. CAGR(16,1,25) 0.11728713807222002
Edit: Only if you need to do this more than once of course. If you do need to do this more, than once and have other formulas to do. I'd love to help with that as I'm trying to learn python, which is why I made this for ya, and it is way more fun with financial formulas.
Aut voluptas sunt distinctio optio. Voluptatum id qui similique consequatur sequi nihil. Distinctio excepturi ratione expedita alias molestiae saepe animi. Ab at atque possimus possimus tenetur aperiam. Accusamus voluptates rerum quia aut voluptatibus natus.
Blanditiis possimus occaecati accusamus est minima tenetur a. Eveniet ea iusto voluptatem iste fugit ut. Dignissimos maiores maiores at animi officia aperiam molestiae. Excepturi nisi et saepe sed atque dolor. Recusandae dolor rerum dicta voluptatem libero magnam cupiditate. Consectetur atque possimus odit totam.
Impedit id perspiciatis ipsa et praesentium et et. Asperiores at non suscipit sint aspernatur adipisci ipsam.
Eius doloremque autem quia ut aperiam. Quis quae neque beatae perferendis voluptate labore facere voluptate. Quasi hic pariatur totam ut dicta.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...