|
Valoración DCF del Grupo SJW (SJW)
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
SJW Group (SJW) Bundle
¡Simplifique la valoración del Grupo SJW (SJW) con esta calculadora DCF personalizable! Con el Real SJW Group (SJW) Financials y las entradas de pronóstico ajustables, puede probar escenarios y descubrir el valor razonable del Grupo SJW (SJW) en minutos.
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 | 420.5 | 564.5 | 573.7 | 620.7 | 670.4 | 757.6 | 856.3 | 967.8 | 1,093.7 | 1,236.1 |
| Revenue Growth, % | 0 | 34.26 | 1.62 | 8.19 | 8 | 13.02 | 13.02 | 13.02 | 13.02 | 13.02 |
| EBITDA | 132.3 | 208.9 | 309.5 | 236.2 | 265.2 | 303.1 | 342.6 | 387.2 | 437.6 | 494.6 |
| EBITDA, % | 31.47 | 37.01 | 53.95 | 38.06 | 39.56 | 40.01 | 40.01 | 40.01 | 40.01 | 40.01 |
| Depreciation | 68.5 | 91.6 | 186.3 | 106.4 | 108.1 | 148.9 | 168.3 | 190.2 | 215.0 | 242.9 |
| Depreciation, % | 16.28 | 16.23 | 32.48 | 17.15 | 16.13 | 19.65 | 19.65 | 19.65 | 19.65 | 19.65 |
| EBIT | 63.9 | 117.3 | 123.2 | 129.8 | 157.1 | 154.2 | 174.3 | 197.0 | 222.7 | 251.6 |
| EBIT, % | 15.19 | 20.78 | 21.47 | 20.91 | 23.43 | 20.36 | 20.36 | 20.36 | 20.36 | 20.36 |
| Total Cash | 12.9 | 5.3 | 10.9 | 12.3 | 9.7 | 14.2 | 16.0 | 18.1 | 20.5 | 23.1 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 88.1 | 103.1 | 104.8 | 110.5 | 126.3 | 142.6 | 161.2 | 182.1 | 205.9 | 232.7 |
| Account Receivables, % | 20.95 | 18.26 | 18.26 | 17.8 | 18.84 | 18.82 | 18.82 | 18.82 | 18.82 | 18.82 |
| Inventories | 5.0 | 12.1 | 10.9 | 9.8 | .0 | 10.3 | 11.6 | 13.2 | 14.9 | 16.8 |
| Inventories, % | 1.19 | 2.14 | 1.9 | 1.57 | 0 | 1.36 | 1.36 | 1.36 | 1.36 | 1.36 |
| Accounts Payable | 34.9 | 34.2 | 30.4 | 29.6 | 46.1 | 47.4 | 53.6 | 60.6 | 68.5 | 77.4 |
| Accounts Payable, % | 8.3 | 6.06 | 5.3 | 4.77 | 6.88 | 6.26 | 6.26 | 6.26 | 6.26 | 6.26 |
| Capital Expenditure | -182.9 | -215.0 | -253.8 | -244.2 | -290.7 | -316.0 | -357.1 | -403.6 | -456.2 | -515.6 |
| Capital Expenditure, % | -43.5 | -38.08 | -44.24 | -39.35 | -43.37 | -41.71 | -41.71 | -41.71 | -41.71 | -41.71 |
| Tax Rate, % | 6.55 | 6.55 | 6.55 | 6.55 | 6.55 | 6.55 | 6.55 | 6.55 | 6.55 | 6.55 |
| EBITAT | 46.6 | 103.2 | 108.2 | 116.4 | 146.8 | 133.2 | 150.6 | 170.2 | 192.3 | 217.4 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -126.0 | -42.9 | 36.4 | -26.8 | -25.3 | -59.2 | -52.0 | -58.8 | -66.4 | -75.1 |
| WACC, % | 5.2 | 5.55 | 5.55 | 5.59 | 5.68 | 5.51 | 5.51 | 5.51 | 5.51 | 5.51 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -263.8 | |||||||||
| Long Term Growth Rate, % | 4.00 | |||||||||
| Free cash flow (T + 1) | -78 | |||||||||
| Terminal Value | -5,154 | |||||||||
| Present Terminal Value | -3,941 | |||||||||
| Enterprise Value | -4,205 | |||||||||
| Net Debt | 1,737 | |||||||||
| Equity Value | -5,942 | |||||||||
| Diluted Shares Outstanding, MM | 32 | |||||||||
| Equity Value Per Share | -187.67 |
What You Will Get
- Editable Forecast Inputs: Effortlessly adjust key assumptions (growth %, margins, WACC) to explore various scenarios.
- Real-World Data: SJW Group’s financial data pre-loaded to facilitate your analysis.
- Automatic DCF Outputs: The template computes Net Present Value (NPV) and intrinsic value automatically.
- Customizable and Professional: A refined Excel model that caters to your valuation requirements.
- Built for Analysts and Investors: Perfect for evaluating projections, validating strategies, and enhancing efficiency.
Key Features
- Customizable Financial Inputs: Adjust essential parameters such as revenue projections, operating margins, and capital investments.
- Instant DCF Valuation: Quickly computes intrinsic value, net present value (NPV), and additional financial metrics.
- High-Precision Outputs: Incorporates SJW Group's actual financial data for accurate valuation results.
- Streamlined Scenario Testing: Easily evaluate various assumptions and analyze different outcomes.
- Efficiency Booster: Avoid the complexities of constructing detailed valuation models from the ground up.
How It Works
- Step 1: Download the Excel file for SJW Group (SJW).
- Step 2: Review SJW Group's pre-filled financial data and forecasts.
- Step 3: Modify key inputs such as revenue growth, WACC, and tax rates (highlighted cells).
- Step 4: Observe the DCF model update in real-time as you adjust your assumptions.
- Step 5: Analyze the outputs and utilize the results for your investment decisions.
Why Choose This Calculator for SJW Group (SJW)?
- User-Friendly Interface: Tailored for both novice users and seasoned professionals.
- Customizable Inputs: Easily adjust parameters to suit your financial analysis.
- Real-Time Valuation: Instantly observe changes in SJW Group’s valuation as you tweak inputs.
- Preloaded Data: Comes with SJW Group’s latest financial statistics for immediate evaluation.
- Preferred by Experts: Widely utilized by investors and analysts for sound decision-making.
Who Should Use SJW Group (SJW)?
- Professional Investors: Develop comprehensive and trustworthy valuation models for investment assessments.
- Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decision-making.
- Consultants and Advisors: Deliver precise valuation insights for SJW Group (SJW) to clients.
- Students and Educators: Utilize real-world data to enhance financial modeling skills and education.
- Utility Sector Enthusiasts: Gain insights into how utility companies like SJW Group (SJW) are valued in the marketplace.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled SJW Group 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 SJW Group.
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.