# Franchise Model Build a franchise financial model with dual-perspective logic for both franchisors and franchisees. Model unit economics, royalty cash flows, and multi-unit expansion without building complex schedules from scratch. - Canonical: https://finamodel.com/templates/franchise-model - Excel download: https://finamodel.com/templates/franchise.xlsx - Category: Consumer - Model type: Operating model - Difficulty: Beginner - Audiences: Founders & operators, Investors & analysts, Franchisors, Franchisees, Franchise investors, Development managers - Tags: franchisee, royalties, unit-economics, multi-unit, growth ## Overview This unit economics model evaluates whether to invest in, acquire, or roll out new locations for a franchise business (QSR, retail, service). Build comprehensive pro-formas for individual store profitability and consolidated group P&L, including member base growth, prime cost mechanics, royalty cascades, and multi-unit expansion ROI. The model drives revenue from daily transactions per store and average order value, applies maturity ramps for new units, and tracks payback periods. The workbook includes store-level economics (four-wall EBITDA), corporate overhead consolidation, franchise fee and royalty deductions, and debt service coverage analysis. Prime cost is 58–62% at gold standard; stores achieving >65% are distressed. Working capital is typically negative (collect before paying suppliers, generating cash from growth). Capex per new location: $350k–$700k inline, $1M–$2.5M drive-thru. Target payback: 2.5–4.0 years per new store. Critical for franchisees evaluating portfolio expansion, multi-unit operators seeking acquisition financing or refinancing, and franchisors stress-testing unit economics across geographies. The model captures unit-level sensitivity to labour inflation, delivery commission dilution, and rent escalation - key headwinds post-2022. Comparable: McDonald's, Yum! Brands, Domino's - all showing 55–70% leverage and 1.25x–1.60x DSCR. ## What's included - Multi-unit expansion and territory development schedule - Unit-level P&L with ramp-up and seasonality adjustments - Franchisor royalty, franchise fee, and marketing fund tracking - Initial investment and startup cost schedule - Debt service coverage and consolidated cash flow metrics - Per-unit revenue model with AUV assumptions - Cost of goods sold and direct labor by unit - Royalty and advertising fund calculations - Franchise fee, build-out costs, and working capital - Multi-unit growth and expansion payback - EBITDA and unit-level profitability analysis ## Franchise Model: How the Template Captures Unit Economics and Cash Flows This franchise model template helps evaluate unit economics and expansion returns for QSR, retail, or service franchises. It links assumptions to a store rollout schedule, revenue build, store P&L, and integrated financial statements. The 12-tab structure supports both single-unit and multi-unit analysis, with royalty and delivery commission mechanics built in. Rates and financial results described here reflect illustrative model settings, not industry benchmarks. ### Store Rollout and Revenue Build Mechanics The model starts with a Store Rollout tab that schedules new openings per year and tracks cumulative open stores, months of operation, and a maturity ramp percentage. This rollout drives all downstream volume calculations. - Revenue is then built by channel: Dine-In/Takeaway and Delivery. For each channel, revenue equals open stores multiplied by daily transactions and average order value, adjusted for the ramp factor. - Same-store sales growth applies to mature units. Delivery revenue is shown net of aggregator commissions, so the delivery contribution reflects the actual cash retained. The model separates channels because their economics differ—delivery commissions can significantly dilute margins, and the template isolates that impact rather than applying it to total revenue. ### Cost Structure and Prime Cost Relationships The Store P&L captures four-wall economics: food and paper cost, store labour (including payroll taxes and benefits), rent and occupancy, utilities, local marketing, franchise royalty, and delivery commissions. Food cost is a percentage of total revenue, and store labour is reported separately from COGS, which is typical for restaurant franchises. - Prime cost—food plus labour—is a key metric; the model includes checks to keep it within a typical 55% to 65% range. Franchise royalty is an ongoing operating expense of 4% to 8% of revenue, not just an initial fee. - Delivery commissions are applied only to delivery revenue. The template also includes pre-opening costs as an expense, not capitalised, so they hit the P&L before a store opens. ### Capital Expenditure, Debt, and Working Capital The Capex_DA tab handles initial build-out per new store, capitalised franchise fees, and maintenance capex as a percentage of revenue. Depreciation schedules are split by asset class—kitchen equipment, leasehold improvements, and franchise fees—each with its own useful life. - The Debt_Schedule models term loan draws, amortisation, and interest, plus any revolver facility. Interest is calculated on the opening debt balance to avoid circularity. - Working capital assumptions include days sales outstanding (DSO), days inventory outstanding (DIO), and days payables outstanding (DPO). For many franchise businesses, net working capital is negative, meaning growth releases cash. The model incorporates this by calculating changes in receivables, inventory, and payables, feeding into the cash flow statement. ### Integrated Outputs and Validation Checks The Income Statement, Balance Sheet, and Cash Flow are fully linked. Store EBITDA is separated from Corporate EBITDA by deducting corporate SG&A, making unit-level profitability visible. - The cash flow statement uses the indirect method, starting with net income and adjusting for non-cash items, working capital changes, capex, and financing flows. A Checks tab enforces balance sheet integrity, a prime cost range, store EBITDA margin range, non-negative cash, and a minimum DSCR of 1.25x. - The model also includes a balance check row and reconciles closing cash on the cash flow statement to the balance sheet. These controls help users trust the outputs when evaluating expansion or investment scenarios. ## Built for franchise economics Use this model when royalty structures, unit-level margins, and multi-location expansion drive the financial plan. ## Covers both franchisor and franchisee views A useful franchise model shows recurring royalty income from the brand perspective alongside unit-level profitability from the operator perspective. ## Better for lending and expansion planning This gives you the detailed projections lenders need for SBA or commercial financing, including DSCR and global cash flow analysis. ## Built for franchise economics Use this model when royalty structures, unit-level margins, and multi-location expansion drive the financial plan. ## Covers both franchisor and franchisee views A useful franchise model shows recurring royalty income from the brand perspective alongside unit-level profitability from the operator perspective. ## Better for lending and expansion planning This gives you the detailed projections lenders need for SBA or commercial financing, including DSCR and global cash flow analysis. ## Features - **Unit economics clarity:** Build single-unit P&L with all direct and indirect costs to show franchisee profitability and franchisor economics. - **Multi-unit scenarios:** Model growth from 1 unit to 10+ units with shared overhead, area development agreements, and timing of new openings. - **Payback and ROI analysis:** Calculate franchise investment payback period, cumulative cash flows, and ROIC for franchisee decision-making. ## Use cases - **Franchisee recruitment:** Provide prospective franchisees with transparent unit economics and return scenarios to support investment decisions. - **Franchise system valuation:** Forecast franchisor revenue from royalties and fees across a growing unit base to support corporate valuation. - **Area development planning:** Model multi-unit development agreements with territorial rights, opening timelines, and shared support functions. ## Frequently asked questions ### What is a franchise financial model? It is a model that forecasts franchise economics including unit-level P&L, royalty income, expansion schedules, and consolidated financial performance. ### Who uses franchise financial models? Franchisors, franchisees, franchise consultants, SBA lenders, and private equity investors use them for planning and underwriting. ### What should a franchise model include? It should include unit-level economics, royalty and fee structures, expansion schedules with ramp-up periods, and consolidated cash flow. ### Does it handle multi-unit expansion? Yes. The model includes a development schedule where each new location follows its own ramp-up curve and seasonality profile. ### Is it suitable for SBA loan applications? Yes. The model provides the P&L, balance sheet, cash flow, and debt service coverage ratios that lenders typically require for franchise financing. ## Related templates - [Restaurant Unit Economics and Multi-Unit Model](https://finamodel.com/templates/restaurant-model) - [E-Commerce Unit Economics](https://finamodel.com/templates/ecommerce-forecast-model) - [Retail Centre Operating and Development Model](https://finamodel.com/templates/retail-centre-model)