Netflix Financial Model

• Total assets: Approximately $50 billion.
• Key asset categories: Content Assets (split into Current and Non-Current) make up over 60% of total assets. This represents the unamortised value of produced and licensed content.
• Goodwill & intangibles: Minimal (less than 5% of assets), as Netflix relies on organic growth rather than major acquisitions.
• Working capital profile:
• Days Sales Outstanding (DSO): Very low (under 15 days) as subscriptions are paid upfront via credit cards.
• Days Inventory Outstanding (DIO): Not applicable in a traditional sense, though content assets act similarly to long-term inventory.
• Days Payable Outstanding (DPO): 60 to 90 days, driven by content production payment terms.
• Net working capital as % of revenue: Consistently negative.
• Is working capital positive or negative? Negative. Netflix collects cash upfront from subscribers and pays content creators and cloud providers later, providing a structural cash flow advantage.
• PP&E: Minimal (under $2 billion), consisting mostly of studio real estate and office fit-outs.
• Right-of-use assets / operating leases: Approximately $2.5 billion to $3 billion, primarily for studio space and corporate offices.

• Capex as % of revenue: Traditional PP&E capex is very low, typically 1% to 2% of revenue.
• Maintenance capex vs. growth capex: Almost entirely maintenance for IT infrastructure and studio upkeep.
• Major capex programmes underway or planned: Expansion of internal production studios and the new "Netflix House" experiential entertainment venues.
• Capitalised software / development costs: Immaterial.
• M&A pattern: Historically organic. Minor bolt-on acquisitions include small animation studios (Animal Logic) and gaming studios (Spry Fox, Night School Studio).
• Typical acquisition multiple paid: Not disclosed, as acquisitions are immaterial to the consolidated financials.

• Total debt: Approximately $14 billion in long-term senior notes.
• Debt/EBITDA ratio: Gross debt to EBITDA is well under 1.5x. Management targets a gross debt range of $10 billion to $15 billion.
• Credit rating: Investment grade (Baa1/BBB+).
• Key debt instruments: Fixed-rate senior unsecured notes. The company also maintains an undrawn revolving credit facility.
• Maturity profile: Well-laddered, with average maturities extending beyond 5 years.
• Interest rate profile: Almost entirely fixed-rate debt with a weighted average cost of debt around 4.5%.
• Covenants: Standard investment-grade incurrence covenants; no restrictive financial maintenance covenants.
• Share repurchase programme: Highly active. The company repurchased over $2.5 billion in stock in Q4 2023 alone and continues to allocate excess free cash flow to buybacks.
• Dividend policy: Netflix does not pay a dividend and has no plans to initiate one.

• Operating cash flow conversion: OCF is heavily distorted by the timing of cash spent on content versus the non-cash amortisation expense. OCF has recently inflected to exceed Net Income.
• Free cash flow margin: FCF margin has expanded to approximately 15% to 18% of revenue (generating over $6 billion in FCF in 2024).
• Major non-cash items that bridge net income to OCF: Content amortisation (added back) and stock-based compensation (added back).
• Working capital cash flow impact: Additions to content assets are a massive use of cash in the operating section. Deferred revenue growth provides a steady source of cash.
• Capex intensity: Traditional capex is extremely low, but "cash spend on content" (which flows through OCF) is the true capital intensity metric, running at approximately $17 billion annually.
• Cash tax rate vs. GAAP effective tax rate: Cash taxes are generally lower than the GAAP effective tax rate due to the immediate expensing of certain content production costs for tax purposes.

1. Assumptions: Contains all hardcoded inputs for subscriber growth, ARM by region, margins, content spend, and WACC.
2. Dashboard: High-level summary charts showing subscriber growth, revenue by region, operating margin expansion, and free cash flow generation.
3. Subscribers & Revenue: Calculates Beginning Memberships, Gross Additions, Churn, Net Additions, and Ending Memberships for UCAN, EMEA, LATAM, and APAC. Multiplies average memberships by regional ARM to calculate segment revenue.
4. Content Schedule: The most critical sheet. Models cash spend on content, the amortisation curve (typically accelerated over 4 years), and calculates the ending Content Asset balance.
5. Income Statement: Consolidated P&L mirroring the 10-K. Links revenue from the Revenue sheet and Content Amortisation from the Content Schedule into Cost of Revenues.
6. Balance Sheet: Standard asset and liability line items, featuring Current and Non-Current Content Assets prominently.
7. Cash Flow Statement: Reconciles Net Income to OCF by adding back Content Amortisation and subtracting Cash Spent on Content.
8. Debt & Interest: Tracks the senior notes tranches, calculates fixed interest expense, and models the share repurchase programme using excess cash.
9. DCF Valuation: Unlevered free cash flow calculation, WACC build-up, terminal value calculation, and implied share price output.

1. `Average Paid Memberships = (Beginning Paid Memberships + Ending Paid Memberships) / 2`
2. `Segment Revenue = Average Paid Memberships x Segment ARM x 12`
3. `Total Streaming Revenue = UCAN Revenue + EMEA Revenue + LATAM Revenue + APAC Revenue`
4. `Cost of Revenues = Content Amortisation + Streaming Delivery Costs + Other Direct Costs`
5. `Content Amortisation = Prior Year Unamortised Content Balance x Blended Amortisation Rate`
6. `Ending Content Assets = Beginning Content Assets + Cash Spent on Content - Content Amortisation`
7. `Operating Income = Total Revenue - Cost of Revenues - Marketing - Technology & Development - General & Administrative`
8. `Operating Margin = Operating Income / Total Revenue`
9. `Free Cash Flow = Net Cash Provided by Operating Activities - Purchases of Property and Equipment`
10. `Net Cash Provided by Operating Activities = Net Income + Content Amortisation - Cash Spent on Content + Depreciation + SBC + Change in Working Capital`
11. `Shares Outstanding = Prior Period Shares - (Share Repurchase Cash / Average Share Price)`

The Subscribers & Revenue sheet is the primary engine, feeding the top line of the Income Statement. The Content Schedule is the critical chain for costs: it calculates Content Amortisation which feeds Cost of Revenues on the Income Statement, and it calculates Cash Spent on Content which feeds the Cash Flow Statement. The net of these two figures dictates the Content Assets balance on the Balance Sheet. Excess cash generated on the Cash Flow Statement flows to the Debt & Interest sheet to fund share repurchases, which reduces the share count used in the DCF Valuation per-share output. A minor circularity exists if interest income on cash balances is modelled, as cash depends on net income which depends on interest income.

• Revenue and subscriber additions are entered as positive numbers.
• All expenses on the Income Statement (Cost of Revenues, Marketing, Tech & Dev, G&A) are entered as negative numbers.
• Margins and growth rates are positive percentages.
• On the Cash Flow Statement, cash inflows (like Net Income and Amortisation add-backs) are positive, while cash outflows (like Cash Spent on Content and Capex) are negative.
• Balance Sheet assets, liabilities, and equity are all positive numbers.

• Failing to separate Content Amortisation (an income statement expense) from Cash Spent on Content (a cash flow statement outflow). This is the single most common error in Netflix models.
• Modelling ARM growth without accounting for foreign exchange headwinds. Constant currency ARM is often much higher than reported ARM in LATAM and EMEA.
• Overestimating subscriber growth by ignoring the pull-forward effect of the 2023/2024 paid sharing crackdown, which was a one-time structural step-up.
• Assuming the ad-supported tier is purely incremental. The model must account for some cannibalisation of the basic ad-free tier.
• Miscalculating the deferred revenue balance. Subscriptions are billed monthly, so deferred revenue should roughly equal one month of total revenue.
• Applying standard working capital assumptions (like DSO and DPO percentages) to content assets. Content assets must be modelled on a standalone schedule.
• Excluding stock-based compensation from operating expenses when calculating valuation multiples, which artificially inflates profitability.
• Modelling debt paydown with excess cash. Netflix management explicitly targets a static gross debt balance and uses excess cash exclusively for share repurchases.

• Operating margin must match management's near-term guidance of approximately 27% for 2024 and show slight expansion thereafter.
• Cash Spent on Content should be hardcoded to approximately $17 billion for 2024 and grow at a slower rate than revenue.
• The ratio of Cash Spent on Content to Content Amortisation should be roughly 1.1x to 1.2x. If it drops below 1.0x, the company is shrinking its content library.
• Free Cash Flow must be positive and in the $6 billion to $7 billion range for the first forecast year.
• Total Assets must equal Total Liabilities plus Equity in every period.
• UCAN ARM should be the highest of all regions (around $17), while APAC ARM should be the lowest (around $7.50).
• Effective tax rate should be modelled between 12% and 15%, reflecting international tax structures and R&D credits.
• Gross debt should remain relatively flat at $14 billion, as the company rolls over maturities rather than paying them down.

• Filings: SEC EDGAR database for Netflix (NFLX) 10-K, 10-Q, and 8-K filings. The Netflix Investor Relations website provides quarterly letters to shareholders which contain vital ARM and subscriber data.
• Key Peers: The Walt Disney Company (DIS), Warner Bros. Discovery (WBD), Comcast Corporation (CMCSA), and Amazon (AMZN) for Prime Video benchmarking.
• Industry Data: Nielsen for streaming viewership share (The Gauge report), Antenna for subscriber churn and gross addition data.
• Consensus Estimates: Bloomberg or FactSet for consensus subscriber net additions and operating margin expectations.

• Netflix, Inc. Form 10-K for the Fiscal Year Ended December 31, 2024. Available at: https://www.sec.gov/
• Netflix Q4 2024 Earnings Release and Letter to Shareholders. Available at: https://ir.netflix.net/
• GuruFocus Analysis of Netflix Q4 2024 Earnings. Available at: https://www.gurufocus.com/
• App Economy Insights: Netflix Q4 FY24 Review. Available at: https://www.appeconomyinsights.com/