|
Valoración de DCF de Icahn Enterprises L.P. (IEP)
US | Industrials | Conglomerates | NASDAQ
|
- ✓ 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
Icahn Enterprises L.P. (IEP) Bundle
¿Busca evaluar el valor intrínseco de Icahn Enterprises L.P.? Nuestra calculadora DCF (IEP) integra datos del mundo real con amplias opciones de personalización, lo que le permite ajustar los pronósticos y mejorar sus opciones de inversión.
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 | 10,386.0 | 7,423.0 | 10,941.0 | 14,126.0 | 11,847.0 | 12,790.1 | 13,808.2 | 14,907.4 | 16,094.1 | 17,375.3 |
| Revenue Growth, % | 0 | -28.53 | 47.39 | 29.11 | -16.13 | 7.96 | 7.96 | 7.96 | 7.96 | 7.96 |
| EBITDA | -684.0 | -1,446.0 | 605.0 | 755.0 | 150.0 | -356.2 | -384.6 | -415.2 | -448.2 | -483.9 |
| EBITDA, % | -6.59 | -19.48 | 5.53 | 5.34 | 1.27 | -2.79 | -2.79 | -2.79 | -2.79 | -2.79 |
| Depreciation | 450.0 | 450.0 | 517.0 | 509.0 | 518.0 | 590.8 | 637.8 | 688.6 | 743.4 | 802.6 |
| Depreciation, % | 4.33 | 6.06 | 4.73 | 3.6 | 4.37 | 4.62 | 4.62 | 4.62 | 4.62 | 4.62 |
| EBIT | -1,134.0 | -1,896.0 | 88.0 | 246.0 | -368.0 | -947.0 | -1,022.4 | -1,103.8 | -1,191.6 | -1,286.5 |
| EBIT, % | -10.92 | -25.54 | 0.80431 | 1.74 | -3.11 | -7.4 | -7.4 | -7.4 | -7.4 | -7.4 |
| Total Cash | 13,739.0 | 10,612.0 | 11,472.0 | 9,146.0 | 5,963.0 | 10,617.8 | 11,463.0 | 12,375.5 | 13,360.7 | 14,424.2 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 1,333.0 | 3,939.0 | 6,076.0 | 7,650.0 | 485.0 | 4,596.3 | 4,962.2 | 5,357.2 | 5,783.7 | 6,244.1 |
| Account Receivables, % | 12.83 | 53.06 | 55.53 | 54.16 | 4.09 | 35.94 | 35.94 | 35.94 | 35.94 | 35.94 |
| Inventories | 1,812.0 | 1,580.0 | 1,478.0 | 1,531.0 | 1,047.0 | 1,839.6 | 1,986.1 | 2,144.2 | 2,314.9 | 2,499.1 |
| Inventories, % | 17.45 | 21.29 | 13.51 | 10.84 | 8.84 | 14.38 | 14.38 | 14.38 | 14.38 | 14.38 |
| Accounts Payable | 945.0 | 738.0 | 805.0 | 870.0 | 830.0 | 1,012.0 | 1,092.6 | 1,179.6 | 1,273.5 | 1,374.8 |
| Accounts Payable, % | 9.1 | 9.94 | 7.36 | 6.16 | 7.01 | 7.91 | 7.91 | 7.91 | 7.91 | 7.91 |
| Capital Expenditure | -250.0 | -199.0 | -305.0 | -338.0 | -303.0 | -328.1 | -354.2 | -382.4 | -412.8 | -445.7 |
| Capital Expenditure, % | -2.41 | -2.68 | -2.79 | -2.39 | -2.56 | -2.57 | -2.57 | -2.57 | -2.57 | -2.57 |
| Tax Rate, % | 25.81 | 25.81 | 25.81 | 25.81 | 25.81 | 25.81 | 25.81 | 25.81 | 25.81 | 25.81 |
| EBITAT | -1,147.0 | -1,810.9 | 76.1 | -683.3 | -273.0 | -674.7 | -728.4 | -786.3 | -848.9 | -916.5 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -3,147.0 | -4,140.9 | -1,679.9 | -2,074.3 | 7,551.0 | -5,133.9 | -876.5 | -946.3 | -1,021.6 | -1,102.9 |
| WACC, % | 7.72 | 7.49 | 7.02 | 2.51 | 6.37 | 6.22 | 6.22 | 6.22 | 6.22 | 6.22 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -8,017.8 | |||||||||
| Long Term Growth Rate, % | 3.00 | |||||||||
| Free cash flow (T + 1) | -1,136 | |||||||||
| Terminal Value | -35,272 | |||||||||
| Present Terminal Value | -26,085 | |||||||||
| Enterprise Value | -34,103 | |||||||||
| Net Debt | 4,256 | |||||||||
| Equity Value | -38,359 | |||||||||
| Diluted Shares Outstanding, MM | 382 | |||||||||
| Equity Value Per Share | -100.42 |
What You Will Get
- Real IEP Financial Data: Pre-filled with Icahn Enterprises’ historical and projected data for precise analysis.
- Fully Editable Template: Modify key inputs like revenue growth, WACC, and EBITDA % with ease.
- Automatic Calculations: See IEP’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
- Comprehensive DCF Calculator: Offers both unlevered and levered DCF valuation models tailored for Icahn Enterprises L.P. (IEP).
- WACC Calculator: Features a pre-designed Weighted Average Cost of Capital sheet with adjustable parameters.
- Customizable Forecast Assumptions: Easily change growth rates, capital expenditures, and discount rates as needed.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios specific to Icahn Enterprises L.P. (IEP).
- Visual Dashboard and Charts: Graphical representations that summarize essential valuation metrics for straightforward analysis.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review Icahn Enterprises L.P.'s (IEP) pre-filled financial data and forecasts.
- Step 3: Modify key inputs such as revenue growth, WACC, and tax rates (highlighted cells).
- Step 4: Observe the DCF model update in real-time as you adjust your assumptions.
- Step 5: Analyze the outputs and leverage the results for your investment decisions.
Why Choose Icahn Enterprises L.P. (IEP)?
- Save Time: Get instant access to essential financial insights without building complex models.
- Enhance Accuracy: Utilize dependable data and methodologies to minimize valuation errors.
- Completely Customizable: Adjust the framework to fit your specific assumptions and forecasts.
- User-Friendly: Intuitive visuals and outputs facilitate straightforward analysis of results.
- Endorsed by Professionals: Crafted for those who prioritize accuracy and ease of use in their financial evaluations.
Who Should Use This Product?
- Investors: Evaluate Icahn Enterprises L.P.'s (IEP) market position before making investment decisions.
- CFOs and Financial Analysts: Enhance valuation methodologies and assess financial forecasts for IEP.
- Startup Founders: Discover the valuation strategies of established firms like Icahn Enterprises L.P. (IEP).
- Consultants: Provide expert valuation analyses and reports for clients interested in IEP.
- Students and Educators: Utilize real-time data from Icahn Enterprises L.P. (IEP) to teach and practice valuation skills.
What the Template Contains
- Pre-Filled DCF Model: Icahn Enterprises L.P. (IEP)’s financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
- Financial Ratios: Evaluate Icahn Enterprises L.P. (IEP)’s profitability, leverage, and efficiency.
- Editable Inputs: Change assumptions such as growth, margins, and CAPEX to fit your scenarios.
- Financial Statements: Annual and quarterly reports to support detailed analysis.
- Interactive Dashboard: Easily visualize key valuation metrics and results.