A. O. Smith Corporation (AOS) DCF Valuation

A. O. Smith Corporation (AOS) DCF Valuation

US | Industrials | Industrial - Machinery | NYSE
A. O. Smith Corporation (AOS) 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

A. O. Smith Corporation (AOS) Bundle

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

TOTAL:

Explore A. O. Smith Corporation's (AOS) financial outlook with our user-friendly DCF Calculator! Simply enter your growth, margin, and cost assumptions to calculate A. O. Smith Corporation's (AOS) intrinsic value and shape your investment approach.


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,992.7 2,895.3 3,538.9 3,753.9 3,852.8 4,119.5 4,404.6 4,709.4 5,035.4 5,383.9
Revenue Growth, % 0 -3.25 22.23 6.08 2.63 6.92 6.92 6.92 6.92 6.92
EBITDA 561.4 531.2 707.8 310.0 823.8 714.7 764.2 817.1 873.6 934.1
EBITDA, % 18.76 18.35 20 8.26 21.38 17.35 17.35 17.35 17.35 17.35
Depreciation 78.3 80.0 77.9 76.9 78.3 96.1 102.7 109.8 117.4 125.6
Depreciation, % 2.62 2.76 2.2 2.05 2.03 2.33 2.33 2.33 2.33 2.33
EBIT 483.1 451.2 629.9 233.1 745.5 618.6 661.4 707.2 756.2 808.5
EBIT, % 16.14 15.58 17.8 6.21 19.35 15.02 15.02 15.02 15.02 15.02
Total Cash 551.4 689.6 631.4 481.8 363.4 678.5 725.4 775.7 829.3 886.7
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 589.5 585.0 634.4 581.2 596.0
Account Receivables, % 19.7 20.21 17.93 15.48 15.47
Inventories 303.0 300.1 447.7 516.4 497.4 492.7 526.8 563.3 602.3 644.0
Inventories, % 10.12 10.37 12.65 13.76 12.91 11.96 11.96 11.96 11.96 11.96
Accounts Payable 509.6 595.2 745.9 625.8 600.4 749.1 800.9 856.3 915.6 979.0
Accounts Payable, % 17.03 20.56 21.08 16.67 15.58 18.18 18.18 18.18 18.18 18.18
Capital Expenditure -64.4 -56.8 -75.1 -70.3 -72.6 -82.3 -88.0 -94.1 -100.6 -107.6
Capital Expenditure, % -2.15 -1.96 -2.12 -1.87 -1.88 -2 -2 -2 -2 -2
Tax Rate, % 24.12 24.12 24.12 24.12 24.12 24.12 24.12 24.12 24.12 24.12
EBITAT 378.6 350.6 490.4 245.6 565.7 507.0 542.1 579.7 619.8 662.7
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF 9.6 466.8 446.9 116.6 550.2 538.6 523.9 560.2 599.0 640.4
WACC, % 9.91 9.91 9.91 9.93 9.91 9.91 9.91 9.91 9.91 9.91
PV UFCF
SUM PV UFCF 2,155.2
Long Term Growth Rate, % 4.00
Free cash flow (T + 1) 666
Terminal Value 11,262
Present Terminal Value 7,020
Enterprise Value 9,176
Net Debt -185
Equity Value 9,360
Diluted Shares Outstanding, MM 151
Equity Value Per Share 61.98

What You Will Receive

  • Customizable Excel Template: A fully adjustable Excel-based DCF Calculator featuring pre-filled real AOS financials.
  • Real-World Insights: Historical data and projected estimates (highlighted in the yellow cells).
  • Forecast Customization: Adjust forecast parameters such as revenue growth, EBITDA %, and WACC.
  • Instant Calculations: Quickly observe how your inputs affect A. O. Smith’s valuation.
  • Professional Resource: Designed for investors, CFOs, consultants, and financial analysts.
  • User-Friendly Interface: Organized for clarity and simplicity, complete with step-by-step guidance.

Key Features

  • Customizable Forecast Inputs: Adjust essential metrics such as revenue growth, operating margin, and capital investments.
  • Instant DCF Valuation: Automatically computes intrinsic value, NPV, and additional financial metrics without delay.
  • High-Precision Accuracy: Leverages A. O. Smith Corporation's (AOS) actual financial data for credible valuation results.
  • Effortless Scenario Testing: Easily explore various assumptions and analyze differing outcomes.
  • Efficiency Booster: Streamline the valuation process by avoiding the creation of intricate models from the ground up.

How It Works

  • Step 1: Download the prebuilt Excel template featuring A. O. Smith Corporation’s (AOS) data.
  • Step 2: Navigate through the pre-filled sheets to familiarize yourself with the essential metrics.
  • Step 3: Modify forecasts and assumptions in the editable yellow cells (WACC, growth, margins).
  • Step 4: Immediately view the updated results, including A. O. Smith Corporation’s (AOS) intrinsic value.
  • Step 5: Utilize the outputs to make informed investment choices or create detailed reports.

Why Choose A. O. Smith Corporation (AOS)?

  • Innovative Solutions: A. O. Smith (AOS) leads the industry with cutting-edge technology and products.
  • Proven Reliability: Our products are known for their durability and long-lasting performance.
  • Customer-Centric Approach: We prioritize customer satisfaction and tailor our services to meet your needs.
  • Expertise You Can Trust: Our team consists of industry veterans committed to delivering excellence.
  • Sustainable Practices: A. O. Smith (AOS) is dedicated to environmentally friendly manufacturing and operations.

Who Should Use This Product?

  • Professional Investors: Develop comprehensive and accurate valuation models for portfolio assessments related to A. O. Smith Corporation (AOS).
  • Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within the organization.
  • Consultants and Advisors: Offer clients precise valuation insights for A. O. Smith Corporation (AOS) stock.
  • Students and Educators: Utilize real-world data to enhance financial modeling skills and education.
  • Industry Analysts: Gain insights into how companies like A. O. Smith Corporation (AOS) are valued in the market.

What the Template Contains

  • Operating and Balance Sheet Data: Pre-filled A. O. Smith Corporation (AOS) 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 A. O. Smith Corporation (AOS).
  • Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.