Icahn Enterprises L.P. (IEP) DCF Valuation
- ✓ Totalmente Editável: Adapte-Se Às Suas Necessidades No Excel Ou Planilhas
- ✓ Design Profissional: Modelos Confiáveis E Padrão Da Indústria
- ✓ Pré-Construídos Para Uso Rápido E Eficiente
- ✓ Não É Necessária Experiência; Fácil De Seguir
Icahn Enterprises L.P. (IEP) Bundle
Looking to assess the intrinsic value of Icahn Enterprises L.P.? Our (IEP) DCF Calculator integrates real-world data with extensive customization options, enabling you to adjust forecasts and enhance your investment choices.
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.