Valuation of SHP20 Feb 2018 12:39
How far off is Shire plc from its intrinsic value? Using the most recent financial data, I am going to take a look at whether the stock is fairly priced by estimating the company�s future cash flows and discounting them to their present value. I will use the discounted cash flows (DCF) model.
I�m using the 2-stage growth model, which simply means we take in account two stages of company�s growth. In the initial period the company may have a higher growth rate and the second stage is usually assumed to have perpetual stable growth rate. In the first stage we need to estimate the cash flows to the business over the next five years. For this I used the consensus of the analysts covering the stock. I then discount the sum of these cash flows to arrive at a present value estimate.
5-year cash flow forecast
2018 2019 2020 2021 2022
Levered FCF ($, Millions) $4,604.95 $5,298.83 $5,421.97 $5,836.44 $6,169.87
Source Analyst x11 Analyst x10 Analyst x5 Analyst x4 Analyst x4
Present Value Discounted @ 9.25% $4,214.93 $4,439.26 $4,157.70 $4,096.47 $3,963.73
Present Value of 5-year Cash Flow (PVCF)= $20,872
We now need to calculate the Terminal Value, which accounts for all the future cash flows after the five years. For a number of reasons a very conservative growth rate is used that cannot exceed that of the GDP. In this case I have used the 10-year government bond rate (1.5%). In the same way as with the 5-year �growth� period, we discount this to today�s value at a cost of equity of 9.3%.
Terminal Value (TV) = FCF2022 � (1 + g) � (r � g) = $6,170 � (1 + 1.5%) � (9.3% � 1.5%) = $80,659
Present Value of Terminal Value (PVTV) = TV / (1 + r)5 = $80,659 / ( 1 + 9.3%)5 = $51,818
The total value, or equity value, is then the sum of the present value of the cash flows, which in this case is �72,690. The last step is to then divide the equity value by the number of shares outstanding. This results in an intrinsic value of �58.32, which, compared to the current share price of �30.75, we find that Shire is quite good value at a 47.27% discount to what it is available for right now.