ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAOAPAQARASATAUAVAWAXAYAZBABBBCBDBEBFBGBHBIBJBKBLBMBNBOBPBQBRBSBTBUBVBWBXBYBZCACBCCCD
1
INPUTS - BIG PICTURE
20242025202620272028
RESULTS & MONTHLY ACTUALS
2
3
↑ by year (click '+' )
↑ Results by year (click '+' )
4
5
6
7
8
1. SETUP & FUNDING
9
10
11
First month-year of modelJan-2024abc 123
✍️ Change any cells with blue text or values and white background
12
Financial Year 2024 is Jan 2024 to Dec 2024
123
✍️ Blue values and gray background calculate values for you but can be overtyped with actuals (use values NOT formulas)
13
Currency used in modelUSD→
Monthly assumptions also entered on right hand side (if in a gray row then MUST be values to work, not formulae)
16
Calcs
17
18
Equity funding
19
Equity Fundraising RoundsMonthAmountJan-2024Feb-2024Mar-2024Apr-2024May-2024Jun-2024Jul-2024Aug-2024Sep-2024Oct-2024Nov-2024Dec-2024Jan-2025Feb-2025Mar-2025Apr-2025May-2025Jun-2025Jul-2025Aug-2025Sep-2025Oct-2025Nov-2025Dec-2025Jan-2026Feb-2026Mar-2026Apr-2026May-2026Jun-2026Jul-2026Aug-2026Sep-2026Oct-2026Nov-2026Dec-2026Jan-2027Feb-2027Mar-2027Apr-2027May-2027Jun-2027Jul-2027Aug-2027Sep-2027Oct-2027Nov-2027Dec-2027Jan-2028Feb-2028Mar-2028Apr-2028May-2028Jun-2028Jul-2028Aug-2028Sep-2028Oct-2028Nov-2028Dec-2028
20
Starting CashJan-202425,000Equity funding- 25,000- - - - 500,000- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
21
Seed RoundJun-2024500,000Equity funding cumulative- 25,00025,00025,00025,00025,000525,000525,000525,000525,000525,000525,000525,000525,000525,000525,000525,000525,000525,000525,000525,000525,000525,000525,000525,000525,000525,000525,000525,000525,000525,000525,000525,000525,000525,000525,000525,000525,000525,000525,000525,000525,000525,000525,000525,000525,000525,000525,000525,000525,000525,000525,000525,000525,000525,000525,000525,000525,000525,000525,000525,000
22
23
24
Formula limit. To add extra events insert an entire row above here
25
Calcs
26
27
Loan funding
28
Cash available
AmountAnnualInterest 0%…Interest only
…then Principal repaid
StartJan-2024Feb-2024Mar-2024Apr-2024May-2024Jun-2024Jul-2024Aug-2024Sep-2024Oct-2024Nov-2024Dec-2024Jan-2025Feb-2025Mar-2025Apr-2025May-2025Jun-2025Jul-2025Aug-2025Sep-2025Oct-2025Nov-2025Dec-2025Jan-2026Feb-2026Mar-2026Apr-2026May-2026Jun-2026Jul-2026Aug-2026Sep-2026Oct-2026Nov-2026Dec-2026Jan-2027Feb-2027Mar-2027Apr-2027May-2027Jun-2027Jul-2027Aug-2027Sep-2027Oct-2027Nov-2027Dec-2027Jan-2028Feb-2028Mar-2028Apr-2028May-2028Jun-2028Jul-2028Aug-2028Sep-2028Oct-2028Nov-2028Dec-2028
29
Flexible loans: grace period, interest only and repayment terms
in mmm-yyyy
RaisedInterest %for L Mths…for M Mths
over N Months (>=0)
Period #
30
SBA LoanApr-2024250,00010%- - 60 4Loan funding cum balance- - - 250,000246,772243,516240,234236,924233,587230,221226,828223,407219,957216,478212,970209,433205,866202,270198,644194,988191,301187,583183,835180,055176,244172,401168,525164,618160,678156,705152,699148,660144,587140,480136,339132,164127,953123,708119,427115,110110,758106,369101,94497,48292,98288,44583,87079,25874,60669,91665,18760,41955,61050,76245,87340,94435,97330,96125,90820,812
31
0Loan funding Interest due- - - - 2,0832,0562,0292,0021,9741,9471,9191,8901,8621,8331,8041,7751,7451,7161,6861,6551,6251,5941,5631,5321,5001,4691,4371,4041,3721,3391,3061,2721,2391,2051,1711,1361,1011,0661,031995959923886850812775737699660622583543503463423382341300258216
32
0
33
Formula limit. To add extra loans COPY & INSERT an entire row above here. "Start Period" formula in right hand column must also be copied.
34
Calcs
35
36
Restaurant Opening
37
Start MonthOn=1Jan-2024Feb-2024Mar-2024Apr-2024May-2024Jun-2024Jul-2024Aug-2024Sep-2024Oct-2024Nov-2024Dec-2024Jan-2025Feb-2025Mar-2025Apr-2025May-2025Jun-2025Jul-2025Aug-2025Sep-2025Oct-2025Nov-2025Dec-2025Jan-2026Feb-2026Mar-2026Apr-2026May-2026Jun-2026Jul-2026Aug-2026Sep-2026Oct-2026Nov-2026Dec-2026Jan-2027Feb-2027Mar-2027Apr-2027May-2027Jun-2027Jul-2027Aug-2027Sep-2027Oct-2027Nov-2027Dec-2027Jan-2028Feb-2028Mar-2028Apr-2028May-2028Jun-2028Jul-2028Aug-2028Sep-2028Oct-2028Nov-2028Dec-2028
38
Restaurant OpeningJun-2024 1 Restaurant Opening- - - - - 1- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
43
Calcs
44
45
Restaurant Setup
46
Useful life inAsset CostJan-2024Feb-2024Mar-2024Apr-2024May-2024Jun-2024Jul-2024Aug-2024Sep-2024Oct-2024Nov-2024Dec-2024Jan-2025Feb-2025Mar-2025Apr-2025May-2025Jun-2025Jul-2025Aug-2025Sep-2025Oct-2025Nov-2025Dec-2025Jan-2026Feb-2026Mar-2026Apr-2026May-2026Jun-2026Jul-2026Aug-2026Sep-2026Oct-2026Nov-2026Dec-2026Jan-2027Feb-2027Mar-2027Apr-2027May-2027Jun-2027Jul-2027Aug-2027Sep-2027Oct-2027Nov-2027Dec-2027Jan-2028Feb-2028Mar-2028Apr-2028May-2028Jun-2028Jul-2028Aug-2028Sep-2028Oct-2028Nov-2028Dec-2028
47
We invest in these assets and depreciate them over their life
Months (e.g. 60)
20242025202620272028
48
Location upfront lease 60 10,000 10,000 10,000 10,000 10,000 Location upfront lease capex- - - - - 10,000- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
49
Renovation and construction costs 60 50,000 50,000 50,000 50,000 50,000
Renovation and construction costs capex
- - - - - 50,000- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
50
Interior design and decor 60 14,500 14,500 14,500 14,500 14,500 Interior design and decor capex- - - - - 14,500- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
51
Furniture and fixtures (tables, chairs, lighting) 60 16,000 16,000 16,000 16,000 16,000
Furniture and fixtures (tables, chairs, lighting) capex
- - - - - 16,000- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
52
Kitchen setup and layout 60 5,000 5,000 5,000 5,000 5,000 Kitchen setup and layout capex- - - - - 5,000- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
53
Kitchen equipment 60 28,000 28,000 28,000 28,000 28,000 Kitchen equipment capex- - - - - 28,000- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
54
Dining furniture & fixtures 60 7,500 7,500 7,500 7,500 7,500 Dining furniture & fixtures capex- - - - - 7,500- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
55
Service materials 60 4,500 4,500 4,500 4,500 4,500 Service materials capex- - - - - 4,500- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
56
PoS System 60 800 800 800 800 800 PoS System capex- - - - - 800- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
57
Inventory Mgt system 60 500 500 500 500 500 Inventory Mgt system capex- - - - - 500- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
58
Security 60 750 750 750 750 750 Security capex- - - - - 750- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
59
Utility setup 60 300 300 300 300 300 Utility setup capex- - - - - 300- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
60
Licensing & Permits 60 400 400 400 400 400 Licensing & Permits capex- - - - - 400- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
61
Music equipment 60 2,500 2,500 2,500 2,500 2,500 Music equipment capex- - - - - 2,500- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
62
Music licensing 60 2,000 2,000 2,000 2,000 2,000 Music licensing capex- - - - - 2,000- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
63
Contingency 60 10,000 10,000 10,000 10,000 10,000 Contingency capex- - - - - 10,000- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
64
Restaurant Setup total capex- - - - - 152,750- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
65
66
Location upfront lease depreciation- - - - - 167167167167167167167167167167167167167167167167167167167167167167167167167167167167167167167167167167167167167167167167167167167167167167167167167167167167167167167
67
Renovation and construction costs depreciation
- - - - - 833833833833833833833833833833833833833833833833833833833833833833833833833833833833833833833833833833833833833833833833833833833833833833833833833833833833833833833
68
Interior design and decor depreciation- - - - - 242242242242242242242242242242242242242242242242242242242242242242242242242242242242242242242242242242242242242242242242242242242242242242242242242242242242242242242
69
Furniture and fixtures (tables, chairs, lighting) depreciation
- - - - - 267267267267267267267267267267267267267267267267267267267267267267267267267267267267267267267267267267267267267267267267267267267267267267267267267267267267267267267
70
Kitchen setup and layout depreciation- - - - - 83838383838383838383838383838383838383838383838383838383838383838383838383838383838383838383838383838383838383
71
Kitchen equipment depreciation- - - - - 467467467467467467467467467467467467467467467467467467467467467467467467467467467467467467467467467467467467467467467467467467467467467467467467467467467467467467467
72
Dining furniture & fixtures depreciation- - - - - 125125125125125125125125125125125125125125125125125125125125125125125125125125125125125125125125125125125125125125125125125125125125125125125125125125125125125125125
73
Service materials depreciation- - - - - 75757575757575757575757575757575757575757575757575757575757575757575757575757575757575757575757575757575757575
74
PoS System depreciation- - - - - 13131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313
75
Inventory Mgt system depreciation- - - - - 8888888888888888888888888888888888888888888888888888888
76
Security depreciation- - - - - 13131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313
77
Utility setup depreciation- - - - - 5555555555555555555555555555555555555555555555555555555
78
Licensing & Permits depreciation- - - - - 7777777777777777777777777777777777777777777777777777777
79
Music equipment depreciation- - - - - 42424242424242424242424242424242424242424242424242424242424242424242424242424242424242424242424242424242424242
80
Music licensing depreciation- - - - - 33333333333333333333333333333333333333333333333333333333333333333333333333333333333333333333333333333333333333
81
Contingency depreciation- - - - - 167167167167167167167167167167167167167167167167167167167167167167167167167167167167167167167167167167167167167167167167167167167167167167167167167167167167167167167
82
Restaurant Setup total depreciation
- - - - - 2,5462,5462,5462,5462,5462,5462,5462,5462,5462,5462,5462,5462,5462,5462,5462,5462,5462,5462,5462,5462,5462,5462,5462,5462,5462,5462,5462,5462,5462,5462,5462,5462,5462,5462,5462,5462,5462,5462,5462,5462,5462,5462,5462,5462,5462,5462,5462,5462,5462,5462,5462,5462,5462,5462,546
101
Calcs
102
103
Initial Operating Expenses
104
Jan-24Feb-24Mar-24Apr-24May-24Jun-24Jul-24Aug-24Sep-24Oct-24Nov-24Dec-24Jan-25Feb-25Mar-25Apr-25May-25Jun-25Jul-25Aug-25Sep-25Oct-25Nov-25Dec-25Jan-26Feb-26Mar-26Apr-26May-26Jun-26Jul-26Aug-26Sep-26Oct-26Nov-26Dec-26Jan-27Feb-27Mar-27Apr-27May-27Jun-27Jul-27Aug-27Sep-27Oct-27Nov-27Dec-27Jan-28Feb-28Mar-28Apr-28May-28Jun-28Jul-28Aug-28Sep-28Oct-28Nov-28Dec-28
105
Initial Food Inventory→Initial Food Inventory - - - - 5,000- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
106
Initial Beverage Inventory→Initial Beverage Inventory - - - - 2,000- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
107
Initial Consumables→Initial Consumables - - - - 1,000- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
108
Rent Deposit →Rent Deposit - - - - 5,000- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
109
Licenses & Registrations→Licenses & Registrations - - - - 1,000- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
110
Other Upfront Operating Expense 1→Other Upfront Operating Expense 1 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
111
Other Upfront Operating Expense 2→Other Upfront Operating Expense 2 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
112
Other Upfront Operating Expense 3→Other Upfront Operating Expense 3 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
113
Initial Operating Expenses tot- - - - 14,000- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
114
Calcs
115
116
2. REVENUES
117
118
119
Long Term Demand
120
20242025202620272028Jan-2024Feb-2024Mar-2024Apr-2024May-2024Jun-2024Jul-2024Aug-2024Sep-2024Oct-2024Nov-2024Dec-2024Jan-2025Feb-2025Mar-2025Apr-2025May-2025Jun-2025Jul-2025Aug-2025Sep-2025Oct-2025Nov-2025Dec-2025Jan-2026Feb-2026Mar-2026Apr-2026May-2026Jun-2026Jul-2026Aug-2026Sep-2026Oct-2026Nov-2026Dec-2026Jan-2027Feb-2027Mar-2027Apr-2027May-2027Jun-2027Jul-2027Aug-2027Sep-2027Oct-2027Nov-2027Dec-2027Jan-2028Feb-2028Mar-2028Apr-2028May-2028Jun-2028Jul-2028Aug-2028Sep-2028Oct-2028Nov-2028Dec-2028
121
Long term demand in covers per day 300 300 300 300 300 LT Daily Demand- - - - - 300- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
122
Days per week restaurant is open 6 6 6 6 6 LT Weekly Demand- - - - - 1,800- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
123
Weeks per year restaurant is open 50 50 50 50 50 LT Annual Demand- - - - - 90,000- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
134
Calcs