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 and date.
Work email required — the download starts immediately. No verification step, no follow-up sequence.
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 30-minute demo.