Royalty Statements: Building the Quarterly Statement and Late-Payment Interest
This lesson is part of the course
In this lesson
You build a quarterly royalty statement with SUMPRODUCT, credit the remaining advance, then check a year of payments against the due dates with DAYS and calculate late-payment interest at a fictional contract rate.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- The Royalty Base: Gross Sales, Allowed Deductions & Net Sales by Category Locked
- Territories & Currencies: Local Sales, Contract FX Rates and Royalties in Dollars Locked
- Minimum Guarantees: Earned Royalties, Shortfall Payments & What Is Due Each Year Locked
- Advances & Recoupment: Cumulative Royalties, Unrecouped Balance and the Recoupment Quarter Locked
- The Licensee's P&L: Wholesale Margin after Royalty, Marketing Fund and the Affordable Rate Locked
- Royalty Statements: Building the Quarterly Statement and Late-Payment Interest Locked
- Royalty Audits: Under-Reported Sales, Extra Royalty and Audit Cost Shifting Locked
- The Licensor's Portfolio: Income by Category, Concentration and Renewal Decisions Locked