|
Valoración de DCF de Unitil Corporation (UTL)
US | Utilities | Diversified Utilities | 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
Unitil Corporation (UTL) Bundle
¡Optimice su tiempo y mejore la precisión con nuestra calculadora DCF de Unitil Corporation (UTL)! Esta herramienta innovadora utiliza datos reales de Unitil y permite suposiciones personalizables, lo que le permite pronosticar, analizar y evaluar Unitil Corporation (UTL) 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 | 438.2 | 418.6 | 473.3 | 563.2 | 557.1 | 594.0 | 633.4 | 675.3 | 720.1 | 767.8 |
| Revenue Growth, % | 0 | -4.47 | 13.07 | 18.99 | -1.08 | 6.63 | 6.63 | 6.63 | 6.63 | 6.63 |
| EBITDA | 136.6 | 123.3 | 134.3 | 143.5 | 160.7 | 170.3 | 181.6 | 193.6 | 206.4 | 220.1 |
| EBITDA, % | 31.17 | 29.46 | 28.38 | 25.48 | 28.85 | 28.67 | 28.67 | 28.67 | 28.67 | 28.67 |
| Depreciation | 52.0 | 54.5 | 59.5 | 62.6 | 67.4 | 72.1 | 76.9 | 81.9 | 87.4 | 93.2 |
| Depreciation, % | 11.87 | 13.02 | 12.57 | 11.12 | 12.1 | 12.13 | 12.13 | 12.13 | 12.13 | 12.13 |
| EBIT | 84.6 | 68.8 | 74.8 | 80.9 | 93.3 | 98.2 | 104.7 | 111.6 | 119.0 | 126.9 |
| EBIT, % | 19.31 | 16.44 | 15.8 | 14.36 | 16.75 | 16.53 | 16.53 | 16.53 | 16.53 | 16.53 |
| Total Cash | 5.2 | 6.0 | 6.5 | 9.0 | 6.5 | 8.0 | 8.6 | 9.1 | 9.7 | 10.4 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 75.4 | 80.5 | 88.1 | 98.1 | 91.3 | 105.6 | 112.6 | 120.0 | 128.0 | 136.5 |
| Account Receivables, % | 17.21 | 19.23 | 18.61 | 17.42 | 16.39 | 17.77 | 17.77 | 17.77 | 17.77 | 17.77 |
| Inventories | 8.7 | 9.1 | 9.6 | 13.2 | 14.5 | 13.2 | 14.1 | 15.0 | 16.0 | 17.1 |
| Inventories, % | 1.99 | 2.17 | 2.03 | 2.34 | 2.6 | 2.23 | 2.23 | 2.23 | 2.23 | 2.23 |
| Accounts Payable | 37.6 | 33.2 | 52.4 | 68.6 | 47.7 | 57.4 | 61.2 | 65.3 | 69.6 | 74.2 |
| Accounts Payable, % | 8.58 | 7.93 | 11.07 | 12.18 | 8.56 | 9.67 | 9.67 | 9.67 | 9.67 | 9.67 |
| Capital Expenditure | -119.2 | -122.6 | -115.0 | -122.1 | -141.0 | -151.8 | -161.9 | -172.6 | -184.0 | -196.2 |
| Capital Expenditure, % | -27.2 | -29.29 | -24.3 | -21.68 | -25.31 | -25.56 | -25.56 | -25.56 | -25.56 | -25.56 |
| Tax Rate, % | 22.6 | 22.6 | 22.6 | 22.6 | 22.6 | 22.6 | 22.6 | 22.6 | 22.6 | 22.6 |
| EBITAT | 64.5 | 52.2 | 56.7 | 63.7 | 72.2 | 75.4 | 80.4 | 85.8 | 91.4 | 97.5 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -49.2 | -25.8 | 12.3 | 6.8 | -16.8 | -7.6 | -8.6 | -9.2 | -9.8 | -10.5 |
| WACC, % | 5.79 | 5.78 | 5.78 | 5.84 | 5.81 | 5.8 | 5.8 | 5.8 | 5.8 | 5.8 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -38.4 | |||||||||
| Long Term Growth Rate, % | 1.00 | |||||||||
| Free cash flow (T + 1) | -11 | |||||||||
| Terminal Value | -220 | |||||||||
| Present Terminal Value | -166 | |||||||||
| Enterprise Value | -205 | |||||||||
| Net Debt | 675 | |||||||||
| Equity Value | -880 | |||||||||
| Diluted Shares Outstanding, MM | 16 | |||||||||
| Equity Value Per Share | -54.80 |
What You Will Receive
- Customizable Excel Template: A fully editable Excel-based DCF Calculator featuring pre-filled real UTL financials.
- Authentic Data: Historical performance metrics and future projections (highlighted in the yellow cells).
- Flexible Forecasting: Adjust forecast variables such as revenue growth, EBITDA %, and WACC.
- Instant Calculations: Quickly observe how your inputs influence Unitil Corporation’s valuation.
- Professional Resource: Designed for investors, CFOs, consultants, and financial analysts.
- User-Centric Layout: Organized for clarity and accessibility, complete with step-by-step guidance.
Key Features
- Comprehensive Financial Data: Gain access to precise pre-loaded historical figures and future forecasts for Unitil Corporation (UTL).
- Adjustable Forecast Inputs: Modify highlighted cells for key metrics such as WACC, growth rates, and profit margins.
- Real-Time Calculations: Automatic adjustments to DCF, Net Present Value (NPV), and cash flow assessments.
- User-Friendly Dashboard: Clear charts and summaries for an intuitive visualization of your valuation outcomes.
- Designed for All Levels: A straightforward, user-friendly layout tailored for investors, CFOs, and consultants alike.
How It Works
- Download: Obtain the pre-built Excel file featuring Unitil Corporation’s (UTL) financial data.
- Customize: Modify forecasts, such as revenue growth, EBITDA %, and WACC.
- Update Automatically: The intrinsic value and NPV calculations refresh in real-time.
- Test Scenarios: Develop various projections and instantly compare the results.
- Make Decisions: Leverage the valuation outcomes to inform your investment strategy.
Why Choose This Calculator for Unitil Corporation (UTL)?
- User-Friendly Interface: Perfect for both novice users and seasoned professionals.
- Customizable Inputs: Adjust parameters effortlessly to suit your financial analysis.
- Real-Time Valuation: Observe immediate updates to Unitil Corporation’s valuation with every input change.
- Pre-Loaded Data: Comes with Unitil Corporation’s actual financial metrics for swift evaluations.
- Preferred by Experts: Widely utilized by investors and analysts to guide their financial decisions.
Who Should Use This Product?
- Utility Investors: Develop comprehensive and accurate valuation models for assessing Unitil Corporation (UTL) investments.
- Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decision-making within the organization.
- Consultants and Advisors: Deliver precise valuation insights for clients interested in Unitil Corporation (UTL) stock.
- Students and Educators: Utilize real-world data to enhance learning and practice in financial modeling.
- Energy Sector Enthusiasts: Gain insights into how utility companies like Unitil Corporation (UTL) are valued in the market.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Unitil Corporation (UTL) historical data and forecasts, including revenue, EBITDA, EBIT, and capital expenditures.
- WACC Calculation: A dedicated sheet for Weighted Average Cost of Capital (WACC), incorporating parameters like Beta, risk-free rate, and share price.
- DCF Valuation (Unlevered and Levered): Editable Discounted Cash Flow models displaying intrinsic value with comprehensive calculations.
- Financial Statements: Pre-loaded financial statements (annual and quarterly) to facilitate analysis.
- Key Ratios: Includes profitability, leverage, and efficiency ratios for Unitil Corporation (UTL).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to simplify result analysis.