|
BorgWarner Inc. (BWA) DCF Valuation
US | Consumer Cyclical | Auto - Parts | 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
BorgWarner Inc. (BWA) Bundle
Gain mastery over your BorgWarner Inc. (BWA) valuation analysis using our state-of-the-art DCF Calculator! Loaded with authentic (BWA) data, this Excel template lets you adjust forecasts and assumptions to accurately determine BorgWarner Inc.'s intrinsic value.
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,168.0 | 10,165.0 | 14,838.0 | 15,801.0 | 14,198.0 | 15,699.0 | 17,358.6 | 19,193.8 | 21,222.9 | 23,466.5 |
| Revenue Growth, % | 0 | -0.02950433 | 45.97 | 6.49 | -10.14 | 10.57 | 10.57 | 10.57 | 10.57 | 10.57 |
| EBITDA | 1,642.0 | 1,585.0 | 1,688.0 | 1,635.0 | 1,671.0 | 2,048.2 | 2,264.8 | 2,504.2 | 2,768.9 | 3,061.6 |
| EBITDA, % | 16.15 | 15.59 | 11.38 | 10.35 | 11.77 | 13.05 | 13.05 | 13.05 | 13.05 | 13.05 |
| Depreciation | 439.0 | 530.0 | 772.0 | 552.0 | 582.0 | 701.0 | 775.1 | 857.1 | 947.7 | 1,047.9 |
| Depreciation, % | 4.32 | 5.21 | 5.2 | 3.49 | 4.1 | 4.47 | 4.47 | 4.47 | 4.47 | 4.47 |
| EBIT | 1,203.0 | 1,055.0 | 916.0 | 1,083.0 | 1,089.0 | 1,347.2 | 1,489.6 | 1,647.1 | 1,821.2 | 2,013.8 |
| EBIT, % | 11.83 | 10.38 | 6.17 | 6.85 | 7.67 | 8.58 | 8.58 | 8.58 | 8.58 | 8.58 |
| Total Cash | 832.0 | 1,650.0 | 1,841.0 | 1,338.0 | 1,534.0 | 1,761.2 | 1,947.4 | 2,153.3 | 2,381.0 | 2,632.7 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 1,931.0 | 2,935.0 | 2,915.0 | 2,485.0 | 3,127.0 | 3,305.0 | 3,654.4 | 4,040.7 | 4,467.9 | 4,940.2 |
| Account Receivables, % | 18.99 | 28.87 | 19.65 | 15.73 | 22.02 | 21.05 | 21.05 | 21.05 | 21.05 | 21.05 |
| Inventories | 807.0 | 1,286.0 | 1,534.0 | 1,687.0 | 1,313.0 | 1,596.6 | 1,765.4 | 1,952.0 | 2,158.4 | 2,386.6 |
| Inventories, % | 7.94 | 12.65 | 10.34 | 10.68 | 9.25 | 10.17 | 10.17 | 10.17 | 10.17 | 10.17 |
| Accounts Payable | 1,289.0 | 2,272.0 | 2,239.0 | 2,146.0 | 2,546.0 | 2,563.1 | 2,834.0 | 3,133.6 | 3,464.9 | 3,831.2 |
| Accounts Payable, % | 12.68 | 22.35 | 15.09 | 13.58 | 17.93 | 16.33 | 16.33 | 16.33 | 16.33 | 16.33 |
| Capital Expenditure | -481.0 | -501.0 | -668.0 | -723.0 | -832.0 | -772.3 | -853.9 | -944.2 | -1,044.0 | -1,154.4 |
| Capital Expenditure, % | -4.73 | -4.93 | -4.5 | -4.58 | -5.86 | -4.92 | -4.92 | -4.92 | -4.92 | -4.92 |
| Tax Rate, % | 36.93 | 36.93 | 36.93 | 36.93 | 36.93 | 36.93 | 36.93 | 36.93 | 36.93 | 36.93 |
| EBITAT | 709.4 | 547.2 | 623.4 | 775.7 | 686.8 | 844.9 | 934.3 | 1,033.0 | 1,142.3 | 1,263.0 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -781.6 | 76.2 | 466.4 | 788.7 | 568.8 | 329.1 | 608.2 | 672.5 | 743.6 | 822.3 |
| WACC, % | 7.51 | 7.4 | 7.64 | 7.7 | 7.57 | 7.56 | 7.56 | 7.56 | 7.56 | 7.56 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 2,498.8 | |||||||||
| Long Term Growth Rate, % | 3.00 | |||||||||
| Free cash flow (T + 1) | 847 | |||||||||
| Terminal Value | 18,561 | |||||||||
| Present Terminal Value | 12,891 | |||||||||
| Enterprise Value | 15,390 | |||||||||
| Net Debt | 2,395 | |||||||||
| Equity Value | 12,995 | |||||||||
| Diluted Shares Outstanding, MM | 234 | |||||||||
| Equity Value Per Share | 55.44 |
What You Will Get
- Real BorgWarner 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 BorgWarner’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
- 🔍 Real-Life BWA Financials: Pre-filled historical and projected data for BorgWarner Inc.
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate BorgWarner’s intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize BorgWarner’s valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- Download the Template: Gain immediate access to the Excel-based BWA DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and other key factors.
- Instant Calculations: The model automatically recalculates BorgWarner’s intrinsic value.
- Test Scenarios: Experiment with various assumptions to assess potential valuation shifts.
- Analyze and Decide: Leverage the results to inform your investment or financial analysis.
Why Choose the BorgWarner Calculator?
- Precision: Utilizes authentic BorgWarner financials for reliable data.
- Adaptability: Built for users to easily experiment with and adjust inputs.
- Efficiency: Avoid the complexities of constructing a DCF model from the ground up.
- Expert-Level: Crafted with the accuracy and functionality expected by CFOs.
- Intuitive: Simple to navigate, suitable for those without extensive financial modeling skills.
Who Should Use BorgWarner Inc. (BWA) Products?
- Automotive Manufacturers: Enhance vehicle performance with cutting-edge powertrain solutions.
- Engineers: Leverage advanced technologies to design efficient and innovative automotive systems.
- Supply Chain Managers: Streamline operations with BorgWarner’s reliable and high-quality components.
- Environmental Advocates: Support sustainability initiatives with eco-friendly automotive technologies.
- Students and Educators: Utilize BorgWarner's innovations as case studies in engineering and automotive courses.
What the Template Contains
- Comprehensive DCF Model: Editable template featuring in-depth valuation calculations.
- Real-World Data: BorgWarner Inc.'s (BWA) historical and projected financials preloaded for analysis.
- Customizable Parameters: Adjust WACC, growth rates, and tax assumptions to explore various scenarios.
- Financial Statements: Complete annual and quarterly breakdowns for enhanced insights.
- Key Ratios: Integrated analysis for profitability, efficiency, and leverage metrics.
- Dashboard with Visual Outputs: Charts and tables to present clear, actionable results.