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.

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.

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	943
Total current assets	20,766
Property, plant, and equipment, net	4,675
Goodwill	39,959
Other intangible assets, net	20,560
Tax assets	668
Other assets	1,014
Total assets	$87,642
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	333
Total liabilities	39,058
Shareholders equity
Ordinary shares	0
Additional paid-in capital	24,904
Retained earnings	26,270
Accumulated other comprehensive loss	(2,711)
Total shareholders equity	48,463
Noncontrolling interests	121
Total equity	48,584
Total liabilities and equity	$87,642