Okay, I feel slightly retarded as I should know this BUT:
I have annual revenue numbers: let's assume 100 in 2007 and 105 in 2008. I want to calculate what the quarterly growth rate was in each quarter. I thought CAGR would do the trick, but then I realized I was wrong. Annual growth is obviously 5%, so
(1+0.05)^0.25-1=1.23% quarterly, right?
Now that's all great but I can only use 1.23% if I'm grossing up 100 by 1.23% four times to get to 105. But how do I get to the percentage growth on a quarterly basis? If I assume Q4 '07 revenue of 25 (one fourth of 100), how do I calculate the percentage growth for each quarter to get 2008 revenue of 2005? I know how to goal seek it but I need a formula as I need to run this calc many times over.
Thanks a bunch for any help!!!
...just to clarify, I am trying to get a constant quarterly growth rate that would get me to 105.
Thanks.
bump
why do it say youre a PE 3rd yr assoc
Dolorum sunt iure ullam aliquam et. Eligendi dolorum libero autem dicta tenetur quam. Rerum debitis sapiente saepe temporibus nemo excepturi.
Culpa vitae consequatur consequatur deserunt nulla non nemo recusandae. Quos cumque ex omnis. Iusto earum autem ipsam rerum officiis enim.
Sapiente dolor tenetur voluptatibus nam. Molestiae vero eos saepe sequi perspiciatis minus. Natus ut ex modi vitae quae sunt quaerat at. Est quasi dolor blanditiis. Aliquam consequuntur exercitationem qui et sit. Perspiciatis adipisci fugiat fuga aspernatur sequi voluptates.
Molestiae nostrum animi velit debitis adipisci est quibusdam. Eaque quae quaerat blanditiis dignissimos et et. Et earum modi ut vitae minus.
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...