Appendix C: Revenue Calculator Worksheets
How to Use These Worksheets
Each worksheet walks through a specific revenue stream step by step. For each calculation, you will find: - The formula - The inputs you need to gather - A worked example using a fictional creator (Maya for solo creator examples, Marcus for community/membership examples) - Fill-in blanks for your own numbers
Work through all six worksheets to build your complete revenue picture. Worksheet 6 is a summary that combines everything into one view.
Important notes on accuracy: These worksheets produce estimates, not guarantees. Revenue varies by niche, audience quality, seasonal trends, and execution quality. Run these calculations with conservative, realistic, and optimistic scenarios. The conservative scenario (low conversion rates, lower CPMs) should still be a business you can survive on. Build toward the realistic scenario. The optimistic scenario shows you what upside is possible.
The worked examples use consistent characters. Maya is a 28-year-old YouTube creator in the personal finance space with 85,000 subscribers and a 23,000-person email list. Marcus runs a paid community for independent consultants, currently at 340 paid members at $97/month.
Worksheet 1: Ad Revenue Calculator
Ad revenue from platform monetization programs (YouTube AdSense, TikTok Creator Rewards, etc.) is the most straightforward revenue stream to model, though it is often the most volatile in practice.
Key Terms
CPM (Cost Per Mille): What advertisers pay per 1,000 ad impressions. This is set by advertisers and varies by niche, season, and geography.
RPM (Revenue Per Mille): What you actually earn per 1,000 views after the platform takes its cut. RPM is always lower than CPM. On YouTube, RPM is typically 45–55% of CPM; the rest is platform revenue share.
Ad fill rate: The percentage of video views that serve an actual ad. Not every view gets an ad — fill rate varies by region and device.
Step 1: Look Up Your Niche CPM Range
The table below shows average CPM ranges by content niche in the United States market (Q1 2026 estimates). Non-US audiences typically earn 30–70% lower CPMs.
| Niche | CPM Low | CPM High | RPM Estimate |
|---|---|---|---|
| Personal Finance / Investing | $12 | $30 | $6–$17 | |
| Business / Entrepreneurship | $10 | $25 | $5–$14 | |
| Real Estate | $10 | $22 | $5–$12 | |
| Software / B2B Tech | $8 | $20 | $4–$11 | |
| Health / Wellness (general) | $5 | $14 | $3–$8 | |
| Beauty / Skincare | $4 | $12 | $2–$7 | |
| Fitness / Bodybuilding | $4 | $10 | $2–$6 | |
| Food / Cooking | $3 | $9 | $1.50–$5 | |
| Travel | $3 | $8 | $1.50–$4.50 | |
| Education (K-12 / academic) | $4 | $10 | $2–$6 | |
| Parenting | $4 | $10 | $2–$6 | |
| Gaming | $2 | $6 | $1–$3.50 | |
| Entertainment / Lifestyle | $2 | $6 | $1–$3.50 | |
| Comedy / Sketch | $2 | $5 | $1–$3 | |
| True Crime / Storytelling | $3 | $8 | $1.50–$4.50 |
[ YOUR NICHE ]: [ CPM RANGE FOR YOUR NICHE ]: $_____ low — $_ high [ ESTIMATED RPM ]: $___ (use 50% of midpoint CPM as a starting estimate)
Step 2: Calculate Monthly Views
| Input | Your Number |
|---|---|
| Average videos published per month | |
| Average views per video (last 90 days) | |
| Monthly views = videos × avg views per video |
[ YOUR MONTHLY VIEWS ]:
Step 3: Calculate Monthly Ad Revenue
Formula: Monthly Revenue = (Monthly Views ÷ 1,000) × RPM
| Scenario | RPM Used | Monthly Views | Monthly Revenue |
|---|---|---|---|
| Conservative | $_____ (low RPM) | | $ | ||
| Realistic | $_____ (mid RPM) | | $ | ||
| Optimistic | $_____ (high RPM) | | $ |
[ YOUR ESTIMATED MONTHLY AD REVENUE ]: $_____ (realistic)
Step 4: Seasonal Adjustment
Ad rates peak in Q4 (October–December) due to holiday advertiser spending and drop to their lowest in Q1 (January–February). Apply these multipliers to your monthly estimate for a more accurate annual projection.
| Month | Multiplier | Your Monthly Estimate | Adjusted Estimate |
|---|---|---|---|
| January | 0.65 | ||
| February | 0.70 | ||
| March | 0.85 | ||
| April | 0.90 | ||
| May | 0.95 | ||
| June | 0.95 | ||
| July | 0.90 | ||
| August | 0.90 | ||
| September | 1.00 | ||
| October | 1.20 | ||
| November | 1.35 | ||
| December | 1.55 | ||
| ANNUAL TOTAL | $ |
Worked Example: Maya's YouTube Channel
Maya's personal finance YouTube channel publishes 3 videos per week, averaging 18,500 views per video. Monthly views: 3 × 4.3 weeks × 18,500 = approximately 238,650 views/month.
Finance niche RPM estimate: $9.50 (realistic mid-range)
Monthly ad revenue: (238,650 ÷ 1,000) × $9.50 = $2,267
Annual estimate with seasonal adjustment: - Q1 (Jan–Feb average multiplier 0.675): $2,267 × 0.675 × 2 = $3,061 - Q1 cont. (March): $2,267 × 0.85 = $1,927 - Q2–Q3 (Apr–Sep, average 0.935): $2,267 × 0.935 × 6 = $12,717 - Q4 (Oct–Dec, average 1.367): $2,267 × 1.367 × 3 = $9,296
Estimated annual YouTube ad revenue: approximately $27,000
Maya's conclusion: Ad revenue alone does not meet her income target. She plans to layer in brand deals and a digital product to reach $120,000 annually.
Worksheet 2: Brand Deal Rate Calculator
Brand deal revenue is typically the highest-revenue stream for mid-sized creators (10,000–500,000 followers), but it requires active business development and negotiation.
Step 1: Calculate Your Baseline Rate Using the CPM Method
Formula: Baseline Rate = (Typical Views on Sponsored Content ÷ 1,000) × $25
The $25 CPM is a conservative starting point for mid-tier creators. It reflects the value of creator-produced content versus display advertising. Adjust upward as your engagement metrics and niche prestige increase.
| Input | Your Number |
|---|---|
| Average views on your sponsored posts (last 3) | |
| Or average views on your last 10 posts if no sponsors yet | |
| Baseline Rate = (views ÷ 1,000) × $25 | $ |
Step 2: Engagement Rate Premium Method
Engagement rate = (likes + comments + saves) ÷ followers × 100
High engagement rates command a premium over CPM-only rates.
| Engagement Rate | Premium Multiplier |
|---|---|
| Below 1% | No premium; may need to justify rate |
| 1–2% | 1.0× (baseline) |
| 2–4% | 1.25× |
| 4–6% | 1.5× |
| 6–10% | 2.0× |
| Above 10% | 2.5× (exceptional; document this clearly) |
| Input | Your Number |
|---|---|
| Total engagement (likes + comments + saves) on last 10 posts | |
| Total divided by 10 = average engagement | |
| Followers | |
| Engagement rate = (average engagement ÷ followers) × 100 | % |
| Premium multiplier (from table above) | × |
| Adjusted rate = Baseline × Multiplier | $ |
[ YOUR BASELINE RATE ]: $ [ YOUR ENGAGEMENT-ADJUSTED RATE ]: $ [ USE THE HIGHER OF THE TWO ]: $
Step 3: Rate Card by Deliverable
Use your adjusted baseline rate as your reference point and build out rates for each deliverable type.
| Deliverable | Multiplier | Your Rate |
|---|---|---|
| TikTok — Dedicated video (full video, your content) | 1.0× baseline | $ |
| TikTok — Integration (30-sec mention in longer video) | 0.5× baseline | $ |
| YouTube — Dedicated video (full video about the brand) | 3.0–5.0× baseline | $ |
| YouTube — 60-sec mid-roll integration | 1.5× baseline | $ |
| YouTube — 15-sec end-roll mention | 0.75× baseline | $ |
| YouTube Shorts — Dedicated | 0.75× baseline | $ |
| Instagram Reel — Dedicated | 1.0× baseline | $ |
| Instagram Static Post | 0.6× baseline | $ |
| Instagram Story Series (3–5 slides) | 0.4× baseline | $ |
| Instagram Link in Bio (30-day) | 0.3× baseline | $ |
| Newsletter — Top placement (first mention, 100–150 words) | Per 1,000 subscribers × $3–$5 | $ |
| Newsletter — Sidebar / secondary | Per 1,000 subscribers × $1.50–$2.50 | $ |
| Newsletter — Dedicated edition | Per 1,000 subscribers × $6–$10 | $ |
| Podcast — 30-sec pre-roll spot | Per 1,000 downloads × $18–$25 | $ |
| Podcast — 60-sec host-read mid-roll | Per 1,000 downloads × $25–$40 | $ |
| Podcast — Episode sponsorship (named sponsor) | Per 1,000 downloads × $35–$60 | $ |
Step 4: Rate Adjustment Multipliers
Apply these multipliers on top of your base rate to account for additional value delivered.
| Factor | Adjustment | Notes |
|---|---|---|
| Exclusivity — 30-day category lock | +20–30% | You cannot work with competing brands for 30 days |
| Exclusivity — 60-day category lock | +40–50% | More restrictive; higher premium |
| Exclusivity — 90+ day or open-ended | +75–100%+ | Rarely worth it; negotiate hard or decline |
| Usage rights — online only, 6 months | Included | Standard; no extra charge |
| Usage rights — paid social amplification | +25–50% | Brand runs ads using your content |
| Usage rights — all media, perpetual | +75–150% | Brand can use your face and content forever; price accordingly |
| Rush delivery — less than 5 business days | +15–25% | You are disrupting your content calendar |
| Rush delivery — less than 48 hours | +40–60% | Emergency rate |
| International / cross-territory use | +20–40% per additional major territory | |
| White-label / brand takeover (no creator credit) | +50–100% | You lose attribution and SEO value |
| Cause misalignment (you believe in this) | Possible discount | Your decision; but do not discount more than 20% |
Worked Example: Maya's Rate Card Evolution
Year 1 (12,000 YouTube subscribers, 8,000 TikTok followers): - Average views on sponsored content: 4,200 - Baseline CPM rate: (4,200 ÷ 1,000) × $25 = $105 - Engagement rate: 4.8% → 1.5× multiplier - Year 1 rate for TikTok dedicated video: ~$157
Year 3 (85,000 YouTube subscribers, 72,000 TikTok followers): - Average views on sponsored YouTube content: 42,000 - Baseline CPM rate: (42,000 ÷ 1,000) × $25 = $1,050 - Engagement rate: 3.2% → 1.25× multiplier - Year 3 rate for YouTube 60-sec integration: $1,050 × 1.25 × 1.5 = $1,969 (approximately $2,000) - Year 3 rate for YouTube dedicated video: $1,050 × 1.25 × 3.5 = $4,594 (approximately $4,500–$5,000)
Maya targets 4 brand deals per month at an average of $3,500 each = $14,000/month brand deal revenue = $168,000/year.
Worksheet 3: Subscription and Membership Revenue Model
Subscription revenue (via Patreon, Substack, Circle, Kajabi, or direct) is the most predictable revenue stream in the creator economy — it is recurring, audience-driven, and not dependent on brand budgets.
Step 1: Monthly Recurring Revenue (MRR) Calculation
MRR = Number of active subscribers × Monthly price per subscriber
| Input | Your Number |
|---|---|
| Current paid subscribers | |
| Monthly price (or average across tiers) | $ |
| Current MRR | $ |
Step 2: Churn Impact Model
Churn is the percentage of subscribers who cancel each month. Even small churn rates significantly erode MRR over time. This table shows what 5% monthly churn does to a base of 200 subscribers with no new additions.
| Month | Start Subscribers | Lost to Churn (5%) | End Subscribers | MRR at $47/mo |
|---|---|---|---|---|
| Month 1 | 200 | 10 | 190 | $8,930 |
| Month 2 | 190 | 10 | 181 | $8,499 |
| Month 3 | 181 | 9 | 172 | $8,074 |
| Month 6 | 152 | 8 | 145 | $6,808 |
| Month 12 | 107 | 5 | 102 | $4,794 |
Key insight: At 5% monthly churn with no new subscribers, a community loses nearly half its members in 12 months. This is why growth (new subscriber acquisition) must consistently exceed churn. A sustainable membership business targets monthly churn below 3%.
[ YOUR CHURN RATE ]: % per month (estimate from your data or use 5% as default) [ YOUR MONTHLY SUBSCRIBER GROWTH ]: __ new subscribers per month [ NET MONTHLY GROWTH ]: _____ (new subscribers minus churned subscribers)
Step 3: Growth Scenario — 10 New Subscribers Per Month Over 24 Months
This table shows a community starting at 50 paid members at $97/month, adding 10 net new members per month, with 3% churn.
| Month | Members | MRR | Annual Run Rate |
|---|---|---|---|
| Month 1 | 57 | $5,529 | $66,348 | |
| Month 3 | 73 | $7,081 | $84,972 | |
| Month 6 | 97 | $9,409 | $112,908 | |
| Month 9 | 121 | $11,737 | $140,844 | |
| Month 12 | 145 | $14,065 | $168,780 | |
| Month 18 | 191 | $18,527 | $222,324 | |
| Month 24 | 235 | $22,795 | $273,540 |
[ YOUR PROJECTION TABLE ]
Starting members: _ Monthly net new members: Price per month: $__
| Month | Projected Members | MRR | ARR |
|---|---|---|---|
| Month 1 | $ | $ | ||
| Month 3 | $ | $ | ||
| Month 6 | $ | $ | ||
| Month 12 | $ | $ | ||
| Month 24 | $ | $ |
Worked Example: Marcus's Membership
Marcus runs a paid community for independent consultants priced at $97/month. He currently has 340 members. He acquires an average of 22 new members per month from his newsletter and podcast, and his monthly churn is 2.8%.
MRR: 340 × $97 = $32,980 Monthly churn: 340 × 0.028 = 9.5 members lost Net monthly growth: 22 − 9.5 = 12.5 net new members Month 12 projection: 340 + (12.5 × 12) = 490 members Month 12 MRR: 490 × $97 = $47,530 Annual revenue at Month 12 run rate: $570,360
Marcus's conclusion: His membership alone exceeds his income target. His growth constraint is not product — it is new member acquisition. He will invest in a podcast advertising campaign to accelerate list growth.
Worksheet 4: Digital Product Revenue Estimator
Digital products (courses, ebooks, templates, presets, workshops, cohorts) offer the highest margin of any creator revenue stream — production cost is a one-time expense; delivery is nearly free.
Step 1: Launch Revenue Model
Launch Revenue = Email List Size × Conversion Rate × Product Price
Conversion rate benchmarks by product type and list quality:
| Product Type + List Quality | Conversion Rate |
|---|---|
| Low-ticket ebook ($7–$27), warm engaged list | 2–5% |
| Low-ticket template/preset ($15–$49), warm engaged list | 1.5–4% |
| Mid-ticket mini-course ($97–$297), warm engaged list | 0.5–2% |
| Mid-ticket workshop ($47–$147), warm engaged list | 1–3% |
| High-ticket course ($497–$997), warm engaged list | 0.3–1% |
| High-ticket course ($1,000+), warm engaged list | 0.1–0.5% |
| Any product, cold or disengaged list | Reduce all rates by 50–70% |
| Cohort / limited enrollment (creates urgency) | Add 25–50% to relevant range |
[ LAUNCH REVENUE CALCULATION ]
| Input | Your Number |
|---|---|
| Email list size | |
| Product price | $ |
| Conversion rate (from table above) | % |
| Launch revenue estimate = list × conversion rate × price | $ |
| Scenario | Conversion Rate | Estimated Launch Revenue |
|---|---|---|
| Conservative | % | $ |
| Realistic | % | $ |
| Optimistic | % | $ |
Step 2: Evergreen Monthly Revenue Model
After a launch, products can sell continuously through your content funnel.
Monthly Revenue = Monthly New Visitors × Landing Page Conversion Rate × Product Price
| Landing Page Type | Conversion Rate Benchmark |
|---|---|
| Organic traffic (SEO / video / social) | 1–3% |
| Email traffic to sales page | 2–5% |
| Paid ad traffic (cold) | 0.5–1.5% |
| Paid ad traffic (retargeting) | 2–4% |
[ EVERGREEN REVENUE CALCULATION ]
| Input | Your Number |
|---|---|
| Monthly new visitors to sales page | |
| Landing page conversion rate | % |
| Product price | $ |
| Monthly evergreen revenue = visitors × conversion rate × price | $ |
Worked Example: Maya's Course Launch
Maya launches a course called "First $1,000 Investing: A Beginner's Blueprint" priced at $197.
Email list: 23,000 subscribers (warm, engaged — 32% open rate) Launch conversion rate estimate: 0.8% (mid-range for high-ticket course) Launch revenue estimate: 23,000 × 0.008 × $197 = $36,248
Maya runs an 8-day launch with a price increase from $147 to $197 on Day 5. She generates $41,600 across the launch window (blended conversion rate of 0.92%).
Evergreen: She redirects YouTube viewers through a "watch this next" funnel. Monthly traffic to sales page: 4,200 visitors. Conversion rate: 1.4%. Monthly evergreen revenue: 4,200 × 0.014 × $197 = $11,585/month.
Maya's conclusion: One course launch plus 6 months of evergreen sales generates approximately $110,710 in the first year of the product's life.
Worksheet 5: Affiliate Revenue Calculator
Affiliate revenue requires no product creation — you earn a commission when your audience purchases through your unique link.
The Affiliate Revenue Formula
Monthly Affiliate Revenue = Monthly Clicks × Click-to-Purchase Conversion Rate × Average Commission Per Sale
Where: - Commission Per Sale = Average Order Value × Commission Rate
Step 1: Estimate Your Click Volume
| Input | Your Number |
|---|---|
| Monthly video views on content containing affiliate links | |
| Click-through rate to affiliate links (typical: 0.5–3%) | % |
| Monthly clicks on affiliate links |
Step 2: Conversion Rate and Commission Benchmarks
| Affiliate Program Type | Conversion Rate | Typical Commission Rate | Notes |
|---|---|---|---|
| Amazon Associates | 3–8% | 1–10% (varies by category) | High conversion; low commission |
| Software / SaaS (monthly subscription) | 5–15% | 20–40% recurring | High value; recurring commission |
| Financial products (credit cards, brokerages) | 1–3% | $50–$300 per lead/account | Very high payout per conversion |
| Online courses (3rd party) | 2–8% | 20–50% | High commissions; varies widely |
| Physical products (specialty) | 2–6% | 5–15% | Moderate commissions |
| Web hosting | 5–12% | $50–$200 flat | Popular for tech/business creators |
| Fashion / apparel | 3–8% | 5–20% | Lower AOV reduces absolute revenue |
Step 3: Monthly Affiliate Revenue Calculation
| Input | Your Number |
|---|---|
| Monthly affiliate clicks | |
| Conversion rate | % |
| Average Order Value | $ |
| Commission rate | % |
| Commission per sale = AOV × commission rate | $ |
| Monthly sales = clicks × conversion rate | |
| Monthly affiliate revenue = monthly sales × commission per sale | $ |
Worked Example
Maya promotes three affiliate products in her finance content: 1. A brokerage account ($100 flat commission, 2% conversion): 800 clicks × 0.02 = 16 conversions × $100 = $1,600/month 2. A budgeting app ($29.99/year, 40% commission, 8% conversion): 600 clicks × 0.08 = 48 conversions × $11.99 = $575/month 3. A tax software ($89 average order, 15% commission, 5% conversion): 400 clicks × 0.05 = 20 conversions × $13.35 = $267/month
Total monthly affiliate revenue: $2,442
Annual affiliate revenue estimate: $29,304 (with Q4 boost for tax season increasing to ~$35,000 annually)
Worksheet 6: Creator Revenue Stack Total
This final worksheet combines all your revenue streams into a unified picture and calculates your diversification score.
Step 1: Revenue Stack Summary
| Revenue Stream | Monthly (Realistic) | Annual | % of Total |
|---|---|---|---|
| Platform ad revenue | $ | $ | % | |
| Brand deals / sponsorships | $ | $ | % | |
| Digital products (launch, avg'd monthly) | $ | $ | % | |
| Subscriptions / memberships | $ | $ | % | |
| Affiliate commissions | $ | $ | % | |
| Consulting / services | $ | $ | % | |
| Live events / speaking | $ | $ | % | |
| Physical products / merch | $ | $ | % | |
| Other | $ | $ | % | |
| TOTAL | $** | **$ | 100% |
Step 2: Revenue Mix Assessment
Healthy creator businesses generally target a revenue mix where no single stream exceeds 50% of total revenue. Use your percentages from Step 1 to assess your current mix.
| Risk Assessment | Threshold |
|---|---|
| Critically concentrated | One stream > 70% of revenue |
| Moderately concentrated | One stream 50–70% of revenue |
| Reasonably diversified | No stream > 50% |
| Well diversified | No stream > 35%; 3+ active streams |
| Optimally diversified | No stream > 25%; 4+ active streams |
[ YOUR LARGEST STREAM ]: ___% of total → Assessment:
Step 3: The Diversification Index
Diversification Index = 1 − (sum of squared percentages)
Example: Streams at 60%, 25%, 15% → DI = 1 − (0.36 + 0.0625 + 0.0225) = 1 − 0.445 = 0.555
| Score | Interpretation |
|---|---|
| 0.0–0.3 | Highly concentrated — single-platform risk |
| 0.3–0.5 | Moderately diversified — one disruption could hurt significantly |
| 0.5–0.7 | Reasonably diversified — survivable disruption to any single stream |
| 0.7–0.8 | Well diversified — healthy creator business |
| 0.8+ | Optimally diversified — best-in-class resilience |
[ YOUR DIVERSIFICATION INDEX ]:
Step 4: 12-Month Revenue Trajectory
Complete this table by carrying forward your estimates from Worksheets 1–5 and your growth assumptions.
| Month | Ad Revenue | Brand Deals | Products | Subscriptions | Affiliate | Other | TOTAL |
|---|---|---|---|---|---|---|---|
| Month 1 | $ | ||||||
| Month 2 | $ | ||||||
| Month 3 | $ | ||||||
| Month 4 | $ | ||||||
| Month 5 | $ | ||||||
| Month 6 | $ | ||||||
| Month 7 | $ | ||||||
| Month 8 | $ | ||||||
| Month 9 | $ | ||||||
| Month 10 | $ | ||||||
| Month 11 | $ | ||||||
| Month 12 | $ | ||||||
| ANNUAL | $ |
Worked Example: Maya's Complete Revenue Stack (Year 3 Projection)
| Revenue Stream | Monthly | Annual | % of Total |
|---|---|---|---|
| YouTube ad revenue | $2,267 | $27,000 | 14.8% | |
| Brand deals (4/month avg $3,500) | $14,000 | $168,000 | 92.3%... |
Revised (after digital product launch):
| Revenue Stream | Monthly | Annual | % of Total |
|---|---|---|---|
| YouTube ad revenue | $2,267 | $27,000 | 10.7% | |
| Brand deals | $10,000 | $120,000 | 47.6% | |
| Course (evergreen) | $11,585 | $67,000 | 26.6% | |
| Affiliate commissions | $2,442 | $29,304 | 11.6% | |
| Coaching (limited) | $900 | $10,800 | 4.3% | |
| Email newsletter ads | $200 | $2,400 | 1.0% | |
| TOTAL | $27,394** | **$256,504 | 100% |
Diversification Index: 1 − (0.476² + 0.266² + 0.116² + 0.107² + 0.043² + 0.010²) = 1 − (0.2266 + 0.0708 + 0.0135 + 0.0114 + 0.00185 + 0.0001) = 1 − 0.324 = 0.676
Maya's DI: 0.676 — Reasonably diversified. Her next goal is to reduce brand deal dependency below 40% by scaling the evergreen course and adding a second digital product. Target DI: 0.72+.