Restaurant Financial Model: Full-Service Restaurant

Plan an 80-seat restaurant in Excel, connecting lunch and dinner demand to seats, funded labor, startup investment, and 60 months of cash flow.

  • Excel (.xlsx)
  • Forecast: 60 months · 5 years
  • Starting case: 80 seats · 3,000 sq. ft.
  • Display: English · USD

Planning several types? Compare 17 restaurant formats

Workbook preview, read-onlyr03
Full-Service Restaurant workbook: dashboard.
Dashboard

Base-case scenario controls, annual financial results and charts for 2027–2031. Financial report amounts are shown in thousands of USD; percentage measures retain their own units.

Enlarge image in a new tab

8 selected worksheet views. Figures show this workbook’s starting case.

Workbook availability

What is inside the Excel model

See whether a seated lunch-and-dinner operation can support its staffing and recover its opening investment. This workbook follows guests from practical service capacity through operating costs, financing, and cash.

Selected worksheets from the documented workbook. Forecast period: January 2027–December 2031. Model reference: PHY001-01.

Inputs you control. Results you can inspect.

On a small screen, scroll within the table to read every column.

Inputs and outputs for the full-service restaurant workbook.
Planning areaInputs you reviewHow they connectResults to inspect
Demand and serviceOpen weekdays, requests per lunch and dinner, opening ramp, and net spend per guest.Calendar trading days and served guests, capped by each service resource.Monthly guest volumes and sales; annual revenue.
Practical capacitySeats, usable-seat factor, service length, dwell time, equipment throughput, productive cook and server hours.The lowest demand or capacity limit controls served guests. Shared labor hours are allocated once.Capacity-constrained sales rather than unlimited demand conversion.
StaffingRole-level FTE, pay, start dates, payroll load, and annual raises.Paid labor cost and funded productive hours.Payroll, labor intensity, and kitchen/service capacity.
Operating costsFood-sales ratios, card and linen costs, employer tip tax, rent, benefits, and dated expense lines.Variable costs follow sales; monthly and one-time expenses follow their schedules.Income statement, margins, and operating cash flow.
Investment and fundingOpening and replacement CAPEX, receivable/inventory days, equity, loan terms, and tax rate.Investment timing, working capital, debt service, and funded cash balances.Cash trough, year-end debt, and project capital recovery.
Scenario reviewLow/Base/High money multipliers and separately editable operating drivers.Financial scenarios change revenue or cost amounts; physical capacity changes require operating-input edits.Scenario cash gaps and financial results without automatic extra funding.

Is this the right model for your business?

Check the starting case before changing the assumptions.

The starting operation

  • One alcohol-free, casual restaurant in the United States, using an existing fitted shell.
  • 80 seats across a 3,000-square-foot site, open Tuesday through Sunday for lunch and dinner.
  • A March 2027 opening after two pre-opening months, with paid owner/manager labor and separate kitchen and service teams.

Check the boundary

A bar-led concept, delivery kitchen, caterer, or multi-location rollout requires a different operating structure. Those revenue streams are not included in this case.

Compare the other restaurant types

How this business makes money

Connect the unit sold to the resources required by this operating case.

Analysis

Revenue logic
Revenue = guests served × net spend per guest.

Lunch and dinner are limited by seating, equipment and funded staff. Sales exclude tax, tips and alcohol.

What customers pay for

Dine-in meals and nonalcoholic drinks, priced per guest.

What limits sales

  • Guest demand and usable seat turns.
  • Kitchen equipment and productive cook hours.
  • Productive server hours within each service window.

Costs to plan for

  • Food and drinks: a percentage of sales.
  • Kitchen, service and paid owner/manager labor.
  • Rent, utilities, insurance and other operating expenses.
  • Card fees, linen/consumables and employer tax on tips.
  • Equipment, working capital and debt use separate schedules.

Scope and expansion

  • This case covers dine-in service only.
  • Delivery, catering or alcohol need separate operating assumptions.
  • Count shared staff, premises and equipment once.

Why does a full-service restaurant need two labor-capacity checks?

A seated guest consumes both kitchen production and table-service time. Filling more seats cannot increase served volume once either the funded kitchen team or the funded service team becomes the binding limit. This case therefore constrains each meal service by demand, seat turns, equipment, cooks, and servers before applying guest spend.

Unit sold
A served guest, priced separately for lunch and dinner.
Service footprint
80 seats; 3-hour lunch and 4.5-hour dinner; Tuesday–Sunday.
Revenue boundary
Dine-in food and nonalcoholic beverages; no delivery, catering, or alcohol.
Resource coupling
Funded cook and server hours are shared once across non-overlapping services.

What to establish for your own operation

  1. Observe requested guests by service and day before selecting the opening ramp.
  2. Test the actual menu against kitchen output and table-service work.
  3. Price the fitted shell, lease, deposits, and local opening requirements.
  4. Stress cash with realistic staffing and slower demand; do not infer capital recovery from one profitable month.

Follow the plan from demand to cash

Open each section for the assumptions, calculations, and limits of this workbook’s starting case.

Turn guest demand into a serviceable planRevenue

The starting case requests 80 lunch guests and 120 dinner guests per open day, rising to 94 and 140 by the fifth year. Opening demand ramps from 60% to 100% over six months. These are selected planning inputs, not measured traffic for a particular address.

Served guests are the minimum of demand, usable seat turns, equipment throughput, funded kitchen labor, and funded service labor. Lunch has a three-hour service and 60-minute dwell; dinner has 4.5 hours and 90-minute dwell. An 85% usable-seat factor allows for imperfect seating. Productive cook and server hours are allocated once across the two services.

Net spend starts at $24 for lunch and $34 for dinner, with approximately 3% annual escalation. Sales exclude sales tax, voluntary tips, and alcohol. No national seasonal pattern is imposed: calendar demand multipliers start at 1.00.

  • Equipment is assumed to process 40 guests per hour; that throughput is an engineering assumption.
  • Kitchen productivity is 14 guests per productive cook hour, with 75% of paid hours productive. Service is 10 guests per productive server hour, with 90% productive.
  • Change labor and capacity alongside demand before interpreting a sales increase as feasible.
Budget the people required to deliver the servicePayroll

The funded team reaches 16.1 FTE: an owner/general manager, head chef, line and preparation cooks, dishwashers, servers, and hosts. Hiring starts across January, February, and March 2027. The owner receives compensation; servers receive a full employer-funded wage plus voluntary tips.

Employer load is 10.65% and pay increases 3% annually. Employee health and welfare are separate fixed expenses. Paid hours are based on 2,080 hours per FTE per year, while only the specified productive share contributes to capacity.

Food and nonalcoholic beverage costs are 32% of net sales. This is a sales-based cost schedule, not a recipe and yield model. Variable expenses include 3.05% card processing, 0.9% linen/consumables, and 1.377% employer FICA on tips. Rent/CAM starts at $7,500 per month for the selected site.

  • The rent allowance is not a restaurant lease quote and includes no refundable deposit.
  • Fixed costs include utilities, maintenance, insurance, software, marketing, administration, cleaning, benefits, and permit renewals.
  • Sales-based food cost increases when selling prices increase; it does not hold ingredient cost per guest constant.
Separate opening works from retained cashCAPEX

Initial capital spending totals $442,200. It assumes a reusable fitted shell, including $240,000 for dining/kitchen fitout plus kitchen equipment, ventilation, refrigeration, furniture, smallwares, technology, signage, and professional work.

The initial total includes a $40,200 build contingency, calculated as 10% of $402,000 of other opening uses. That allowance is spent CAPEX in this case. A separate $15,000 equipment replacement occurs in January 2030, taking 60-month CAPEX to $457,200.

Funding arrives in January 2027: $517,000 of owner equity and $200,000 of debt. The loan assumes 10% fixed annual interest and 84 monthly annuity payments with no grace period. These are selected terms, not a lender commitment. Seven-year book depreciation starts as spending occurs and is not a tax depreciation schedule.

  • Operating losses, interest, and working capital are included in the cash forecast; adding them again to the cash trough would duplicate them.
  • A $90,000 retained-cash target is distinct from the build contingency.
  • Equity and debt remain fixed inputs after changes. Recheck the cash requirement when the case changes.
Read cash, operating break-even, and payback separatelyCF

Base-case 2027 revenue is $1,384,320 across ten operating months, while EBITDA is negative $58,843. The first year includes pre-opening activity. By 2028, a full operating year, revenue is $2,089,293 and EBITDA is $280,830. These are modeled outputs, not expected returns for another restaurant.

With the selected debt and debt service but without equity, cash reaches negative $426,186 in June 2027. Adding $517,000 of equity produces a funded minimum cash balance of $90,814. Working capital assumes two receivable days, seven inventory days, and zero payable days.

Operating break-even is July 2027, the first active month with nonnegative EBITDA, EBIT, and operating cash flow, sustained thereafter in Base. Project payback occurs in February 2030 when cumulative undiscounted unlevered free cash flow crosses zero. Counting starts in January 2027, includes opening and replacement investment, and uses whole months. Shareholder distributions are zero, so this is not realized owner payback.

The Low money scenario has minimum cash of negative $220,200 and 60-month EBITDA of negative $237,604. The same funding does not cover that scenario. Financial multipliers are sensitivity tests, not probabilities or changes to physical guest demand.

  • Unlevered project free cash flow excludes interest, financing flows, and terminal-sale proceeds; operating cash flow includes interest.
  • The six KPI groups cover net guest spend, sales per paid hour, food cost, labor and benefits, occupancy, and pretax margin.
  • The 2031 pretax margin of 14.2% is an ambitious case supported by rising traffic/prices with broadly fixed staffing, not a typical restaurant margin.

Selected results from the starting case

Modeled results in USD unless stated otherwise. These describe the selected inputs, not an estimate for your location or a guaranteed outcome.

Modeled case
2027 revenue
$1,384,320Base · USD · ten operating months after a March opening.
2027 EBITDA
−$58,843Base · USD · includes two pre-opening months.
Initial CAPEX
$442,200USD · includes the $40,200 spent contingency.
Minimum funded cash
$90,814Base · June 2027 · after $517,000 equity and $200,000 debt.
Operating break-even
July 2027Base · month 7 · EBITDA, EBIT, and operating cash flow nonnegative.
Project payback
February 2030Base · month 38 · cumulative undiscounted unlevered FCF from January 2027.

Make the case your own

Work from the operating plan toward the cash requirement.

  1. Confirm the seated-service scope and replace the calendar, opening date, guest requests, and net spend with your operating case.

  2. Set practical seats, equipment output, service times, and funded staff together. Check that paid and productive hours are not confused.

  3. Replace rent, wages, food ratios, fixed costs, and installed CAPEX with evidence for the intended site and specification.

  4. Review monthly cash, debt service, and the Low case. Resize fixed funding if necessary, then compare operating break-even with unlevered project payback.

Interpretation and scope
  • The U.S. national research case is not an observed average, premises approval, lease quotation, or local demand study.
  • A 25% blended planning tax rate is used without a selected state or loss carryforwards.
  • Food costs follow sales percentages rather than recipe quantities; money scenarios do not change physical capacity.
  • No alcohol, delivery, catering, lease deposit, shareholder distribution, or exit proceeds are included.
  • Software compatibility, license, support, and update terms must be confirmed for a future purchase; none is implied by the Excel file format.

The workbook is an Excel file for local planning. Learn how to interpret assumptions and evidence.

Each operating type calls for its own financial structure.

Compare all 17

Questions

Does increasing lunch demand always increase sales?

No. Revenue uses guests served after seat, equipment, kitchen, and service labor limits. A higher request count has no effect when another resource is already binding.

Is owner labor included?

Yes. The owner/general manager is one paid FTE starting in January 2027 at $78,000 annual base pay before the modeled load and future raises.

Does the food budget track recipes?

No. Food and nonalcoholic beverage COGS starts at 32% of net sales, split into four purchasing groups. It does not calculate recipe yields or waste per dish.

Is the $442,200 opening investment the entire funding need?

No. It is initial CAPEX. The cash forecast also includes pre-opening expenses, trading deficits, debt service, and working capital. Base funding is $717,000, including a separate retained-cash reserve.

Does February 2030 payback mean the owner receives the investment back?

No. It is project recovery measured by cumulative unlevered free cash flow. The case has zero shareholder distributions, and loan payments follow a separate schedule.

Will funding resize itself in the Low scenario?

No. Equity and debt are fixed inputs. Low minimum cash is negative $220,200, identifying a funding gap that requires a revised operating or financing plan.

Can I use this case for a restaurant with a bar?

The starting model excludes alcohol. Bar sales, inventory, service, equipment, and licensing would require a separately justified operating adaptation.

Are these numbers an estimate for my location?

They describe one researched national planning case. Replace traffic, wages, installed costs, lease terms, and local requirements before drawing conclusions about a specific site.

Can I buy this model now?

No. Purchasing and workbook downloads are not available on this site.

Which software does the workbook use?

The documented file is an Excel workbook (.xlsx). Compatibility with other spreadsheet applications is not established by the file extension.

Evidence and scope

A related category or operator is referenced. Do not interpret the link as independent proof of this exact configuration or its viability.

The links below provide operating-format context; they do not verify the workbook’s selected inputs or calculated returns.

The workbook guide and figures describe model PHY001-01, revision r03, for January 2027–December 2031. These are a documented planning case, not observed results for a particular business.

Read our methodology and how to read financial assumptions.