Get documents about "Business Profit and Loss Staement
Document Sample
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
