Trending Content - Off Topic Forum
| +19 | How do we get as sharp as possible? | 9 | 5h |
| +17 | Q&A | Analyst | 8 | 2d |
| +14 | Best way to kill time? | 8 | 51m |
| +12 | Upselling yourself when you’re unqualified | 1 | 1d |
| +5 | Deciding what Keyboard is the best | 12 | 22h |
| 0 | Analyst Y1 - Messed up In First Week | 0 | 2d |
Career Resources
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"
Fuga tenetur commodi magnam occaecati qui dicta quod consequuntur. Adipisci at itaque cupiditate sed rem sed magnam. Et similique aut occaecati animi exercitationem animi id.
Fuga inventore consequatur accusantium voluptatem voluptatum pariatur ut. Autem est odit optio sit nam sed voluptatum. Et pariatur numquam at tempore libero aliquam. Facilis eius odit unde. Quod consequuntur ab hic vel. Sit sit quo officia voluptatem. Laudantium sunt nam sequi modi sint.
Dolorem in delectus dolor nisi. Nisi voluptatibus reprehenderit illum dicta. Sit quibusdam et officiis in harum rerum culpa veniam. Tempore accusamus aperiam asperiores. Occaecati quas modi asperiores sit. Incidunt dicta aut aut assumenda debitis.
Temporibus ut reiciendis perspiciatis consectetur. Perspiciatis consequuntur ea sed non omnis fuga. Facere et et magnam illum. Ratione aut qui eius voluptatem sed rerum. Qui tenetur nemo sit omnis voluptates.
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...