Multi-Unit QSR Franchise Resale Acquisition Model – Excel XLSX

BENEFITS OF THIS DOWNLOADABLE EXCEL DOCUMENT

1. System sales are built from units times AUV and then reduced by the royalty, brand fund and technology fee before anything else, which is how you see the franchisor taking about 66% of store-level EBITDA.
2. The deal is priced on Adjusted EBITDA after hiring a district manager to replace the seller's above-store supervision and funding the remodel reserve, with the broker-basis price shown alongside it.
3. Because royalty scales with sales while occupancy and management do not, a routine same-store-sales decline drives DSCR from 1.33x to 0.85x, and the model prints that stress instead of describing it.

RESTAURANT INDUSTRY EXCEL DESCRIPTION

Multi-Unit QSR Franchise Resale Acquisition Model is an Excel template (XLSX) with a supplemental PDF document available for immediate download upon purchase.

This is an acquisition model for buying an existing multi-unit quick-service-restaurant franchise operation with an SBA 7(a) loan. Most franchise templates are startup or operating forecasts for a new franchisee; this one prices a resale.

The valuation error it intercepts is the store-level sheet. A broker's package shows what the stores earn before the franchisor and before the two costs the seller does not pay. The franchisor's royalty, brand and advertising fund and technology fee come off gross sales before the operator earns anything, and on the base case those fees equal about 66% of the store-level EBITDA. Then the seller's own above-store supervision, which a buyer has to replace with a district manager, and the remodel or reimage reserve the franchise agreement will eventually force, are both treated as free.

The engine builds earnings bottom-up: units times average unit volume gives system sales, the royalty stack comes off the top, and the store P&L (food, labour, occupancy and other) lands the store-level EBITDA. The model then hires the district manager, funds the contractual remodel reserve and prices the deal on Adjusted EBITDA, showing the broker-basis price next to it so the overpay you avoid is a number rather than an argument. The headline is the true DSCR of 1.33x, computed on cash flow after above-store G&A, the district manager and the remodel reserve, printed beside the naive DSCR of 2.16x that a store-level sheet implies. Because the royalty is charged on gross sales while occupancy and management stay fixed, a normal same-store-sales decline compresses profit more than proportionally, and the model stresses that in a down-case DSCR of 0.85x, below the 1.25x lender floor.

Inside: a 10-sheet Excel workbook, Google Sheets compatible with no macros, add-ins or external links, plus a 20-plus page PDF guide covering the quick start, a sheet-by-sheet walkthrough, how the royalty-stack and FDD Item 19 engine works, the three honesty adjustments, SBA 7(a) franchise financing (the SBA Franchise Directory, an 80/10/10 structure and the seller-note standby lever) and a franchise-resale due-diligence checklist. Sheets include the unit economics and royalty engine, SDE and valuation with the district-manager add-back and the broker-basis overpay memo, sources and uses with a real-estate option block, a DSCR and debt tab with true-versus-naive DSCR, coverage before remodel, the same-store-sales down-case and a real SBA amortisation schedule, returns and exit with cash-on-cash and a five-year equity multiple, a dashboard with a DSCR sensitivity grid, and a benchmarks and sources tab. A three-way concept toggle (Burger and Sandwich QSR, Coffee and Beverage, Pizza and Delivery) re-prices the whole deal.

What the model does not claim: FDD Item 19 figures are averages that exclude underperformers, so they need normalizing before you underwrite them. There is deliberately no IRR, because on one deal it is hostage to the exit multiple. Verified by 64 automated checks across three independent calculation engines. Educational planning tool, not financial, investment, tax, lending or legal advice; confirm the FDD, the franchise agreement's remaining term and transfer terms, the leases, the seller's tax returns and your SBA term sheet before relying on any number.

Source: Best Practices in Restaurant Industry, Integrated Financial Model Excel: Multi-Unit QSR Franchise Resale Acquisition Model Excel (XLSX) Spreadsheet, ProformaWorks