Restaurant Financial Model: Quick-Service Restaurant

Plan counter and kiosk orders, shared kitchen capacity, paid handover, recipe costs and startup cash for an independent quick-service restaurant.

  • Excel (.xlsx)
  • Forecast: 60 monthly periods / five calendar years
  • Starting footprint: 2,000 sq ft / 32 seats
  • Opening schedule: March 2027 / seven days per week
  • Sales unit: Fulfilled order; meal equivalents drive food

Planning several types? Compare 17 restaurant formats

Workbook preview, read-onlyr01
Quick-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 overview

What is inside the Excel model

Plan dine-in and takeaway orders against shared cooking, ordering and paid handover capacity. Connect the meal basket, funded staff and opening investment to five years of monthly cash flow.

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

Inputs you control. Results you can inspect.

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

Inputs and outputs for the quick-service restaurant workbook.
Planning areaInputs you reviewHow they connectResults to inspect
Demand and launch100 dine-in and 150 takeaway requests per mature open day; 65% opening demand.Actual calendar days and a six-month ramp generate channel requests.Requested orders before capacity limits.
Physical capacity10 service hours; 90 meal units/hour; two ordering endpoints.Seat eligibility, kitchen output, ordering and paid handover limit fulfillment.Whole fulfilled orders by channel.
Basket and recipe1.5 meal equivalents/order; $18 net order value; 90% ingredient yield.Meal volume drives ingredient purchases; fulfilled orders earn sales once.Revenue and food costs.
Paid resources10.5 initial FTE; 75% productive cook and handover time.Active roles and start dates create separate resource budgets and payroll.Funded capacity and labor expense.
Opening investment$352,000 initial CAPEX; $15,000 replacement in January 2030.Timed capital spending feeds cash flow and book depreciation.Investment schedule and asset balances.
Liquidity$345,000 equity; $180,000 debt; $75,000 reserve objective.Operating cash, working capital, CAPEX and loan service determine monthly liquidity.Minimum cash and financing exposure.

Is this the right model for your business?

Check the starting case before changing the assumptions.

The starting operation

  • An independent inline restaurant with standardized meals, counter or kiosk ordering and rapid handover.
  • A team evaluating the same kitchen's ability to serve dine-in and takeaway demand without counting its capacity twice.
  • An owner budgeting paid management, a production crew and opening cash before a March 2027 launch.

Check the boundary

The saved case does not include a drive-through, delivery, table service, franchise fees or alcohol sales.

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
Fulfilled dine-in and takeaway orders multiplied by their net basket values.

Meal equivalents drive ingredients; guests drive the dine-in seating limit.

What customers pay for

Customers pay per order; the case models two revenue days of receivables.

What limits sales

  • Dining seats limit dine-in orders before shared resources apply
  • Productive cooks and installed equipment jointly limit meal output
  • Ordering endpoints and paid handover minutes constrain both channels

Costs to plan for

  • Recipe ingredients adjusted for usable yield and meal quantities
  • Packaging and card fees tied to fulfilled orders
  • Paid owner, production cooks, prep and counter staff
  • Rent, benefits, utilities and other recurring operating expenses

Scope and expansion

  • Test additional demand against the tightest shared resource
  • Add funded production or handover capacity before expanding throughput
  • Revise baskets, recipes and capital budgets for the proposed site

What limits a counter-service restaurant after demand is established?

Dine-in seating is only the first gate. In this quick-service design, both channels compete for the same kitchen, ordering and paid handover resources. Extra takeaway demand cannot create additional production minutes. The useful comparison is fulfilled orders per funded resource, with meals per order kept separate from guests and payment transactions.

Ordering
Two endpoints / 1.5 minutes per transaction
Kitchen
90 installed meal units per hour, also capped by productive cooks
Handover
Separate paid counter crew / 1.5 minutes per order

What to establish for your own operation

  1. Measure peak ordering and handover time rather than assuming the daily average will hold.
  2. Confirm meal quantities and recipe yield before changing the average order price.
  3. Test takeaway independently of seats, then reduce the shared cooking and counter budgets.

Follow the plan from demand to cash

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

Follow orders through shared production and handoverRevenue

The starting $18 order contains 1.5 complete-meal equivalents at $12 each. Dine-in and takeaway have the same initial basket, but remain separate order streams. Dine-in alone uses the 32-seat gate, with a 30-minute visit and 1.5 guests per order. Rejected seated demand does not automatically become takeaway demand.

Eligible demand then shares equipment, productive cooks, ordering endpoints and paid handover minutes. A common fulfillment fraction applies to both channels before whole-order rounding. Four production-cook FTE initially support the kitchen; prep and management do not create a second production allowance. Selected throughput is an operating assumption that needs a time study.

  • March demand starts at 65% and reaches 100% in the sixth active month.
  • Ordering and handover each require 1.5 minutes per transaction; they are separate constraints.
  • Zero seats can leave takeaway operating. Zero kitchen or ordering capacity stops both channels.
Connect meal costs with the people who produce themPayroll

The initial recipe costs ($1.65 protein/dairy + $1.10 bread/sides + $0.75 sauces/drinks) divided by 90% usable yield: approximately $3.88889 per meal equivalent, or $5.83333 per order. Yield loss is included once. Packaging is a separate $0.60 per fulfilled order, including the blended dine-in supplies allowance.

Paid staffing starts at 10.5 FTE and reaches 12.2 in 2031. The working owner receives $74,880 annually from January; prep and cooks begin in February. Employer load is 10.65%, with a separate $1,200 monthly welfare budget. Rent/CAM starts at $5,000 per month for the selected footprint. These amounts are planning budgets, not hiring or lease quotations.

  • Salary and recurring expense assumptions grow 3% annually.
  • Card costs use 90% card share, 2.6% of gross tender and $0.15 per paid order.
  • Annual cost shares preserve the existing expense schedules; changing within-year channel economics can approximate monthly unit costs.
Separate the opening asset budget from cash fundingCAPEX

Initial capital is $352,000: $320,000 of base assets plus $32,000 of contingency modeled as spent. The reused-shell fitout is $160,000, with cooking, refrigeration, ventilation, dining fixtures, ordering equipment and other assets separately funded. A $15,000 replacement follows in January 2030. Installed costs require actual bids.

January financing totals $525,000. The $180,000 loan uses assumed 10% fixed interest and 84 monthly annuity payments without grace; its $5,400 fee is an expense. The cash trough without equity, including the loan and its service, is −$269,360. Adding the $75,000 reserve and rounding equity upward to $1,000 produces the $345,000 contribution.

  • The reserve remains cash and is not another opening expense.
  • Receivables are two revenue days, food inventory seven food-cost days and payables zero.
  • Seven-year book depreciation does not represent tax depreciation or equipment resale proceeds.
Read the modeled operating return and cash cushion togetherCF

The Base case produces $1,232,388 of 2027 revenue across 68,466 fulfilled orders. Its $131,219 EBITDA includes the first year's setup period. Revenue totals $9,891,764 across the 60 months, with $2,412,060 EBITDA. Later margins rely on traffic and prices growing faster than the selected labor and overhead budgets.

Monthly EBITDA, EBIT and operating cash first become nonnegative in April 2027 and remain nonnegative. Project payback arrives in October 2028, forecast month 22, when cumulative undiscounted unlevered free cash flow crosses zero. That measure includes startup investment and operating deficits, excludes financing and terminal value, and does not describe an owner distribution.

  • Base minimum funded cash is $75,640 in March 2027.
  • The Low monetary scenario leaves $28,713 minimum cash with Base financing unchanged.
  • Price and cost scenarios do not change physical order counts; test operational demand and staffing separately.

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,232,388USD, Base case; ten sales months after a March opening.
2027 fulfilled orders
68,466Whole dine-in and takeaway orders; not meal portions or diners.
60-month EBITDA
$2,412,060Base cumulative operating result before interest, tax, depreciation and amortization.
Minimum cash
$75,640Base funded monthly balance in March 2027.
Project payback
October 2028 / month 22First cumulative undiscounted unlevered project FCF crossing; no later reversal.
Low-case minimum cash
$28,713Monetary sales/cost stress over 60 months; original financing remains fixed.

Make the case your own

Work from the operating plan toward the cash requirement.

  1. Replace channel demand, opening date and meal basket with the proposed site's evidence.

  2. Match cooking and counter capacity to paid schedules, then test the tightest resource.

  3. Enter installed asset bids, lease costs and loan terms before reviewing minimum cash.

  4. Compare operating break-even, project recovery and downside liquidity as separate decisions.

Interpretation and scope
  • This is an analytical US national case, without a chosen city, lease or confirmed customer demand.
  • Monthly averages and proportional allocation do not simulate queues, individual shifts or a lost-demand backlog.
  • The 25% tax planning rate has no selected jurisdiction and does not carry losses forward.
  • Strong later margins are scenario outputs, not an industry expectation; no shareholder distributions are scheduled.

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 takeaway use dining seats?

No. Its eligible orders bypass seating, then share the kitchen, ordering endpoints and handover staff with dine-in.

Is the $18 value a price per guest?

No. It is the starting net value per order, built from 1.5 meal equivalents at $12 each.

Can another kiosk alone increase sales?

Only if ordering is the binding constraint. Cooking or paid handover may still cap fulfilled orders.

Is owner labor included?

Yes. The working owner/general manager receives $74,880 annual starting pay from January, before the March opening.

Does $352,000 cover all opening cash?

It is initial CAPEX. Total financing is $525,000 and also supports startup expenses, working capital, debt service and retained cash.

Does the Low scenario model fewer physical orders?

No. It applies monetary sales and cost factors. Physical demand and capacity must be tested with their own operating inputs.

Does month-22 payback mean cash is paid to the owner?

No. It is cumulative project free cash flow recovery. The case schedules no shareholder distributions.

What if a purchased file is damaged or cannot be downloaded?

See the refund and replacement policy for file correction, replacement and download assistance. Keep the product name and your order reference when requesting help.

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

User-selected analytical restaurant configuration. No direct operator source was assigned; formulas and capacity assumptions are specifications rather than verified market facts.

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-06, 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.