WEC Energy Group, Inc. (WEC) DCF Valuation

WEC Energy Group, Inc. (WEC) DCF Valuation
  • ✓ 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

WEC Energy Group, Inc. (WEC) 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 WEC Energy Group, Inc. (WEC) financial prospects with our user-friendly DCF Calculator! Enter your projections for growth, margins, and expenses to calculate WEC's intrinsic value 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 7,523.1 7,241.7 8,316.0 9,597.4 8,893.0 9,319.1 9,765.5 10,233.4 10,723.7 11,237.4
Revenue Growth, % 0 -3.74 14.83 15.41 -7.34 4.79 4.79 4.79 4.79 4.79
EBITDA 2,493.9 2,723.2 2,861.4 3,151.2 3,527.4 3,311.3 3,469.9 3,636.2 3,810.4 3,992.9
EBITDA, % 33.15 37.6 34.41 32.83 39.66 35.53 35.53 35.53 35.53 35.53
Depreciation 926.3 975.9 1,074.3 1,122.6 1,264.2 1,204.4 1,262.1 1,322.6 1,385.9 1,452.3
Depreciation, % 12.31 13.48 12.92 11.7 14.22 12.92 12.92 12.92 12.92 12.92
EBIT 1,567.6 1,747.3 1,787.1 2,028.6 2,263.2 2,106.9 2,207.8 2,313.6 2,424.4 2,540.6
EBIT, % 20.84 24.13 21.49 21.14 25.45 22.61 22.61 22.61 22.61 22.61
Total Cash 37.5 24.8 16.3 28.9 42.9 33.9 35.6 37.3 39.0 40.9
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 1,176.5 1,202.8 1,505.7 1,818.4 1,503.2
Account Receivables, % 15.64 16.61 18.11 18.95 16.9
Inventories 549.8 528.6 635.8 807.1 775.2 734.0 769.1 806.0 844.6 885.1
Inventories, % 7.31 7.3 7.65 8.41 8.72 7.88 7.88 7.88 7.88 7.88
Accounts Payable 908.1 880.7 1,005.7 1,198.1 896.6 1,097.6 1,150.2 1,205.3 1,263.1 1,323.6
Accounts Payable, % 12.07 12.16 12.09 12.48 10.08 11.78 11.78 11.78 11.78 11.78
Capital Expenditure -2,260.8 -2,238.8 -2,252.8 -2,334.1 -2,492.9 -2,617.0 -2,742.3 -2,873.7 -3,011.4 -3,155.7
Capital Expenditure, % -30.05 -30.92 -27.09 -24.32 -28.03 -28.08 -28.08 -28.08 -28.08 -28.08
Tax Rate, % 13.24 13.24 13.24 13.24 13.24 13.24 13.24 13.24 13.24 13.24
EBITAT 1,412.7 1,468.3 1,551.8 1,650.1 1,963.6 1,808.1 1,894.7 1,985.5 2,080.6 2,180.3
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF -740.0 172.9 88.2 147.0 780.5 534.3 354.9 371.9 389.7 408.4
WACC, % 5.55 5.45 5.49 5.4 5.49 5.48 5.48 5.48 5.48 5.48
PV UFCF
SUM PV UFCF 1,770.2
Long Term Growth Rate, % 3.00
Free cash flow (T + 1) 421
Terminal Value 16,983
Present Terminal Value 13,009
Enterprise Value 14,779
Net Debt 18,755
Equity Value -3,976
Diluted Shares Outstanding, MM 316
Equity Value Per Share -12.59

What You Will Get

  • Pre-Filled Financial Model: WEC Energy Group’s actual data enables precise DCF valuation.
  • Full Forecast Control: Adjust revenue growth, margins, WACC, and other key drivers.
  • Instant Calculations: Automatic updates ensure you see results as you make changes.
  • Investor-Ready Template: A refined Excel file designed for professional-grade valuation.
  • Customizable and Reusable: Tailored for flexibility, allowing repeated use for detailed forecasts.

Key Features

  • 🔍 Real-Life WEC Financials: Pre-filled historical and projected data for WEC Energy Group, Inc. (WEC).
  • ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
  • 📊 Professional DCF Valuation: Built-in formulas calculate WEC’s intrinsic value using the Discounted Cash Flow method.
  • ⚡ Instant Results: Visualize WEC’s valuation instantly after making changes.
  • Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.

How It Works

  • 1. Access the Template: Download and open the Excel file containing WEC Energy Group, Inc.'s (WEC) preloaded data.
  • 2. Adjust Assumptions: Modify key inputs such as growth rates, WACC, and capital expenditures.
  • 3. Instant Results: The DCF model automatically calculates intrinsic value and NPV in real-time.
  • 4. Explore Scenarios: Analyze various forecasts to evaluate different valuation possibilities.
  • 5. Present with Assurance: Deliver professional valuation insights to bolster your decision-making process.

Why Choose WEC Energy Group, Inc. (WEC)?

  • Reliable Energy Solutions: Count on us for consistent and efficient energy services.
  • Commitment to Sustainability: We prioritize renewable resources and environmentally friendly practices.
  • Customer-Centric Approach: Our focus is on meeting the unique needs of our customers.
  • Innovative Technology: We leverage cutting-edge technology to enhance service delivery.
  • Recognized Industry Leader: Trusted by stakeholders for our expertise and reliability in energy management.

Who Should Use This Product?

  • Individual Investors: Make informed decisions about buying or selling WEC Energy Group, Inc. (WEC) stock.
  • Financial Analysts: Enhance valuation processes with ready-to-use financial models specific to WEC.
  • Consultants: Provide professional valuation insights regarding WEC to clients efficiently and accurately.
  • Business Owners: Gain insights into how utility companies like WEC are valued to inform your own business strategies.
  • Finance Students: Explore valuation techniques using real-world data and scenarios related to WEC.

What the Template Contains

  • Pre-Filled DCF Model: WEC Energy Group's financial data preloaded for immediate use.
  • WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
  • Financial Ratios: Evaluate WEC Energy Group's profitability, leverage, and efficiency.
  • Editable Inputs: Change assumptions such as growth, margins, and CAPEX to fit your scenarios.
  • Financial Statements: Annual and quarterly reports to support detailed analysis.
  • Interactive Dashboard: Easily visualize key valuation metrics and results.

No products were found matching.