# Intercontinental Exchange (ICE) Financial Model Free Excel 3-statement financial model and company analysis for Intercontinental Exchange. - Canonical: https://finamodel.com/companies/intercontinental-exchange - Industry: Capital Markets - Downloadable model: Yes - Excel download: https://finamodel.com/company-models/ICE.xlsx ## Model Purpose This model provides a comprehensive sum-of-the-parts equity valuation and cash flow forecast for Intercontinental Exchange (ICE) to help an equity research analyst determine the target price and assess the deleveraging trajectory following the Black Knight acquisition. ## Company Overview Intercontinental Exchange (ICE) is a leading global provider of market infrastructure, data services, and technology solutions to a broad range of customers including financial institutions, corporations, and government entities. The company operates regulated exchanges, clearing houses, and digital workflow tools, most notably running the New York Stock Exchange (NYSE) and a comprehensive US residential mortgage technology platform. - Exchanges (approximately 54% of net revenue): Operates global commodity and financial futures exchanges, the NYSE, and related clearing houses. - Fixed Income and Data Services (approximately 24% of net revenue): Provides fixed income pricing, reference data, indices, and execution networks. - Mortgage Technology (approximately 22% of net revenue): Offers end-to-end digital workflow tools for the US residential mortgage market, significantly expanded by the 2023 acquisition of Black Knight. - Key Geographies: Primarily the US, UK, and EU, though data and exchange customers are global. - Business Model: Platform and transaction-based, with a strong shift towards recurring subscription revenue (data and software). - Competitive Position: A dominant global exchange operator (alongside CME Group and Nasdaq) and the leading provider of US mortgage origination and servicing technology. - Recent Major Events: Closed the $11.9 billion acquisition of Black Knight in September 2023, which required divesting the Empower and Optimal Blue businesses to satisfy antitrust regulators. ## Revenue Deep Dive ### Exchanges - Segment name: Exchanges - Revenue driver formula: (Trading Volume x Rate per Contract) + (Listings x Fee per Listing) + Exchange Data Subscriptions. - Historical growth rate: 5-9% CAGR. - Key growth levers and headwinds: Energy market volatility, interest rate hedging demand, and IPO market health. - Pricing dynamics: Highly regulated but possesses strong pricing power for proprietary data and listing fees. - Revenue recognition: Transaction fees recognised upon trade execution; data and listings recognised rateably over the subscription or listing period. - Seasonality: Q1 is typically the strongest quarter for trading volumes due to portfolio rebalancing and beginning-of-year hedging. ### Fixed Income and Data Services - Segment name: Fixed Income and Data Services - Revenue driver formula: Annual Subscription Value + (Fixed Income Execution Volume x Capture Rate). - Historical growth rate: 4-6% CAGR. - Key growth levers and headwinds: Shift towards passive investing (ETF AUM benchmarked to ICE indices reached $794 billion in 2025), demand for ESG and climate data. - Pricing dynamics: Subscription-based with annual price escalators. - Revenue recognition: Predominantly recognised over time as services are provided. - Seasonality: Relatively stable due to the high mix of recurring revenue. ### Mortgage Technology - Segment name: Mortgage Technology - Revenue driver formula: (US Mortgage Origination Volume x Capture Rate per Loan) + Servicing Software Subscriptions. - Historical growth rate: Highly cyclical, recently 4-5% following the Black Knight integration. - Key growth levers and headwinds: US interest rate environment, housing inventory, and refinancing cycles. - Pricing dynamics: Transaction fees tied to loan origination volumes, plus sticky recurring SaaS fees for servicing software. - Revenue recognition: Transaction fees recognised upon loan closing or network transaction; software subscriptions recognised over the contract term. - Seasonality: Spring and summer months typically see higher home buying activity, driving Q2 and Q3 transaction volumes. ## Cost Structure ### Variable Costs / COGS - Line-by-line breakdown: Transaction-based expenses (Section 31 fees, clearing fees, and liquidity payments). ICE reports "Net Revenues" which deducts these directly from gross revenues. - Gross margin range: ICE focuses on Net Revenue margins. Operating margins on Net Revenue range from 46% to 50% (GAAP) and 58% to 60% (Adjusted). - Key input costs: Server hosting, cloud computing, and bandwidth. - How COGS scales: Transaction expenses scale perfectly linearly with gross transaction volumes. ### Operating Expenses - Compensation and Benefits: The largest expense, driven by headcount, wage inflation, and performance-based bonuses. - Technology and Communication: Cloud infrastructure, data centre costs, and network capacity. - Depreciation & Amortisation: Significant due to the capitalisation of software development and large intangible assets from acquisitions (Black Knight, Ellie Mae). - Selling, General and Administrative: Marketing, professional fees, and legal costs. - Acquisition-Related and Restructuring: Frequent adjustments for M&A integration costs and severance. ### Margin Profile - Adjusted operating margins have steadily expanded to approximately 60% in 2025, driven by operating leverage in the data and exchange businesses. - GAAP operating margins run lower (around 50%) due to heavy acquisition-related amortisation. - Segment margins: Exchanges run at approximately 75% adjusted operating margin, FIDS at 45%, and Mortgage Technology at 41%. ## Balance Sheet Structure - Total assets: Approximately $160 billion to $180 billion, heavily inflated by clearing house assets. - Key asset categories: Cash, Goodwill and Intangible Assets, and Clearing House Assets (margin deposits and guaranty funds). - Goodwill & intangibles: Represents a massive portion of non-clearing assets due to serial acquisitions (NYSE, Ellie Mae, Black Knight). - Working capital profile: - Days Sales Outstanding (DSO): 30 to 40 days. - Days Payable Outstanding (DPO): 20 to 30 days. - Net working capital: Often negative or neutral when excluding clearing house assets, as subscription data is billed in advance (deferred revenue). - PP&E: Relatively small compared to intangibles; consists of data centres, network equipment, and office leases. - Right-of-use assets: Material but manageable, representing long-term office and data centre leases. ## Capital Expenditure & Investment - Capex as % of revenue: Typically 7-8% of Net Revenue ($740 to $790 million guided for 2026). - Maintenance vs. growth: Heavily skewed towards growth and capitalised software development for new trading platforms and mortgage technology integration. - Capitalised software: A major component of capex, reflecting internal development of proprietary matching engines and data analytics tools. - M&A pattern: Transformational acquirer. ICE historically buys large, dominant platforms (NYSE, Ellie Mae, Black Knight) and extracts significant cost and revenue synergies. - Typical acquisition multiple: Often pays 15x to 20x forward EBITDA for high-quality technology assets, relying on synergies to bring the effective multiple down. ## Debt & Capital Structure - Total debt: $19.6 billion as of December 31, 2025. - Debt/EBITDA ratio: Target is below 3.0x. The company successfully deleveraged to 3.0x by the end of 2025 following the Black Knight acquisition. - Credit rating: A- (S&P), A3 (Moody's). - Key debt instruments: Senior unsecured notes, commercial paper programme, and term loans. - Maturity profile: Well-laddered bond maturities stretching out 10 to 40 years. - Interest rate profile: Predominantly fixed-rate bonds, with commercial paper used for short-term floating-rate liquidity. - Share repurchase programme: Highly active. Repurchased $1.3 billion in 2025 after pausing temporarily to deleverage post-Black Knight. - Dividend policy: Consistent dividend grower, paying out approximately $1.1 billion in 2025 with a 6% increase heading into 2026. ## Cash Flow Characteristics - Operating cash flow conversion: Extremely strong. OCF is typically $4.5 to $4.7 billion, closely tracking adjusted net income. - Free cash flow margin: Adjusted FCF margin is typically 40-45% of Net Revenue ($4.2 billion in 2025). - Major non-cash items: Depreciation and amortisation (especially acquisition-related intangibles) and stock-based compensation. - Working capital cash flow impact: Favourable due to upfront collection of data subscriptions and listing fees. - Capex intensity: Low capital intensity, allowing for massive free cash flow generation. - Cash tax rate: Typically 24% to 26%, closely mirroring the GAAP effective tax rate. ## Sheet Structure 1. **Control**: Scenario toggles, cost of capital assumptions, and macro drivers (US mortgage origination volume forecasts, equity market volatility). 2. **Assumptions**: Hardcoded historical data and projected growth rates, margins, and capital allocation targets. 3. **Revenues_Exchanges**: Volume, rate per contract, and recurring data revenue for the Exchanges segment. 4. **Revenues_FIDS**: Fixed Income and Data Services recurring revenue build, index AUM, and execution volumes. 5. **Revenues_Mortgage**: Origination technology, closing solutions, and servicing software (Black Knight integration) revenue build. 6. **Consolidated_IS**: Income statement down to Net Income, calculating both GAAP and Adjusted EPS. 7. **Operating_Expenses**: Breakdown of compensation, technology, D&A, and acquisition-related costs. 8. **Working_Capital**: Receivables, deferred revenue, and accrued liabilities (excluding clearing house assets). 9. **Clearing_House**: Separate tracking of margin deposits and guaranty funds (assets and matching liabilities) to prevent distortion of core working capital. 10. **PP&E_and_Intangibles**: Capex, capitalised software, and amortisation schedules for acquisition intangibles. 11. **Debt_Schedule**: Tranche-by-tranche bond maturities, commercial paper balances, and interest expense calculation. 12. **Equity_and_Dividends**: Share count roll-forward, buyback modelling, and dividend payouts. 13. **Consolidated_BS**: Balance sheet ensuring Total Assets equal Total Liabilities plus Equity. 14. **Consolidated_CFS**: Cash flow statement bridging Net Income to Free Cash Flow. 15. **Valuation_DCF**: Unlevered free cash flow build, WACC calculation, and terminal value. 16. **Valuation_SOTP**: Sum-of-the-parts valuation applying different EV/EBITDA multiples to Exchanges, FIDS, and Mortgage Technology. ## Key Financial Relationships 1. Exchanges Net Revenue = Gross Exchanges Revenue - Transaction-Based Expenses. 2. Futures & Options Revenue = Total Contract Volume x Average Rate per Contract. 3. FIDS Recurring Revenue = Prior Year FIDS Recurring Revenue x (1 + FIDS Recurring Growth Rate). 4. Mortgage Origination Revenue = US Total Mortgage Origination Market Volume x ICE Market Share x Revenue per Loan. 5. Adjusted Operating Income = GAAP Operating Income + Acquisition-Related Amortisation + M&A Integration Costs. 6. Adjusted Operating Margin = Adjusted Operating Income / Total Net Revenue. 7. Capitalised Software = Total Capex x Capitalised Software Percentage. 8. Free Cash Flow = Operating Cash Flow - Capital Expenditures - Capitalised Software Development Costs. 9. Interest Expense = (Average Commercial Paper Balance x Short-Term Rate) + Sum of (Bond Tranches x Fixed Coupon Rates). 10. Share Repurchases = Available Free Cash Flow - Dividends Paid - Debt Principal Repayments. 11. Ending Basic Shares = Beginning Basic Shares - (Share Repurchases / Average Share Price). 12. Gross Leverage Ratio = Total Gross Debt / Adjusted EBITDA. ## Cross-Sheet Dependencies - The **Revenues** sheets (Exchanges, FIDS, Mortgage) feed directly into the top line of the **Consolidated_IS**. - **Operating_Expenses** feeds into the **Consolidated_IS** to determine Operating Income. - **PP&E_and_Intangibles** calculates D&A, which feeds into **Operating_Expenses** (for GAAP) and the **Consolidated_CFS** as a non-cash add-back. - **Clearing_House** feeds both the asset and liability sides of the **Consolidated_BS**, ensuring the massive margin deposits remain balanced. - **Debt_Schedule** calculates interest expense, which feeds the **Consolidated_IS**, creating a potential circularity if debt repayments are driven by cash sweeps from the **Consolidated_CFS**. - **Equity_and_Dividends** relies on the share price derived from the **Valuation_DCF** to calculate the number of shares repurchased, which then feeds back into the EPS calculation on the **Consolidated_IS**. ## Sign Convention - Revenues and Asset balances are entered as positive numbers. - Expenses, capital expenditures, and cash outflows are entered as positive numbers in their build schedules, but subtracted in the Income Statement and Cash Flow Statement formulas. - Liabilities and Equity balances are entered as positive numbers. - Contra-asset accounts (like accumulated depreciation) are entered as positive numbers and subtracted from gross assets. - In the Cash Flow Statement, an increase in an asset is a negative adjustment (cash outflow), and an increase in a liability is a positive adjustment (cash inflow). ## Things Most Likely to Go Wrong 1. Failing to separate Gross Revenue from Net Revenue. ICE reports Net Revenue as its primary top-line metric; modelling based on Gross Revenue will distort margin calculations. 2. Mishandling clearing house assets. Margin deposits can swing by tens of billions of dollars quarter-to-quarter. These must be modelled as perfectly offsetting assets and liabilities so they do not impact core free cash flow. 3. Ignoring the difference between GAAP and Adjusted earnings. ICE's GAAP earnings are heavily burdened by acquisition-related amortisation. Valuation must be based on Adjusted EPS and Adjusted Free Cash Flow. 4. Miscalculating the Black Knight synergies. The model must phase in the stated revenue and cost synergies over the 2024-2026 period, rather than assuming immediate realisation. 5. Overestimating mortgage technology growth. This segment is highly sensitive to US interest rates; the model must link this segment's growth to macroeconomic mortgage origination forecasts. 6. Double-counting capitalised software. It appears in capex but is amortised through operating expenses. Ensure the cash flow statement correctly captures the cash outflow without double-counting the expense. 7. Incorrectly modelling the constant currency impact. ICE has significant UK and EU operations; the model should ideally forecast in constant currency and apply a top-level FX overlay. 8. Forgetting the share count dilution from the Black Knight acquisition. ICE issued approximately 10.9 million shares to fund the deal, which permanently altered the share base. ## Validation Checks 1. Adjusted Operating Margin must remain between 58% and 62%. Flag if it falls outside this range. 2. Total Net Revenue growth should align with management guidance (mid-single digits for Exchanges and FIDS, low-to-mid single digits for Mortgage Technology). 3. Gross Leverage (Debt/Adjusted EBITDA) must trend towards or remain at the 3.0x target. 4. Adjusted Free Cash Flow conversion (Adj FCF / Adj Net Income) should remain consistently above 1.0x. 5. The Balance Sheet must balance perfectly in every forecasted period, including the volatile clearing house line items. 6. Capex (including capitalised software) should remain between 7% and 8% of Total Net Revenue. 7. Effective tax rate should remain between 24% and 26% as per management guidance. 8. Dividend payout ratio should remain sustainable, typically between 25% and 35% of Adjusted Free Cash Flow. ## Key Assumptions (Default Values) | Assumption | Default Value | Unit | Rationale | |---|---|---|---| | Exchanges Net Revenue Growth | 5.0 | % | Management guidance for mid-single digit recurring growth and stable transaction volumes. | | FIDS Net Revenue Growth | 5.0 | % | Management guidance for mid-single digit growth driven by index and pricing data. | | Mortgage Tech Revenue Growth | 4.0 | % | Management guidance for low-to-mid single digit growth in 2026. | | Adjusted Operating Margin | 60.0 | % | Actual reported adjusted operating margin for FY 2025. | | Capex (Total) | 765 | $ Millions | Midpoint of management's 2026 guidance range ($740M - $790M). | | Effective Tax Rate | 25.0 | % | Midpoint of management's 2026 guidance range (24% - 26%). | | Target Gross Leverage | 3.0 | x | Company's stated leverage target, achieved at the end of 2025. | | Annual Share Repurchases | 1,300 | $ Millions | Matches the actual share repurchases executed in FY 2025. | | Dividend Growth Rate | 6.0 | % | Matches the dividend increase announced for 2026. | | WACC | 8.5 | % | Standard cost of capital for a diversified, mature financial infrastructure provider. | | Terminal Growth Rate | 2.5 | % | Reflects long-term GDP growth plus pricing power in data services. | ## Data Sources & Benchmarks - SEC EDGAR: ICE 10-K, 10-Q, and 8-K filings. - ICE Investor Relations: Quarterly earnings supplements, synergy tracking presentations, and monthly volume reports. - Key Peers: CME Group (CME), Nasdaq (NDAQ), London Stock Exchange Group (LSEG), MSCI Inc. (MSCI). - Industry Data: Mortgage Bankers Association (MBA) for US mortgage origination forecasts; Futures Industry Association (FIA) for global derivatives volumes. - Consensus Estimates: FactSet or Bloomberg for forward EPS and revenue estimates. ## Sources - Intercontinental Exchange Inc. FY 2025 Earnings Release and Presentation (February 5, 2026). - Intercontinental Exchange Inc. FY 2024 Earnings Release (February 6, 2025). - Intercontinental Exchange Inc. 2025 Form 10-K. - S&P Global Ratings Research Update on ICE (September 6, 2023). - ICE Black Knight Acquisition Press Releases and Synergy Presentations (2022-2023). --- ## Frequently asked questions ### What does Intercontinental Exchange (ICE) do? Intercontinental Exchange (ICE) is a leading global provider of market infrastructure, data services, and technology solutions. The company operates regulated exchanges, including the New York Stock Exchange (NYSE), and offers a comprehensive US residential mortgage technology platform. ### How does Intercontinental Exchange (ICE) generate revenue? ICE generates revenue through a platform and transaction-based business model, with a significant shift towards recurring subscription revenue from data and software. Its main segments include Exchanges, Fixed Income and Data Services, and Mortgage Technology. ### What is Intercontinental Exchange's (ICE) capital expenditure strategy? ICE's capital expenditure typically represents 7-8% of Net Revenue, heavily skewed towards growth and capitalized software development. This investment supports new trading platforms and the integration of mortgage technology solutions. ### What is the purpose of the Intercontinental Exchange (ICE) financial model? The ICE financial model provides a comprehensive sum-of-the-parts equity valuation and cash flow forecast. Its purpose is to assist equity research analysts in determining a target price and assessing the company's deleveraging trajectory following the Black Knight acquisition. ### Can I download an Excel financial model for Intercontinental Exchange (ICE)? Yes, an Excel financial model for Intercontinental Exchange (ICE) is available for download. This model offers a comprehensive sum-of-the-parts equity valuation and cash flow forecast for the company. ### What are the key operating expense assumptions in the Intercontinental Exchange (ICE) financial model? The financial model assumes Cost of Goods Sold (COGS) at 55% of revenue and Selling, General, and Administrative (SGA) expenses at approximately 2.4% of revenue. Depreciation and Amortization (DA) is modeled at about 10.6% of revenue. [Interactive forecast calculator](https://finamodel.com/companies/intercontinental-exchange/forecast)