Middlesex Water Company (MSEX) DCF Valuation
- ✓ Entièrement Modifiable: Adapté À Vos Besoins Dans Excel Ou Sheets
- ✓ Conception Professionnelle: Modèles Fiables Et Conformes Aux Normes Du Secteur
- ✓ Pré-Construits Pour Une Utilisation Rapide Et Efficace
- ✓ Aucune Expertise N'Est Requise; Facile À Suivre
Middlesex Water Company (MSEX) Bundle
Evaluate the financial outlook of Middlesex Water Company (MSEX) like a seasoned expert! This (MSEX) DCF Calculator comes with pre-filled financials and offers full flexibility to modify revenue growth, WACC, margins, and other essential assumptions to align with your projections.
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 | 134.6 | 141.6 | 143.1 | 162.4 | 166.3 | 175.5 | 185.2 | 195.4 | 206.2 | 217.7 |
| Revenue Growth, % | 0 | 5.2 | 1.09 | 13.48 | 2.36 | 5.53 | 5.53 | 5.53 | 5.53 | 5.53 |
| EBITDA | 51.6 | 58.5 | 62.0 | 74.1 | 71.3 | 74.2 | 78.3 | 82.7 | 87.2 | 92.1 |
| EBITDA, % | 38.3 | 41.34 | 43.34 | 45.63 | 42.86 | 42.3 | 42.3 | 42.3 | 42.3 | 42.3 |
| Depreciation | 17.2 | 20.8 | 26.8 | 27.5 | 29.4 | 28.4 | 29.9 | 31.6 | 33.4 | 35.2 |
| Depreciation, % | 12.8 | 14.72 | 18.72 | 16.91 | 17.71 | 16.17 | 16.17 | 16.17 | 16.17 | 16.17 |
| EBIT | 34.3 | 37.7 | 35.2 | 46.6 | 41.8 | 45.8 | 48.4 | 51.1 | 53.9 | 56.9 |
| EBIT, % | 25.5 | 26.63 | 24.62 | 28.72 | 25.15 | 26.12 | 26.12 | 26.12 | 26.12 | 26.12 |
| Total Cash | 2.2 | 4.5 | 3.5 | 3.8 | 2.4 | 3.9 | 4.1 | 4.3 | 4.6 | 4.8 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 19.1 | 21.6 | 22.6 | 24.7 | 97.3 | 41.8 | 44.1 | 46.5 | 49.1 | 51.8 |
| Account Receivables, % | 14.18 | 15.28 | 15.78 | 15.19 | 58.54 | 23.79 | 23.79 | 23.79 | 23.79 | 23.79 |
| Inventories | 5.4 | 5.1 | 5.4 | 6.2 | 7.0 | 6.8 | 7.2 | 7.6 | 8.0 | 8.4 |
| Inventories, % | 4.05 | 3.61 | 3.74 | 3.8 | 4.19 | 3.88 | 3.88 | 3.88 | 3.88 | 3.88 |
| Accounts Payable | 23.3 | 30.4 | 21.1 | 24.8 | 27.6 | 30.0 | 31.7 | 33.4 | 35.3 | 37.2 |
| Accounts Payable, % | 17.32 | 21.5 | 14.76 | 15.3 | 16.61 | 17.1 | 17.1 | 17.1 | 17.1 | 17.1 |
| Capital Expenditure | -89.1 | -105.6 | -79.4 | -91.3 | -90.2 | -107.6 | -113.6 | -119.9 | -126.5 | -133.5 |
| Capital Expenditure, % | -66.22 | -74.59 | -55.45 | -56.23 | -54.24 | -61.35 | -61.35 | -61.35 | -61.35 | -61.35 |
| Tax Rate, % | 3.2 | 3.2 | 3.2 | 3.2 | 3.2 | 3.2 | 3.2 | 3.2 | 3.2 | 3.2 |
| EBITAT | 37.8 | 42.2 | 41.5 | 43.3 | 40.5 | 44.9 | 47.4 | 50.0 | 52.8 | 55.7 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -35.3 | -37.6 | -21.6 | -19.7 | -90.9 | 23.8 | -37.3 | -39.4 | -41.5 | -43.8 |
| WACC, % | 7.04 | 7.04 | 7.04 | 6.95 | 7 | 7.01 | 7.01 | 7.01 | 7.01 | 7.01 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -105.4 | |||||||||
| Long Term Growth Rate, % | 4.00 | |||||||||
| Free cash flow (T + 1) | -46 | |||||||||
| Terminal Value | -1,513 | |||||||||
| Present Terminal Value | -1,078 | |||||||||
| Enterprise Value | -1,183 | |||||||||
| Net Debt | 410 | |||||||||
| Equity Value | -1,593 | |||||||||
| Diluted Shares Outstanding, MM | 18 | |||||||||
| Equity Value Per Share | -89.27 |
What You Will Receive
- Customizable Excel Template: A fully editable Excel-based DCF Calculator featuring pre-filled financial data for Middlesex Water Company (MSEX).
- Accurate Data: Historical performance metrics and forward-looking estimates (highlighted in the yellow cells).
- Flexible Forecasting: Adjust key assumptions such as revenue growth, EBITDA margin, and WACC.
- Instant Calculations: Quickly assess how your inputs affect the valuation of Middlesex Water Company (MSEX).
- Professional Resource: Designed for use by investors, CFOs, consultants, and financial analysts.
- Intuitive Layout: Organized for simplicity and ease of navigation, complete with step-by-step guidance.
Key Features
- Comprehensive DCF Calculator: Features detailed unlevered and levered DCF valuation models tailored for Middlesex Water Company (MSEX).
- WACC Calculator: Pre-configured Weighted Average Cost of Capital sheet with adjustable inputs specific to MSEX.
- Customizable Forecast Assumptions: Adjust growth rates, capital expenditures, and discount rates to fit MSEX's financial outlook.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios relevant to Middlesex Water Company (MSEX).
- Interactive Dashboard and Charts: Visual representations summarize essential valuation metrics for straightforward analysis.
How It Works
- 1. Access the Template: Download and open the Excel file featuring Middlesex Water Company's (MSEX) preloaded data.
- 2. Adjust Assumptions: Modify key inputs such as growth rates, WACC, and capital expenditures to fit your analysis.
- 3. View Results Instantly: The DCF model automatically computes intrinsic value and NPV based on your inputs.
- 4. Explore Scenarios: Evaluate various forecasts to understand different valuation possibilities.
- 5. Present with Confidence: Share professional valuation insights to enhance your decision-making process.
Why Choose This Calculator for Middlesex Water Company (MSEX)?
- User-Friendly Interface: Perfect for both novice and experienced users.
- Customizable Inputs: Adjust parameters to suit your specific analysis needs.
- Real-Time Feedback: Instantly observe changes in Middlesex Water's valuation as you modify inputs.
- Pre-Loaded Data: Comes with Middlesex Water's actual financial figures for immediate evaluation.
- Relied Upon by Experts: Favored by investors and analysts for making well-informed choices.
Who Should Use This Product?
- Individual Investors: Gain insights for making informed decisions about buying or selling Middlesex Water Company (MSEX) stock.
- Financial Analysts: Enhance valuation methods with comprehensive financial models tailored for Middlesex Water Company (MSEX).
- Consultants: Provide accurate and timely valuation assessments of Middlesex Water Company (MSEX) to your clients.
- Business Owners: Learn from the valuation practices of established companies like Middlesex Water Company (MSEX) to refine your own business strategies.
- Finance Students: Explore valuation principles using real data and case studies related to Middlesex Water Company (MSEX).
What the Template Contains
- Preloaded MSEX 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.