Message Font: Serif | Sans-Serif
 
UnThreaded | Threaded | Whole Thread (3) | Ignore Thread Prev | Next
Author: job3rd Two stars, 250 posts Add to my Favorite Fools Ignore this person (you won't see their posts anymore) Number: of 14782  
Subject: Re: OT: Question for Mungo Date: 12/6/2012 4:30 PM
Post New | Post Reply | Reply Later | Create Poll Report this Post | Recommend it!
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!

John
Post New | Post Reply | Reply Later | Create Poll Report this Post | Recommend it!
Print the post  
UnThreaded | Threaded | Whole Thread (3) | Ignore Thread Prev | Next

Announcements

Foolanthropy 2014!
By working with young, first-time moms, Nurse-Family Partnership is able to truly change lives – for generations to come.
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.
Post of the Day:
Macro Economics

Looking at Currency Ratios
What was Your Dumbest Investment?
Share it with us -- and learn from others' stories of flubs.
Community Home
Speak Your Mind, Start Your Blog, Rate Your Stocks

Community Team Fools - who are those TMF's?
Contact Us
Contact Customer Service and other Fool departments here.
Work for Fools?
Winner of the Washingtonian great places to work, and "#1 Media Company to Work For" (BusinessInsider 2011)! 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.
Advertisement