|
Valoración de DCF de American States Water Company (AWR)
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 States Water Company (AWR) Bundle
¡Agilice su análisis y mejore la precisión con nuestra calculadora DCF (AWR)! Utilizando datos reales de American States Water Company y suposiciones personalizables, esta herramienta le permite pronosticar, analizar y valorar American States Water Company 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 | 473.9 | 488.2 | 498.9 | 491.5 | 595.7 | 632.8 | 672.3 | 714.2 | 758.7 | 806.0 |
| Revenue Growth, % | 0 | 3.03 | 2.17 | -1.47 | 21.19 | 6.23 | 6.23 | 6.23 | 6.23 | 6.23 |
| EBITDA | 164.1 | 171.0 | 185.1 | 170.8 | 252.5 | 232.7 | 247.3 | 262.7 | 279.0 | 296.4 |
| EBITDA, % | 34.63 | 35.03 | 37.1 | 34.75 | 42.39 | 36.78 | 36.78 | 36.78 | 36.78 | 36.78 |
| Depreciation | 35.7 | 37.2 | 40.0 | 41.7 | 43.3 | 49.3 | 52.3 | 55.6 | 59.0 | 62.7 |
| Depreciation, % | 7.54 | 7.62 | 8.01 | 8.48 | 7.26 | 7.78 | 7.78 | 7.78 | 7.78 | 7.78 |
| EBIT | 128.4 | 133.8 | 145.1 | 129.1 | 209.3 | 183.5 | 194.9 | 207.1 | 220.0 | 233.7 |
| EBIT, % | 27.09 | 27.41 | 29.08 | 26.26 | 35.13 | 29 | 29 | 29 | 29 | 29 |
| Total Cash | 1.3 | 36.7 | 5.0 | 6.0 | 14.1 | 15.7 | 16.6 | 17.7 | 18.8 | 20.0 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 88.4 | 93.1 | 102.3 | 99.3 | 123.4 | 125.5 | 133.3 | 141.6 | 150.4 | 159.8 |
| Account Receivables, % | 18.64 | 19.07 | 20.5 | 20.21 | 20.72 | 19.83 | 19.83 | 19.83 | 19.83 | 19.83 |
| Inventories | 6.4 | 8.6 | 12.2 | 14.6 | 17.6 | 14.5 | 15.4 | 16.4 | 17.4 | 18.5 |
| Inventories, % | 1.36 | 1.77 | 2.44 | 2.98 | 2.95 | 2.3 | 2.3 | 2.3 | 2.3 | 2.3 |
| Accounts Payable | 55.6 | 63.8 | 65.9 | 84.8 | 68.7 | 84.6 | 89.8 | 95.4 | 101.4 | 107.7 |
| Accounts Payable, % | 11.74 | 13.06 | 13.21 | 17.26 | 11.53 | 13.36 | 13.36 | 13.36 | 13.36 | 13.36 |
| Capital Expenditure | -151.9 | -130.4 | -144.5 | -166.2 | -188.5 | -193.9 | -206.0 | -218.8 | -232.5 | -247.0 |
| Capital Expenditure, % | -32.06 | -26.71 | -28.97 | -33.82 | -31.65 | -30.64 | -30.64 | -30.64 | -30.64 | -30.64 |
| Tax Rate, % | 24.98 | 24.98 | 24.98 | 24.98 | 24.98 | 24.98 | 24.98 | 24.98 | 24.98 | 24.98 |
| EBITAT | 99.3 | 100.9 | 109.7 | 99.2 | 157.0 | 139.5 | 148.2 | 157.5 | 167.3 | 177.7 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -56.1 | 8.9 | -5.4 | -6.0 | -31.5 | 11.7 | -8.9 | -9.5 | -10.1 | -10.7 |
| WACC, % | 6 | 5.98 | 5.98 | 5.99 | 5.97 | 5.98 | 5.98 | 5.98 | 5.98 | 5.98 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -20.8 | |||||||||
| Long Term Growth Rate, % | 4.00 | |||||||||
| Free cash flow (T + 1) | -11 | |||||||||
| Terminal Value | -560 | |||||||||
| Present Terminal Value | -419 | |||||||||
| Enterprise Value | -440 | |||||||||
| Net Debt | 904 | |||||||||
| Equity Value | -1,343 | |||||||||
| Diluted Shares Outstanding, MM | 37 | |||||||||
| Equity Value Per Share | -36.23 |
What You Will Get
- Real AWR Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures for American States Water Company (AWR).
- Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates to fit your analysis.
- Instant Valuation Updates: Automatic recalculations to analyze the impact of changes on American States Water Company’s (AWR) fair value.
- Versatile Excel Template: Tailored for quick edits, scenario testing, and detailed projections specific to American States Water Company (AWR).
- Time-Saving and Accurate: Skip building models from scratch while ensuring precision and flexibility in your evaluations of American States Water Company (AWR).
Key Features
- Comprehensive DCF Calculator: Features detailed unlevered and levered DCF valuation models tailored for American States Water Company (AWR).
- WACC Calculator: Includes a pre-built Weighted Average Cost of Capital sheet with customizable inputs for precise analysis.
- Adjustable Forecast Assumptions: Easily modify growth rates, capital expenditures, and discount rates to fit your analysis needs.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios specifically for American States Water Company (AWR).
- Interactive Dashboard and Charts: Visual representations summarize essential valuation metrics for straightforward analysis.
How It Works
- Download the Template: Gain immediate access to the Excel-based AWR DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and other variables.
- Instant Calculations: The model automatically recalculates the intrinsic value of American States Water Company (AWR).
- Test Scenarios: Experiment with different assumptions to see how they affect the valuation.
- Analyze and Decide: Leverage the results to inform your investment or financial assessment.
Why Choose American States Water Company (AWR)?
- Reliable Service: Count on consistent and dependable water services for your needs.
- Commitment to Sustainability: Focused on environmentally friendly practices and resource conservation.
- Community Engagement: Actively involved in local initiatives to support and enhance community welfare.
- Expertise and Experience: Over a century of experience in providing quality water solutions.
- Customer-Centric Approach: Dedicated to delivering exceptional service and support to customers.
Who Should Use This Product?
- Individual Investors: Make informed decisions about buying or selling American States Water Company (AWR) stock.
- Financial Analysts: Streamline valuation processes with ready-to-use financial models for American States Water Company (AWR).
- Consultants: Deliver professional valuation insights on American States Water Company (AWR) to clients quickly and accurately.
- Business Owners: Understand how companies like American States Water Company (AWR) are valued to guide your own strategy.
- Finance Students: Learn valuation techniques using real-world data and scenarios related to American States Water Company (AWR).
What the Template Contains
- Preloaded AWR Data: Historical and projected financial data, including revenue, EBIT, and capital expenditures.
- DCF and WACC Models: Professional-grade sheets for calculating intrinsic value and Weighted Average Cost of Capital.
- Editable Inputs: Yellow-highlighted cells for adjusting revenue growth, tax rates, and discount rates.
- Financial Statements: Comprehensive annual and quarterly financials for deeper analysis.
- Key Ratios: Profitability, leverage, and efficiency ratios to evaluate performance.
- Dashboard and Charts: Visual summaries of valuation outcomes and assumptions.