ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
3
Business Name
John's Coffee
4
5
Start Up Costs
Revenue Projections
6
Equipment
7
Espresso Machine & Accessories
 $ 15,000 MonthJanuaryFebruaryMarchAprilMayJuneJulyAugust
September
October
November
December
8
Furniture $ 5,000
Total Customers Per Day
707070757575909090110110110
9
Payment System
 $ 2,000
Ave Coffee Price
 $ 5.00 $ 5.00 $ 5.00 $ 5.00 $ 5.00 $ 5.00 $ 5.00 $ 5.00 $ 5.00 $ 5.00 $ 5.00 $ 5.00
10
Cutlery and Mugs
 $ 5,000
Pastries Sold Per Day
101214151617181920202020
11
Insert $ -
Ave Price per Pastry
 $ 4.50 $ 4.50 $ 4.50 $ 4.50 $ 4.50 $ 4.50 $ 4.50 $ 4.50 $ 4.50 $ 4.50 $ 4.50 $ 4.50
12
Total $ 27,000
13
Costs per Coffee
Customer Payment Terms
14
InventoryMilk $ 0.20 Days to Pay0
(immediate point of sale payment)
15
Coffee Beans
 $ 1,500 Cup $ 0.20
16
Milk $ 150
Coffee Beans
 $ 0.80
Inventory/Ingredients Payment Terms
17
Pastries $ 200 Sugar $ 0.05 Days to Pay28
18
Sugar $ 100 Total $ 1.25
19
Total $ 1,950
Gross Profit Margin
75%
Starting Equity (cash put into business)
20
21
Renovations/Fitout
Pastry Costs
 $ 20,000
22
Fitout $ 10,000
Ave Price Paid per Pastry
 $ 3.00
23
Insert $ -
Gross Profit Margin
33%
Total Borrowed Funds
24
Insert $ -
25
Total $ 10,000
Fixed Monthly Operating Costs
 Amount $ 30,000
26
Rent $ 2,500 Interest Rate8%
27
Marketing
Salaries/Month
 $ 4,500
Repayment Months
24
28
Website $ 2,500 Super12%
29
Promtional Materials
 $ 750
Super Cost
 $ 518
Monthly Repayment
30
Menus $ 250
Workcover
2%
if Interest Only
 $ 200.00
31
Signage $ 500
Workcover Cost
 $ 100
if Principal and Interest
 $ 1,356.82
32
Insert $ -
General Insurance
 $ 250
33
Insert $ -
Promotions
 $ 100
34
Total $ 4,000
Accounting/Payroll
 $ 250
35
Utilities $ 500
36
Miscelanious
Total Fixed Monthly Costs
 $ 8,718
37
Licensing and Registrations
 $ 1,000
38
Insert $ -
39
Insert $ -
40
Total $ 1,000
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