PLEASE SOLVE iN EXCEL !!

Analysis and Interpretation of Profitability sheets and income statements for 3M Company follow. LO4, 5, 6,7,8 3M COMPANY 3M COMPANY Consolidated Statements of Income Years Ended Dec. 31 (S millions) 2015 2014 2013 Net sales. Operating expenses $30,274 $31,821 $30,871 Cost of sales Selling, general and administrative expenses Research, development and related expenses Total operating expenses Operating income. Interest expense and income 15,383 6,182 1,763 23,328 ...6,946 16,447 6.469 1,770 24,686 E 16,108 6,384 1,715 24,205 6,666 7.135 Interest expense. Interest income 149 142 Income before income taxes Provision for income taxes Net income including noncontrolling interest Less: Net income attributable to noncontrolling interest Net income attributable to 3M 6,823 1,982 4,841 7,026 2,028 4,998 6,562 1,841 4.721 62 $ 4,659 $ 4,833 $ 4,958 3M COMPANY Consolidated Balance Sheets At December 31 (S millions, except per share amount 2015 2014 Current assets Marketable securities-current Accounts receivable-net of allowances of $91 and $94.... 1,798$1.897 1,439 4,238 118 4.154 1,655 1,008 855 3,518 1,398 1,723 Work in process Raw materials and supplies. Total inventories . 3,708 1,023 12,303 Total current assets. Marketable securities-noncurrent . 15 102 23,098 (14,583) 8,515 9,249 2,601 188 1,053 22,841 (14,352) 8,489 7,050 1,435 Less: Accumulated depreciation. Property, plant and equipment-net Intangible assets-net Prepaid pension benefits Other assets... 1,769 $32,718 $31,209 Profitability Analysis and Interpretation 2015 continued from prior page t December 31 (S millions, except per share amount) Liabilities Current liabilities $2,044 1,694 108 Accrued payroll Accrued income taxes . 7.118 ....8,753 1,580 . $20,971 5,964 Total current liabilities Long-term debt 1,555 $18,067 Other liabilities Total liabilities 3M Company shareholders' equity: Common stock, par value $0.01 per share Shares outstanding-2015: 609,330,124; 4,791 ...36,575 4,379 34,317 Retained earnings . Treasury stock Accumulated other comprehensive income (loss) (6,359) 13,109 $11,747$13,142 $31,209 Total liabilities and equity .. Required Compute net operating profit after tax (NOPAT) for 2015. Assume that the combined federal and stale statutory tax rate is 37%. b. Compute net operating assets (NOA) for 2015 and 2014. Treat noncurrent investments as a nonoperating Compute and disaggregate 3M's RNOA into net operating profit margin (NOPM) and net operating (NOA) for 2015. Demonstrate that RNOA-NOPM#x NOAT d. Compute net nonoperating obligations (NNO) for 2015 and 2014. Confirm the relation: NOA NNO asset turnover + Total equity e. Compute return on equity (ROE) for 2015. f. What is the nonoperating return component of ROE for 205 g. Comment on the difference between ROE and RNO A. What inference can we draw from comparison? Compute the DuPont Disaggregation of ROE