How to Build a Franchise Pro Forma Before You Sign
A pro forma is not a projection of what you hope will happen. It is a test of whether the business survives what plausibly will.
Most candidates build one late, after they have emotionally committed, and build it to confirm a decision already made. The useful version gets built early, from sourced inputs, and is designed to find the conditions under which the deal does not work.
The Rule That Governs Everything
Franchisors cannot give you projections outside of Item 19. Under the FTC Franchise Rule, any financial performance representation must appear in Item 19 of the Franchise Disclosure Document, with a reasonable basis and substantiation available on request.
A franchise development representative who verbally tells you what you will earn is violating that rule. The correct response is to ask for it in writing, in the FDD, or to disregard it entirely.
This means the model is yours to build. The franchisor supplies disclosed data. You supply the assumptions, and you own the consequences.
See FDD Item 19 and how to read the earnings claim.
Where Each Input Comes From
A defensible pro forma sources every line. If you cannot say where a number came from, it is not an assumption, it is a wish.
| Line | Source |
|---|---|
| Revenue | Item 19 if disclosed, plus validator calls |
| Cost of goods | Validator calls, category benchmarks |
| Labor | Local wage data plus validator staffing models |
| Rent | Actual quoted terms from your broker |
| Royalty and brand fund | Item 6 |
| Technology fees | Item 6, every line |
| Insurance | Actual quotes |
| Debt service | Actual lender terms |
| Local marketing | Item 6 or 7 minimums, plus your plan |
| Opening cost | Item 7, adjusted to your market |
Two of these carry more weight than the rest.
Revenue. If the system discloses Item 19, read it precisely. Understand whether the figure is an average or a median, which units are included, how many units are excluded and why, and whether the reported units are mature or include openings. An average that includes only top-quartile units is not a forecast for your unit.
If there is no Item 19, revenue comes entirely from validation calls, and you should weight that fact heavily in your view of the opportunity.
Rent. Item 7 gives a range across the system. Your market has a price. Get real quoted terms on real sites before you finalize the model, because in brick-and-mortar concepts rent is often the difference between a workable unit and a marginal one.
Build Three Cases, Not One
A single-scenario pro forma is a marketing document. Build three.
Conservative. Revenue at the lower end of what validators report for units in their first full year. Costs at the higher end of Item 7. Opening delayed by sixty days. This is your survival case, and it is the one that matters most.
Base. Revenue at the median of comparable validator reports. Costs at the Item 7 midpoint. On-time opening.
Upside. Only useful for understanding the ceiling. Do not make decisions from it.
The decision rule is simple and unforgiving: if the conservative case does not survive with the capital you have, you do not have enough capital. Not for this deal at this time. That conclusion is worth reaching before you write the check rather than in month eight.
A pro forma that only works in the base case is not a plan. It is a bet on nothing going wrong.
The Lines Candidates Get Wrong
Six recurring errors, in rough order of how much damage they cause.
Ramp modeled as a straight line. Revenue does not go from zero to steady state in month one, and it does not climb linearly either. Most concepts see an opening spike, a trough, and then a slower build. Model the trough.
Owner compensation omitted. If you need to draw, it is a cost. If you do not draw, say where your household income comes from. See franchise working capital.
Local marketing left out. The required minimum is a recurring obligation, separate from the brand fund. See the franchise marketing fund and who controls it.
Technology fees rolled into an "other" line. Pull them out. They are fixed and they escalate. See franchise technology fees.
Royalty calculated on net rather than gross. Most agreements charge on gross sales before discounts. Confirm the base definition and model it correctly. See franchise royalties explained.
Debt service modeled at an assumed rate. Get a real term sheet. The difference between an assumed rate and an actual one compounds across a ten-year note.
The Validation Call Is Your Data Collection
The pro forma is only as good as the operator data behind it, and Item 20 gives you the list.
Structure the calls. Ask the same questions in the same order so the answers are comparable.
- What did your first twelve months of revenue look like, quarter by quarter?
- How many months until the unit covered its own operating costs?
- What did the build-out actually cost versus what you budgeted?
- What is your labor as a percentage of sales now, and in year one?
- What surprised you on the cost side?
- What would you budget differently?
Call at least ten. Include units that opened recently and units that are five years in. If the franchisor limits who you can speak with, that is itself a data point.
Stress Testing
Once the model runs, break it deliberately.
- Revenue ten percent below the conservative case
- Labor cost up fifteen percent
- Opening delayed ninety days
- Cost of goods up ten percent for two quarters
- One equipment failure requiring a mid-five-figure repair
Any one of these is an ordinary business event. Your model should survive each of them individually and should tell you which combination breaks it. Knowing your break point in advance is what lets you act early rather than react late.
The Practical Takeaway
Build the pro forma before you fall in love with the concept, source every line, and run three cases with the conservative case as the decision case.
The output you want is not a revenue number. It is an answer to two questions: how much capital does this actually require, and what has to go wrong before I am in trouble? A model that answers both is worth more than any projection anyone could hand you, and it is the only projection the rules allow you to rely on.
Financial modeling is specific to your situation. Work with an accountant and consult the current FDD. This is not financial, tax, or legal advice.
Explore franchise opportunities we currently represent at unitlockfranchising.com/brands.
Ready to scale your franchise?
Let's discuss how UnitLock can help you grow the right way.
Get Started