ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
P&L Basic Model:
2
3
201920202021
4
Assumptions
5
Revenue
6
Units100200350
7
Price$250$260$270
8
9
Unit Cost$150$150$150
10
11
Operating Expenses
12
Labor$10,000$15,000$20,000
13
Marketing$5,000$6,000$7,000
14
15
Tax6%6%6%
16
17
Income Statement
18
19
Net Revenue$25,000$52,000$94,500
20
21
COGS$15,000$30,000$52,500
22
23
Gross Profit$10,000$22,000$42,000
24
GP%40.0%42.3%44.4%
25
26
Operating Expenses
27
Labor$10,000$15,000$20,000
28
Marketing$5,000$6,000$7,000
29
Total$15,000$21,000$27,000
30
31
Operating Income-$5,000$1,000$15,000
32
Operating Margin %-20.0%1.9%15.9%
33
34
Tax$825
35
36
Net Income-$5,000$1,000$14,175
37
Net Income %-20%2%15%
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100