No. of Recommendations: 0
I don't get it.
Our figures for MSFT agree, except for timing. For netcash I get 41990 and you get 57725.
But I get EXPO as cash $1481740 and LT debt as $230420, giving netcash of 1251320. Which is more than 57725 (or 41990). Which is why I get EXPO as the 1st pick instead of MSFT.
Indeed, yahoo says EXPO cash is 148.17M and *TOTAL* debt is 28.79M. Other sites say LT debt is 13.34M. ROE is 29.32%, which is higher than the lowest you posted (25.92), so it should have made the ROE cut.
Ah, I see one thing that maybe explains it.
PAYX, Jim shows cash 1222 and LTdebt 798.2
Yahoo & WSJ & others show LTdebt (excl. Cap leases) 798.
But they show "Cash Only" 1,272
and "Cash & Short Term Investments" 1,645
Note that WSJ for MSFT shows "Cash Only" 34,704 and "Cash & Short Term Investments" 111,262.
So it looks like sometimes VL reports cash_only and sometimes reports Cash & Short Term Investments.
Probably doesn't make much of a difference overall, using this as a long-term hold screen. We get 24 of the 40 in common and the buys are equal weight; it's mostly just a matter of making the netcash cutoff. It's somewhat hard to equal weight 40 stocks, going with 50 makes it 2% per stock. (M1 Finance only takes whole numbers for the weight percentages.)
Still not quite ready to replace some of my BRK with this screen.
I am encouraged that this screen only picks one of the huge stocks that are the top holdings of SPY, QQQ, etc. instead of many of them. Of course, that means that it will probably underperform the S&P500 for the near future.
--------------
My screen picks Prudential Financial Inc PRU in the #5 spot.
PRU has quite low ROE, 6.8% (barchart says 14%), so it should have not made the ROE cut. Using the data from barchart the ROE cutoff is 25.82% at position #240, PRU is #486.
