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 Net income Net income loss attributable to noncontrolling interests Net income attributable to Medtronic April 26, 2019 $36,668 10,986 2,796 12,502 2,117 238 199 310 7,520 (448) 1,733 6,235 656 5,579 (23) $5,556
Refine Assumptions for PPE Forecast Following are the income statement and balance sheet for Medtronic PLC. \begin{tabular}{|l|r|} \hline \multicolumn{1}{|c|}{ \$ millions } & April 26, \\ \hline Current assets & 2019 \\ \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 \\ \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 taxliablities & 1,534 \\ \hline Other liabilities & 908 \\ \hline Total liabilites & 47,379 \\ \hline Shareholders equity & \\ \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 answers decimal places. a. Use the financial statements alongr 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 year ended April 2020 is as follor compary anticipated CApex for fiscal year ended April 202051,000 mition Use this guidance to refine your forecast of property, plant and equipment, net for fiscal year ended April 2020. Note: Complete the entire question in Excel using the following template: Excel Template. Format each answer to two decimal places. Then enter the answers int 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 year ended April 2020 is as follows. Compary anticipated CAPEX for fiscal year ended Apnil 2020$1,800 millica Use this guidance to refine your forecast of property, plant and equipment, net for fiscal year ended April 2020. Property, plant and equipment net Emilion