Restaurant Business Plan Financial Model in Excel: Startup Costs, Sales Forecast and 3-Year P&L

A restaurant business plan financial model is an Excel spreadsheet that turns your concept into three linked forecasts: a startup cost budget, a sales forecast built from seats, turns and average check, and a 3-year P&L that shows when the restaurant breaks even. Lenders, landlords and investors use it to judge whether the unit economics hold up before they put money in.

As of November 2026. Figures below are dated to their sources.

Key facts

Fact	Value	Source	As of
Median independent restaurant startup cost (RestaurantOwner.com survey)	$375,000	prnewswire.com	2018-11-15
Median startup cost per square foot	$113 per square foot	prnewswire.com	2018-11-15
Median startup cost per seat	$3,586 per seat	prnewswire.com	2018-11-15
NRA projected 2025 traditional restaurant sales and growth	over $1.1 trillion in 2025, up 4.1% year over year	restaurantdive.com	2025-02-06
CAVA fiscal 2024 restaurant-level profit margin	25.0%	sec.gov	2024-12-29
CAVA fiscal 2024 average unit volume	$2.9 million	sec.gov	2024-12-29

This step by step guide covers how to build a restaurant business plan financial model in Excel. You will set the startup budget against survey data, build a driver-based sales forecast, and check your P&L ratios against what public operators such as CAVA actually report. Every benchmark below comes from a named source, so you can defend each assumption when a banker asks where it came from.

Why a Restaurant Business Plan Financial Model Matters More Than the Concept Deck

The industry is huge, but each restaurant earns thin margins. The National Restaurant Association's 2025 State of the Restaurant Industry report projected traditional restaurant sales of over $1.1 trillion in 2025, up 4.1% year over year, according to Restaurant Dive's February 6, 2025 coverage. The same report found that over one-third of operators said their restaurants were not profitable in 2024, and over half still carried pandemic-era debt. Industry growth will not cover a weak build budget or optimistic covers.

Underwriters read a restaurant model for three answers:

How much cash do you need to open, and to survive the ramp? Build cost plus pre-opening plus working capital, not build cost alone.
Is the sales forecast physically possible? Seats, turns and check size have to fit the room and the hours you will be open.
What is left after prime cost and rent? Restaurant-level profit is the number that pays your debt service.

Takeaway: Before you open Excel, write down the three numbers a lender will test first: total capital required, Year 2 sales, and restaurant-level margin. Every tab you build should feed one of them.

Startup Costs: Building the Capital Budget Tab

The most widely cited dataset on independent restaurant build costs is still the RestaurantOwner.com survey of over 350 independent owners, released on November 15, 2018 via PR Newswire. It reported a median startup cost of $375,000, or $113 per square foot and $3,586 per seat. For a ground-up build excluding real estate, the median was $650,000. The data is now several years old and construction costs have risen since then, so treat these figures as a floor and add an inflation adjustment line in your model.

How to structure the startup cost tab, step by step

Leasehold improvements. Construction, MEP (mechanical, electrical, plumbing), hood and fire suppression, ADA restrooms. Net out any tenant improvement allowance from the landlord on a separate line so the lender can see gross and net.
Kitchen and bar equipment. List each item with quantity and unit price. Flag whether it is bought outright or leased, because leased equipment moves from capex to operating expense.
FF&E and technology. Furniture, smallwares, POS hardware, signage.
Soft costs. Architect, permits, licenses (a liquor license can be the largest single soft cost in some cities), legal and design.
Pre-opening expenses. Training payroll, opening inventory, marketing, and rent paid during build-out.
Working capital reserve. Fund at least three to six months of fixed costs. This line keeps the restaurant open while sales ramp.
Contingency. Add 10% to 15% on top of hard costs. Build-outs almost always run over budget.

Worked example: sanity-checking a 60-seat bistro

Take a 60-seat, 2,800-square-foot neighborhood bistro. At the survey median of $113 per square foot, the build lands near $316,400. At $3,586 per seat, it comes to about $215,160. If your bottom-up line items total $550,000, you are well above the 2018 median. That can be justified (a second-generation space with no hood, a high-cost city, eight years of construction inflation), but the model should state the reason in a note next to the cell.

Takeaway: Build the budget bottom-up, then add two check cells that divide total cost by square feet and by seats. If either check is far from the benchmark, either write down why or cut scope before you sign the lease.

Sales Forecast: Seats, Turns and Average Check

A credible restaurant sales forecast never starts with "we will do $1.2 million." It starts with the room. The core formula for each daypart is:

Daily revenue = Seats x Table turns x Average check per cover

Run that separately for each daypart and channel, then multiply by operating days.

Example: building the forecast in the spreadsheet model

Dinner: 60 seats x 1.2 turns x $42 check = $3,024 per day
Lunch: 60 seats x 0.6 turns x $20 check = $720 per day
Daily total: $3,744
Annual run-rate: $3,744 x 312 days (six days a week) = $1,168,128

Add takeout and delivery as separate lines with their own check size and their own cost structure, since third-party commissions belong in operating expenses. Delivery is a real channel. In the NRA's 2025 research, 82% of consumers said they planned to order delivery that year (Restaurant Dive, February 6, 2025).

Model the ramp, not just the run-rate

New restaurants rarely open at full volume. Build a monthly ramp curve on the forecast tab, for example 60% of run-rate in month one, 75% in month two, 85% in month three, reaching 95% to 100% by month six. On the example above, that ramp puts Year 1 sales at roughly $990,000 rather than the $1.17 million run-rate. The $180,000 gap is the reason the working capital reserve exists.

Seasonality goes on top. Apply a monthly index (January at 0.85, December at 1.15, and so on) so that cash flow troughs show up in the right months.

Takeaway: Put seats, turns, check and days in clearly marked blue input cells. When a lender pushes back, you change one driver and the whole model updates, instead of defending a single top-line number.

The 3-Year P&L: Benchmarking Against Real Operators

Once sales are set, the restaurant business plan financial model builds the P&L as percentages of revenue. The structure that public restaurant companies use, and that lenders recognize, runs from sales down to restaurant-level profit and then to EBITDA.

Prime cost: the first ratio anyone checks

Prime cost is cost of goods sold plus total labor. Restaurant365 puts the target for full-service restaurants below 65% of total sales and for quick-service and fast-casual concepts at about 60% or lower, because they need less labor. If your Year 2 prime cost comes in above those lines, the model is telling you to re-price the menu or redesign the labor schedule before opening.

A public benchmark: CAVA's fiscal 2024 unit economics

CAVA's fourth quarter and fiscal 2024 earnings release, filed with the SEC on February 25, 2025, gives a clean, audited-company look at fast-casual restaurant economics. For the fiscal year ended December 29, 2024:

Food, beverage and packaging: 29.3% of restaurant revenue
Labor: 25.9%
Occupancy: 7.3%
Other operating expenses: 12.5%
Restaurant-level profit margin: 25.0%
Average unit volume (AUV): $2.9 million

CAVA's prime cost works out to 55.2%, comfortably under the fast-casual benchmark, and its $2.9 million AUV spreads occupancy over a large sales base. An independent bistro will not hit those numbers. CAVA buys at scale and runs a limited-labor assembly line. It is still a useful ceiling. If your model shows a 28% restaurant-level margin for a first-time independent operator, a lender will assume you made a mistake.

Example 3-year P&L for the 60-seat bistro

Using the forecast above, with 3% annual menu price increases from Year 2 onward:

Sales: Year 1 $990,000; Year 2 $1,203,000; Year 3 $1,239,000
COGS at 31% / 30% / 30%: Year 1 runs higher because of waste while the menu settles
Labor at 36% / 32% / 31%: Year 1 carries training and overstaffing during the ramp
Occupancy: fixed rent of $96,000 a year plus CAM, which is about 9.7% of Year 1 sales and 8.0% of Year 2
Other operating expenses: 12% to 13% (utilities, repairs, card fees, marketing, delivery commissions)

On those inputs, Year 1 prime cost is 67% and restaurant-level margin is close to 10%, which is thin but typical of an opening year. By Year 2, prime cost falls to 62% and restaurant-level margin rises to around 17% to 18%. That gap between Year 1 and Year 2 is the main story the model has to tell. Below restaurant-level profit, deduct owner or GM salary if not already in labor, then G&A, depreciation on the build-out (typically straight-line over the lease term), and interest on the SBA or bank loan.

Takeaway: Show every P&L line both as dollars and as a percentage of sales, side by side with a benchmark column (CAVA, Restaurant365's prime cost targets, or your own comparable set). Reviewers spot outliers in seconds when the comparison sits right next to the figure.

Break-Even, Cash Flow and Stress Tests in Your Excel Template

The P&L shows profitability. The cash flow tab shows survival. Link them with these steps:

Calculate monthly break-even sales. Fixed costs (rent, salaried management, insurance, loan payments) divided by contribution margin (1 minus COGS% minus hourly labor% minus variable opex%). For the bistro, about $46,000 in monthly fixed costs at a 40% contribution margin gives a break-even of roughly $115,000 a month, or about $4,400 per operating day.
Convert break-even to covers. At a blended $35 check, that is about 126 covers a day. Ask whether 60 seats can do that on a slow night in February.
Build the monthly cash flow. Start with opening cash from the capital budget, subtract pre-opening spend, then add monthly net income, add back depreciation, and subtract debt principal.
Run three scenarios. Base case, downside (turns down 20%, food cost up 2 points), and upside. Use a scenario switch cell so the whole workbook flips with one input.
Find the cash low point. The lowest monthly cash balance across all three scenarios is the minimum reserve you should raise.

The NRA data supports the downside case: 61% of operators reported traffic declines between 2023 and 2024, and 48% expected competition to increase in 2025 (Restaurant Dive, February 6, 2025). A model that only works in the base case is a weak model.

Takeaway: If the downside scenario runs out of cash before month 12, raise more capital, sign a cheaper lease, or shrink the build. Fix it in the spreadsheet before you fix it with a personal credit card.

Conclusion: Start From a Built Template, Then Make It Yours

A lender-ready restaurant model links five tabs: startup costs, a driver-based sales forecast with a ramp, a 3-year P&L benchmarked line by line, break-even analysis, and a monthly cash flow with scenarios. Building that from a blank workbook takes a first-time founder weeks, and broken links between tabs are the most common error bankers find. A ready-made Excel template gives you the structure, formulas and check cells on day one, so your time goes into the inputs that matter: your rent, your menu prices, your labor schedule. Plug in your numbers, test them against the $113 per square foot and 60% to 65% prime cost benchmarks, and walk into the bank meeting with a model that answers the questions before anyone asks them.