Black Hills Corporation (BKH) DCF Valuation

Black Hills Corporation (BKH) DCF Valuation

US | Utilities | Diversified Utilities | NYSE
Black Hills Corporation (BKH) DCF Valuation
  • ✓ Totalmente Editável: Adapte-Se Às Suas Necessidades No Excel Ou Planilhas
  • ✓ Design Profissional: Modelos Confiáveis ​​E Padrão Da Indústria
  • ✓ Pré-Construídos Para Uso Rápido E Eficiente
  • ✓ Não É Necessária Experiência; Fácil De Seguir

Black Hills Corporation (BKH) Bundle

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

TOTAL:

Explore Black Hills Corporation's (BKH) financial outlook with our user-friendly DCF Calculator! Enter your assumptions regarding growth, margins, and costs to calculate the intrinsic value of Black Hills Corporation (BKH) and refine your investment approach.


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 1,734.9 1,696.9 413.9 458.5 2,331.3 2,523.5 2,731.5 2,956.7 3,200.5 3,464.3
Revenue Growth, % 0 -2.19 -75.61 10.78 408.46 8.24 8.24 8.24 8.24 8.24
EBITDA 614.9 649.8 645.6 706.6 735.5 1,540.8 1,667.8 1,805.3 1,954.1 2,115.3
EBITDA, % 35.45 38.29 155.99 154.11 31.55 61.06 61.06 61.06 61.06 61.06
Depreciation 209.1 224.5 236.0 250.9 256.8 747.1 808.7 875.4 947.5 1,025.6
Depreciation, % 12.05 13.23 57.01 54.72 11.02 29.61 29.61 29.61 29.61 29.61
EBIT 405.8 425.4 409.7 455.7 478.7 1,349.4 1,460.6 1,581.0 1,711.4 1,852.5
EBIT, % 23.39 25.07 98.98 99.39 20.53 53.47 53.47 53.47 53.47 53.47
Total Cash 9.8 6.4 8.9 21.4 86.6 57.9 62.7 67.9 73.5 79.6
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 272.3 285.4 339.7 508.2 368.8
Account Receivables, % 15.69 16.82 82.07 110.84 15.82
Inventories 117.2 117.4 151.0 207.4 160.9 516.3 558.8 604.9 654.8 708.7
Inventories, % 6.75 6.92 36.48 45.24 6.9 20.46 20.46 20.46 20.46 20.46
Accounts Payable 193.5 183.3 217.8 310.0 186.4 758.0 820.5 888.1 961.3 1,040.6
Accounts Payable, % 11.15 10.8 52.61 67.62 8 30.04 30.04 30.04 30.04 30.04
Capital Expenditure -818.4 -767.4 -677.5 -604.4 -555.6 -1,596.0 -1,727.6 -1,870.0 -2,024.2 -2,191.0
Capital Expenditure, % -47.17 -45.22 -163.68 -131.81 -23.83 -63.25 -63.25 -63.25 -63.25 -63.25
Tax Rate, % 13.06 13.06 13.06 13.06 13.06 13.06 13.06 13.06 13.06 13.06
EBITAT 332.8 351.4 375.1 397.8 416.2 1,161.6 1,257.4 1,361.1 1,473.3 1,594.7
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF -472.3 -215.1 -119.8 -88.4 179.7 -265.1 262.6 284.2 307.7 333.0
WACC, % 5.53 5.55 5.76 5.66 5.65 5.63 5.63 5.63 5.63 5.63
PV UFCF
SUM PV UFCF 726.0
Long Term Growth Rate, % 2.00
Free cash flow (T + 1) 340
Terminal Value 9,364
Present Terminal Value 7,121
Enterprise Value 7,847
Net Debt 4,315
Equity Value 3,533
Diluted Shares Outstanding, MM 67
Equity Value Per Share 52.65

What You Will Get

  • Editable Forecast Inputs: Easily modify assumptions (growth %, margins, WACC) to generate various scenarios.
  • Real-World Data: Black Hills Corporation’s (BKH) financial data pre-loaded to facilitate your analysis.
  • Automatic DCF Outputs: The template computes Net Present Value (NPV) and intrinsic value for you.
  • Customizable and Professional: A refined Excel model that adjusts to your valuation requirements.
  • Built for Analysts and Investors: Perfect for evaluating projections, confirming strategies, and enhancing efficiency.

Key Features

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

How It Works

  • Step 1: Download the prebuilt Excel template featuring Black Hills Corporation’s (BKH) data.
  • Step 2: Navigate through the pre-filled sheets and familiarize yourself with the essential metrics.
  • Step 3: Modify forecasts and assumptions in the editable yellow cells (WACC, growth, margins).
  • Step 4: Instantly view the recalibrated results, including Black Hills Corporation’s (BKH) intrinsic value.
  • Step 5: Make well-informed investment decisions or create reports based on the outputs.

Why Choose This Calculator for Black Hills Corporation (BKH)?

  • Accurate Data: Utilizes real Black Hills Corporation financials for dependable valuation outcomes.
  • Customizable: Tailor essential parameters such as growth rates, WACC, and tax rates to align with your forecasts.
  • Time-Saving: Ready-made calculations streamline the process, so you don’t have to start from square one.
  • Professional-Grade Tool: Crafted for investors, analysts, and consultants focused on Black Hills Corporation.
  • User-Friendly: Easy-to-navigate design and clear instructions cater to users of all experience levels.

Who Should Use This Product?

  • Investors: Accurately assess Black Hills Corporation's (BKH) fair value prior to making investment choices.
  • CFOs: Utilize a professional-grade DCF model for financial reporting and analysis specific to Black Hills Corporation (BKH).
  • Consultants: Easily modify the template for valuation reports tailored to clients interested in Black Hills Corporation (BKH).
  • Entrepreneurs: Acquire knowledge about financial modeling practices employed by leading companies like Black Hills Corporation (BKH).
  • Educators: Implement it as a teaching resource to illustrate valuation methodologies using Black Hills Corporation (BKH) as a case study.

What the Template Contains

  • Operating and Balance Sheet Data: Pre-filled Black Hills Corporation (BKH) historical data and forecasts, including revenue, EBITDA, EBIT, and capital expenditures.
  • WACC Calculation: A dedicated sheet for Weighted Average Cost of Capital (WACC), including parameters like Beta, risk-free rate, and share price.
  • DCF Valuation (Unlevered and Levered): Editable Discounted Cash Flow models showing intrinsic value with detailed calculations.
  • Financial Statements: Pre-loaded financial statements (annual and quarterly) to support analysis.
  • Key Ratios: Includes profitability, leverage, and efficiency ratios for Black Hills Corporation (BKH).
  • Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.

No products were found matching.