Franchise Financial Projections Template
By FranchiseFeast Editorial
A financial projection is where a franchise plan meets arithmetic. This free three-year Excel workbook gives you the structure of a franchise profit-and-loss projection, revenue, cost of goods, operating expenses, and the royalty and ad-fund fees that are unique to franchising, so you can model your own numbers year over year. It ships blank. You enter every figure from your brand's FDD and your own research, and the sheet does the math.
Opens in Excel, Google Sheets, or Numbers. It ships blank, with built-in formulas that total each section and calculate net income and margin as you type.
What each section is for
| Section | What you enter | Where to find it |
|---|---|---|
| Revenue | Your own projected sales, split into up to three streams, for each of the three years. | Your market research; a franchisor's Item 19 if it provides one |
| Cost of goods sold (COGS) | Your cost of the product you sell, by line. The sheet totals it and subtracts it from revenue to show gross profit. | Your own operating estimates; Item 7 for opening inventory |
| Operating expenses | Labor, occupancy, utilities, marketing, insurance, and other operating costs you enter yourself. | Your own local estimates and quotes |
| Franchise fees | You enter only the royalty rate and the ad-fund rate as percentages; the sheet computes the dollar amounts from your revenue. | FDD Item 6 |
| Result (auto-calculated) | Nothing to enter. The workbook computes gross profit, total operating expenses, net operating income, and net operating margin from your inputs. | The sheet's own formulas |
How to build an honest projection
The workbook does the arithmetic; the judgment is yours. A few rules keep a franchise projection honest rather than wishful.
- Build three scenarios, not one. Run a conservative, a middle, and an optimistic version by changing your revenue assumptions, and plan around the conservative one.
- Ramp your first year. New locations rarely open at full volume, so model a slower Year 1 that builds, rather than assuming a mature run rate from day one.
- Use real fee percentages. Pull the royalty and ad-fund rates straight from the brand's FDD Item 6; the sheet turns them into dollars against your revenue automatically.
- Do not borrow a franchisor's numbers as your own. If a brand provides an Item 19, read its metric and sample size; it is not a promise, and its absence is not evidence either way. Your projection should rest on your assumptions, not its illustration.
- Pressure-test against people. Before you trust a revenue line, call current franchisees from the Item 20 list and ask how long their ramp actually took.
Pair this with our guide to how much a franchise really costs to open for the startup side, ourexplainer on royalty and ad-fund fees for the percentages this sheet uses, and how to read an Item 19 so you never mistake a franchisor's figure for your own.
Email yourself this projections workbook
We will email you the download link, plus the free Franchise Due-Diligence Kit. No spam, unsubscribe anytime.
The kit is educational only, not legal or financial advice. By subscribing you agree to ourterms and privacy policy. How we're paid, including referral fees:affiliate & referral disclosure.
Keep reading
Buying Process
How Much Money Do You Need to Start a Franchise?
What it really costs to open a food or coffee franchise: the franchise fee vs the FDD Item 7 total vs the cash you actually need out of pocket after financing.
Buying Process
FDD Item 7 Explained: The Real Cost Table
A line-by-line guide to Item 7 of the Franchise Disclosure Document: what each row means, what's routinely left out, and how to compare two brands correctly.
Coffee Franchises
Reading a Coffee Franchise Item 19 Without Getting Played
What Item 19 financial performance disclosures actually show, how coffee brands format them differently, and the questions no Item 19 can answer for you.
Before you rely on any number
This resource is for general educational purposes only and is not legal, financial, or tax advice. Franchise laws, the FDD, and franchise agreements vary by state and by brand. Review the full FDD and franchise agreement with a franchise attorney licensed in your state and a qualified accountant before you sign anything or pay any money.
Sources