Nearly 80% of restaurant expansion plans fail because they lack solid financial backing. Banks and investors don't care about your gut feelings—they want five years of profit and loss data that tells a clear story. Your P&L statements hold the key to proving which investments will actually pay off.
Why five years of P&L data matters for growth
Growth plans without historical data are just expensive guesses. You need five years because it shows:
- Seasonal patterns and cyclical trends
- How you handled external shocks (pandemic, inflation, new competition)
- Consistent performance over time
- Realistic foundation for future projections
Start with revenue trend analysis
Pull your annual revenues from the past five years. Calculate year-over-year growth percentages and spot the patterns.
💡 Example:
Restaurant De Smaak - revenue analysis:
- 2019: €485,000
- 2020: €320,000 (-34% due to pandemic)
- 2021: €410,000 (+28% recovery)
- 2022: €465,000 (+13%)
- 2023: €520,000 (+12%)
Average growth (excluding pandemic years): 12.5% annually
Don't ignore seasonal patterns by quarter. Most restaurants see weak Q1 performance (January-March) and strong Q4 numbers (October-December). Map these cycles—they're crucial for cashflow planning.
Break down your cost structure evolution
Track how your major cost categories performed as revenue percentages:
- Food cost: Should stay between 28-35%
- Labor costs: Typically runs 30-40% of revenue
- Rent: Keep it under 8-12% of revenue
- Other operating costs: Usually 15-25%
💡 Example cost analysis:
Food cost development Restaurant De Smaak:
- 2019: 31% of revenue
- 2020: 35% (lower volumes hurt efficiency)
- 2021: 33%
- 2022: 34% (ingredient price inflation)
- 2023: 32% (better purchasing, reduced waste)
Trend: food costs controlled, ready for growth
This is the kind of thing you only learn after closing your first month at a loss—cost percentages matter more than absolute numbers. A €1,000 food bill looks different on €3,000 revenue versus €10,000 revenue.
Track your EBITDA performance
EBITDA (earnings before interest, tax, depreciation, amortization) shows your operational strength. Here's the formula:
EBITDA = Revenue - Food cost - Labor costs - Operating costs
Target an EBITDA margin between 15-25% for restaurants. Investors focus on this number because it strips out financing decisions and accounting methods.
⚠️ Note:
EBITDA isn't cash flow. You still pay interest, taxes, and equipment depreciation. But it reveals your core business performance.
Spot growth opportunities in your data
Your P&L history reveals where growth potential hides:
- Seasonal valleys: Can you boost revenue during slow months?
- Cost efficiency gains: Which expenses improved as revenue percentages?
- Revenue per square foot: Are you maximizing your space?
- Average transaction value: Is it trending up or down?
These patterns guide decisions about expansion, renovations, or menu changes.
Create data-backed growth projections
Build three scenarios using your historical trends as the foundation:
💡 Example projection 2024:
Based on 12.5% historical growth:
- Conservative: €540,000 (+4% due to economic headwinds)
- Realistic: €570,000 (+10% with enhanced marketing)
- Optimistic: €600,000 (+15% after terrace expansion)
Each scenario requires different investment levels and risk tolerance
Package your business case
Combine historical analysis with future plans into a compelling story:
- Demonstrate your track record with 5-year trends
- Explain how data revealed growth opportunities
- Support proposed investments with historical evidence
- Calculate expected ROI and payback periods
A food cost calculator like KitchenNmbrs helps maintain consistent tracking and generates clean reports for presentations.
How do you build a data-driven growth plan? (step by step)
Gather five years of P&L data
Collect your profit and loss statements from the last five years. Make sure all figures are consistent and comparable (same fiscal year, same cost structure). Export from your accounting software to Excel for analysis.
Analyze revenue and cost trends
Calculate year-over-year growth percentages and review cost items as a percentage of revenue. Identify seasonal patterns and external factors that influenced your figures. Pay special attention to food cost, labor costs, and EBITDA development.
Identify growth opportunities
Look in your data for patterns that reveal opportunities: which months are weak, which cost items can you optimize, where are operational improvement points? Use these insights to formulate realistic growth targets.
Make future projections
Build three scenarios (conservative, realistic, optimistic) based on your historical growth trends. Calculate required investments and expected ROI per scenario. Back up each assumption with data from your P&L analysis.
✨ Pro tip
Update your P&L analysis monthly and track variance against your 36-month rolling projections. This gives you early warning signals if growth plans need adjustment and keeps investor-ready numbers at your fingertips.
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
What if I don't have five years of P&L data?
Work with what you've got—three years is the minimum for meaningful trend analysis. Fill gaps with industry benchmarks and be upfront about data limitations. Investors respect honesty over incomplete information.
How should I handle pandemic years in my analysis?
Include 2020-2021 as exceptional years but don't ignore them completely. Show how quickly you recovered and what operational improvements you made. Many investors view strong pandemic recovery as proof of business resilience.
What EBITDA margin should restaurants target?
Aim for 15-25% EBITDA margin in restaurants. Below 10% signals problems, above 25% is exceptional performance. Remember this is before interest, taxes, and depreciation—your actual profit will be lower.
Should external factors like inflation be included?
Absolutely explain how external forces affected your numbers. Show you can separate temporary impacts from underlying trends. This proves you understand your market dynamics and can make realistic future projections.
📚 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.
Related questions
Calculate your break-even point in seconds
Food cost is just one part of the story. KitchenNmbrs also helps you structure labor costs and other expenses for a complete break-even overview. Start free.
Start free trial →