Your parents are considering investing in PepsiCo, Inc. common stock. They ask you, asan accounting expert, to make an analysis of the company for them. Fortunately, excerpts from a current annual report of PepsiCo are presented in Appendix A. Note that all dollar amounts are in millions.

PEPSICO Instructions

(Follow the approach in the chapter for rounding numbers.)

(a) Make a 5-year trend analysis, using 2006 as the base year, of (1) net sales and (2) net income.

Comment on the significance of the trend results.

(b) Compute for 2010 and 2009 the (1) profit margin, (2) asset turnover, (3) return on assets, and

(4) return on common stockholders’ equity. How would you evaluate PepsiCo’s profitability?

Total assets at December 31, 2008, were $35,994 and total stockholders’ equity at December 31, 2008, was $12,203.

j

(c) Compute for 2010 and 2009 the (1) debt to total assets and (2) times interest earned ratio. How would you evaluate PepsiCo’s long-term solvency?

(d) What information outside the annual report may also be useful to your parents in making a decision about PepsiCo, Inc.?

Comparative Analysis Problem:

PepsiCo, Inc. vs. The Coca-Cola Company