Value investing toolkitHello Investors! This educational post is about my toolkit developed for filtering out the almost perfect applicants for further analysis and research in the light of the principals of value investing. The work is based upon Warren Buffett's principals, calculations and recomendations.
After publishing my two previous posts on the "Value investing chart set" and the "Intrinsic value calculation" I have received a lots of positive comments and feedbacks. Alongside the encouraging comments I have received quite a lots of requests to share the chart layout and the other scripts I am using while compiling the chart set I have introduced. I have promised to further develope both tools and come up with an even more powerfull toolkit.
Now it is here! :-) I have combined the already published Intrinsic value calculation script with the Value investing chart set and further developed both on the way! This setup now is way more powerfull and exciting and is loaded with features as described below.
First of all: here is the public link to the shared chart layout setup: www.tradingview.com
Which company could be more adequate for the introduction of a value investing toolkit than Berkshire Hathaway, the company of Warren Buffett? It is not just an honor to use this ticker for educational purposes but aparently -as you can see during the analysis- it makes a perfect long term investment! What a surprise, right? :-)
Here I will only explain all the new features of this chart as there is a very detailed explanation of both the Intrinsic value calculation script and the Value investing chart set in those two posts. You can find the links for them below.
SO! Obviously the biggest developement is poping into your eyes right away: I have programed a value investing analysis tool into the chart so whenever you enter a ticker, the toolkit will supply you with an instant assesment on the given ticker. Of course it is a very basic tool and can only supply you with a preliminary overview on the company and does not, in any way substitute detailed and troughly research before you make any investment decission!
- The assessment is based on the principals Warren Buffett, Ben Graham layed down. Some of Peter Lynch's work has been used, too.
- The tool is using a rather conservative approach as the main goal is to maintain the capital invested and only additional to that to produce adequate gain on the long run
In general: if you see a green labell with the text 'Possible subject for firther research' than you have found a company which passed a conservative test and is worth for further study. Needless to say that if you see a red label with the text 'XX NOT RECOMENDED XX' and a bunch of reasons below, why (overvalued - overpriced - debt risk) do not rush to your broker to put your life savings on it.
To give you an example, here is how Google is evaluated today:
In order to get the green light a company has to meet the following, rather strict criterias:
- Valuation: The current price of the stock has to be below the Intrinsic value. (In this case $224 closing price vs. $426 for the Int. value) This line will precisely tell you how far the price is from the Intrinsic value, in other words, it will tell you your margin of safety when investing to the company on today's price level. In this example it is 90%
- Pricing: The close price has to be below the "Buffetts limit price" indicator. To make it short Graham and Buffet stated that the number you get when multiplying the Price to Earnings (P/E) ratio with the Price to book (P/B) ratio has to be below 22.5 in order to consider the given share cheap. This line will tell you how far the price is from the Buffetts limit price. This case it is 61%. ($224 vs. $361)
- Debt risk: The company has to have much less debt than equity in order to qualify for long term value investing. The limit here is 1, meaning that the company has to have more equity than total debt. If this is not the case, the company fails the test. (This can be taken a little flexible as certain industries, like banking and insuarance by definition deploy a lots of debt instruments without risking their long term profitability or sustainability) In the example of Bershire this is 0,27 meaning that Berkshire has more than 3 times more equity than debt which is needless to say a more than perfect setup. (What do we expect from Mr. B, right?)
These are the first 3 deciding criterias where a company can fail the test. Any of those turn to be out of range, you will get a red labell with a big fat NO recomendation. And most of the time this is going to be the case...
As for the other points you will get more inside peek into the state of the company:
- Price/book: this line will tell you if the price is still below the 1.5 times book value point. This is the highest price what value investors find comfortable paying. If the P/E value is very low for the share you might run into a situation where the Buffetts limit (P/E times P/B) is still low (below 22,5) but the stock is rather overpriced.
You will not get a red labell here, only a 'Caution' warning and a grey label, instead of 'GOOD!'
- Earnings: you will get an opinnion on the earnings here. The main criteria to get a 'GOOD!' evaluation is to have a growing level of EPS in the last 5 years.
- Revenue: It is very important to invest in a company which is able to grow it's revenues steadily. This line will analyse that and will tell you if it wouldn't be so.
- Profit & loss: Although it is not a deciding factor but a value investor should avoid investing to companies that were producing losses in the past decade or so. This line examines the last 5 years in this respect.
- Dividend: The one and only point where Berkshire fails the test! :-) As Warren Buffett used to say: I am not paying income tax, Berkshire doesn't pay dividend... :-) Poor guy! Since we are investing for a very long term it is imperative that we top the gains we might have over the years with the 3-4% dividend p.a. As you can see here, there is a Warning! comment should the company fail in paying dividend.
- Number of shares: Here you will see a quick analysis on the share buyback habits of the company/management. Again, what we examine here is wether the number of shares outstanding is less than 5 years ago or more which means that the company is buying back it's shares thus help investors to maintain equity.
So entering your choosen ticker you should have an instant overview if the company can supply you with the value investing criterias or fails in this field.
One very instructive exercise is to click through the leading blue chip stocks with this valuation toolkit and see how hugely overvalued they are at the moment.
Some further developements I made in the mean time:
- I have automated the calculation of the book value growth with finding the very first data point regardless when it happens. In this way you do not have to enter any parameter and you can simply click conveniently from one ticker to the other without reentering the needed inputs. Hopefully it doesn't matter which pricing structure you are in at TradingView. Free acounts will use 5 years data.
- I have included a 4th pane just below the main pane. This shows the revenue of the company in 3 way: the white line is the anual values, the grey line is the quarterly data and I have also added the red line showing the TTM (trailing twelve month) figure in order to visualise the very recent trends in the revenue of the company.
- The same way I have added the TTM figure on the lowest pane to the EPS figure, for the same reasons.
- I have added explanatory labells to the right of the charts showing the actual value of the indicators, like the Intrinsic value, Buffetts limit, and book value.
- Should either the Book value or the EPS figure be negative for the current year the script will issue a red label without any data regardless the other values as the Buffetts limit can not be calculated. (Negative numbers does not have square roots and that is required to calculate the limit price back from the P/E and the P/B values)
One final remark: this toolkit is as complete as my knowledge is about value investing. It is a purely educational tool, not in any way intented to be investment advice. I do use this tool and for instance I do have position in this example company Bershire Hathaway at the time of writing this post. You have to make your own research and decision when it comes to investing your money.
For further explanation on the Intrinsic value calculation please check my earlier post here:
For further explanation on the Value investing chart set please check my earlier post here:
Graham
Value investing chart setI would like to share the set of charts I use to find and analyse candidates for value investing.
It is a rather dense and telling setup where you can find a lots of information. Please allow me to explain them one by one.
(The chart is made on the company Nippon Tel. It is not a recomendation for anybody to buy Nippon Tel, I use this chart for educational purposes only)
So: what can you see in this chart? A LOT! You can, in a glance asses if a company would qualify for value investing or should be avoided. From bottom up here are the panes, charts, indicators explained:
There are 3 panes in this setup.
In the lowest pane you will find the dividend information. There are 3 indicators telling a lot about the company's endurance and discipline. We can see that in our example
- the company has never been missing a dividend payment over the last 15 years (even during the 08 crisis)
- the company has been constantly raising the dividends over the last 15 years
- the company has made an ever growing diluted EPS (earnings per share) over the last 15 years
- the investment in the current price levels would yield 3,69% (bottom right scale)
- the company has been very disciplined to pay out about 50% of the earnings per share and retain the rest within the company resulting growing book value
In the middle pane you can see the net income (green territory) of the company and the number of common shares outstanding (blue line). We can see that in our example
- the company has been constantly making profit over the last 15 years (even during the 08 crisis)
- the company constanly buying its shares back thus helping the existing shareholders to keep/grow the equity per share
Now the top, main pane tells the most about the company and its share. Here is what you can read from this chart:
- the yellow line will show the Debt to Equity ratio
What this is telling you is that the company is ran by vigiliant leaders who are keeping a close eye on the company's long and short therm debt and resist the temptation of today's really cheap loans. As Peter Lynch use to say: it is almost impossible to go bankrupt for a company without excessive debt. The ratio Ben Graham and Warren Buffet (also Peter Lynch) finds healthy here is a 1 to 2 debt to equity ratio. In other words, it is assuring if half of the equity covers all the debt of the company.
In the case of our example the current value of this ratio is 0,415 which is a very good level of debt. (Industry specific figure!) The company has been constantly paying it's debt back over the last 15 years and although the figure has been growing during the last 2 years it is still under a acceptable level.
- the light brown line is the book value or the shareholder1s equity per share
Needless to say the for a value investor it is imperative that the book value is steadily growing, just like in our example from 8,8 to 21. What is even more important is that the current price is below the book value per share or in other words a buyer in these price levels gets a 1 on 1 value for his bucks. Just to give you a comparison: today this value for Apple (AAPL) is 30 to 1! So you pay $ 30 for $ 1 of equity when you buy Apple stock.
In our example the book value of this company is steadily growing and the price is currently below the book value.
- the pink line on the pane is my "invention" as this is the intrinsic value graph which is calculated by the script I have posted already here. I would not explain in details here, please check out my post and all the comments below it for details.
This line shows you what would be a fair value of the stock if you take all the dividends and the book value growth that will happen in the next coming 10 years and discount it back to today's value using the 10 years US Note's yield. This is called the intrinsic value of the company and calculating it is rather art than science, says Buffett.
In the case of the example company the Intrinsic Value is around 43 while the price is a bit above 20 which means that a value investor has a 100% margin of safety when buying this stock.
- the green/red line is another calculated line: Warren's limit price
Ben Graham and Warren Buffett uses a rule of thumb saying that the PE (price earning ratio) multiplied by the Price to Book ratio can not result a higher value than 22.5 to be considered a cheap stock. Here I use the Diluted Earnings figure to calculate the PE ratio to take all the convertible securities (options, prefered stocks, warrants, etc) into consideration.
This line shows if the stock can be valued as cheap or overpriced.
In the case of our example the current price is under the limit price and can be considered an underpriced stock.
As you can see there are lots of fundamental informations you can visualise and asses with this chart setup in order to pick your winning stocks for value investing.
Book Value: $3.72 (Total Shareholder's equity/number of shares)We know...Market doesn't follow any logic. Finally the super overvalued stocks are starting fo fall . Anyway, there are very few stocks which are quite undervalued. Benjamin Graham’s Criteria for Picking Value Stocks
VALUE CRITERIAS: Graham advised buying companies with Total Debt to Current Asset ratios of less than 1.10 - ODP Current Assets (in millions) 2,870 ODP Total Debt is 1,700. so 1700/2870 = 0.59 (Much less than 1.10)
Current Ratio (current assets divided by current liabilities) to find companies with ratios over 1.50. About OFFICE Depot Numbers: 2870/2046 = 1.40 (a bit lower than 1.50)
Invest in companies with price to earnings per share (P/E) ratios of 9.0 or less. ODP P/E is 6.8
Find companies with price to book value (P/BV) ratios less than 1.20. ODP Price (Market value) is 1,280 . Total stockholders’ equity (last quarter) is 2,120 so 1,280/2,120 = 0,6 (50% less than 1.20!)
Invest in companies that are currently paying dividends. ODP, actually, is paying dividends.
Following the Graham numbers, ODP is one of the very very few companies to be undervalued. It's undervalued by 76%
dqydj.com
Express Scripts Holding Company (ESRX) Intrinsic ValueRetorno de Capital (Greenblatt): 428.34%
P/E (Greenblatt): 10
Margen de seguridad en base a descuento de flujo de Caja(Graham): 42.2%
Supplementing Your Portfolio with NAIINAII is a sports nutrition and supplement company flushed with cash, no debt, and increased operating income over the last three years. Check out my latest analysis of the comp here: rockvuecapital.wordpress.com
The short of it: The market seems to be mis-pricing the tremendous margin and operating efficiency that NAII has compared to its peers. With higher margins, lower operating costs, and an peer leading ROA and ROE, I think the market is overemphasizing the recent downtrend in the company's earnings.
I entered at 11.35 with a stop loss at 10.00 in the paper account, risking 46bps of capital. I might add to this position if price advances in my favor.
Please be critical in your analysis, help me find my blind spots.
Always trying to improve,
Brandon