Explore BrainMass

Comparative Analysis Case

Please help and put in excel...
Thank you!
Go to and use information found there to answer the following questions related to The Coca-Cola Company and PepsiCo, Inc.

a. Which company had the greater percentage increase in total assets from 2006 to 2007?

b. Using the Selected Financial Data section of these two companies, determine their 5-year average growth rates related to net sales and income from continuing operations.

c. Which company had more depreciation and amortization expense for 2007? Provide a rationale as to why there is a difference in these amounts between the two companies.

Solution Summary

The solution explains some calculations in relation to Coca Cola and Pepsico