; Profit and Loss Projection Model
Documents
Resources
Learning Center
Upload
Plans & pricing Sign in
Sign Out
Your Federal Quarterly Tax Payments are due April 15th Get Help Now >>

Profit and Loss Projection Model

VIEWS: 9,569 PAGES: 2

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.

More Info
  • pg 1
									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
								
To top