Chapter 25 Exercises: Revenue Modeling and Financial Planning

Exercise 25.1 — Income History Audit

Objective: Build your 12-month income dataset as the foundation for all financial modeling.

Instructions: 1. Access your records for the past 12 months: bank statements, PayPal/Stripe dashboards, AdSense reports, affiliate dashboards, brand deal invoices. 2. Create a spreadsheet with the following columns: Month, Ad Revenue, Brand Deals, Product Sales, Subscription MRR, Affiliate Revenue, Other, Total. 3. Fill in every month as completely as possible. Use $0 for months with no income in a given stream. 4. Calculate the following for each revenue stream: mean, standard deviation, minimum, maximum, and coefficient of variation. 5. Identify your most volatile stream (highest CV) and your most stable stream (lowest CV).

Deliverable: A completed 12-month income spreadsheet with summary statistics for each stream.

Reflection question: What surprised you most about your income distribution? Were there patterns you did not expect?

Exercise 25.2 — Monte Carlo Simulation Setup

Objective: Configure and run the revenue_forecast.py script with your actual data.

Instructions: 1. Install required Python libraries: pip install numpy matplotlib pandas scipy 2. Open code/revenue_forecast.py and locate the sample data section near the top. 3. Replace the sample RevenueStream definitions with your own top three revenue streams, using the mean and standard deviation you calculated in Exercise 25.1. 4. For seasonal factors, create a 12-element list where each element is a multiplier. Start with 1.0 for all months, then adjust based on your historical patterns (e.g., if December is 40% above average, set index 11 to 1.4). 5. Run the simulation and examine the output table.

Deliverable: A screenshot or printed output of your Monte Carlo results table showing P10–P90 for each of the next 12 months.

Analysis questions: - What is your P10 for your worst expected month in the next 12 months? - Does your P10 exceed your monthly expenses? If not, what is the shortfall? - What is your P90 for your best expected month?

Exercise 25.3 — Volatility Report

Objective: Use income_volatility.py to generate a complete volatility analysis of your income.

Instructions: 1. Export your monthly income data from Exercise 25.1 as a CSV file with columns month, year, income. 2. Open code/income_volatility.py and update the file path to point to your CSV. 3. Run the script and review the generated output, including: volatility metrics table, income histogram, time series chart, and streak analysis. 4. Save the output charts.

Deliverable: Your volatility report output including your Creator Income Score and longest below-average streak.

Analysis questions: - What is your coefficient of variation? How does it compare to the benchmarks in the chapter? - What is your Creator Income Score? - What is your longest historical streak of consecutive below-average months? - Based on your streak length, what is your precise cash reserve target?

Exercise 25.4 — Cash Flow Calendar Construction

Objective: Map your seasonal income patterns and build a 12-month planning calendar.

Instructions: 1. Using your 12-month income history, calculate which months are above your average, which are at-average (within 10%), and which are below average. 2. Create a 12-month calendar (can be done in Google Sheets, Excel, or even on paper). 3. Color-code each month: green = historically strong, yellow = average, red = historically weak. 4. For each red month, calculate the expected income gap (average monthly income minus expected red-month income). 5. Calculate the total savings you would need to cover all red-month gaps.

Deliverable: A visual 12-month cash flow calendar with gap analysis and total reserve requirement.

Planning questions: - When should you accumulate savings most aggressively? - If you planned one major product launch, which month would maximize its impact given your audience engagement patterns? - Are there any structural changes (content cadence, promotion timing) that could smooth your seasonal curve?

Exercise 25.5 — Revenue Stack Optimization Analysis

Objective: Calculate effective hourly rates for each revenue stream and identify your highest-leverage opportunities.

Instructions: 1. For each of your active revenue streams, estimate the average hours per month you spend maintaining or generating that stream (include production, admin, and maintenance time). 2. Calculate the effective hourly rate: Monthly Revenue / Monthly Hours. 3. Rank your revenue streams from highest to lowest effective hourly rate. 4. For each stream, estimate what would happen to revenue if you spent 5 more hours per week on it (be realistic about diminishing returns). 5. Run the "drop one stream" scenario in your Monte Carlo model: remove your largest stream entirely and look at your new P10.

Deliverable: A revenue stream ranking table with effective hourly rates and a "drop one stream" sensitivity analysis.

Strategic questions: - Which stream has the highest effective hourly rate? Does this surprise you? - Which stream has the most unrealized potential with marginal time investment? - If your largest stream disappeared tomorrow, would your P10 still cover your monthly expenses?

Exercise 25.6 — Implement the 30/30/30/10 System

Objective: Set up a functional income allocation system for your creator business.

Instructions: 1. If you do not already have a dedicated business bank account, research three options (most banks offer free business checking for sole proprietors). Note the minimum balance requirements and any fees. 2. Set up (or plan to set up) a separate high-yield savings account specifically for tax reserves. 3. Calculate what 30/30/30/10 would look like for your average monthly income. Use actual numbers. 4. Identify any adjustments needed: if your operating expenses are actually 40% of income, you need to either cut costs or adjust the percentages and reduce savings temporarily. 5. Write a one-page personal financial protocol: what happens to every dollar you earn, in what sequence, automatically if possible.

Deliverable: A written income allocation protocol with specific dollar amounts based on your average monthly income.

Exercise 25.7 — Three-Year Financial Projection

Objective: Build a simplified three-year financial projection combining your Monte Carlo base case with planned growth.

Instructions: 1. Using your Monte Carlo median (P50) as Year 1 base, project Year 2 and Year 3 income by estimating realistic growth rates for each revenue stream (be conservative — 20–30% annual growth for established streams is ambitious). 2. Project expenses at Year 1, Year 2, and Year 3, recognizing that costs often grow with revenue (more content = more editing costs, larger audience = more email platform costs). 3. Calculate net income (gross minus operating expenses) for each year. 4. Apply the 30/30/30/10 rule to each year's projected net income. 5. Calculate cumulative savings and investment contributions over three years.

Deliverable: A three-year financial summary table showing revenue, expenses, net income, tax reserve, and savings for each year.

Reflection: How does seeing three years projected at once change how you think about near-term decisions? What would you invest in today if you knew these projections were reasonable?