Ardagh Metal Packaging S.A. (AMBP) 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
Ardagh Metal Packaging S.A. (AMBP) Bundle
Evaluate Ardagh Metal Packaging S.A.'s financial outlook with expertise! This (AMBP) DCF Calculator provides pre-filled financial data and total flexibility to modify revenue growth, WACC, profit margins, and other essential 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 | 3,344.0 | 3,451.0 | 4,055.0 | 4,689.0 | 4,812.0 | 5,280.7 | 5,795.0 | 6,359.5 | 6,978.9 | 7,658.6 |
| Revenue Growth, % | 0 | 3.2 | 17.5 | 15.64 | 2.62 | 9.74 | 9.74 | 9.74 | 9.74 | 9.74 |
| EBITDA | 499.0 | 542.0 | 281.0 | 747.0 | 508.0 | 676.4 | 742.3 | 814.6 | 893.9 | 981.0 |
| EBITDA, % | 14.92 | 15.71 | 6.93 | 15.93 | 10.56 | 12.81 | 12.81 | 12.81 | 12.81 | 12.81 |
| Depreciation | 290.0 | 315.0 | 343.0 | 359.0 | 418.0 | 449.9 | 493.8 | 541.8 | 594.6 | 652.5 |
| Depreciation, % | 8.67 | 9.13 | 8.46 | 7.66 | 8.69 | 8.52 | 8.52 | 8.52 | 8.52 | 8.52 |
| EBIT | 209.0 | 227.0 | -62.0 | 388.0 | 90.0 | 226.5 | 248.5 | 272.7 | 299.3 | 328.5 |
| EBIT, % | 6.25 | 6.58 | -1.53 | 8.27 | 1.87 | 4.29 | 4.29 | 4.29 | 4.29 | 4.29 |
| Total Cash | 284.0 | 254.0 | 460.0 | 550.0 | 434.0 | 506.4 | 555.7 | 609.8 | 669.2 | 734.4 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 318.0 | 507.0 | 694.0 | 748.0 | 582.0 | 732.6 | 803.9 | 882.2 | 968.1 | 1,062.4 |
| Account Receivables, % | 9.51 | 14.69 | 17.11 | 15.95 | 12.09 | 13.87 | 13.87 | 13.87 | 13.87 | 13.87 |
| Inventories | 268.0 | 250.0 | 407.0 | 567.0 | 469.0 | 497.8 | 546.3 | 599.5 | 657.9 | 722.0 |
| Inventories, % | 8.01 | 7.24 | 10.04 | 12.09 | 9.75 | 9.43 | 9.43 | 9.43 | 9.43 | 9.43 |
| Accounts Payable | 619.0 | 646.0 | 1,006.0 | 1,060.0 | 1,091.0 | 1,133.4 | 1,243.8 | 1,365.0 | 1,497.9 | 1,643.8 |
| Accounts Payable, % | 18.51 | 18.72 | 24.81 | 22.61 | 22.67 | 21.46 | 21.46 | 21.46 | 21.46 | 21.46 |
| Capital Expenditure | -205.0 | -268.0 | -687.0 | -596.0 | -379.0 | -543.1 | -596.0 | -654.1 | -717.8 | -787.7 |
| Capital Expenditure, % | -6.13 | -7.77 | -16.94 | -12.71 | -7.88 | -10.29 | -10.29 | -10.29 | -10.29 | -10.29 |
| Tax Rate, % | 29.58 | 29.58 | 29.58 | 29.58 | 29.58 | 29.58 | 29.58 | 29.58 | 29.58 | 29.58 |
| EBITAT | 557.3 | 180.0 | -69.3 | 359.2 | 63.4 | 200.3 | 219.8 | 241.3 | 264.8 | 290.5 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 675.3 | 83.0 | -397.3 | -37.8 | 397.4 | -29.8 | 108.1 | 118.7 | 130.2 | 142.9 |
| WACC, % | 5.39 | 4.77 | 5.39 | 5.17 | 4.5 | 5.04 | 5.04 | 5.04 | 5.04 | 5.04 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 390.8 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 146 | |||||||||
| Terminal Value | 4,792 | |||||||||
| Present Terminal Value | 3,747 | |||||||||
| Enterprise Value | 4,138 | |||||||||
| Net Debt | 3,300 | |||||||||
| Equity Value | 838 | |||||||||
| Diluted Shares Outstanding, MM | 598 | |||||||||
| Equity Value Per Share | 1.40 |
What You Will Get
- Real Ardagh Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures for Ardagh Metal Packaging S.A. (AMBP).
- Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates specific to Ardagh.
- Instant Valuation Updates: Automatic recalculations to analyze the impact of changes on Ardagh's fair value.
- Versatile Excel Template: Tailored for quick edits, scenario testing, and detailed projections relevant to Ardagh Metal Packaging S.A. (AMBP).
- Time-Saving and Accurate: Skip building models from scratch while maintaining precision and flexibility for Ardagh.
Key Features
- Comprehensive DCF Calculator: Offers detailed unlevered and levered DCF valuation models tailored for Ardagh Metal Packaging S.A. (AMBP).
- WACC Calculator: Features a pre-built Weighted Average Cost of Capital sheet with adjustable inputs for accurate assessments.
- Customizable Forecast Assumptions: Easily adjust growth rates, capital expenditures, and discount rates to fit your analysis needs.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios specifically for Ardagh Metal Packaging S.A. (AMBP).
- Interactive Dashboard and Charts: Visual representations summarize essential valuation metrics for straightforward analysis.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review Ardagh Metal Packaging's pre-filled financial data and forecasts.
- Step 3: Modify key inputs such as revenue growth, WACC, and tax rates (highlighted cells).
- Step 4: Observe the DCF model update in real-time as you adjust assumptions.
- Step 5: Analyze the outputs and leverage the results for investment decisions.
Why Choose This Calculator for Ardagh Metal Packaging (AMBP)?
- Accurate Data: Utilize real Ardagh Metal Packaging financials for trustworthy valuation outcomes.
- Customizable: Modify essential parameters such as growth rates, WACC, and tax rates to align with your forecasts.
- Time-Saving: Pre-configured calculations streamline the process, so you don’t have to start from the ground up.
- Professional-Grade Tool: Tailored for investors, analysts, and consultants in the packaging industry.
- User-Friendly: Simple design and clear step-by-step guidance ensure accessibility for all users.
Who Should Use This Product?
- Professional Investors: Develop comprehensive and accurate valuation models for portfolio assessment related to Ardagh Metal Packaging S.A. (AMBP).
- Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within the organization.
- Consultants and Advisors: Deliver precise valuation insights for clients interested in Ardagh Metal Packaging S.A. (AMBP).
- Students and Educators: Utilize real-time data to enhance learning and practice in financial modeling.
- Industry Analysts: Gain insights into how metal packaging companies like Ardagh are valued in the marketplace.
What the Template Contains
- Pre-Filled Data: Includes Ardagh Metal Packaging’s historical financials and forecasts.
- Discounted Cash Flow Model: Editable DCF valuation model with automatic calculations.
- Weighted Average Cost of Capital (WACC): A dedicated sheet for calculating WACC based on custom inputs.
- Key Financial Ratios: Analyze Ardagh Metal Packaging’s profitability, efficiency, and leverage.
- Customizable Inputs: Edit revenue growth, margins, and tax rates with ease.
- Clear Dashboard: Charts and tables summarizing key valuation results.