Netflix operating model
Netflix from its 10-K: content cash against amortisation, advertising, margins, value. Read a content business’s operating income and free cash flow side by side and say what separates them, carry a capitalised content book forward so that amortisation follows from spending rather than from a ratio, model a new revenue line from a single described figure, and read what the forecast is worth without mistaking it for a view on the shares.
By Surojit Chakraverti, founder of L3VLUP and an investor running a long-short healthcare and technology equities strategy.
On this subject: netflix operating model.Updated 20 November 2026
Who builds it, and for whatThe model an equity analyst, a media banker or a credit analyst builds for a streaming business from its filings: revenue by region, the content book carried forward from what is spent, when it is released and how fast it is amortised, and the bridge from operating income to free cash flow. Netflix is the subject because its largest cost is a capitalised asset whose amortisation trails the cash paid for it, because it stopped reporting members in 2025, and because its advertising revenue is described only in round figures.
Every sheet below, in your browser, with its outputs and checks
Starter workbook free with an account. Worked model: one a month with Plus, every one with Pro. Downloads
| A | B | C | D | E | F | G | H | I | J | K | L | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Reported | |||||||||||
| 2 | $m unless stated, as filed. Blue cells are typed from the filings named on the Sources sheet; nothing here is adjusted. | |||||||||||
| 4 | $m | Unit | FY2023A | FY2024A | FY2025A | FY2026E | FY2027E | FY2028E | FY2029E | FY2030E | Notes | |
| 5 | Revenue by region (Form 10-K, note 2, revenue recognition) | |||||||||||
| 6 | United States and Canada (UCAN) | $m | 14,873.8 | 17,359.4 | 19,957.2 | Streaming revenues by region. FY2025 10-K, note 2 and Item 7. Not tagged in the SEC’s companyfacts record (a segment member). | ||||||
| 7 | Europe, Middle East and Africa (EMEA) | $m | 10,556.5 | 12,387.0 | 14,514.6 | FY2025 10-K, note 2. | ||||||
| 8 | Latin America (LATAM) | $m | 4,446.5 | 4,839.8 | 5,357.5 | FY2025 10-K, note 2. | ||||||
| 9 | Asia-Pacific (APAC) | $m | 3,763.7 | 4,414.7 | 5,353.7 | FY2025 10-K, note 2. | ||||||
| 10 | DVD revenues | $m | 82.8 | - | - | The DVD-by-mail service closed in 2023. FY2025 10-K, Item 7, results of operations. | ||||||
| 11 | Revenues | $m | 33,723.3 | 39,001.0 | 45,183.0 | us-gaap:Revenues. | ||||||
| 12 | Of which hedging gains (losses) in streaming revenues | $m | - | 124.0 | (91.1) | FY2025 10-K, Item 7: cash flow hedges of forecast revenue reclassified into revenue. None in 2023. | ||||||
| 14 | Advertising and memberships, as the company last described them | |||||||||||
| 15 | Advertising revenue, as described: over $1.5bn | $m | 1,500.0 | Q4 2025 shareholder letter, Form 8-K of 20 January 2026, Exhibit 99.1: ad revenue “rose more than 2.5x to over $1.5B”. Unaudited, in round figures, and a floor: the 10-K says revenue other than membership fees was not material and gives no figure. | ||||||||
| 16 | Advertising revenue, FY2025 over FY2024, as described: more than | x | 2.5x | The same letter. Read as a floor, so FY2024 advertising revenue was at most $1.5bn divided by it. | ||||||||
| 17 | Paid memberships at end of period | m memberships | 260.28 | 301.63 | FY2024 10-K, Item 7. Netflix stopped reporting membership numbers in 2025; the FY2025 10-K gives none. | |||||||
| 18 | Average paying memberships | m memberships | 240.89 | 277.73 | FY2024 10-K, Item 7. | |||||||
| 19 | Average monthly revenue per paying membership | $ a month | 11.64 | 11.70 | FY2024 10-K, Item 7. Discontinued with the membership count. | |||||||
| 21 | Costs and profit (consolidated statements of operations) | |||||||||||
| 22 | Cost of revenues | $m | 19,715.4 | 21,038.5 | 23,275.3 | us-gaap:CostOfRevenue. | ||||||
| 23 | Of which amortisation of content assets | $m | 14,197.4 | 15,301.5 | 16,422.2 | nflx:CostofServicesAmortizationofStreamingContentAssets, from the 10-K’s inline XBRL. Also the cash flow statement’s add-back. | ||||||
| 24 | Of which licensed content | $m | 7,145.4 | 7,689.0 | 8,713.6 | FY2025 10-K, note 5, the same tag on the licensed content member. | ||||||
| 25 | Of which produced content | $m | 7,052.0 | 7,612.5 | 7,708.6 | FY2025 10-K, note 5, the same tag on the produced content member. | ||||||
| 26 | Production tax incentives that lowered amortisation, approximately | $m | 835.0 | 899.0 | 1,000.0 | nflx:CostOfServicesDecreasedAmortizationFromTaxIncentives, FY2025 10-K, note 5, footnote 1. Already inside the amortisation line. | ||||||
| 27 | Sales and marketing | $m | 2,657.9 | 2,917.6 | 3,301.3 | us-gaap:SellingAndMarketingExpense. Includes advertising sales people and payments to advertising sales partners. | ||||||
| 28 | Technology and development | $m | 2,675.8 | 2,925.3 | 3,391.4 | Tagged us-gaap:ResearchAndDevelopmentExpense. | ||||||
| 29 | General and administrative | $m | 1,720.3 | 1,702.0 | 1,888.4 | us-gaap:GeneralAndAdministrativeExpense. | ||||||
| 30 | Operating income | $m | 6,954.0 | 10,417.6 | 13,326.6 | us-gaap:OperatingIncomeLoss. | ||||||
| 31 | Interest expense | $m | 699.8 | 718.7 | 776.5 | us-gaap:InterestExpenseNonoperating. FY2025 includes about $60m of costs of the financing arranged for the Warner Bros. Discovery transaction. | ||||||
| 32 | Interest and other income (expense) | $m | (48.8) | 266.8 | 172.5 | us-gaap:NonoperatingIncomeExpense. Interest on cash, net of foreign exchange gains and losses. | ||||||
| 33 | Income before income taxes | $m | 6,205.4 | 9,965.7 | 12,722.6 | us-gaap:IncomeLossFromContinuingOperationsBeforeIncomeTaxesExtraordinaryItemsNoncontrollingInterest. | ||||||
| 34 | Provision for income taxes | $m | 797.4 | 1,254.0 | 1,741.4 | us-gaap:IncomeTaxExpenseBenefit. | ||||||
| 35 | Net income | $m | 5,408.0 | 8,711.6 | 10,981.2 | us-gaap:NetIncomeLoss. | ||||||
| 36 | Diluted earnings per share | $ per share | 1.20 | 1.98 | 2.53 | us-gaap:EarningsPerShareDiluted, after the ten-for-one split of November 2025. | ||||||
| 37 | Weighted average diluted shares | m shares | 4,494.97 | 4,392.61 | 4,343.86 | us-gaap:WeightedAverageNumberOfDilutedSharesOutstanding, restated for the split in the FY2025 10-K (the FY2024 10-K printed 449.5m and 439.3m). | ||||||
| 39 | Cash flow (consolidated statements of cash flows) | |||||||||||
| 40 | Additions to content assets | $m | 12,554.7 | 16,223.6 | 17,096.6 | nflx:AdditionstoStreamingContentAssets, an outflow inside operating cash flow. Typed positive. | ||||||
| 41 | Change in content liabilities | $m | (585.6) | (779.1) | (610.8) | nflx:ChangeInStreamingContentLiabilities, signed as the cash flow statement shows it: negative when the liabilities fell and more was paid than added. | ||||||
| 42 | Depreciation and amortisation of property, equipment and intangibles | $m | 356.9 | 328.9 | 333.4 | us-gaap:DepreciationDepletionAndAmortization. | ||||||
| 43 | Stock-based compensation expense | $m | 339.4 | 272.6 | 368.4 | us-gaap:ShareBasedCompensation. | ||||||
| 44 | Change in deferred revenue | $m | 178.7 | 77.8 | 254.9 | us-gaap:IncreaseDecreaseInContractWithCustomerLiability. | ||||||
| 45 | Net cash provided by operating activities | $m | 7,274.3 | 7,361.4 | 10,149.3 | us-gaap:NetCashProvidedByUsedInOperatingActivities. | ||||||
| 46 | Purchases of property and equipment | $m | 348.6 | 439.5 | 688.2 | us-gaap:PaymentsToAcquirePropertyPlantAndEquipment. | ||||||
| 47 | Repurchases of common stock | $m | 6,045.3 | 6,263.7 | 9,127.2 | us-gaap:PaymentsForRepurchaseOfCommonStock. | ||||||
| 48 | Interest paid | $m | 684.5 | 674.5 | 718.6 | us-gaap:InterestPaidNet, supplemental disclosure. | ||||||
| 49 | Income taxes paid, net of refunds | $m | 1,155.0 | 1,642.0 | 2,220.4 | us-gaap:IncomeTaxesPaidNet, note 11. FY2025 includes about $200m of tax deposits beyond the recurring obligations. | ||||||
| 50 | Free cash flow, as reported (non-GAAP) | $m | 6,921.8 | 9,461.1 | Operating cash flow less purchases of property and equipment. Q4 2025 shareholder letter, Form 8-K of 20 January 2026, Exhibit 99.1, non-GAAP reconciliation. Not in the 10-K. | |||||||
| 51 | FY2022: additions to content assets | $m | 16,839.0 | FY2024 10-K, cash flow statement, nflx:AdditionstoStreamingContentAssets. | ||||||||
| 52 | FY2022: change in content liabilities | $m | 179.3 | FY2024 10-K, the same tag. Positive: the liabilities rose, so less was paid than added. | ||||||||
| 54 | Content assets and obligations at 31 December (note 5, note 9) | |||||||||||
| 55 | Content assets, net | $m | 31,658.1 | 32,452.5 | 32,778.4 | nflx:ContentAssetsNetNoncurrent; us-gaap:FiniteLivedIntangibleAssetsNet in the companyfacts record. | ||||||
| 56 | Licensed content, net | $m | 12,422.3 | 12,138.6 | FY2025 10-K, note 5, us-gaap:FiniteLivedIntangibleAssetsNet on the licensed member. | |||||||
| 57 | Produced content, released, less amortisation | $m | 10,151.5 | 10,687.4 | nflx:FiniteLivedIntangibleAssetsReleasedNetLessAmortization. | |||||||
| 58 | Produced content, in production | $m | 9,317.4 | 9,210.7 | nflx:FiniteLivedIntangibleAssetsInProductionNet. Paid for, not yet released, not yet amortised. | |||||||
| 59 | Produced content, in development and pre-production | $m | 561.2 | 741.6 | nflx:FiniteLivedIntangibleAssetsInDevelopmentAndPreProductionNet. | |||||||
| 60 | Licensed content: expected amortisation in 2026 | $m | 6,381.0 | FY2025 10-K, note 5: of the $12,139m unamortised. us-gaap:FiniteLivedIntangibleAssetsAmortizationExpenseNextTwelveMonths. | ||||||||
| 61 | Licensed content: expected amortisation in 2027 | $m | 2,280.0 | us-gaap:FiniteLivedIntangibleAssetsAmortizationExpenseYearTwo. | ||||||||
| 62 | Licensed content: expected amortisation in 2028 | $m | 1,469.0 | us-gaap:FiniteLivedIntangibleAssetsAmortizationExpenseYearThree. | ||||||||
| 63 | Produced content, released: expected amortisation in 2026 | $m | 4,309.0 | FY2025 10-K, note 5: of the $10,687m unamortised. Same tags, produced member. | ||||||||
| 64 | Produced content, released: expected amortisation in 2027 | $m | 2,784.0 | us-gaap:FiniteLivedIntangibleAssetsAmortizationExpenseYearTwo. | ||||||||
| 65 | Produced content, released: expected amortisation in 2028 | $m | 1,840.0 | us-gaap:FiniteLivedIntangibleAssetsAmortizationExpenseYearThree. | ||||||||
| 66 | Current content liabilities | $m | 4,466.5 | 4,393.7 | 4,084.9 | nflx:ContentLiabilitiesCurrent. | ||||||
| 67 | Non-current content liabilities | $m | 2,578.2 | 1,780.8 | 1,579.5 | nflx:ContentLiabilitiesNoncurrent. | ||||||
| 68 | Content obligations not on the balance sheet | $m | 17,000.0 | 18,400.0 | us-gaap:UnrecordedUnconditionalPurchaseObligationBalanceSheetAmount. Titles contracted but not yet available; the 10-K adds that unknown future titles could be $1bn to $4bn over three years. | |||||||
| 70 | Balance sheet at 31 December | |||||||||||
| 71 | Cash and cash equivalents | $m | 7,116.9 | 7,804.7 | 9,033.7 | us-gaap:CashAndCashEquivalentsAtCarryingValue. | ||||||
| 72 | Short-term investments | $m | 21.0 | 1,779.0 | 28.7 | us-gaap:ShortTermInvestments. | ||||||
| 73 | Short-term debt | $m | 399.8 | 1,784.5 | 998.9 | us-gaap:ShortTermBorrowings. Senior notes due within a year. | ||||||
| 74 | Long-term debt | $m | 14,143.4 | 13,798.4 | 13,464.0 | us-gaap:LongTermDebtNoncurrent. Fixed-rate senior notes due 2026 to 2054. | ||||||
| 75 | Deferred revenue | $m | 1,443.0 | 1,520.8 | 1,775.7 | us-gaap:ContractWithCustomerLiabilityCurrent. | ||||||
| 76 | Operating lease liabilities | $m | 2,430.1 | 2,412.2 | 2,513.0 | us-gaap:OperatingLeaseLiability, current and non-current. | ||||||
| 77 | Stockholders’ equity | $m | 20,588.3 | 24,743.6 | 26,615.5 | us-gaap:StockholdersEquity. | ||||||
| 78 | Shares of common stock outstanding | m shares | 4,277.57 | 4,222.16 | us-gaap:CommonStockSharesOutstanding, after the split. | |||||||
| 79 | Incremental shares from stock options and awards (treasury stock method) | m shares | 79.25 | 97.42 | 94.35 | us-gaap:IncrementalCommonSharesAttributableToShareBasedPaymentArrangements, note 3. | ||||||
Select a cell to see its row, its schedule and the type of cell. Font colours: blue for inputs, black for formulas, green for links to other sheets. Scroll sideways to see every period.
Download
Netflix operating model: the workbook
An Excel workbook with working formulas, no macros and no external links: the same model you can work with on this page.
- Browse without an accountPreview every model online, sheet by sheet, with its outputs and checks.
- Free accountWork with every model online: change the inputs, switch the case, see every formula. And every starter workbook, with its key schedules left blank to build.
- L3VLUP Plus$4.99/monthEverything in Free, and one worked model each billing month as an Excel file: every schedule built, formulas live, checks at zero, yours to keep.
- L3VLUP Pro$25/monthEverything in Plus, every worked model in the library, and the Pro applications.
- The worked model
- 10 sheets and 764 live formulas, all 7 schedules built and linked, every check reading zero. Change an input in Excel and the whole model moves.
- The starter
- The same inputs and layout with the capex and depreciation (PP&E roll-forward) left blank for you to build, each blank cell marked. The worked model is its answer.
What the base case says
- FY2025A revenues
- $45,183.0m
- FY2025A cash paid for content / amortisation
- 1.1x
- FY2025A free cash flow
- $9,461.1m
- FY2030E revenues, selected case
- $74,324.1m
- FY2030E operating margin
- 30.8%
- Value per share the forecast implies
- 59.24
Read from the workbook as served, every input at its default. Periods: FY2023A, FY2024A, FY2025A, FY2026E, FY2027E, FY2028E, FY2029E, FY2030E. Built from Netflix, Inc.’s Forms 10-K for 2025 and 2024 and its Form 8-K of 20 January 2026, each figure cited with its XBRL tag or section on the Reported sheet; the forecast, the release lag and the amortisation pattern, the discount rate and the terminal assumptions are editorial judgements, labelled on the Forecast sheet, and move with whatever you type in. Company guidance is not used.
What changes the answer
Every figure below is the workbook recalculated by its own formulas: the cases it carries, each key assumption moved a tenth either way, and the sensitivity grids from its own sheets. Nothing is estimated outside the model.
The cases, side by side
The scenario switch on the Forecast sheet, set to each option in turn. Every check in the workbook reads zero in every case.
| Output | Baseas shipped | Downside | Upside |
|---|---|---|---|
| FY2025A revenues | $45,183.0m | $45,183.0m | $45,183.0m |
| FY2025A cash paid for content / amortisation | 1.1x | 1.1x | 1.1x |
| FY2025A free cash flow | $9,461.1m | $9,461.1m | $9,461.1m |
| FY2030E revenues, selected case | $74,324.1m | $59,982.0m-$14,342.1m | $81,911.9m+$7,587.8m |
| FY2030E operating margin | 30.8% | 23.1%-7.7 pts | 33.2%+2.4 pts |
| Value per share the forecast implies | 59.24 | 37.91-21.33 | 68.80+9.56 |
What each case assumes
| Membership and other revenue growth, selected | 11.0% | 7.0% | 13.0% |
|---|---|---|---|
| Advertising revenue growth, selected | 80.0% | 45.0% | 100.0% |
| Cost of selling advertising, selected | 30.0% | 40.0% | 25.0% |
| Cash paid for content, % of revenues, selected | 38.6% | 39.4% | 38.4% |
| Other cost of revenues, % of revenues, selected | 14.0% | 15.0% | 13.5% |
| Sales and marketing before advertising costs, selected | 7.2% | 7.3% | 7.1% |
| Technology and development, selected | 7.4% | 7.6% | 7.4% |
| General and administrative, selected | 4.1% | 4.2% | 4.1% |
The first period of each assumption row the switch sets directly, in the order of the columns above.
What moves the value per share the forecast implies most
Value per share the forecast implies is 59.24 in the base case. Each bar moves one assumption 10% below and 10% above its own value, with everything else held, and shows where the output lands.
Discount rate
10% lower: 70.2910% higher: 51.08
Cash paid for content
10% lower: 66.6610% higher: 51.82
Other cost of revenues
10% lower: 62.2310% higher: 56.25
Terminal growth
10% lower: 56.8610% higher: 61.88
Membership and other revenue growth (revenue)
10% lower: 57.1010% higher: 61.44
Technology and development
10% lower: 60.6010% higher: 57.88
The sensitivity grids, as heatmaps
Value per share: discount rate by terminal growth
| Discount rate ↓ / Terminal growth → | 2.0% | 2.5% | 3.0% | 3.5% | 4.0% |
|---|---|---|---|---|---|
| 7.0% | 74.38 | 81.57 | 90.56 | 102.12 | 117.53 |
| 8.0% | 61.37 | 66.09 | 71.76 | 78.69 | 87.35 |
| 9.0% | 52.09 | 55.39 | 59.24 | 63.79 | 69.26 |
| 10.0% | 45.13 | 47.55 | 50.31 | 53.49 | 57.21 |
| 11.0% | 39.74 | 41.56 | 43.62 | 45.95 | 48.61 |
Value per share: discount rate by exit multiple
| Discount rate ↓ / Exit multiple → | 18.0x | 20.0x | 22.0x | 24.0x | 26.0x |
|---|---|---|---|---|---|
| 7.0% | 80.82 | 88.40 | 95.97 | 103.54 | 111.11 |
| 8.0% | 77.33 | 84.56 | 91.79 | 99.02 | 106.24 |
| 9.0% | 74.03 | 80.93 | 87.83 | 94.73 | 101.63 |
| 10.0% | 70.89 | 77.49 | 84.08 | 90.67 | 97.27 |
| 11.0% | 67.92 | 74.22 | 80.53 | 86.83 | 93.13 |
Presenting these figures? In Deck Studio a slide can carry any output above, with the case and the cell printed as its source.Open Deck Studio
What this model is
An operating model of Netflix, Inc., the streaming service, built from its filed results for 2023 to 2025 and carried five years forward in three editorial cases.
The Reported sheet holds only what the company filed: revenue by region, the cost lines, profit, cash flow, the content book and its expected amortisation, the balance sheet, the last membership figures and the advertising revenue the company described, each with its filing and tag. The Derived sheet sets the cash paid for content against its amortisation and rebuilds the company’s free cash flow. The Forecast sheet is where judgement enters, and says so on every row.
Uses: seeing why a content business’s operating income and free cash flow differ, and by how much; carrying a capitalised asset forward so that its amortisation follows from what is spent rather than from a ratio; modelling a new revenue line whose filed history is a single round number; and testing how far a value moves with the discount rate, growth and the content assumptions.
Seats: Equity research and hedge funds, Investment banking, Product and technology, Private equity.
Careers that do this work: growth equity, venture capital, equity research, corp dev / m&a, bizops / strategy & ops.
How the schedules connect
Every row in the workbook is tagged with the schedule it belongs to; the inspector above shows the tag when you click a row. These are the schedules this model is made of and where each one lives.
Revenue build
Where the top line comes from
Reported, rows 6–12 · Reported, rows 15–19 · Derived, rows 6–17 · Forecast, rows 11–22 · P&L & Cash Flow, rows 6–10
Operating costs and margins
Cost of sales, opex, EBITDA
Reported, rows 22–37 · Derived, rows 20–34 · Forecast, rows 37–53 · P&L & Cash Flow, rows 13–25
Capex and depreciation (PP&E roll-forward)
Opening, plus capex, less depreciation, closing
Reported, rows 55–68 · Derived, rows 37–52 · Forecast, rows 25–34 · Content, rows 6–9 · Content, rows 12–15 · Content, rows 18–23
Cash flow statement
Indirect method, closing on balance-sheet cash
Reported, rows 40–52 · Derived, rows 55–65 · Forecast, rows 56–63 · P&L & Cash Flow, rows 37–46 · P&L & Cash Flow, rows 49–53
Enterprise value to equity value
Debt off, cash on, per share
Reported, rows 71–79 · P&L & Cash Flow, rows 28–34 · Valuation, rows 13–27
Discounting and terminal value
Discount factors, two terminal methods, reconciled
Forecast, rows 66–68 · Valuation, rows 6–10 · Valuation, rows 30–32
Sensitivity tables
Two assumptions at once, without a data table
Sensitivity, rows 5–7 · Sensitivity, rows 10–15 · Sensitivity, rows 18–25
What you should be able to explain
- Why cash paid for content is additions to content assets less the change in content liabilities, and why both sit inside operating cash flow.
- Why amortisation trails the cash: productions are paid for while they are made, released later, and amortised over the years after release, so growth in spending opens a gap.
- How the 10-K’s schedule of expected amortisation for released titles sets the first three forecast years of the existing book.
- Why the gap between operating income and free cash flow is content in some years and tax and interest in others, and how to separate the two.
- What advertising adds when its filed history is one round figure: its own growth, the cost of selling it, and no extra content.
What a reviewer looks for
- Forecasting content amortisation as a share of revenue, so the gap between cash and amortisation can never move.
- Reading operating margin as cash margin in a year when content spending is growing.
- Taking 2023’s free cash flow as the run rate when the strikes held content spending back.
- Treating the shareholder letter’s “over $1.5B” of advertising as a measured figure, or using the company’s guidance as the base case.
- Deducting the content obligations as debt while also charging the content spending in the cash flows.
- Mixing share counts from before and after the ten-for-one split of November 2025.
Conventions this workbook uses
Stated on the cover sheet too. A model is only as trustworthy as the decisions it tells you it made.
- Three kinds of number, on three sheets: Reported (filed, blue, cited), Derived (arithmetic on Reported, no assumption), Forecast (editorial, blue, labelled). Every other sheet is formulas over them.
- Cash paid for content is additions to content assets less the change in content liabilities, as the cash flow statement presents them; both are inside operating cash flow, so free cash flow is struck after content.
- Content amortisation in forecast years is an output. The titles released by 31 December 2025 run off as the 10-K expects for 2026 to 2028, the rest over FY2029E and FY2030E. A share of each year’s spending is released in the same year and the rest the next; what was in production at 31 December 2025 is released in FY2026E; each year’s releases are amortised over four years on the Forecast sheet’s pattern.
- Revenue in forecast years is membership and other revenue at a growth rate plus advertising revenue from the $1.5bn the company described for 2025, a floor in round figures, so the FY2025A split between them is approximate.
- Cost ratios fade linearly from the FY2025A ratio to the case’s FY2030E target. The cost of selling advertising is charged in sales and marketing on the advertising revenue added since FY2025A.
- Debt is held at its 31 December 2025 carrying amount and interest is charged on opening balances; all free cash flow is returned, so cash stays where it was. Nothing is circular.
- The valuation discounts unlevered free cash flow after stock-based compensation at 31 December 2025, with a perpetuity-growth terminal value and an exit multiple on operating income as a cross-check; cash is added and debt deducted at their carrying amounts, so interest on both is taken out of the cash flows first. Leases and content obligations are not deducted, because their cost is inside the cash flows. The value per share is what the inputs imply and nothing more.
- Share counts and per-share figures are after the ten-for-one split of 14 November 2025, as the FY2025 10-K restates them.
Build it yourself
The starter workbook
The content book has been cleared: cash paid, additions, releases, the amortisation of the old and new titles, the closing book and the gap on the Content sheet, in every forecast year. Rebuild them from the Forecast sheet’s spending, release and amortisation inputs so the released book at 31 December 2025 runs off as the 10-K expects and the gap between cash and amortisation carries through to free cash flow.
Blanks: Capex and depreciation (PP&E roll-forward). Download it beside the worked model.
Finished? Audit a model you built for errors, hardcodes and checks that do not tie, in your browser.
The path around this model
Understand it, drill it, read the build, then apply it to a real company.
Build · Lab · ~15 min
DCF Builder
Build a DCF by hand from revenue to a share price, know how much of it sits in the terminal value, and name the one assumption the answer hinges on.
Build · Lab · ~8 min
Three-Statement Linker
Walk any event through all three statements in the right order, with the right signs, and prove the balance sheet balances rather than asserting it.
Build · Lab · ~10 min
Depreciation Waterfall
Forecast depreciation from a capex plan rather than a ratio, read a capex-to-depreciation multiple, and say which part of the spend is buying growth and which is only standing still.
Read · Guide · 16 min
How to Build a DCF Model: From Operating Assumptions to a Defensible Valuation
Read · Guide · 15 min
How to Build a Three-Statement Model That Actually Balances
Read · Guide · 7 min
Enterprise Value vs. Equity Value, Once and For All
Apply · Skill
Model Audit
Find the errors in a financial model before someone senior does.
Apply · Skill
Company Profile
Build a banker-grade one-pager on any company, fast.
Vocabulary: Free Cash Flow (FCF), Depreciation & Amortisation (D&A), Deferred Revenue, GAAP vs. Non-GAAP, Stock-Based Compensation (SBC), Terminal Value.
Questions about this model
Which figures in this model are Netflix’s and which are the page’s?
Every figure on the Reported sheet is Netflix’s, from its Forms 10-K for 2025 and 2024 and the shareholder letter filed on Form 8-K in January 2026, each cited with its XBRL tag or the section it was read from. The Derived sheet is arithmetic on those alone. Everything on the Forecast sheet is a judgement of this page: revenue and advertising growth, content spending, the release lag and the amortisation pattern among it. Netflix gives guidance in its letters; none of it is used.
How far does content amortisation run behind the cash?
In 2025 Netflix paid $17,707m for content and amortised $16,422m, 1.08 times; in 2024 1.11 times; in 2023, when the strikes held production back, 0.93 times. Operating income counted content at the amortisation, so with the cash in its place 2025’s operating income of $13,327m would have been $12,041m, a margin of 26.7% against 29.5%.
Why is operating income so much higher than free cash flow?
In 2025 operating income was $13,327m and free cash flow, Netflix’s own measure, $9,461m. Of the $3,866m between them, $1,285m is content paid for but not yet amortised; most of the rest is $2,939m of tax and interest paid, partly offset by depreciation and share pay that are not cash and by working capital. In 2024 content was about half of the difference.
What is the value per share on the Valuation sheet?
What the selected forecast is worth at 31 December 2025 at the discount rate and terminal growth on the Forecast sheet: unlevered free cash flow after stock-based compensation, discounted, plus cash, less debt, over the shares outstanding and the awards’ incremental shares after the split. It is a consequence of the inputs, not a target, a fair value or a recommendation, and the page never compares it with the share price.
Related models
Core modelling · Core
Discounted cash flow model
Unlevered free cash flow to a share price
Core modelling · Foundation
Integrated three-statement model
The operating model everything else sits on
Technology · Core
Spotify operating model
Spotify from its 20-Fs: subscribers and ARPU, two segments, social costs, cash, value
What assumption would you challenge?
Every model rests on a few judgements. Ask how one works, or say which input you would set differently and why.
No questions yet. Ask the first.