Air Products and Chemicals, Inc. (APD) 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
Air Products and Chemicals, Inc. (APD) Bundle
Whether you’re an investor or analyst, this (APD) DCF Calculator is your go-to resource for accurate valuation. Equipped with real data from Air Products and Chemicals, Inc., you can adjust forecasts and immediately observe the effects.
Discounted Cash Flow (DCF) - (USD MM)
| Year | AY1 2020 |
AY2 2021 |
AY3 2022 |
AY4 2023 |
AY5 2024 |
FY1 2025 |
FY2 2026 |
FY3 2027 |
FY4 2028 |
FY5 2029 |
|---|---|---|---|---|---|---|---|---|---|---|
| Revenue | 8,856.3 | 10,323.0 | 12,698.6 | 12,600.0 | 12,100.6 | 13,154.4 | 14,299.9 | 15,545.2 | 16,899.0 | 18,370.6 |
| Revenue Growth, % | 0 | 16.56 | 23.01 | -0.77646 | -3.96 | 8.71 | 8.71 | 8.71 | 8.71 | 8.71 |
| EBITDA | 3,433.7 | 3,672.9 | 3,796.6 | 4,010.8 | 6,491.1 | 4,991.4 | 5,426.1 | 5,898.6 | 6,412.3 | 6,970.7 |
| EBITDA, % | 38.77 | 35.58 | 29.9 | 31.83 | 53.64 | 37.94 | 37.94 | 37.94 | 37.94 | 37.94 |
| Depreciation | 1,185.0 | 1,321.3 | 1,338.2 | 1,358.3 | 1,451.1 | 1,565.1 | 1,701.4 | 1,849.6 | 2,010.6 | 2,185.7 |
| Depreciation, % | 13.38 | 12.8 | 10.54 | 10.78 | 11.99 | 11.9 | 11.9 | 11.9 | 11.9 | 11.9 |
| EBIT | 2,248.7 | 2,351.6 | 2,458.4 | 2,652.5 | 5,040.0 | 3,426.3 | 3,724.6 | 4,049.0 | 4,401.6 | 4,784.9 |
| EBIT, % | 25.39 | 22.78 | 19.36 | 21.05 | 41.65 | 26.05 | 26.05 | 26.05 | 26.05 | 26.05 |
| Total Cash | 6,357.9 | 5,800.8 | 3,301.7 | 1,949.2 | 2,984.7 | 5,107.0 | 5,551.8 | 6,035.2 | 6,560.8 | 7,132.2 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 1,757.7 | 2,002.2 | 1,941.2 | 2,325.2 | 2,168.2 | 2,391.5 | 2,599.8 | 2,826.2 | 3,072.3 | 3,339.8 |
| Account Receivables, % | 19.85 | 19.4 | 15.29 | 18.45 | 17.92 | 18.18 | 18.18 | 18.18 | 18.18 | 18.18 |
| Inventories | 404.8 | 453.9 | 514.2 | 651.8 | 766.0 | 645.1 | 701.3 | 762.3 | 828.7 | 900.9 |
| Inventories, % | 4.57 | 4.4 | 4.05 | 5.17 | 6.33 | 4.9 | 4.9 | 4.9 | 4.9 | 4.9 |
| Accounts Payable | 546.2 | 736.8 | 1,120.7 | 1,212.9 | 1,451.6 | 1,151.1 | 1,251.3 | 1,360.3 | 1,478.7 | 1,607.5 |
| Accounts Payable, % | 6.17 | 7.14 | 8.83 | 9.63 | 12 | 8.75 | 8.75 | 8.75 | 8.75 | 8.75 |
| Capital Expenditure | -2,509.0 | -2,464.2 | -2,926.5 | -4,626.4 | .0 | -2,945.6 | -3,202.2 | -3,481.0 | -3,784.2 | -4,113.7 |
| Capital Expenditure, % | -28.33 | -23.87 | -23.05 | -36.72 | 0 | -22.39 | -22.39 | -22.39 | -22.39 | -22.39 |
| Tax Rate, % | 20.6 | 20.6 | 20.6 | 20.6 | 20.6 | 20.6 | 20.6 | 20.6 | 20.6 | 20.6 |
| EBITAT | 1,750.4 | 1,968.7 | 2,013.4 | 2,116.7 | 4,001.9 | 2,759.3 | 2,999.5 | 3,260.8 | 3,544.7 | 3,853.4 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -1,189.9 | 722.8 | 809.7 | -1,580.8 | 5,734.5 | 975.8 | 1,334.6 | 1,450.8 | 1,577.2 | 1,714.5 |
| WACC, % | 7.45 | 7.49 | 7.48 | 7.46 | 7.46 | 7.47 | 7.47 | 7.47 | 7.47 | 7.47 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 5,610.9 | |||||||||
| Long Term Growth Rate, % | 4.00 | |||||||||
| Free cash flow (T + 1) | 1,783 | |||||||||
| Terminal Value | 51,422 | |||||||||
| Present Terminal Value | 35,873 | |||||||||
| Enterprise Value | 41,484 | |||||||||
| Net Debt | 11,822 | |||||||||
| Equity Value | 29,662 | |||||||||
| Diluted Shares Outstanding, MM | 223 | |||||||||
| Equity Value Per Share | 133.13 |
What You Will Get
- Pre-Filled Financial Model: Air Products and Chemicals, Inc. (APD)’s actual data enables precise DCF valuation.
- Full Forecast Control: Adjust revenue growth, margins, WACC, and other key drivers specific to Air Products and Chemicals, Inc. (APD).
- Instant Calculations: Automatic updates ensure you see results as you make changes in real-time.
- Investor-Ready Template: A refined Excel file designed for professional-grade valuation of Air Products and Chemicals, Inc. (APD).
- Customizable and Reusable: Tailored for flexibility, allowing repeated use for detailed forecasts on Air Products and Chemicals, Inc. (APD).
Key Features
- Comprehensive DCF Calculator: Features detailed unlevered and levered DCF valuation models tailored for Air Products and Chemicals, Inc. (APD).
- WACC Calculator: Pre-configured Weighted Average Cost of Capital sheet with adjustable inputs specific to the needs of Air Products and Chemicals, Inc. (APD).
- Customizable Forecast Assumptions: Adjust growth rates, capital expenditures, and discount rates to fit Air Products and Chemicals, Inc. (APD).
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios relevant to Air Products and Chemicals, Inc. (APD).
- Interactive Dashboard and Charts: Visual representations summarize essential valuation metrics for straightforward analysis of Air Products and Chemicals, Inc. (APD).
How It Works
- 1. Access the Template: Download and open the Excel file featuring Air Products and Chemicals, Inc. (APD)’s preloaded data.
- 2. Modify Assumptions: Adjust key inputs such as growth rates, WACC, and capital expenditures.
- 3. Analyze Results Instantly: The DCF model automatically computes intrinsic value and NPV.
- 4. Explore Scenarios: Evaluate multiple forecasts to examine various valuation outcomes.
- 5. Present with Assurance: Share professional valuation insights to back your decisions.
Why Choose This Calculator for Air Products and Chemicals, Inc. (APD)?
- Designed for Experts: A sophisticated tool tailored for analysts, CFOs, and industry consultants.
- Accurate Data: Historical and projected financials for Air Products preloaded to ensure precision.
- Flexible Scenario Analysis: Effortlessly simulate various forecasts and assumptions.
- Comprehensive Outputs: Automatically computes intrinsic value, NPV, and essential metrics.
- User-Friendly: Step-by-step guidance makes the process straightforward and intuitive.
Who Should Use This Product?
- Individual Investors: Make informed decisions about buying or selling Air Products and Chemicals, Inc. (APD) stock.
- Financial Analysts: Streamline valuation processes with ready-to-use financial models for Air Products and Chemicals, Inc. (APD).
- Consultants: Deliver professional valuation insights to clients quickly and accurately using data from Air Products and Chemicals, Inc. (APD).
- Business Owners: Understand how large companies like Air Products and Chemicals, Inc. (APD) are valued to guide your own strategy.
- Finance Students: Learn valuation techniques using real-world data and scenarios related to Air Products and Chemicals, Inc. (APD).
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Air Products and Chemicals, Inc. (APD) historical data and forecasts, including revenue, EBITDA, EBIT, and capital expenditures.
- WACC Calculation: A dedicated sheet for Weighted Average Cost of Capital (WACC), including parameters like Beta, risk-free rate, and share price.
- DCF Valuation (Unlevered and Levered): Editable Discounted Cash Flow models showing intrinsic value with detailed calculations.
- Financial Statements: Pre-loaded financial statements (annual and quarterly) to support analysis.
- Key Ratios: Includes profitability, leverage, and efficiency ratios for Air Products and Chemicals, Inc. (APD).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.