Babcock & Wilcox Enterprises, Inc. (BW) 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
Babcock & Wilcox Enterprises, Inc. (BW) Bundle
Evaluate Babcock & Wilcox Enterprises, Inc.'s financial outlook like an expert! This (BW) DCF Calculator provides pre-filled financial data and allows you to easily modify revenue growth, WACC, profit margins, and other critical assumptions to align with your projections.
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 | 859.1 | 566.3 | 723.4 | 889.8 | 999.4 | 1,071.7 | 1,149.4 | 1,232.6 | 1,321.9 | 1,417.7 |
| Revenue Growth, % | 0 | -34.08 | 27.74 | 23 | 12.31 | 7.24 | 7.24 | 7.24 | 7.24 | 7.24 |
| EBITDA | 26.1 | 77.4 | 91.2 | 57.6 | -.3 | 76.7 | 82.2 | 88.2 | 94.6 | 101.4 |
| EBITDA, % | 3.04 | 13.68 | 12.61 | 6.47 | -0.02671726 | 7.15 | 7.15 | 7.15 | 7.15 | 7.15 |
| Depreciation | 29.0 | 21.6 | 22.5 | 21.6 | 21.0 | 31.8 | 34.1 | 36.5 | 39.2 | 42.0 |
| Depreciation, % | 3.37 | 3.81 | 3.11 | 2.43 | 2.1 | 2.96 | 2.96 | 2.96 | 2.96 | 2.96 |
| EBIT | -2.9 | 55.9 | 68.7 | 35.9 | -21.3 | 44.9 | 48.1 | 51.6 | 55.4 | 59.4 |
| EBIT, % | -0.33302 | 9.87 | 9.5 | 4.04 | -2.13 | 4.19 | 4.19 | 4.19 | 4.19 | 4.19 |
| Total Cash | 43.8 | 57.3 | 224.9 | 76.7 | 71.0 | 133.0 | 142.6 | 152.9 | 164.0 | 175.9 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 233.8 | 187.6 | 212.2 | 276.5 | 270.2 | 316.8 | 339.8 | 364.4 | 390.8 | 419.1 |
| Account Receivables, % | 27.21 | 33.13 | 29.34 | 31.08 | 27.04 | 29.56 | 29.56 | 29.56 | 29.56 | 29.56 |
| Inventories | 63.1 | 67.2 | 79.5 | 102.6 | 113.9 | 113.9 | 122.1 | 131.0 | 140.5 | 150.6 |
| Inventories, % | 7.34 | 11.87 | 10.99 | 11.53 | 11.4 | 10.63 | 10.63 | 10.63 | 10.63 | 10.63 |
| Accounts Payable | 109.9 | 73.5 | 85.9 | 131.2 | 127.5 | 139.7 | 149.8 | 160.6 | 172.3 | 184.7 |
| Accounts Payable, % | 12.79 | 12.98 | 11.88 | 14.75 | 12.76 | 13.03 | 13.03 | 13.03 | 13.03 | 13.03 |
| Capital Expenditure | -3.8 | -8.2 | -6.7 | -13.2 | -9.8 | -11.3 | -12.1 | -13.0 | -14.0 | -15.0 |
| Capital Expenditure, % | -0.44232 | -1.45 | -0.92618 | -1.48 | -0.98063 | -1.06 | -1.06 | -1.06 | -1.06 | -1.06 |
| Tax Rate, % | -181.12 | -181.12 | -181.12 | -181.12 | -181.12 | -181.12 | -181.12 | -181.12 | -181.12 | -181.12 |
| EBITAT | -3.0 | 173.4 | 72.4 | 61.7 | -59.8 | 44.9 | 48.1 | 51.6 | 55.4 | 59.4 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -164.8 | 192.4 | 63.8 | 28.0 | -57.3 | 30.9 | 49.0 | 52.5 | 56.3 | 60.4 |
| WACC, % | 11.74 | 11.74 | 11.74 | 11.74 | 11.74 | 11.74 | 11.74 | 11.74 | 11.74 | 11.74 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 175.4 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 62 | |||||||||
| Terminal Value | 633 | |||||||||
| Present Terminal Value | 364 | |||||||||
| Enterprise Value | 539 | |||||||||
| Net Debt | 365 | |||||||||
| Equity Value | 174 | |||||||||
| Diluted Shares Outstanding, MM | 89 | |||||||||
| Equity Value Per Share | 1.95 |
What You Will Get
- Real Babcock & Wilcox Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures.
- Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- Instant Valuation Updates: Automatic recalculations to analyze the impact of changes on Babcock & Wilcox's fair value.
- Versatile Excel Template: Tailored for quick edits, scenario testing, and detailed projections.
- Time-Saving and Accurate: Skip building models from scratch while maintaining precision and flexibility.
Key Features
- Customizable Forecast Inputs: Adjust essential metrics such as revenue growth, operating margins, and capital investments.
- Instant DCF Valuation: Provides immediate calculations for intrinsic value, NPV, and other financial metrics.
- High-Precision Accuracy: Leverages Babcock & Wilcox's real-world financial data for dependable valuation results.
- Effortless Scenario Analysis: Evaluate various assumptions and analyze outcomes with ease.
- Efficiency Booster: Remove the hassle of constructing intricate valuation models from the ground up.
How It Works
- Download the Template: Gain immediate access to the Excel-based BW DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and additional parameters.
- Instant Calculations: The model will automatically refresh Babcock & Wilcox's intrinsic value.
- Test Scenarios: Experiment with various assumptions to assess potential changes in valuation.
- Analyze and Decide: Utilize the results to inform your investment or financial analysis decisions.
Why Choose This Calculator for Babcock & Wilcox Enterprises, Inc. (BW)?
- Accuracy: Utilizes real Babcock & Wilcox financials to ensure precise data.
- Flexibility: Tailored for users to experiment with and adjust inputs as needed.
- Time-Saving: Avoid the complexities of creating a DCF model from the ground up.
- Professional-Grade: Crafted with the expertise and usability expected at the CFO level.
- User-Friendly: Intuitive design makes it accessible for users without advanced financial modeling skills.
Who Should Use This Product?
- Energy Sector Professionals: Develop comprehensive models for assessing energy project valuations.
- Corporate Finance Teams: Evaluate financial scenarios to inform strategic decisions within the energy sector.
- Consultants and Advisors: Deliver precise valuation assessments for Babcock & Wilcox Enterprises, Inc. (BW) to clients.
- Students and Educators: Utilize real-time data to enhance learning in financial modeling and energy economics.
- Industry Analysts: Gain insights into how companies like Babcock & Wilcox Enterprises, Inc. (BW) are valued in the energy market.
What the Template Contains
- Preloaded BW Data: Historical and projected financial data, including revenue, EBIT, and capital expenditures.
- DCF and WACC Models: Professional-grade sheets for calculating intrinsic value and Weighted Average Cost of Capital.
- Editable Inputs: Yellow-highlighted cells for adjusting revenue growth, tax rates, and discount rates.
- Financial Statements: Comprehensive annual and quarterly financials for deeper analysis.
- Key Ratios: Profitability, leverage, and efficiency ratios to evaluate performance.
- Dashboard and Charts: Visual summaries of valuation outcomes and assumptions.