Skip to main content

Dividend Analysis Framework

Dividend Analysis Framework Using INVRS

Passive Income
A dividend investing framework for creating passive income.

A complete dividend analysis can be easily conducted in INVRS.  Some set up is required, but once complete you can run the analysis at will, with only small tweaks necessary to reflect your personal preferences and changing market conditions.

1. Canadian Analysis:  Use INVRS to calculate the current dividend yield of the TSX 60 (average dividend yield of the 60 member stocks).  US analysis: Use INVRS to calculate the average dividend yield of the 500 member stocks.

More details:
  1. Create a portfolio of the 60 Canadian companies and/or a portfolio of the 500 US Companies.  
  2. Create a template using the dividend yield metric of your choice.  Options are Dividend Yield Daily (dividends per share / most recent last close price), Forward Dividend Yield (this is a calculation you create - choose the Dividend Rate (most recent dividend multiplied by the number of times the company pays a dividend) and divide by the Current Price,Dividend  Yield Fiscal or Dividend Yield Security (latter two are calculated using the fiscal period end price).  I like Dividend Yield Daily.
  3. Click "Add/Update Formula" and write avg(A), which will give you the average dividend yield of all the stocks in the portfolio.
  4. Run the portfolio against the template to get the average.
2. Create a screen to identify all Canadian or US companies in the following dividend yield range:
  • Floor: 1 to 1.5 x the average dividend yield
  • Ceiling: 5 x the average dividend yield
More details:
Add two separate filters.  The first greater than 1.5 x the average dividend yield and the other less than 5 x the average dividend yield.  You may wish to use the same dividend yield as you used for the market average.

3. Run the screen and add the candidates to a portfolio.  

4.  The portfolio is further screened to exclude securities that have not experienced at least 5 consecutive years of dividend growth.

More details:
Create a template with five years (Y to Y-5) of dividends per share data.  Write five "if" formulea that assigns the value "1" if the dividends per share is greater than the year previous to it and "0" otherwise (eg. if(A>B,1,0)).  Sum the score of the five "if" statements and if the sum is less than five remove the stock from the portfolio.

5. From this group, the following characteristics are examined:
  • Dividend coverage - calculated as the quotient of dividends per share and free cash flow per share, the sweet spot is greater than zero and less than 75%.
  • Forward dividend yield is greater than the five year average.  This is our valuation proxy and can be calculated by dividing the forward dividend yield by the five year average dividend yield.  If is greater than one, then the it qualifies.
  • Total yield - calculated as the sum of the forward dividend yield and the five year growth rate, however look also at the growth trend.  Is it declining, constant or accelerating?  If it is declining significantly, the 5 year growth rate might not be appropriate.  The total yield number is a matter of preference.  The highest total yield possible might not be ideal, as very high yields indicate greater risk.  The sweet spot may be between 9% and 16%.
You are looking for companies that check the boxes on all three characteristics.  If they do, they are good options for your dividend portfolio.


I wish to thank David Solyomi, author, economist and dividend investor.  His website is The Falcon Method.   I learned these concepts from him, any errors in interpretation are my own.


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 -