The worksheet is 18 number fields in two groups: 15 lines that follow the categories in Item 7 of the FDD, and three lines for cash that Item 7 leaves out. As you type, the page adds each group into a subtotal and adds the two subtotals into one figure labeled "Total cash you would need." That is all it does. A blank field counts as zero, a negative entry counts as zero, and any single entry is capped at $100,000,000. It has no default numbers, applies no inflation or contingency percentage, calculates no loan interest or payment, and does not compare your figures to any brand. The arithmetic runs in your browser as you type.
The first group follows the FTC's own description of Item 7. ItsFranchise Rule Compliance Guidesays Item 7 does not prescribe an exhaustive list, and names the typical expenses as the initial franchise fee, training, real property, equipment, beginning inventory, and business licenses, plus any other required payment the franchisee must make to open. The worksheet splits those into familiar lines such as signage, insurance, and technology. Your brand's table may combine or split them differently, so match your figures to the brand's rows rather than forcing them to ours.
One design choice deserves a warning. The single total adds a number the franchisor discloses (Item 7) to numbers you choose (the cushion). When you compare two brands, compare their Item 7 subtotals with each other, and add your own cushion once, on top, so a brand does not look cheaper only because you padded the other one more.
How to read each Item 7 line
For every line in the Item 7 chart the guide says a franchisor must disclose the amount, the method of payment, when the payment is due, and to whom it is paid. If an amount is unknown, the franchisor may give a low-high range based on its current experience. Item 7 must also state, in footnotes, whether each payment is refundable and under what conditions. Three habits follow from that.
- Budget toward the high end. The ranges come from the franchisor's own recent experience, and your site, contractor, and market are not the average one.
- Mark each line refundable or not. The footnotes tell you how much of the total is gone if you walk away after signing, which is a different number from the total itself.
- Note the due date. A franchise fee due at signing and buildout draws that arrive months later put pressure on your cash at different times. A total does not show that timing.
Read the footnotes against the worksheet and theItem 7 explainer if a line is unclear.
Worked example (illustrative numbers)
These figures are invented to show the arithmetic. They are not a brand's costs, and no real brand's investment is implied. Suppose a buyer enters these Item 7 lines: franchise fee $35,000; real estate deposit and first rent $12,000; leasehold improvements $180,000; equipment $95,000; fixtures and furniture $20,000; signage $8,000; opening inventory $10,000; supplies $6,000; technology and POS $7,000; insurance $4,000; licenses and permits $3,000; professional fees $10,000; training travel $5,000; grand opening marketing $15,000; and additional funds $45,000.
The Item 7 subtotal is 35,000 + 12,000 + 180,000 + 95,000 + 20,000 + 8,000 + 10,000 + 6,000 + 7,000 + 4,000 + 3,000 + 10,000 + 5,000 + 15,000 + 45,000 = $455,000.
For the cushion, the buyer chooses three figures. An operating reserve of $60,000 (three more months at an assumed $20,000 monthly shortfall). Personal living expenses of $54,000 (twelve months at $4,500). A contingency of $27,500, which is 10 percent of the buildout and equipment lines ($180,000 + $95,000 = $275,000). The 10 percent is this example's assumption, not a standard. The cushion subtotal is 60,000 + 54,000 + 27,500 = $141,500, and the worksheet's total is 455,000 + 141,500 = $596,500.
The worksheet stops there, but the next step is by hand: subtract the cash you can commit. If the buyer has $250,000 in liquid funds, the gap is 596,500 − 250,000 = $346,500, which is the amount to fund some other way. A brand that publishes a lower Item 7 range does not change this arithmetic, it only changes the first subtotal. Notice too that the cushion is 31 percent of the Item 7 subtotal (141,500 ÷ 455,000), which is why leaving it out understates the real ask.
What Item 7 does not tell you
The same guide states that the "additional funds" line covers an initial period that is, in general, at least three months, and that the franchisor must state the period it used and the basis for its estimate. It also notes that this line generally does not include the owner's salary or draw. That is the reason the cushion section exists: three months of costs is not a plan to live on while a location ramps up, and your household bills are outside the disclosure entirely.
Item 7 also lists costs only. The guide notes that listing expenses in Item 7 does not trigger an Item 19 disclosure, and that a franchisor may include financial performance representations in Item 19 but is not required to. So a complete, well-footnoted Item 7 can sit next to an Item 19 that says nothing about sales. The worksheet total tells you the price of entry, never the return. Read how to read an FDD for what to look for, and for coffee brands see how to read a coffee franchise Item 19.
Recurring franchisor charges are also outside this worksheet. Item 6 covers royalties, advertising fees, and transfer fees, and the guide says it does not cover payments made directly to third parties. Once you have your opening cash, the recurring costs belong in a monthly budget, such as our coffee shop monthly budget template, andItem 6 explained shows how to read the fee table.
A tax note before you finalize the numbers
IRS Publication 583 (12/2024) says you can elect to deduct up to $5,000 of business start-up costs and up to $5,000 of organizational costs, that each $5,000 is reduced by the amount the costs exceed $50,000, and that the remainder must be amortized. It describes start-up costs as expenses incurred before the business begins operating, and gives advertising, travel, surveys, and training as examples. The worksheet does not classify any line for tax. Ask a CPA which of your lines are start-up costs and which are assets you depreciate, because that changes how the money comes back to you, not how much you need to open.
Use the worksheet inside the 14-day window
Under 16 CFR 436.2(a), a franchisor must give you its disclosure document at least 14 calendar days before you sign a binding agreement or pay it anything in connection with the sale. Fill in the worksheet from that document during those days, bring the high-end total and the refundability notes to a franchise attorney, and ask current franchisees whether their real opening costs landed inside the range. For a cafe you would build from scratch instead of buying into a system, thecoffee shop startup cost calculator gives a sourced estimate to check against.