Message Font: Serif | Sans-Serif
No. of Recommendations: 0
"Fit a regression line through the earnings per share."

In Excel, is this =LINEST(known y's) ?

"..and measure the R-squared quality of fit.
The better the fit, the steadier the earnings."

In Excel, is this =RSQ (.. ) ?

"- Some sane constant to set a cap. 10-12-15% maybe?"

In Excel, is this =SMALL(bvg5, eps5, projEPS, max 15%??
(i.e. SMALL(C4, D4, E4; >= 15, 15 ???)

"This sort of pure-quant analysis would be good
for finding candidates, but a lot more examination
would be in order. Sometimes a firm with
preternaturally smooth earnings is actually a risky firm."

I planned on narrowing the list first by low debt,
consistent/above ave ROE, etc. Then, run remaining
through some acct'g ratios such as
Cash Flow from Financing/ Ave Tot Assets,
Bal Sheet Accrual Ratio
Total Assets/Total Accruals

So, you would recommend doing the pure-quant
future EPS estimate AFTER I've narrowed the
list to 50-60 quality firms?

Thanks again Jim!

Print the post  


When Life Gives You Lemons
We all have had hardships and made poor decisions. The important thing is how we respond and grow. Read the story of a Fool who started from nothing, and looks to gain everything.
Contact Us
Contact Customer Service and other Fool departments here.
Work for Fools?
Winner of the Washingtonian great places to work, and Glassdoor #1 Company to Work For 2015! Have access to all of TMF's online and email products for FREE, and be paid for your contributions to TMF! Click the link and start your Fool career.