AptarGroup, Inc. (ATR) DCF Valuation
- ✓ Entièrement Modifiable: Adapté À Vos Besoins Dans Excel Ou Sheets
- ✓ Conception Professionnelle: Modèles Fiables Et Conformes Aux Normes Du Secteur
- ✓ Pré-Construits Pour Une Utilisation Rapide Et Efficace
- ✓ Aucune Expertise N'Est Requise; Facile À Suivre
AptarGroup, Inc. (ATR) Bundle
Gain mastery over your AptarGroup, Inc. (ATR) valuation analysis using our sophisticated DCF Calculator! Equipped with real-time ATR data, this Excel template enables you to adjust forecasts and assumptions, allowing you to accurately determine the intrinsic value of AptarGroup, Inc. (ATR).
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 | 2,859.7 | 2,929.3 | 3,227.2 | 3,322.2 | 3,487.5 | 3,666.4 | 3,854.4 | 4,052.2 | 4,260.1 | 4,478.6 |
| Revenue Growth, % | 0 | 2.43 | 10.17 | 2.94 | 4.97 | 5.13 | 5.13 | 5.13 | 5.13 | 5.13 |
| EBITDA | 576.9 | 556.2 | 586.8 | 609.4 | 663.8 | 694.6 | 730.2 | 767.7 | 807.0 | 848.4 |
| EBITDA, % | 20.17 | 18.99 | 18.18 | 18.34 | 19.03 | 18.94 | 18.94 | 18.94 | 18.94 | 18.94 |
| Depreciation | 194.6 | 220.3 | 234.9 | 233.7 | 248.6 | 262.2 | 275.7 | 289.8 | 304.7 | 320.3 |
| Depreciation, % | 6.8 | 7.52 | 7.28 | 7.03 | 7.13 | 7.15 | 7.15 | 7.15 | 7.15 | 7.15 |
| EBIT | 382.4 | 335.9 | 351.9 | 375.7 | 415.2 | 432.3 | 454.5 | 477.8 | 502.3 | 528.1 |
| EBIT, % | 13.37 | 11.47 | 10.91 | 11.31 | 11.91 | 11.79 | 11.79 | 11.79 | 11.79 | 11.79 |
| Total Cash | 242.0 | 300.4 | 123.7 | 141.7 | 223.6 | 243.6 | 256.1 | 269.3 | 283.1 | 297.6 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 558.4 | 566.6 | 671.4 | 693.7 | 695.9 | 737.0 | 774.8 | 814.5 | 856.3 | 900.3 |
| Account Receivables, % | 19.53 | 19.34 | 20.8 | 20.88 | 19.95 | 20.1 | 20.1 | 20.1 | 20.1 | 20.1 |
| Inventories | 375.8 | 379.4 | 441.5 | 486.8 | 513.1 | 507.0 | 533.0 | 560.3 | 589.0 | 619.3 |
| Inventories, % | 13.14 | 12.95 | 13.68 | 14.65 | 14.71 | 13.83 | 13.83 | 13.83 | 13.83 | 13.83 |
| Accounts Payable | 192.7 | 243.7 | 285.3 | 320.3 | 328.6 | 315.0 | 331.2 | 348.2 | 366.0 | 384.8 |
| Accounts Payable, % | 6.74 | 8.32 | 8.84 | 9.64 | 9.42 | 8.59 | 8.59 | 8.59 | 8.59 | 8.59 |
| Capital Expenditure | -247.1 | -252.0 | -307.9 | -315.6 | -318.4 | -333.0 | -350.1 | -368.1 | -386.9 | -406.8 |
| Capital Expenditure, % | -8.64 | -8.6 | -9.54 | -9.5 | -9.13 | -9.08 | -9.08 | -9.08 | -9.08 | -9.08 |
| Tax Rate, % | 24.1 | 24.1 | 24.1 | 24.1 | 24.1 | 24.1 | 24.1 | 24.1 | 24.1 | 24.1 |
| EBITAT | 270.7 | 238.7 | 267.1 | 268.6 | 315.2 | 315.7 | 331.9 | 349.0 | 366.9 | 385.7 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -523.3 | 246.2 | 68.7 | 154.0 | 225.3 | 196.4 | 209.9 | 220.6 | 231.9 | 243.8 |
| WACC, % | 6.73 | 6.73 | 6.75 | 6.73 | 6.75 | 6.74 | 6.74 | 6.74 | 6.74 | 6.74 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 904.3 | |||||||||
| Long Term Growth Rate, % | 3.50 | |||||||||
| Free cash flow (T + 1) | 252 | |||||||||
| Terminal Value | 7,799 | |||||||||
| Present Terminal Value | 5,630 | |||||||||
| Enterprise Value | 6,534 | |||||||||
| Net Debt | 961 | |||||||||
| Equity Value | 5,573 | |||||||||
| Diluted Shares Outstanding, MM | 67 | |||||||||
| Equity Value Per Share | 83.30 |
What You Will Get
- Editable Excel Template: A fully customizable Excel-based DCF Calculator featuring pre-filled real ATR financials.
- Real-World Data: Historical data and forward-looking estimates (as shown in the yellow cells).
- Forecast Flexibility: Adjust forecast assumptions such as revenue growth, EBITDA %, and WACC.
- Automatic Calculations: Instantly observe the effect of your inputs on AptarGroup’s valuation.
- Professional Tool: Designed for investors, CFOs, consultants, and financial analysts.
- User-Friendly Design: Organized for clarity and ease of use, complete with step-by-step instructions.
Key Features
- Comprehensive DCF Calculator: Offers detailed unlevered and levered DCF valuation frameworks.
- WACC Calculator: Features a pre-configured Weighted Average Cost of Capital sheet with adjustable parameters.
- Customizable Forecast Assumptions: Tailor growth projections, capital expenditures, and discount rates.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios for AptarGroup, Inc. (ATR).
- Interactive Dashboard and Charts: Visual representations summarize essential valuation metrics for streamlined analysis.
How It Works
- Step 1: Download the Excel file for AptarGroup, Inc. (ATR).
- Step 2: Review AptarGroup’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 your investment strategies.
Why Choose This Calculator for AptarGroup, Inc. (ATR)?
- Designed for Experts: A sophisticated tool utilized by financial analysts, CFOs, and industry consultants.
- Accurate Data: AptarGroup’s historical and projected financials are preloaded for precise calculations.
- Flexible Scenario Analysis: Effortlessly simulate various forecasts and assumptions.
- Comprehensive Outputs: Instantly calculates intrinsic value, NPV, and essential financial metrics.
- User-Friendly: Step-by-step guidance makes the process straightforward and accessible.
Who Should Use This Product?
- Finance Students: Master valuation techniques and apply them using real data from AptarGroup, Inc. (ATR).
- Academics: Integrate professional models into your coursework or research focused on AptarGroup, Inc. (ATR).
- Investors: Evaluate your own assumptions and analyze valuation outcomes for AptarGroup, Inc. (ATR) stock.
- Analysts: Enhance your workflow with a pre-built, customizable DCF model tailored for AptarGroup, Inc. (ATR).
- Small Business Owners: Understand the analytical methods used for large public companies like AptarGroup, Inc. (ATR).
What the Template Contains
- Preloaded ATR 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.