Restaurant Financial Model Template

Start with the Assumptions sheet. Enter your seating capacity, estimated covers per service (lunch and dinner), and average check size for each daypart. If you're modeling an existing restaurant, use last month's POS report for covers and average check — it takes about 10 minutes to pull those numbers. If you're projecting for a new opening, research comparable restaurants in your market and make conservative estimates. Everything else in the model calculates from what you enter here, so spend the most time getting your cover count and average check right.

Once assumptions are set, review the Revenue Projections and P&L sheets to see if the numbers look realistic. Check your food cost percentage and labor cost percentage in the Food & Beverage Cost and Labor Plan sheets — if food cost is above 35% or prime cost (food + labor) is above 65%, that's a signal to revisit your pricing, portioning, or staffing plan, not just the spreadsheet. The Cash Flow sheet shows your break-even month and monthly cash position, which is the number lenders focus on when you're seeking financing.

For ongoing use, update your actual monthly covers, check size, and key costs in the Assumptions sheet each month and compare the projections to what actually happened. The Dashboard shows whether your food cost and prime cost percentages are trending in the right direction. Restaurant operators who build a habit of monthly model reviews catch cost creep early — a food cost that drifts from 30% to 33% looks small, but at $100,000 monthly revenue that's $3,000 a month in margin loss. Catching it in month one versus month six is the difference between a conversation with your supplier and a serious cash flow problem.

Restaurants fail more often from cash flow problems than from bad food. The challenge is that the business collects revenue in small daily increments — $5 here, $45 there — while expenses come in large periodic hits: a $12,000 rent check on the first of the month, a $8,000 food invoice twice a week, a $22,000 payroll run every two weeks. Without a financial model that maps those cash flows month by month, it's easy to run a profitable restaurant that still runs out of cash. That's the first thing a restaurant financial model solves: showing you the shape of your cash position, not just your profitability.

The second thing it solves is prime cost discipline. Prime cost — food plus labor as a percentage of revenue — is the single number restaurant operators use to gauge whether the business is healthy. For full-service restaurants, the target is below 60–65% of revenue. For fast casual, below 55%. When prime cost creeps up, the problem is almost always in one of two places: food cost percentage drifting because of portioning drift, theft, or supplier price increases, or labor cost climbing because of inefficient scheduling, overtime, or turnover replacing trained staff with new hires. A model that tracks both separately, by category, lets you identify which is causing the problem before it compounds.

For anyone planning a new restaurant, the financial model is also a prerequisite for financing. SBA lenders, private investors, and commercial real estate landlords all expect to see projections showing how the restaurant will perform over 24 months. They want to know the break-even point, the peak cash requirement before the restaurant turns cash-flow positive, and whether the return justifies the investment. A well-structured model built on realistic cover counts and industry-standard cost benchmarks is the difference between getting that conversation and not. This template is structured to produce the outputs a lender or investor expects without requiring you to build it from scratch.