Essential Utilities, Inc. (WTRG) DCF Valuation

Essential Utilities, Inc. (WTRG) DCF Valuation
  • ✓ Fully Editable: Tailor To Your Needs In Excel Or Sheets
  • ✓ Professional Design: Trusted, Industry-Standard Templates
  • ✓ Pre-Built For Quick And Efficient Use
  • ✓ No Expertise Is Needed; Easy To Follow

Essential Utilities, Inc. (WTRG) Bundle

DCF model
Get Full Bundle:
$25 $15
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7

TOTAL:

Explore the financial potential of Essential Utilities, Inc. (WTRG) with our user-friendly DCF Calculator! Simply enter your assumptions regarding growth, margins, and costs to calculate the intrinsic value of Essential Utilities, Inc. (WTRG) and enhance your investment strategy.


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 889.7 1,462.7 1,878.1 2,288.0 2,053.8 2,589.8 3,265.8 4,118.1 5,192.9 6,548.2
Revenue Growth, % 0 64.4 28.4 21.82 -10.24 26.1 26.1 26.1 26.1 26.1
EBITDA 513.7 716.4 908.4 990.5 1,058.8 1,294.5 1,632.4 2,058.4 2,595.6 3,273.1
EBITDA, % 57.74 48.98 48.36 43.29 51.55 49.98 49.98 49.98 49.98 49.98
Depreciation 156.5 257.1 298.0 321.2 343.7 423.7 534.3 673.7 849.5 1,071.3
Depreciation, % 17.59 17.57 15.86 14.04 16.73 16.36 16.36 16.36 16.36 16.36
EBIT 357.2 459.3 610.4 669.3 715.1 870.8 1,098.1 1,384.7 1,746.1 2,201.8
EBIT, % 40.15 31.4 32.5 29.25 34.82 33.63 33.63 33.63 33.63 33.63
Total Cash 1,868.9 4.8 10.6 11.4 4.6 526.3 663.7 836.9 1,055.4 1,330.8
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 107.6 273.3 260.9 376.8 245.7
Account Receivables, % 12.1 18.69 13.89 16.47 11.96
Inventories 18.4 58.4 109.6 199.7 112.7 135.2 170.5 215.0 271.1 341.9
Inventories, % 2.07 3.99 5.83 8.73 5.49 5.22 5.22 5.22 5.22 5.22
Accounts Payable 74.9 177.5 192.9 238.8 221.2 269.5 339.9 428.6 540.4 681.5
Accounts Payable, % 8.42 12.13 10.27 10.44 10.77 10.41 10.41 10.41 10.41 10.41
Capital Expenditure -550.3 -835.6 -1,020.5 -1,062.8 -1,199.1 -1,440.7 -1,816.7 -2,290.9 -2,888.8 -3,642.7
Capital Expenditure, % -61.85 -57.13 -54.34 -46.45 -58.38 -55.63 -55.63 -55.63 -55.63 -55.63
Tax Rate, % -15.39 -15.39 -15.39 -15.39 -15.39 -15.39 -15.39 -15.39 -15.39 -15.39
EBITAT 379.2 493.8 624.3 690.5 825.2 870.8 1,098.1 1,384.7 1,746.1 2,201.8
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF -65.7 -188.0 -121.6 -211.2 170.3 -253.4 -248.1 -312.9 -394.6 -497.5
WACC, % 6.74 6.74 6.74 6.74 6.74 6.74 6.74 6.74 6.74 6.74
PV UFCF
SUM PV UFCF -1,375.7
Long Term Growth Rate, % 4.00
Free cash flow (T + 1) -517
Terminal Value -18,914
Present Terminal Value -13,653
Enterprise Value -15,029
Net Debt 7,083
Equity Value -22,112
Diluted Shares Outstanding, MM 268
Equity Value Per Share -82.61

What You Will Get

  • Real Essential Utilities Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures.
  • Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
  • Instant Valuation Updates: Automatic recalculations to analyze the impact of changes on Essential Utilities’ fair value.
  • Versatile Excel Template: Tailored for quick edits, scenario testing, and detailed projections.
  • Time-Saving and Accurate: Skip building models from scratch while maintaining precision and flexibility.

Key Features

  • Accurate Essential Utilities Financials: Gain access to reliable pre-loaded historical data and future forecasts.
  • Tailorable Forecast Assumptions: Modify highlighted cells for WACC, growth rates, and profit margins.
  • Real-Time Calculations: Automatic adjustments to DCF, Net Present Value (NPV), and cash flow evaluations.
  • Interactive Dashboard: User-friendly charts and summaries to illustrate your valuation findings.
  • Designed for All Skill Levels: A straightforward, intuitive layout suitable for investors, CFOs, and consultants.

How It Works

  • 1. Access the Template: Download and open the Excel file containing Essential Utilities, Inc. (WTRG) preloaded data.
  • 2. Modify Assumptions: Adjust key variables such as growth rates, WACC, and capital expenditures.
  • 3. See Results Instantly: The DCF model automatically calculates intrinsic value and NPV.
  • 4. Explore Scenarios: Evaluate various forecasts to assess different valuation outcomes.
  • 5. Present with Assurance: Deliver expert valuation insights to enhance your decision-making process.

Why Choose This Calculator for Essential Utilities, Inc. (WTRG)?

  • Accurate Data: Up-to-date Essential Utilities financials provide dependable valuation outcomes.
  • Customizable: Tailor key inputs such as growth rates, WACC, and tax rates to align with your forecasts.
  • Time-Saving: Pre-configured calculations save you the hassle of starting from scratch.
  • Professional-Grade Tool: Crafted for investors, analysts, and consultants in the utility sector.
  • User-Friendly: Simple design and guided instructions ensure accessibility for all users.

Who Should Use This Product?

  • Utility Management Students: Understand regulatory frameworks and apply them using real-world data.
  • Researchers: Integrate industry-specific models into academic studies or papers.
  • Investors: Evaluate your investment strategies and assess valuation metrics for Essential Utilities, Inc. (WTRG).
  • Financial Analysts: Enhance your analysis with a ready-to-use, customizable DCF model tailored for utility companies.
  • Small Business Owners: Discover how large utility firms like Essential Utilities, Inc. (WTRG) are evaluated in the market.

What the Template Contains

  • Historical Data: Includes Essential Utilities, Inc. (WTRG)’s past financials and baseline forecasts.
  • DCF and Levered DCF Models: Detailed templates to calculate Essential Utilities, Inc. (WTRG)’s intrinsic value.
  • WACC Sheet: Pre-built calculations for Weighted Average Cost of Capital.
  • Editable Inputs: Modify key drivers like growth rates, EBITDA %, and CAPEX assumptions.
  • Quarterly and Annual Statements: A complete breakdown of Essential Utilities, Inc. (WTRG)’s financials.
  • Interactive Dashboard: Visualize valuation results and projections dynamically.

No products were found matching.