PLEASE ANSWER THE FOLLOWING QUESTIONS USING THE DATA PRESENTED. PLEASE SHOW EXCEL CALCULATIONS AND EXPLINATIONS. THANK YOU!!!!!

Company: 3M Cost of Equity Risk Free Rate + Equity Risk Premium Beta x Market Risk Premium Expected Market Return - Risk Free Rate Market Capitalization Formula 1.74 % Provided in the guidelines Formula Value Formula 11.84 % Provided in the guidelines 1.74 % Link to cell B7 Value Enter the appropriate formulas or references in this table: Cost of Capital - Current Market Value Weight Cost WxC Equity Formula Formula Formula Debt (A-T) Formula Formula Formula WACC Formula Change in WACC if expected market return increases by 1.5 pp: Income Taxes/Taxable income Interest Expense/Total Debt Cost of Debt 1-Effective Tax Rate Effective Tax Rate x Total Pre-Tax Cost of Debt x Debt Adjustment Factor Total Debt Short Term Debt + Long Term Debt Formula Formula Value Value Value Formula Value Value Change in WACC if effective tax rate decreases by 5 pp: 1. (20 points) Calculate the company's weighted average cost of capital (WACC) using the template. Note that you should enter either a value or a formula (function) in cells. The following values are given: Risk-Free Rate: 1.74% Expected Market Return: 11.84% Debt Adjustment Factor: 1.00 The rest of the values can be retrieved from your previous assignments, with a few hints provided in the Excel file. Here is a formula example: Market Risk Premium = Expected Market Return Risk-Free Rate; that is, in the formula in cell B10 is =B11-B12"; additionally, the formula (reference) in cell B12 is "=B7". 2. (5 points) Answer the following questions. You can enter the number and write a sentence in the empty text box on the same Excel sheet. If you have entered all the formulas correctly, your WACC should automatically change as you change any of the input values: a. What will the new WACC be if the expected market return increases by 1.5 percentage points (for example, from 8.80% to 10.30%)? b. What will the new WACC be if the effective tax rate decreases by 5 percentage points (for example, from 27.10% to 22.10%)? Balance Sheet Cash Flow Statement Income Statement Item Consolidated Statement of Income Value Current assets Cash Flows from Operating Activities Jun. 30, 2021 Jun. 30, 2021 Jun. 30, 2021 Cash and cash equivalents $4,695 Net sales $32,184 $5,388 Marketable securities - current 805 Net income including noncontrolling interest Adjustments to reconcile net income including noncontrolling interest to net cash provided by operating activities Operating expenses 4,991 16,605 Accounts receivable - net of allowances of $231 and $233 Inventories 1,911 6,929 -156 Finished goods 2,356 Cost of sales Selling, general and administrative expenses Research, development and related expenses Gain on sale of businesses Total operating expenses Operating income 1,878 -389 25,023 7,161 Work in process Raw materials and supplies Total inventories Prepaids 1,342 1,144 4,842 406 262 -389 - 165 Depreciation and amortization Company pension and postretirement contributions Company pension and postretirement expense Stock-based compensation expense Gain on sale of businesses Deferred income taxes Loss on deconsolidation of Venezuelan subsidiary Changes in assets and liabilities Accounts receivable Inventories Accounts payable Accrued income taxes (current and long-term) 633 377 16,343 450 6,711 1,318 5,393 Other current assets Total current assets Property, plant and equipment Less: Accumulated depreciation Property, plant and equipment - net 27,132 Interest expense and income Other expense (income), net Income before income taxes Provision for income taxes Income of consolidated group Income (loss) from unconsolidated subsidiaries, net of taxes Net income including noncontrolling interest Less: Net income (loss) attributable to noncontrolling interest 165 -91 252 (17,774) 9,358 -5 132 Operating lease right of use assets 872 5,388 398 Goodwill 13,722 Other - net Net cash provided by (used in) operating activities 4 8,113 Net income attributable to 3M $5,384 5,384 Cash Flows from Investing Activities Intangible assets - net Other assets 5,572 2,440 Purchases of property, plant and equipment (PP&E) 577.6 - 1,501 Total assets 48,307 Weighted average 3M common shares outstanding - basic in shares) Earnings per share attributable to 3M common shareholders - basic (in dollars per share) Weighted average 3M common shares outstanding - diluted in shares) Proceeds from sale of PP&E and other assets $9.32 128 Current liabilities 582.2 -25 1,981 Short-term borrowings and current portion of long-term debt Accounts payable -1,579 2,931 1,811 Accrued payroll 832 576 10 Accrued income taxes Operating lease liabilities - current 247 268 -580 Acquisitions, net of cash acquired Purchases of marketable securities and investments Proceeds from maturities and sale of marketable securities and investments Proceeds from sale of businesses, net of cash sold Other - net Net cash provided by (used in) investing activities Cash Flows from Financing Activities Change in short-term debt-net Repayment of debt (maturities greater than 90 days) Proceeds from debt (maturities greater than 90 days) Purchases of treasury stock Proceeds from issuance of treasury stock pursuant to stock option and benefit plans Dividends paid to shareholders Other current liabilities Total current liabilities Long-term debt 3,181 9,440 16,267 -143 -3,482 Pension and postretirement benefits 4,184 1,750 -368 Operating lease liabilities Other liabilities 603 3,297 429 -3,388 Total liabilities 33,791 33,791 Dividends paid to shareholders -3,388 Total liabilities Commitments and contingencies (Note 14) 3M Company shareholders' equity: -98 Other - net Net cash provided by (used in) financing activities -5,300 9 Common stock par value, $.01 par value: 944,033,056 shares issued; Shares outstanding - March 31, 2021: 579,675,002; Shares outstanding - December 31, 2020: 577,749,638 Additional paid-in capital 48 6,337 Effect of exchange rate changes on cash and cash equivalents Net increase (decrease) in cash and cash equivalents Cash and cash equivalents at beginning of year 2,281 Retained earnings 44,824 2,353 (29,236) (7,486) Treasury stock, at cost: Shares at March 31, 2021: 364,358,054; Shares at December 31, 2020: 366,283,418 Accumulated other comprehensive income (loss) Total 3M Company shareholders' equity Noncontrolling interest Total equity Total liabilities and equity 14,448 68 14,516 $ 48,307 Company: 3M Cost of Equity Risk Free Rate + Equity Risk Premium Beta x Market Risk Premium Expected Market Return - Risk Free Rate Market Capitalization Formula 1.74 % Provided in the guidelines Formula Value Formula 11.84 % Provided in the guidelines 1.74 % Link to cell B7 Value Enter the appropriate formulas or references in this table: Cost of Capital - Current Market Value Weight Cost WxC Equity Formula Formula Formula Debt (A-T) Formula Formula Formula WACC Formula Change in WACC if expected market return increases by 1.5 pp: Income Taxes/Taxable income Interest Expense/Total Debt Cost of Debt 1-Effective Tax Rate Effective Tax Rate x Total Pre-Tax Cost of Debt x Debt Adjustment Factor Total Debt Short Term Debt + Long Term Debt Formula Formula Value Value Value Formula Value Value Change in WACC if effective tax rate decreases by 5 pp: 1. (20 points) Calculate the company's weighted average cost of capital (WACC) using the template. Note that you should enter either a value or a formula (function) in cells. The following values are given: Risk-Free Rate: 1.74% Expected Market Return: 11.84% Debt Adjustment Factor: 1.00 The rest of the values can be retrieved from your previous assignments, with a few hints provided in the Excel file. Here is a formula example: Market Risk Premium = Expected Market Return Risk-Free Rate; that is, in the formula in cell B10 is =B11-B12"; additionally, the formula (reference) in cell B12 is "=B7". 2. (5 points) Answer the following questions. You can enter the number and write a sentence in the empty text box on the same Excel sheet. If you have entered all the formulas correctly, your WACC should automatically change as you change any of the input values: a. What will the new WACC be if the expected market return increases by 1.5 percentage points (for example, from 8.80% to 10.30%)? b. What will the new WACC be if the effective tax rate decreases by 5 percentage points (for example, from 27.10% to 22.10%)? Balance Sheet Cash Flow Statement Income Statement Item Consolidated Statement of Income Value Current assets Cash Flows from Operating Activities Jun. 30, 2021 Jun. 30, 2021 Jun. 30, 2021 Cash and cash equivalents $4,695 Net sales $32,184 $5,388 Marketable securities - current 805 Net income including noncontrolling interest Adjustments to reconcile net income including noncontrolling interest to net cash provided by operating activities Operating expenses 4,991 16,605 Accounts receivable - net of allowances of $231 and $233 Inventories 1,911 6,929 -156 Finished goods 2,356 Cost of sales Selling, general and administrative expenses Research, development and related expenses Gain on sale of businesses Total operating expenses Operating income 1,878 -389 25,023 7,161 Work in process Raw materials and supplies Total inventories Prepaids 1,342 1,144 4,842 406 262 -389 - 165 Depreciation and amortization Company pension and postretirement contributions Company pension and postretirement expense Stock-based compensation expense Gain on sale of businesses Deferred income taxes Loss on deconsolidation of Venezuelan subsidiary Changes in assets and liabilities Accounts receivable Inventories Accounts payable Accrued income taxes (current and long-term) 633 377 16,343 450 6,711 1,318 5,393 Other current assets Total current assets Property, plant and equipment Less: Accumulated depreciation Property, plant and equipment - net 27,132 Interest expense and income Other expense (income), net Income before income taxes Provision for income taxes Income of consolidated group Income (loss) from unconsolidated subsidiaries, net of taxes Net income including noncontrolling interest Less: Net income (loss) attributable to noncontrolling interest 165 -91 252 (17,774) 9,358 -5 132 Operating lease right of use assets 872 5,388 398 Goodwill 13,722 Other - net Net cash provided by (used in) operating activities 4 8,113 Net income attributable to 3M $5,384 5,384 Cash Flows from Investing Activities Intangible assets - net Other assets 5,572 2,440 Purchases of property, plant and equipment (PP&E) 577.6 - 1,501 Total assets 48,307 Weighted average 3M common shares outstanding - basic in shares) Earnings per share attributable to 3M common shareholders - basic (in dollars per share) Weighted average 3M common shares outstanding - diluted in shares) Proceeds from sale of PP&E and other assets $9.32 128 Current liabilities 582.2 -25 1,981 Short-term borrowings and current portion of long-term debt Accounts payable -1,579 2,931 1,811 Accrued payroll 832 576 10 Accrued income taxes Operating lease liabilities - current 247 268 -580 Acquisitions, net of cash acquired Purchases of marketable securities and investments Proceeds from maturities and sale of marketable securities and investments Proceeds from sale of businesses, net of cash sold Other - net Net cash provided by (used in) investing activities Cash Flows from Financing Activities Change in short-term debt-net Repayment of debt (maturities greater than 90 days) Proceeds from debt (maturities greater than 90 days) Purchases of treasury stock Proceeds from issuance of treasury stock pursuant to stock option and benefit plans Dividends paid to shareholders Other current liabilities Total current liabilities Long-term debt 3,181 9,440 16,267 -143 -3,482 Pension and postretirement benefits 4,184 1,750 -368 Operating lease liabilities Other liabilities 603 3,297 429 -3,388 Total liabilities 33,791 33,791 Dividends paid to shareholders -3,388 Total liabilities Commitments and contingencies (Note 14) 3M Company shareholders' equity: -98 Other - net Net cash provided by (used in) financing activities -5,300 9 Common stock par value, $.01 par value: 944,033,056 shares issued; Shares outstanding - March 31, 2021: 579,675,002; Shares outstanding - December 31, 2020: 577,749,638 Additional paid-in capital 48 6,337 Effect of exchange rate changes on cash and cash equivalents Net increase (decrease) in cash and cash equivalents Cash and cash equivalents at beginning of year 2,281 Retained earnings 44,824 2,353 (29,236) (7,486) Treasury stock, at cost: Shares at March 31, 2021: 364,358,054; Shares at December 31, 2020: 366,283,418 Accumulated other comprehensive income (loss) Total 3M Company shareholders' equity Noncontrolling interest Total equity Total liabilities and equity 14,448 68 14,516 $ 48,307