|
La valoración de DCF de York Water Company (YORW)
US | Utilities | Regulated Water | NASDAQ
|
- ✓ 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
The York Water Company (YORW) Bundle
¡Evalúe las perspectivas financieras de la compañía de agua de York como un experto! Esta calculadora DCF (YORW) proporciona datos financieros precargados al tiempo que le permite modificar fácilmente el crecimiento de los ingresos, WACC, los márgenes y otros supuestos esenciales para alinearse con sus predicciones.
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 | 51.6 | 53.9 | 55.1 | 60.1 | 71.0 | 77.1 | 83.6 | 90.7 | 98.4 | 106.8 |
| Revenue Growth, % | 0 | 4.41 | 2.35 | 8.97 | 18.26 | 8.5 | 8.5 | 8.5 | 8.5 | 8.5 |
| EBITDA | 30.0 | 31.2 | 31.0 | 33.3 | 43.8 | 44.7 | 48.5 | 52.6 | 57.0 | 61.9 |
| EBITDA, % | 58.21 | 58.02 | 56.32 | 55.52 | 61.71 | 57.96 | 57.96 | 57.96 | 57.96 | 57.96 |
| Depreciation | 7.7 | 8.2 | 8.9 | 10.1 | 11.7 | 12.3 | 13.3 | 14.4 | 15.7 | 17.0 |
| Depreciation, % | 14.91 | 15.18 | 16.07 | 16.88 | 16.54 | 15.92 | 15.92 | 15.92 | 15.92 | 15.92 |
| EBIT | 22.3 | 23.1 | 22.2 | 23.2 | 32.1 | 32.4 | 35.2 | 38.1 | 41.4 | 44.9 |
| EBIT, % | 43.3 | 42.84 | 40.24 | 38.64 | 45.17 | 42.04 | 42.04 | 42.04 | 42.04 | 42.04 |
| Total Cash | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 7.2 | 8.8 | 8.3 | 10.9 | 11.7 | 12.3 | 13.4 | 14.5 | 15.7 | 17.1 |
| Account Receivables, % | 14.04 | 16.25 | 15.08 | 18.1 | 16.41 | 15.98 | 15.98 | 15.98 | 15.98 | 15.98 |
| Inventories | 1.0 | 1.0 | 1.9 | 2.3 | 3.1 | 2.4 | 2.6 | 2.8 | 3.1 | 3.3 |
| Inventories, % | 1.95 | 1.88 | 3.48 | 3.89 | 4.38 | 3.11 | 3.11 | 3.11 | 3.11 | 3.11 |
| Accounts Payable | 3.5 | 6.5 | 6.7 | 10.8 | 10.9 | 9.9 | 10.7 | 11.7 | 12.6 | 13.7 |
| Accounts Payable, % | 6.69 | 12.14 | 12.18 | 17.93 | 15.31 | 12.85 | 12.85 | 12.85 | 12.85 | 12.85 |
| Capital Expenditure | -20.5 | -33.3 | -46.4 | -53.9 | -64.6 | -56.5 | -61.3 | -66.5 | -72.2 | -78.3 |
| Capital Expenditure, % | -39.82 | -61.83 | -84.18 | -89.78 | -91 | -73.32 | -73.32 | -73.32 | -73.32 | -73.32 |
| Tax Rate, % | 5.1 | 5.1 | 5.1 | 5.1 | 5.1 | 5.1 | 5.1 | 5.1 | 5.1 | 5.1 |
| EBITAT | 19.3 | 20.6 | 20.8 | 23.2 | 30.5 | 30.1 | 32.6 | 35.4 | 38.4 | 41.7 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 1.7 | -3.0 | -17.0 | -19.5 | -23.9 | -15.1 | -15.8 | -17.1 | -18.6 | -20.1 |
| WACC, % | 6.48 | 6.52 | 6.57 | 6.65 | 6.59 | 6.56 | 6.56 | 6.56 | 6.56 | 6.56 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -71.2 | |||||||||
| Long Term Growth Rate, % | 4.00 | |||||||||
| Free cash flow (T + 1) | -21 | |||||||||
| Terminal Value | -818 | |||||||||
| Present Terminal Value | -595 | |||||||||
| Enterprise Value | -666 | |||||||||
| Net Debt | 180 | |||||||||
| Equity Value | -846 | |||||||||
| Diluted Shares Outstanding, MM | 14 | |||||||||
| Equity Value Per Share | -59.19 |
What You Will Receive
- Customizable Excel Template: A fully adjustable Excel-based DCF Calculator featuring pre-filled real YORW financials.
- Actual Market Data: Historical performance data and forward-looking projections (as highlighted in the yellow cells).
- Assumption Flexibility: Modify forecast parameters such as revenue growth, EBITDA %, and WACC.
- Instant Calculations: Quickly observe how your inputs affect The York Water Company's valuation.
- Professional Resource: Designed for investors, CFOs, consultants, and financial analysts.
- User-Friendly Interface: Organized for clarity and ease of use, complete with step-by-step guidance.
Key Features
- Comprehensive DCF Calculator: Features both unlevered and levered DCF valuation models tailored for The York Water Company (YORW).
- WACC Calculator: Customizable Weighted Average Cost of Capital sheet to suit your analytical needs.
- Adjustable Forecast Assumptions: Easily change growth rates, capital expenditures, and discount rates to fit your projections.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios specific to The York Water Company (YORW).
- Visual Dashboard and Charts: Graphical representations that highlight essential valuation metrics for straightforward analysis.
How It Works
- Download the Template: Get instant access to the Excel-based YORW DCF Calculator.
- Input Your Assumptions: Adjust the yellow-highlighted cells for growth rates, WACC, margins, and more.
- Instant Calculations: The model automatically updates The York Water Company’s intrinsic value.
- Test Scenarios: Simulate different assumptions to evaluate potential valuation changes.
- Analyze and Decide: Use the results to guide your investment or financial analysis.
Why Choose This Calculator for The York Water Company (YORW)?
- Designed for Industry Experts: A sophisticated tool utilized by water utility analysts, CFOs, and financial consultants.
- Accurate Financial Insights: The York Water Company's historical and projected financial data preloaded for precision.
- Flexible Scenario Analysis: Effortlessly simulate various forecasts and assumptions.
- Comprehensive Outputs: Automatically computes intrinsic value, NPV, and essential metrics.
- User-Friendly Interface: Step-by-step guidance to navigate the calculation process seamlessly.
Who Should Use This Product?
- Investors: Accurately assess The York Water Company's (YORW) fair value prior to making investment choices.
- CFOs: Utilize a professional-grade DCF model for financial reporting and analysis related to (YORW).
- Consultants: Efficiently customize the template for valuation reports tailored to (YORW) clients.
- Entrepreneurs: Acquire knowledge on financial modeling techniques employed by established water utility companies like (YORW).
- Educators: Implement it as a teaching resource to illustrate valuation methodologies in the context of (YORW).
What the Template Contains
- Pre-Filled Data: Includes The York Water Company's historical financials and forecasts.
- Discounted Cash Flow Model: Editable DCF valuation model with automatic calculations.
- Weighted Average Cost of Capital (WACC): A dedicated sheet for calculating WACC based on custom inputs.
- Key Financial Ratios: Analyze The York Water Company's profitability, efficiency, and leverage.
- Customizable Inputs: Edit revenue growth, margins, and tax rates with ease.
- Clear Dashboard: Charts and tables summarizing key valuation results.