Taking into account key assumptions such as the number of seats, the average turnover per seat, average check for the different menu items, and the combination of fixed and variable costs, the model provides a framework to forecast the expected Income, Balance sheet and Cash Flow statement, as well as the valuation of the modeled restaurant business using the DCF approach.
This model is a solid model that takes into account the specifics of the restaurant business. The template is monthly in nature), and it is a 100% unlocked Excel file with fully transparent formulas that can be further tailored to suit your particular needs.
Model Overview:
– Revenue: Sales Breakdown by the different menu items and by group of sales (Food, Beverage, and others)
-Cost of Revenue: Breakdown of the Cost of revenue for each stream
-Wages & Salaries: Calculation of the cost with wages & salaries for each year and monthly wise
for the chosen year
-Suppliers and External Services: Calculation of the cost with supplies for each year and monthly
wise for the chosen year
-Loan Schedule: Calculation of the debt service (Principal & Interest) and outstanding balance
-Depreciation: Calculation of the depreciation, according to the Capex for each year.
-Working Capital: Calculation of the working capital requirement by using the collection, payment, and duration of inventories assumptions
Outputs:
-Executive Summary: Summary of the main KPIs
-Yearly Financial Statements: Yearly profit and loss account, Balance sheet and cash flow
Statement
-Monthly Financial Statements: Monthly profit and loss account, Balance sheet and cash flow
Statement
-Valuation: the valuation of the company is calculated based on the Free Cash Flows to the Firm
Similar Products
Other customers were also interested in...
Restaurant Aggregator and Food Delivery Business F...
Restaurant Aggregator and Food Deliver Business Plan Model is a perfect tool for a financial feasibi... Read more
Pizzeria – 3 Statement Financial Model with ...
This Pizzeria business Plan Model is a perfect tool for a financial feasibility study on launching a... Read more
Catering Services Business Financial Model (10+ Yr...
The catering services business financial model is a comprehensive tool designed to analyze the finan... Read more
Restaurant Financial Model Excel Template
Get Your Restaurant Financial Model Template. Spend less time on Cash Flow forecasting and more time... Read more
Restaurant Financial Model
This Restaurant Financial Model is tailored for those who aim to start a business from scratch, and ... Read more
Start Up Restaurant Financial Model Template
This detailed, yet easy to use three statement financial model will allow you to calculate your busi... Read more
Restaurant Financial Model
This Restaurant Business Plan Model is a perfect tool for a financial feasibility study on launching... Read more
All-day Restaurant & Bar – 5 Year Financial ...
Financial Model providing advanced financial planning & analysis for an All-day Restaurant &... Read more
Cafe Financial Model Excel Template
Check Our Cafe Budget Template. Creates a financial summary formatted for your Pitch Deck. Ready to ... Read more
Multi Cuisine Cafe – 3 Statement Financial M...
This Multi-Cuisine Café business Plan Model is a perfect tool for a financial feasibility study on ... Read more
You must log in to submit a review.