According to reports, both PepsiCo (NYSE: PEP) and Pepsi Bottling Group (NYSE: PBG) received an upgrade from Stifel Nicolaus. Both are now placed in the "buy" category. I'm sure the companies are happy to be away from the depressing "hold" moniker. The price targets on Pepsi and Pepsi Bottling Group are $64 and $37, respectively. As of this writing, Pepsi was priced at $54.82 while Pepsi Bottling Group's last bid was $33.71.

As can be seen, if Stifel Nicolaus turns out to be right, then traders might have a winning transaction on their hands. But one thing that must be remembered is the arbitrage game going on here. Pepsi wants to buy Pepsi Bottling Group. The latter is, of course, arguing for a higher purchase price.

Patrick Byrne, the petulant chairman and CEO of the king of corporate crybabies, Overstock.com (NASDAQ: OSTK), issued yet another rambling press release on Friday, lamenting the fact that the company had reappeared on the Regulation SHO Threshold List after its stock price tanked following quarterly earnings that disappointed investors. Byrne said that ". . . the price of it fell 40% when we announced earnings that largely beat the Wall Street consensus expectations."

Regardless of how impressed Mr. Byrne was with yet another quarterly loss from his company, Stifel Nicolaus analyst Scott Devitt wasn't buying it. He downgraded the stock from hold to sell, pointing out that the company's revenue growth benefited from "fairly easy comps," adding that Overstock "may never achieve operating margins above 2%-3% at scale."

But never mind analyst predictions. Let's look at Patrick Byrne's predictions. In a 2001 interview with The Wall Street Transcript, Byrne said that by 2004 he "would want to see us well over $400 million and as profitable as hell. Making a ton of money. I want to see that next year."

That was seven years ago, and Overstock still has not reported anything resembling a profitable year, although Byrne is predicting that 2008 will be profitable in spite of a year-to-date loss of $10.4 million. Apparently Mr. Byrne is upset that no one is taking his forward-looking statements seriously anymore, but the fact is that, historically, Mr. Byrne's projections of profitability have been horrifically optimistic, and investors who believed him got their stuff handed to them.

If Mr. Byrne stopped wasting time lashing out at critics and devoted a few hours a day to backing up his big talk, the critics would go away and the stock would thrive.

How should you invest $10,000 in the coming year? The question was posed to some of Wall Street's most respected seers by syndicated columnist Andrew Leckey, whose Successful Investing column appears in over 150 newspapers.

Here, courtesy of The Bull & Bear Financial Report, 9 leading Wall Street experts -- Elaine Garzarelli, Richard Crippps, Sheldon Jacobs, Don Phillips, Richard Yamarone, High Johnson, Mark Johannessen, Curt Weil, and Paul Nolte -- offer their answers to the $10,000 question.

"Amid relentless volatility in 2007, every participant last December produced an increase over the past 12 months. Our pundits for a second consecutive year are spreading their bets because there are so many economic and political wild cards in the coming presidential election year.

MOST NOTEWORTHY: Oil and gas services companies, mining companies and Moody's Corporation (NYSE: MCO) were today's noteworthy upgrades:

• Morgan Keegan upgraded Natural Gas Services Group Inc (AMEX: NGS), Basic Energy Services Inc (NYSE: BAS) and Complete Production Services Inc (NYSE: CPX) to Outperform from Market Perform and Patterson-UTI Energy Inc (NASDAQ: PTEN) to Market Perform from Underperform, as the firm has a bullish outlook for drilling activity in the back half of 2007 and into 2008.
• JP Morgan upgraded shares of both Compania de Minas Buenaventu (NYSE: BVN) and Goldcorp Inc (NYSE: GG) to Overweight from Neutral on valuation.
• Moody's was upgraded to Overweight from Equal Weight at Morgan Stanley, citing increased confidence in revenue outlook and growth drivers.

OTHER UPGRADES:

• Inverness Medical Innovations Inc (AMEX: IMA) was upgraded to Buy from Hold at Stifel Nicolaus.
• Credit Suisse upgraded shares of Johnson Controls Inc (NYSE: JCI) to Outperform from Neutral, citing growth outlook in the company's building efficiency business.
• Allianz SE (NYSE: AZ) was upgraded to Buy from Add at WestLB on valuation and the company's strong Q1 results.

The folks at ThinkEquity believe that Texas Instruments (NYSE:TXN) is in for better days. They slapped an "accumulate" on the shares after carrying them as a "sell." The reason given was that TI's analog chip business should be getting better. ThinkEquity admits that the TI cell phone chip business is going to be rough for a long time. But, the research firm's sources say that the analog chip pick-up is broad and sustained. They put a new price target of $30 on the stock. It already trades above $28.

Almost any other research firm on Wall Street with an opinion on TI is worried about the stock. Stifel Nicolaus thinks TI's gross margins are down. Cathay Financial thinks that weakness in handset chips is continuing into 2007. And, Lehman Bros. has cut its earnings estimates for the big chip firm. Part of Lehman's analysis is that the analog business at TI is still "challenging."

Someone is right here and someone is wrong.

TI has two strikes on it. One is that it competes with Qualcomm (NASDAQ:QCOM) in the handset chip market. QCOM has seen better days, but it has formidable market share in the handset market. In addition to that, almost no one thinks that handset giants Nokia (NYSE:NOK) and Motorola (NYSE:MOT) will do well in 2007. Margins are dropping because the demand for phones tends to be in emerging markets where cheap is better. Cheaper phones, cheaper chips.

Analog may do OK for TI. But, it can't beat the devil. The handset market is in for some rough quarters.

Douglas A. McIntyre is a partner at 24/7 Wall St.