# Revenue Projection with Excel Model

VIEWS: 32,914 PAGES: 2

• pg 1
```									REVENUE FORECASTING
Revenue Forecasting For                                        Sales Growth projection                Percentage                \$ AMOUNT
2011                                                                                           2012          5%                 \$ 44,100.00
2013          5%                 \$ 46,305.00
Product A (Specify) Selling Price   \$    10.00                                                 2014          5%                 \$ 48,620.25
2015          5%                 \$ 51,051.26
Product B (Specify) Selling Price   \$     8.00                                                 2016          5%                 \$ 53,603.83

Product C (Specify) Selling Price   \$     3.00

TOTAL REVENUE FOR THE YEAR          \$ 42,000.00

Jan-11       Feb-11       Mar-11       Apr-11       May-11       Jun-11       Jul-11       Aug-11        Sep-11

Unit sold for product A                     100          100          100          100          100          100          100           100          100

Total Revenue For Product A         \$ 1,000.00    \$ 1,000.00   \$ 1,000.00   \$ 1,000.00   \$ 1,000.00   \$ 1,000.00   \$ 1,000.00   \$ 1,000.00    \$ 1,000.00

Unit Sold for Product B                     200          200          200          200          200          200          200           200          200

Total Revenue For Product B         \$ 1,600.00    \$ 1,600.00   \$ 1,600.00   \$ 1,600.00   \$ 1,600.00   \$ 1,600.00   \$ 1,600.00   \$ 1,600.00    \$ 1,600.00

Unit Sold For Product C                     300          300          300          300          300          300          300           300          300

Total Revenue For Product C         \$   900.00    \$   900.00   \$   900.00   \$   900.00   \$   900.00   \$   900.00   \$   900.00   \$   900.00    \$   900.00

TOTAL REVENUES                      \$ 3,500.00    \$ 3,500.00   \$ 3,500.00   \$ 3,500.00   \$ 3,500.00   \$ 3,500.00   \$ 3,500.00   \$ 3,500.00    \$ 3,500.00
Annual
Oct-11       Nov-11       Dec-11     Totals             2012          2013         2014          2015           2016

100          100          100          1200          1260          1323      1389.15     1458.6075 1531.53788

\$ 1,000.00   \$ 1,000.00   \$ 1,000.00   \$ 12,000.00   \$ 12,600.00   \$ 13,230.00   \$ 13,891.50   \$ 14,586.08   \$ 15,315.38

200          200          200          2400          2520          2646        2778.3     2917.215 3063.07575

\$ 1,600.00   \$ 1,600.00   \$ 1,600.00   \$ 19,200.00   \$ 20,160.00   \$ 21,168.00   \$ 22,226.40   \$ 23,337.72   \$ 24,504.61

300          300          300          3600          3780          3969      4167.45     4375.8225 4594.61363

\$   900.00   \$   900.00   \$   900.00   \$ 10,800.00   \$ 11,340.00   \$ 11,907.00   \$ 12,502.35   \$ 13,127.47   \$ 13,783.84

\$ 3,500.00   \$ 3,500.00   \$ 3,500.00   \$ 42,000.00   \$ 44,100.00   \$ 46,305.00   \$ 48,620.25   \$ 51,051.26   \$ 53,603.83
\$     3.00

TOTAL REVENUE FOR THE YEAR          \$ 42,000.00

Jan-09       Feb-09       Mar-09       Apr-09       May-09

Unit sold for product A                     100          100          100          100          100

Total Revenue For Product A         \$ 1,000.00    \$ 1,000.00   \$ 1,000.00   \$ 1,000.00   \$ 1,000.00

Unit Sold for Product B                     200          200          200          200          200

Total Revenue For Product B         \$ 1,600.00    \$ 1,600.00   \$ 1,600.00   \$ 1,600.00   \$ 1,600.00

Unit Sold For Product C                     300          300          300          300          300

Total Revenue For Product C         \$   900.00    \$   900.00   \$   900.00   \$   900.00   \$   900.00

TOTAL REVENUES                      \$ 3,500.00    \$ 3,500.00   \$ 3,500.00   \$ 3,500.00   \$ 3,500.00
CASTING
Percentage                \$ AMOUNT
5%                 \$ 44,100.00
5%                 \$ 46,305.00
5%                 \$ 48,620.25
5%                 \$ 51,051.26
5%                 \$ 53,603.83

Annual
Jun-09       Jul-09       Aug-09        Sep-09       Oct-09       Nov-09       Dec-09     Totals

100          100           100          100          100          100          100          1200

\$ 1,000.00   \$ 1,000.00   \$ 1,000.00    \$ 1,000.00   \$ 1,000.00   \$ 1,000.00   \$ 1,000.00   \$ 12,000.00

200          200           200          200          200          200          200          2400

\$ 1,600.00   \$ 1,600.00   \$ 1,600.00    \$ 1,600.00   \$ 1,600.00   \$ 1,600.00   \$ 1,600.00   \$ 19,200.00

300          300           300          300          300          300          300          3600

\$   900.00   \$   900.00   \$   900.00    \$   900.00   \$   900.00   \$   900.00   \$   900.00   \$ 10,800.00

\$ 3,500.00   \$ 3,500.00   \$ 3,500.00    \$ 3,500.00   \$ 3,500.00   \$ 3,500.00   \$ 3,500.00   \$ 42,000.00
2010          2011         2012          2013           2014

1260          1323      1389.15     1458.6075 1531.53788

\$ 12,600.00   \$ 13,230.00   \$ 13,891.50   \$ 14,586.08   \$ 15,315.38

2520          2646        2778.3     2917.215 3063.07575

\$ 20,160.00   \$ 21,168.00   \$ 22,226.40   \$ 23,337.72   \$ 24,504.61

3780          3969      4167.45     4375.8225 4594.61363

\$ 11,340.00   \$ 11,907.00   \$ 12,502.35   \$ 13,127.47   \$ 13,783.84

\$ 44,100.00   \$ 46,305.00   \$ 48,620.25   \$ 51,051.26   \$ 53,603.83
```
To top