Emerson Electric Co (EMR)

Submitted by admin on Thu, 10/22/2009 - 11:17

This is a sample of the output from the Stock Selection Guide module Phat Geeks has written for Drupal.

Its modeled after Better Investing's Stock Selection Guide.

All you do is type in a ticker, and this is what you get. The module crunches the numbers, generates the graph and spits it all out for your review.

You can inspect all the harvested and calculated data in Section 6.

If you'd like to try it out, sign up for an account.

Or if you are interested in hiring Phat Geeks feel free to Contact Us.

Stock Selection Guide for Emerson Electric Co (EMR)

1. Visual Analysis
Recent Quarterly Figures
  Sales EPS
Latest Quarter 5091.00 0.52
Year Ago Quarter 6568.00 0.79
Percent Change -22.49 -34.18

Click to Enlarge

Click Image to get full-size.

Computed Revenue Growth: 6.05%
Computed EPS Growth: 13.09%
2. Evaluating Management
  1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 Last 5yr Avg Trend
EBT Margin (%) 14.20 14.00 10.30 11.30 10.10 11.90 12.40 13.30 13.80 14.50 13.18 Up
Return on Equity (%) 21.92 22.61 16.49 2.06 17.85 18.35 19.43 23.72 25.24 26.97 22.74 Up
3. Price-Earnings History
Present Price: 39.81    High This Year: 41.24    Low This Year: 24.41

  High Low EPS High PE Low PE Dividend/Share % Payout % High Yield
2004 31.06 24.63 1.49 20.85 16.53 0.00 0.00 0.00
2005 34.98 27.22 1.70 20.58 16.01 0.85 50.00 3.12
2006 41.14 33.93 2.24 18.37 15.15 0.93 41.52 2.74
2007 55.12 38.90 2.66 20.72 14.62 1.09 40.98 2.80
2008 55.63 28.93 3.06 18.18 9.45 1.23 40.20 4.25
Averages 43.59 30.72   19.74 14.35   34.54  

Average Price earnings Ratio: 17.05    Current Price Earnings Ratio: 16.05

4. Evaluating Risk and Reward
A. High Price (next 5 years)

Forecast High Price = Average High PE x High EPS Estimate = 19.74 x 4.47 = 88.24

B. Low Price (next 5 years)
Forecast Low = Average Low PE x Low EPS Estimate = 14.35 x 2.42 = 34.73
Average Low of Last 5 Years: 30.72
Recent Severe Market Low: 27.22
Price Dividend Will Support = Present Dividend / High Yield = 1.23 / 4.25% = 28.94
Forecast Low Price Chosen: 30.40
NOTE:The "Price Dividend Will Support" is not included in that average if we determine the High Yield was 0.

C. Zoning
1/3 of range = (High Forecast Price - Low Forecast Price) / 3 = (88.24 - 30.40) / 3 = 19.28

  Low High
Buy 30.40 49.68
Maybe 49.69 68.97
Sell 68.98 88.24

Applying the current price of 39.81 to the table above you should: BUY

D. Up-side Down-side Ratio (potential gain vs potential loss)
(High Price - Present Price) / (Present Price - Low Price) = (88.24 - 39.81) / (39.81 - 30.40) = 5.15 to 1

E. Price Target (potential market price appreciation over next 5 years
(High Price / Present Price * 100) - 100 = (88.24 / 39.81 * 100) - 100 = 121.65%

5. Five Year Potential

A. Present Yield or % Returned on Purchase Price
Present Full Year's Dividend / Present Price * 100 = 1.23 / 39.81 * 100 = 3.09

B. Average Yield over next five years
Average EPS Next Five Years * Average % Payout = 3.55 * 34.54 = 122.62%