Creator Economy Math: YouTube, Streaming & Sponsorships

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 six months of channel views into ad revenue: monetised playbacks × CPM, the creator's share, the RPM per month and the true six-month RPM.
• Forecast a year of channel growth when the upload schedule doubles from 4 to 8 videos a month in July: views per video, monthly views, new subscribers, churn and the subscriber count, then chart it.
• Build a sponsorship quote for a cookware brand: expected views from the median of recent videos, a CPM-based fee per deliverable, uplifts for usage rights and exclusivity, and the effective CPM the brand pays.
• Calculate a month of affiliate commissions and merch profit, compare them with ad revenue per 1,000 views and work out the merch margin.
• Turn 828,000 streams of a track into gross royalties, split them into a master and a publishing pool after fees, and pay out three collaborators with SUMPRODUCT.
• Analyse three paid membership tiers: net monthly revenue after fees, the member count each tier drifts towards, the lifetime value of one member and the blended churn.
• Build Maya's yearly profit and loss: depreciate the camera gear, add the editor and other costs, set money aside for taxes and see what is left to live on each month.
• Measure how dependent Maya's channel business is on one income source: revenue shares, a Herfindahl-Hirschman-style concentration index, a stress test and a chart of the mix.