# Trade Desk (TTD) Financial Model Free Excel 3-statement financial model and company analysis for Trade Desk. - Canonical: https://finamodel.com/companies/trade-desk - Industry: Media - Downloadable model: Yes - Excel download: https://finamodel.com/company-models/TTD.xlsx ## Model Purpose This model evaluates the equity valuation and operating leverage of The Trade Desk by forecasting gross advertising spend, take rate stability, and working capital dynamics to determine whether the company can sustain its premium valuation against walled-garden competitors. ## Company Overview - The Trade Desk is an independent, cloud-based demand-side platform (DSP) that empowers buyers of advertising to create, manage, and optimise data-driven digital advertising campaigns. - **Business segments:** The company operates as a single reporting segment, generating 100% of its revenue from platform fees. - **Key geographies:** Primarily North America (historically ~85-90% of revenue), with a growing international presence in Europe and Asia Pacific. - **Business model type:** Asset-light, transaction-based platform. The company charges a percentage fee (take rate) on the gross media spend transacted through its platform. - **Competitive position:** The leading independent DSP in the open internet, competing directly with "walled gardens" like Google (DV360) and Amazon Ads, as well as smaller players like Criteo and Viant. It is the primary champion of Unified ID 2.0 (UID2). - **Recent major events:** In 2025, the company launched the Ventura streaming TV operating system, expanded its Kokai AI capabilities, and executed a massive $1.4 billion share repurchase programme. Gross spend reached a record $13.4 billion in FY2025. ## Revenue Deep Dive - **Segment name:** Platform Revenue (Single Segment). - **Revenue driver formula:** `Gross Ad Spend x Take Rate`. - **Historical growth rate:** Gross spend grew 11% year-over-year to $13.4 billion in FY2025, driving revenue growth of 18% to $2.9 billion. - **Key growth levers and headwinds:** Growth is driven by the shift to Connected TV (CTV), retail media partnerships, and international expansion. Headwinds include macro-economic advertising slowdowns and the competitive threat of Amazon Ads expanding into CTV. - **Pricing dynamics:** Contractual Master Services Agreements (MSAs) with advertising agencies. The take rate has remained remarkably stable at approximately 21.6% over the last several years. - **Revenue recognition:** Recognised at a point in time when the ad impression is delivered to the consumer. - **Seasonality:** Highly seasonal. Q4 is the strongest quarter by a wide margin due to holiday advertising spend, while Q1 is historically the weakest. ## Cost Structure ### Variable Costs / COGS - **Line-by-line breakdown:** Reported as "Platform Operations". This includes hosting costs, data centre operations, third-party data costs, and personnel costs related to platform operations. - **Gross margin range:** Exceptionally high and stable, ranging from 78.6% to 82.2% over the last 5 years (80.7% in FY2025). - **Key input costs and commodity exposures:** Cloud computing and server hosting costs (AWS/infrastructure). - **How COGS scales with revenue:** Highly linear with revenue, demonstrating massive operating leverage as the platform scales. ### Operating Expenses - **R&D:** Reported as "Technology and development". Typically runs at 18-20% of revenue. It covers software engineering, data science (Kokai AI), and platform upgrades. - **SG&A:** Split into "Sales and marketing" (~20-22% of revenue) and "General and administrative" (~12-15% of revenue). Primarily headcount-driven. - **Depreciation & Amortisation:** Very low, typically 2-3% of revenue, mostly related to capitalised software and data centre equipment. - **Stock-Based Compensation:** Extremely high. Historically 15-20% of revenue, heavily skewed by a long-term CEO performance grant ($67 million in FY2025 alone). - **Restructuring / one-time charges:** Rare; the company generally grows organically without major restructuring events. ### Margin Profile - **Gross margin:** ~80-81%. - **EBITDA margin:** Adjusted EBITDA margin is consistently ~40-41% (41% in FY2025). - **Operating margin:** GAAP operating margin is typically 15-20%, heavily depressed by SBC. - **Margin trend:** Stable to slightly expanding on an Adjusted EBITDA basis as the company scales its top line while maintaining a flat take rate. ## Balance Sheet Structure - **Total assets:** Approximately $4.5 to $5.0 billion. - **Key asset categories:** Cash and cash equivalents (~$658 million at FY2025 year-end) and massive Accounts Receivable balances. - **Goodwill & intangibles as % of total assets:** Very low (<5%), as the company is an organic grower, not a serial acquirer. - **Working capital profile:** - **Days Sales Outstanding (DSO):** ~90-100 days (calculated on Gross Spend, not Net Revenue). - **Days Inventory Outstanding (DIO):** N/A (digital platform). - **Days Payable Outstanding (DPO):** ~90-100 days (calculated on Gross Spend minus Revenue). - **Net working capital as % of revenue:** The company acts as a clearinghouse. It bills agencies for Gross Spend and pays publishers for ad inventory. Working capital swings violently between Q4 and Q1. - **Is working capital positive or negative?** Generally positive, but the timing of Q4 collections heavily dictates operating cash flow in Q1. - **PP&E:** Minimal. Consists of data centre equipment and leasehold improvements. - **Right-of-use assets / operating leases:** Standard office leases, immaterial to the overall valuation. ## Capital Expenditure & Investment - **Capex as % of revenue:** 2-4% historically. - **Maintenance capex vs. growth capex:** Almost entirely growth capex (server capacity and capitalised software development). - **Major capex programmes underway or planned:** Investments in the Ventura streaming TV OS and UID2 infrastructure. - **Capitalised software / development costs if material:** Yes, a portion of Technology & Development is capitalised, but it remains a small percentage of total revenue. - **M&A pattern:** Organic grower. Occasional small bolt-on acquisitions (e.g., Sincera in 2025, Adbrain historically) for technology, not revenue. - **Typical acquisition multiple paid:** N/A (immaterial deal sizes). ## Debt & Capital Structure - **Total debt:** $0 long-term debt. - **Debt/EBITDA ratio:** 0.0x. - **Credit rating:** Unrated (no debt). - **Key debt instruments:** The company maintains an undrawn revolving credit facility for liquidity purposes. - **Maturity profile:** N/A. - **Interest rate profile:** N/A. - **Covenants:** Standard facility covenants, easily cleared due to zero debt. - **Share repurchase programme:** Highly active. The company repurchased $1.4 billion of stock in FY2025 at an average price of $52.60. An additional $350 million was authorised in Feb 2026, bringing total capacity to $500 million. - **Dividend policy:** No dividend. 100% of capital return is via buybacks. ## Cash Flow Characteristics - **Operating cash flow conversion:** OCF / Net Income is typically >1.5x. This is driven by the massive add-back of non-cash stock-based compensation. - **Free cash flow margin:** FCF / Revenue typically runs at 30-35%. - **Major non-cash items that bridge net income to OCF:** Stock-based compensation (the largest bridge item) and depreciation/amortisation. - **Working capital cash flow impact:** Massive source/use of cash depending on the quarter. A strong Q4 gross spend results in a huge build in AR and AP, which unwinds in Q1. - **Capex intensity:** Very low, resulting in FCF closely tracking OCF. - **Cash tax rate vs. GAAP effective tax rate:** Cash taxes are often lower than GAAP taxes due to excess tax benefits from stock-based compensation. ## Sheet Structure 1. **Assumptions**: Hardcoded inputs for Gross Spend growth, Take Rate, operating expense margins, SBC as a % of revenue, and working capital days. 2. **Revenue & KPIs**: Calculation of Gross Ad Spend, Take Rate, and Platform Revenue. 3. **Income Statement**: Platform Revenue, Platform Operations (COGS), Sales and Marketing, Technology and Development, General and Administrative, SBC breakout, and Adjusted EBITDA reconciliation. 4. **Balance Sheet**: Cash, Accounts Receivable, Prepaid Expenses, PP&E, Accounts Payable, Accrued Expenses, Retained Earnings. 5. **Cash Flow Statement**: Net Income, D&A, SBC add-back, Change in Working Capital, Capex, Share Repurchases. 6. **Working Capital Schedule**: Detailed calculation of AR and AP based on Gross Spend, not Net Revenue. 7. **Debt & Equity Schedule**: Share count roll-forward, EPS calculation, and share repurchase schedule. 8. **DCF Valuation**: Unlevered Free Cash Flow build, WACC calculation, Terminal Value, and implied share price. ## Key Financial Relationships 1. `Platform Revenue = Gross Ad Spend * Take Rate` 2. `Platform Operations (COGS) = Platform Revenue * (1 - Gross Margin %)` 3. `Gross Profit = Platform Revenue - Platform Operations` 4. `Adjusted EBITDA = Net Income + Provision for Income Taxes + D&A + Stock-Based Compensation + Interest Expense` 5. `Accounts Receivable = (Gross Ad Spend / 365) * DSO` 6. `Accounts Payable = ((Gross Ad Spend - Platform Revenue) / 365) * DPO` 7. `Technology & Development Expense = Platform Revenue * Tech & Dev Margin %` 8. `Sales & Marketing Expense = Platform Revenue * S&M Margin %` 9. `General & Administrative Expense = Platform Revenue * G&A Margin %` 10. `Free Cash Flow = Cash from Operations - Purchases of Property and Equipment - Capitalised Software Costs` 11. `Ending Basic Shares = Beginning Basic Shares - (Share Repurchase Amount / Average Share Price)` ## Cross-Sheet Dependencies - The **Revenue & KPIs** sheet is the engine of the model; Gross Spend feeds the **Income Statement** (via Take Rate) and the **Working Capital Schedule** (for AR and AP calculations). - The **Working Capital Schedule** feeds the Change in Working Capital line on the **Cash Flow Statement**. - The **Income Statement** feeds Net Income to the **Cash Flow Statement** and Retained Earnings to the **Balance Sheet**. - The **Cash Flow Statement** feeds the ending Cash balance to the **Balance Sheet**. - The **Debt & Equity Schedule** feeds the Share Repurchase cash outflow to the **Cash Flow Statement** and calculates per-share metrics on the **Income Statement**. ## Sign Convention - Revenue, Gross Spend, and Take Rate are entered and displayed as positive numbers. - Expenses (Platform Operations, Opex) are calculated as positive numbers but subtracted in profit subtotals. - On the Cash Flow Statement, cash inflows (Net Income, SBC add-back, increases in AP) are positive. Cash outflows (Capex, Share Repurchases, increases in AR) are negative. - Balance Sheet assets, liabilities, and equity are all positive. ## Things Most Likely to Go Wrong - **Working Capital Error:** Calculating Accounts Receivable and Accounts Payable based on Platform Revenue instead of Gross Ad Spend. TTD bills agencies for the total ad spend and pays publishers the remainder. AR and AP must be driven by Gross Spend. - **SBC Underestimation:** The Trade Desk issues massive amounts of stock-based compensation (especially CEO performance awards). Failing to model SBC accurately will result in a severe disconnect between GAAP Net Income and Adjusted EBITDA. - **Take Rate Assumptions:** Assuming the take rate will expand over time. It has been structurally flat at ~21.6% for years. Modelling take rate expansion will artificially inflate revenue and margins. - **Seasonality Ignorance:** If building a quarterly model, failing to weight Gross Spend heavily toward Q4 will break the working capital cash flow dynamics. - **Debt Modelling:** Wasting time building complex debt schedules. The company has zero debt and funds buybacks entirely through free cash flow. - **Share Count Dilution:** Forgetting to offset the aggressive share repurchase programme with the dilutive impact of the massive SBC grants. Net share count reduction is slower than gross buybacks imply. ## Validation Checks - "Take Rate must remain between 21.0% and 22.0%; flag if outside this historical band." - "Gross margin should be in the 79-82% range; flag if it deviates." - "Adjusted EBITDA margin should remain near 40-42%." - "Accounts Receivable must be significantly larger than quarterly Platform Revenue (AR is tied to Gross Spend)." - "Long-term debt must equal $0 in all forecast periods." - "Free Cash Flow conversion (FCF / Adjusted EBITDA) should remain robust at >60%." - "Balance sheet must balance: Total Assets = Total Liabilities + Equity in every period." ## Key Assumptions (Default Values) | Assumption | Default Value | Unit | Rationale | |---|---|---|---| | Gross Ad Spend Growth | 12.0 | % | Slight acceleration from 11% in FY2025, driven by CTV and retail media | | Take Rate | 21.6 | % | Flat with FY2025 actuals; historically very stable | | Gross Margin | 80.7 | % | Flat with FY2025 actuals | | Sales & Marketing % of Rev | 21.0 | % | In line with historical averages | | Tech & Dev % of Rev | 19.0 | % | In line with historical averages, supporting Kokai/Ventura | | G&A % of Rev | 13.0 | % | In line with historical averages | | SBC % of Rev | 15.0 | % | Normalised rate, accounting for ongoing executive grants | | DSO (Days Sales Outstanding) | 95 | Days | Calculated based on Gross Spend and historical AR balances | | DPO (Days Payable Outstanding) | 95 | Days | Calculated based on (Gross Spend - Revenue) and historical AP | | Capex % of Rev | 3.0 | % | Historical average for data centre and capitalised software | | Effective Tax Rate | 22.0 | % | Estimated long-term GAAP tax rate | | Annual Share Repurchases | 1,000 | $ Millions | Supported by strong FCF and recent $500M authorisation | | WACC | 9.5 | % | High beta tech stock, offset by zero debt capital structure | | Terminal Growth Rate | 3.5 | % | Long-term digital advertising market growth proxy | ## Data Sources & Benchmarks - **Filings:** SEC EDGAR (The Trade Desk 10-K, 8-K, DEF 14A). - **Investor Relations:** investors.thetradedesk.com (Earnings releases, Q4 2025 presentation). - **Key Peers:** Alphabet (GOOGL), Meta Platforms (META), Amazon (AMZN - Advertising segment), Criteo (CRTO), Viant Technology (DSP). - **Industry Data:** eMarketer (for global digital ad spend and CTV growth forecasts), Magna Global advertising forecasts. ## Sources - The Trade Desk Q4 and Full Year 2025 Earnings Release (February 25, 2026) - The Trade Desk FY2024 and FY2025 Annual Reports on Form 10-K - MediaPost: "Trade Desk's CTV Gross Ad Spend: Competitive Factors?" (February 27, 2026) - Stock Titan: "Trade Desk posts 2025 growth, expands buyback" (February 25, 2026) - Finbox and GuruFocus historical margin data for TTD --- ## Frequently asked questions ### What is The Trade Desk and how does it generate revenue? The Trade Desk is an independent, cloud-based demand-side platform (DSP) that empowers buyers of advertising to create, manage, and optimize data-driven digital advertising campaigns. The company operates as a single reporting segment, generating 100% of its revenue from platform fees, which are a percentage of the gross media spend transacted through its platform. ### What are the primary drivers of The Trade Desk's revenue growth? The Trade Desk's revenue is primarily driven by the formula of Gross Ad Spend multiplied by its Take Rate. Key growth levers include the shift to Connected TV (CTV), retail media partnerships, and international expansion, though macroeconomic advertising slowdowns can act as headwinds. ### What is the assumed revenue growth rate and cost of goods sold percentage in The Trade Desk's financial model? The financial model for The Trade Desk assumes a revenue growth rate of 20% (0.2) for its forecasts. The Cost of Goods Sold (COGS) is projected at approximately 20.03% of revenue within the model's assumptions. ### How does The Trade Desk's working capital profile impact its operating cash flow? The Trade Desk acts as a clearinghouse, billing agencies for Gross Spend and paying publishers for ad inventory, which results in significant working capital swings. While generally positive, the timing of Q4 collections heavily dictates operating cash flow in Q1, making it a crucial aspect for financial analysis. ### What is The Trade Desk's typical capital expenditure as a percentage of revenue? Historically, The Trade Desk's capital expenditure has been between 2-4% of revenue. This spending is almost entirely growth capex, focused on server capacity, capitalized software development, and investments in initiatives like the Ventura streaming TV OS and UID2 infrastructure. ### Can I download an Excel financial model for The Trade Desk, and what is its forecast horizon? Yes, an Excel financial model for The Trade Desk is available for download. This model provides a forecast horizon spanning from fiscal year 2026 through fiscal year 2030, allowing for long-term financial analysis. [Interactive forecast calculator](https://finamodel.com/companies/trade-desk/forecast)