Operating schedules · in 1 model

System sales and royalties: a franchisor’s units and volumes

Two unit roll-forwards, AUV, system sales, the royalty.

By Surojit Chakraverti, founder of L3VLUP and an investor running a long-short healthcare and technology equities strategy.

On this subject: system sales and royalties: a franchisor’s units and volumes.Updated 11 November 2026

What it does

A franchised restaurant chain has two estates, the restaurants the company runs and the ones franchisees run, and each is rolled forward: restaurants at the start of the year, openings, closures and restaurants at the end. A restaurant the company sells to a franchisee leaves the first roll-forward and enters the second, so the system count is unchanged. Sales come from average unit volume, the sales of one mature restaurant in a year, which grows with same-restaurant sales (traffic and price compounded); a new restaurant trades below it for its first years and for only part of the year it opens. System sales are the sales of every restaurant. The company’s revenue takes its own restaurants’ sales and adds a royalty, a percentage of the franchisees’ sales, which is why the schedule feeds revenue twice and on very different terms.

Where it lives

The same schedule in each model that carries it, with the rows to open. Open a model in the browser, go to the sheet, and click the lines.

Restaurant franchise roll-out model
  • Assumptions, rows 11–18: Company-operated restaurants, end of FY0, Franchised restaurants, end of FY0, Company openings in FY-1, Franchised openings in FY-1…
  • Assumptions, rows 30–33: Average unit volume, mature restaurant, FY0, New restaurant volume, first year, % of mature, New restaurant volume, second year, % of mature, Menu price increase, annual
  • Units, rows 6–11: Restaurants, start of year, Add: openings, Less: closures, Less: refranchised…
  • Units, rows 14–19: Restaurants, start of year, Add: openings, Less: closures, Add: bought from the company…
  • Units, rows 22–25: System restaurants, end of year, Average system restaurants, Net unit growth, Franchised share of the system
  • Units, rows 28–36: Company: in their first year (opened this year), Company: in their second year, Company: mature, average in the year, Company: mature-restaurant equivalents…
  • System Sales, rows 6–11: Traffic growth, Menu price increase, Same-restaurant sales growth, Average unit volume, mature restaurant…
  • System Sales, rows 14–18: Company restaurant sales, Franchised restaurant sales, System sales, System sales growth…
  • System Sales, rows 21–22: Royalties, Check: system sales - sales of each cohort at its own volume

What a reviewer looks for

  • System sales treated as revenue.
  • Year-end restaurants used for a year in which restaurants opened, closed and changed hands throughout.
  • A refranchised restaurant dropped from the company estate and never added to the franchised one.
  • Same-restaurant sales that include the ramp of restaurants opened in the last year.

Learn it, then build it

Vocabulary: System Sales, Average Unit Volume (AUV), Like-for-Like Sales.

Other operating schedules

Working capital scheduleCapex and depreciation (PP&E roll-forward)Airline capacity and traffic: ASK, RPK and load factorAirline unit revenue and unit cost: RASK and CASKAirline fuel cost and hedgingType curves and production declineOil and gas reserves roll-forwardRealised prices and the field netbackUnits-of-production DD&AContainer fleet: owned, chartered, newbuilds and scrappingMine plan: from ore reserve to payable metalC1 cash cost and all-in sustaining costMine closure and rehabilitation provisionLiftings and freight rate: a liner’s revenueRestaurant unit economics: restaurant margin and new-unit returnsBunker fuel and the bunker adjustment factorRate base roll-forwardAllowed revenue: the building blocksRegulatory lag: earned against allowed returnHeadcount pyramid: hiring, attrition and promotionMobile subscriber roll-forward: gross adds, churn, net addsFibre build: homes passed, penetration and connectionsSpectrum licences: auction payments and amortisationTower site roll-forward: build-to-suit and decommissioningTenancy roll-forward: anchor, colocation and the tenancy ratioTower unit economics: yield on cost by tenantGround lease schedule: rent, escalators and buy-outsUtilisation and realisation: hours to fee revenueProfit per partner: pay, bonus pools and partnership profitStore estate roll-forward and cohortsRetail sales: density, like-for-like and onlineFour-wall EBITDA and new-store paybackStore leases under IFRS 16Driver-based budget: volume, price, heads and cost per headRolling forecast: actuals, reforecast and the outturnPrice-volume-mix: revenue and margin varianceCost variances: rate, volume, heads and cost per headEBITDA bridge: plan to actual and forecastCapacity cohorts: MW, GPUs, utilisation and revenueBacklog roll-forward: contracts to revenue to cashCapital roll-forwardRisk budgetTrading cost baseSponsorship revenue