Core modellingCore · ~45 minWorking draft · 12 sheets · 983 formulas

Restaurant franchise roll-out model

Units, AUV, system sales, royalties, refranchising. Build a restaurant franchisor from its units: roll the company-operated and franchised estates forward with openings, closures and refranchising, grow average unit volume with traffic and price, separate system sales from reported revenue, take company restaurants through food and paper, labour and occupancy to the restaurant margin, add royalties, fees and overhead to EBITDA, test a new restaurant on its cash-on-cash return, and carry it through securitised notes, buybacks and a valuation that shows what the same restaurants are worth operated and franchised.

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

On this subject: restaurant franchise roll-out model.Updated 11 November 2026

Who builds it, and for whatThe model an equity research analyst covering a quick-service restaurant chain keeps, and the one a consumer team at a bank or a private equity fund rebuilds before a refranchising programme, a securitisation or a buyout. It separates the two businesses inside every franchisor: restaurants the company runs, which carry food, labour and rent, and a royalty on restaurants other people run, which carries almost nothing. The analyst uses it to say what unit growth and same-restaurant sales are worth and how far a bad year for the consumer reaches the company; the banker and the lender read the same lines for how much debt the royalty stream supports and what selling company restaurants does to earnings, cash and the multiple.

Every sheet below, in your browser, with its outputs and checks

Starter workbook free with an account. Worked model: one a month with Plus, every one with Pro. Downloads

Inspect the workbook
All checks read zero100%
Every value, every sheet, as the workbook holds it.
ABCDEFGHIJ
1Assumptions
2$m unless stated. Average unit volume and costs per restaurant in $m a year.
4YearUnitFY0FY1FY2FY3FY4FY5Notes
5Year number#012345FY0 = 0. Drives growth and inflation.
7Scenario
8Scenario#11 = base, 2 = consumer downturn, 3 = accelerated refranchising. Sets traffic, food and wage inflation, franchise openings and restaurants refranchised from FY1.
10Restaurants
11Company-operated restaurants, end of FY0units620
12Franchised restaurants, end of FY0units2480
13Company openings in FY-1units12In their second year in FY0.
14Franchised openings in FY-1units100
15Company openingsunits141618202020Opened evenly through the year.
16Franchised openings, development planunits110120130140150150What franchisees have agreed to open.
17Company closuresunits886666Mature restaurants, closed evenly through the year.
18Franchised closuresunits454545455050
20Refranchising and franchise openings by scenario
21Restaurants refranchised, base and downturnunits302020202020Mature company restaurants sold to franchisees, evenly through the year.
22Restaurants refranchised, acceleratedunits301201201006040
23Restaurants refranchised, selected scenariounits302020202020
24Franchised openings, % of plan, base and accelerated%100.0%
25Franchised openings, % of plan, downturn%70.0%Franchisees with thinner margins and dearer credit open fewer restaurants.
26Franchised openings, % of plan, selected scenario%100.0%
27Sale price per restaurant refranchised$m1.15
29Average unit volume and same-restaurant sales
30Average unit volume, mature restaurant, FY0$m a year2.00The same for a company and a franchised restaurant.
31New restaurant volume, first year, % of mature%85.0%
32New restaurant volume, second year, % of mature%95.0%Mature, at 100%, from the third year.
33Menu price increase, annual%2.5%From FY1, in every scenario.
35Traffic and inflation by scenario
36Traffic growth, base and accelerated%0.5%Annual change in transactions per mature restaurant, from FY1.
37Traffic growth, downturn%-2.0%
38Traffic growth, selected scenario%0.5%
39Food and paper cost inflation, base and accelerated%2.5%
40Food and paper cost inflation, downturn%4.0%
41Food and paper cost inflation, selected scenario%2.5%
42Restaurant wage inflation, base and accelerated%3.5%
43Restaurant wage inflation, downturn%4.5%
44Restaurant wage inflation, selected scenario%3.5%
46Company restaurant costs
47Food and paper, % of sales, FY0%30.5%
48Labour per restaurant, FY0$m a year0.62Crew and restaurant managers. Per restaurant, so it does not fall when traffic does.
49Occupancy per restaurant, FY0$m a year0.19Rent, property taxes and utilities.
50Of which rent, FY0$m a year0.12Kept in occupancy as an operating lease cost; capitalised only in the lease-adjusted leverage.
51Occupancy cost growth, annual%2.5%
52Other restaurant operating costs, % of sales%8.5%Card and delivery fees, repairs, supplies and insurance.
54Royalty, fees and the advertising fund
55Royalty, % of franchised sales%5.0%
56Initial franchise fee per restaurant$m0.05On each franchised opening and each restaurant refranchised, recognised in the year.
57Advertising fund contribution, % of sales%4.0%Paid by every restaurant, company and franchised, and spent in full.
59General and administrative costs
60Corporate costs, FY0$m105.0Head office, brand, technology and finance. Fixed.
61Field management per company restaurant, FY0$m a year0.05Area managers and above-restaurant operations.
62Franchise support per franchised restaurant, FY0$m a year0.01
63Corporate costs taken out per restaurant refranchised$m a year0.04At FY0 prices, on restaurants sold from FY1. Payroll, accounting and systems a smaller company estate no longer needs.
64Growth in general and administrative costs, annual%3.0%
66Capital spending, working capital and tax
67Build cost per new company restaurant$m1.25Building, kitchen and pre-opening costs, net of landlord contributions. Fixed in money terms.
68Maintenance and remodelling per company restaurant$m a year0.06
69Technology and corporate capital spending$m20.0A year.
70Net PP&E, FY0$m680.0
71Depreciation, % of opening net PP&E%9.0%
72Net working capital, % of company restaurant sales%-4.0%Negative: customers pay at the counter and suppliers are paid later.
73Tax rate%25.0%
75Securitised notes and capital returns
76Securitised notes, FY0$m1,550.0Secured on royalties, fees and company restaurant profits.
77Coupon%5.0%Fixed. Charged on the opening balance.
78Scheduled amortisation, % of original principal%1.0%A year, while the leverage test is failed.
79Non-amortisation test: notes / EBITDA at or belowx5.0xOn the opening balance and the previous year’s EBITDA.
80Cash trap: debt service coverage belowx1.8xBelow it cash is held back and nothing is bought back.
81Multiple of rent capitalised in lease-adjusted leveragex8.0x
82Cash, FY0$m180.0
83Cash kept in the business$m150.0Cash above it is used to buy back shares.
84Dividends, % of net income%40.0%
85Shares in issue, FY0m shares40.00
86Share price, FY0$ per share60.00Buybacks are made at this price grown each year.
87Growth in the buyback price, annual%8.0%
89Valuation
90Discount rate (WACC)%8.0%Valued at the end of FY0.
91EV / EBITDA, company restaurantsx7.5xOn restaurant margin less field management.
92EV / EBITDA, franchise royalties and feesx15.0xOn franchise revenue less franchise support. Corporate costs are spread across both in proportion.

Select a cell to see its row, its schedule and the type of cell. Font colours: blue for inputs, black for formulas, green for links to other sheets. Scroll sideways to see every period.

Download

Restaurant franchise roll-out model: the workbook

An Excel workbook with working formulas, no macros and no external links: the same model you can work with on this page.

  1. Browse without an accountPreview every model online, sheet by sheet, with its outputs and checks.
  2. Free accountWork with every model online: change the inputs, switch the case, see every formula. And every starter workbook, with its key schedules left blank to build.
  3. L3VLUP Plus$4.99/monthEverything in Free, and one worked model each billing month as an Excel file: every schedule built, formulas live, checks at zero, yours to keep.
  4. L3VLUP Pro$25/monthEverything in Plus, every worked model in the library, and the Pro applications.
The worked model
12 sheets and 983 live formulas, all 11 schedules built and linked, every check reading zero. Change an input in Excel and the whole model moves.
The starter
The same inputs and layout with the system sales and royalties: a franchisor’s units and volumes left blank for you to build, each blank cell marked. The worked model is its answer.

What the base case says

Value per share ($)
64.28
Cash-on-cash return on a new restaurant
27.0%
System sales, FY5
$8,209.7m
Revenue, FY5
$1,701.9m
System restaurants, end of FY5
3,617
Franchised share of the system, FY5
83.9%
Restaurant margin, FY5
15.8%
EBITDA, FY5
$371.5m
Franchise share of segment EBITDA, FY5
63.2%
New-restaurant payback (years)
4.39
Free cash flow after refranchising, FY5
$184.0m
Dividends and buybacks, FY1 to FY5
$781.4m
Net debt / EBITDA, FY5
3.7x
Debt service coverage, lowest
3.2x
Enterprise value
$3,941.0m
Blended EV / EBITDA, FY5
12.2x
Value per share on FY1 multiples ($)
54.23
Asset-light premium
18.1%

Read from the workbook as served, every input at its default. Periods: FY0, FY1, FY2, FY3, FY4, FY5. The figures are invented and move with whatever you type in.

What this model is

A five-year model (FY1 to FY5, from an FY0 base year) of an invented quick-service restaurant chain, four-fifths of whose restaurants are run by franchisees.

Two estates are rolled forward side by side, company-operated and franchised, with openings, closures and the restaurants the company sells to franchisees. Sales come from average unit volume: a mature restaurant grows with traffic and menu price, and a new one takes two years to reach the mature volume.

System sales are every restaurant’s sales. Revenue is the company’s own restaurant sales plus a royalty on franchised sales and initial fees, with the advertising fund kept apart. Company restaurants carry a restaurant-level P&L down to the restaurant margin; overhead is split between field management, franchise support and corporate costs.

A new restaurant is tested on its build cost, cash-on-cash return and payback, for the company and for a franchisee. Each restaurant refranchised brings proceeds and a royalty and takes away its margin, its field management and its capital spending.

Securitised notes, free cash flow, dividends and buybacks follow. The company is valued by discounted cash flow and by a sum of the parts on EV / EBITDA, with company restaurants and the franchise stream at their own multiples.

Three scenarios (base, consumer downturn and accelerated refranchising) and two board-style sensitivity tables: cash-on-cash return by average unit volume and build cost, and value per share by royalty rate and discount rate.

Seats: Equity research and hedge funds, Investment banking, Private equity.

How the schedules connect

Every row in the workbook is tagged with the schedule it belongs to; the inspector above shows the tag when you click a row. These are the schedules this model is made of and where each one lives.

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

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

Assumptions, rows 11–18 · Assumptions, rows 30–33 · Units, rows 6–11 · Units, rows 14–19 · Units, rows 22–25 · Units, rows 28–36 · System Sales, rows 6–11 · System Sales, rows 14–18 · System Sales, rows 21–22

Restaurant unit economics: restaurant margin and new-unit returns

Food, labour, occupancy, restaurant margin, cash-on-cash

Assumptions, rows 36–44 · Assumptions, rows 47–52 · Restaurants, rows 6–18 · Restaurants, rows 21–30 · Restaurants, rows 33–36

Refranchising: selling company restaurants to franchisees

Proceeds, gain, margin given up, royalty kept, the premium

Assumptions, rows 21–27 · Refranchising, rows 6–12 · Refranchising, rows 15–23 · Valuation, rows 34–41

Revenue build

Where the top line comes from

Assumptions, rows 55–57 · Profit, rows 6–13 · Profit, rows 16–20

Operating costs and margins

Cost of sales, opex, EBITDA

Assumptions, rows 60–64 · Profit, rows 23–32 · Profit, rows 35–43

Capex and depreciation (PP&E roll-forward)

Opening, plus capex, less depreciation, closing

Assumptions, rows 67–73 · Cash Flow, rows 6–12

Working capital schedule

Receivables, inventory and payables in days

Cash Flow, rows 15–16

Cash flow statement

Indirect method, closing on balance-sheet cash

Cash Flow, rows 19–28

Debt schedule

Tranches, interest, amortisation and the sweep

Assumptions, rows 76–87 · Debt, rows 6–13 · Debt, rows 16–23 · Debt, rows 26–32

Discounting and terminal value

Discount factors, two terminal methods, reconciled

Assumptions, rows 90–92 · Cash Flow, rows 31–32 · Valuation, rows 6–13 · Valuation, rows 16–27 · Valuation, rows 30–31

Sensitivity tables

Two assumptions at once, without a data table

Sensitivity, rows 5–8 · Sensitivity, rows 11–16 · Sensitivity, rows 19–31

What you should be able to explain

  • Why system sales and revenue are different numbers, and why a franchisor is compared on system sales and unit growth while its income statement shows a fraction of them.
  • How two unit roll-forwards connect: a restaurant refranchised leaves the company estate and joins the franchised one, so the system count and system sales do not move while revenue falls.
  • What same-restaurant sales measure, why they are split into traffic and price, and why a new restaurant’s ramp is kept out of them.
  • Why a royalty holds up when costs rise and a restaurant margin does not: labour and occupancy are costs per restaurant, and the royalty is taken off sales.
  • How a new restaurant is judged on build cost, cash-on-cash return and payback, and why the franchisee’s return matters as much as the company’s.
  • What refranchising gives up and keeps on each restaurant, why the market pays a higher multiple for the royalty, and why the premium depends on taking overhead out.

What a reviewer looks for

  • Calling system sales revenue, or growing revenue at the system’s rate while restaurants are being refranchised.
  • Refranchising that removes a restaurant from the company estate without adding it to the franchised one, so the system shrinks and the royalty on it is lost.
  • Restaurant labour as a fixed share of sales, so falling traffic never squeezes the margin.
  • New restaurants at the mature average unit volume from the day they open, so unit growth is overstated and the payback looks shorter than it is.
  • Advertising fund contributions counted as income, when the fund is spent in full.
  • One EBITDA multiple on the whole company, so a change in the mix between restaurant profits and royalties cannot change the value.

Conventions this workbook uses

Stated on the cover sheet too. A model is only as trustworthy as the decisions it tells you it made.

  • Annual periods. FY0 is the base year, built from the same drivers as the forecast. Scenarios change traffic, food and wage inflation, franchised openings and the restaurants refranchised from FY1 only.
  • Openings, closures and refranchising fall evenly through the year: average restaurants are the average of the start and the end, and a restaurant in its first year trades for half of it.
  • A new restaurant trades at 85% of the mature average unit volume in its first year and 95% in its second, and is mature from its third. Closures and refranchising come from mature restaurants, and a restaurant sold arrives mature in the franchised estate, so refranchising never changes system sales.
  • Same-restaurant sales growth is traffic and menu price compounded, on mature restaurants. One average unit volume serves company and franchised restaurants.
  • Food and paper is a share of sales that moves with food inflation against menu price. Labour and occupancy are costs per restaurant, so they do not fall with traffic. The advertising contribution and other costs are shares of sales.
  • Initial franchise fees are recognised in the year a restaurant opens or is sold, a simplification of the revenue standard, which spreads them over the franchise term. The advertising fund is spent in full and adds nothing to EBITDA; revenue is shown before and including franchisees’ contributions.
  • Leases: rent stays in occupancy as an operating lease cost, so EBITDA is after rent and net debt holds no lease liability. Lease-adjusted leverage, with rent capitalised at a multiple, is shown as a memo. That is a judgement; under IFRS 16 the rent would leave EBITDA.
  • A restaurant refranchised or closed removes its share of opening net PP&E. The gain on refranchising and the loss on closures sit below EBITDA and are taxed with everything else. Depreciation is a rate on opening net PP&E. Tax is never below zero.
  • The notes carry a fixed coupon on the opening balance. Scheduled amortisation applies only while opening notes exceed the test multiple of the previous year’s EBITDA. When debt service coverage falls below the trap level, nothing is bought back. Otherwise all cash above the amount kept in the business buys back shares, at a price that grows each year.
  • The discounted cash flow values unlevered free cash flow, including refranchising proceeds, at the end of FY0, with a terminal value equal to the sum of the parts on FY5 EBITDA. In the sum of the parts corporate costs are spread across the two segments in proportion to their EBITDA, so the blended multiple is the two segment multiples weighted by segment EBITDA.
  • The sensitivity tables recompute from the model’s own lines; the centre of each equals the model.

What this model does not cover

Where its answer stops, so you know what to add before relying on it.

  • Individual restaurants, markets, formats and dayparts, and the mix of delivery, drive-through and digital orders. One average unit volume serves the whole system.
  • Property. Many franchisors own or lease sites and sublet them to franchisees at a margin; here franchisees hold their own leases and pay a royalty only.
  • Franchisee finances: their debt, their own overhead, and closures or royalty relief when their returns fall. Franchised openings slow in the downturn, and nothing else.
  • Initial fees spread over the franchise term, breakage on gift cards and loyalty points, and other timing under the revenue standard.
  • IFRS 16. Rent stays in occupancy and leases appear only in the lease-adjusted leverage.
  • The terms of a real securitisation beyond a non-amortisation test and a cash trap: reserve accounts, rapid amortisation, variable funding notes and refinancing at the anticipated repayment date.
  • A real company. Yum! Brands, Restaurant Brands International and Wingstop are candidates for a case built from their reports; this model uses invented figures.

Build it yourself

The starter workbook

The Units and System Sales sheets have been cleared: both unit roll-forwards, average restaurants, each estate by age, same-restaurant sales, average unit volume, company, franchised and system sales and the royalty. Rebuild them from the Assumptions sheet, then watch revenue, the restaurant margin, refranchising, the notes and the valuation calculate again. The Checks sheet shows when the system roll-forward and the sales by cohort tie.

Blanks: System sales and royalties: a franchisor’s units and volumes. Download it beside the worked model.

The path around this model

Understand it, drill it, read the build, then apply it to a real company.

Vocabulary: System Sales, Average Unit Volume (AUV), Refranchising, Like-for-Like Sales, Four-Wall EBITDA, Cash-on-Cash Return, Sum-of-the-Parts (SOTP), DSCR (Debt Service Coverage Ratio), EBITDA, Free Cash Flow (FCF).

Questions about this model

What is the difference between system sales and revenue?

System sales are the sales of every restaurant under the brand, whoever runs it: $6,099.2 million in FY0 from 3,100 restaurants. The company books only the sales of the 620 it runs itself, $1,260.7 million, plus a 5% royalty on the franchisees’ $4,838.5 million, which is $241.9 million, and $6.3 million of initial fees. Revenue is therefore $1,508.9 million, 24.7% of system sales. Franchisees also pay $193.5 million into the advertising fund, which is reported as revenue with the spending as a cost; the model keeps it apart because the fund is spent in full and adds nothing to EBITDA.

Why does a downturn hurt company restaurants more than the royalty?

Because the restaurant bears the costs and the royalty comes off sales. In the consumer downturn traffic falls 2% a year while food costs rise 4% and wages 4.5% against a 2.5% menu price increase. Labour is a cost per restaurant, so it climbs from 31.1% of sales to 37.9%, and the restaurant margin falls from 16.4% in FY0 to 6.2% in FY5. The franchise segment, royalties and fees less franchise support, still grows from $219.0 million to $250.8 million. EBITDA falls from $289.1 million to $173.4 million, debt service coverage reaches 1.93x against a cash trap at 1.75x, and the value per share falls from $64.28 to $19.79.

What does a new restaurant return?

At FY1 prices a new restaurant costs $1.25 million to build and sells $2.06 million a year once mature. After food and paper, the advertising contribution and other costs it keeps 57.0% of sales, and labour and occupancy take $0.84 million, leaving $0.34 million of restaurant cash flow: a 27.0% cash-on-cash return. It earns $0.16 million in its first year and $0.28 million in its second, so the build cost is recovered in 4.4 years. A franchisee running the same restaurant pays a $0.10 million royalty each year and a $0.045 million initial fee, and earns 18.1%.

What is the asset-light premium, and does refranchising create value?

A dollar of royalty is valued more highly than a dollar of restaurant profit because it needs no capital and barely moves with costs. Here company restaurants are valued at 7.5 times their EBITDA and the franchise stream at 15 times. The 614 restaurants the company runs in FY1 are worth $1,302.1 million as operated; sold at $1.15 million each, with the royalty they would then pay valued at 15 times, they are worth $1,538.1 million, a premium of 18.1%. In the accelerated case the company sells 440 restaurants by FY5 rather than 100: the franchised share reaches 93.3% rather than 83.9%, EBITDA is $318.1 million rather than $371.5 million, the blended multiple 13.6x rather than 12.2x, and the value per share $66.66 rather than $64.28. That rests on taking out $0.04 million of corporate cost for each restaurant sold, on top of its field management. With none taken out, the accelerated case is worth $61.31 against $63.25: the multiple rises, but the same head office is spread over less EBITDA. The two cases are worth the same, $63.71, at $0.018 million a restaurant, so selling faster pays only if each sale takes at least that much out of head office.

Related models

Questions about this model

Discussions open here soon.

All discussions

Share your result 📊

𝕏in💬🤖

Instagram and TikTok have no desktop share link, so copy the caption and paste it into the app.