|
A. O. Smith Corporation (AOS) DCF Valuation
US | Industrials | Industrial - Machinery | NYSE
|
- ✓ 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
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 | 731.5 | 782.1 | 836.2 | 894.1 | 956.0 |
Account Receivables, % | 19.7 | 20.21 | 17.93 | 15.48 | 15.47 | 17.76 | 17.76 | 17.76 | 17.76 | 17.76 |
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.