RE: Simply wall street12 Jul 2020 10:58
Here's the details..Worth a look at simply wall st. Data from there site. Its a 10 year projection I think. Not always up to date with latest info but I find it a great place to find undervalued plays.
Below are the data sources, inputs and calculation used to determine the intrinsic value for Eurasia Mining.
AIM:EUA Discounted Cash Flow Data Sources
Data Point Source Value
Valuation Model 2 Stage Free Cash Flow to Equity
Levered Free Cash Flow Average of 1 Analyst Estimates (S&P Global) See below
Discount Rate (Cost of Equity) See below 7.8%
Perpetual Growth Rate 10-Year GB Government Bond Rate 1.2%
An important part of a discounted cash flow is the discount rate, below we explain how it has been calculated.
Calculation of Discount Rate/ Cost of Equity for AIM:EUA
Data Point Calculation/ Source Result
Risk-Free Rate 10-Year GB Govt Bond Rate 1.2%
Equity Risk Premium S&P Global 6.9%
Metals and Mining Unlevered Beta Simply Wall St/ S&P Global 0.92
Re-levered Beta = 0.33 + [(0.66 * Unlevered beta) * (1 + (1 - tax rate) (Debt/Market Equity))]
= 0.33 + [(0.66 * 0.919) * (1 + (1 - 19.0%) (0.01%))] 0.946
Levered Beta Levered Beta limited to 0.8 to 2.0
(practical range for a stable firm) 0.946
Discount Rate/ Cost of Equity = Cost of Equity = Risk Free Rate + (Levered Beta * Equity Risk Premium)
= 1.22% + (0.946 * 6.92%) 7.76%
Discounted Cash Flow Calculation for AIM:EUA using 2 Stage Free Cash Flow to Equity
The calculations below outline how an intrinsic value for Eurasia Mining is arrived at by discounting future cash flows to their present value using the 2 stage method. We use analyst's estimates of cash flows going forward 5 years for the 1st stage, the 2nd stage assumes the company grows at a stable rate into perpetuity.
AIM:EUA DCF 1st Stage: Next 5 year cash flow forecast
Levered FCF (GBP, Millions) Source Present Value
Discounted (@ 7.76%)
2021 236.2 Analyst x1 219.18
2022 430.98 Est @ 82.47% 371.11
2023 681.35 Est @ 58.09% 544.43
2024 960.91 Est @ 41.03% 712.5
2025 1,240.42 Est @ 29.09% 853.49
2026 1,497.52 Est @ 20.73% 956.15
2027 1,720.28 Est @ 14.88% 1,019.25
2028 1,905.7 Est @ 10.78% 1,047.76
2029 2,056.47 Est @ 7.91% 1,049.19
2030 2,177.87 Est @ 5.9% 1,031.07
Present value of next 5 years cash flows £7,804
AIM:EUA DCF 2nd Stage: Terminal Value
Calculation Result
Terminal Value FCF2030 × (1 + g) ÷ (Discount Rate – g)
= £2,177.873 x (1 + 1.22%) ÷ (7.76% - 1.22% ) £33,685.79
Present Value of Terminal Value = Terminal Value ÷ (1 + r)10
£33,686 ÷ (1 + 7.76%)10 £15,947.93
AIM:EUA Total Equity Value
Calculation Result
Total Equity Value = Present value of next 10 years cash flows + Terminal Value
= £7,804 + £15,948 £23,751.93
Equity Value per Share
(GBP) = Total value / Shares Outstanding
= £23,752 / 2,725 £8.72
AIM:EUA Discount to Share Price
Calculation Result
Value per share (GBP) From above. £8.72
Current discount Discount to share price of £0.17
= -1 x (£0.17 - £8.72) / £8.72