ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
3
4
5
6
7
8
9
10
Salary Cost
11
unitsHourscostweeklyMonthly
Quaterly
yearly
12
rent401248014405760
13
staff25010100040001200048000
14
Manager150157503000900036000
15
22440
16
17
Breakeven CalculationTC44880179520
18
Year One
Liquidity Capital
-35904Gross Caiptal-75904
19
Q1Q2Q3Q4TotalCash positiveQ3paybackQ4
20
Money Out
Break even point
Q4
21
Fixed Cost2244022440224402244089760
Break even units
2244
22
Variable Cost2244022440224402244089760
23
Total cost44880448804488044880179520
24
25
Money In
26
10%20%30%40%
27
Revenue17952359045385671808179520
28
29
Total-26928-89768976269280
30
Total of totals-26928-35904-269280
31
32
Gross Capital
33
Year OneYear two
34
Q1Q2Q3Q4TotalQ1Q2Q3Q4Total
35
Money Out
36
Fixed Cost22440224402244022440897602244022440224402244089760
37
Variable Cost22440224402244022440897602244022440224402244089760
38
Equipement40000
39
8488044880448804488017952044880448804488044880179520
40
41
Money In
42
10%20%30%40%42%44%46%48%
43
Revenue1795235904538567180817952075398.478988.882579.286169.6323136
44
45
Total-66928-8976897626928-4000030518.434108.837699.241289.6143616
46
Total of totals-66928-75904-66928-40000030518.464627.2102326.4143616
47
48
49
Cash Flow
50
Year OneYear two
51
Q1Q2Q3Q4TotalQ1Q2Q3Q4Total
52
Money Out
53
Fixed Cost22440224402244022440897602244022440224402244089760
54
Variable Cost22440224402244022440897602244022440224402244089760
55
Equipement40000
56
8488044880448804488017952044880448804488044880179520
57
Money In
58
10%20%30%40%
59
Revenue1795235904538567180817952042%44%46%48%
60
Gross capital7590475398.478988.882579.286169.6323136
61
62
Total897635904538567180817054430518.434108.837699.241289.6143616
63
Total of totals£8,976£44,880£98,736£170,544£323,136£30,518£64,627£102,326£143,616£341,088
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