ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
3
Franchise Feasibility
4
5
Start Date of Project1-Jan-20Unit SummaryFranchise Agreement SignedInitial Franchise FeeCost to DevelopOccupancy Cost - MonthlyOccupancy Start MonthDaily # of SalesMonthly # of SalesAvg. Ticket PriceStarting Year Avg. Rev.Est. Annual GrowthMonths of Growth Before Stabilizing
6
Unit 11$16,000 $650,000 $5,500 725675$120 $972,000 5.00%36
7
Cost AssumptionsUnit 22$14,000 $650,000 $5,500 725675$120 $972,000 5.00%36
8
Unit 38$16,000 $700,000 $5,500 725675$120 $972,000 7.00%36
9
Unit 410$16,000 $650,000 $5,500 725675$120 $972,000 6.00%36
10
On-Going Annual CostsUnit 512$16,000 $650,000 $5,500 725675$120 $972,000 10.00%36
11
Cost of Goods Sold25.00%Unit 615$16,000 $650,000 $5,500 725675$120 $972,000 5.00%36
12
Marketing5.00%Unit 718$16,000 $650,000 $5,500 725675$120 $972,000 10.00%36
13
Repairs1.50%Unit 820$16,000 $650,000 $5,500 725675$120 $972,000 15.00%36
14
Supplies2.00%Unit 922$16,000 $650,000 $5,500 725675$120 $972,000 10.00%36
15
Bank & CC Fees1.75%Unit 1025$16,000 $650,000 $5,500 725675$120 $972,000 5.00%36
16
Royalty Fee1.00%Unit 1130$16,000 $650,000 $5,500 725675$120 $972,000 6.00%36
17
Unit 1232$16,000 $650,000 $5,500 725675$120 $972,000 7.00%36
18
Development Starts8
19
Unit Opens (revenue starts)15
20
Avg. Days Open for Business per Month27
21
Interest Only Rate8.00%
22
23
Field for Other Fixed Costs per Unit$500
Monthly cost per unit
24
Start Month15
25
26
Insurance or Other Fixed Cost per Unit$500
Monthly cost per unit
Video Tutorial:
https://www.youtube.com/watch?v=pXz9reXqVHQ
27
Start Month15Disclaimer:
Use at your own risk. This is not financial advise and there may be errors.
28
29
Labor Costs per Unit (average)
30
Salary / HourlyAvg. # of hours in a monthCountAnnual Cost
31
Annual Manager Salary$65,0001$65,000
32
Asst. manager Hourly Wage$13.001501$23,400
33
Other Hourly wages$18.001507$226,800
34
Total Annual Labor per Center$315,200
35
36
37
Debt and Equity
38
Equity from Owner15%
39
Debt from Bank85%
40
41
42
P+I Assumptions
43
Loan term (yrs)30
44
Annual Interest Rate5.00%
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