Free demo, no card required · Try the demo →
Cafe numbers · guide

How cafe financial modelling turns a plan into real numbers

A cafe financial model is the plan in your head turned into numbers you can test. Before you open, it answers the question that matters most: on realistic trade, does this cafe make money, and does it have the cash to last until it does? Build it honestly and you'll find the problems while they're still lines in a spreadsheet, before they're signatures on a lease.

A HospoSure guide for cafe founders and owners · 10 min read

Every cafe that fails looked fine in the founder's head. The coffee was good, the fit out was right, the location felt busy. What was missing was a model that turned the plan into numbers and asked whether they added up. Financial modelling is unglamorous. It's also what separates a cafe that trades its way to profit from one that runs out of cash and can't work out where it went.

A cafe financial model is built from five pieces. Get each one realistic and you can trust the numbers before you commit to a lease.

Step 01 · what it is

What a cafe financial model actually is

A financial model is your cafe as numbers over time. At its simplest it takes what you expect to earn, subtracts what you expect to spend, and shows what's left, month by month, on assumptions you can change and test.

The profit figure at the bottom matters less than what the model lets you try. Change the rent and see what happens. Drop the average spend by a dollar and watch the margin move. Add a staff member and check whether the takings still cover it. A model lets you make your expensive mistakes for free.

Worth knowing

A model is only as good as its assumptions. The maths is easy. The hard part is being honest about how busy you'll really be and what things will really cost, instead of working backwards from the answer you want.

Step 02 · revenue

Build revenue from covers and average spend

Revenue is where optimistic models go wrong, because it's tempting to start with a number that feels right. Build it from the ground up instead. Estimate your covers, the number of customers, for each part of the day, then multiply by a realistic average spend.

Building a daily revenue estimate from the ground up
DaypartCoversAverage spendRevenue
Morning90$9$810
Midday70$18$1,260
Afternoon40$7$280
Daily total200 $2,350

Add that up across a realistic week, adjusted for quieter and busier days, and you have a monthly revenue figure you can defend. It makes you face how busy you really expect to be, and a lender will trust it far more than a round number that came from nowhere.

Step 03 · cost of goods

Cost of goods from a properly costed menu

Cost of goods is what your sales cost you in ingredients. It should come from a real costed menu, not a percentage pulled from an article. Cost each dish and drink on yielded weight and your cost of goods matches what you actually sell.

This is where the model meets the kitchen. Cost the menu properly and the model inherits accurate numbers. Don't, and every projection after it is built on sand. Our guides on how to cost a cafe menu and the cafe food cost calculator cover the method, and a pre-costed recipe library gives you a costed starting point to model from.

Step 04 · labour

Labour, rostered to your real hours

Labour is one of the two largest costs a cafe carries, and it's easy to understate if you think in headline wages instead of real rosters. Model it from the shifts you'll actually run across your opening hours, and include the parts people forget.

  • Penalty rates on weekends and public holidays under the relevant hospitality award.
  • Superannuation and on costs on top of the base wage.
  • Your own time, if you're working in the cafe, valued honestly and not treated as free.

Rostered to demand, total labour including on costs should sit around 28 to 30% of turnover for a healthy cafe. Build it from real shifts, not a flat percentage, or the number is a pleasant fiction.

Step 05 · overheads

Overheads, the costs that are easy to underestimate

Overheads are the running costs beyond stock and wages, and there are more of them than most new owners list. Rent is the obvious one, but a real cafe carries dozens of smaller costs that add up to a real share of turnover.

Rent and outgoings, utilities, insurance, merchant and payment fees, waste and cleaning, repairs and maintenance, marketing, accounting, software, licences, and loan repayments or finance costs if you borrowed to open: they all belong in the model. Leave them out and a plan that looked profitable turns thin once you're trading. Our guide on cafe overheads has the full list to work through.

Worth knowing

A model with only rent, wages and stock in it will always look healthier than the cafe will be. The realism is in the long tail of smaller overheads, so list them out properly. Don't round them into one vague number.

Step 06 · cash flow

Cash flow: the number that keeps the doors open

Profit and cash are different things, and mixing them up closes cafes. Profit is what's left after costs over a period. Cash flow is whether the money is in the account when rent, wages and suppliers need paying. A cafe can be profitable on paper and still fail because the cash arrived too late.

New cafes are most exposed early, when takings are still building and the bills land in full from day one. A month by month cash flow shows the size of that gap and how much working capital you need to trade through it. It's the most underestimated number in a first cafe plan, and finding it early is half the reason to build a model.

Step 07 · testing it

Pressure test the model against reality

Once the pieces are in, don't just read the profit line and relax. Test the model against independent reference points and against your own worst cases.

Check your cost ratios against the ATO cafe benchmarks for your turnover band. If cost of goods or total expenses sit well outside the published ranges, or labour sits outside the industry guideline, an assumption is probably too optimistic. Then push the model down. What happens if covers come in 20% below plan, or rent is higher, or the slow start lasts twice as long? If the model survives a hard look, you can act on it. If it only works on the best case, that's your answer.

Where HospoSure fits

HospoSure builds the whole model for you: revenue from covers and average spend, cost of goods from a costed menu, labour rostered to your hours, over 40 common overheads, and cash flow month by month. Change an assumption and every number updates. Then export bank ready projections without wrestling a spreadsheet.

Try the free demo
Recap

Modelling a cafe that holds up

An owner who models their cafe well:

  1. Builds revenue from covers and average spend, not a hopeful headline figure.
  2. Takes cost of goods from a costed menu, so it matches what they actually sell.
  3. Models labour from real rosters, including penalty rates and on costs.
  4. Lists overheads in full, including the long tail of smaller costs.
  5. Projects cash flow month by month, to size the working capital they need.
  6. Pressure tests against benchmarks and against their own worst case.

Build the pieces honestly, tie them together in cash flow, test them hard, and you'll walk into the lease knowing the numbers instead of hoping. To put the model in context, our cafe business plan template for Australia shows how it fits the whole plan.

Common questions

Common questions about cafe financial modelling

What is cafe financial modelling?

It's projecting a cafe's finances before or during trading: estimated revenue, costs, profit and cash flow, built into a model you can test against different assumptions. A good model shows whether the cafe is profitable on paper, and also whether it has enough cash to get through the slow early months. That's what lets you pressure test a plan instead of just hoping.

What goes into a cafe financial model?

Five core pieces. Revenue, built from expected covers and average spend across your trading hours. Cost of goods, from a properly costed menu. Labour, rostered to your actual opening hours with penalty rates and on costs included. Overheads, the fixed and variable running costs from rent to insurance to merchant fees. And cash flow, which ties them together month by month and shows when money is actually in the bank, not just earned on paper.

How do I project revenue for a new cafe?

Build it from the ground up. Don't pick a hopeful headline figure. Estimate covers, the number of customers, for each part of the day and each day of the week, then multiply by a realistic average spend. Add those up to a daily figure, then weekly and monthly. It forces you to be honest about how busy you'll be, and a lender who has seen plenty of optimistic guesses can follow your working.

Why does cash flow matter as much as profit?

Because a cafe can be profitable on paper and still run out of money. Profit is what's left after costs over a period. Cash flow is whether the money is in the account when rent, wages and suppliers need paying. New cafes are most exposed early, when takings are still building and the bills arrive in full. Modelling cash flow month by month shows how much working capital you need to get through that gap, and it's one of the things new owners most often underestimate.

What is a realistic profit margin for a cafe?

Many established independent cafes run a net profit margin of around 5 to 10% of turnover once they're trading steadily, though it varies widely and the first year is usually leaner. The figure that matters in your model is your own: revenue less your costed cost of goods, rostered labour and actual overheads. If that comes out thin or negative on reasonable assumptions, the model has done its job by telling you before you signed.

How do I know if my model is realistic?

Check the cost ratios against independent reference points. The ATO publishes cafe benchmarks for cost of sales and total expenses by turnover band, and there's a commonly used industry guideline for labour. If your model assumes ratios well outside those ranges, you might have found a real edge. More often, an assumption is too optimistic. A model inside the benchmarks is one you and a lender can both believe.

Do I need to be good with spreadsheets to model a cafe?

You need to understand the pieces, but you don't need to build the machinery by hand. A spreadsheet can work. The trouble is a cafe model has a lot of moving parts, and keeping formulas right across revenue, cost of goods, labour, overheads and cash flow is where errors and stale numbers creep in. Software built for cafes holds the structure for you, so you spend your time on the assumptions, not on debugging cells.

Next step

Model your cafe before you commit to it

HospoSure builds the whole model for you: revenue from covers and average spend, cost of goods from a costed menu, labour rostered to your hours, over 40 common overheads, and cash flow month by month. You get bank ready projections without touching a spreadsheet.

Try the free demo