|
Peabody Energy Corporation (BTU) DCF Valuation
US | Energy | Coal | NYSE
|
- ✓ 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
Peabody Energy Corporation (BTU) Bundle
Whether you’re an investor or analyst, this BTU DCF Calculator is your go-to resource for accurate valuation. Preloaded with Peabody Energy Corporation’s real data, you can adjust forecasts and observe the effects in real-time.
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 | 4,623.4 | 2,881.1 | 3,318.3 | 4,981.9 | 4,946.7 | 5,279.6 | 5,634.9 | 6,014.1 | 6,418.8 | 6,850.7 |
| Revenue Growth, % | 0 | -37.68 | 15.17 | 50.13 | -0.70656 | 6.73 | 6.73 | 6.73 | 6.73 | 6.73 |
| EBITDA | 661.1 | -1,366.0 | 907.0 | 1,785.9 | 1,506.0 | 639.0 | 682.0 | 727.8 | 776.8 | 829.1 |
| EBITDA, % | 14.3 | -47.41 | 27.33 | 35.85 | 30.44 | 12.1 | 12.1 | 12.1 | 12.1 | 12.1 |
| Depreciation | 659.4 | 391.7 | 353.4 | 367.0 | 321.4 | 553.0 | 590.2 | 629.9 | 672.3 | 717.6 |
| Depreciation, % | 14.26 | 13.6 | 10.65 | 7.37 | 6.5 | 10.47 | 10.47 | 10.47 | 10.47 | 10.47 |
| EBIT | 1.7 | -1,757.7 | 553.6 | 1,418.9 | 1,184.6 | 86.0 | 91.7 | 97.9 | 104.5 | 111.5 |
| EBIT, % | 0.03676948 | -61.01 | 16.68 | 28.48 | 23.95 | 1.63 | 1.63 | 1.63 | 1.63 | 1.63 |
| Total Cash | 732.2 | 709.2 | 954.3 | 1,307.3 | 969.3 | 1,214.8 | 1,296.6 | 1,383.8 | 1,476.9 | 1,576.3 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 329.5 | 244.8 | 350.5 | 465.5 | 389.7 | 458.4 | 489.2 | 522.1 | 557.3 | 594.8 |
| Account Receivables, % | 7.13 | 8.5 | 10.56 | 9.34 | 7.88 | 8.68 | 8.68 | 8.68 | 8.68 | 8.68 |
| Inventories | 331.5 | 261.6 | 226.7 | 296.1 | 351.8 | 381.6 | 407.3 | 434.7 | 463.9 | 495.1 |
| Inventories, % | 7.17 | 9.08 | 6.83 | 5.94 | 7.11 | 7.23 | 7.23 | 7.23 | 7.23 | 7.23 |
| Accounts Payable | 254.8 | 146.3 | 201.7 | 240.7 | 275.8 | 285.9 | 305.1 | 325.7 | 347.6 | 371.0 |
| Accounts Payable, % | 5.51 | 5.08 | 6.08 | 4.83 | 5.58 | 5.41 | 5.41 | 5.41 | 5.41 | 5.41 |
| Capital Expenditure | -285.3 | -197.5 | -183.1 | -224.2 | -348.3 | -317.7 | -339.1 | -361.9 | -386.2 | -412.2 |
| Capital Expenditure, % | -6.17 | -6.86 | -5.52 | -4.5 | -7.04 | -6.02 | -6.02 | -6.02 | -6.02 | -6.02 |
| Tax Rate, % | 32.47 | 32.47 | 32.47 | 32.47 | 32.47 | 32.47 | 32.47 | 32.47 | 32.47 | 32.47 |
| EBITAT | 2.2 | -1,765.3 | 538.5 | 1,439.4 | 800.0 | 79.9 | 85.3 | 91.0 | 97.1 | 103.7 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -29.9 | -1,525.0 | 693.4 | 1,436.8 | 828.3 | 226.9 | 299.2 | 319.3 | 340.8 | 363.7 |
| WACC, % | 9.75 | 9.75 | 9.71 | 9.75 | 9.2 | 9.63 | 9.63 | 9.63 | 9.63 | 9.63 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 1,163.7 | |||||||||
| Long Term Growth Rate, % | 0.50 | |||||||||
| Free cash flow (T + 1) | 366 | |||||||||
| Terminal Value | 4,003 | |||||||||
| Present Terminal Value | 2,527 | |||||||||
| Enterprise Value | 3,691 | |||||||||
| Net Debt | -570 | |||||||||
| Equity Value | 4,261 | |||||||||
| Diluted Shares Outstanding, MM | 154 | |||||||||
| Equity Value Per Share | 27.62 |
What You Will Get
- Editable Excel Template: A fully customizable Excel-based DCF Calculator featuring pre-filled real BTU financials.
- Real-World Data: Historical data and projected estimates (as indicated in the highlighted cells).
- Forecast Flexibility: Adjust forecast parameters such as revenue growth, EBITDA %, and WACC.
- Automatic Calculations: Instantly observe how your inputs affect Peabody Energy's valuation.
- Professional Tool: Designed for investors, CFOs, consultants, and financial analysts.
- User-Friendly Design: Organized for clarity and simplicity, complete with step-by-step guidance.
Key Features
- Comprehensive Peabody Financials: Access reliable pre-loaded historical data and future projections for Peabody Energy Corporation (BTU).
- Customizable Forecast Assumptions: Modify highlighted cells such as WACC, growth rates, and profit margins to suit your analysis.
- Dynamic Calculations: Automatic updates for DCF, Net Present Value (NPV), and cash flow assessments.
- Visual Dashboard: User-friendly charts and summaries to effectively visualize your valuation outcomes.
- For Professionals and Beginners: A straightforward, intuitive layout designed for investors, CFOs, and consultants alike.
How It Works
- Download: Obtain the pre-formatted Excel file featuring Peabody Energy Corporation’s (BTU) financial data.
- Customize: Modify projections, including revenue growth, EBITDA %, and WACC.
- Update Automatically: The intrinsic value and NPV calculations refresh in real-time.
- Test Scenarios: Generate various forecasts and instantly compare the results.
- Make Decisions: Leverage the valuation outcomes to inform your investment approach.
Why Choose Peabody Energy's Calculator?
- Save Time: Skip the hassle of building a DCF model from the ground up – it’s ready for immediate use.
- Improve Accuracy: Dependable financial data and formulas minimize valuation errors.
- Fully Customizable: Adjust the model to align with your specific assumptions and forecasts.
- Easy to Interpret: Intuitive charts and outputs simplify the analysis of results.
- Trusted by Experts: Crafted for professionals who prioritize accuracy and ease of use.
Who Should Use This Product?
- Investors: Make informed decisions with a comprehensive analysis tool for Peabody Energy Corporation (BTU).
- Financial Analysts: Streamline your workflow with a customizable financial model tailored for Peabody Energy Corporation (BTU).
- Consultants: Effortlessly modify the template for client pitches or reports related to Peabody Energy Corporation (BTU).
- Energy Sector Enthusiasts: Enhance your grasp of industry valuation methods through practical examples from Peabody Energy Corporation (BTU).
- Educators and Students: Utilize it as a hands-on learning resource in energy finance courses.
What the Template Contains
- Historical Data: Includes Peabody Energy Corporation’s past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate Peabody Energy Corporation’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 Peabody Energy Corporation’s financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically.