Test the price, capacity and costs behind your ghost kitchen. Explore the online worksheet previews alongside calculations from the current illustrative business case.
6 online worksheet illustrations, described below
Opening budget, scenario assumptions and dashboard views
Five-year forecast and separate operating break-even sensitivity
Editable Excel product with assumptions and formulas
The online preview illustrates 6 planning sections using this website's scenario. These illustrations are separate from the downloadable workbook.
01Orders, channels and average checkUses the verified E02 restaurant engine for a delivery-only single-brand commercial kitchen: order volume by channel is multiplied by the matching average check, followed by seasonality and separately supported ancillary revenue.Explore layout ↓
02Food, packaging and channel costSeparates ingredients, packaging, marketplace commissions, payment fees, refunds, remakes, promotions and order-specific delivery costs from paid payroll and fixed kitchen overhead so each accepted paid order has a visible contribution.Explore layout ↓
03Kitchen capacity and dispatchBridges independently entered orders to receiving, cold storage, prep, cook, hold, assembly, order accuracy, pickup shelf, courier handoff, cleaning and peak dayparts, with prep, cook, hold, assembly and courier handoff visible rather than assuming every listed order can be delivered on time.Explore layout ↓
04Staffing and operating expensesSchedules paid owner work, kitchen and dispatch roles, employer costs, occupancy, utilities, cleaning, maintenance, software, marketing and recurring overhead.Explore layout ↓
05Startup uses, funding and scenariosSchedules kitchen build-out, ventilation, cooking and cold equipment, assembly, pickup systems and reserve, working capital and financing, then compares low, base and high order, check, contribution and fixed-cost paths.Explore layout ↓
06Statements and dashboardConnects channel revenue, sales-linked cost, payroll, operating expense, capital and funding schedules to five-year statements, cash flow, balance sheet, KPIs and a management dashboard.Explore layout ↓
Explore the online worksheet illustrations
Open each online sheet presentation to read its specification and illustration. These web views are not screenshots or downloadable Excel files.
Ghost KitchenPlanned XLSX
EBITDA = Revenue − operating costs
Illustrative workbook layout · annual USD
Income statement
Year 1
Year 2
Year 3
Revenue
$900,000
$1,450,000
$2,038,400
Food, packaging, marketplace, payment and order-linked costs
$423,000
$667,000
$876,512
Paid management, kitchen, assembly, dispatch and cleaning payroll
$480,000
$560,000
$650,000
Occupancy, utilities, maintenance, marketing, software and overhead
$380,000
$405,000
$430,000
EBITDA
−$383,000
−$182,000
$81,888
EBITDA margin
-42.6%
-12.6%
4.0%
Planned presentation, not a completed file. Costs are shown as positive outflows; EBITDA excludes interest, tax, depreciation and amortization.
01Orders, channels and average checkWorksheet specification
Orders, channels and average check
Planned purpose: Uses the verified E02 restaurant engine for a delivery-only single-brand commercial kitchen: order volume by channel is multiplied by the matching average check, followed by seasonality and separately supported ancillary revenue.
Inputs
Order channels
Launch dates
Orders by channel
Average check by channel
Monthly seasonality
Separately supported ancillary revenue
Outputs
Revenue by channel
Monthly and annual revenue
Order and check mix
Limits and completion needs
The order channels must remain distinct: direct pickup, direct delivery where supported and each third-party marketplace.
Do not count the same order in both its channel and the $32 blended public order value or count platform-collected customer payments before deductions as net revenue without a consistent policy.
02Food, packaging and channel costWorksheet specification
Food, packaging and channel cost
Planned purpose: Separates ingredients, packaging, marketplace commissions, payment fees, refunds, remakes, promotions and order-specific delivery costs from paid payroll and fixed kitchen overhead so each accepted paid order has a visible contribution.
Marketplace, direct-order and courier terms must reflect the actual contract, refunds, promotions, taxes, tips, delivery charges, settlement timing and responsibility for failed delivery.
03Kitchen capacity and dispatchWorksheet specification
Kitchen capacity and dispatch
Planned purpose: Bridges independently entered orders to receiving, cold storage, prep, cook, hold, assembly, order accuracy, pickup shelf, courier handoff, cleaning and peak dayparts, with prep, cook, hold, assembly and courier handoff visible rather than assuming every listed order can be delivered on time.
Inputs
Orders by daypart
Station cycle times
Batch and holding limits
Courier arrival and handoff
Downtime and rejected orders
Outputs
Sellable order capacity
Used capacity
Daypart bottlenecks and service levels
Limits and completion needs
Revenue inputs do not prove that the kitchen, equipment or staff can deliver the volume.
Menu complexity, cleaning, food-safety controls, remakes and courier congestion consume capacity.
04Staffing and operating expensesWorksheet specification
National occupation data do not set local offers or a complete employer burden.
Receiving, prep, cook, assembly, allergen control, dispatch, cleaning and management duties must be assigned.
05Startup uses, funding and scenariosWorksheet specification
Startup uses, funding and scenarios
Planned purpose: Schedules kitchen build-out, ventilation, cooking and cold equipment, assembly, pickup systems and reserve, working capital and financing, then compares low, base and high order, check, contribution and fixed-cost paths.
Inputs
Opening uses
Vendor and installation timing
Reserve policy
Debt and equity
Scenario multipliers
Outputs
Sources and uses
Cash runway
Funding gap
Break-even and sensitivity
Limits and completion needs
The StartFigures allocation is not a property, equipment, contractor, insurer or lender quote.
Debt service, tax, deposits, build-out timing and replacement capital require a dated cash schedule.
06Statements and dashboardWorksheet specification
Statements and dashboard
Planned purpose: Connects channel revenue, sales-linked cost, payroll, operating expense, capital and funding schedules to five-year statements, cash flow, balance sheet, KPIs and a management dashboard.
Inputs
Selected scenario
Working-capital and settlement timing
Financing
Tax assumptions
Opening balances
Outputs
P&L
Cash flow
Balance sheet
Dashboard and ratios
Limits and completion needs
Outputs inherit every order, check, fee, capacity, cost, funding and settlement assumption.
A forecast does not certify demand, food compliance, delivery performance or profitability.
Ways to prepare your files
Template
Current product · Shopify checkout
Edit the financial model with your own assumptions.
Define the revenue drivers, operating modules, outputs and review criteria before agreeing the work.
Project quote · Schedule agreed with you
Assumptions you can change
These are the current inputs behind the business case and the intended starting points for the editable workbook. Range endpoints represent modeled scopes or sensitivities, not measured national averages.
The opening budget and annual expense inputs also need local quotes and staffing estimates. This page shows fixed examples; the free calculator lets you change price, volume and trading days.
Volume-only sensitivity · revenue at mature volume · monthly USD
Scenario
Daily units
Monthly revenue
Break-even revenue
First operating break-even
Lower volume
100
$96,992
$157,895
Not reached
Base volume
175
$169,736
$157,895
Month 12
Higher volume
260
$252,179
$157,895
Month 7
Only accepted paid orders per operating day changes. Blended collected revenue per accepted paid order: $32.00; 7 operating days per week. Fixed costs and contribution margin stay constant. “Not reached” means no operating break-even within the 12-month ramp. This sensitivity is separate from the annual forecast and does not measure cash payback.
Sample outputs from the current case
These results are calculated from the website’s illustrative assumptions. They demonstrate intended workbook topics, not a tested Excel file.
01 / Annual forecast
Revenue across five years
$900k
Year 1
$1.5m
Year 2
$2.0m
Year 3
$2.4m
Year 4
$2.6m
Year 5
Annual USD. Full values appear in the Dashboard presentation.
02 / Opening allocation
Where the opening budget goes
Leasehold, ventilation, grease, plumbing, electrical and fire work$230,000
Cooking, preparation, refrigeration and dish equipment$160,000
Assembly, packaging, pickup, POS and order systems$45,000
Design, permits, professional fees and inspections$45,000
Opening food, packaging, smallwares and uniforms$30,000
Deposits, insurance, hiring, training and launch marketing$40,000
Working capital and contingency reserve$100,000
One-time budget: $650,000. This allocation is not a cumulative cash-flow forecast.
03 / Operating earnings
Year 3 costs and EBITDA
Against annual revenue of $2,038,400.
Food, packaging, marketplace, payment and order-linked costs$876,512
Paid management, kitchen, assembly, dispatch and cleaning payroll$650,000
Occupancy, utilities, maintenance, marketing, software and overhead$430,000
EBITDA$81,888
EBITDA margin: 4.0%. EBITDA is not cash available to the owner.
04 / Operating threshold
Volume needed to break even
Required whole units per day
163
Break-even revenue / month
$157,895
Base revenue / month at maturity
$169,736
First operating break-even
Month 12
Units mean accepted paid orders per operating day. The ramp covers 12 months; operating break-even does not measure recovery of opening capital.
The annual forecast and fixed-cost sensitivity are separate planning views. The website does not yet supply a complete funding, debt, tax and working-capital schedule for a cumulative cash-flow or payback chart. Read the full input basis and limitations.
Annual forecast and calculator comparison
The annual forecast and calculator use separate scenarios. Their revenue ramp or cost allocations differ, as shown below. The calculator's break-even month does not reconcile the annual forecast.
Original base inputs · USD per year
Check
Annual forecast
Calculator inputs
Year 1 revenue
$900,000
$1,329,033
Year 1 operating result
−$383,000
−$322,451
Year 3 / mature annual operating result
$81,888
$80,994
Calculator figures use the original first 12 months and mature monthly result × 12; sliders do not change this comparison. Neither column measures cash flow or payback. Input basis.
Both products in one cart
Model + Business Plan
Write the strategy and test the assumptions for your ghost kitchen together. Update the narrative when you change the forecast.
The Business Plan uses Word and the Financial Model uses Excel. The online illustrations use this website's scenario data and may differ from the purchased files.
File format
XLSX
Editor
Microsoft Excel
Editing
Input cells, forecast assumptions and formulas; workbook behavior still needs verification.
Other software
Compatibility with alternative editors has not been verified.
Delivery and terms
Review the product description, delivery details, license and final total in Shopify before paying.
Use the purchase button to buy the Ghost Kitchen Financial Model for $109 through Shopify. This is a one-time price in USD before any applicable taxes.
What do the online previews show?
The online preview explains Orders, channels and average check, Food, packaging and channel cost, Kitchen capacity and dispatch, Staffing and operating expenses, Startup uses, funding and scenarios, Statements and dashboard using this website's illustrative case. It is separate from the downloadable Excel model.
Are these previews pages from a finished file?
The web previews are rendered from the website's case record. They illustrate planning concepts and calculations; they are not screenshots or a page-by-page inventory of the downloadable product.
What would I need to change for my business?
Review blended collected revenue per accepted paid order, accepted paid orders per operating day, the operating schedule, opening budget and costs. These web previews do not edit a workbook. Test the website's price and volume assumptions in the business idea page's calculator.
Is the written business plan included?
The Financial Model is sold separately. The $168 Bundle adds the $59 Business Plan and $109 Financial Model for the same business to one cart, one of each.
Do the figures establish what my business will earn?
No. The figures describe an illustrative U.S. operating case, not measured industry averages or a prediction for your location. EBITDA is not owner cash, and operating break-even does not recover the opening investment. Check local costs, capacity and demand before using the assumptions.
