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. Medtronic PLC Consolidated Statement of Income S millions, For Fiscal Year Ended Net sales Costs and expenses 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 April 26, 2019 $30,557 9,155 1,118 10,418 1,764 95 166 258 7,583 (179) 1,444 6,318 547

Following are the income statement and balance sheet for Medtronic PLC. Note: Complete the entire question using the following Excel template: Excel Template. Then eriter the answers into the provided spaces below with two decimal places: \begin{tabular}{|l|r|} \hline Income tax provision & 547 \\ \hline Net income & 5,771 \\ \hline Net income loss attributable to noncontrolling interests & (19) \\ \hline Net income attributable to Medtronic & $5,752 \\ \hline \hline \end{tabular} \begin{tabular}{|l|r|} \hline Total assets & $87,789 \\ \hline Current liabilities & \\ \hline Current debt obligations & $838 \\ \hline Accounts payable & 1,953 \\ \hline Accrued compensation & 2,189 \\ \hline Accrued income taxes & 567 \\ \hline Other accrued expenses & 2,925 \\ \hline Total current liabilities & 8,472 \\ \hline Long-term debt & 24,486 \\ \hline Accrued compensation and retirement benefits & 1,651 \\ \hline Accrued income taxes & 2,838 \\ \hline Deferred tax liabilities & 1,278 \\ \hline Other liabilities & 363 \\ \hline Total liabilities & 39,088 \\ \hline Shareholders' equity & \\ \hline Ordinary shares & 0 \\ \hline Additional paid-in capital & 25,021 \\ \hline Retained earnings & 26,270 \\ \hline Accumulated other comprehensive loss & (2,711) \\ \hline Total shareholders' equity & 48,580 \\ \hline Noncontrolling interests & 121 \\ \hline \end{tabular} 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 deci 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. Note: Use negative signs with answers, when appropriate. \begin{tabular}{|l|r|} \hline Accounts payable & 0 \\ \hline Accrued compensation & 0 \\ \hline Accrued income taxes & 0 \\ \hline Other accrued expenses & 0 \\ \hline \multicolumn{1}{|c|}{ Total current liabilities } & 0 \\ \hline Long-term debt & 0 \\ \hline Accrued compensation and retirement benefits & 0 \\ \hline Accrued income taxes & 0 \\ \hline Deferred tax liabilities & 0 \\ \hline Other liabilities & 0 \\ \hline Total liabilities & 0 \\ \hline Shareholders' equity & 0 \\ \hline Ordinary shares & 0 \\ \hline Additional paid-in capital & 0 \\ \hline Retained earnings & 0 \\ \hline Accumulated other comprehensive loss & 0 \\ \hline Total shareholders' equity & 0 \\ \hline Noncontrolling interests & 0 \\ \hline Total equity & 0 \\ \hline Total liabilities and equity & 0 \\ \hline \end{tabular}