AZZ Inc. (AZZ) DCF Valuation

AZZ Inc. (AZZ) 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

AZZ Inc. (AZZ) 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:

Explore AZZ Inc.'s (AZZ) financial future with our user-friendly DCF Calculator! Enter your assumptions regarding growth, margins, and costs to calculate AZZ Inc.'s (AZZ) intrinsic value and enhance your investment strategy.


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 1,061.8 838.9 902.7 1,323.6 1,537.6 1,727.5 1,940.9 2,180.6 2,450.0 2,752.6
Revenue Growth, % 0 -20.99 7.6 46.64 16.16 12.35 12.35 12.35 12.35 12.35
EBITDA 128.5 105.2 111.5 252.1 316.6 264.8 297.5 334.2 375.5 421.9
EBITDA, % 12.11 12.55 12.35 19.04 20.59 15.33 15.33 15.33 15.33 15.33
Depreciation 50.2 44.6 32.1 74.6 79.4 84.3 94.7 106.4 119.6 134.3
Depreciation, % 4.73 5.32 3.55 5.64 5.17 4.88 4.88 4.88 4.88 4.88
EBIT 78.4 60.6 79.4 177.5 237.2 180.5 202.8 227.8 256.0 287.6
EBIT, % 7.38 7.23 8.8 13.41 15.42 10.45 10.45 10.45 10.45 10.45
Total Cash 36.7 14.8 15.1 2.8 4.3 25.5 28.7 32.2 36.2 40.7
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 209.3 190.1 88.0 262.7 237.2
Account Receivables, % 19.71 22.66 9.75 19.85 15.43
Inventories 99.8 92.9 126.1 143.9 117.7 183.0 205.6 231.0 259.6 291.6
Inventories, % 9.4 11.08 13.97 10.87 7.65 10.59 10.59 10.59 10.59 10.59
Accounts Payable 62.0 41.5 24.8 109.9 88.0 95.2 107.0 120.2 135.1 151.7
Accounts Payable, % 5.84 4.95 2.75 8.3 5.72 5.51 5.51 5.51 5.51 5.51
Capital Expenditure -35.0 -37.1 -28.4 -57.1 -95.1 -73.8 -82.9 -93.2 -104.7 -117.6
Capital Expenditure, % -3.3 -4.42 -3.15 -4.32 -6.19 -4.27 -4.27 -4.27 -4.27 -4.27
Tax Rate, % 21.9 21.9 21.9 21.9 21.9 21.9 21.9 21.9 21.9 21.9
EBITAT 58.2 47.1 62.7 132.8 185.2 138.6 155.7 174.9 196.5 220.8
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF -173.8 60.3 118.7 42.7 199.4 26.2 119.3 134.1 150.6 169.2
WACC, % 9.63 9.75 9.8 9.65 9.76 9.72 9.72 9.72 9.72 9.72
PV UFCF
SUM PV UFCF 434.8
Long Term Growth Rate, % 3.00
Free cash flow (T + 1) 174
Terminal Value 2,594
Present Terminal Value 1,632
Enterprise Value 2,066
Net Debt 973
Equity Value 1,093
Diluted Shares Outstanding, MM 25
Equity Value Per Share 43.38

What You Will Get

  • Editable Excel Template: A fully customizable Excel-based DCF Calculator featuring pre-filled real AZZ Inc. (AZZ) financials.
  • Real-World Data: Access to historical data and forward-looking estimates (highlighted in the yellow cells).
  • Forecast Flexibility: Adjust forecast assumptions such as revenue growth, EBITDA %, and WACC.
  • Automatic Calculations: Quickly observe the effects of your inputs on AZZ Inc.'s (AZZ) 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 AZZ Financials: Access reliable pre-loaded historical data and future forecasts for AZZ Inc. (AZZ).
  • Adjustable Forecast Assumptions: Modify highlighted cells for key variables like WACC, growth rates, and profit margins.
  • Real-Time Calculations: Automatic refresh of DCF, Net Present Value (NPV), and cash flow assessments.
  • User-Friendly Dashboard: Clear charts and summaries to help visualize your valuation outcomes.
  • Designed for All Skill Levels: An intuitive layout tailored for investors, CFOs, and consultants alike.

How It Works

  1. Step 1: Download the Excel file.
  2. Step 2: Review pre-entered AZZ Inc. (AZZ) data (historical and projected).
  3. Step 3: Adjust key assumptions (yellow cells) based on your analysis.
  4. Step 4: View automatic recalculations for AZZ Inc.'s intrinsic value.
  5. Step 5: Use the outputs for investment decisions or reporting.

Why Choose the AZZ Inc. (AZZ) Calculator?

  • Designed for Experts: A sophisticated tool tailored for analysts, CFOs, and financial consultants.
  • Accurate Data: AZZ Inc.’s historical and projected financials are preloaded for reliable analysis.
  • 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 ensures a smooth experience throughout the process.

Who Should Use AZZ Inc. (AZZ)?

  • Investors: Make informed investment choices with comprehensive insights into AZZ's performance.
  • Financial Analysts: Streamline your analysis with detailed reports and data on AZZ's financial health.
  • Consultants: Easily tailor presentations or reports featuring AZZ to meet client needs.
  • Finance Enthusiasts: Enhance your knowledge of market dynamics through AZZ's industry-specific case studies.
  • Educators and Students: Utilize AZZ as a case study for practical applications in finance education.

What the AZZ Template Contains

  • Historical Data: Contains AZZ Inc.'s past financial performance and foundational forecasts.
  • DCF and Levered DCF Models: Comprehensive templates for assessing AZZ's intrinsic value.
  • WACC Sheet: Pre-formulated calculations for Weighted Average Cost of Capital.
  • Editable Inputs: Adjust key variables such as growth rates, EBITDA %, and CAPEX projections.
  • Quarterly and Annual Statements: A thorough analysis of AZZ Inc.'s financial data.
  • Interactive Dashboard: Dynamically visualize valuation outcomes and forecasts.