1
$\begingroup$

Ok. I am trying to put together a 5-year revenue projection. I only have the following data:

  • Units Sold in Year 1: 20
  • Units Sold in Year 2: 80
  • Units Sold in Year 3: 200

Now I need to use this data to figure out:

  1. What monthly growth rate to use for each month from Year 1 to Year 5 to project monthly unit sales?
  2. Similarly, growth rate to use for each quarter?
  3. The 5-year compound annual growth rate?
  • 0
    The annual growth from year 1 to year 2 is 300%, which would correspond to approximately 9.6% monthly growth. The annual growth from year 2 to year 3 is 150%, which corresponds to approximately 3.4% monthly growth. That's a pretty big difference, so that trying to approximate with a single growth rate is likely going to produce some horrible errors.2011-05-16

1 Answers 1

1

As Arturo pointed out, using uniform growth here is probably not what was intended. Assuming that the growth rate halves every year seems more plausible. Also, the question 1 seems to indicate that you should find a different growth rate for each month (and hence quarter).

My intuitive answer would be the following:

Since the growth rate seems to halve every twelve months, use the formula for half-life:

$ g = g_{0} \left( \frac{1}{2} \right) ^{\frac{t}{12}}$

where $g$ is your growth rate, and $g_{0}$ is your starting value of growth (in this case, 600) and $t$ is the time in months..

You can compute the compound rates from there.

Then again, this is just a gist. The question seems quite vague and leaves many room for different assumptions.