Skip to main content

Looking for Value, Part 3, Analysis on the Telecom Majors

Sorry I didn't get right on this after the 21st, I meant to publish this final section on the 22nd, but some life came up.

As mentioned on Tuesday, I'm going to look at Telecom Majors to see if anything looks good.  This analysis will be in three parts: an analysis on year over year growth in earnings, a quality of earnings review and valuation using Ohlson Clean Surplus.  I discussed the latter two on Seeking Alpha and published links on this blog.  For convenience the links are in this article too.

Year over Year Growth in Earnings

This calculation looks at how many years the company has been able to achieve year over year growth in its earnings per share.

What the graph below shows is the number of times the company has grown its earnings with respect to its previous year.  The maximum score is six.

T and SHEN have done fairly well with a score of four each.  What I want to check next is how reliable those earnings results are.  For that I use the quality of earnings.

Quality of Earnings

This quality of earnings measure looks at multiple factors and scores each factor with a pass (1) or a fail (0).  These scores are summed to give a grand score out of eight.  Here's how they did.

VZ - 4
T - 5
SHEN - 6
CNSL - 3
BCE - 4
ALSK - 4
ATNI - 3
CBB - 2

SHEN at six is a good score, which makes me even more confident when coupled with its good earnings growth.  But is it fairly valued or even better, under-valued?

Valuation Using OCS

The graph below charts the percentage difference between the theoretical price and the stock's current price, therefore a value above zero indicates the company is trading at a discount relative to the theoretical price.

VZ and T are the only two at a discount, the rest appear to be over-valued which unfortunately includes SHEN.


I like to sleep easy at night so I look for a number of factors to be in alignment.  I've had very good results when there is an intersection between good earnings growth, good earnings quality and a theoretical value below the actual value.

We didn't have it this time, but that's OK, it's a big world of stocks.  Maybe we'll hit on the next analysis which will be on the cannabis phenomena in Canada.


Popular posts from this blog

11 Reasons Why INVRS is Better Than Excel Alone

If you work with your own investment models you likely use excel to build them, but excel isn’t ideal for many reasons and it costs you in other ways.   First, you need good data and it isn’t just lying around in an easy to import format.   You’re either keying it in yourself or paying money for excel downloads.   When you need data from numerous sources – price information, data from different statements and across multiple years - you must merge it from multiple sheets.   It's a n inefficient process which can lead to data corruption. After all this data is collected and merged, models built and tested, the net result is one statistic for one company.   A stand-alone number without context has limited use.   To be meaningful, you need to compare it to similar companies.       This is just a sample of the challenges.  You need software that overcomes these problems and is designed for investment model creation. Surprise!  This software exists,

NextEra - Good Dividend in the Renewable Energy Sector

NextEra had good results relative to a group of peers in a factor-based analysis. NextEra has an appealing profitability and income profile. Its price momentum looks decent, with a caveat. Its relatively small size (a small mid-cap) coupled with its industry (renewable energy) further weight the odds that this company could be a strong performer in the future. If you want in on renewable energy, we recommend NextEra. The Analysis Overview I created a portfolio of stocks in the alternative energy sector, looking specifically for companies with a market cap over $1B but less than $4B.  This is a sweet spot that offers strong potential for growth but is also substantial enough not to be too speculative. It's my believe that alternative energy is on the ascendance, where as fossil fuels will inevitably decline (NextEra isn't a pure play in this regard however, natural gas assets are part of its portfolio).  If you share this belief and you want exposure to this ma

Analyzing Results - 2013/Y-6

 There were eight companies in Group 8 (no 9) in 2013/Y-6: EW  STZ LRCX ALXN MU MCHP AME DE This is how they each fared from 2014 to 2020 - the year runs from April 1 to March 31st:   EW         92%, -58%, 5%, 48%, 41%, -1% STZ        36%, 31%, 7%, 42%, -22%, -18% LRCX     27%, 10%, 57%, 60%, -6%, 32% ALXN     12%, -18%, -15%, -7%, 24%, -34% MU         11%, -61%, 162%, 82%, -17%, 0 MCHP     5%, 3%, 56%, 27%, -4%, -21% AME        1%, -4%, 9%, 42%, 12%, -14% DE           -2%, -9%, 45%, 45%, 24%, -34% Six Year Return: EW  69% STZ  81% LRCX  355% ALXN  -42% MU  72% MCHP  60% AME  42% DE  68% What score did each of the above have in 2014/Y-5? EW - 6 STZ - 8 (no 9) LRCX - 4 ALXN - 8 (no 9) MU - 6 MCHP - 5 AME - 6 DE -5 What score did each have in 2015/Y-4? EW - 5 STZ -6 LRCX - 6 ALXN -5 MU - 6 MCHP - 2 AME - 3 DE - 1 What score did each have in 2016/Y-3? EW - 8 STZ - 7 LRCX - 7 ALXN - 6 MU - 7 MCHP - 5 AME - 1 DE - 2 What score did each have in 2017/Y-2? EW - 8 STZ - 4 LRCX - 8 ALXN - 6 MU -