Forecast Income Statement and Balance Sheet Following are the income statement and balance sheet for Medtronic PLC. Note: Complete the entire question using the following Excel template: Excel Template . Then enter the answers into the provided spaces below with two decimal places. Medtronic PLC Consolidated Statement of Income $ millions, For Fiscal Year Ended April 26, 2019 Net sales $30,557 Costs and expenses Cost of products sold 9,155 Research and development expense 932 Selling, general, and administrative expense 10,418 Amortization of intangible assets 1,764 Restructuring charges, net 79 Certain litigation charges, net 166 Other operating expense, net 258 Operating profit 7,785 Other nonoperating income, net (149) Interest expense 1,444 Income before income taxes 6,490 Income tax provision 547 Net income 5,943 Net income loss attributable to noncontrolling interests (19) Net income attributable to Medtronic $5,924 Medtronic PLC Consolidated Balance Sheet $ millions April 26, 2019 Current assets Cash and cash equivalents $4,393 Investments 5,455 Accounts receivable, net 6,222 Inventories, net 3,753 Other current assets 858 Total current assets 20,681 Property, plant, and equipment, net 4,675 Goodwill 39,959 Other intangible assets, net 20,560 Tax assets 608 Other assets 1,014 Total assets $87,497 Current liabilities Current debt obligations $838 Accounts payable 1,953 Accrued compensation 2,189 Accrued income taxes 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 303 Total liabilities 39,028 Shareholders equity Ordinary shares 0 Additional paid-in capital 24,789 Retained earnings 26,270 Accumulated other comprehensive loss (2,711) Total shareholders equity 48,348 Noncontrolling interests 121 Total equity 48,469 Total liabilities and equity $87,497 Income Statement Balance Sheet Use the following assumptions to prepare a forecast of the companys balance sheet for fiscal year 2020. Note: Complete the entire question in Excel (template provided above). Using Excel, format each answer to two decimal places. Use Increase Decimal or Decrease Decimal to adjust 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 No change Accounts receivable, less allowance 20.4% of net sales Inventories, net 12.3% of net sales Other current assets 7% of net sales Goodwill No change Tax assets 5% of net sales Other assets 3.3% of net sales Accounts payable 6.4% of net sales Accrued compensation (current liability) 7.2% of net sales Accrued compensation and retirement benefits (noncurrent liability) No change Accrued income taxes (current liability) 1.9% of net sales Other accrued expenses 9.6% of net sales Accrued income taxes (noncurrent liability) 9.3% of net sales Deferred tax liabilities 4.2% of net sales Other liabilities 2.5% of net sales Ordinary shares No change Accumulated other comprehensive loss No change Net income attributable to noncontrolling interest $19 million Dividends in FY2020 $2,853 million CAPEX in FY2019 $1,134 $million, forecast CAPEX at historic % of net sales Depreciation expense in FY2020 $950 million Amortization expense in FY2020 $1,914 million Debt due in FY2020 $838 million Debt due in FY2021 $2,058 million Medtronic PLC Consolidated Balance Sheet $ millions 2020 Current assets Cash and cash equivalents Answer 3,411 Investments Answer 5,455 Accounts receivable, net Answer 6,732 Inventories, net Answer 4,059 Other current assets Answer 2,310 Total current assets Answer 20,595 Property, plant, and equipment, net Answer 4,675 Goodwill Answer 39,959 Other intangible assets, net Answer 18,646 Tax assets Answer 1,650 Other assets Answer 1,089 Total assets Answer 91,986 Current liabilities Current debt obligations Answer 2,058 Accounts payable Answer 2,112 Accrued compensation Answer 2,376 Accrued income taxes Answer 627 Other accrued expenses Answer 3,168 Total current liabilities Answer 103,410 Long-term debt Answer 22,428 Accrued compensation and retirement benefits Answer 1,651 Accrued income taxes Answer 3,069 Deferred tax liabilities Answer 1,386 Other liabilities Answer 825 Total liabilities Answer 39,700 Shareholders equity Ordinary shares Answer 0 Additional paid-in capital Answer 26,532 Retained earnings Answer 28,325 Accumulated other comprehensive loss Answer (2,711) Total shareholders equity Answer 52,146 Noncontrolling interests Answer 140 Total equity Answer 52,286 Total liabilities and equity Answer 91,986