Refine Assumptions for PPE Forecast Following are the income statement and balance sheet for Medtronic PLC. Medtronic PLC Consolidated Statement of Income For Fiscal Year Ended Net sales Costs and expenses $ millions Cost of products sold Research and development expense Selling, general, and administrative expense Amortization of intangible assets Restructuring charges, net Certain litigation charges, net Other operating expense, net Operating profit Other nonoperating income, net Interest expense Income before income taxes Income tax provision Not income April 26, 2019 $36,668 10,986 2,796 12,502 2,117 238 199 310 7,520 (448) 1,733 6,235 656

Refine Assumptions for PPE Forecast \begin{tabular}{|l|r|} \hline Interest expense & 1,733 \\ \hline Income before income taxes & 6,235 \\ \hline Income tax provision & 656 \\ \hline Net income & 5,579 \\ \hline Net income loss attributable to noncontrolling interests & (23) \\ \hline Net income attributable to Medtronic & $5,556 \\ \hline \end{tabular} \begin{tabular}{|lr|} \hline \multicolumn{1}{|c|}{CodtronicPLC$millions} & April26,2019 \\ \hline Current assets & \\ \hline Cash and cash equivalents & $5,272 \\ \hline Investments & 6,546 \\ \hline Accounts receivable, net & 7,466 \\ \hline Inventories, net & 4,504 \\ \hline Other current assets & 2,573 \\ \hline Total current assets & 26,361 \\ \hline Property, plant, and equipment, net & 5,610 \\ \hline Goodwill & 47,951 \\ Other intangible assets, net & 24,672 \\ \hline Tax assets & 1,823 \\ \hline \end{tabular} \begin{tabular}{|l|r|} \hline Goodwill & 47,951 \\ \hline Other intangible assets, net & 24,672 \\ \hline Tax assets & 1,823 \\ \hline Other assets & 1,217 \\ \hline Total assets & $107,634 \\ \hline Current liabilities & \\ \hline Current debt obligations & $1,006 \\ \hline Accounts payable & 2,344 \\ \hline Accrued compensation & 2,627 \\ \hline Accrued income taxes & 680 \\ \hline Other accrued expenses & 3,510 \\ \hline Total current liabilities & 10,167 \\ \hline Long-term debt & 29,383 \\ \hline Accrued compensation and retirement benefits & 1,981 \\ \hline Accrued income taxes & 3,406 \\ \hline Deferred tax liabilities & 1,534 \\ \hline Other liabilities & 908 \\ \hline Total liabilities & 47,379 \\ \hline Shareholders' equity & 0 \\ \hline Ordinary shares & 31,839 \\ \hline Additional paid-in capital & 31.524 \\ \hline Retainer earnines & \\ \hline \end{tabular} Note: Complete the entire question in Excel using the following template: Excel Template. Format each answer to two decimal places, Then enter the answe 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 . b. Suppose the company discloses in a press release that accompanies its year-end SEC filing that anticipated CAPEX for fiscal ye Use this guidance to refine your forecast of property, plant and equipment, net for fiscal year ended April 2020. Property, plant, and equipment, net milion