Startup Pro Forma_Example_Shops at MRM
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Pro Forma Profit and Loss
2
Busy Bee Wine + Cheese
3
4
YEAR 1YEAR 2YEAR 3
5
Revenue
6
Sales $ 284,200.00 $ 369,460.00 $ 480,290.00
7
Direct Cost of Sales $ 142,100.00 $ 184,730.00 $ 240,145.00
8
Other Production Expenses $ - $ - $ -
9
TOTAL COST OF SALES $ 142,100.00 $ 184,730.00 $ 240,145.00
10
Gross Margin $ 142,100.00 $ 184,730.00 $ 240,145.00
11
Gross Margin %50%50%50%
12
13
Expenses
14
Rent $ 14,400.00 $ 14,400.00 $ 14,400.00
15
Payroll $ 44,115.00 $ 48,527.00 $ 53,379.00
16
Legal and Accounting Fees $ 6,248.00 $ 3,115.00 $ 3,340.00
17
Advertising and Promotional Expenses $ 15,448.00 $ 15,523.00 $ 15,834.00
18
Insurance $ 741.00 $ 763.00 $ 786.00
19
Depreciation $ - $ - $ -
20
Telephone $ 1,800.00 $ 1,800.00 $ 1,836.00
21
Internet $ 4,500.00 $ 4,800.00 $ 4,896.00
22
Payroll Taxes $ 4,412.00 $ 4,853.00 $ 5,338.00
23
Other $ - $ - $ -
24
Total Operating Expenses $ 91,664.00 $ 93,781.00 $ 99,809.00
25
Profit Before Interest and Taxes $ 50,436.00 $ 90,949.00 $ 140,336.00
26
Interest Expense $ 1,491.00 $ 1,175.00 $ 845.00
27
Taxes Incurred $ 21,100.00 $ 32,416.00 $ 47,405.00
28
NET PROFIT $ 27,845.00 $ 57,358.00 $ 92,086.00
29
NET PROFIT/SALES9.80%15.52%19.17%
30
31
32
33
34
35
36
37
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
Loading...