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
| A | B | C | D | E | F | G | H | I | J | |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Assumptions | |||||||||
| 2 | $m unless stated. Average unit volume and costs per restaurant in $m a year. | |||||||||
| 4 | Year | Unit | FY0 | FY1 | FY2 | FY3 | FY4 | FY5 | Notes | |
| 5 | Year number | # | 0 | 1 | 2 | 3 | 4 | 5 | FY0 = 0. Drives growth and inflation. | |
| 7 | Scenario | |||||||||
| 8 | Scenario | # | 1 | 1 = base, 2 = consumer downturn, 3 = accelerated refranchising. Sets traffic, food and wage inflation, franchise openings and restaurants refranchised from FY1. | ||||||
| 10 | Restaurants | |||||||||
| 11 | Company-operated restaurants, end of FY0 | units | 620 | |||||||
| 12 | Franchised restaurants, end of FY0 | units | 2480 | |||||||
| 13 | Company openings in FY-1 | units | 12 | In their second year in FY0. | ||||||
| 14 | Franchised openings in FY-1 | units | 100 | |||||||
| 15 | Company openings | units | 14 | 16 | 18 | 20 | 20 | 20 | Opened evenly through the year. | |
| 16 | Franchised openings, development plan | units | 110 | 120 | 130 | 140 | 150 | 150 | What franchisees have agreed to open. | |
| 17 | Company closures | units | 8 | 8 | 6 | 6 | 6 | 6 | Mature restaurants, closed evenly through the year. | |
| 18 | Franchised closures | units | 45 | 45 | 45 | 45 | 50 | 50 | ||
| 20 | Refranchising and franchise openings by scenario | |||||||||
| 21 | Restaurants refranchised, base and downturn | units | 30 | 20 | 20 | 20 | 20 | 20 | Mature company restaurants sold to franchisees, evenly through the year. | |
| 22 | Restaurants refranchised, accelerated | units | 30 | 120 | 120 | 100 | 60 | 40 | ||
| 23 | Restaurants refranchised, selected scenario | units | 30 | 20 | 20 | 20 | 20 | 20 | ||
| 24 | Franchised openings, % of plan, base and accelerated | % | 100.0% | |||||||
| 25 | Franchised openings, % of plan, downturn | % | 70.0% | Franchisees with thinner margins and dearer credit open fewer restaurants. | ||||||
| 26 | Franchised openings, % of plan, selected scenario | % | 100.0% | |||||||
| 27 | Sale price per restaurant refranchised | $m | 1.15 | |||||||
| 29 | Average unit volume and same-restaurant sales | |||||||||
| 30 | Average unit volume, mature restaurant, FY0 | $m a year | 2.00 | The same for a company and a franchised restaurant. | ||||||
| 31 | New restaurant volume, first year, % of mature | % | 85.0% | |||||||
| 32 | New restaurant volume, second year, % of mature | % | 95.0% | Mature, at 100%, from the third year. | ||||||
| 33 | Menu price increase, annual | % | 2.5% | From FY1, in every scenario. | ||||||
| 35 | Traffic and inflation by scenario | |||||||||
| 36 | Traffic growth, base and accelerated | % | 0.5% | Annual change in transactions per mature restaurant, from FY1. | ||||||
| 37 | Traffic growth, downturn | % | -2.0% | |||||||
| 38 | Traffic growth, selected scenario | % | 0.5% | |||||||
| 39 | Food and paper cost inflation, base and accelerated | % | 2.5% | |||||||
| 40 | Food and paper cost inflation, downturn | % | 4.0% | |||||||
| 41 | Food and paper cost inflation, selected scenario | % | 2.5% | |||||||
| 42 | Restaurant wage inflation, base and accelerated | % | 3.5% | |||||||
| 43 | Restaurant wage inflation, downturn | % | 4.5% | |||||||
| 44 | Restaurant wage inflation, selected scenario | % | 3.5% | |||||||
| 46 | Company restaurant costs | |||||||||
| 47 | Food and paper, % of sales, FY0 | % | 30.5% | |||||||
| 48 | Labour per restaurant, FY0 | $m a year | 0.62 | Crew and restaurant managers. Per restaurant, so it does not fall when traffic does. | ||||||
| 49 | Occupancy per restaurant, FY0 | $m a year | 0.19 | Rent, property taxes and utilities. | ||||||
| 50 | Of which rent, FY0 | $m a year | 0.12 | Kept in occupancy as an operating lease cost; capitalised only in the lease-adjusted leverage. | ||||||
| 51 | Occupancy cost growth, annual | % | 2.5% | |||||||
| 52 | Other restaurant operating costs, % of sales | % | 8.5% | Card and delivery fees, repairs, supplies and insurance. | ||||||
| 54 | Royalty, fees and the advertising fund | |||||||||
| 55 | Royalty, % of franchised sales | % | 5.0% | |||||||
| 56 | Initial franchise fee per restaurant | $m | 0.05 | On each franchised opening and each restaurant refranchised, recognised in the year. | ||||||
| 57 | Advertising fund contribution, % of sales | % | 4.0% | Paid by every restaurant, company and franchised, and spent in full. | ||||||
| 59 | General and administrative costs | |||||||||
| 60 | Corporate costs, FY0 | $m | 105.0 | Head office, brand, technology and finance. Fixed. | ||||||
| 61 | Field management per company restaurant, FY0 | $m a year | 0.05 | Area managers and above-restaurant operations. | ||||||
| 62 | Franchise support per franchised restaurant, FY0 | $m a year | 0.01 | |||||||
| 63 | Corporate costs taken out per restaurant refranchised | $m a year | 0.04 | At FY0 prices, on restaurants sold from FY1. Payroll, accounting and systems a smaller company estate no longer needs. | ||||||
| 64 | Growth in general and administrative costs, annual | % | 3.0% | |||||||
| 66 | Capital spending, working capital and tax | |||||||||
| 67 | Build cost per new company restaurant | $m | 1.25 | Building, kitchen and pre-opening costs, net of landlord contributions. Fixed in money terms. | ||||||
| 68 | Maintenance and remodelling per company restaurant | $m a year | 0.06 | |||||||
| 69 | Technology and corporate capital spending | $m | 20.0 | A year. | ||||||
| 70 | Net PP&E, FY0 | $m | 680.0 | |||||||
| 71 | Depreciation, % of opening net PP&E | % | 9.0% | |||||||
| 72 | Net working capital, % of company restaurant sales | % | -4.0% | Negative: customers pay at the counter and suppliers are paid later. | ||||||
| 73 | Tax rate | % | 25.0% | |||||||
| 75 | Securitised notes and capital returns | |||||||||
| 76 | Securitised notes, FY0 | $m | 1,550.0 | Secured on royalties, fees and company restaurant profits. | ||||||
| 77 | Coupon | % | 5.0% | Fixed. Charged on the opening balance. | ||||||
| 78 | Scheduled amortisation, % of original principal | % | 1.0% | A year, while the leverage test is failed. | ||||||
| 79 | Non-amortisation test: notes / EBITDA at or below | x | 5.0x | On the opening balance and the previous year’s EBITDA. | ||||||
| 80 | Cash trap: debt service coverage below | x | 1.8x | Below it cash is held back and nothing is bought back. | ||||||
| 81 | Multiple of rent capitalised in lease-adjusted leverage | x | 8.0x | |||||||
| 82 | Cash, FY0 | $m | 180.0 | |||||||
| 83 | Cash kept in the business | $m | 150.0 | Cash above it is used to buy back shares. | ||||||
| 84 | Dividends, % of net income | % | 40.0% | |||||||
| 85 | Shares in issue, FY0 | m shares | 40.00 | |||||||
| 86 | Share price, FY0 | $ per share | 60.00 | Buybacks are made at this price grown each year. | ||||||
| 87 | Growth in the buyback price, annual | % | 8.0% | |||||||
| 89 | Valuation | |||||||||
| 90 | Discount rate (WACC) | % | 8.0% | Valued at the end of FY0. | ||||||
| 91 | EV / EBITDA, company restaurants | x | 7.5x | On restaurant margin less field management. | ||||||
| 92 | EV / EBITDA, franchise royalties and fees | x | 15.0x | On 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.
- Browse without an accountPreview every model online, sheet by sheet, with its outputs and checks.
- 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.
- 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.
- 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.
Build · Lab · ~12 min
Unit Economics
Build an LTV:CAC you could defend under questioning, and answer payback as its own question.
Build · Lab · ~3 min
Name That Multiple
Place a business in the right EV/EBITDA band from its quality alone, and say what drives it.
Build · Lab · ~10 min
Covenant Headroom
Compute the three maintenance ratios from a certificate, find the binding test and its EBITDA cushion, and say whether a given downside breaches.
Read · Guide · 7 min
Equity Research Interview Questions: The Coverage Mindset
Read · Guide · 10 min
Scenario and Sensitivity Architecture: Building a Model That Can Be Stress-Tested
Read · Guide · 7 min
Enterprise Value vs. Equity Value, Once and For All
Apply · Skill
Company Profile
Build a banker-grade one-pager on any company, fast.
Apply · Skill
Model Audit
Find the errors in a financial model before someone senior does.
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.