# Gartner (IT) Financial Model Free Excel 3-statement financial model and company analysis for Gartner. - Canonical: https://finamodel.com/companies/gartner - Industry: Business Services - Downloadable model: Yes - Excel download: https://finamodel.com/company-models/IT.xlsx ## Model Purpose This model evaluates Gartner's equity valuation and free cash flow generation capacity to help an equity research analyst determine the intrinsic value of the shares, focusing heavily on subscription contract value (CV) growth, deferred revenue cash flow dynamics, and aggressive share repurchase impacts. ## Company Overview Gartner, Inc. is the world's leading research and advisory company, providing objective insights, tools, and advice to executives across enterprise technology, business strategy, and operational functions. The company operates a highly lucrative, asset-light subscription business model where clients pay upfront for annual access to proprietary research, analyst inquiries, and benchmarking data. The business operates through three primary segments: Business and Technology Insights (approximately 80% of revenue, renamed from "Research" in 2025), Conferences (approximately 10%), and Consulting (approximately 10%). Geographically, the United States and Canada generate roughly 62% of revenue, Europe, Middle East, and Africa (EMEA) contribute 26%, and Other International markets make up the remaining 12%. Gartner enjoys an undisputed market leadership position in IT research, with its Magic Quadrant and Hype Cycle frameworks serving as industry standards for enterprise technology purchasing decisions. Recent major corporate events include the renaming of its core segment to Business and Technology Insights in Q2 2025, the strategic divestiture of its Digital Markets business in late 2025, the issuance of its first investment-grade bonds, and a massive $2.0 billion share repurchase programme executed throughout 2025. ## Revenue Deep Dive ### Business and Technology Insights (formerly Research) - **Segment name:** Business and Technology Insights - **Revenue driver formula:** Beginning Contract Value (CV) + Net New CV (Price Increases + Upsell - Churn) + Non-subscription revenue - **Historical growth rate:** 5% to 8% CAGR - **Key growth levers and headwinds:** Wallet retention rates, expansion into non-IT executive functions (HR, Finance, Supply Chain), and pricing power. A recent headwind has been the U.S. Federal Government sector, which has dragged down overall CV growth compared to the commercial sector. - **Pricing dynamics:** Contractual, highly predictable, and typically paid upfront annually. - **Revenue recognition notes:** Cash is collected upfront and recorded as Deferred Revenue, then recognised ratably over the life of the contract (typically 12 months). - **Seasonality:** Revenue recognition is relatively smooth, but cash collections (billings) peak in Q1 and Q4 when most enterprise contracts renew. ### Conferences - **Segment name:** Conferences - **Revenue driver formula:** Number of Destination Conferences x Average Revenue per Conference - **Historical growth rate:** 10% to 15% (normalising post-pandemic) - **Key growth levers and headwinds:** Corporate travel budgets, attendee volume, and sponsorship demand from technology vendors. - **Pricing dynamics:** Spot pricing for tickets, contractual for sponsorships. - **Revenue recognition notes:** Recognised entirely when the specific conference takes place. - **Seasonality:** Highly seasonal. Q4 is the strongest quarter by a wide margin due to the flagship Gartner IT Symposium/Xpo events, followed by Q2. Q1 and Q3 are materially weaker. ### Consulting - **Segment name:** Consulting - **Revenue driver formula:** Billable Headcount x Utilisation Rate x Average Realised Billing Rate - **Historical growth rate:** 4% to 9% - **Key growth levers and headwinds:** Enterprise IT transformation budgets, consultant retention, and macro-economic uncertainty delaying project sign-offs. - **Pricing dynamics:** Competitive, project-based or time-and-materials. - **Revenue recognition notes:** Recognised over time as services are delivered based on input measures (hours worked). - **Seasonality:** Generally tracks the number of working days in a quarter; Q4 often sees a slight bump from year-end budget flush. ## Cost Structure ### Variable Costs / COGS - **Line-by-line breakdown:** Cost of Services and Product Development includes analyst compensation, conference venue and production costs, and direct consulting labour. - **Gross margin range:** 67% to 69% historically. - **Key input costs and commodity exposures:** Highly dependent on specialised human capital (analyst salaries and bonuses). No material commodity exposure. - **How COGS scales with revenue:** High operating leverage in the Insights segment (one piece of research can be sold infinitely), whereas Conferences and Consulting scale more linearly with volume. ### Operating Expenses - **R&D:** Not explicitly broken out; research creation costs sit in Cost of Services. - **SG&A:** The largest expense category (approximately 35% to 38% of revenue). It includes heavy sales commissions, marketing, and corporate overhead. Commissions are capitalised and amortised over the expected period of client benefit. - **Depreciation & Amortisation:** Approximately 1.5% to 2.5% of revenue, primarily related to capitalised software and acquired intangibles. - **Stock-Based Compensation:** Approximately 2% to 3% of revenue, used to retain key analyst and executive talent. - **Restructuring / one-time charges:** Infrequent, though 2025 included a $150 million goodwill impairment charge related to specific reporting units. ### Margin Profile - **Gross margin:** 67% to 69% - **EBITDA margin:** 23% to 25% (Adjusted EBITDA) - **Operating margin:** 15% to 19% - **Net margin:** 11% to 15% - **Margin trend:** Stable to slightly expanding. The company benefits from operating leverage in its Insights business, though this is occasionally offset by investments in sales headcount and AI initiatives. ## Balance Sheet Structure - **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. ## Capital Expenditure & Investment - **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. ## Debt & Capital Structure - **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. ## Cash Flow Characteristics - **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. ## Sheet Structure 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. ## Key Financial Relationships 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)` ## Cross-Sheet Dependencies 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. ## Sign Convention - 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. ## Things Most Likely to Go Wrong - **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. ## Validation Checks - "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%." ## Key Assumptions (Default Values) | Assumption | Default Value | Unit | Rationale | |---|---|---|---| | Insights (CV) Growth Rate | 5.0 | % | Aligns with recent commercial growth trends and 2026 guidance. | | Conferences Revenue Growth | 8.0 | % | Normalised growth rate post-pandemic recovery. | | Consulting Revenue Growth | 4.0 | % | Conservative estimate based on recent macro-driven project delays. | | Gross Margin | 68.0 | % | Historical average for the consolidated business. | | SG&A as % of Revenue | 36.0 | % | Reflects heavy sales commission structure and marketing spend. | | Adjusted EBITDA Margin | 24.5 | % | In line with 2025 actuals and 2026 management guidance. | | Effective Tax Rate | 22.0 | % | Standard corporate rate adjusted for state taxes and international mix. | | Capex as % of Revenue | 2.5 | % | Historical average for internal software and IT investments. | | Annual Share Repurchases | 1,200 | $ Millions | Reflects the refreshed board authorisation for 2026. | | Average Interest Rate on Debt | 5.5 | % | Blended rate of recent 2031/2035 senior notes and historical debt. | | WACC | 8.5 | % | Standard discount rate for a highly predictable, low-beta subscription business. | | Terminal Growth Rate | 3.0 | % | Long-term GDP plus slight premium for IT sector pricing power. | ## Data Sources & Benchmarks - **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. ## Sources - 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 --- ## Frequently asked questions ### What does Gartner do and how does it make money? Gartner, Inc. is the world's leading research and advisory company, providing objective insights, tools, and advice to executives across enterprise technology, business strategy, and operational functions. The company operates a highly lucrative, asset-light subscription business model where clients pay upfront for annual access to proprietary research, analyst inquiries, and benchmarking data. ### What are Gartner's main revenue segments and how do they contribute? Gartner operates through three primary segments: Business and Technology Insights (approximately 80% of revenue), Conferences (approximately 10%), and Consulting (approximately 10%). Geographically, the United States and Canada generate roughly 62% of revenue, with EMEA contributing 26% and Other International markets 12%. ### What is Gartner's capital expenditure strategy? Gartner's capital expenditure is minimal, typically 2.0% to 3.0% of revenue, and is almost entirely focused on growth and efficiency. This includes investments in internal technology systems, capitalized software development, and AI-augmented tools to improve analyst productivity. ### Why does Gartner have negative net working capital, and what does it mean for the company? Gartner has deeply negative net working capital, typically -20% to -30% of revenue, because it collects cash upfront for 12-month subscriptions. This structural advantage means that business growth generates immediate cash flow for the company. ### What is the primary purpose of the Gartner financial model? The Gartner financial model evaluates the company's equity valuation and free cash flow generation capacity. Its main purpose is to help an equity research analyst determine the intrinsic value of Gartner's shares, with a focus on subscription contract value growth, deferred revenue dynamics, and aggressive share repurchases. ### Can I download an Excel financial model for Gartner? Yes, a downloadable Excel financial model for Gartner (ticker: IT) is available. This model provides a forecast horizon from FY2026 to FY2030, allowing for detailed analysis of the company's future financial performance. [Interactive forecast calculator](https://finamodel.com/companies/gartner/forecast)