The Licensor's Portfolio: Income by Category, Concentration and Renewal Decisions
This lesson is part of the course
In this lesson
You summarise a licensor's royalty income by category with SUMIFS, measure how much depends on the three biggest licensees, turn MG cover into a renewal decision with nested IF and chart the income by category.
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