Restaurant Financial Model: Fixed-Menu Session Restaurant

Plan scheduled sittings, synchronized courses, attendance, no-show food costs and optional pairings for a fixed-menu restaurant.

  • Excel (.xlsx)
  • Room: 1,800 sq ft / 32 seats
  • Offer: Five courses / $125 starting menu
  • Schedule: Two evening sessions Wednesday–Sunday
  • Opening: March 2027 / 60-month financial forecast

Planning several types? Compare 17 restaurant formats

Workbook preview, read-onlyr01
Fixed-Menu Session 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

Test scheduled sittings against dining seats, course-release timing and funded service labor. Follow accepted bookings, attendance and optional pairings through ingredients, investment and monthly cash.

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

Inputs you control. Results you can inspect.

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

Inputs and outputs for the fixed-menu session restaurant workbook.
Planning areaInputs you reviewHow they connectResults to inspect
Session demand24 early and 28 late mature paid requests; one free request per session.Actual operating days and a 60% opening ramp generate separate sitting demand.Requested paid and complimentary bookings.
Timing150 dining minutes plus 15 reset; six-hour window; five 25-minute courses.Session and course schedules must fit the offered service window.Valid one- or two-session operation.
Capacity32 seats; 40 kitchen covers/course; three plating positions.Seats, course release and equally allocated kitchen/service labor limit bookings.Accepted bookings per sitting.
Attendance and pairings96% paid attendance; 35% pairing uptake; $35 pairing.Whole-cover attendance earns menus; beverage minutes cap pairings.Served paid covers and separately priced pairing units.
Recipe and labor$26 edible five-course basket; 90% yield; 9.6 initial FTE.All accepted menus consume food, including complimentary and no-show bookings.Ingredient purchases, waste and funded service capacity.
Startup and funding$348,920 initial CAPEX; $366,000 equity; $160,000 loan.Cash flow covers opening spending, startup deficits, settlement and loan service.Reserve, operating milestones and project recovery.

Is this the right model for your business?

Check the starting case before changing the assumptions.

The starting operation

  • An independent restaurant selling a complete fixed menu in scheduled sittings.
  • A team assessing synchronized preparation, plating and service instead of continuous table turns.
  • An operator separating reservations, actual attendance, no-show food waste and optional nonalcoholic pairings.

Check the boundary

The saved case does not include prepaid tickets, deposits, cancellation fees, alcohol, tips, delivery or extra service-charge revenue.

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
Served paid guests earn one complete-menu price, with optional paid nonalcoholic pairings.

Courses are included in the menu. Pairings add sales without adding guests or seats.

What customers pay for

Customers pay after service; there are no prepaid tickets, deposits or no-show fees.

What limits sales

  • Session and course schedules must fit the offered service window
  • Seats and synchronized kitchen or plating release cap each sitting
  • Paid kitchen and dining-service budgets are divided between sittings
  • Beverage preparation minutes separately limit optional pairing sales

Costs to plan for

  • Ingredients for accepted bookings, including free guests and no-shows
  • Preparation yield losses and ingredients for sold beverage pairings
  • Paid owner, chefs, brigade, dining service and support staff
  • Served-guest consumables, card fees and recurring premises expenses

Scope and expansion

  • Test reservation demand, attendance and premium menu prices together
  • Validate course-release timing before increasing seats or scheduled sittings
  • Fund kitchen, service and beverage labor for the proposed schedule

What limits a restaurant that releases the same courses to a whole sitting?

A daily cooking total is insufficient. Every course must pass the kitchen and plating line inside a release window, while the complete sequence and reset must fit the session. This design limits bookings by those synchronized constraints, then distinguishes accepted reservations from guests who attend. No-shows still consume prepared-menu ingredients under the selected policy.

Release window
Three plating positions × 12 minutes / one minute per plate = 36 covers
Session schedule
150 dining minutes + 15 reset minutes
Attendance
96% paid factor, rounded down separately per sitting

What to establish for your own operation

  1. Run a full course-release time study rather than relying only on daily kitchen output.
  2. Validate attendance and premium-price demand with actual booking evidence.
  3. Keep pairings, menus, guests and prepaid cash as separate concepts; this case has no prepayment.

Follow the plan from demand to cash

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

Keep booking, attendance and earned revenue separateRevenue

Two scheduled sessions each use 150 dining minutes plus 15 reset minutes inside a six-hour window. Five 25-minute courses fit the sitting. A booking limit takes the lowest of 32 seats, 40 installed kitchen covers per course, 36 plating-release covers and funded kitchen/service budgets allocated equally across the offered sessions.

Paid and complimentary requests share that limit proportionally. Accepted paid bookings then receive a 96% attendance factor and round down per sitting. Only served paid covers earn the $125 starting menu price. Optional $35 nonalcoholic pairings are a subset of served paid guests, constrained by beverage labor. They do not add seats or guests.

  • Unused capacity in one session is not automatically reassigned to the other.
  • One enabled session admits early demand only; zero sessions stop service.
  • Payment is after service. No prepaid ticket or deposit revenue is counted.
Count ingredients for every accepted bookingPayroll

The five-course edible basket is $4 starter, $6 fish, $10 main, $1 palate course and $5 dessert: $26 total. Dividing by 90% usable yield gives $28.8889 raw ingredients per accepted menu. Food is prepared for both regular and complimentary bookings, including no-shows that earn no menu revenue. Preparation loss and discarded no-show menus are measured separately without charging either twice.

The starting 9.6 paid FTE includes the owner, executive chef, kitchen brigade, preparation/pastry cook, dining service, beverage preparation, dishwashing and relief. Owner salary is $74,880 from January. Chef and kitchen preparation start in February; guest service starts in March. Employer load is 10.65%, with a separate $1,500 monthly welfare pool.

  • Each sold pairing uses an $8 ingredient allowance; each served guest uses $1.50 consumables.
  • Initial rent/CAM is $4,500/month; full wages are paid without tip credit.
  • Annual cost shares reconcile yearly totals but can alter monthly costs; maximum Base ingredient allocation difference is $655.65.
Fund the synchronized service setup and reserveCAPEX

Initial CAPEX is $348,920: $317,200 base assets plus $31,720 spent contingency. It includes a $144,000 reused-shell fitout, cooking, a three-position plating/pass setup, refrigeration, ventilation, warewashing and courseware. January 2030 adds $15,000 replacement spending. Actual installed prices and service performance need confirmation.

The financing package is $526,000 in January: $366,000 equity and a $160,000 loan at assumed 10% fixed interest over 84 monthly annuity payments, without grace. The $4,800 fee is expensed. Cash without owner equity reaches −$285,027. Adding an $80,000 retained reserve and rounding upward produces the equity requirement; costs in the trough are not added again.

  • Minimum funded cash is $80,973 in March 2027.
  • Receivables use two days, food inventory seven days and payables zero.
  • Book depreciation uses seven years; terminal valuation is excluded from project payback and cash ROI.
Interpret the premium-price result without confusing unitsCF

Base 2027 revenue is $1,281,435 from 9,365 paid dining covers and 3,166 pairings. Total served guests are 9,801 after complimentary attendance. The 12,531 sold menu-and-pairing units used by the financial report are therefore not a guest count. Base 2027 EBITDA is $268,697.

Monthly EBITDA, EBIT and operating cash first become and remain nonnegative in April 2027. Project payback is April 2028, month 16, without later reversal. The 60-month simple project cash ROI is 500.3%: $2,186,630 net unlevered project FCF divided by $437,059 absolute negative monthly project FCF. This strong scenario depends on the premium tariff, recipe budget and productive time.

  • The project measure is undiscounted and nonannualized; it excludes financing and terminal sale proceeds.
  • Low monetary stress has $58,615 minimum cash, below the $80,000 reserve objective.
  • No shareholder distributions are scheduled; retained business cash is not a realized investor return.

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,281,435USD, Base; delivered menus and paid pairings after March opening.
2027 paid dining covers
9,365Served paid diners; separate from 3,166 pairings and 436 complimentary guests.
2027 EBITDA
$268,697Base operating result before interest, tax, depreciation and amortization, including setup months.
Minimum cash
$80,973Funded Base monthly balance in March 2027.
Project payback
April 2028 / month 16Cumulative undiscounted unlevered project FCF recovery from January 2027.
Low-case minimum cash
$58,615Monetary stress with fixed funding and physical sessions; below the selected $80,000 reserve.

Make the case your own

Work from the operating plan toward the cash requirement.

  1. Enter the actual menu, offered sessions, service window and expected reservations.

  2. Validate preparation, plating, dining-service and beverage time budgets against paid staff.

  3. Update recipe costs, attendance, installed assets and premises expenses.

  4. Review discarded no-show menus, monthly reserve coverage and cumulative project cash recovery.

Interpretation and scope
  • The national case is not a local booking study or an operator's actual financial performance.
  • Representative monthly service days and equal labor allocation omit party-to-table packing and peak variation.
  • Whole-cover rounding can reduce realized attendance below 96% and round a small complimentary allocation to zero.
  • Annual expense allocation affects monthly margins, working capital and exact break-even timing. The 25% tax rate has no chosen jurisdiction or loss carryforward.

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

Are the five courses five separate sales?

No. A served paid guest earns one complete-menu price. Pairings are the only separately priced addition in the saved offer.

Are reservations prepaid?

No. Payment follows service, with two receivable days approximating settlement. Deposits and unearned ticket revenue are absent.

Why do no-shows still cost food?

The kitchen prepares a complete menu for every accepted booking. A no-show menu is discarded and earns no menu sale.

Can unused early-session labor be moved to the late session?

Not automatically. The case divides paid kitchen and service capacity equally across offered sittings.

Does 96% attendance mean exactly 96% of annual bookings attend?

No. The percentage applies to each sitting and rounds down to whole covers, which can reduce realized attendance further.

Why are sold units higher than paid guest counts?

The financial product-volume total combines menus and pairings. A guest buying a pairing is still one diner occupying one seat.

Does the high cash ROI establish an achievable return?

No. It is an undiscounted model output driven by selected premium pricing and productivity. Validate those inputs; no shareholder payout is scheduled.

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

Primary operator examples support only the operating features described in the source registry. This full configuration, all formulas, local feasibility and numerical economics remain analyst-authored and unverified.

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-10, revision r01, 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.