|
Valoración de DCF de American Water Works Company, Inc. (AWK)
US | Utilities | Regulated Water | NYSE
|
- ✓ Completamente Editable: Adáptelo A Sus Necesidades En Excel O Sheets
- ✓ Diseño Profesional: Plantillas Confiables Y Estándares De La Industria
- ✓ Predeterminadas Para Un Uso Rápido Y Eficiente
- ✓ No Se Necesita Experiencia; Fáciles De Seguir
American Water Works Company, Inc. (AWK) Bundle
¡Ahorre tiempo y mejore la precisión con nuestra calculadora DCF (AWK)! Utilizando datos reales de American Water Works Company, Inc. y permitiendo supuestos personalizables, esta herramienta le permite pronosticar, analizar y valor (AWK) como un inversor experimentado.
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 | 3,610.0 | 3,777.0 | 3,930.0 | 3,792.0 | 4,234.0 | 4,412.1 | 4,597.6 | 4,790.9 | 4,992.4 | 5,202.4 |
Revenue Growth, % | 0 | 4.63 | 4.05 | -3.51 | 11.66 | 4.21 | 4.21 | 4.21 | 4.21 | 4.21 |
EBITDA | 1,812.0 | 1,901.0 | 1,910.0 | 1,999.0 | 2,360.0 | 2,272.9 | 2,368.5 | 2,468.1 | 2,571.9 | 2,680.1 |
EBITDA, % | 50.19 | 50.33 | 48.6 | 52.72 | 55.74 | 51.52 | 51.52 | 51.52 | 51.52 | 51.52 |
Depreciation | 582.0 | 604.0 | 636.0 | 649.0 | 704.0 | 723.9 | 754.4 | 786.1 | 819.1 | 853.6 |
Depreciation, % | 16.12 | 15.99 | 16.18 | 17.11 | 16.63 | 16.41 | 16.41 | 16.41 | 16.41 | 16.41 |
EBIT | 1,230.0 | 1,297.0 | 1,274.0 | 1,350.0 | 1,656.0 | 1,549.0 | 1,614.1 | 1,682.0 | 1,752.8 | 1,826.5 |
EBIT, % | 34.07 | 34.34 | 32.42 | 35.6 | 39.11 | 35.11 | 35.11 | 35.11 | 35.11 | 35.11 |
Total Cash | 60.0 | 547.0 | 116.0 | 85.0 | 330.0 | 257.1 | 267.9 | 279.1 | 290.9 | 303.1 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 466.0 | 527.0 | 568.0 | 609.0 | 727.5 | 657.9 | 685.6 | 714.4 | 744.4 | 775.7 |
Account Receivables, % | 12.91 | 13.95 | 14.45 | 16.06 | 17.18 | 14.91 | 14.91 | 14.91 | 14.91 | 14.91 |
Inventories | 44.0 | 47.0 | 57.0 | 98.0 | 112.0 | 80.7 | 84.1 | 87.6 | 91.3 | 95.1 |
Inventories, % | 1.22 | 1.24 | 1.45 | 2.58 | 2.65 | 1.83 | 1.83 | 1.83 | 1.83 | 1.83 |
Accounts Payable | 203.0 | 189.0 | 235.0 | 254.0 | 294.0 | 266.9 | 278.1 | 289.8 | 302.0 | 314.7 |
Accounts Payable, % | 5.62 | 5 | 5.98 | 6.7 | 6.94 | 6.05 | 6.05 | 6.05 | 6.05 | 6.05 |
Capital Expenditure | -1,758.0 | -1,928.0 | -1,873.0 | -2,420.0 | -2,734.0 | -2,433.6 | -2,536.0 | -2,642.6 | -2,753.8 | -2,869.6 |
Capital Expenditure, % | -48.7 | -51.05 | -47.66 | -63.82 | -64.57 | -55.16 | -55.16 | -55.16 | -55.16 | -55.16 |
Tax Rate, % | 21.07 | 21.07 | 21.07 | 21.07 | 21.07 | 21.07 | 21.07 | 21.07 | 21.07 | 21.07 |
EBITAT | 917.0 | 995.2 | 981.1 | 1,098.2 | 1,307.1 | 1,203.8 | 1,254.4 | 1,307.2 | 1,362.1 | 1,419.4 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -566.0 | -406.8 | -260.9 | -735.8 | -815.4 | -432.1 | -547.0 | -570.0 | -594.0 | -619.0 |
WACC, % | 6.24 | 6.27 | 6.28 | 6.34 | 6.31 | 6.29 | 6.29 | 6.29 | 6.29 | 6.29 |
PV UFCF | ||||||||||
SUM PV UFCF | -2,287.2 | |||||||||
Long Term Growth Rate, % | 4.00 | |||||||||
Free cash flow (T + 1) | -644 | |||||||||
Terminal Value | -28,131 | |||||||||
Present Terminal Value | -20,738 | |||||||||
Enterprise Value | -23,025 | |||||||||
Net Debt | 12,112 | |||||||||
Equity Value | -35,137 | |||||||||
Diluted Shares Outstanding, MM | 193 | |||||||||
Equity Value Per Share | -182.06 |
What You Will Get
- Real AWK Financial Data: Pre-filled with American Water Works Company’s historical and projected data for precise analysis.
- Fully Editable Template: Modify key inputs like revenue growth, WACC, and EBITDA % with ease.
- Automatic Calculations: See AWK’s intrinsic value update instantly based on your changes.
- Professional Valuation Tool: Designed for investors, analysts, and consultants seeking accurate DCF results.
- User-Friendly Design: Simple structure and clear instructions for all experience levels.
Key Features
- Comprehensive Data: American Water Works Company, Inc.'s (AWK) historical financial statements and pre-filled projections.
- Customizable Inputs: Modify WACC, tax rates, revenue growth, and EBITDA margins as needed.
- Real-Time Results: View the intrinsic value of American Water Works Company, Inc. (AWK) updated instantly.
- Intuitive Visual Outputs: Dashboard graphs showcase valuation results and essential metrics.
- Designed for Precision: A professional-grade tool for analysts, investors, and finance professionals.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review American Water Works Company's pre-filled financial data and forecasts.
- Step 3: Modify critical inputs like revenue growth, WACC, and tax rates (highlighted cells).
- Step 4: Watch the DCF model update instantly as you tweak assumptions.
- Step 5: Analyze the outputs and use the results for investment decisions.
Why Choose This Calculator?
- Accurate Data: Real American Water Works Company financials ensure reliable valuation results.
- Customizable: Adjust key parameters like growth rates, WACC, and tax rates to match your projections.
- Time-Saving: Pre-built calculations eliminate the need to start from scratch.
- Professional-Grade Tool: Designed for investors, analysts, and consultants.
- User-Friendly: Intuitive layout and step-by-step instructions make it easy for all users.
Who Should Use This Product?
- Investors: Accurately estimate American Water Works Company, Inc.'s (AWK) fair value before making investment decisions.
- CFOs: Leverage a professional-grade DCF model for financial reporting and analysis related to American Water Works Company, Inc. (AWK).
- Consultants: Quickly adapt the template for valuation reports for clients in the utilities sector, including American Water Works Company, Inc. (AWK).
- Entrepreneurs: Gain insights into financial modeling practices used by leading utility companies like American Water Works Company, Inc. (AWK).
- Educators: Use it as a teaching tool to demonstrate valuation methodologies specific to the water utility industry, including American Water Works Company, Inc. (AWK).
What the Template Contains
- Historical Data: Includes American Water Works Company's past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate American Water Works Company's intrinsic value.
- WACC Sheet: Pre-built calculations for Weighted Average Cost of Capital.
- Editable Inputs: Modify key drivers like growth rates, EBITDA %, and CAPEX assumptions.
- Quarterly and Annual Statements: A complete breakdown of American Water Works Company's financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically.