Underestimating the opening budget
Equipment, permits and a reserve for the first months add up. The model shows how much cash you need at the lowest point.
Financial model template
Restaurant financial model template with food cost and payback
A restaurant needs a big investment and runs on thin margins, so a mistake in food cost or staffing shows up fast. The template has covers and the average check, food cost, kitchen and floor staff in two shifts, rent and a large opening investment.
The model answers
- How many covers a day you need to break even
- What food cost the menu can afford
- How much money to raise for the fit-out and the first months
What is inside the template
Each line is a block with plain fields. Change the numbers, delete blocks or add new ones.
- Dining room sales with a ramp-up and food cost as a share of the check
- Kitchen and floor staff in two shifts with payroll costs
- Rent, utilities, card and delivery app fees, marketing
- Kitchen equipment and fit-out as a start-up investment
- A loan or owner investment
- Taxes on revenue or profit
Numbers to watch
- Food cost
- For most restaurants 25–35% of the menu price. Each extra point eats profit directly.
- Labor cost
- Staff with payroll costs often take 25–35% of revenue.
- Covers per day
- Seats × turns per day. Check against what the room and kitchen can handle.
- Cash gap before stabilization
- The deepest point of cash is the minimum amount you need to raise.
Common mistakes in this kind of model
Food cost from the menu, not from reality
Waste and staff meals raise the real food cost. Put a realistic percentage.
One shift instead of two
A restaurant open 12 hours needs two shifts of staff. The template counts both.
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
What is a good food cost for a restaurant?
Usually 25–35% of the price. Fast food and coffee can be lower, steakhouses higher. The AI assistant can compare your menu with restaurants nearby.
How long does a restaurant take to pay back?
Often 2–4 years because of the large start. The model calculates your payback month from your numbers.
Related reading
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.
Profit vs cash flow: what is the difference
Why profit and cash flow differ: depreciation, loans, inventory, payment terms, taxes and owner payouts. With examples and how to read both reports together.
Similar templates
Open the restaurant template now
The demo works without sign-up. To save your model, start the free trial.