Restaurant & Cafe Financial Model (Excel + Google Sheets)

A 5 year financial model built for a restaurant or cafe, not a generic business template with the name changed.

Type your covers, your average check, your delivery orders, your menu's food cost and your staff on one tab. Everything else calculates.

WHAT YOU GET

• 15 tab financial model, Excel and Google Sheets

• Dashboard with 6 KPI tiles and 3 charts: capital required, revenue at maturity, margins, break even month, cash low point

• Revenue built from real restaurant drivers: dine in covers, takeaway and delivery, catering and events, retail, each with growth, a seat capacity ceiling and its own food cost %

• Food cost % and labour % against industry benchmarks, right on the dashboard

• Full staff roster with start months: GM, head chef, line cooks, servers, barista, dishwasher, host, second shift, assistant manager, sous chef

• Restaurant expense lines: rent, utilities, POS, delivery platform ads, insurance, smallwares, repairs, linen and pest, waste, licences

• Opening capex: kitchen equipment, fit out, furniture, POS, signage, with depreciation

• Loan schedule with interest and principal, plus owner equity, and the funding gap if any

• Linked P&L, cash flow and balance sheet, monthly for 60 months plus annual summaries

• Break even analysis, Base / Best / Worst scenarios, use of funds

• Checks tab that proves the model balances

• One page quick start guide

WHO IT IS FOR

Opening a place and need to show a lender or a partner. Running a place and need to know what a second shift or a delivery push does to cash.

HOW IT WORKS

1. Download and open in Excel, or import into Google Sheets

2. Go to Inputs. Blue cells on yellow are yours.

3. Read the Dashboard.

FORMAT

Excel .xlsx, opens in Excel 2016 or later and in Google Sheets. No macros. Instant download after purchase. A one click Google Sheets copy link is inside the download.

Preview images were created with AI assisted design tools. The spreadsheet itself is hand built and formula driven.

LICENCE

Personal and single business use. Not for resale or redistribution.

Also in the shop: Restaurant OS (the Notion system) and the Recipe Cost and Menu Pricing Calculator.

Questions before you buy? Message me. I answer within a day.