Free demo access, no card required · Start Planning →
Cafe numbers · guide

Cafe financial modelling: turning a plan into numbers that hold up

A cafe financial model is the plan in your head turned into numbers you can test. It answers the only question that matters before you open: on realistic trade, does this cafe make money, and does it have the cash to reach the point where it does? Build the model honestly and you find the problems while they are still lines in a spreadsheet, not signatures on a lease.

A HospoSure guide for first-time cafe founders · 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 the one thing that would have shown the trouble in advance: a model that turned the plan into numbers and asked whether they actually add up. Financial modelling is unglamorous, and it is the difference between a cafe that trades its way to profit and one that runs out of cash wondering where it went.

This guide covers what a cafe financial model is, the five pieces it is built from, and how to make the numbers realistic enough to trust before you commit to a lease.

Step 01 · what it is

What a cafe financial model actually is

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

The value is not the single profit figure at the bottom. It is what the model lets you do: change the rent and see the effect, 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 is a place to make your expensive mistakes for free, before any of them cost real money.

Worth knowing

A model is only as good as its assumptions. The maths is the easy part. The discipline is being honest about how busy you will really be and what things will really cost, rather than reverse-engineering the numbers to reach the answer you want.

Step 02 · revenue

Build revenue from covers and average spend

Revenue is where optimistic models go wrong, because it is tempting to start with a headline 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

Summed across a realistic week, and adjusted for quieter and busier days, this becomes a monthly revenue figure you can defend. Building it this way forces you to be honest about how busy you expect to be, and it stands up far better to a lender than a round number that appeared 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, and it should come from a real costed menu, not a percentage plucked from an article. When each dish and drink is costed on yielded weight, your cost of goods reflects what you actually sell rather than a guess.

This is where a model connects to the kitchen. If your menu is costed properly, the model inherits accurate numbers. If it is not, every projection downstream 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 is easy to understate in a model by thinking in headline wages rather than real rosters. Model it from the shifts you will actually run, across your actual opening hours, and include the parts that are simple to 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 are working in the cafe, valued honestly rather than treated as free.

Rostered to demand, total labour including on-costs commonly sits somewhere around 26 to 33 percent of turnover for a healthy cafe. Modelling it from real shifts, rather than a flat percentage, is what stops the number being 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 first-timers list. Rent is the obvious one, but a real cafe carries dozens of smaller costs that add up to a meaningful share of turnover.

Rent and outgoings, utilities, insurance, merchant and payment fees, waste and cleaning, repairs and maintenance, marketing, accounting, software, licences, and any loan repayments or finance costs if you borrowed to open, all belong in the model. Leaving them out is one of the quiet reasons a plan that looked profitable turns thin in reality. Our guide on cafe overheads covers 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 lives in the long tail of smaller overheads, so build the list out properly rather than rounding it into a single vague number.

Step 06 · cash flow

Cash flow: the number that keeps the doors open

Profit and cash are not the same thing, and confusing them closes cafes. Profit is what is left after costs over a period. Cash flow is whether the money is physically in the account when the rent, the wages, and the 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 but the bills land in full from day one. Modelling cash flow month by month shows you the size of that gap and how much working capital you need to trade through it. This is the single most underestimated number in a first cafe plan, and the model exists largely to surface it before it surprises you.

Step 07 · testing it

Pressure test the model against reality

Once the pieces are in, do not 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 your cost of goods, labour, or total expenses sit well outside the published ranges, an assumption is probably too optimistic. Then run the model down: what happens if covers come in 20 percent below plan, or rent is higher, or the slow start lasts twice as long? A model that survives a hard look is one you can act on. A model that only works on the best case is telling you something.

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 25 common overheads, and month-by-month cash flow. Change an assumption and watch every number update, then export bank-ready projections without wrestling a spreadsheet.

Model your cafe with HospoSure
Recap

Modelling a cafe that holds up

A founder 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 reflects 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.

Cafe financial modelling is how you find out whether the business works before you commit to it. Build the pieces honestly, tie them together in cash flow, and test them hard, and you walk into the lease knowing the numbers rather than hoping them. If you want to structure the whole thing, our cafe business plan template for Australia puts the model in context.

Common questions

Common questions about cafe financial modelling

What is cafe financial modelling?

It is the process of projecting a cafe's finances before, or during, trading: building estimated revenue, costs, profit, and cash flow into a model you can test against different assumptions. A good model shows not just whether the cafe is profitable on paper, but whether it holds enough cash to survive the slow early months and reach the point where it trades comfortably. It turns a plan from a hope into something you can pressure test.

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 including penalty rates and on-costs. 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 rather than just earned on paper.

How do I project revenue for a new cafe?

Build it from the ground up rather than picking 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. Sum those to a daily figure, then a weekly and monthly one. Building revenue this way forces you to be honest about how busy you actually expect to be, and it makes the number defensible to a lender, who has seen plenty of optimistic guesses.

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 is left after costs over a period. Cash flow is whether the money is physically in the account when the rent, wages, and suppliers need paying. New cafes are especially exposed early, when takings are still building but the bills arrive in full. Modelling cash flow month by month shows you how much working capital you need to survive the gap, which is one of the most common things first-timers underestimate.

What is a realistic profit margin for a cafe?

Many established independent cafes run a net profit margin in the region of 5 to 10 percent of turnover once they are trading steadily, though it varies widely and the first year is usually leaner. The figure that matters in your model is not a borrowed average but your own: revenue less your costed cost of goods, your rostered labour, and your 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?

Pressure test the cost ratios against independent reference points. The ATO publishes cafe benchmarks for cost of sales and total expenses by turnover band, and labour has a commonly used industry guideline. If your model assumes ratios well outside those ranges, either you have found a genuine edge or, more often, an assumption is too optimistic. A model that sits inside the benchmarks reads as credible, both to you and to a lender.

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

You need to understand the pieces, but you do not need to build the machinery by hand. A spreadsheet can work, but a cafe model has a lot of moving parts, and keeping formulas correct and current across revenue, cost of goods, labour, overheads, and cash flow is where errors and stale numbers creep in. A purpose-built tool holds the structure for you, so you spend your time on the assumptions that matter rather than 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 25 common overheads, and month-by-month cash flow. Bank-ready projections without a spreadsheet.

Model your cafe with HospoSure