# Streaming Model Build a streaming model for OTT platforms covering subscriber growth cohorts, content library amortisation, and hybrid revenue stacking across subscription and ad-supported tiers. - Canonical: https://finamodel.com/templates/streaming-model - Excel download: https://finamodel.com/templates/streaming.xlsx - Category: Consumer - Model type: Operating model - Difficulty: Intermediate - Audiences: Founders & operators, CFOs & FP&A, Streaming operators, Media investors, Subscription managers, Growth analysts - Tags: subscriber, churn, content-spend, arpu ## Overview Model streaming subscriber economics and content ROI so you know whether your subscriber base actually offsets content burn. The model projects subscriber growth by tier (ad-free, ad-tier), applies monthly churn rates per cohort, and calculates blended ARPU. Revenue comes from subscriptions (subs × ARPU × 12) and advertising (ad-tier subs × hours watched × ad load × CPM). Content spend is the largest cost (50-65% of revenue), modelled as capitalised and amortised over useful life (4 years for originals, contract term for licensed). The model separates cash content spend (CFI) from P&L amortisation (COGS), avoiding the double-counting trap. Key mechanics: subscriber cohorts have different churn rates and growth trajectories; early cohorts churn faster; later cohorts stick (if quality content retains them). Content amortisation front-loads (70-90% of value in Year 1), so a hit series drives profitability immediately while a flop is written off. Streaming delivery costs (CDN, AWS) scale with hours watched. Marketing is the second-largest opex (10-20% of revenue during growth, declining as scale improves). The model outputs path-to-profitability (typically Y3-Y5 at scale), shows EBITDA margin progression, and calculates FCF including the working capital timing of content payments. Target: streaming investors, acquirers of streaming assets, production companies evaluating in-house platforms, and studios planning content budgets. Works with content portfolio ROI and subscriber acquisition cost (SAC) payback analysis. ## What's included - Subscriber cohort modelling with retention curves - Multi-tier revenue build covering SVoD, AVoD, and PVOD - Content production and licensing amortisation schedules - Variable CDN and bandwidth cost scaling - Marketing spend to CAC and LTV mapping - Subscriber acquisition and retention curves by cohort - Monthly churn rates and CAC payback periods - Revenue by tier (ad-supported, premium, bundle) - Content spend by title type and hours produced - Technology and licensing cost per subscriber - EBITDA margin path to profitability ## How the Streaming Model Works: Subscribers, Content Costs and Cash Flow This streaming model template shows how subscriber growth, content spending and hybrid subscription and advertising revenue combine to drive profitability and cash flow. It is designed for evaluating a mid-tier OTT platform, whether for investment, acquisition or funding. The explanation below covers the key operating drivers, calculation flow, outputs and practical use of the model. ### Operating Drivers Behind the Streaming Model The streaming model is built around subscriber movement, tier mix and content investment. Ad-free and ad-supported subscribers are tracked separately, with gross additions, churn and migration between tiers determining closing balances. - Churn is annualised from monthly rates and applied to opening subscribers, avoiding circularity. Revenue per user combines subscription ARPU with advertising yield, where ad revenue depends on hours watched, ad load and CPM. - Content spend is set as a percentage of revenue and split between originals and licensed titles, with originals amortised on an accelerated schedule and licensed content straight-line over its licence term. Payment processing and app-store commissions are treated as variable costs, and technology, marketing, G&A and support form the operating expense base. ### How Revenue and Costs Flow Through the Model The calculation flow starts with the subscriber forecast, which feeds the revenue build. Subscription revenue is closing subscribers times monthly ARPU times twelve, while advertising revenue is ad-tier subscribers times monthly hours times ad minutes per hour times CPM divided by one thousand, annualised. - Licensing revenue is held flat. Total revenue then drives content spend, which is separated into a cash outflow in investing activities and an amortisation charge in cost of goods sold. - This distinction prevents double-counting and ensures the content library roll-forward stays accurate. The income statement deducts content amortisation, streaming delivery and payment processing to arrive at gross profit, then subtracts operating expenses to reach EBITDA. Depreciation, interest and tax lead to net income, which feeds retained earnings and the balance sheet. ### Outputs: KPIs, Financial Statements and Valuation The model produces a dashboard with headline KPIs by year, including closing subscribers, tier mix, blended ARPU, revenue growth, gross margin, EBITDA and free cash flow. - Unit economics such as customer acquisition cost, lifetime value, LTV/CAC and payback are calculated from marketing spend, churn and gross margin. - The income statement, balance sheet and cash flow statement are fully integrated, with working capital driven by days sales outstanding, days payable outstanding and deferred revenue months. - A dedicated valuation sheet cross-checks multiple-based and discounted cash flow approaches using explicit-period free cash flow and a terminal growth assumption, providing both enterprise and equity values. ### Practical Use and Scenario Analysis This streaming model is intended for investment, acquisition or funding decisions. A scenario selector on the assumptions sheet allows switching between Base, Bull and Bear cases, which adjusts subscriber adds, churn, ARPU and cost drivers across the model. - Sensitivity to content spend, pricing and churn can be explored by changing inputs, and the model includes validation checks such as balance sheet balancing, positive cash, gross margin range and improving EBITDA. - The public download is a values-only preview, so it shows the structure and logic without live formulas; users can review the design and output format before deciding whether to build their own version or request the full model. ## Built for OTT platform economics Use this model when subscriber retention, content investment, and hybrid revenue streams are the core drivers of platform profitability. ## Handles content economics properly A strong streaming model distinguishes between original productions and licensed content, applying flexible amortisation schedules that reflect asset value decay. ## Useful for pricing and growth strategy Stress-test the impact of price adjustments, ad-supported tiers, and content investment on ARPU, churn, and gross margins. ## Built for OTT platform economics Use this model when subscriber retention, content investment, and hybrid revenue streams are the core drivers of platform profitability. ## Handles content economics properly A strong streaming model distinguishes between original productions and licensed content, applying flexible amortisation schedules that reflect asset value decay. ## Useful for pricing and growth strategy Stress-test the impact of price adjustments, ad-supported tiers, and content investment on ARPU, churn, and gross margins. ## Features - **Cohort-based churn modeling:** Model retention by cohort to show that newer subscribers churn faster and mature cohorts stabilize, revealing true LTV by subscriber vintage. - **Content ROI and spend optimization:** Track content spend per view hour and show impact of content quality, exclusive originals, and licensed library on churn and ARPU. - **Advertising and ARPU trade-off:** Model ad-supported tier cannibalization vs. incremental revenue, and compare blended ARPU across tiers. ## Use cases - **Subscriber and content strategy:** Model subscriber growth targets, content spend allocation, and CAC payback to optimize profitability path. - **Pricing and tier strategy:** Evaluate ad-supported tier, price increases, and bundle economics on ARPU, churn, and lifetime value. - **Investor and analyst guidance:** Model EBITDA inflection timeline and margins at scale to support investor confidence and guidance credibility. ## Frequently asked questions ### What is a streaming financial model? It is a model that forecasts subscriber growth, content costs, revenue by tier, and platform profitability for SVoD, AVoD, or hybrid streaming businesses. ### Who uses streaming models? OTT platform operators, media executives, content producers, and TMT investment analysts use them for growth planning and investment analysis. ### What should a streaming model include? It should include subscriber cohort analysis, content amortisation, multi-tier revenue forecasting, variable delivery costs, and unit economics outputs. ### How does it handle content amortisation? The model supports straight-line or accelerated amortisation to match accounting standards and actual viewership decay patterns for both original and licensed content. ### Can I model both subscription and advertising revenue? Yes. The model supports hybrid revenue builds with ad-revenue based on monthly active users, average impressions, and CPM rates alongside recurring subscription income. ## Related templates - [E-Commerce Unit Economics](https://finamodel.com/templates/ecommerce-forecast-model) - [Subscription Box Economics](https://finamodel.com/templates/subscription-box-model) - [Marketplace Economics Model](https://finamodel.com/templates/marketplace-model)