Gartner Financial Model

• Total assets: Approximately $7.0 billion to $8.0 billion.
• Key asset categories: Goodwill and Intangible Assets (historically from the CEB acquisition) make up a large portion of assets. Cash and cash equivalents are also material, sitting at $1.7 billion at the end of 2025.
• Goodwill & intangibles as % of total assets: Approximately 40% to 50%.
• Working capital profile:
• Days Sales Outstanding (DSO): 60 to 70 days.
• Days Inventory Outstanding (DIO): 0 days (not applicable).
• Days Payable Outstanding (DPO): 30 to 40 days.
• Net working capital as % of revenue: Deeply negative (typically -20% to -30%).
• Is working capital positive or negative? Negative. Gartner collects cash upfront for 12-month subscriptions, creating a massive Deferred Revenue liability. This negative working capital is a structural advantage, meaning growth generates immediate cash flow.
• PP&E: Minimal (less than 5% of assets), consisting mostly of leasehold improvements for offices and internal IT equipment.
• Right-of-use assets / operating leases: Material due to a global footprint of sales and analyst offices.

• Capex as % of revenue: 2.0% to 3.0%.
• Maintenance capex vs. growth capex: Almost entirely growth and efficiency capex, focused on internal technology systems and capitalised software development.
• Major capex programmes underway or planned: Investments in AI-augmented software engineering practices and internal generative AI tools to improve analyst productivity.
• Capitalised software / development costs: Material component of total capex.
• M&A pattern: Historically a transformational acquirer (e.g., CEB in 2017), but recently focused on organic growth and portfolio optimisation (divesting Digital Markets in 2025).
• Typical acquisition multiple paid: Not applicable for recent years as the focus has shifted entirely to share repurchases.

• Total debt: Approximately $2.5 billion.
• Debt/EBITDA ratio: 1.5x to 2.0x (management targets maintaining investment-grade metrics).
• Credit rating: Investment grade (achieved first investment-grade bond issuance in 2025).
• Key debt instruments: Senior unsecured notes (including $350 million due 2031 and $450 million due 2035 issued in 2025) and a revolving credit facility.
• Maturity profile: Well-laddered with recent 2025 refinancing pushing major maturities into the 2030s.
• Interest rate profile: Primarily fixed-rate bonds, with floating rates on the revolver (if drawn).
• Covenants: Standard leverage and interest coverage ratios; currently operating well within limits.
• Share repurchase programme: Highly active. The company repurchased $2.0 billion of stock in 2025 (reducing outstanding shares by 8%) and authorised an additional $500 million in early 2026.
• Dividend policy: The company does not pay a dividend, preferring to return all excess capital via share repurchases.

• Operating cash flow conversion: Consistently exceeds 100% of Net Income (often 150%+) due to the upfront collection of subscription fees (deferred revenue growth) and non-cash add-backs.
• Free cash flow margin: 18% to 20% (generated $1.2 billion FCF on $6.5 billion revenue in 2025).
• Major non-cash items: Depreciation, amortisation, stock-based compensation, and occasional impairment charges ($150 million goodwill impairment in 2025).
• Working capital cash flow impact: A major source of cash. As Contract Value grows, the Deferred Revenue balance increases, providing a continuous cash float.
• Capex intensity: Very low (asset-light model).
• Cash tax rate vs. GAAP effective tax rate: Cash taxes are generally aligned with the GAAP effective rate (around 20% to 24%), though timing differences exist due to capitalised commission deductibility.

1. Assumptions: Hardcoded drivers for Contract Value growth, segment margins, macro indicators, and capital allocation targets.
2. Scenarios: Base, Bull, and Bear toggle switches linked to the Assumptions sheet.
3. Revenue_Build: Detailed roll-forward of Insights Contract Value (Beginning CV + Net New - Churn), Conferences schedule (number of events x revenue per event), and Consulting capacity.
4. Income_Statement: Segment revenues (Insights, Conferences, Consulting), Cost of Services and Product Development, SG&A, D&A, Interest Expense, and Taxes.
5. Balance_Sheet: Cash, Accounts Receivable, Prepaid Expenses, PP&E, Goodwill, Deferred Revenue (current and non-current), Debt, and Shareholders' Equity.
6. Cash_Flow: Net Income bridge to OCF (highlighting Deferred Revenue changes and SBC), Capex, Debt issuance/repayment, and Share Repurchases.
7. Debt_Schedule: Tranche-by-tranche breakdown of Senior Notes, Revolver balance, interest rate calculations, and maturity tracking.
8. Working_Capital: DSO, DPO, and a detailed Deferred Revenue waterfall schedule.
9. DCF: Unlevered Free Cash Flow calculation, WACC build, Terminal Value, and implied share price.
10. Outputs: Summary dashboard showing Adjusted EPS, FCF per share, segment growth rates, and leverage ratios.

1. `Insights Revenue = (Beginning Deferred Revenue + In-Period Billings) recognised ratably over the period`
2. `Ending Contract Value (CV) = Beginning CV + Net New Business + Pricing Uplift - Churn`
3. `Conferences Revenue = Number of Destination Conferences x Average Revenue per Conference`
4. `Consulting Revenue = Billable Headcount x Target Utilisation % x Average Realised Rate`
5. `Total Revenue = Insights Revenue + Conferences Revenue + Consulting Revenue`
6. `Cost of Services = Insights Direct Costs + Conference Venue/Production Costs + Consulting Labour`
7. `Gross Profit = Total Revenue - Cost of Services`
8. `Adjusted EBITDA = Net Income + Taxes + Interest + D&A + Stock-Based Comp + One-Time Impairments`
9. `Deferred Revenue Change = Total Billings - Recognised Insights Revenue`
10. `Operating Cash Flow = Net Income + Non-Cash Charges + Change in Net Working Capital (driven by Deferred Revenue)`
11. `Free Cash Flow = Operating Cash Flow - Capital Expenditures`
12. `Ending Shares Outstanding = Beginning Shares Outstanding - (Share Repurchase Allocation / Average Share Price)`

The `Assumptions` sheet feeds the `Revenue_Build` to calculate Contract Value and segment revenues. The `Revenue_Build` feeds the `Income_Statement` (top line) and `Working_Capital` (to calculate Billings and Deferred Revenue). The `Working_Capital` sheet calculates the change in Deferred Revenue, which is a critical input for the `Cash_Flow` sheet (Operating Cash Flow). The `Cash_Flow` sheet determines Free Cash Flow, which feeds the `Debt_Schedule` (for revolver paydowns) and the `Balance_Sheet` (Cash balance). The `Debt_Schedule` calculates Interest Expense, which loops back to the `Income_Statement`. A circularity switch must be included to break the interest expense and cash balance loop.

• Revenues and Contract Value metrics are positive.
• Expenses (COGS, SG&A, Interest, Taxes) are entered as positive numbers and subtracted in subtotal formulas.
• Assets and Liabilities are positive.
• On the Cash Flow Statement, cash inflows are positive, and cash outflows (Capex, Share Repurchases, Debt Repayment) are negative.

• Mismodelling Deferred Revenue: Gartner collects cash upfront. If Contract Value grows, Deferred Revenue must grow, which artificially boosts Operating Cash Flow relative to Net Income. Failing to link CV growth to Deferred Revenue will break the cash flow model.
• Ignoring the Digital Markets divestiture: The company divested this unit in late 2025. Historical data must be pro-forma adjusted to remove Digital Markets revenue and EBITDA to ensure comparable growth rates for 2026 and beyond.
• Segment renaming confusion: The core segment was renamed from "Research" to "Business and Technology Insights" in Q2 2025. The model must use the new nomenclature to match future filings.
• Conference seasonality: Conferences revenue is highly skewed to Q4 (IT Symposiums) and Q2. Straight-lining conference revenue across four quarters will result in massive quarterly forecasting errors.
• Share count reduction: Gartner aggressively buys back stock (reducing share count by 8% in 2025). The model must dynamically reduce the share count, otherwise EPS forecasts will be far too low.
• Federal vs. Commercial CV: U.S. Federal government contract value has been a drag on overall growth. The model should ideally split CV into Federal and Commercial to accurately project recovery.
• Capitalised commissions: Gartner capitalises a significant portion of sales commissions and amortises them. This creates a divergence between cash SG&A and GAAP SG&A that must be tracked in working capital.
• Goodwill impairments: The $150 million impairment in 2025 distorts historical GAAP operating margins. The model must use Adjusted EBITDA and Adjusted EPS for trend analysis.

• "Free Cash Flow to Net Income conversion should consistently exceed 1.2x due to the deferred revenue float; flag if it drops below 1.0x."
• "Gross margin should remain tightly bound between 67% and 69%; flag if outside this band."
• "Adjusted EBITDA margin should be approximately 24% to 25%; flag if it deviates by more than 150 bps."
• "Share count must decline year-over-year if the share repurchase assumption is greater than zero."
• "Balance sheet must balance: Total Assets = Total Liabilities + Equity in every period."
• "Debt/EBITDA should remain below 2.5x to align with the company's investment-grade rating targets."
• "Deferred Revenue should represent approximately 35% to 45% of the next twelve months' Insights revenue."
• "Capex as a percentage of revenue should not exceed 3.5%."

• Filings: SEC EDGAR (Gartner 10-K, 10-Q, 8-K) and the Gartner Investor Relations website (specifically the Quarterly Earnings Supplements which contain vital Contract Value metrics).
• Peers for benchmarking: Forrester Research (FORR), FactSet Research Systems (FDS), Morningstar (MORN), and MSCI Inc. (MSCI).
• Industry data sources: Global IT spending forecasts (often published by Gartner themselves) and corporate travel recovery indices (for the Conferences segment).
• Consensus estimates: Bloomberg or FactSet consensus for Adjusted EPS and Free Cash Flow to validate model outputs against Street expectations.

• Gartner Q4 2025 Earnings Release and Financial Supplement (investor.gartner.com)
• Gartner 2025 Annual Report on Form 10-K (sec.gov)
• Quartr Q4 2025 Earnings Summary and Transcript
• Investing.com Q4 2025 Financial Analysis
• Bullfincher Gartner Company Profile and Statistics