Forecast the data for 2020

Medtronic PLC Consolidated Balance Sheet $ millions April 26, 2019 Current assets Use the following assumptions to prepare a forecast of the company's 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. \begin{tabular}{|l|r|l|} \hline Investments & No change \\ \hline Accounts receivable, less allowance & 20.4% & of net sales \\ \hline Inventories, net & 12.3% & of net sales \\ \hline Other current assets & 7% & of net sales \\ \hline Goodwill & No change \\ \hline Tax assets & 5% & of net sales \\ \hline Other assets & 3.3% & of net sales \\ \hline Accounts payable & 6.4% & of net sales \\ \hline Accrued compensation (current liability) & 7.2% & of net sales \\ \hline Accrued compensation and retirement benefits (noncurrent liability) & & No change \\ \hline Accrued income taxes (current liability) & 1.9% & of net sales \\ \hline Other accrued expenses & 9.6% & of net sales \\ \hline Accrued income taxes (noncurrent liability) & 9.3% & of net sales \\ \hline Deferred tax liabilities & 4.2% & of net sales \\ \hline Other liabilities & 2.5% & of net sales \\ \hline Ordinary shares & & No change \\ \hline Accumulated other comprehensive loss & No change \\ \hline Net income attributable to noncontrolling interest & $19 & million \\ \hline Dividends in FY2020 & $2,853 & million \\ \hline CAPEX in FY2019 & $1,134 & $ million, forecast CAPEX at historic % of net sales \\ \hline Depreciation expense in FY2020 & $950 & million \\ \hline Amortization expense in FY2020 & $1,914 & million \\ \hline Debt due in FY2020 & $838 & million \\ \hline Debt due in FY2021 & $2,058 & million \\ \hline \end{tabular} Medtronic PLC Consolidated Balance Sheet $millions 2020 Current assets Cash and cash equivalents Investments Accounts receivable, net Inventories, net Other current assets Medtronic PLC Consolidated Balance Sheet $ millions April 26, 2019 Current assets Use the following assumptions to prepare a forecast of the company's 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. \begin{tabular}{|l|r|l|} \hline Investments & No change \\ \hline Accounts receivable, less allowance & 20.4% & of net sales \\ \hline Inventories, net & 12.3% & of net sales \\ \hline Other current assets & 7% & of net sales \\ \hline Goodwill & No change \\ \hline Tax assets & 5% & of net sales \\ \hline Other assets & 3.3% & of net sales \\ \hline Accounts payable & 6.4% & of net sales \\ \hline Accrued compensation (current liability) & 7.2% & of net sales \\ \hline Accrued compensation and retirement benefits (noncurrent liability) & & No change \\ \hline Accrued income taxes (current liability) & 1.9% & of net sales \\ \hline Other accrued expenses & 9.6% & of net sales \\ \hline Accrued income taxes (noncurrent liability) & 9.3% & of net sales \\ \hline Deferred tax liabilities & 4.2% & of net sales \\ \hline Other liabilities & 2.5% & of net sales \\ \hline Ordinary shares & & No change \\ \hline Accumulated other comprehensive loss & No change \\ \hline Net income attributable to noncontrolling interest & $19 & million \\ \hline Dividends in FY2020 & $2,853 & million \\ \hline CAPEX in FY2019 & $1,134 & $ million, forecast CAPEX at historic % of net sales \\ \hline Depreciation expense in FY2020 & $950 & million \\ \hline Amortization expense in FY2020 & $1,914 & million \\ \hline Debt due in FY2020 & $838 & million \\ \hline Debt due in FY2021 & $2,058 & million \\ \hline \end{tabular} Medtronic PLC Consolidated Balance Sheet $millions 2020 Current assets Cash and cash equivalents Investments Accounts receivable, net Inventories, net Other current assets