Template · Café / Bar / Restaurant
Café, bar or restaurant financial model template
Bring your sales, costs and cash figures. Adapt this starting plan for a café & bar business to see what your next move could cost.
Starting assumptions
Check these against your business.
These are the numbers the template starts with, such as costs and how long customers take to pay. Review them with your accountant and change them as needed. They are US starting points, not your own results or financial advice.
| Setting | Value |
|---|---|
| Cost of revenue | 32% |
| Days to collect (DSO) | 2 days |
| Days to pay suppliers (DPO) | 21 days |
| Inventory held | 8 days |
| Revenue collected in advance (deferred) | 3 days |
| Depreciation life | 7 years |
| Tax rate | 21% |
| Trading days per month | 26 |
| Revenue driver | Walk-in revenue |
| Valuation default | 3.5× EBITDA |
The statements
See where each assumption leads.
Follow the inputs through profit, cash and the balance sheet, then review the template's valuation basis. The method and assumptions determine the estimate; it is not a promised sale price.
Income statement
- Revenue = covers per day × average ticket × days open
- Food & beverage cost at 32% of sales is cost of sales
- Wages, rent and utilities are operating expenses (prime cost = F&B + labour)
Balance sheet
- Card settlement in ~2 days keeps receivables tiny
- ~8 days of F&B stock is inventory
- Suppliers on 21-day terms fund part of it
- Gift cards and prepaid bookings are deferred revenue
Cash flow
- Fit-out and kitchen equipment are capex depreciated straight-line over 7 years: cash leaves up front, expense follows over time
Valuation
- EBITDA multiple (default 3.5×), which is how hospitality businesses trade hands
KPIs and benchmarks
What the dashboard tracks for this business
The KPIs on the dashboard and the thresholds the ratios grid shades against come from this template.
Dashboard KPIs
- 01Average ticket
- 02Covers / day
- 03Prime cost %
- 04Break-even covers / day
- 05Revenue / trading day
| Benchmark | Target |
|---|---|
| Gross margin | ≥ 65% |
| EBITDA margin | ≥ 12% |
| Revenue growth (annual) | ≥ 8% |
| Runway | ≥ 6 months |
| Revenue per employee | ≥ $60k |
| Prime cost | ≤ 60% |
Targets are US starting points for this kind of business, not advice.
Use it
Turn the starting point into your plan.
- Bring your current figures. Choose “Café / Bar / Restaurant” during setup or on My Company. Enter reported monthly totals in Your Data, or import a supported CSV or XLSX export from your books.
- Set what you expect next. Review the defaults above, then plan sales, people, running costs, purchases and funding. The assistant can propose edits for you to check.
- Explore a decision. Compare a more cautious sales assumption or a planned investment. Review cash and profit, then the valuation and any ownership implications when raising is relevant.
Sample figures show how the model works. Replace them with your own figures and assumptions before relying on the results.
Other templates: SaaS, Retail or e-commerce, Agency or professional services, Marketplace.
Start with your business.Explore what comes next.
Request an invitation, bring your current figures and build a plan you can review with your accountant.