Free Restaurant / F&B Financial Model Generator (Excel)

A restaurant financial model projects dine-in revenue (covers × average spend) plus delivery income against ~35% food cost, rent, staffing and fit-out CAPEX, producing linked statements with payback and IRR. Generate the full 15-sheet Excel model free for up to 5 years.

⚡ Generate my Restaurant / F&B model — free (requires JavaScript)

Key drivers pre-loaded in this template

Covers × average spend	Dine-in revenue build
Delivery stream	Aggregator and takeaway income
Food cost ~35%	Industry-standard COGS default
Rent $8k/month default	Location-driven fixed cost

What you get

A 15-sheet, fully formula-linked Excel workbook: Assumptions, Revenue, OPEX, CAPEX & Depreciation, Debt, Tax (with loss carryforward), Income Statement, Cash Flow, Balance Sheet, DCF Valuation, Sensitivity tables, a charted KPI Dashboard and an Integrity Check. Free 15-sheet linked Excel download for models up to 5 years (annual or quarterly, no sign-up). Models from 7 to 25 years are a one-time $29 premium download.

Frequently asked questions

What food-cost percentage should I use?

28–35% of revenue is typical; the template defaults to 35% and is fully editable.

Does it show payback on fit-out?

Yes — the KPI dashboard shows the payback period on your initial CAPEX.

Can I model multiple locations?

Model a second site as an additional revenue stream, or generate separate models per location.

More industry financial models

SaaS / Subscription financial model · Data Center financial model · Real Estate financial model · Manufacturing financial model · Hotel / Hospitality financial model · E-commerce / Retail financial model · Pricing

Free tools

WACC calculator · CAPM calculator · DCF calculator · IRR calculator · Inside the 15-sheet model · Glossary