Refine Assumptions for PPE Forecast

Following are the income statement and balance sheet for Medtronic PLC.

Medtronic PLCConsolidated Statement of Income For Fiscal Year Ended$ millionsApril 26, 2019Net sales$36,668Costs and expenses Cost of products sold10,986Research and development expense2,796Selling, general, and administrative expense12,502Amortization of intangible assets2,117Restructuring charges, net238Certain litigation charges, net199Other operating expense, net310Operating profit7,520Other nonoperating income, net(448)Interest expense1,733Income before income taxes6,235Income tax provision656Net income5,579Net income loss attributable to noncontrolling interests(23)Net income attributable to Medtronic$5,556

Medtronic PLCConsolidated Balance Sheet$ millionsApril 26, 2019Current assets Cash and cash equivalents$5,272Investments6,546Accounts receivable, net7,466Inventories, net4,504Other current assets2,573Total current assets26,361Property, plant, and equipment, net5,610Goodwill47,951Other intangible assets, net24,672Tax assets1,823Other assets1,217Total assets$107,634Current liabilities Current debt obligations$1,006Accounts payable2,344Accrued compensation2,627Accrued income taxes680Other accrued expenses3,510Total current liabilities10,167Long-term debt29,383Accrued compensation and retirement benefits1,981Accrued income taxes3,406Deferred tax liabilities1,534Other liabilities908Total liabilities47,379Shareholders equity Ordinary shares0Additional paid-in capital31,839Retained earnings31,524Accumulated other comprehensive loss(3,253)Total shareholders equity60,110Noncontrolling interests145Total equity60,255Total liabilities and equity$107,634

Note: Complete the entire question in Excel using the following template: Excel Template. Format each answer to two decimal places. Then enter the answers into the provided spaces below with two decimal places.

a. Use the financial statements along with the additional information below to forecast property, plant and equipment, net for fiscal year ended April 2020.

$ millionsApril 27, 2018 ActualApril 26, 2019 ActualApril 2020 Forecast Net sales$35,944$36,668$33,002 CAPEX1,2821,134 Depreciation expense985895 Property, plant, and equipment, gross12,31110,920 Property, plant, and equipment, net

Answer

b. Suppose the company discloses in a press release that accompanies its year-end SEC filing that anticipated CAPEX for fiscal year ended April 2020 is as follows.

Company anticipated CAPEX for fiscal year ended April 2020$1,800million

Use this guidance to refine your forecast of property, plant and equipment, net for fiscal year ended April 2020.

Property, plant, and equipment, net

Answer

million

Medtronic PLCConsolidated Balance Sheet$ millionsApril 26, 2019Current assets Cash and cash equivalents$5,272Investments6,546Accounts receivable, net7,466Inventories, net4,504Other current assets2,573Total current assets26,361Property, plant, and equipment, net5,610Goodwill47,951Other intangible assets, net24,672Tax assets1,823Other assets1,217Total assets$107,634Current liabilities Current debt obligations$1,006Accounts payable2,344Accrued compensation2,627Accrued income taxes680Other accrued expenses3,510Total current liabilities10,167Long-term debt29,383Accrued compensation and retirement benefits1,981Accrued income taxes3,406Deferred tax liabilities1,534Other liabilities908Total liabilities47,379Shareholders equity Ordinary shares0Additional paid-in capital31,839Retained earnings31,524Accumulated other comprehensive loss(3,253)Total shareholders equity60,110Noncontrolling interests145Total equity60,255Total liabilities and equity$107,634

Note: Complete the entire question in Excel using the following template: Excel Template. Format each answer to two decimal places. Then enter the answers into the provided spaces below with two decimal places.

a. Use the financial statements along with the additional information below to forecast property, plant and equipment, net for fiscal year ended April 2020.

$ millionsApril 27, 2018 ActualApril 26, 2019 ActualApril 2020 Forecast Net sales$35,944$36,668$33,002 CAPEX1,2821,134 Depreciation expense985895 Property, plant, and equipment, gross12,31110,920 Property, plant, and equipment, net

Answer

b. Suppose the company discloses in a press release that accompanies its year-end SEC filing that anticipated CAPEX for fiscal year ended April 2020 is as follows.

Company anticipated CAPEX for fiscal year ended April 2020$1,800million

Use this guidance to refine your forecast of property, plant and equipment, net for fiscal year ended April 2020.

Property, plant, and equipment, netAnswermillion