Trending Content - Off Topic Forum
Career Resources
WSO Free Modeling Series - Now Open Through
June 30, 2026
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
High Finance Applications
Guaranteed
Get at least one offer GUARANTEED
- 1:1 support
- 92% success rate
- 2,000+ mentor network
- Unlimited Live bootcamps
- AI for resume + LinkedIn
- Networking automation tools
- HireVue simulation tool
- Full course library
- Private Slack community
- 20hrs of mocks
- + much more...
there is a negative. Shift the year forwards or back until there isn't a negative and then footnote it in the book.
so are you saying its impossible to compute a CAGR if the beginning value must be negative. Lets throw in some variables say beginning is -5000 and ending is 200 over the course of 3 years...how would I compute it, assuming I must use those numbers?
A CAGR for annualized growth from a negative to a positive number can be calculated if the number of time periods is odd but doesn't make sense.
Take your example:
The growth rate would have to solve the equation
-5000*(1+g)^3=200
This can be solved to yield g=-1.344, implying annual growth of -134.4% - however, this doesn't make sense:
After a year, you would have "grown" from -5000 to 1720, then back to -585 and back to 200, but this is not what you would expect from a CAGR.
Note also that the calculation no longer works if the number of years is even, so you'd be best of following LdnMezz's suggestion and just shifting until you get a proper result.
So, my five math geek minutes of the day are over, back to work on those comps... :)
true, it does work mathematically with that formula, but does an increase from -5000 to 200 really make sense as a negative 134.4% growth??
yeah, my point was that although you can calculate it mathematically, it doesn't really make sense, so you're best of either not showing it at all or finding a work-around so you get to use all positive numbers - just check with your associate what he wants to see
"NM"
Ad adipisci amet facilis deserunt delectus. Consequatur pariatur et ea et. Est adipisci officia et blanditiis laboriosam. Neque maiores consequatur eligendi.
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...