American Axle & Manufacturing Holdings, Inc. (AXL) 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
American Axle & Manufacturing Holdings, Inc. (AXL) Bundle
Discover the true value of American Axle & Manufacturing Holdings, Inc. (AXL) with our professional-grade DCF Calculator! Adjust key assumptions, explore various scenarios, and evaluate how changes affect the valuation of American Axle & Manufacturing Holdings, Inc. (AXL) – all within a single Excel template.
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,530.9 | 4,710.8 | 5,156.6 | 5,802.4 | 6,079.5 | 6,062.7 | 6,045.9 | 6,029.2 | 6,012.5 | 5,995.9 |
| Revenue Growth, % | 0 | -27.87 | 9.46 | 12.52 | 4.78 | -0.27658 | -0.27658 | -0.27658 | -0.27658 | -0.27658 |
| EBITDA | 227.6 | 109.7 | 839.2 | 732.9 | 668.0 | 554.2 | 552.7 | 551.1 | 549.6 | 548.1 |
| EBITDA, % | 3.48 | 2.33 | 16.27 | 12.63 | 10.99 | 9.14 | 9.14 | 9.14 | 9.14 | 9.14 |
| Depreciation | 536.9 | 521.9 | 544.3 | 492.1 | 487.2 | 562.0 | 560.5 | 558.9 | 557.4 | 555.8 |
| Depreciation, % | 8.22 | 11.08 | 10.56 | 8.48 | 8.01 | 9.27 | 9.27 | 9.27 | 9.27 | 9.27 |
| EBIT | -309.3 | -412.2 | 294.9 | 240.8 | 180.8 | -7.8 | -7.8 | -7.8 | -7.7 | -7.7 |
| EBIT, % | -4.74 | -8.75 | 5.72 | 4.15 | 2.97 | -0.12865 | -0.12865 | -0.12865 | -0.12865 | -0.12865 |
| Total Cash | 532.0 | 557.0 | 530.2 | 511.5 | 519.9 | 577.4 | 575.8 | 574.2 | 572.6 | 571.0 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 815.4 | 793.2 | 762.8 | 820.2 | 818.5 | 869.6 | 867.2 | 864.8 | 862.4 | 860.0 |
| Account Receivables, % | 12.49 | 16.84 | 14.79 | 14.14 | 13.46 | 14.34 | 14.34 | 14.34 | 14.34 | 14.34 |
| Inventories | 373.6 | 323.2 | 410.4 | 463.9 | 482.9 | 442.3 | 441.1 | 439.9 | 438.7 | 437.4 |
| Inventories, % | 5.72 | 6.86 | 7.96 | 7.99 | 7.94 | 7.3 | 7.3 | 7.3 | 7.3 | 7.3 |
| Accounts Payable | 623.5 | 578.9 | 612.8 | 734.0 | 773.9 | 716.6 | 714.6 | 712.6 | 710.7 | 708.7 |
| Accounts Payable, % | 9.55 | 12.29 | 11.88 | 12.65 | 12.73 | 11.82 | 11.82 | 11.82 | 11.82 | 11.82 |
| Capital Expenditure | -433.3 | -215.7 | -181.2 | -171.4 | -194.6 | -253.2 | -252.5 | -251.8 | -251.1 | -250.4 |
| Capital Expenditure, % | -6.63 | -4.58 | -3.51 | -2.95 | -3.2 | -4.18 | -4.18 | -4.18 | -4.18 | -4.18 |
| Tax Rate, % | -37.14 | -37.14 | -37.14 | -37.14 | -37.14 | -37.14 | -37.14 | -37.14 | -37.14 | -37.14 |
| EBITAT | -280.9 | -379.0 | 1,449.9 | 233.5 | 248.0 | -7.5 | -7.5 | -7.4 | -7.4 | -7.4 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -742.8 | -44.8 | 1,790.1 | 564.5 | 563.2 | 233.5 | 302.1 | 301.3 | 300.5 | 299.6 |
| WACC, % | 7.54 | 7.6 | 8.04 | 7.88 | 8.04 | 7.82 | 7.82 | 7.82 | 7.82 | 7.82 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 1,144.9 | |||||||||
| Long Term Growth Rate, % | 3.50 | |||||||||
| Free cash flow (T + 1) | 310 | |||||||||
| Terminal Value | 7,181 | |||||||||
| Present Terminal Value | 4,929 | |||||||||
| Enterprise Value | 6,073 | |||||||||
| Net Debt | 2,465 | |||||||||
| Equity Value | 3,609 | |||||||||
| Diluted Shares Outstanding, MM | 117 | |||||||||
| Equity Value Per Share | 30.95 |
What You Will Get
- Real AXL Financial Data: Pre-filled with American Axle & Manufacturing's historical and projected data for precise analysis.
- Fully Editable Template: Modify key inputs like revenue growth, WACC, and EBITDA % with ease.
- Automatic Calculations: See AXL's intrinsic value update instantly based on your changes.
- Professional Valuation Tool: Designed for investors, analysts, and consultants seeking accurate DCF results.
- User-Friendly Design: Simple structure and clear instructions for all experience levels.
Key Features
- Comprehensive DCF Calculator: Features detailed unlevered and levered DCF valuation models tailored for American Axle & Manufacturing Holdings, Inc. (AXL).
- WACC Calculator: Comes with a pre-built Weighted Average Cost of Capital sheet that allows for customizable inputs specific to AXL.
- Adjustable Forecast Assumptions: Easily modify growth rates, capital expenditures, and discount rates to fit AXL's financial outlook.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios specifically for American Axle & Manufacturing Holdings, Inc. (AXL).
- Visual Dashboard and Charts: Provides visual summaries of key valuation metrics for straightforward analysis of AXL.
How It Works
- 1. Open the Template: Download and open the Excel file containing American Axle & Manufacturing Holdings, Inc.'s preloaded data.
- 2. Edit Assumptions: Modify key inputs such as growth rates, WACC, and capital expenditures for [AXL].
- 3. View Results Instantly: The DCF model automatically calculates intrinsic value and NPV for [AXL].
- 4. Test Scenarios: Evaluate various forecasts to assess different valuation outcomes for [AXL].
- 5. Use with Confidence: Deliver professional valuation insights to back your decisions regarding [AXL].
Why Choose This Calculator for American Axle & Manufacturing Holdings, Inc. (AXL)?
- Designed for Industry Experts: A sophisticated tool utilized by financial analysts, CFOs, and industry consultants.
- Comprehensive Data: Historical and projected financials for American Axle preloaded to ensure precision.
- Flexible Scenario Analysis: Effortlessly simulate various forecasts and assumptions.
- Intuitive Outputs: Automatically computes intrinsic value, NPV, and essential financial metrics.
- User-Friendly Interface: Step-by-step guidance simplifies the calculation process.
Who Should Use This Product?
- Investors: Evaluate American Axle’s valuation prior to making investment decisions.
- CFOs and Financial Analysts: Enhance valuation methodologies and validate financial forecasts.
- Startup Founders: Understand the valuation processes of established companies like American Axle.
- Consultants: Provide detailed valuation analyses and reports for clients.
- Students and Educators: Utilize real-world examples to learn and teach valuation strategies.
What the Template Contains
- Comprehensive DCF Model: Editable template featuring detailed valuation calculations.
- Real-World Data: American Axle & Manufacturing's (AXL) historical and projected financials preloaded for analysis.
- Customizable Parameters: Modify WACC, growth rates, and tax assumptions to explore different 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 designed for clear, actionable results.