Ranking Table Column Information
Use this page to find definitions of all the column used in our ranking tables. Ranking Table Column Information should be used to understand what each column in the represents. Thus allowing you to better use the information presented. If you find any of the description are not clear please contact us so we can review and update the descriptions.
When reviewing the data please keep in mind the following.
- All data is based on last nights closing values.
- We update the Model at least once a day between 17:00 and 22:00 for the premium site only.
- New features are added daily and existing functionality is refined as needed.
- This is a dynamic model and the ranking results will vary daily as determined by the market action.
Definitions – Ranking Table Column Information
Symbol
- Stock Symbol as used by Google finance.
- Stock Symbol as used by TMX
- ISIN Number where available
Special codes:
$ – a $ following the Stock symbol indicates this is a US$ based preferred.
Price
Price of stock as of last closing.
52 Week High
Highest closing price for this stock for the year.
52 Week Low
Lowest closing price for this stock for the year.
Fixed Rate Base
The return yield as defined in the prospectus of this stock. For example:
- 5yr + 2.66% : rate is set based on the Government Of Canada 5yr bond + 2.66. If the 5yr is 2% the total rate is 4.66%
- 5yr MIN 5% + 3.80%. rate is the highest of the 5yr GOC bond plus 3.80% or 5.00%.
- NEGATIVE_SPREAD(>=80% OF 5YR RATE <=100%) at least 0.27%. This represents the total yield offered. In this case the full yield is a percent of the 5Year rate. I have marked it as NEGATIVE_SPREAD because the resulting yield is by definition a portion of the full 5year rate. In this case its only 80%. This is a 20% negative spread to the 5 year rate. I have only seen this structure with BCE preferrreds only. The system treats these securities as 5 year resets with a Negative_spread (Instread of adding a spread onto the 5year rate we subrtact from it ).
- FLOATING(>=80% OF PRIME RATE <=100%). The rate is calucated montlhy/quarterly and is based on PRIME. Again this the total yield offered by the security and is a discount of the PRIME RATE. In this example the next dividend will be based on the 80% of the prime rate and is determined by the company a number of days before as described in the prospectus. Some of the BCE, Brookfield and Power Financial. You can see the complete list at list-of-floating-rate-preferred-stocks
Current (Yield | Dividend)
Represents the yield and dividend for the current issue based on last night’s closing stock price. The yield fluctuates with stock price. The dividend is fixed for the current period.
Reset (Yield | Dividend)
Represents the yield and dividend for the current issue after the upcoming reset. For this calculation it’s assumed the key rates are going to be the same as today’s published rates. The reset yield is the sum of the key rate for the base term (5YR, 3Month, etc) plus the published spread. Since we do not know what the key rate will be at the time of the reset we assume its going to be the same as today. The ability to use a different set of rates during this caclulation is planned for a future release.
Yield To Call
Represents the average yearly yield % for the duration of the term assuming the preferred is called at face value at the end of the current term.
The formula used is explained at “Yield To Maturity” .
Blended (Yield | Dividend)
This is a “What If” scenario. It represents the blended yield and dividend for the current issue. It should only be used as a reference. It is not meant to show actual returns for Yield/Dividend. This metric has merit only when applied across all issues being considered. To calculate the blended values the model makes the following assumptions.
- The period used is 5 years. Some based on the Current Yield and the rest based on the Reset Yield.
- 20 dividend payments are used for quarterly and 60 for monthly.
- Assumes you hold prior to the Ex-Dividend date.
- Within the 5 years yield and dividend will reset at most once, on the reset date.
- Dividend till reset date is known and fixed, as shown in column “Current (Yield|Dividend)“. Dividend from reset date and for the remainder of the 5 year term period is a projection based on.
- 5YR GOC rate is assumed to be the same as today’s rate. The “Reset Scenarios Based on Various G.O.C. 5 Year Bond Yield Rates” tool, shows an additional 5 variations of the blended rate based on 5 different “5YR GOC” rates.
- New dividend = $25 * ( 5YR GOC + shares additional rate). Same as shown in column “Reset (Yield | Dividend)“
- The Blended Yield is calculated as follows
- PreResetDividendAmount = sum of all dividends from now till reset date based on current dividend.
- PostResetDividendAmount = sum of all (projected)dividends from reset date till the end of the current 5 year period.
- Total5YearDividendAmount = PreResetDividendAmount + PostResetDividendAmount.
- Blended yield = (Total5YearDividendAmount / today’s share price) / 5
- Blended dividend = Total5YearDividendAmount / 5
Blended Rate metric should be used when comparing how a share is expected to perform in the next 5 years under a predefined “What If” scenario. Allows you to project performance of shares in uniform so picking the one with best expectations is more clear. It can be used to hi-lite how the current issue will perform relative to it’s peers. We present a total of 6 variations of “Blended (Yield/Dividend)” metric based on 6 different “5YR GOC” rates.
Please review the comments below for additional information on this metric.
Reset Date
The date of the upcoming reset for this issue. During the reset the new dividend will be determined by the issuer as outlined in the prospectus.
Rate Increase ( percent| to value )
This reflects the effect or the current price on the issue rate of the preferred. In column “Fixed Rate Base” you see the issue rate. Here you see the effective new rate of the share due to its drop or rise of its share value. The second part in this column shows the percent increase/decrease of the new rate. A detailed explanation of this metric is presented in How To Find Undervalued Preferred Stocks
In the premium version this metric has been taken apart. Two column are used one for the percent and one for the value. This way you can now sort the table on ‘Rate Increase Value’ or ‘Rate Increase Percent’
New Spread (%Increase | value)
This reflects the effect or the current price on the issue spread of the preferred. In column “Fixed Rate Base” you see the issue spread. Here in the second part you see the effective new spread of the share due to its drop or rise of its share value. The first part in this column shows the percent increase/decrease of the new spread. A mored detailed explanation of this metric is presented in How To Find Undervalued Preferred Stocks
In the premium version this metric has been taken apart. Two column are used one for the percent and one for the value. This way you can now sort the table on ‘New Spread Value’ or ‘New Spread Percent’
Additional Features
Displays codes for additional feature of the preferred share
- Cumul – Share is Cumulative
- Non C – Share is Non Cumulative.
- DTCEPI – DividendTaxCreditEligibilityPotentialIssues – Distribution may consist of a combination of dividend, income and return of capital and therefore may not be entirely eligible for the dividend tax credit. Please consult a tax professional for further information.
- ACTSWHC – Automatic Conversion To Common Stock Up On Occurrence of a Trigger Event Without Consent of Holder.
- SSDPT – Split-Share preferred dividend only paid if NAV is above threshold value. See notes on the homepage for this security.
Metric only available in the Premium Version.
Years To Double Initial Investment
How many years will it take for the initial investment to double. This is a simple calculation based on the following assumptions.
- The rate used for all years, in the calculation, is based on the “Current (Yield | Dividend)”.
- Dividends are re invested annually at the end of the year. And the purchase price of the units is same as the current price “Price”
- No Increase / decrease to the share price. Not a likely scenario but for this metric we have to assume the share price remains unchanged.
For perpetuals this calculation is quite close to what you can expect, if you could re invest the dividends into the same issue at a price close to the current price. For resets and floating issues this is not going to be anywhere close to reality. Just use this as a reference only. Its the same formula used to show the power of compound interest. In this case, Instead of interest we use the dividends.
P/E Ratio
Common Stock Price to Earning Ratio
Market Cap In Billions
The company Market Cap.
P/B Ratio
Common Stock Price to Book Ratio.
Available in Premium Version Only.
Common Stock Yield
Common Stock Dividend Yield.
Available in Premium Version Only.
Projected Common Stock Yield
This is the 5 year average yield of the common stock. It is based on the previous 5 year history of common dividend increases. The same rate of increased is projected for the next 5 years. Use this yield to compare against the preferreds blended yield.
Name
Full name of the preferred as found in the prospectus.