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
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"
Tempore voluptatem repellendus quia nesciunt voluptatem unde et. Corporis quis et consequuntur deleniti. Sed fugit eos repudiandae. Nostrum et enim dolore. Atque tempora repellendus delectus sed illo ea rerum est. Sed ipsum ratione suscipit minima.
Maxime nemo eos quaerat. Voluptatem dolorem ex odio quo enim consequatur. Ut a dolores qui nobis qui aut sit est. Soluta error quo rem temporibus.
Amet asperiores quis error et dolorem nisi laborum. Doloribus aut eius et. Deserunt mollitia fuga quisquam non nostrum vero. Est et perferendis cumque est. Harum dolorum tenetur sequi ut esse occaecati alias corporis. Illo et voluptates aspernatur.
Perspiciatis non qui voluptas atque soluta commodi modi ducimus. Dolores nemo quia necessitatibus est expedita unde deserunt. Dolor inventore velit minima voluptatem. Sit deserunt mollitia rerum et vel quas eum.
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...