IDEX Corporation (IEX) 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
IDEX Corporation (IEX) Bundle
Engineered for accuracy, our (IEX) DCF Calculator allows you to evaluate IDEX Corporation's valuation using real-world financial data and provides complete flexibility to modify all essential parameters for improved projections.
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 | 2,494.6 | 2,351.6 | 2,764.8 | 3,181.9 | 3,273.9 | 3,517.9 | 3,780.2 | 4,062.0 | 4,364.7 | 4,690.1 |
Revenue Growth, % | 0 | -5.73 | 17.57 | 15.09 | 2.89 | 7.45 | 7.45 | 7.45 | 7.45 | 7.45 |
EBITDA | 647.8 | 604.6 | 720.5 | 909.8 | 964.1 | 955.3 | 1,026.5 | 1,103.1 | 1,185.3 | 1,273.6 |
EBITDA, % | 25.97 | 25.71 | 26.06 | 28.59 | 29.45 | 27.16 | 27.16 | 27.16 | 27.16 | 27.16 |
Depreciation | 76.9 | 83.5 | 103.0 | 119.7 | 152.1 | 132.0 | 141.9 | 152.4 | 163.8 | 176.0 |
Depreciation, % | 3.08 | 3.55 | 3.73 | 3.76 | 4.65 | 3.75 | 3.75 | 3.75 | 3.75 | 3.75 |
EBIT | 570.9 | 521.1 | 617.5 | 790.1 | 812.0 | 823.3 | 884.7 | 950.6 | 1,021.5 | 1,097.6 |
EBIT, % | 22.89 | 22.16 | 22.33 | 24.83 | 24.8 | 23.4 | 23.4 | 23.4 | 23.4 | 23.4 |
Total Cash | 632.6 | 1,025.9 | 855.4 | 430.2 | 534.3 | 913.0 | 981.0 | 1,054.2 | 1,132.7 | 1,217.2 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 298.2 | 293.1 | 356.4 | 442.8 | 427.8 | 452.4 | 486.1 | 522.3 | 561.2 | 603.1 |
Account Receivables, % | 11.95 | 12.47 | 12.89 | 13.92 | 13.07 | 12.86 | 12.86 | 12.86 | 12.86 | 12.86 |
Inventories | 293.5 | 289.9 | 370.4 | 470.9 | 420.8 | 458.3 | 492.5 | 529.2 | 568.7 | 611.0 |
Inventories, % | 11.76 | 12.33 | 13.4 | 14.8 | 12.85 | 13.03 | 13.03 | 13.03 | 13.03 | 13.03 |
Accounts Payable | 138.5 | 152.0 | 178.8 | 208.9 | 179.7 | 214.8 | 230.9 | 248.1 | 266.6 | 286.4 |
Accounts Payable, % | 5.55 | 6.46 | 6.47 | 6.57 | 5.49 | 6.11 | 6.11 | 6.11 | 6.11 | 6.11 |
Capital Expenditure | -50.9 | -51.5 | -72.7 | -68.0 | -89.9 | -82.6 | -88.8 | -95.4 | -102.5 | -110.2 |
Capital Expenditure, % | -2.04 | -2.19 | -2.63 | -2.14 | -2.75 | -2.35 | -2.35 | -2.35 | -2.35 | -2.35 |
Tax Rate, % | 21.6 | 21.6 | 21.6 | 21.6 | 21.6 | 21.6 | 21.6 | 21.6 | 21.6 | 21.6 |
EBITAT | 455.9 | 418.6 | 478.6 | 618.8 | 636.6 | 649.4 | 697.8 | 749.8 | 805.7 | 865.8 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 28.6 | 472.7 | 392.0 | 513.7 | 734.7 | 671.9 | 699.0 | 751.1 | 807.1 | 867.3 |
WACC, % | 8.5 | 8.5 | 8.49 | 8.49 | 8.49 | 8.49 | 8.49 | 8.49 | 8.49 | 8.49 |
PV UFCF | ||||||||||
SUM PV UFCF | 2,960.8 | |||||||||
Long Term Growth Rate, % | 4.00 | |||||||||
Free cash flow (T + 1) | 902 | |||||||||
Terminal Value | 20,072 | |||||||||
Present Terminal Value | 13,353 | |||||||||
Enterprise Value | 16,313 | |||||||||
Net Debt | 912 | |||||||||
Equity Value | 15,402 | |||||||||
Diluted Shares Outstanding, MM | 76 | |||||||||
Equity Value Per Share | 202.92 |
What You Will Get
- Real IDEX Financial Data: Pre-filled with IDEX Corporation’s historical and projected data for precise analysis.
- Fully Editable Template: Modify key inputs like revenue growth, WACC, and EBITDA % with ease.
- Automatic Calculations: See IDEX’s intrinsic value update instantly based on your changes.
- Professional Valuation Tool: Designed for investors, analysts, and consultants seeking accurate DCF results.
- User-Friendly Design: Simple structure and clear instructions for all experience levels.
Key Features
- Accurate IDEX Financials: Gain access to reliable pre-loaded historical data and future forecasts.
- Adjustable Forecast Parameters: Modify highlighted cells for metrics like WACC, growth rates, and profit margins.
- Real-Time Calculations: Instant updates for DCF, Net Present Value (NPV), and cash flow assessments.
- Interactive Dashboard: User-friendly charts and summaries to easily visualize your valuation findings.
- Designed for All Levels: An intuitive framework suitable for investors, CFOs, and consultants alike.
How It Works
- Download: Get the pre-built Excel file featuring IDEX Corporation’s (IEX) financial data.
- Customize: Modify projections, such as revenue growth, EBITDA %, and WACC.
- Update Automatically: Watch as intrinsic value and NPV calculations refresh in real-time.
- Test Scenarios: Develop various forecasts and instantly compare results.
- Make Decisions: Leverage the valuation outcomes to inform your investment choices.
Why Choose IDEX Corporation (IEX)?
- Innovative Solutions: IDEX Corporation (IEX) offers cutting-edge technologies tailored to your needs.
- Proven Performance: A track record of delivering reliable products that enhance operational efficiency.
- Comprehensive Support: Dedicated customer service ensures you have assistance whenever needed.
- Global Reach: IDEX Corporation (IEX) operates worldwide, providing solutions across diverse markets.
- Commitment to Sustainability: Focused on environmentally responsible practices for a better future.
Who Should Use This Product?
- Investors: Accurately assess IDEX Corporation’s (IEX) intrinsic value prior to making investment choices.
- CFOs: Utilize a high-quality DCF model for comprehensive financial reporting and analysis.
- Consultants: Efficiently customize the template for client valuation reports.
- Entrepreneurs: Acquire knowledge on financial modeling practices employed by leading corporations.
- Educators: Implement it as a resource to illustrate valuation techniques in the classroom.
What the Template Contains
- Pre-Filled Data: Includes IDEX Corporation’s historical financials and forecasts.
- Discounted Cash Flow Model: Editable DCF valuation model with automatic calculations.
- Weighted Average Cost of Capital (WACC): A dedicated sheet for calculating WACC based on custom inputs.
- Key Financial Ratios: Analyze IDEX Corporation’s profitability, efficiency, and leverage.
- Customizable Inputs: Edit revenue growth, margins, and tax rates with ease.
- Clear Dashboard: Charts and tables summarizing key valuation results.