Когда нужна финансовая модель ресторана
When Restaurant Financial Modelling Is Needed
Financial modelling becomes particularly important when a decision requires capital, while the underlying economics are still based on separate assumptions, disconnected calculations or an optimistic sales forecast.
You are planning to open a new restaurant
You may already have a concept, location or investment budget, but still need to determine the sales volume required, the resources necessary to support that volume and the conditions under which the restaurant can reach operating break-even.
You are evaluating a new restaurant format
You may be changing the floor area, price positioning, service model, kitchen configuration, menu structure or sales channels.
The financial model shows how the new configuration affects revenue, costs, investment requirements and cash flow.
You are comparing several investment scenarios
Alternative options need to be evaluated using the same methodology: investment, utilisation, revenue, margins, operating costs, working-capital requirements and sensitivity to the most important assumptions.
The sales plan and cost plan have been built separately
Revenue may be calculated from guest numbers and average spend, while staffing, purchasing, equipment and other resources are budgeted independently.
This makes it difficult to determine whether the resource model can actually support the projected demand.
The investment budget exists, but its economic logic has not been tested
CAPEX may already have been estimated from design documentation, quotations or project budgets, but there is no integrated model linking investment to capacity, future operating economics and cash flow.
Read more about the investment structure in restaurant CAPEX and its role in project economics.
Owners, partners or investors need a transparent basis for the decision
Decision-makers need to see more than the final profit number.
They need to understand the assumptions behind it, the relationships between operating and financial metrics, and the consequences of changing the scenario.
An existing restaurant produces results that are difficult to explain
Profit may be above or below expectations, but the underlying reason remains unclear: demand, average spend, utilisation, sales mix, Food Cost, labour productivity, fixed operating expenses or incorrect assumptions in the original plan.
You are assessing restaurant-group expansion
Before opening additional sites, management needs to understand which parts of the existing economics are genuinely repeatable, which costs arise at site and group level, and how much capital will be required under different expansion scenarios.
What Changes After the Project
Once the financial model has been developed, management discussions no longer revolve around a single projected profit figure.
Instead, the business has an integrated system of assumptions showing the path from market demand to the investment decision:
demand → sales → capacity and resources → CAPEX/OPEX → profit → cash flow → break-even → scenarios → investment decision
This makes it possible to:
- understand which assumptions generate the financial result;
- distinguish source data from calculated metrics and management assumptions;
- test whether forecast sales are consistent with restaurant capacity and available resources;
- see how profit and cash flow change when demand, average spend, Food Cost, staffing, CAPEX or other drivers change;
- assess break-even within the actual revenue and cost structure rather than as an isolated formula;
- compare investment scenarios using one consistent methodology;
- update the model as new information becomes available.
For an existing business, the model can become a foundation for planning and regular review of economic assumptions.
For a new restaurant, it provides a structured way to test the investment decision before a significant share of the capital has already been committed.
Which Metrics and Drivers We Analyse
The financial model is built around the drivers of economic performance rather than by mechanically extending historical numbers into the future.
Demand
We identify the assumptions that generate potential guest and order volumes, including:
- operating days and opening hours;
- guest flow and visit frequency;
- utilisation;
- seasonality;
- demand distribution by day and trading period;
- sales channels;
- demand and capacity constraints.
For a new restaurant, some parameters will inevitably be assumptions.
The objective is not to hide this uncertainty inside the final revenue figure, but to make every material assumption visible, testable and available for scenario analysis.
Sales
We connect demand to the revenue model:
guests / orders → frequency → average spend → sales mix → revenue
Where relevant, the model can separate dine-in, takeaway, delivery and other channels when their economics differ materially.
The analysis covers not only the amount of revenue the restaurant is expected to generate, but also the operating configuration required to produce that revenue.
Read more about the modelling principles in our guide to the restaurant financial model.
Capacity and Resources
We test whether the restaurant can physically handle the demand built into the model.
Sales may be linked to:
- seating capacity and table turns;
- kitchen throughput;
- production areas;
- opening hours and shift structure;
- staffing levels and workforce mix;
- equipment;
- inventory and other operational resources.
A restaurant financial model should reflect the physical economics of the operation.
Sales growth cannot be considered credible if the corresponding operating model does not have the capacity to produce and serve that volume.
Food Cost and Other Variable Costs
We connect the sales mix with product consumption and cost of sales.
Depending on the project, the model may include:
- planned sales mix;
- recipe or category cost;
- purchasing assumptions;
- packaging;
- channel commissions;
- other costs that change with sales volume.
Food Cost is not treated as a universal benchmark percentage.
Its appropriate level depends on the concept, menu, pricing, channel mix and the restaurant’s overall profit model.
Staffing and Labor Cost
Staffing requirements are modelled from operating hours, workload, production processes and service model.
This allows sales to be linked to a specific resource logic rather than simply applying a percentage of revenue:
demand → workload → labour hours → staffing → labour cost
OPEX
We structure operating expenditure according to its economic behaviour.
The model distinguishes between costs that:
- vary directly with business volume;
- change in steps as workload increases;
- behave as relatively fixed expenses;
- arise at individual restaurant level;
- belong to the management company or restaurant group.
CAPEX
We build the investment component of the model and connect it directly to the project configuration.
Depending on the concept, CAPEX may include construction and fit-out, kitchen equipment, furniture, IT infrastructure, operating equipment and other required investment categories.
The objective is not simply to calculate the total investment amount.
The model must also show how the investment decision affects capital requirements and the subsequent economics of the restaurant.
P&L and Profit
Sales, resources and costs are brought together into the projected financial result.
The P&L explains the economic result for a period, but it does not replace the cash-flow model.
Profit and cash flow are therefore modelled separately.
Cash Flow and Capital Requirements
We model cash movements across both the investment and operating stages of the project.
This helps determine:
- when additional financing is required;
- how much capital may be needed before the operating model reaches a sustainable position;
- how changes in opening dates, sales, operating costs or CAPEX affect the cash position;
- which scenarios create additional funding requirements.
Break-Even
Break-even shows the level of activity required to cover the relevant cost structure.
We analyse it together with sales and cost drivers rather than treating it as a standalone formula.
See how to calculate and interpret restaurant break-even.
Scenarios and Sensitivity
We identify the assumptions whose changes have the greatest impact on project economics.
These may include:
- guest numbers;
- average spend;
- the speed of sales ramp-up;
- sales mix;
- Food Cost;
- staffing requirements;
- rent;
- CAPEX;
- opening schedule.
For each material driver, the model can test what happens when the assumption changes and show the resulting effect on profit, cash flow, break-even and capital requirements.
What the Project Includes
Restaurant financial modelling is more than preparing a spreadsheet.
The project includes the methodological and analytical design of the model itself.
Financial Model Architecture
We define the structure of calculations, the relationships between model blocks and the sequence through which the final result is generated:
assumptions → operating drivers → sales → resources → costs → financial result → cash flow → investment metrics
Assumption Framework
We determine which inputs should be entered explicitly and which metrics should be calculated automatically.
Assumptions are structured so that the owner, CFO or analyst can trace the origin of every material figure.
Demand and Sales Modelling
We develop the revenue calculation logic based on available data, the restaurant format and the management decision the model must support.
Resource Modelling
Projected workload is connected with space, equipment, staffing and other resources where those relationships are material to the economics.
Cost and Operating Expense Modelling
We structure calculations for Food Cost, Labor Cost and other OPEX according to the economic behaviour of each cost category.
CAPEX Model
Investment expenditure is structured and incorporated into the overall financing model.
P&L and Cash-Flow Model
Operating and investment calculations are linked to projected profit and cash movement.
Break-Even Calculation
We determine the restaurant’s break-even position and connect it to the principal sales and cost drivers.
Scenario Analysis
Alternative scenarios are created to test how robust the restaurant economics are when major assumptions change.
Sensitivity Analysis
We identify which assumptions and drivers have the greatest impact on the financial result and capital requirements.
Model Update Methodology
We define how assumptions and actual data should be updated so that the financial model can continue to support analysis after the original investment decision rather than becoming a one-off calculation.
How the Project Works
1. Defining the Decision and Model Scope
We begin with the management decision that the model needs to support.
This may involve:
- opening a new restaurant;
- launching a new format;
- refurbishment or reconstruction;
- restaurant-group expansion;
- a concept change;
- reassessing the economics of an existing site;
- comparing investment alternatives.
We define the required operating and financial metrics, modelling horizon, scenario structure and level of detail.
2. Collecting and Reviewing Assumptions
Available source information is structured and reviewed.
We distinguish between:
- actual historical data;
- confirmed project parameters;
- calculated assumptions;
- management assumptions;
- parameters that remain uncertain.
This distinction is particularly important for a new restaurant financial model.
The model should not create an illusion of precision where the underlying assumptions are still uncertain.
3. Building the Driver Architecture
We develop the cause-and-effect structure:
demand → sales → resources → costs → profit → cash flow → investment result
The principal relationships are defined and tested for economic consistency.
4. Developing the Calculation Model
Operating, financial and investment blocks are created and connected.
Independent calculations that could produce contradictory assumptions or results are eliminated.
5. Scenario Modelling
We build alternative sets of assumptions and test the sensitivity of the result to the most important drivers.
The purpose of a scenario is not to predict the future with certainty.
It is to show the possible range of outcomes and the conditions that lead to each one.
6. Agreeing the Management Logic
Together with the client, we review the key relationships within the model:
- where revenue comes from;
- which capacities are required;
- how resource requirements are calculated;
- what drives operating costs;
- where profit or loss is generated;
- when cash deficits may arise;
- which drivers have the greatest impact on the investment result.
7. Model Handover and Update Rules
The client receives the financial model, assumption structure, scenarios and methodology for future updates.
Where the model is intended for regular business planning, we also define which inputs should be refreshed and which metrics should be monitored after launch.
What the Client Receives
The exact output depends on the management task, but the project can include the following deliverables.
Driver-Based Financial Model
An integrated calculation model showing how financial results develop from underlying assumptions through to profit and cash flow.
Metric and Driver Tree
A cause-and-effect structure showing which drivers determine sales, costs, profit, capital requirements and break-even.
Demand and Sales Model
A structured set of assumptions and calculations explaining how forecast revenue is generated.
Resource Model
A model connecting projected workload with staffing, operating capacity and other material resources.
CAPEX and OPEX Model
A structured framework for investment and operating expenditure with clear calculation rules and adjustable assumptions.
P&L Forecast
Projected financial performance under the agreed scenarios.
Cash-Flow Model
A forecast of cash movements and funding requirements.
Break-Even Model
Calculation of the break-even position and its dependence on the key operating drivers.
Scenario Model
A set of connected scenarios for comparing alternative development paths.
Sensitivity Analysis
A model showing how changes in key assumptions affect financial performance and cash flow.
Data Requirements
A structured description of the information required for initial modelling and future updates.
Update Methodology
Rules for updating assumptions, scenarios and actual data as the model is used over time.
What Data Will Be Required
The required input depends on whether the project concerns an existing restaurant, a new opening or a restaurant group.
For a new project, inputs may include:
- concept and format description;
- site area and seating capacity;
- operating hours;
- assumptions regarding guest traffic and sales;
- menu structure and pricing;
- recipe or product-cost information, or Food Cost assumptions;
- service model and staffing structure;
- rental terms and material operating expenses;
- project CAPEX;
- investment and opening schedule;
- available internal and market benchmarks.
For an existing restaurant, the model may also use historical data such as:
- sales;
- number of transactions and guests;
- average spend;
- sales mix;
- purchasing and product cost;
- labour cost;
- operating expenses;
- P&L;
- cash-flow data;
- utilisation and productivity metrics;
- existing budgets and forecasts.
Sources may include management reports, POS systems, ERP or accounting platforms, 1C where applicable, spreadsheets, project documentation and other available operational data sources.
A perfect data environment is not required before work can begin.
What matters is identifying which inputs are confirmed, which need to be reconstructed and which assumptions need to remain explicitly visible in the model.
How to Use the Financial Model in Management
A financial model remains useful beyond the initial investment decision.
Once the restaurant begins operating, forecast assumptions can gradually be replaced by actual results and the resulting variances analysed.
The management cycle becomes:
metric → driver → cause → decision → control
For example, actual revenue may be below the model.
Recording the variance alone is not sufficient.
Management needs to identify the chain behind it:
revenue → guest count / average spend / sales mix → cause of change → management action → control in the next period
The same approach can be applied to Food Cost, Labor Cost, operating profit, cash flow and other financial metrics.
In this way, the original investment model can gradually become part of the restaurant’s regular economic management system.
For a broader planning framework, see the business planning and investment analysis system.
Financial Model for an Existing Restaurant
Financial modelling for an operating restaurant differs from modelling a new opening because actual operating data is already available.
The model can therefore be tested against real restaurant economics and used to determine which relationships actually drive performance.
For example:
traffic → conversion → guests → average spend → revenue
sales mix → product cost → Food Cost
workload → labour hours → staffing → Labor Cost
revenue and resources → OPEX → operating profit
profit + investment + working capital → cash flow
This changes the management question from:
“What result did we achieve?”
to:
“Which drivers created that result, and what happens if one of those drivers changes?”
Financial Model for a New Restaurant Opening
A new restaurant does not yet have its own operating history.
The quality of the model therefore depends heavily on the transparency of its assumptions.
Every material figure should have an explanation.
Not simply:
revenue = X
but:
seats × table turns × utilisation × trading periods × average spend → revenue
Not simply:
labour cost = Y
but:
operating model → required staffing → labour hours → cost of labour → labour cost
Not simply:
the project produces the required return under the scenario
but:
which assumptions regarding demand, sales, CAPEX, operating costs and opening schedule generate that financial result.
For this reason, a new restaurant financial model should be designed first to be testable and traceable, rather than merely to appear precise.
Financial Model for a Restaurant Group
For a restaurant group, the model can operate across several levels:
individual restaurant → format → site portfolio → management company → group
This makes it possible to separate restaurant-level economics from central costs and assess expansion without mixing financial drivers from different organisational levels.
A restaurant-group financial model can support analysis of:
- existing format economics;
- future site openings;
- expansion pace;
- central overhead;
- capital requirements;
- alternative growth scenarios.
Existing site metrics should not automatically be transferred to a new opening.
The model should first determine which drivers are genuinely repeatable and which depend on the specific location, floor area, demand profile or operating configuration.
RestoFactor and Financial Model Automation
The methodology comes first.
Metrics, drivers, relationships, assumptions, scenarios and update rules must be designed before deciding how the model should be automated.
If the financial model needs to be regularly refreshed with actual data and used for budgeting, forecasting and plan-versus-actual analysis, the next stage may be to automate the approved methodology in Finoko.
With this approach, automation is applied to an already defined management system rather than to a collection of unrelated spreadsheets:
data → metric → driver → variance → cause → decision
Automation is therefore a possible next stage, not a prerequisite for developing the financial model.
FAQ
What is included in a restaurant financial modelling service?
The scope depends on the management decision.
A project can include the assumption framework, demand and sales model, resource calculations, Food Cost and Labor Cost, CAPEX, OPEX, P&L, cash flow, break-even, scenario analysis and sensitivity analysis.
The central objective is to connect these components into one cause-and-effect model.
Can we order a restaurant financial model before the final concept has been selected?
Yes.
In this situation, the model can be used to compare several concepts or format alternatives.
Parameters that remain uncertain are treated as explicit assumptions and changed between scenarios. This makes it possible to see which decisions have the greatest impact on the economics of the future restaurant.
Is the service suitable for an existing restaurant?
Yes.
For an operating restaurant, the model can incorporate actual historical data and be used to reassess current economics, plan changes and build forward-looking scenarios.
It is particularly useful when the owner needs to understand not only the P&L result but also the operating drivers behind it.
What data is required to begin?
For a new restaurant, we use the available information on the concept, premises, projected sales, menu, staffing, costs, CAPEX and opening assumptions.
For an existing restaurant, we can additionally use actual sales, product cost, labour, operating expenses and financial performance.
Where information is missing, the model treats it as an explicit assumption rather than hiding uncertainty inside the final calculation.
Can the project begin with one specific investment decision?
Yes.
The model can initially be developed for one new restaurant, a particular format, refurbishment, a new site within a group or another specific investment decision.
If required, the architecture can be designed so that it can later be extended to additional sites or a broader business-planning system.
Will the financial model replace our POS, ERP or accounting system?
No.
Operational systems and financial modelling perform different functions.
POS, ERP, accounting systems or platforms such as 1C may provide source data.
The financial model defines the management logic: which metrics should be calculated, which drivers determine them, how forecasts are built and how scenarios should be analysed.
If required, the approved methodology can later be automated using the existing data environment.
What is the difference between a restaurant business plan and a financial model?
A business plan may include the concept, market analysis, operating model, marketing, organisational structure and other project components.
The financial model is the calculation core of the investment decision.
It shows how specific assumptions generate sales, resource requirements, CAPEX, OPEX, profit, cash flow and break-even.
A restaurant business plan and a financial model can therefore be used together, but they are not the same management tool.
What happens after the financial model has been developed?
The client receives the model together with its calculation logic and update methodology.
It can then be used to review assumptions, compare scenarios, monitor the opening and later perform plan-versus-actual analysis.
If regular data updates and integration with budgeting or forecasting processes are required, automation of the approved methodology can be considered as a separate next stage.
