Value Investing: Hidden Stock Price = Deliberate Practice
A little over a year ago, Geoff Gannon wrote a post where he gave readers the salient financial information of company, but didn't give the ticker/name of the company. He then had readers guess the stock price. It was an amazing little experiment derived from a quote of Warren Buffett where WEB goes on to say he likes to guess the stock price before looking at the actual price when he analyzes investments.
As always, WEB was well ahead of his time. Much work and study from behavioral finance/economics, like that of Daniel Kahneman, had discusses the effects anchoring has on each of us. If we see a stock price before valuing the company, we will unconsciously fix our valuation near the actual price.
Ever since Geoff's original post I have been fascinated by the experiment. I even went as far as making an Excel program that would randomly generate ticker from the Russell 3000, display the financial information with ticker and price hidden. I could then go about valuing the company and check my work to see how I was doing. Here are three takeaways from probably doing this a couple thousand times in the past year:
- There are many companies out there that I did not know existed. While very few were "cheap" per se, it felt like a healthy change from names you hear about every day on the press or in the value investing community
- I have improved my valuation skills
- I can feel the bias in stocks that are easily dismissed. For instance, the for profit education sector screens amazing well (i.e. I guess the stock price substantially higher than the actual trading level). This is similar to some of the stocks spit out by Joel Greenblatt's Magic Formula.
(You will note I have added a number of line items from Geoff's original exercise)
I have not looked at the ticker or stock price. The first few things I would notice:
- Sales and earnings are growing very quickly
- Dividends have come down
- Lots of free cash flow. Scalable business with essentially flat capex in the last few years along with growth
- Industry: Hard to tell. Not a utility or a REIT. Definitely asset light, working capital heavy (people)
29 comments:
Hunter- very fun project. I think it would be worthwhile to include Gross Profit and operating income in the information given.
How did you come up with the excel program to find choose the random stocks in general? I just finished my first year out of undergrad and was wondering how you created the excel program, so I might be able to try something like this on my own.
Thanks,
Jeff
so are we putting a price on where we think it is trading, or a price on what we would pay for it?
Where it is trading is how I think about it. I think what you would pay for it changes based on your hurdle. A better way to think about it: What is it worth? We want to buy meaningfully below 'what it is worth'...
Here are my educated guesses for the market prices on 6/18 of each of these companies:
1) $5.63
2) $100.66
3) $69.13
i would also love to know if your excel program is able to be replicated. I do remember reading JG's post on this back then and it's a great idea. It is a solid way to improve valuation skills.
Great idea, Hunter. To others, the model is easy to replicate assuming you have access to Bloomberg - took me about 20 minutes this morning. If not, it will require some work, but I'm sure it can still be done. I'm happy to help if needed.
I think you also need i) cash, ii) non-operating assets, iii) non-operating liabilities, iv) preferred stock, v) non-controlling interest.
Also, tangible equity would be helpful.
1)$3
2)$55-$60
3)$90-$100
With the information given the only stock that meets my criteria is #2. I would pay $18 but I'm a cheapskate.
I like this exercise, but its very easy to find the companies using Bloomberg Equity Screen
shares outstanding each year would be helpful - you can kinda figure out whether they raised equity or not but not how much dilution there was, etc.
What are they worth?
$4.60, $55 and $55
Where are they likely trading today?
$5, $40 and $90
#2 is interesting. The sort of stock that will double then halve then double again.
Rob Southey
#1 = $3 looks like a entertainment store/book store/Re business.. heading to extinction
#2 = $35 strong growth, Equity doubling in 4 years , asset growth , storng cash flow from shares
#3 = $50, sales growth, huge equity growth but FCF is a disaster, don't like high capex!
#1 - $7
#2 - $24
#3 - $40
The Benjamin Graham stock screener (http://www.anahin.net/screener) gives a complete Graham analysis, for all 4000 stocks listed on the NYSE and NASDAQ.
Including all the above stocks.
Benjamin Graham was Warren Buffett's professor and mentor, and the original proponent of Value Investing.
#1) I would not touch the stock above $3.50-$3.90 due to Declining sales and cash flow, horrible earnings contraction, and one off dividend. I would not be surprised if it was trading above book value, but without the earnings or revneue growth hardly worth touching it. I would not be surprised if the stock was trading above $5.60 due to the 5 year average yield of about 2.5-3% and the one off dividend last year.
#2) Due to consist growth in most metrics, I would be interested in this stock below $24, but it probably is trading above $45
#3) Due to excessive build up of debt and capex from acquisitions, I would not be prepared to pay more then $50, however it probably is trading at over $70 due to the earnings, dividend and cash flow growth.
My guess:
1. $6.00 (no debt, cyclical, recent eye-popping dividend, trades for about revenues)
2. $62.00 (trades for 30X earnings in this crazy market)
3. $28.00 (5.0X dividend yield)
Cheers
$4.11
$24.25
$26.24
1. 5.50
2. 25
3. 45
1) 1% ROE, shrinking asset base, high capex, Not any better than liquiation play: hedging risky exposure not worth than maybe 2.80 (pricing for 50% decline in asset writedown). Earning power largely redundant
2)Obvious case of optimism: no explanation required: what value: 3X Book, 15 X earnings and 2X Sales Approx $30
3)Consistent and profitable, maintained gearing and payout ratios, well behaved book value and cash flows: Taking wild market beast's projections : trades somewhere between 38 and 45. My guess $40
Hunter, do you have the excel program available? or at least the symbol list you used. I was thinking about developing one using the SMF_ADD in. that would pull historical fundamentals from some period X years back using a random symbol. then for practice come up with a valuation and see how the walk forward came out. I will probably use the OSV (old school value worksheet) and pair it down.
Hunter
Here is my guess
1- 3.8
2- 35.3
3- 28.6
Mat
1. $2
2. $40
3. $60
Hi Hunter,
What's the answer??
Kid
Fantastic post - I'm going to start incorporating this exercise with another one of gannon's posts (http://www.gannonandhoangoninvesting.com/blog/how-to-become-a-better-analyst-one-hour-at-a-time.html). My guesses for the stocks are:
1) $5
2) $38
3) $33
1. 3
2. 28
3. 35
I know this is a day after the end of the month, but:
1)3.30
2)42
3)25
Post a Comment