Problem:
You will assume the role of a financial analyst and create a full analysis between Coca-Cola and PepsiCo. Please explain all calculations and ensure that you answer each and every question thoroughly. You will need to locate Coca-Cola and PepsiCo, Inc annual financial statements for 2007. These can be easily obtained through the internet, should you have any difficulty please let me know.
Question 1) What were the accounts receivable (net) for Coca-Cola and PepsiCo at the end of 2007? Which company reports the greater allowance for doubtful accounts receivable (amount and percentage of gross receivable) at the end of 2007?
Question 2) What is the amount of inventory reported by Coca-Cola at December 31, 2007, and by PepsiCo at December 29, 2007? What percent of total assets is invested in inventory by each company?
Question 3) Compute and compare the inventory turnover ratios and days to sell inventory for Coca-Cola and PepsiCo for 2007. Indicate why there might be a significant difference between the two companies.
Question 4) What amount is reported in the balance sheets as property, plant, and equipment (net) of Coca-Cola at December 31, 2007, and of PepsiCo at December 29, 2007? What percentage of total assets is invested in property, plant, and equipment by each company?
Question 5) Compute and compare the following ratios for Coca-Cola and PepsiCo for 2007: Asset turnover, Profit margin on sales, and Rate of return on assets.
Question 6) What amounts for intangible assets were reported in their respective balance sheets by Coca-Cola and PepsiCo? What percentage of total assets is each of these reported amounts?
Question 7) What were Coca-Cola's and PepsiCo's net revenues (sales) for the year 2007? Which company increased its revenues more (dollars and percentage) from 2006 to 2007?