Huntsman Corporation (HUN) DCF Valuation
- ✓ Fully Editable: Tailor To Your Needs In Excel Or Sheets
- ✓ Professional Design: Trusted, Industry-Standard Templates
- ✓ Pre-Built For Quick And Efficient Use
- ✓ No Expertise Is Needed; Easy To Follow
Huntsman Corporation (HUN) Bundle
Evaluate Huntsman Corporation's (HUN) financial outlook like an expert! This (HUN) DCF Calculator comes with pre-filled financial data and offers complete flexibility to modify revenue growth, WACC, margins, and other crucial assumptions to align with your predictions.
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,797.0 | 6,018.0 | 8,453.0 | 8,023.0 | 6,111.0 | 6,112.3 | 6,113.5 | 6,114.8 | 6,116.0 | 6,117.3 |
| Revenue Growth, % | 0 | -11.46 | 40.46 | -5.09 | -23.83 | 0.02064325 | 0.02064325 | 0.02064325 | 0.02064325 | 0.02064325 |
| EBITDA | 827.0 | 560.0 | 1,648.0 | 1,095.0 | 442.0 | 756.1 | 756.2 | 756.4 | 756.6 | 756.7 |
| EBITDA, % | 12.17 | 9.31 | 19.5 | 13.65 | 7.23 | 12.37 | 12.37 | 12.37 | 12.37 | 12.37 |
| Depreciation | 325.0 | 346.0 | 335.0 | 336.0 | 278.0 | 284.0 | 284.0 | 284.1 | 284.2 | 284.2 |
| Depreciation, % | 4.78 | 5.75 | 3.96 | 4.19 | 4.55 | 4.65 | 4.65 | 4.65 | 4.65 | 4.65 |
| EBIT | 502.0 | 214.0 | 1,313.0 | 759.0 | 164.0 | 472.1 | 472.2 | 472.3 | 472.4 | 472.5 |
| EBIT, % | 7.39 | 3.56 | 15.53 | 9.46 | 2.68 | 7.72 | 7.72 | 7.72 | 7.72 | 7.72 |
| Total Cash | 525.0 | 1,593.0 | 1,041.0 | 654.0 | 540.0 | 776.2 | 776.4 | 776.6 | 776.7 | 776.9 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 953.0 | 910.0 | 1,015.0 | 834.0 | 753.0 | 780.7 | 780.9 | 781.1 | 781.2 | 781.4 |
| Account Receivables, % | 14.02 | 15.12 | 12.01 | 10.4 | 12.32 | 12.77 | 12.77 | 12.77 | 12.77 | 12.77 |
| Inventories | 914.0 | 848.0 | 1,201.0 | 995.0 | 867.0 | 835.4 | 835.5 | 835.7 | 835.9 | 836.1 |
| Inventories, % | 13.45 | 14.09 | 14.21 | 12.4 | 14.19 | 13.67 | 13.67 | 13.67 | 13.67 | 13.67 |
| Accounts Payable | 822.0 | 876.0 | 1,114.0 | 961.0 | 719.0 | 777.1 | 777.3 | 777.5 | 777.6 | 777.8 |
| Accounts Payable, % | 12.09 | 14.56 | 13.18 | 11.98 | 11.77 | 12.71 | 12.71 | 12.71 | 12.71 | 12.71 |
| Capital Expenditure | -274.0 | -249.0 | -342.0 | -272.0 | -230.0 | -236.8 | -236.8 | -236.9 | -236.9 | -237.0 |
| Capital Expenditure, % | -4.03 | -4.14 | -4.05 | -3.39 | -3.76 | -3.87 | -3.87 | -3.87 | -3.87 | -3.87 |
| Tax Rate, % | -2.02 | -2.02 | -2.02 | -2.02 | -2.02 | -2.02 | -2.02 | -2.02 | -2.02 | -2.02 |
| EBITAT | 550.8 | 184.8 | 1,045.0 | 500.9 | 167.3 | 407.8 | 407.9 | 408.0 | 408.1 | 408.2 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -443.2 | 444.8 | 818.0 | 798.9 | 182.3 | 517.1 | 455.0 | 455.1 | 455.2 | 455.2 |
| WACC, % | 7.39 | 7.15 | 7.03 | 6.79 | 7.39 | 7.15 | 7.15 | 7.15 | 7.15 | 7.15 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 1,916.5 | |||||||||
| Long Term Growth Rate, % | 3.50 | |||||||||
| Free cash flow (T + 1) | 471 | |||||||||
| Terminal Value | 12,921 | |||||||||
| Present Terminal Value | 9,150 | |||||||||
| Enterprise Value | 11,067 | |||||||||
| Net Debt | 1,528 | |||||||||
| Equity Value | 9,539 | |||||||||
| Diluted Shares Outstanding, MM | 177 | |||||||||
| Equity Value Per Share | 53.77 |
What You Will Get
- Pre-Filled Financial Model: Huntsman Corporation’s actual data enables precise DCF valuation.
- Full Forecast Control: Adjust revenue growth, margins, WACC, and other key drivers.
- Instant Calculations: Automatic updates ensure you see results as you make changes.
- Investor-Ready Template: A refined Excel file designed for professional-grade valuation.
- Customizable and Reusable: Tailored for flexibility, allowing repeated use for detailed forecasts.
Key Features
- Comprehensive DCF Calculator: Offers detailed unlevered and levered DCF valuation models tailored for Huntsman Corporation (HUN).
- WACC Calculator: Pre-configured Weighted Average Cost of Capital sheet with adjustable inputs specific to Huntsman Corporation (HUN).
- Customizable Forecast Assumptions: Alter growth rates, capital expenditures, and discount rates to fit Huntsman Corporation (HUN) projections.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios relevant to Huntsman Corporation (HUN).
- Interactive Dashboard and Charts: Visual representations summarize essential valuation metrics for straightforward analysis of Huntsman Corporation (HUN).
How It Works
- Download the Template: Gain immediate access to the Excel-based HUN DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and additional factors.
- Instant Calculations: The model automatically recalculates Huntsman Corporation’s intrinsic value.
- Test Scenarios: Experiment with various assumptions to assess potential changes in valuation.
- Analyze and Decide: Leverage the results to inform your investment or financial decisions.
Why Choose This Calculator for Huntsman Corporation (HUN)?
- Accurate Data: Utilize real Huntsman financials for dependable valuation outcomes.
- Customizable: Modify essential parameters like growth rates, WACC, and tax rates to align with your forecasts.
- Time-Saving: Pre-configured calculations save you the hassle of building from the ground up.
- Professional-Grade Tool: Tailored for investors, analysts, and consultants focusing on Huntsman Corporation.
- User-Friendly: Easy-to-navigate design and clear instructions cater to users of all experience levels.
Who Should Use Huntsman Corporation (HUN)?
- Investors: Gain insights and make informed decisions with Huntsman Corporation's robust market performance.
- Financial Analysts: Utilize comprehensive data and reports to enhance your analysis of Huntsman Corporation (HUN).
- Consultants: Leverage Huntsman Corporation's information for tailored client recommendations and presentations.
- Industry Enthusiasts: Explore Huntsman Corporation's innovations and strategies to broaden your industry knowledge.
- Educators and Students: Incorporate Huntsman Corporation (HUN) case studies into finance and business curricula for practical learning.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Huntsman Corporation (HUN) 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 Huntsman Corporation (HUN).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions for easy result analysis.