Planning full capacity from month one
A new café takes 4–8 months to reach steady traffic. The template grows sales gradually toward a ceiling.
Financial model template
Coffee shop financial model template
Find out whether your café pays back before you sign the lease. The template already has sales with cost of goods, a team of baristas, rent, fit-out and a start-up loan. Replace the numbers with yours and see the month you break even.
The model answers
- How many cups a day you need to cover rent and salaries
- When the investment in fit-out and equipment pays back
- How much cash you need on day one so you do not run out in month three
What is inside the template
Each line is a block with plain fields. Change the numbers, delete blocks or add new ones.
- Coffee and food sales with growth to a capacity ceiling and cost of goods as a share of the price
- Baristas and a manager with payroll costs on top of salaries
- Rent, utilities and marketing as monthly expenses
- Fit-out and equipment as a one-off investment in the first month
- A start-up loan with an amortization schedule
- Tax on revenue, which you can switch to tax on profit
Numbers to watch
- Average ticket × sales per day
- Revenue is these two numbers. Check both against cafés within walking distance.
- Cost of goods
- Usually 25–35% of the price for coffee with food. Above 40% the business barely survives rent.
- Rent as a share of revenue
- If rent takes more than 15–20% of revenue at full capacity, the location is expensive for this format.
- Lowest cash balance
- The deepest point of the cash curve shows how much money you need before opening.
Common mistakes in this kind of model
Forgetting the opening period
Rent and salaries start before the first sale. The model counts them from the first month.
Counting profit instead of cash
Loan repayments and equipment do not show in profit but leave your account. Watch the cash chart.
AI assistant
Check the template against your market
Tell the assistant your city and format. It looks up prices, rent and salaries online, compares them with the template and proposes changes as cards with the effect on profit and cash. You decide what to apply.
Questions
How much does it cost to open a coffee shop?
It depends on the city and format. The template shows the structure: fit-out and equipment, a deposit for rent and a cash reserve for the first months. The AI assistant can look up rent and equipment prices for your city.
How long does a coffee shop take to pay back?
Small cafés usually pay back in 12–30 months. The model calculates your own payback month from your prices, traffic and costs.
Related reading
Break-even point: how to calculate it and use it
What the break-even point is, the formula in units and in money, a worked example, and why monthly break-even differs from payback. Plus how to lower it.
Cash flow gap: how to spot it before it happens
What a cash flow gap is, the typical causes (stock, payment terms, seasonality, loans), how to find it in a monthly forecast and six ways to close it.
Similar templates
Open the coffee shop template now
The demo works without sign-up. To save your model, start the free trial.