MG shortfall projection template (Excel)
An Excel template that projects each agreement's minimum-guarantee position — cumulative earned royalties to date against the MG, a run-rate projection through the guarantee period, and the projected shortfall (or surplus) with the settlement amount per agreement, next to each agreement's settlement terms.
Free for brand, retailer, wholesaler and manufacturer teams. We email the link to your work address; requests from companies we can’t verify are reviewed first.
To check a request we may look at your company’s public website, sometimes with the help of an AI research assistant. Only your company name and web domain are used for that, never your name or email.
Inside the template
Per-agreement MG register (guarantee amount, period, settlement terms)
Cumulative earned royalties vs. MG tracking by period
Run-rate projection to period end with seasonality adjustment row
Projected shortfall / surplus and settlement amount per agreement
Portfolio view: every MG position on one tab
Example data for collegiate + pro sports + golf agreements
Best fit
Apparel finance teams with MG-bearing agreements who want shortfalls to show up in the forecast months early — as a budgeted settlement, not a year-end discovery.
Templates help. The platform replaces them.
Walk through royalty calculation, statement generation, advance recoupment, and audit trail in a free trial — no credit card, no commitments.