Restaurant Financial Model

Taking into account key assumptions such as the number of seats, average turnover per seat, average check for different menu items, and the combination of fixed and variable costs, this model provides a comprehensive framework for forecasting the expected income, balance sheet, and cash flow statements, as well as the valuation of the modeled restaurant business using the discounted cash flow (DCF) approach.

This model is highly reliable and tailored specifically for the restaurant industry. It is designed as a monthly template and is presented as a fully unlocked Excel file with transparent formulas that can be customized to meet your specific requirements.

Model Overview:
- Revenue: Sales breakdown by different menu items and sales groups (Food, Beverage, and others).
- Cost of Revenue: Detailed breakdown of the cost of revenue for each revenue stream.
- Wages & Salaries: Calculate wages and salaries costs annually and monthly for the selected year.
- Suppliers and External Services: Calculation of supply costs annually and monthly for the selected year.
- Loan Schedule: Calculating debt service (principal and interest) and outstanding balance.
- Depreciation: Calculation of depreciation based on capital expenditures for each year.
- Working Capital: Calculate the working capital requirement using assumptions for inventory collection, payment, and duration.

Outputs:
- Executive Summary: Summary of the main key performance indicators (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: Calculate the company's valuation based on free cash flows to the firm.

By utilizing this comprehensive model, you will gain valuable insights into your restaurant business's financial performance and valuation.