Intercontinental Exchange, Inc. (ICE) DCF Valuation
- ✓ Completamente Editable: Adáptelo A Sus Necesidades En Excel O Sheets
- ✓ Diseño Profesional: Plantillas Confiables Y Estándares De La Industria
- ✓ Predeterminadas Para Un Uso Rápido Y Eficiente
- ✓ No Se Necesita Experiencia; Fáciles De Seguir
Intercontinental Exchange, Inc. (ICE) Bundle
Explore the financial future of Intercontinental Exchange, Inc. (ICE) with our user-friendly DCF Calculator! Enter your projections for growth, margins, and expenses to calculate the intrinsic value of Intercontinental Exchange, Inc. (ICE) and enhance your investment strategy.
Discounted Cash Flow (DCF) - (USD MM)
| Year | AY1 2019 |
AY2 2020 |
AY3 2021 |
AY4 2022 |
AY5 2023 |
FY1 2024 |
FY2 2025 |
FY3 2026 |
FY4 2027 |
FY5 2028 |
|---|---|---|---|---|---|---|---|---|---|---|
| Revenue | 6,547.0 | 8,244.0 | 9,168.0 | 9,636.0 | 9,903.0 | 11,017.2 | 12,256.7 | 13,635.7 | 15,169.9 | 16,876.7 |
| Revenue Growth, % | 0 | 25.92 | 11.21 | 5.1 | 2.77 | 11.25 | 11.25 | 11.25 | 11.25 | 11.25 |
| EBITDA | 3,337.0 | 3,874.0 | 5,821.0 | 4,803.0 | 4,896.0 | 5,745.2 | 6,391.6 | 7,110.7 | 7,910.7 | 8,800.8 |
| EBITDA, % | 50.97 | 46.99 | 63.49 | 49.84 | 49.44 | 52.15 | 52.15 | 52.15 | 52.15 | 52.15 |
| Depreciation | 3,462.0 | 4,438.0 | 5,335.0 | 5,406.0 | 1,215.0 | 5,140.1 | 5,718.4 | 6,361.7 | 7,077.5 | 7,873.8 |
| Depreciation, % | 52.88 | 53.83 | 58.19 | 56.1 | 12.27 | 46.65 | 46.65 | 46.65 | 46.65 | 46.65 |
| EBIT | -125.0 | -564.0 | 486.0 | -603.0 | 3,681.0 | 605.1 | 673.2 | 749.0 | 833.2 | 927.0 |
| EBIT, % | -1.91 | -6.84 | 5.3 | -6.26 | 37.17 | 5.49 | 5.49 | 5.49 | 5.49 | 5.49 |
| Total Cash | 841.0 | 583.0 | 607.0 | 1,799.0 | 2,110.0 | 1,465.6 | 1,630.5 | 1,813.9 | 2,018.0 | 2,245.1 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 988.0 | 1,230.0 | 1,208.0 | 1,169.0 | 1,366.0 | 1,522.9 | 1,694.2 | 1,884.8 | 2,096.9 | 2,332.8 |
| Account Receivables, % | 15.09 | 14.92 | 13.18 | 12.13 | 13.79 | 13.82 | 13.82 | 13.82 | 13.82 | 13.82 |
| Inventories | 65,930.0 | 85,083.0 | 146,971.0 | 153,521.0 | .0 | 8,813.7 | 9,805.4 | 10,908.6 | 12,135.9 | 13,501.3 |
| Inventories, % | 1007.03 | 1032.06 | 1603.09 | 1593.2 | 0 | 80 | 80 | 80 | 80 | 80 |
| Accounts Payable | 505.0 | 639.0 | 703.0 | 866.0 | 1,003.0 | 930.9 | 1,035.6 | 1,152.2 | 1,281.8 | 1,426.0 |
| Accounts Payable, % | 7.71 | 7.75 | 7.67 | 8.99 | 10.13 | 8.45 | 8.45 | 8.45 | 8.45 | 8.45 |
| Capital Expenditure | -305.0 | -410.0 | -452.0 | -482.0 | -489.0 | -539.9 | -600.6 | -668.2 | -743.4 | -827.0 |
| Capital Expenditure, % | -4.66 | -4.97 | -4.93 | -5 | -4.94 | -4.9 | -4.9 | -4.9 | -4.9 | -4.9 |
| Tax Rate, % | 18.18 | 18.18 | 18.18 | 18.18 | 18.18 | 18.18 | 18.18 | 18.18 | 18.18 | 18.18 |
| EBITAT | -97.4 | -426.0 | 346.1 | -482.3 | 3,012.0 | 467.7 | 520.3 | 578.9 | 644.0 | 716.5 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -63,353.4 | -15,659.0 | -56,572.9 | -1,906.3 | 157,199.0 | -3,974.8 | 4,579.8 | 5,095.1 | 5,668.4 | 6,306.1 |
| WACC, % | 8.3 | 8.28 | 8.24 | 8.32 | 8.34 | 8.29 | 8.29 | 8.29 | 8.29 | 8.29 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 12,601.7 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 6,432 | |||||||||
| Terminal Value | 102,189 | |||||||||
| Present Terminal Value | 68,607 | |||||||||
| Enterprise Value | 81,209 | |||||||||
| Net Debt | 22,013 | |||||||||
| Equity Value | 59,196 | |||||||||
| Diluted Shares Outstanding, MM | 565 | |||||||||
| Equity Value Per Share | 104.77 |
What You Will Get
- Editable Forecast Inputs: Easily modify assumptions (growth %, margins, WACC) to explore various scenarios.
- Real-World Data: Intercontinental Exchange, Inc. (ICE)’s financial data pre-filled to enhance your analysis.
- Automatic DCF Outputs: The template computes Net Present Value (NPV) and intrinsic value automatically.
- Customizable and Professional: A sleek Excel model that adjusts to your valuation requirements.
- Built for Analysts and Investors: Perfect for assessing projections, validating strategies, and optimizing efficiency.
Key Features
- 🔍 Real-Life ICE Financials: Pre-filled historical and projected data for Intercontinental Exchange, Inc. (ICE).
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate ICE’s intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize ICE’s valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- Step 1: Download the prebuilt Excel template featuring Intercontinental Exchange, Inc. (ICE) data.
- Step 2: Navigate through the pre-filled sheets to familiarize yourself with the essential metrics.
- Step 3: Modify forecasts and assumptions in the editable yellow cells (WACC, growth, margins).
- Step 4: Instantly see the recalculated results, including the intrinsic value of Intercontinental Exchange, Inc. (ICE).
- Step 5: Utilize the outputs to make informed investment decisions or create comprehensive reports.
Why Choose This Calculator?
- Accurate Data: Real Intercontinental Exchange, Inc. (ICE) financials ensure reliable valuation results.
- Customizable: Adjust key parameters like growth rates, WACC, and tax rates to match your projections.
- Time-Saving: Pre-built calculations eliminate the need to start from scratch.
- Professional-Grade Tool: Designed for investors, analysts, and consultants.
- User-Friendly: Intuitive layout and step-by-step instructions make it easy for all users.
Who Should Use This Product?
- Institutional Investors: Develop comprehensive trading strategies based on market data from Intercontinental Exchange, Inc. (ICE).
- Risk Management Teams: Assess and mitigate financial risks using advanced analytical tools offered by Intercontinental Exchange, Inc. (ICE).
- Financial Analysts: Provide clients with in-depth insights and forecasts related to market trends involving Intercontinental Exchange, Inc. (ICE).
- Students and Educators: Utilize real-time market information to enhance learning and teaching in finance and trading.
- Market Enthusiasts: Gain a deeper understanding of how exchanges like Intercontinental Exchange, Inc. (ICE) influence global markets.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Intercontinental Exchange, Inc. (ICE) historical data and forecasts, including revenue, EBITDA, EBIT, and capital expenditures.
- WACC Calculation: A dedicated sheet for Weighted Average Cost of Capital (WACC), featuring parameters such as Beta, risk-free rate, and share price.
- DCF Valuation (Unlevered and Levered): Editable Discounted Cash Flow models illustrating intrinsic value with comprehensive calculations.
- Financial Statements: Pre-loaded financial statements (annual and quarterly) to facilitate analysis.
- Key Ratios: Includes profitability, leverage, and efficiency ratios for Intercontinental Exchange, Inc. (ICE).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to simplify result analysis.