Growth Rate Calculator

Document Sample

```					                                                                                                                                  Growth Rate Calculator

Instructions

1. Enter Product Names and Revenue Goals for 2014

Product 1         \$2,000,000

Product 2         \$3,500,000

Product 3        \$12,000,000

Product 4        \$10,000,000

2. In the "Growth Rate Analysis" tab, enter your histoical "Total Annual Sales" in the grey boxes for each product (2006-2011).

3. The Growth Rate Analysis will automatically calculate the One Year Growth rate and the Compound Annual Growth Rate (3 Year Trailing) required to meet your
objectives.

*The Compound Annual Growth Rate (CAGR) is the average growth rate over a period of years.

4. Use the "Results" tab to identify trends and to formulate a plan to reach your revenue goals.
Growth Rate Calculator
*Enter historical sales figures in the grey boxes for each year below (2006 - 2011).

Product 1                           2006           2007              2008           2009            2010           2011           2012           2013          2014
Total Annual Sales                                \$725,000       \$750,000       \$795,000          \$800,000       \$900,000       \$1,000,000     \$1,259,921     \$1,587,401    \$2,000,000

1 Year Growth Rate (%)                                             3.4%               6.0%           0.6%          12.5%          11.1%          26.0%          26.0%

3 Year Trailing Compound Annual Growth Rate (CAGR) %                                                 3.3%           6.3%           7.9%          16.3%          20.8%         26.0%

Product 2                            2006           2007              2008           2009            2010           2011           2012           2013          2014
Total Annual Sales                               \$2,000,000     \$2,500,000     \$3,000,000         \$2,500,000     \$3,100,000     \$3,200,000     \$3,297,028     \$3,396,999    \$3,500,000

1 Year Growth Rate (%)                                            25.0%              20.0%         -16.7%          24.0%           3.2%           3.0%           3.0%

3 Year Trailing Compound Annual Growth Rate (CAGR) %                                                 7.7%           7.4%           2.2%           9.7%           3.1%          3.0%

Product 3                            2006           2007              2008           2009            2010           2011           2012           2013          2014
Total Annual Sales                               \$4,000,000     \$5,000,000     \$6,000,000         \$7,000,000     \$8,000,000     \$8,000,000     \$9,157,714     \$10,482,966   \$12,000,000

1 Year Growth Rate (%)                                            25.0%              20.0%          16.7%          14.3%           0.0%          14.5%          14.5%

3 Year Trailing Compound Annual Growth Rate (CAGR) %                                                20.5%          17.0%          10.1%           9.4%           9.4%         14.5%

Product 4                            2006           2007              2008           2009            2010           2011           2012           2013          2014
Total Annual Sales                               \$3,000,000     \$4,000,000     \$5,000,000         \$6,000,000     \$7,000,000     \$8,000,000     \$8,617,739     \$9,283,178    \$10,000,000

1 Year Growth Rate (%)                                            33.3%              25.0%          20.0%          16.7%          14.3%           7.7%           7.7%

3 Year Trailing Compound Annual Growth Rate (CAGR) %                                                26.0%          20.5%          17.0%          12.8%           9.9%          7.7%

2005           2006               2007           2008           2009           2010           2011
Product 1                                             \$795,000       \$800,000          \$900,000       \$1,000,000     \$1,259,921     \$1,587,401     \$2,000,000
Product 2                                            \$3,000,000     \$2,500,000         \$3,100,000     \$3,200,000     \$3,297,028     \$3,396,999     \$3,500,000
Product 3                                            \$6,000,000     \$7,000,000         \$8,000,000     \$8,000,000     \$9,157,714    \$10,482,966    \$12,000,000
Product 4                                            \$5,000,000     \$6,000,000         \$7,000,000     \$8,000,000     \$8,617,739     \$9,283,178    \$10,000,000
Annuela Sales by Product                               3 Year Trailing Compound Annual Growth
Product 1    Product 2      Product 3   Product 4
Rate/Product
Product 1   Product 2   Product 3   Product 4

\$14,000,000                                                            30%

\$12,000,000
25%
\$10,000,000
20%
\$8,000,000
15%
\$6,000,000

\$4,000,000                                                            10%

\$2,000,000
5%
\$0
2005    2006    2007       2008    2009   2010    2011   0%
1
Product 3   15%
\$6,000,000
Product 4

\$4,000,000                                                                              10%

\$2,000,000
5%

\$0
2003   2004   2005   2006   2007   2008   2009   2010   2011               0%

Product 1       1
Product 2   Product 3   Product 4

```
DOCUMENT INFO
Shared By:
Categories:
Stats:
 views: 2729 posted: 9/22/2009 language: English pages: 3
Description: Use this tool to determine your required annual growth rate to meet your desired revenue goal in 3 years. Develop a plan based on the growth rate required to meet your objectives.
This document is also part of a package Strategic Planning 23 Documents Included