Docstoc
EXCLUSIVE OFFER FOR DOCSTOC USERS
Try the all-new QuickBooks Online for FREE.  No credit card required.

Revenue Projection with Excel Model

Document Sample
Revenue Projection with Excel Model Powered By Docstoc
					                                                               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

				
DOCUMENT INFO
Description: A company can use this template spreadsheet as a tool to assess future revenues for particular products and/or services. This basic spreadsheet assumes a certain growth projection and then applies that growth rate to existing revenues in order to tabulate future revenue amounts. Forecasting future revenues is a complex process that requires analyzing various unknowns, including future demand, market share, total market, inventory availability, and expenses. Businesses often choose to make multiple revenue projections, some using conservative predictions and some using aggressive predictions.
This document is also part of a package Business Transaction Starter Kit 14 Documents Included