# Restaurant Model Build a restaurant model designed around the real drivers of dining economics. Track RevPASH, prime cost, and seasonal labour scheduling to move beyond basic budgeting into strategic F&B forecasting. - Canonical: https://finamodel.com/templates/restaurant-model - Excel download: https://finamodel.com/templates/restaurant.xlsx - Category: Consumer - Model type: Operating model - Difficulty: Beginner - Audiences: Founders & operators, Investors & analysts, Restaurant operators, Franchise investors, Equity investors, Management consultants - Tags: restaurant-operations, unit-economics, qsr, multi-unit, franchise ## Overview Model single-unit restaurant unit economics by projecting covers (table turns), food and beverage revenue, COGS by category, labor percentages, and path to profitability during ramp-up and stabilisation. This template forecasts monthly revenue from average check size, captures seasonality and ramp curves (restaurants reach stabilised covers within 3–6 months), and applies cost-of-goods ratios (food COGS 28–32%, beverage COGS 18–25%). Labor is modeled as a percentage of revenue and includes payroll taxes and benefits. The workbook contains a revenue sheet with covers, food/beverage/off-premise revenue streams and delivery commission impacts, a detailed labor schedule for FOH and BOH staffing, an operating costs section covering rent, utilities, credit card fees (2.5% on 95% of sales), insurance, and maintenance capex (1.5–3% of revenue). The model calculates prime cost (COGS + labor), a key industry metric targeting 60–65% of revenue, and EBITDA margins of 10–15% at stabilisation. Cash flow shows the pre-opening cash investment (build-out, pre-opening expenses) and monthly breakeven timing. Debt service and equity return calculations support investment or acquisition decisions. Target users are restaurant operators, QSR franchisees, food-focused PE firms, and lenders evaluating single-unit or multi-unit restaurant concepts valued at $1M to $10M per unit. ## What's included - RevPASH (revenue per available seat hour) calculation - Prime cost tracking covering food, beverage, and labour - Seat turnover and day-part revenue modelling - Seasonal labour scheduling with shift-based costs - Pre-opening budget, CapEx amortisation, and break-even analysis - Average ticket size and customer count forecast - Food cost and cost of goods sold (COGS) percentage - Labor cost and staffing by daypart and location - Rent and occupancy cost assumptions - Operating expenses including utilities and supplies - Unit-level EBITDA and multi-unit chain margin expansion ## How the Restaurant Model Handles Multi-Unit Rollouts and Unit Economics This restaurant model supports underwriting a multi-unit chain rollout, starting with one founder unit and scaling to eight stores over five years. It captures unit-level and chain-level economics, produces a three-statement financial forecast, and calculates equity returns. The underlying model tracks revenue drivers, labour scheduling, operating costs, and capital structure, giving a structured view of how a restaurant concept may perform as it grows. ### Operating Drivers: Multi-Unit Rollout and Revenue Build The model is built around a defined multi-unit rollout schedule, with new units opened in specific years to reach eight cumulative stores by Year 5. Revenue is driven by a daypart matrix covering breakfast, lunch, dinner, late-night, and brunch, each with its own operating days, covers per seat, and average check. - A same-store sales multiplier compounds traffic and ticket growth annually. Off-premise sales are split across three platforms—DoorDash, Uber Eats, and direct online—each with a distinct mix and commission rate, so the model reflects the net revenue impact of delivery. - Unit maturity follows a ramp curve where first-year units achieve a percentage of mature average unit volume, rising in subsequent years, which affects how revenue scales across the chain. ### Calculation Flow: From Unit Economics to Chain Rollup Per-unit revenue, labour, and operating costs are computed on a mature-unit basis and then scaled to chain totals using weighted-unit equivalents, which combine cumulative units with a maturity factor. This means revenue, cost of goods sold, labour, and other operating expenses grow with both the number of units and their individual maturity. - Occupancy costs, however, scale by physical unit count because rent does not ramp with maturity. The labour schedule uses eleven roles, each with full-time-equivalent counts, hours, wages, payroll markup, and annual wage inflation. - Cost of goods sold is broken into food categories and beverage costs, each with its own inflation rate, while operating expenses are split into fixed and variable components, reflecting operating leverage as revenue grows. ### Outputs: Financial Statements and Returns The model produces a full three-statement financial forecast: income statement, balance sheet, and cash flow statement. On the income statement, restaurant-level EBITDA is calculated after deducting cost of goods sold, labour, and operating expenses, then corporate general and administrative costs are subtracted to arrive at chain EBITDA. - The balance sheet includes a balance check row to ensure assets equal liabilities plus equity. The cash flow statement uses the indirect method. - An equity returns block calculates IRR, NPV, MOIC, fractional payback, and debt service coverage ratios, using a Year-0 equity outflow and subsequent capital calls. A KPI scorecard summarises metrics such as average unit volume, sales per square foot, covers per seat per day, prime cost percentage, and restaurant-level margin. ### Practical Use: Assumptions and Scope The model consolidates all hardcoded inputs into an assumptions sheet, making it straightforward to adjust drivers such as rollout timing, average unit volume ramp, wage inflation, and platform commission rates. It is designed as a single-concept, annual model and does not include monthly seasonality, dividend distributions, or a franchise versus corporate-owned split. - Pre-opening expenses are treated as period costs rather than capitalised, and the debt schedule uses level-payment amortisation. The returns calculation assumes all equity returns are realised at a terminal exit in Year 5. - These design choices make the model suitable for evaluating a venture-backed restaurant concept at a small chain scale, providing a structured way to test how operating decisions affect financial outcomes. ## Built for hospitality economics Use this model when seat turnover, prime cost ratios, and day-part revenue mix are the drivers that determine whether a restaurant concept works financially. ## Tracks the metrics operators care about A proper restaurant model separates food cost, beverage cost, and labour into a clear prime cost framework that targets sustainable margin ranges. ## Useful for investors and lenders Generate professional pro formas that demonstrate debt service coverage and ROI timelines for bank financing or private investment. ## Built for hospitality economics Use this model when seat turnover, prime cost ratios, and day-part revenue mix are the drivers that determine whether a restaurant concept works financially. ## Tracks the metrics operators care about A proper restaurant model separates food cost, beverage cost, and labour into a clear prime cost framework that targets sustainable margin ranges. ## Useful for investors and lenders Generate professional pro formas that demonstrate debt service coverage and ROI timelines for bank financing or private investment. ## Features - **Unit economics granularity:** Models sales by daypart (breakfast, lunch, dinner) to reflect traffic patterns and staffing efficiency. - **Multi-unit scaling and overhead absorption:** Shows how corporate overhead, G&A, and supply chain savings improve margin as restaurant count grows. - **Franchisee economics and royalty structure:** Models franchisee unit economics after royalties and support fees to show franchisee appeal and franchise expansion potential. ## Use cases - **New restaurant site selection and pro forma:** Build unit-level financial forecast for lease negotiation and investor pitch with comparable unit economics. - **Chain expansion and multi-unit development:** Model incremental units, corporate overhead absorption, and chain-level profitability to support capital raise. - **Franchise system profitability and pricing:** Analyze franchisee unit returns after royalties to set competitive franchise fees and support growth. ## Frequently asked questions ### What is a restaurant financial model? It is a model that forecasts revenue by day-part and seat turnover, tracks prime cost, and projects profitability for a restaurant or food and beverage operation. ### Who uses restaurant financial models? Restaurant owners, hospitality investors, F&B consultants, and commercial lenders use them for planning, financing, and operational analysis. ### What should a restaurant model include? It should include RevPASH or covers-based revenue, prime cost tracking, labour scheduling, pre-opening costs, and integrated financial statements with break-even visibility. ### Does it handle delivery and off-premise sales? Yes. The revenue section supports split channel modelling with specific commission rates for third-party delivery platforms to analyse the true net margin of off-premise sales. ### Can I model seasonal labour adjustments? Yes. The labour scheduler includes a monthly seasonality index to ramp staffing for peak seasons and tighten costs during quieter periods. ## Related templates - [Franchise Unit Economics Model](https://finamodel.com/templates/franchise-model) - [Food Delivery Unit Economics](https://finamodel.com/templates/food-delivery-model) - [Subscription Box Economics](https://finamodel.com/templates/subscription-box-model)