Air Products and Chemicals, Inc. (APD) DCF Valuation

Air Products and Chemicals, Inc. (APD) 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

Air Products and Chemicals, Inc. (APD) Bundle

DCF model
Get Full Bundle:
$25 $15
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7

TOTAL:

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
Account Receivables, % 19.85 19.4 15.29 18.45 17.92
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.

No products were found matching.