A scenario analysis helps you calculate the financial consequences of growth in advance. Most restaurant owners jump into expansion without understanding the cashflow impact. Here's how to calculate three realistic growth scenarios and make informed expansion decisions.
Why create a scenario analysis?
Growth sounds appealing, but it drains cash upfront. Opening a second location means paying double rent, hiring more staff, and covering higher purchasing costs months before you see extra revenue. A scenario analysis reveals what happens to your cashflow and profit under different conditions.
⚠️ Important:
Most entrepreneurs calculate extra revenue but overlook upfront costs. New locations typically burn cash for the first several months before turning profitable.
The three standard growth scenarios
For restaurant expansion, you should model three realistic scenarios:
- Conservative scenario: Slow growth with cautious assumptions
- Realistic scenario: Average growth based on market research
- Optimistic scenario: Rapid growth if conditions align perfectly
Modeling all three shows how your finances perform across different outcomes.
Step 1: Document your current situation
Before building scenarios, establish your baseline. Collect these figures from your existing location:
- Monthly revenue (12-month average)
- Food cost percentage
- Monthly staff costs
- Fixed expenses (rent, insurance, utilities)
- Monthly net profit
💡 Example current situation:
Restaurant "De Brasserie", existing location:
- Monthly revenue: €45,000
- Food cost: 32%
- Staff costs: €18,000/month
- Fixed costs: €8,500/month
- Net profit: €6,500/month
Step 2: Estimate costs for new location
A second location creates new expenses. Some you can calculate exactly, others require estimates based on market data.
Fixed costs new location:
- Rent (including service charges)
- Renovation and equipment (amortized over 5-7 years)
- Additional insurance coverage
- Launch marketing budget
- Permits and professional fees
Variable costs:
- Additional staff (kitchen, service, management)
- Higher purchasing costs (reduced economies of scale initially)
- Extra administrative and accounting expenses
💡 Example costs second location:
Projected monthly costs new location:
- Rent: €4,200/month
- Equipment amortization: €1,800/month
- Additional staff: €15,000/month
- Insurance: €350/month
- Marketing: €800/month
Total fixed costs: €22,150/month
Step 3: Calculate revenue scenarios
Now model three different revenue scenarios for your new location. Base assumptions on solid market research and comparable restaurants.
Conservative scenario (70% of target):
Assumes slow ramp-up and cautious growth. This accounts for challenges like limited brand recognition or intense local competition.
Realistic scenario (100% of target):
Built on market data and performance of similar restaurants nearby. This becomes your primary business case scenario.
Optimistic scenario (130% of target):
Assumes everything clicks: prime location, rapid brand awareness, weak competition. Don't bank on this for financing, but it shows upside potential.
💡 Example revenue scenarios new location:
Month 6 (full operations):
- Conservative: €28,000/month (70%)
- Realistic: €40,000/month (100%)
- Optimistic: €52,000/month (130%)
Note: expect lower revenue first 3 months during ramp-up period.
Step 4: Calculate cashflow per scenario
For each scenario, compute monthly cashflow for the new location using this formula:
Net cashflow = Revenue - Food cost - Staff costs - Fixed costs
Run this calculation across all three scenarios to identify when each breaks even (stops generating losses). This is the kind of thing you only learn after closing your first month at a loss - the break-even timeline determines everything.
💡 Example cashflow calculation (month 6):
Realistic scenario - new location:
- Revenue: €40,000
- Food cost (32%): €12,800
- Staff costs: €15,000
- Fixed costs: €7,000
Net cashflow: €5,200/month
Break-even achieved month 4 under this scenario.
Step 5: Impact on total business
Don't overlook how expansion affects your original location. A second site can impact:
- Cannibalization: Customers switch to the new location
- Management bandwidth: Reduced attention to existing location
- Purchasing power: Better supplier rates from increased volume
- Shared overhead: Split costs like accounting and marketing
⚠️ Important:
Always account for 10-20% cannibalization if opening within the same city. Customers typically choose whichever location is most convenient.
Financing needs per scenario
Each growth variant requires different funding levels. Calculate for each scenario:
- Initial investment: Setup, renovation, equipment purchases
- Working capital: Initial inventory, first month operating expenses
- Cash buffer: Safety net for slower-than-expected revenue
The conservative scenario demands the largest buffer since break-even takes longer.
Create a decision matrix
Build a summary comparing all three scenarios with key metrics:
- Break-even timeline (months)
- Total financing requirement
- ROI after 12 months
- Downside risk exposure
This matrix enables data-driven decisions about whether expansion makes financial sense.
How do you create a scenario analysis? (step by step)
Gather current figures
Note your monthly revenue, food cost percentage, staff costs, and fixed costs from your existing location. These figures are the basis for your calculations.
Estimate costs for new location
Calculate rent, setup, additional staff, and other costs of the second location. Don't forget hidden costs like additional insurance and marketing.
Create three revenue scenarios
Calculate conservative (70%), realistic (100%), and optimistic (130%). Use market data and performance of similar restaurants as a basis.
Calculate cashflow per scenario
Subtract food cost, staff costs, and fixed costs from each revenue variant. This shows you when each variant breaks even.
Determine financing need
Calculate per scenario how much money you need for investment, working capital, and buffer. The conservative scenario determines your minimum financing.
✨ Pro tip
Model your conservative scenario first, then stress-test it with a 6-month revenue delay. If that version still breaks even within 18 months, you've got a viable expansion plan with built-in cushion for setbacks.
Calculate this yourself?
In the KitchenNmbrs app you can do this in just a few clicks. 7 days free, no credit card.
Was this article helpful?
Frequently asked questions
How realistic should my revenue estimates be?
Base financing decisions on your conservative scenario. Research comparable restaurants in your target area and reduce their performance by 20% for safety. Most operators overestimate initial demand.
Should I factor in cannibalization effects?
Absolutely - expect 10-20% revenue decline at your existing location if opening in the same city. Customers gravitate toward convenience, so some will switch locations rather than represent new business.
What costs do most restaurant owners forget in expansion planning?
Additional management time, higher per-unit purchasing costs due to split volume, and extended staff training periods. Marketing the new location also requires dedicated budget separate from your existing advertising spend.
📚 Sources consulted
- EU Verordening 852/2004 — Levensmiddelenhygiëne (2004) — Official source
- EU Verordening 853/2004 — Hygiënevoorschriften voor levensmiddelen van dierlijke oorsprong (2004) — Official source
- EU Verordening 1169/2011 — Voedselinformatie aan consumenten (2011) — Official source
- NVWA — Hygiënecode voor de horeca (2024) — Official source
- NVWA — Allergenen in voedsel (2024) — Official source
- Codex Alimentarius — International Food Standards (2024) — Official source
- FSA — Safer food, better business (HACCP) (2024) — Official source
- BVL — Lebensmittelhygiene (HACCP) (2024) — Official source
- Warenwetbesluit Bereiding en behandeling van levensmiddelen (2024) — Official source
- WHO — Foodborne diseases estimates (2024) — Official source
Food Standards Agency (FSA) — https://www.food.gov.uk
The HACCP standards shown in this application are for informational purposes only. KitchenNmbrs does not guarantee that displayed values are current or complete. Always consult the FSA or your local authority for the latest regulations.
Written by
Jeffrey Smit
Founder & CEO of KitchenNmbrs
Jeffrey Smit built KitchenNmbrs from 8 years of hands-on experience as kitchen manager at 1NUL8 Group in Rotterdam. His mission: give every restaurant owner control over food cost.
All your financial KPIs in one dashboard
Food cost percentage, gross margin, revenue per cover — KitchenNmbrs calculates it all automatically based on your recipes and purchases. Start your free trial.
Start free trial →