Overview

Description
Taking into account key assumptions such as number of seats, the average turnover per seataverage 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 very 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 the 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 collectionpayment 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 the Free Cash Flows to the Firm.

Reviews Add a review
No reviews yet

More From Jair

Browse our top rated business templates. See All
Convenience Store Gas Station Financial Plan
1,183
0
This Financial Plan Model is a perfect tool for a financial feasibility study on launching a Convenience Store Gas Station. The model can be used to create 5 years’ projections.   The model…
Bakery Financial Plan
1,237
1
This financial model can be utilized to evaluate a bakery business feasibility. This template is detailed, robust and very user-friendly.…
Mobile App Business Case Financial Model
1,275
3
The mobile app financial model provides a comprehensive financial plan template for a mobile app business such as a startup…
Real Estate Condo Development Model - With Pre-sold units
1,214
0
This is a fully functional, institutional quality and dynamic real estate Development Financial Model, which will allow the user to…
Real Estate - Land Development Model
1,214
1
This financial model can be used to evaluate a real estate investment opportunities such as a land development project. It’s…
10 Years Financial Forecast and Valuation Excel Model
1,320
1
Excel Financial Model & Valuation. This is a generic financial model that allows the user to forecast the Company's profit and loss account, balance sheet, cash flow statement, and it…
See All