Docstoc

Profit and Loss Projection Model

Document Sample
Profit and Loss Projection Model Powered By Docstoc
					               Income Statement Projection                                              PnL projection




Profit and Loss Projection (12 Months)
Business Name

For The Year Begging
Aug-11




                                                                                                 2




                                                                                                                               2
                                                               11




                                                                                                                                                           2


                                                                                                                                                                      AR
                                                                                              n-1




                                                                                                                           r-1




                                                                                                                                                        l-1
                                        g-




                                                                                                                                     y-
                                                                       v-
                                                    p-




                                                                                   c-




                                                                                                                r-
                                                                                                       b-




                                                                                                                                            n-




                                                                                                                                                                    LY
                                                                t-




                                                                                                                                    12




                                                                                                                                                                                 %
                                       11




                                                                      11
                                                  11




                                                                                  11




                                                                                                      12


                                                                                                              12




                                                                                                                                           12
                                                                                                             Ma




                                                                                                                                   Ma
                                      Au




                                                                     No




                                                                                                                         Ap
                                                             Oc




                                                                                                                                                                   YE
                                                                                 De
                                                 Se




                                                                                                                                          Ju



                                                                                                                                                      Ju
                                                                                                     Fe
                                                                                            Ja
Revenue (Sales)
Specify source                    $ 100.00   $ 100.00                                                                                                          $ 200.00        100.0
Specify source                                                                                                                                                 $      -          0.0
Specify source                                                                                                                                                 $      -          0.0
Specify source                                                                                                                                                 $      -          0.0
Specify source                                                                                                                                                 $      -          0.0
Specify source                                                                                                                                                 $      -          0.0
Specify source                                                                                                                                                 $      -          0.0
Total Revenue (Sales)             $ 100.00   $ 100.00    $      -    $   -   $     -    $     -      $   -   $   -   $     -       $ -    $   -   $    -       $ 200.00        100.0

Cost of Sales
Specify details                                                                                                                                                $       -
Specify details                                                                                                                                                $       -
Specify details                                                                                                                                                $       -
Specify details                                                                                                                                                $       -
Specify details                                                                                                                                                $       -
Specify details                                                                                                                                                $       -
Specify details                                                                                                                                                $       -
Total Cost of Sales               $      -   $      -    $      -    $   -   $     -    $     -      $   -   $   -   $     -       $ -    $   -   $    -       $       -

Gross Profit                      $ 100.00   $ 100.00    $      -    $   -   $     -    $     -      $   -   $   -   $     -       $ -    $   -   $    -       $ 200.00

Expenses
Salary expenses                                                                                                                                                $       -
Payroll expenses                                                                                                                                               $       -
Outside services                                                                                                                                               $       -
Supplies (office and operating)                                                                                                                                $       -
Repairs and maintenance                                                                                                                                        $       -
Advertising                                                                                                                                                    $       -
Car, delivery and travel                                                                                                                                       $       -
Accounting and legal                                                                                                                                           $       -
Rent                                                                                                                                                           $       -
Telephone                                                                                                                                                      $       -
Utilities                                                                                                                                                      $       -
Insurance                                                                                                                                                      $       -
Taxes                                                                                                                                                          $       -
Interest                                                                                                                                                       $       -
Depreciation                                                                                                                                                   $       -
Misc. expenses                                                                                                                                                 $       -
                                                                                                                                                               $       -
                                                                                                                                                               $       -
                                                                                                                                                                   $       -
Total Expenses                    $      -   $      -    $      -    $   -   $     -    $     -      $   -   $   -   $     -       $ -    $   -   $    -       $       -

Net Profit                        $ 100.00   $ 100.00    $      -    $   -   $     -    $     -      $   -   $   -   $     -       $ -    $   -   $    -       $ 200.00
Profit & Loss Projection Quarterly



Aug-11
                                     Nov-11          Mar-12             Jul-12
Revenue (Sales)                   1st Quarter    % 2nd Quarter    % 3rd Quarter   % Year Total    %

                                  $ 200.00      100   $   -   -      $   -    -      $ 200.00    100
                                  $    -          0   $   -   -      $   -    -      $    -        0
                                  $    -          0   $   -   -      $   -    -      $    -        0
                                  $    -          0   $   -   -      $   -    -      $    -        0
                                  $    -          0   $   -   -      $   -    -      $    -        0
                                  $    -          0   $   -   -      $   -    -      $    -
                                  $    -          0   $   -   -      $   -    -      $    -
Total Sales                       $ 200.00      100   $   -   -      $   -    -      $ 200.00    100

Cost of Sales
                                  $    -              $   -          $   -           $    -
                                  $    -              $   -          $   -           $    -
                                  $    -              $   -          $   -           $    -
                                  $    -              $   -          $   -           $    -
                                  $    -              $   -          $   -           $    -
                                  $    -              $   -          $   -           $    -
                                  $    -              $   -          $   -           $    -
Total Cost of Sales               $    -              $   -          $   -           $    -


Gross Profit                      $ 200.00            $   -          $   -           $ 200.00

Expenses
Salary expenses                   $    -              $   -          $   -           $    -
Payroll expenses                  $    -              $   -          $   -           $    -
Outside services                  $    -              $   -          $   -           $    -
Supplies (office and operating)   $    -              $   -          $   -           $    -
Repairs and maintenance           $    -              $   -          $   -           $    -
Advertising                       $    -              $   -          $   -           $    -
Car, delivery and travel          $    -              $   -          $   -           $    -
Accounting and legal              $    -              $   -          $   -           $    -
Rent                              $    -              $   -          $   -           $    -
Telephone                         $    -              $   -          $   -           $    -
Utilities                         $    -              $   -          $   -           $    -
Insurance                         $    -              $   -          $   -           $    -
Taxes                             $    -              $   -          $   -           $    -
Interest                          $    -              $   -          $   -           $    -
Depreciation                      $    -              $   -          $   -           $    -
Misc. expenses                    $    -              $   -          $   -           $    -
                                  $    -              $   -          $   -           $    -
                                  $    -              $   -          $   -           $    -
                                  $    -              $   -          $   -           $    -
Total Expenses                    $    -              $   -          $   -           $    -


Net Profit                        $ 200.00            $   -          $   -           $ 200.00

                                   $    -             $   -          $   -           $    -
                                   $    -             $   -          $   -           $    -
                                   $    -             $   -          $   -           $    -
                                   $    -             $   -          $   -           $    -
                                   $    -             $   -          $   -           $    -
                                   $    -             $   -          $   -           $    -
Total Cost of Sales                $    -             $   -          $   -           $    -


Gross Profit                       $ 200.00           $   -          $   -           $ 200.00

Expenses
Salary expenses                    $    -             $   -          $   -           $    -
Payroll expenses                   $    -             $   -          $   -           $    -
Outside services                   $    -             $   -          $   -           $    -
Supplies (office and operating)    $    -             $   -          $   -           $    -
Repairs and maintenance            $    -             $   -          $   -           $    -
Advertising                        $    -             $   -          $   -           $    -
Car, delivery and travel           $    -             $   -          $   -           $    -
Accounting and legal               $    -             $   -          $   -           $    -
Rent                               $    -             $   -          $   -           $    -
Telephone                          $    -             $   -          $   -           $    -
Utilities                          $    -             $   -          $   -           $    -
Insurance                          $    -             $   -          $   -           $    -
Taxes                              $    -             $   -          $   -           $    -
Interest                           $    -             $   -          $   -           $    -
Depreciation                       $    -             $   -          $   -           $    -
Mis expenses                       $    -             $   -          $   -           $    -
                                   $    -             $   -          $   -           $    -
                                   $    -             $   -          $   -           $    -
                                   $    -             $   -          $   -           $    -
Total Expenses                     $    -             $   -          $   -           $    -


Net Profit                         $ 200.00           $   -          $   -           $ 200.00

				
DOCUMENT INFO
Description: This Profit and Loss Projection provides a spreadsheet model for making monthly and quarterly profit and loss projections. A profit and loss statement, also known as an income statement, is a financial statement showing total revenues and costs. Sales and expenses should be input into this template on a monthly basis. A profit and loss projection is a planning tool that allows managers to see a company's net income (the bottom line) once costs, expenses, and taxes have been taken out of revenues (top line), over the course of an entire fiscal year.
This document is also part of a package Financial Statements and Projections 22 Documents Included