The 1YPEG calculation spreadsheet I’ve been working on now has all values filled in for all stocks in the sheet, including revenue. For reference, the spreadsheet is located here:
For stocks that weren’t mine and left by other people I went ahead and filled in the Revenue and Earnings numbers, however, please note that I used amigobulls to extract this information. I felt it would have been a laborious task to go into each company’s earnings report to pull its numbers for stocks that I didn’t even own…but I also have a sort of completion complex about me so felt it must be done
As always, please make sure to research these numbers on your own and always do follow up work on any stock the spreadsheet may happen to highlight. These are first pass candidates!
I tweaked the candidate stock selection criteria to also include stocks that are still coming out of negative earnings (e.g. no 1YPEG as of yet) but have extremely good earnings (>40%) and revenue (>50%). In this way XPO makes its appearance in the list. Since WAB and CELG have a 1YPEG > 1 they still don’t make the cut. But I think that is ok as I’m using this spreadsheet as a tool to find a place for new money and not to find places where things may be winding down.
The updated stock candidates are below. I entered in a bunch of new stocks into the sheet that I screened using CAPS. I looked for stocks showing signs of large amounts of revenue growth and earnings growth and then dug in to only stocks that had a CAPS rating of 4 or 5. Some of those CAPS screened stocks made their way into the list below.
As Saul suggests, there really are a lot of stocks out there with the right quality signs, and my first exercise at finding them has become proof to me that they really are out there. I’m becoming much more confident in my abilities to identify stocks with the right qualities on my own.
Give a man a fish and I’ll eat for a day. Teach a man to fish and I’ll eat for a lifetime. Thank you Saul. You have my eternal gratitude.
this is from FireEye earnings release
For 2015, the company currently expects total revenue in the range of $615 to $635 million. Additionally, for 2015, on a non-GAAP basis, the company expects:
Total billings in the range of $825 to $835 million.
Gross margin in the range of 71 to 75 percent of total revenue.
Research and development expenses in the range of 35 to 38 percent of total revenue. Sales and marketing expenses in the range of 64 to 68 percent of total revenue.,
General and administrative expenses in the range of 14 to 17 percent of total revenue.
Loss per share of $1.75 to $1.85, based on estimated weighted average shares outstanding of approximately 155 million.
Negative cash flow from operations in the range of $65 to $80 million.
I am ill and all medicated up so I hope I made sense. My point is they are cash flow negative, they have no earnings, so the screen seems to have an error.
But I am not thinking my best today so take it with a grain of salt.
The screen just shows that FEYE has increased earnings by a lot YOY. And I think we all understand this is just one screen and that more research needs to be done before any purchases are made.
Still, Kevin, I can’t tell you how much I’ve used this already for research. I’ve even entered a lot of companies! What’s funny is how the stocks I used to consider relatively “safe” are far from it. Thanks Kevin!
What you wrote makes perfect sense and you are correct in that FEYE has no earnings.
I probably wasn’t as clear as to what I did to the screen and why I made the change. I wanted to open up the selection criteria so that we wouldn’t miss the next XPO as Saul has found. XPO is one of those stocks with negative earnings, but, they are solidly growing revenue and EPS YoY. Yes, opening up the criteria to these types of stocks means it is an exception to the rule, and that may be ok as long as you’ve done your research.
If you visit the spreadsheet, the stocks with these slightly questionable criteria show up with a ‘?’ in the candidate stock column. This is opposed to the normal ‘X’. The question mark means it could be a good one to investigate, but definately do your homework!
The stocks with a question mark include ARCP, ENPH, FEYE and XPO. The rest in the list are all solidly in the positive territory and satisfy the normal criteria.
Hi Flygal, How about these two numbers on your FEYE post?
Loss per share of $1.75 to $1.85, based on estimated weighted average shares outstanding of approximately 155 million. (That comes to a total loss of $280 million).
Negative cash flow from operations in the range of $65 to $80 million.
I probably wasn’t as clear as to what I did to the screen and why I made the change. I wanted to open up the selection criteria so that we wouldn’t miss the next XPO as Saul has found. XPO is one of those stocks with negative earnings, but, they are solidly growing revenue and EPS YoY. Yes, opening up the criteria to these types of stocks means it is an exception to the rule, and that may be ok as long as you’ve done your research.
Hi Kevin, I would recommend that people be very, VERY, cautious with the story stocks that say they will break even in 2016 or 2017!!! I made an exception for XPO because its adjusted EBITDA looked like this (rounding off):
but even with that, I’m not kidding myself. Once they have positive earnings and a real PE ratio, they’ll have to prove themselves as a real company. And with another company like FEYE, which seems far from breaking even, I’d be especially cautious.
JMO
Saul
For Knowledgebase for this board please go to Post #9286
Kevin, Great work, as I have said. I have just a small suggestion that might simplify your table and make it easier to read. What I’d do is remove all the decimal places. They simply don’t figure into your decision of whether or not to buy, and they do confuse the picture. For example, look at CNC (I know nothing about the company).
CNC 50.30% 32.04 0.64 52.94%
Saying it like this:
CNC 50% 32 0.64 53%
you don’t lose anything you need for decision making, but when looking at a whole column it’s a lot easier to make sense of. It makes no difference if the rate of earnings growth is 50 or 50.3 percent as far as any decision you’d make. Similarly with the PE of 32 or 32.04, and with rate of growth of earnings between 52.94 and 53 percent, but it sure makes your table more readable.
Saul, thanks for the suggestion. I just made the change.
Also, I took note about what you and Kate said and will add something to make the considerations clearer on the stocks with negative earnings. Perhaps it may be best to leave the indicator off entirely since the circumstances for consideration are very rare.
Yes FEYE is losing money and is expected to be losing money all the way until 2018-2020 according to Value Line projections althoughh losses may decrease in future years.
One suggestion regarding your use of Amigobulls to pull EPS information. Maybe flag the EPS information in the spread sheet (colorcode?) the EPS information from amigobulls vs the info pulled directly from the earnings report.
This way people know which data has been vetted already.
Hi Flygal, How about these two numbers on your FEYE post?
Loss per share of $1.75 to $1.85, based on estimated weighted average shares outstanding of approximately 155 million. (That comes to a total loss of $280 million).
Negative cash flow from operations in the range of $65 to $80 million.
Of course you are completely right but I was so far gone (recurring paradoxical vocal cord disorder) I couldn’t get the formatting right.
Mending, Flygal
You can see my holdings on my profile, required of all employees of the Fool, even part timers like me.