"I will tell you how to become rich. Close the doors. Be fearful when others are greedy. Be greedy when others are fearful." 
  -- Warren Buffett

Can't argue with that, can you? I don't need to remind you of how much fear is in the market these days. But that fear is also creating abundant opportunities for investors patient and diligent enough to search for the babies thrown out with the bathwater.

Using our Motley Fool CAPS ranking system's nifty screening tool, I looked for companies with the following characteristics:

  • Five-star ratings, as they are the best of breed.
  • Trailing dividend yields of at least 3%.
  • Price-to-book ratios no greater than 1.
  • Greater-than-10% drops in share price over the last 13 weeks. I'm looking for bargains, right?

Among others, that screen dug up these stocks, which have been shredded to such paltry levels that it's hard to keep ignoring 'em.

Take a look:

Company

13-Week
Price Change

Dividend
Yield

Price/Book Ratio

Price/Earnings
Ratio (TTM)

ConocoPhillips (NYSE:COP)

(31.8%)

3.5%

0.86

4.33

Capital Source (NYSE:CSE)

(63.1%)

3.8%

0.49

16.8

Dow Chemical (NYSE:DOW)

(45.2%)

8.2%

0.99

7.38

ArcelorMittal (NYSE:MT)

(59.3%)

4.8%

0.59

2.53

NYSE Euronext (NYSE:NYX)

(34.7%)

4.1%

0.85

10.28

Ternium (NYSE:TX)

(61.2%)

5.7%

0.33

1.46

Tata Motors (NYSE:TTM)

(52.2%)

7.5%

0.69

3.5

Data from Motley Fool CAPS as of Dec. 18. TTM= trailing 12 months.

Looking at earnings in the rearview mirror typically means very little, but the disparity between what these companies earned in the past year compared to what they trade for today is pretty overwhelming. None of these are formal recommendations -- just a good starting point for you to dig a little deeper. Intrigued? You can rerun an update of this screen yourself, if you like.

Roiled by oil
Can you believe it? It seems like only days ago that ballyhoo over $150 oil was everywhere and most credible analysts predicted $200 oil was right around the corner.

Fast forward a few months, and we're in the mid $30s and falling by the day -- great if you're looking for relief at the pump, terrible if you're an oil company like ConocoPhillips.

For patient investors, though, it can be a blessing in disguise. The plunge in crude prices is actually setting up what'll inevitably be a spectacular rebound. Why? Lower prices causes oil producers to reduce supply and shelve investment, which sets up an even bigger supply/demand imbalance once the economy picks up again.

CAPS member BSHumphreyII seems to agree, viewing Conoco as a bargain at these prices, recently writing:

4 times earnings?! This thing's priced for $10 oil, which just isn't going to happen. OPEC is going to cut production significantly, soon, and while global economic numbers are bad, they aren't quite bad enough to justify any further decline in the price of oil. Supply problems aren't going anywhere. We're far more likely to see oil in the $60-$80 range next year, maybe higher.

[ConocoPhillips] also has some significant gas exposure, and gas inventories are down. The new administration might not like any of the fossil fuels, but they'll have to pick at least one because "renewable energy" is a looong way off from being economically viable. Gas is the cleanest of the three, and will be the first to benefit once the Obama administration starts to think clearly about energy.

Let's also not forget that Warren Buffett himself purchased 24 million shares of Conoco in recent months ... not a bad vote of confidence, I might say.                                                                   

Attack of the steel mills
Just like oil's spectacular collapse, steel stocks have been cliff diving as investors brace for what could be a nasty global recession. The pullback might be justified in the short term, but rampant pessimism is providing an opportunity to buy a market-leader like ArcelorMittal in an industry that will always have demand at what looks like a bargain price. Doesn't get better than that, does it?

As CAPS All-star TheHuney pointed out last month:

The book value of this stock is $45 and it's selling at over a 50% discount to that! All the while, it's still producing positive cash flows; for FY '07, I calculated about $11.50 per share in cash flows from operations and maybe $8 in free cash flows (depends on how you calculate it; but needless to say, it's positive). Will that drop over the next year? Probably, but even if it drops a considerable amount this might not be such a horrible deal. At the current share price, it's almost like 3 straight years of huge losses are factored in. 

Care to see what over 120,000 other investors are saying about these and oodles of other stocks? Check out our Motley Fool CAPS investor intelligence database. Click here to give it a whirl. It won't cost you a dime.

For further Foolishness:

On Jan. 12, 2009, Fool co-founder David Gardner, Jeff Fischer, and their Motley Fool Pro team will accept new subscribers to their real-money portfolio service. Motley Fool Pro is investing $1 million of the Fool's own money in long and short positions in a range of securities, including common stocks, put and call options, and exchange-traded funds (ETFs). They also incorporate proprietary CAPS "community intelligence" data into their research. To learn more about Motley Fool Pro and to receive a private invitation to join, simply enter your email address in the box below.

Stock news, financial commentary, and your daily dose of Foolishness: Get plugged in to The Motley Fool on Twitter!

Fool contributor Morgan Housel doesn't own shares in any of the companies mentioned in this article. Tata Motors is a Motley Fool Global Gains pick. Dow Chemical and CapitalSource are Income Investor selections. NYSE Euronext is a Rule Breakers pick. The Fool owns shares of CapitalSource. The Motley Fool is investors writing for investors.