Harmony Gold Mining Company Limited (HMY) DCF Valuation

Harmony Gold Mining Company Limited (HMY) 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

Harmony Gold Mining Company Limited (HMY) 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:

Enhance your investment strategies with the Harmony Gold Mining Company Limited (HMY) DCF Calculator! Utilize real financial data, adjust growth projections and expenses, and observe how these modifications affect the intrinsic value of Harmony Gold Mining Company Limited (HMY) in real-time.


Discounted Cash Flow (DCF) - (USD MM)

Year AY1
2020		 AY2
2021		 AY3
2022		 AY4
2023		 AY5
2024		 FY1
2025		 FY2
2026		 FY3
2027		 FY4
2028		 FY5
2029
Revenue 1,565.7 2,234.2 2,283.1 2,638.0 3,286.0 3,984.3 4,830.9 5,857.5 7,102.2 8,611.3
Revenue Growth, % 0 42.7 2.19 15.55 24.56 21.25 21.25 21.25 21.25 21.25
EBITDA 128.7 233.0 179.0 427.2 921.3 563.5 683.2 828.4 1,004.5 1,217.9
EBITDA, % 8.22 10.43 7.84 16.19 28.04 14.14 14.14 14.14 14.14 14.14
Depreciation 190.3 207.6 197.2 184.9 248.5 355.8 431.4 523.1 634.3 769.1
Depreciation, % 12.16 9.29 8.64 7.01 7.56 8.93 8.93 8.93 8.93 8.93
EBIT -61.6 25.4 -18.2 242.3 672.7 207.7 251.8 305.3 370.2 448.8
EBIT, % -3.94 1.14 -0.79728 9.18 20.47 5.21 5.21 5.21 5.21 5.21
Total Cash 340.3 150.9 131.1 153.5 253.3 380.6 461.5 559.5 678.4 822.6
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 65.8 6.2 5.5 118.1 120.4
Account Receivables, % 4.2 0.27707 0.24243 4.48 3.66
Inventories 129.6 136.1 150.9 174.8 192.9 266.7 323.4 392.1 475.5 576.5
Inventories, % 8.28 6.09 6.61 6.63 5.87 6.69 6.69 6.69 6.69 6.69
Accounts Payable 37.8 67.9 67.8 64.5 60.9 101.4 122.9 149.0 180.7 219.1
Accounts Payable, % 2.41 3.04 2.97 2.45 1.85 2.54 2.54 2.54 2.54 2.54
Capital Expenditure -11.1 -275.3 -332.7 -409.0 -449.6 -452.5 -548.7 -665.3 -806.7 -978.1
Capital Expenditure, % -0.7111 -12.32 -14.57 -15.5 -13.68 -11.36 -11.36 -11.36 -11.36 -11.36
Tax Rate, % 27.04 27.04 27.04 27.04 27.04 27.04 27.04 27.04 27.04 27.04
EBITAT -90.9 19.2 -18.1 176.8 490.8 174.8 211.9 256.9 311.5 377.7
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF -69.4 34.7 -167.9 -187.1 265.7 62.6 37.7 45.8 55.5 67.3
WACC, % 10.89 10.69 10.89 10.67 10.67 10.76 10.76 10.76 10.76 10.76
PV UFCF
SUM PV UFCF 198.1
Long Term Growth Rate, % 2.00
Free cash flow (T + 1) 69
Terminal Value 783
Present Terminal Value 470
Enterprise Value 668
Net Debt -129
Equity Value 796
Diluted Shares Outstanding, MM 630
Equity Value Per Share 1.26

What You Will Receive

  • Pre-Filled Financial Model: Harmony Gold's actual data enables accurate DCF valuation.
  • Full Forecast Control: Modify production levels, cost structures, discount rates, and other essential factors.
  • Instant Calculations: Real-time updates provide immediate feedback as you adjust inputs.
  • Investor-Ready Template: A polished Excel file crafted for high-quality valuation presentations.
  • Customizable and Reusable: Designed for adaptability, allowing for repeated use in comprehensive forecasts.

Key Features

  • Comprehensive Data: Harmony Gold's historical financial reports and pre-filled projections.
  • Customizable Parameters: Modify WACC, tax rates, production growth, and EBITDA margins.
  • Real-Time Insights: View Harmony Gold's intrinsic value update instantly.
  • Visual Representation: Dashboard graphs illustrate valuation outcomes and essential metrics.
  • Designed for Precision: A professional-grade tool for analysts, investors, and finance professionals.

How It Works

  1. Step 1: Download the Excel file for Harmony Gold Mining Company Limited (HMY).
  2. Step 2: Review the pre-filled financial data and forecasts for Harmony Gold.
  3. Step 3: Adjust key inputs such as gold production, operating costs, and tax rates (highlighted cells).
  4. Step 4: Observe the DCF model update in real-time as you modify your assumptions.
  5. Step 5: Evaluate the outputs and leverage the results for your investment strategies.

Why Choose This Calculator?

  • User-Friendly Interface: Perfect for both novices and seasoned professionals.
  • Customizable Inputs: Easily adjust parameters to suit your specific analysis.
  • Real-Time Feedback: Monitor immediate changes to Harmony Gold Mining’s valuation as you tweak inputs.
  • Preloaded Data: Comes with Harmony Gold's actual financial figures for swift evaluations.
  • Preferred by Experts: Utilized by investors and analysts for making well-informed choices.

Who Should Use This Product?

  • Investors: Assess Harmony Gold Mining Company's (HMY) market value before making investment decisions.
  • CFOs and Financial Analysts: Optimize valuation processes and evaluate future projections for mining operations.
  • Mining Executives: Understand how major mining companies like Harmony Gold are valued in the industry.
  • Consultants: Provide comprehensive valuation reports tailored for clients in the mining sector.
  • Students and Educators: Utilize industry-specific data to teach and practice valuation methodologies.

What the Template Contains

  • Preloaded HMY 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.

No products were found matching.