Discounted Cash Flow (DCF) Analysis Unlevered

Hudbay Minerals Inc. (HBM)

$4.77

+0.35 (+7.92%)
All numbers are in Millions, Currency in USD
Stock DCF: -3.95 | 4.77 | overvalue

Operating Data

Year
A/P
2018
Actual
2019
Actual
2020
Actual
2021
Actual
2022
Actual
2023
Projected
2024
Projected
2025
Projected
2026
Projected
2027
Projected
Revenue 1,472.371,237.441,092.421,5021,461.441,487.441,513.911,540.851,568.271,596.17
Revenue (%)
EBITDA 573.28-33.36270.77231.76502.54329.75335.61341.58347.66353.85
EBITDA (%)
EBIT 240.13-380-92.83-128163.48-60.19-61.26-62.35-63.46-64.59
EBIT (%)
Depreciation 333.14346.63363.60359.77339.06389.94396.88403.94411.12418.44
Depreciation (%)

Balance Sheet Data

Year
A/P
2018
Actual
2019
Actual
2020
Actual
2021
Actual
2022
Actual
2023
Projected
2024
Projected
2025
Projected
2026
Projected
2027
Projected
Total Cash 515.50396.15439.13270.99225.66418.59426.03433.62441.33449.18
Total Cash (%)
Account Receivables 119.16113.28153.64204.08122.33158.47161.29164.16167.09170.06
Account Receivables (%)
Inventories 118.47138.82143.11158.45155.01159.22162.05164.94167.87170.86
Inventories (%)
Accounts Payable 61.3968.74104.6084.2883.8291.1792.7994.4496.1297.84
Accounts Payable (%)
Capital Expenditure -190.90-259.20-361.18-377.43-308.96-336.89-342.88-348.99-355.20-361.52
Capital Expenditure (%)

Weighted Average Cost Of Capital

Share price $ 4.77
Beta 1.970
Diluted Shares Outstanding 261.46
Cost of Debt
Tax Rate 26.54
After-tax Cost of Debt 3.99%
Risk-Free Rate
Market Risk Premium
Cost of Equity 13.037
Total Debt 1,245.18
Total Equity 1,247.18
Total Capital 2,492.36
Debt Weighting 49.96
Equity Weighting 50.04
Wacc

Build Up Free Cash

Year
A/P
2018
Actual
2019
Actual
2020
Actual
2021
Actual
2022
Actual
2023
Projected
2024
Projected
2025
Projected
2026
Projected
2027
Projected
Revenue 1,472.371,237.441,092.421,5021,461.441,487.441,513.911,540.851,568.271,596.17
EBITDA 573.28-33.36270.77231.76502.54329.75335.61341.58347.66353.85
EBIT 240.13-380-92.83-128163.48-60.19-61.26-62.35-63.46-64.59
Tax Rate 50.00%24.06%19.27%-20.52%26.54%19.87%19.87%19.87%19.87%19.87%
EBIAT 120.06-288.55-74.95-154.27120.08-48.23-49.09-49.96-50.85-51.76
Depreciation 333.14346.63363.60359.77339.06389.94396.88403.94411.12418.44
Accounts Receivable -5.88-40.36-50.4481.75-36.14-2.82-2.87-2.92-2.97
Inventories --20.35-4.28-15.353.44-4.21-2.83-2.88-2.93-2.99
Accounts Payable -7.3535.86-20.32-0.457.351.621.651.681.71
Capital Expenditure -190.90-259.20-361.19-377.43-308.96-336.89-342.88-348.99-355.20-361.52
UFCF 262.31-208.24-81.32-258.04234.92-28.180.870.890.900.92
WACC
PV UFCF -25.970.740.690.650.61
SUM PV UFCF -23.28

Terminal Value

Growth in perpetuity method:
Long-term growth rate
WACC (%) 8.52
Free cash flow (t + 1) 0.94
Terminal Value 14.37
Present Value of Terminal Value 9.55

Intrinsic Value

Enterprise Value -13.73
Net Debt 1,019.52
Equity Value -1,033.24
Shares Outstanding 261.46
Equity Value Per Share -3.95