|
James Hardie Industries plc (JHX) DCF Valuation
IE | Basic Materials | Construction Materials | NYSE
|
- ✓ 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
James Hardie Industries plc (JHX) Bundle
Evaluate the financial outlook of James Hardie Industries plc like an expert! This (JHX) DCF Calculator provides pre-filled financial data along with the flexibility to modify revenue growth, WACC, margins, and other essential assumptions to align with your projections.
Discounted Cash Flow (DCF) - (USD MM)
| Year | AY1 2020 |
AY2 2021 |
AY3 2022 |
AY4 2023 |
AY5 2024 |
FY1 2025 |
FY2 2026 |
FY3 2027 |
FY4 2028 |
FY5 2029 |
|---|---|---|---|---|---|---|---|---|---|---|
| Revenue | 2,606.8 | 2,908.7 | 3,614.7 | 3,777.1 | 3,936.3 | 4,374.8 | 4,862.2 | 5,403.8 | 6,005.8 | 6,674.9 |
| Revenue Growth, % | 0 | 11.58 | 24.27 | 4.49 | 4.21 | 11.14 | 11.14 | 11.14 | 11.14 | 11.14 |
| EBITDA | 473.7 | 594.8 | 844.2 | 934.2 | 976.1 | 975.6 | 1,084.3 | 1,205.1 | 1,339.4 | 1,488.6 |
| EBITDA, % | 18.17 | 20.45 | 23.35 | 24.73 | 24.8 | 22.3 | 22.3 | 22.3 | 22.3 | 22.3 |
| Depreciation | 128.4 | 133.0 | 161.5 | 172.8 | 185.0 | 203.4 | 226.0 | 251.2 | 279.2 | 310.3 |
| Depreciation, % | 4.93 | 4.57 | 4.47 | 4.58 | 4.7 | 4.65 | 4.65 | 4.65 | 4.65 | 4.65 |
| EBIT | 345.3 | 461.8 | 682.7 | 761.4 | 791.1 | 772.3 | 858.3 | 953.9 | 1,060.2 | 1,178.3 |
| EBIT, % | 13.25 | 15.88 | 18.89 | 20.16 | 20.1 | 17.65 | 17.65 | 17.65 | 17.65 | 17.65 |
| Total Cash | 207.4 | 208.5 | 125.0 | 113.0 | 365.0 | 269.9 | 300.0 | 333.4 | 370.5 | 411.8 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 368.3 | 339.8 | 373.9 | 336.8 | 371.2 | 476.9 | 530.0 | 589.0 | 654.7 | 727.6 |
| Account Receivables, % | 14.13 | 11.68 | 10.34 | 8.92 | 9.43 | 10.9 | 10.9 | 10.9 | 10.9 | 10.9 |
| Inventories | 305.1 | 218.3 | 279.7 | 344.2 | 337.8 | 390.6 | 434.1 | 482.5 | 536.2 | 596.0 |
| Inventories, % | 11.7 | 7.51 | 7.74 | 9.11 | 8.58 | 8.93 | 8.93 | 8.93 | 8.93 | 8.93 |
| Accounts Payable | 151.3 | 174.0 | 273.6 | 198.2 | 252.0 | 271.3 | 301.5 | 335.1 | 372.4 | 413.9 |
| Accounts Payable, % | 5.8 | 5.98 | 7.57 | 5.25 | 6.4 | 6.2 | 6.2 | 6.2 | 6.2 | 6.2 |
| Capital Expenditure | -203.3 | -120.2 | -259.7 | -599.8 | -449.3 | -406.1 | -451.3 | -501.6 | -557.5 | -619.6 |
| Capital Expenditure, % | -7.8 | -4.13 | -7.18 | -15.88 | -11.41 | -9.28 | -9.28 | -9.28 | -9.28 | -9.28 |
| Tax Rate, % | 32.41 | 32.41 | 32.41 | 32.41 | 32.41 | 32.41 | 32.41 | 32.41 | 32.41 | 32.41 |
| EBITAT | 289.5 | 294.5 | 487.3 | 538.8 | 534.7 | 552.0 | 613.5 | 681.8 | 757.8 | 842.2 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -307.5 | 445.4 | 393.3 | 9.1 | 296.2 | 210.1 | 321.8 | 357.6 | 397.5 | 441.8 |
| WACC, % | 9.45 | 9.38 | 9.41 | 9.41 | 9.39 | 9.41 | 9.41 | 9.41 | 9.41 | 9.41 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 1,293.2 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 451 | |||||||||
| Terminal Value | 6,083 | |||||||||
| Present Terminal Value | 3,880 | |||||||||
| Enterprise Value | 5,174 | |||||||||
| Net Debt | 836 | |||||||||
| Equity Value | 4,338 | |||||||||
| Diluted Shares Outstanding, MM | 440 | |||||||||
| Equity Value Per Share | 9.87 |
What You Will Get
- Editable Excel Template: A fully customizable Excel-based DCF Calculator featuring pre-filled real JHX financials.
- Real-World Data: Historical data and forward-looking estimates (as indicated in the yellow cells).
- Forecast Flexibility: Adjust forecast assumptions such as revenue growth, EBITDA %, and WACC.
- Automatic Calculations: Instantly observe the impact of your inputs on James Hardie’s valuation.
- Professional Tool: Designed for investors, CFOs, consultants, and financial analysts.
- User-Friendly Design: Organized for clarity and ease of use, complete with step-by-step instructions.
Key Features
- Comprehensive JHX Data: Pre-loaded with James Hardie’s historical performance metrics and future projections.
- Flexible Input Options: Modify revenue growth rates, profit margins, discount rates, tax implications, and capital investments.
- Interactive Valuation Model: Instant updates to Net Present Value (NPV) and intrinsic value reflecting your customized inputs.
- Scenario Analysis: Develop various forecasting scenarios to explore different valuation possibilities.
- Intuitive Interface: Streamlined, organized, and accessible for both seasoned professionals and newcomers.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review James Hardie Industries plc’s pre-filled financial data and forecasts.
- Step 3: Modify critical inputs like revenue growth, WACC, and tax rates (highlighted cells).
- Step 4: Watch the DCF model update instantly as you tweak assumptions.
- Step 5: Analyze the outputs and use the results for investment decisions.
Why Choose This Calculator for James Hardie Industries (JHX)?
- User-Friendly Interface: Ideal for both novices and seasoned professionals.
- Customizable Inputs: Adjust parameters effortlessly to suit your analysis needs.
- Real-Time Feedback: Observe immediate changes in James Hardie’s valuation as you tweak inputs.
- Preloaded Data: Comes with James Hardie’s actual financial figures for swift evaluations.
- Relied Upon by Experts: Favored by investors and analysts for making well-informed choices.
Who Should Use This Product?
- Individual Investors: Gain insights to make informed decisions on buying or selling James Hardie Industries plc (JHX) stock.
- Financial Analysts: Enhance valuation processes with comprehensive financial models tailored for James Hardie Industries plc (JHX).
- Consultants: Provide clients with accurate and timely valuation insights regarding James Hardie Industries plc (JHX).
- Business Owners: Learn how companies like James Hardie Industries plc (JHX) are valued to inform your own business strategies.
- Finance Students: Explore valuation methodologies using real-world data from James Hardie Industries plc (JHX).
What the Template Contains
- Historical Data: Includes James Hardie’s past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate James Hardie’s intrinsic value.
- WACC Sheet: Pre-built calculations for Weighted Average Cost of Capital.
- Editable Inputs: Modify key drivers like growth rates, EBITDA %, and CAPEX assumptions.
- Quarterly and Annual Statements: A complete breakdown of James Hardie’s financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically.