MGE Energy, Inc. (MGEE) DCF Valuation

MGE Energy, Inc. (MGEE) 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

MGE Energy, Inc. (MGEE) 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:

Simplify MGE Energy, Inc. (MGEE) valuation with this customizable DCF Calculator! Featuring real MGE Energy, Inc. (MGEE) financials and adjustable forecast inputs, you can test scenarios and uncover MGE Energy, Inc. (MGEE) fair value in minutes.


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 568.9 538.6 606.6 714.5 690.4 727.9 767.5 809.2 853.1 899.4
Revenue Growth, % 0 -5.31 12.62 17.79 -3.37 5.43 5.43 5.43 5.43 5.43
EBITDA 201.3 209.6 211.0 249.4 276.3 267.9 282.4 297.7 313.9 331.0
EBITDA, % 35.38 38.9 34.78 34.9 40.02 36.8 36.8 36.8 36.8 36.8
Depreciation 71.6 74.2 77.0 85.5 100.4 95.4 100.6 106.1 111.8 117.9
Depreciation, % 12.58 13.77 12.69 11.97 14.53 13.11 13.11 13.11 13.11 13.11
EBIT 129.7 135.4 134.0 163.8 175.9 172.4 181.8 191.7 202.1 213.0
EBIT, % 22.8 25.13 22.09 22.93 25.48 23.69 23.69 23.69 23.69 23.69
Total Cash 23.5 44.7 17.4 11.6 11.1 27.0 28.5 30.0 31.6 33.4
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 74.3 76.2 97.1 109.9 95.5
Account Receivables, % 13.07 14.15 16.01 15.38 13.84
Inventories 45.3 47.3 52.0 74.3 72.6 67.3 70.9 74.8 78.9 83.1
Inventories, % 7.96 8.77 8.57 10.4 10.52 9.24 9.24 9.24 9.24 9.24
Accounts Payable 55.2 54.6 64.1 59.3 65.5 70.2 74.0 78.0 82.2 86.7
Accounts Payable, % 9.7 10.14 10.58 8.3 9.48 9.64 9.64 9.64 9.64 9.64
Capital Expenditure -164.0 -203.1 -153.2 -175.0 -222.1 -216.1 -227.9 -240.3 -253.3 -267.1
Capital Expenditure, % -28.84 -37.71 -25.25 -24.5 -32.16 -29.69 -29.69 -29.69 -29.69 -29.69
Tax Rate, % 19.11 19.11 19.11 19.11 19.11 19.11 19.11 19.11 19.11 19.11
EBITAT 106.7 111.9 129.0 132.5 142.3 145.8 153.8 162.1 170.9 180.2
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF -50.2 -21.5 36.7 3.1 42.7 25.3 20.9 22.1 23.3 24.5
WACC, % 7.01 7.01 7.12 6.99 6.99 7.02 7.02 7.02 7.02 7.02
PV UFCF
SUM PV UFCF 95.1
Long Term Growth Rate, % 3.00
Free cash flow (T + 1) 25
Terminal Value 628
Present Terminal Value 447
Enterprise Value 542
Net Debt 769
Equity Value -227
Diluted Shares Outstanding, MM 36
Equity Value Per Share -6.26

What You Will Get

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

Key Features

  • Accurate MGE Energy Financials: Access reliable pre-loaded historical data and future forecasts.
  • Customizable Forecast Assumptions: Modify highlighted cells for metrics such as WACC, growth rates, and profit margins.
  • Dynamic Calculations: Automatic updates for DCF, Net Present Value (NPV), and cash flow analysis.
  • Visual Dashboard: User-friendly charts and summaries to help visualize your valuation outcomes.
  • For All Skill Levels: An intuitive design tailored for investors, CFOs, and consultants alike.

How It Works

  1. Step 1: Download the Excel file.
  2. Step 2: Review pre-entered MGE Energy data (historical and projected).
  3. Step 3: Adjust key assumptions (yellow cells) based on your analysis.
  4. Step 4: View automatic recalculations for MGE Energy’s intrinsic value.
  5. Step 5: Use the outputs for investment decisions or reporting.

Why Choose This Calculator?

  • Designed for Industry Experts: A sophisticated tool utilized by energy analysts, CFOs, and consultants.
  • Accurate Data: MGE Energy’s historical and projected financials preloaded for precision.
  • Scenario Analysis: Effortlessly simulate various forecasts and assumptions.
  • Comprehensive Outputs: Automatically computes intrinsic value, NPV, and essential metrics.
  • User-Friendly: Step-by-step guidance to navigate through the calculations.

Who Should Use This Product?

  • Individual Investors: Make informed decisions about buying or selling MGE Energy, Inc. (MGEE) stock.
  • Financial Analysts: Streamline valuation processes with ready-to-use financial models for MGE Energy, Inc. (MGEE).
  • Consultants: Deliver professional valuation insights on MGE Energy, Inc. (MGEE) to clients quickly and accurately.
  • Business Owners: Understand how utility companies like MGE Energy, Inc. (MGEE) are valued to guide your own strategy.
  • Finance Students: Learn valuation techniques using real-world data and scenarios related to MGE Energy, Inc. (MGEE).

What the Template Contains

  • Pre-Filled Data: Includes MGE Energy’s historical financials and forecasts.
  • Discounted Cash Flow Model: Editable DCF valuation model with automatic calculations.
  • Weighted Average Cost of Capital (WACC): A dedicated sheet for calculating WACC based on custom inputs.
  • Key Financial Ratios: Analyze MGE Energy’s profitability, efficiency, and leverage.
  • Customizable Inputs: Edit revenue growth, margins, and tax rates with ease.
  • Clear Dashboard: Charts and tables summarizing key valuation results.

No products were found matching.