Calculator Inputs
Formula Used
This calculator applies contract-style sales adjustments, tiered royalty bands, minimum royalty protection, separate ad fund charges, fixed fees, and taxes.
Adjusted Sales = Gross Sales − Exempt Sales − Other Deductions
Tiered Royalty = (Band 1 Sales × Rate 1) + (Band 2 Sales × Rate 2) + (Band 3 Sales × Rate 3)
Royalty Payable = max(Tiered Royalty, Minimum Royalty)
Advertising Fund = Adjusted Sales × Advertising Fund Rate
Subtotal Before Tax = Royalty Payable + Advertising Fund + Fixed Fee + Late or Admin Fee
Tax Amount = Subtotal Before Tax × Tax Rate
Total Due = Subtotal Before Tax + Tax Amount
Tier 1 and Tier 2 caps are cumulative adjusted-sales breakpoints. Any adjusted sales above Tier 2 automatically move into Tier 3.
How to Use This Calculator
- Enter gross sales for the reporting period.
- Add exempt sales and other deductions allowed by the agreement.
- Define Tier 1 and Tier 2 adjusted-sales caps.
- Enter royalty percentages for each band.
- Include ad fund rate, minimum royalty, fixed fee, and any late fee.
- Add the applicable tax rate if charges are taxed.
- Choose the number of forecast periods and expected sales growth.
- Submit the form to view summary results, schedule totals, downloads, and the Plotly chart.
Example Data Table
| Scenario | Gross Sales | Exempt Sales | Other Deductions | Tier 1 Cap | Tier 2 Cap | Rates | Minimum Royalty |
|---|---|---|---|---|---|---|---|
| Base Month | $120,000 | $5,000 | $3,000 | $50,000 | $100,000 | 6% / 5% / 4% | $2,500 |
| Slow Period | $55,000 | $2,500 | $1,500 | $40,000 | $80,000 | 6% / 5% / 4% | $2,500 |
| High Volume | $175,000 | $8,000 | $4,000 | $60,000 | $120,000 | 6.5% / 5.5% / 4.5% | $3,000 |
Frequently Asked Questions
1. What does this calculator estimate?
It estimates royalty payable, ad fund contributions, fixed fees, taxes, minimum royalty effects, and projected totals across future reporting periods. Use it for budgeting, reviews, and scenario comparisons before finalizing payment schedules.
2. Why can royalty differ from the contract rate?
Some agreements use tiered percentages, minimum monthly royalties, exclusions, and deductions. This tool separates those elements, so your payable amount can rise above or fall below a simple flat-rate estimate.
3. What are exempt sales?
Exempt sales are revenue categories excluded by contract definitions, such as taxes collected, employee meals, gift card redemptions, or approved refunds. Always confirm exclusions directly against the signed agreement language.
4. Why include a minimum royalty?
Many franchise agreements require a floor payment even when sales are weak. The calculator compares the computed royalty against the minimum amount and uses the higher figure automatically.
5. How do tier bands work?
Adjusted sales can be split across multiple ranges. Each range uses its own percentage, which makes high-volume periods more accurate than a single blended royalty rate.
6. Can I use this during contract negotiation?
Yes. It helps model alternative royalty structures, fee caps, and reporting assumptions. Still, negotiated language should be reviewed by qualified counsel before execution.
7. Does this replace accounting or legal advice?
No. It is a planning and review tool, not legal or tax advice. Final obligations should be validated against the signed agreement, notices, and professional guidance.
8. Why export CSV and PDF files?
Exports make it easier to share scenarios with managers, accountants, and counsel. They also support audit trails, internal approvals, and side-by-side comparisons during renewals or amendments.