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 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 company$$s income statement 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.

Income statement assumptions

Net sales increase $8\%$ growth

Cost of products sold $30\mathrm{.}0\%$ of net sales

Research and development expense $7\mathrm{.}6\%$ of net sales

Selling, general, and administrative expense $34\mathrm{.}1\%$ of net sales

Amortization of intangible assets $5\mathrm{.}8\%$ of net sales

Restructuring charges, net $75\%$ of $2019$ restructuring expense

Certain litigation charges, net $$150$ million

Other operating expense, net No change in $ amount

Other nonoperating income, net No change in $ amount

Interest expense No change in $ amount

Income tax provision $15\%$ of pretax income

Income attributable to noncontrolling interests No change in $ amount

Medtronic PLC

Consolidated Statement of Income

$ millions

For Fiscal Year Ended $2020$

Net sales Answer

$33,009\mathrm{.}56$

Costs and expenses

Cost of products sold Answer

$9,902\mathrm{.}87$

Research and development expense Answer

$2,510\mathrm{.}32$

Selling, general, and administrative expense Answer

$11,268\mathrm{.}16$

Amortization of intangible assets Answer

$1,916\mathrm{.}94$

Restructuring charges, net Answer

$59\mathrm{.}25$

Certain litigation charges, net Answer

$150$

Other operating expense, net Answer

$258$

Operating profit Answer

$7,944\mathrm{.}82$

Other nonoperating income, net Answer

$149$

Interest expense Answer

$1,444$

Income before income taxes Answer

$6,351\mathrm{.}82$

Income tax provision Answer

$952\mathrm{.}77$

Net income Answer

$5,399\mathrm{.}05$

Net income loss attributable to noncontrolling interests Answer

$19$

Net income attributable to Medtronic