Restaurant Financial Model: Counter-Service Takeout Restaurant
Plan a pickup restaurant with individual and family orders, shared kitchen and counter capacity, startup funding, and five-year cash flow.
- Excel (.xlsx)
- Forecast: 60 months · five calendar years
- Starting format: 1,700 sq ft · counter pickup
- Model inputs: English · USD · Base scenario
Planning several types? Compare 17 restaurant formats
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
Order demand, counter-service throughput and average order value assumptions with annual sales results. Monetary inputs and sales use USD; operating volumes retain their labelled units. Forecast years are 2027–2031.
Enlarge image in a new tab
Food and other direct-cost categories, variable expense shares and fixed operating expenses. Monetary inputs are USD; the annual percentage columns are cost shares of revenue.
Enlarge image in a new tab
Monthly income statement for 2027–2031, in USD. This is an income statement view; it does not show payroll setup inputs. Enlarge to inspect the wide monthly table.
Enlarge image in a new tab
Asset categories, purchase dates and spending assumptions in USD. The total includes every scheduled purchase shown, including later replacements where present.
Enlarge image in a new tab
Excerpt from Returns: cumulative project free cash flow and first payback, if reached. 2027–2031 base case; dollar amounts in thousands.
Open full Returns view in a new tabExcerpt from Returns: revenue, annual and monthly break-even revenue, and EBITDA. 2027–2031 base case; dollar amounts in thousands.
Open full Returns view in a new tab
Six annual financial-driver charts for Counter-Service Takeout Restaurant, 2027–2031 (Base scenario). Dollar amounts are in thousands; margins and cost mix are percentages.
Enlarge image in a new tab8 selected worksheet views. Figures show this workbook’s starting case.
Workbook availability
What is inside the Excel model
Build a pickup-first plan around the work each order creates. This Excel model connects individual and family orders to funded kitchen and counter hours, then carries the fulfilled volume through costs, investment and cash. Its starting case is a researched U.S. national planning scenario, not a local quotation or promised forecast.
Selected worksheets from the documented workbook. Forecast period: January 2027–December 2031. Model reference: PHY001-02.
Inputs you control. Results you can inspect.
On a small screen, scroll within the table to read every column.
| Planning area | Inputs you review | How they connect | Results to inspect |
|---|---|---|---|
| Order demand | Individual and family requests, weekday switches, opening date and ramp. | Calendar demand is limited by shared kitchen and counter workload. | Fulfilled orders and unmet demand. |
| Pricing and mix | Net order values, family workload and prepaid share. | Fulfilled orders earn their own basket values; prepaid orders use less counter time. | Revenue by order type. |
| Paid capacity | Cook and counter FTE, pay, productive shares and throughput. | Funded hours constrain production and handoff separately. | Payroll and practical fulfillment limits. |
| Operating costs | Food, payment and packaging shares; fixed expenses and start dates. | Sales-linked expenses combine with scheduled overhead. | Gross profit and operating earnings. |
| Opening investment | Fitout, equipment, contingency and replacement timing. | Capital spending and book depreciation follow their schedules. | CAPEX and financial statements. |
| Cash and finance | Receivable and inventory days, equity, debt and tax rate. | Monthly cash includes losses, working capital and debt service. | Cash trough, funding needs and project payback. |
Is this the right model for your business?
Check the starting case before changing the assumptions.
The starting operation
- One independent 1,700-square-foot pickup restaurant opening in March 2027.
- Individual complete-meal orders and larger family orders using the same kitchen and pickup counter.
- An owner who needs to test order mix, prepaid pickup, staffing and funding together.
Check the boundary
The starting case excludes dining seats, table service, third-party delivery, franchise royalties and alcohol.
Compare the other restaurant typesHow this business makes money
Connect the unit sold to the resources required by this operating case.
Revenue logic
Revenue = fulfilled individual orders × net individual order value + fulfilled family orders × net family order value.
Both order types share kitchen and counter capacity. Unfilled demand expires; sales tax is excluded.
What limits a counter-service takeout restaurant’s sales?
A pickup restaurant must complete both production and order handoff. In this case, family orders create more kitchen work, while prepaid orders reduce counter work. Adding demand only increases fulfilled sales while both shared resource pools have capacity. The model allocates any shortage proportionally rather than prioritizing one order type.
- Order unit
- One individual or family order; kitchen units are workload equivalents.
- Kitchen
- Lower of equipment output and funded productive cook hours.
- Counter
- Funded counter minutes and one physical station.
- Demand
- Daily requests × actual open dates × seasonality × launch ramp.
What to establish for your own operation
- Validate willingness to pay for the selected premium baskets.
- Time a realistic family order and the prepaid handoff process.
- Review peak-hour staffing separately from monthly averages.
Follow the plan from demand to cash
Open each section for the assumptions, calculations, and limits of this workbook’s starting case.
Two order types, one shared operating systemRevenue
The 2027 case starts with 100 individual and 25 family requests per open day, priced at $18 and $45 net. Tuesday–Sunday trading runs eight hours daily. A six-month launch ramp begins at 65% of selected demand; calendar multipliers are initially neutral.
A family order consumes 2.5 kitchen workload units versus one for an individual order. Kitchen output is limited by equipment and funded cook hours. Both order types receive the same fulfillment fraction, also constrained by shared counter minutes. Unfilled requests expire.
- Equipment assumption: 45 meal units per service hour; cook assumption: 16 units per productive hour with 75% productive time.
- A 60% prepaid share reduces weighted handling from three walk-in minutes to 1.92 minutes per order.
- These are monthly engineering assumptions; peak queues and batch-size effects require separate operating judgment.
Include the owner and review sales-linked cost assumptionsPayroll
Opening staffing totals 7.4 FTE: paid owner/manager, preparation, 2.8 line cooks, utility and two counter FTE. Only the cooks and counter workers create their respective throughput limits. Wage growth is 3% annually, with a 10.65% payroll load and a separate $750 monthly welfare pool.
Food starts at 32.4% of sales, packaging at 3.5%, and payment expense at 3.85%. The latter reflects selected online/card shares and basket values. These are percentage approximations: changing prices or mix warrants a fresh review of actual ingredients, containers and transaction fees.
- Selected rent/CAM is $4,250 monthly from January; it is a planning allowance.
- The owner’s initial annual salary is $74,880; unpaid owner labor does not support the result.
- 2027 includes opening marketing, formation/training and loan closing costs as expenses.
Separate opening assets from retained cashCAPEX
Initial CAPEX is $279,400 for a reusable fitted shell, kitchen systems, equipment and pickup fixtures. This includes a fully spent $25,400 contingency on $254,000 before contingency. A further $10,000 equipment replacement is scheduled for January 2030.
January 2027 funding is $452,000: $302,000 equity and $150,000 debt. The assumed loan uses 10% fixed interest and 84 monthly annuity payments. Funding covers the modeled cash deficit plus a $60,000 retained reserve; that reserve is separate from construction contingency.
- The Base cash trough before equity, but including debt and debt service, is −$241,423.
- Receivables use two days of sales, food inventory seven days of food cost, and payables zero.
- No refundable lease deposit is included; replace allowances and resize fixed funding for the actual premises.
Track operating coverage and capital recovery separatelyCF
Base 2027 revenue is $686,293 and EBITDA is −$54,575, reflecting two pre-opening months and the launch ramp. The five-year case totals $5,521,596 revenue and $773,833 EBITDA. These outcomes depend on premium basket values, growing demand and the funded staffing plan.
Operating break-even occurs in July 2027: EBITDA, EBIT and operating cash are nonnegative and remain so in Base. Project payback arrives in July 2030, measured from January 2027 using cumulative undiscounted unlevered cash flow, including startup deficits and replacement capital.
- Project cash flow excludes interest, financing and exit proceeds; operating cash is a different measure.
- The tested monetary Low scenario produces minimum cash of −$126,072 with Base financing unchanged.
- The six KPIs cover labor productivity, premises productivity, food, labor, occupancy and pretax 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.
- First-year revenue
- $686,293Base, calendar 2027, USD; includes ten service months and 29,329 expected fulfilled orders.
- Five-year EBITDA
- $773,833Base, January 2027–December 2031, USD; operating earnings before interest, tax, depreciation and amortization.
- Minimum funded cash
- $60,577Base monthly closing-cash minimum in June 2027, USD; includes the selected equity and loan.
- Operating break-even
- July 2027 · month 7First active Base month with nonnegative EBITDA, EBIT and operating cash, sustained thereafter.
- Project payback
- July 2030 · month 43Base cumulative undiscounted unlevered project cash flow crosses zero; counted from January 2027.
- Low-scenario cash minimum
- −$126,072Tested monetary Low scenario, USD, across the 60-month forecast; fixed Base funding leaves a shortfall.
Make the case your own
Work from the operating plan toward the cash requirement.
Set the actual opening date, trading days and individual/family mix.
Replace prices, productive-hour assumptions and staffing with a supportable operating plan.
Update the premises budget and review food, payment and packaging shares.
Read monthly cash under Base and downside assumptions; adjust funding explicitly.
Interpretation and scope
- This is a national starting case researched September 26, 2026; local demand, lease terms and supplier costs still need validation.
- The 25% blended tax rate is a planning assumption without a selected jurisdiction or loss carryforward.
- Money-only scenarios do not change physical demand or staffing. No owner distributions or terminal sale proceeds are scheduled.
The workbook is an Excel file for local planning. Learn how to interpret assumptions and evidence.
Other restaurant types
Each operating type calls for its own financial structure.
Questions
Is a family order counted as 2.5 customers?
No. It is one sale with 2.5 equivalent kitchen workload units. The model does not infer the number of diners.
Does prepaid pickup create another revenue stream?
No. It changes handling time within the same order types. Both prepaid and counter sales use the two-day receivable assumption.
Can adding cooks remove every capacity limit?
No. The equipment line and shared counter can still constrain fulfillment after kitchen labor expands.
Are food and packaging calculated from purchase quantities?
No. Both remain sales-percentage approximations. Recipe quantities, ingredient yields and containers are not dynamically costed.
Is the first year a full trading year?
No. January and February 2027 are pre-opening months; trading begins in March and includes a six-month ramp.
Does Base funding cover the downside automatically?
No. Equity stays fixed. The tested Low scenario has negative minimum cash despite the Base reserve.
Is project payback money paid back to the owner?
No. It measures cumulative project cash recovery before financing. The model schedules no shareholder distributions.
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.
Read the planning guides
Explore the relevant operating questions and how to interpret a workbook’s assumptions.
What does a takeout order leave to cover paid labor?
Follow a takeout order from net sales through food, packaging, and payment costs, then test whether the remaining contribution covers scheduled payroll.
Read the guide
Which restaurant business idea fits the way you want to operate?
Choose among dine-in, pickup, delivery, catering, and a temporary residency by comparing the customer promise, operating work, and commitments each creates.
Read the guide
How to read financial assumptions before editing an Excel model
Follow the chain from operating assumptions to calculated results, check units and timing, and keep a useful record of changes to a financial workbook.
Read the guideEvidence 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-02, revision r01, for January 2027–December 2031. These are a documented planning case, not observed results for a particular business.