Restaurant Business Plan Financial Model Excel Template v5 FML
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJ
1
DashBoard
CURRENCY, DENOMINATOR & TAXDEBT ASSUMPTIONS
2
Your Business Model Name
Currency Inputs
$Loan NameAmount, $LaunchTerm, MInterest, %Select Type
3
Go to Table of Contents
Currency Outputs
$Debt_1 800,000 Jul-18367% Usual
4
Go to FINMODELSLAB.COM
Denomination
1,000Debt_2
Min Cash Month
Apr-21
5
Currency exch rate $ / $
1.000Debt_3
Min Cash ($'000)
-438.6
6
Corporate tax, %
10%Grant
7
8
Core InputsRevenue Breakdown ($'000) - 5 Years to June 2023Profitability ($'000) - 5 Years to June 2023
9
10
WORKING DAYSSALES MIX
11
12
# of Days Open per Week
7Food70%
13
# of Working Days per Year
364Beverage30%
14
Weekends & Holidays per Year
100
15
Midweek per Year
264
Safety Stock, %
30%
16
17
AVERAGE SALES PER DAY, $
18
2019 2020 2021 2022 2023
19
Midweek
3,7004,3505,5006,5506,700
20
Weekends & Holidays
5,5005,7006,5007,0007,500
21
22
MARGIN, %
23
2019 2020 2021 2022 2023
24
Food
40%50%55%60%60%
25
Beverage
40%40%50%50%50%
26
27
Core Financials ($'000)Cash flow ($'000) - 5 Years to June 2023Cumulative CashFlow ($'000) - 5 Years to June 2023
28
29
Fiscal Year
2019 2020 2021 2022 2023
30
31
Revenue
Revenue
1,597 1,797 2,199 2,541 2,635
32
COGS
(958)(953)(1,022)(1,093)(1,133)
33
GROSS MARGIN
639 845 1,176 1,448 1,502
34
GROSS MARGIN %
40%47%54%57%57%
35
Salaries & Wages
(578)(590)(602)(615)(629)
36
Variable Expenses
(144)(162)(198)(229)(237)
37
Fixed Expenditure
(91)(91)(91)(91)(91)
38
NET MARGIN
(173) 3 285 514 545
39
NET MARGIN %
0%13%20%21%
40
EBITDA
EBITDA(173) 3 285 514 545
41
EBITDA %
EBITDA %
0%13%20%21%
42
Depreciation & Amortization
(85.4)(103.6)(103.6)(103.3)(102.0)
43
EBIT
(259)(101) 182 410 443
44
Net Interest Expense
(44)(30)(12)(0) -
45
Net Profit Before Tax
(303)(131) 170 410 443
46
Tax Expense
- - (17)(41)(44)
47
Net Profit After Tax
(303)(131) 153 369 399
48
Net Profit After Tax %
7%15%15%
49
Operating Cash Flows
(246)(28) 255 470 500
50
Cash
(114)(408)(420) 28 528
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
Dashboard Source Data
83
84
Displayed Periods Description
5 Years to June 2023
85
012345
86
Year Ending
2019 2020 2021 2022 2023
87
88
Year End Date
_)30-Jun-19_)_)30-Jun-20_)_)30-Jun-21_)_)30-Jun-22_)_)30-Jun-23_)
89
90
Income Statement Source Data
91
92
Revenue
1,597,033 1,797,446 2,198,692 2,540,943 2,634,665
93
COGS(958,220)(952,647)(1,022,392)(1,092,606)(1,132,906)
94
Salaries & Wages
(577,830)(589,892)(602,388)(615,339)(628,766)
95
Variable Expenditure
(143,733)(161,770)(197,882)(228,685)(237,120)
96
Fixed Expenditure
(90,600)(90,600)(90,600)(90,600)(90,600)
97
EBITDA(173,350) 2,538 285,430 513,714 545,273
98
Depreciation & Amortization
(85,383)(103,583)(103,583)(103,250)(102,000)
99
EBIT(258,733)(101,045) 181,847 410,464 443,273
100
Interest Expense
(44,204)(30,333)(11,667)(130) -
Loading...
Main menu