Music Royalties: Streaming Payouts, Splits, Publishing & Recoupment

What you'll build

What you will be able to do

Each lab ends with a concrete result that you build yourself and the checker confirms, cell by cell.

• Turn one month of a fictional service's revenue into a royalty pool, work out the pool per 1,000 streams, pay out five of Juno Vale's tracks by their share of all streams and see how a busier month dilutes her payout.
• Read one month of Juno's distributor statement: payout per 1,000 streams for six fictional services, the blended rate, each service's share of streams vs share of money, the streams needed for an income target and a sorted bar chart of the rates.
• Split a year of Glass Harbour's streaming money into master and publishing royalties, break publishing down into mechanical, performance and other income with the writer and publisher halves, compare three publishing deals and add up what Juno takes home.
• Pay three songwriters from a split sheet, check that the splits add up to 100 %, take the producer's and mixer's points out of Juno's all-in artist royalty and work out what Low Tide pays her per 1,000 streams.
• Run Juno's record deal through eight half-year statements: her 20 % royalty, the cumulative royalty, the unrecouped balance of a 150,000 advance plus recording costs, and the first statements that actually pay her.
• Compare three routes for Juno's next album over three years: a flat-fee distributor, a commission distributor and a label deal with an advance and recoupable costs, find the best route and the label income at which the label deal breaks even.
• Split a TV-ad sync fee between the master and publishing sides, work out Juno's part, then summarise twelve months of her income lines by type with SUMIF, calculate each type's share and name the largest.
• Value Harbourlight's rights in two Juno Vale albums: forecast the net label share down a decay curve for ten years, discount it, add a terminal value, turn the result into a multiple of last year's NLS, decide on a buyer's offer and chart the decay.