Please show your work in excel.

Problems and Cases 12.10 Calculating Free Cash Flows. The 3M Company is a global diversified LO 12-2 technology company active in the following product markets: consumer and office; display and graphics; electronics and communications; health care; industrial; safety, security, and protection services; and transportation. At the consumer level, 3M is probably most widely known for products such as Scotch Brand transparent tape and Post-it notes. Exhibit 12.12 presents information from the statement of cash flows and income statement for the 3M Company for 2013 to 2015. From 2013 through 2015, 3M decreased cash and cash equivalents. The interest income reported by 3M pertains to interest earned on cash and marketable securities. 3M holds only small amounts of investments in marketable securities. 3M's income tax rate is 35%. Exhibit 12.12 3M Company Selected Information from the Statement of Cash Flows (amounts in millions) (Problem 12.10) 2015 2014 2013 + $ 6,420 $ 6,626 $ 5,817 (1.428) (2,791) 1,300 102 $(2,817) (1,358) (94) 754 102 $ (596) (1,537) 8 627 46 $ (856) Operating Activities: Cash Flow from Operating Activities Investing Activities: Fixed assets acquired, net (Acquisition) Sale of businesses, net (Purchase) Sale of investments, net Other investing Cash Flow from Investing Activities Financing Activities: Increase (Decrease) in short-term borrowing Increase (Decrease) in long-term debt Increase (Decrease) in common stock Dividends paid Cash Flow from Financing Activities Net increase (decrease) in cash & equivalents Cash at beginning of year Cash at end of year Interest income Interest expense 860 2,448 (4,449) (2,561) $(3,702) $ (99) $ 1,897 $ 1,798 $ 26 $ 27 853 (5,378) (2,216) $(6,714) $ (684) $ 2,581 $ 1,897 $ 33 $ 142 (2) (20) (3,511) (1,730) $(5,263) $ (302) $ 2,883 $ 2,581 $ 41 $ 145 149 Source: 3M Company, Form 10-K for Fiscal Year Ended December 31, 2015. Required a. Beginning with cash flows from operating activities, calculate the amount of free cash flows to all debt and equity capital stakeholders for 3M for 2013, 2014, and 2015. b. Beginning with cash flows from operating activities, calculate the amount of free cash flows 3M generated for common equity shareholders in 2013, 2014, and 2015. c. Reconcile the amounts of free cash flows 3M generated for common equity shareholders in 2013, 2014, and 2015 from Requirement b with 3M's uses of cash flows for equity shareholders, including share repurchases and dividend payments