Wholesale Revenue Projection Worksheet

Document Sample
Wholesale Revenue Projection Worksheet Powered By Docstoc
					                                                                       REVENUE FORECASTING
Revenue Forecasting For                                                Growth projection                      Percentage                $ AMOUNT
2011                                                                                                   2012          5%                 $ 44,100.00
                                                                                                       2013          5%                 $ 46,305.00
Product/Service A (Specify) Selling Price   $    10.00                                                 2014          5%                 $ 48,620.25
                                                                                                       2015          5%                 $ 51,051.26
Product/Service B (Specify) Selling Price   $     8.00                                                 2016          5%                 $ 53,603.83

Product/Service 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/Service A                     100          100          100          100          100          100          100           100          100

Total Revenue For Product/Service 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/Service B                     200          200          200          200          200          200          200           200          200

Total Revenue For Product/Service 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/Service C                     300          300          300          300          300          300          300           300          300

Total Revenue For Product/Service 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

				
DOCUMENT INFO
Shared By:
Tags:
Stats:
views:255
posted:6/1/2012
language:Unknown
pages:2
Description: A wholesaler 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.