Business Profit and Loss Staement by 6Y0V811

VIEWS: 22 PAGES: 3

									                                                    Product company P&L summary sheet
                       COMPANY Name:                                                                                                                                   Fill in ONLY blue cells with data e.g.                      233


                                   %                  %                      %                      %
                     2008        Change   2009      Change   2010          Change   2011          Change   2012          % Change   2013          % Change   2014          % Change   2015          % Change    2016          % Change   2017          % Change

  Gross Sales           116                   240
     Discounts           16                                                                                                                                                                                                                        0


   Net Sales            100                   240                      0                      0                      0                        0                        0                        0                         0                        0
     % Sales          100.0%               100.0%            #DIV/0!                #DIV/0!                #DIV/0!                  #DIV/0!                  #DIV/0!                  #DIV/0!                   #DIV/0!                  #DIV/0!
     COGs                   35
     % Sales          35.1%                 0.0%             #DIV/0!                #DIV/0!                #DIV/0!                  #DIV/0!                  #DIV/0!                  #DIV/0!                   #DIV/0!                  #DIV/0!



 Gross Margin               65
      % GM            64.9%                 0.0%             #DIV/0!                #DIV/0!                #DIV/0!                  #DIV/0!                  #DIV/0!                  #DIV/0!                   #DIV/0!                  #DIV/0!
    Expenses
 Adv & Promotion            10
     % Sales          10.0%                 0.0%             #DIV/0!                #DIV/0!                #DIV/0!                  #DIV/0!                  #DIV/0!                  #DIV/0!                   #DIV/0!                  #DIV/0!
      Other                  2
     % Sales           2.0%                 0.0%             #DIV/0!                #DIV/0!                #DIV/0!                  #DIV/0!                  #DIV/0!                  #DIV/0!                   #DIV/0!                  #DIV/0!
   Sales Force              10
     % Sales          10.0%                 0.0%             #DIV/0!                #DIV/0!                #DIV/0!                  #DIV/0!                  #DIV/0!                  #DIV/0!                   #DIV/0!                  #DIV/0!

                            22
   M & S TOTAL
EXPENSES % Sales      22.1%                 0.0%             #DIV/0!                #DIV/0!                #DIV/0!                  #DIV/0!                  #DIV/0!                  #DIV/0!                   #DIV/0!                  #DIV/0!
 Other Expenses
 Total Admin     %           2
       Sales           2.0%                 0.0%             #DIV/0!                #DIV/0!                #DIV/0!                  #DIV/0!                  #DIV/0!                  #DIV/0!                   #DIV/0!                  #DIV/0!

TOTAL EXPENSES              24
    % Sales           24.1%                 0.0%             #DIV/0!                #DIV/0!                #DIV/0!                  #DIV/0!                  #DIV/0!                  #DIV/0!                   #DIV/0!                  #DIV/0!


Distribution Costs           2
     % Sales           2.0%                 0.0%             #DIV/0!                #DIV/0!                #DIV/0!                  #DIV/0!                  #DIV/0!                  #DIV/0!                   #DIV/0!                  #DIV/0!

      EBIT               39
    % Sales           38.9%                 0.0%             #DIV/0!                #DIV/0!                #DIV/0!                  #DIV/0!                  #DIV/0!                  #DIV/0!                   #DIV/0!                  #DIV/0!




      Confidential                                                                                                   6/24/2012                                                                                                                           Page 1
Product Name
                                                  Product Profit and Loss Statement
                                                               Yellow are Only Areas to be filled in
                                Year   1            2            vs PY         3


Market Sales UNITS                         200          250       25%              280
Product - Units sold                        20           30       50%               40
MS% w/in Mkt UNITS                         10%          12%                        14%
Market Sales Value                     1,000        1,200         20%         1,250
Product - Sales to Market              100          150           50%          200
MS% w/in Mkt DOLLARS                       10%           4%                         6%
Avg $Sales/unit                            5.00         5.00                       5.00
COGS                                       35           53        50%              74
COGS % of Net Sales                        35%          35%                        37%


Gross Margin                               65           98        50%          126
  GM % of Net Sales                        65%          65%                        63%
                                                                 #DIV/0!
      Advertising + Promotion               10           10        0%               10
      Sales Force                           10           10        0%               10
      Mktg & Sales Overhead                  2            2        0%                2
      Samples                                4            4        0%                4
      Internal Allocation                                        #DIV/0!
M&S Cost                                   26           26         0%              26
 M&S % of Net Sales                        40%          27%                        21%


Product Margin                             39           72        83%          100
PM %                                       39%          48%                        50%


Total R&D                                    3            3        0%                3
Total Admin                                  2            2        0%                2
Total Finance                                2            2        0%                2

EBT                                        32           65        102%             93
EBT %                                      32%          43%                        47%


cum. PM                                     39      110.5                          211
cum. EBT                                    32       96.5                          190
 t Profit and Loss Statement                                 Year: 200X
Yellow are Only Areas to be filled in
                         vs PY          4          vs PY     5          vs PY




                          12%               300      7%          320      7%
                          33%                50     25%           60     20%
                                            17%                  19%
                           4%           1,300        4%      1,400        8%
                          33%           250         25%       300        20%
                                             7%                   8%
                                            5.00                 5.00
                          41%               93      25%          117     26%
                                            37%                  39%


                          29%           158         25%       183        16%
                                            63%                  61%
                         #DIV/0!                   #DIV/0!              #DIV/0!
                           0%                10      0%           10      0%
                           0%                10      0%           10      0%
                           0%                 2      0%            2      0%
                           0%                 4      0%            4      0%
                         #DIV/0!                   #DIV/0!              #DIV/0!
                           0%               26       0%          26       0%
                                            17%                  14%


                          40%           132         32%       157        19%
                                            53%                  52%


                           0%                 3      0%            3      0%
                           0%                 2      0%            2      0%
                           0%                 2      0%            2      0%


                          44%           125         34%       150        20%
                                            50%                  50%


                                            342                  499
                                            314                  464

								
To top