Comcast (CMCSA) Fair Value & DCF
Score
CMCSA fair value $46.28. Price $25.16. Price is 46% below fair value.
Worked example
Cash-flow value. Starting free cash flow is $4.82 a share. Year 1 is the first earnings forecast, so it has no growth rate of its own. The forecast then reaches 12.06%, and that pace fades in a straight line to 3% terminal growth by year 10. The discount rate is 8.70% (beta 0.80). It is beta-adjusted and capped at 12%. The cash-flow value is $48.52 a share.
Earnings value. Next-twelve-months earnings per share of $3.38 times 13.03 is $44.04. The peer group is Telecommunications Services, 9 companies worth at least $10 billion. Peer median 11.6. Own 10-year median 14.4. The multiple used is the average of the two, kept between 8 and 30, which is 13.03.
Fair value is the average of the two, $46.28. The price is $25.16, which is 45.6% below fair value.