Following are the income statement and balance sheet for Medtronic PLC. Note: Complete the entire question using the following Excel template: Ex Medtronic PLC Consolidated Statement of Income April 26, $ millions, For Fiscal Year Ended 2019 Net sales $30,557 Costs and expenses Cost of products sold 9.155 Research and development expense 1,118 Selling, general, and administrative expense 10,418 Amortization of intangible assets 1,764 Restructuring charges, net 95 Certain litigation charges, net 166 Other operating expense, net 258 Operating profit 7,583 Other nonoperating income, net (179) Interest expense 1,444 Income before income taxes 6,318 Income tax provision 547 Net income 5,771 Net income loss attributable to noncontrolling interests Net income attributable to Medtronic (19) $5,752 Medtronic PLC Consolidated Balance Sheet April 26, 2019 $ millions Current assets Cash and cash equivalents $4,393 Investments 5,455 Accounts receivable, net 6,222 Inventories, net 3.753 Other current assets 1,029 Total current assets 20,852 Property, plant, and equipment, net 4,675 Goodwill 39,959 Other intangible assets, net 20.560 Tax assets 729 Other assets 1,014 Total assets $87,789 Current liabilities Current debt obligations $838 Accounts payable 1,953 Accrued compensation Accrued income taxes 2,189 567 Other accrued expenses 2,925 Total current liabilities 8,472 Long-term debt 24,486 Accrued compensation and retirement benefits 1,651 Accrued income taxes 2,838 Deferred tax liabilities 1,278 Other liabilities 262 Accrued compensation and retirement benefits 1,651 Accrued income taxes 2,838 Deferred tax liabilities 1,278 Other liabilities Total liabilities 363 39,088 Shareholders' equity Ordinary shares 0 Additional paid-in capital 25,021 Retained earnings 26,270 Accumulated other comprehensive loss (2.711) Total shareholders' equity 48,580 Noncontrolling interests 121 Total equity 48,701 Total liabilities and equity $87,789 Income Statement Balance Sheet Use the following assumptions to prepare a forecast of the company's income statement for fiscal year 2020. Note: Complete the entire question in Excel (template provided above). Using Excel, format each answer to decimal places. Do not round answers. Then enter the answers into the provided spaces below with two decimal Note: Use negative signs with answers, when appropriate. Income statement assumptions Net sales increase 8% growth Cost of products sold 30.0% of net sales Research and development expense 7.6% of net sales Selling, general, and administrative expense 34.1% of net sales Amortization of intangible assets Restructuring charges, net Certain litigation charges, net Other operating expense, net Other nonoperating income, net Interest expense Income tax provision Income attributable to noncontrolling interests 5.8% of net sales 75% of 2019 restructuring expense $150 million No change in $ amount No change in $ amount No change in $ amount 15% of pretax income No change in S amount Note: Complete the entire question in Excel (template provided above). Using Excel, format each answer to two decimal places. Use Increase C decimal places. Do not round answers. Then enter the answers into the provided spaces below with two decimal places... Note: Use negative signs with answers, when appropriate. Balance sheet assumptions Investments Accounts receivable, less allowance Inventories, net Other current assets Goodwill Tax assets Other assets Accounts payable Accrued compensation (current liability) Accrued compensation and retirement benefits (noncurrent liability) Accrued income taxes (current liability) Other accrued expenses Accrued income taxes (noncurrent liability) No change 20.4% of net sales 12.3% of net sales 7% of net sales No change 5% of net sales 3.3% of net sales 6.4% of net sales 7.2% of net sales No change 1.9% of net sales 9.6% of net sales 9.3% of net sales 4.2% of net sales Deferred tax liabilities Other liabilities Ordinary shares Accumulated other comprehensive loss Net income attributable to noncontrolling interest Dividends in FY2020 CAPEX in FY2019 Depreciation expense in FY2020 Amortization expence in FY2020 Debt dus in FY2020 Debt due in FY2021 2.5% of net sales No change No change $19 million $2.853 million $1,134 Smillion forecast CAPEX at historic % of net sales $950 million $1,914 million $838 million $2.058 million Medtronic PLC Consolidated Balance Sheet Current assets $ millions Cash and cash equivalents Investments Accounts receivable, net Inventories, net Other current assets Total current assets Property, plant, and equipment, net Goodwill Other intangible assets, net Tax assets Other assets 2020 $ 0 0 0 0 0 0 0 0 0 Total assets Current liabilities Current debt obligations Accounts payable Accrued compensation 5 i 0 0 0 0 Accrued income taxes Other accrued expenses 0 0 Total current liabilities Long-term debt 0 0 Accrued compensation and retirement benefits 0 Accrued income taxes 0 Deferred tax liabilities Other liabilities Total liabilities 0 Total liabilities Shareholders' equity Ordinary shares Additional paid-in capital Retained earnings Accumulated other comprehensive loss Total shareholders' equity Noncontrolling interests Total equity Total liabilities and equity +A $ 0 0 0 0 0 0 0 0 0