Discounted Cash Flow (DCF) Analysis Unlevered

Jaguar Mining Inc. (JAG.TO)

$1.31

-0.02 (-1.50%)
All numbers are in Millions, Currency in USD
Stock DCF: 0.59 | 1.31 | 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 94.9297.23160.25151.47142.50162.40185.07210.91240.35273.91
Revenue (%)
EBITDA 21.5328.9190.6469.1440.8159.5267.8377.3088.09100.39
EBITDA (%)
EBIT 2.1714.3375.4847.9820.5635.8040.8046.5052.9960.39
EBIT (%)
Depreciation 19.3614.5715.1621.1620.2523.7227.0330.8035.1040
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 6.2710.9238.9140.3725.2128.0832.0136.4741.5747.37
Total Cash (%)
Account Receivables ----------
Account Receivables (%)
Inventories 12.1412.7012.5314.5516.2417.7520.2323.0626.2829.95
Inventories (%)
Accounts Payable 11.7410.3711.6410.3914.2215.3117.4519.8822.6625.82
Accounts Payable (%)
Capital Expenditure -28.99-32.23-34.75-34.23-44.16-45.14-51.44-58.62-66.80-76.13
Capital Expenditure (%)

Weighted Average Cost Of Capital

Share price $ 1.31
Beta 1.001
Diluted Shares Outstanding 73.50
Cost of Debt
Tax Rate 20.20
After-tax Cost of Debt 29.41%
Risk-Free Rate
Market Risk Premium
Cost of Equity 9.165
Total Debt 7
Total Equity 96.28
Total Capital 103.29
Debt Weighting 6.78
Equity Weighting 93.22
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 94.9297.23160.25151.47142.50162.40185.07210.91240.35273.91
EBITDA 21.5328.9190.6469.1440.8159.5267.8377.3088.09100.39
EBIT 2.1714.3375.4847.9820.5635.8040.8046.5052.9960.39
Tax Rate -0.26%120.47%16.74%18.84%20.20%35.20%35.20%35.20%35.20%35.20%
EBIAT 2.18-2.9362.8538.9416.4123.2026.4430.1334.3439.13
Depreciation 19.3614.5715.1621.1620.2523.7227.0330.8035.1040
Accounts Receivable ----------
Inventories --0.560.17-2.02-1.69-1.52-2.48-2.82-3.22-3.67
Accounts Payable --1.381.27-1.253.831.092.142.442.783.16
Capital Expenditure -28.99-32.23-34.75-34.23-44.16-45.14-51.44-58.62-66.80-76.13
UFCF -7.46-22.5344.6922.60-5.371.361.691.922.192.50
WACC
PV UFCF 1.231.381.421.471.51
SUM PV UFCF 7.02

Terminal Value

Growth in perpetuity method:
Long-term growth rate
WACC (%) 10.54
Free cash flow (t + 1) 2.55
Terminal Value 29.86
Present Value of Terminal Value 18.09

Intrinsic Value

Enterprise Value 25.11
Net Debt -18.20
Equity Value 43.31
Shares Outstanding 73.50
Equity Value Per Share 0.59