HW Prob 1 C Version Q Search Sheet Home Insert Page Layout F

HW Prob 1 (C Version) Q Search Sheet Home Insert Page Layout Formulas Data Review Viev Share ^ AutoSum AR . | 11A-A- = Calibri (Body) , , E,wrap Text General - B 1-S, S \' , . conditional asTable Styles Paste Copy Merge & Cen ter· s-% Format Cell Insert Delete Formst Sort & Filter Fa mat Format B Clear Formatting aTable Styles 1 2 3 4 A) what is the total amount of assets invested in each company over the last 3 years? B) What is the return on assets for each company in the most current year? C) How much were total expenses for each oompany in the most current year? D)If the industry average return on assets is 3.7% how do the companies compare? for I the ind were totae E} Print the Excel formulas (CNTRL 5 Coca Cola (in millons $) Pepsi lin millions S) Year End Year EndYear End Year End Year End 12/30/12 11/121/2/1112/29/12 12/31/11 12/25/10 2,344 52,294 46,989 6,443 9 Net Income 10 Total Liabilities 11 Total Equity 12 Revenues 13 8,58411809 41,918 2,790 31,635 31,003 35,119 9,019 6,178 53,38448,339 989 21,164 22,29420,588 66,504 48,017 46,542 65,492 57,838

Solution

Particulars coca cola pepsi Total assets invested 13253 6485 Return on assets 10.46% 8.27% Total expenses 38998 59314 Compare to industry average better than industry better than industry