Forecast Income Statement and Balance SheetFollowing 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 PLCConsolidated Statement of Income$ millions, For Fiscal Year EndedApril $26,2019$Net sales$$30,557$Costs and expensesCost 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 PLCConsolidated Balance Sheet$ millionsApril $26,2019$Current assetsCash 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 liabilitiesCurrent 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 equityOrdinary 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 StatementBalance SheetUse 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 assumptionsInvestmentsNo changeAccounts receivable, less allowance$20\mathrm{.}4\%$of net salesInventories, net$12\mathrm{.}3\%$of net salesOther current assets$7\%$of net salesGoodwillNo changeTax assets$5\%$of net salesOther assets$3\mathrm{.}3\%$of net salesAccounts payable$6\mathrm{.}4\%$of net salesAccrued compensation $($current liability$)7\mathrm{.}2\%$of net salesAccrued compensation and retirement benefits $($noncurrent liability$)$No changeAccrued income taxes $($current liability$)1\mathrm{.}9\%$of net salesOther accrued expenses$9\mathrm{.}6\%$of net salesAccrued income taxes $($noncurrent liability$)9\mathrm{.}3\%$of net salesDeferred tax liabilities$4\mathrm{.}2\%$of net salesOther liabilities$2\mathrm{.}5\%$of net salesOrdinary sharesNo changeAccumulated other comprehensive lossNo changeNet income attributable to noncontrolling interest$$19$millionDividends in FY$2020$$$2,853$millionCAPEX in FY$2019$$$1,134$$million, forecast CAPEX at historic $\%$ of net salesDepreciation expense in FY$2020$$$950$millionAmortization expense in FY$2020$$$1,914$millionDebt due in FY$2020$$$838$millionDebt due in FY$2021$$$2,058$million

$\backslash$table$[[$c$,],[$Accrued compensation,$2,376vv$