I need assistance completing the income statement and balance sheet, please.

Following are the income statement and balance sheet for Medtronic PLC. Note: Complete the entire question using the following Excel template: Excel Template. Consolidated Statement of Income \begin{tabular}{|c|c|} \hline$ millions, For Fiscal Year Ended & \begin{tabular}{c} April \\ 26 , \\ 2019 \end{tabular} \\ \hline Net sales & $30,557 \\ \hline \multicolumn{2}{|l|}{ Costs and expenses } \\ \hline Cost of products sold & 9,155 \\ \hline Research and development expense & 1,118 \\ \hline Selling, general, and administrative expense & 10,418 \\ \hline Amortization of intangible assets & 1,764 \\ \hline Restructuring charges, net & 95 \\ \hline Certain litigation charges, net & 166 \\ \hline Other operating expense, net & 258 \\ \hline Operating profit & 7,583 \\ \hline Other nonoperating income, net & (179) \\ \hline Interest expense & 1,444 \\ \hline Income before income taxes & 6,318 \\ \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 \end{tabular} \begin{tabular}{|c|c|} \hline \begin{tabular}{c} Medtronic PLC \\ Consolidated Balance Sheet \end{tabular} & \begin{tabular}{l} April \\ 26, \\ 2019 \end{tabular} \\ \hline \multicolumn{2}{|l|}{ Current assets } \\ \hline Cash and cash equivalents & $4,393 \\ \hline Investments & 5,455 \\ \hline Accounts receivable, net & 6,222 \\ \hline Inventories, net & 3,753 \\ \hline Other current assets & 1,029 \\ \hline Total current assets & 20,852 \\ \hline Property, plant, and equipment, net & 4,675 \\ \hline Goodwill & 39,959 \\ \hline Other intangible assets, net & 20,560 \\ \hline Tax assets & 729 \\ \hline Other assets & 1,014 \\ \hline Total assets & $87,789 \\ \hline \multicolumn{2}{|l|}{ Current liabilities } \\ \hline Current debt obligations & $838 \\ \hline Accounts payable & 1,953 \\ \hline Accrued compensation & 2.189 \\ \hline \end{tabular} \begin{tabular}{|l|r|} \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 Total equity & 48,701 \\ \hline Total liabilities and equity & $87,789 \\ \hline \hline \end{tabular} Use the foliowing 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 Excet, format esch answer to two decimal places. Use increase Oecinal or Oocrase. 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. \begin{tabular}{|l|r|} \hline \multicolumn{1}{|c|}{\begin{tabular}{c} Medtronic PLC \\ Consolidated Statement of Income \\ \$ millions \\ For Fiscal Year Ended \end{tabular}} & \multicolumn{1}{c|}{2020} \\ \hline Net sales & 33,001.56 \\ \hline Costs and expenses & \\ \hline Cost of products sold & 9,900.47 \\ \hline Research and development expense & 2,508.12 \\ \hline Selling, general, and administrative expense & 11,253.53 \\ \hline Amortization of intangible assets & 1,914.09 \\ \hline Restructuring charges, net & 71.25 \\ \hline Certain litigation charges, net & 150 \\ \hline Other operating expense, net & 258 \\ \hline Operating profit & 6,946.1 \\ \hline Other nonoperating income, net & (179) \\ \hline Interest expense & 1,444 \\ \hline Income before income taxes & 5,323.1 \\ \hline Income tax provision & 851.57 \\ \hline Net income & 4,825.54 \\ \hline Net income loss attributable to noncontrolling interests & (19) \\ \hline Net income attributable to Medtronic & $4,806.54 \\ \hline \end{tabular} Use the following assumptions to prepare a forecast of the comparys's balance sheet for fiscal year 2020 Note; Comptete the entire question in Excet (temptate provided above). Using Excel, format each answer to two decimat 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 fwo decimal places. Note: Use negative signs with answers, when appropriate Balance sheet assumptions \begin{tabular}{|c|c|c|} \hline Investments & & No change \\ \hline Accounts receivable, less allowance & 20.4% & of net sales \\ \hline Inventories, net & 12.3% & of net sales \\ \hline Other current assets & 7% & of net sales \\ \hline Goodwill & & No change \\ \hline Tax assets & 5% & of net sales \\ \hline Other assets & 3.39 & of net sales \\ \hline Accounts payable & 6.4% & of net sales \\ \hline Accrued compensation (current liability) & 7.2% & of net sales \\ \hline Accrued compensation and retirement benefits (noncurrent liability) & & No change \\ \hline Accrued income taxes (current liability) & 1.9% & of net sales \\ \hline Other accrued expenses & 9.6% & of net sales. \\ \hline Accrued income taxes (noncurrent liability) & 9.3% & of net sales \\ \hline Deferred tax liabilities & 4.2% & of net sales \\ \hline Other liabilities & 2.5% & of net sales \\ \hline Ordinary shares & & No change \\ \hline Accumulated other comprehensive loss & & No change \\ \hline Net income attributable to noncontrolling interest & $19 & million \\ \hline Dividends in FY2020 & $2,853 & million \\ \hline & $1,134 & Smillion, forecast CAPEX at historic 1\% of net sales \\ \hline \end{tabular} \begin{tabular}{|c|c|c|} \hline Goodwill & & No change \\ \hline Tax assets & 59 & of net sales \\ \hline Other assets & 3.39 & of net sales \\ \hline Accounts payable & 6.4% & of net sales \\ \hline Accrued compensation (current liability) & 7.296 & of net sales \\ \hline Accrued compensation and retirement benefits (noncurrent liability) & & No change \\ \hline Accrued income taxes (current liability) & 1.9% & of net sales \\ \hline Other accrued expenses & 9.6% & of net sales \\ \hline Accrued income taxes (noncurrent liability) & 9.3% & of net sales \\ \hline Deferred tax liabilities: & 4.2% & of net sales \\ \hline Other liabilities & 2.5% & of net sales \\ \hline Ordinary shares & & No change \\ \hline Accumulated other comprehensive loss & & No change \\ \hline Net income attributable to noncontrolling interest & $19 & million \\ \hline Dividends in FY20O20 & $2,853 & million \\ \hline CAPEX in FY2019 & $1,134 & Smillion, forecast CAPEX at historic io of net sales \\ \hline Depreciation expense in F2O22 & $950 & million \\ \hline Amortization expense in FY2O20 & $1,914 & million \\ \hline Debt due in FYZ2020 & $838 & million \\ \hline Debt due in FY2021 & $2,058 & million \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|} \hline \begin{tabular}{c} Medtronic PLC \\ Consolidated Balance Sheet \\ S millions \end{tabular} & & 2020 & \\ \hline \multicolumn{4}{|l|}{ Current assets } \\ \hline Cash and cash equivalents & $ & & 0x \\ \hline Investments & & & 0 \\ \hline Accounts receivable, net & 4 & & 0x \\ \hline Inventories, net & & & 0x \\ \hline Other current assets & & & 0x \\ \hline Total current assets & & & 0x \\ \hline Property, plant, and equipment, net & & & 0x \\ \hline Goodwill & & & 0x \\ \hline Other intangible assets, net & & & 0 \\ \hline Tax assets & & & 0 \\ \hline Other assets & & & 0x \\ \hline Total assets & $ & & 0x \\ \hline \multicolumn{4}{|l|}{ Current liabilities } \\ \hline Current debt obligations & $ & & 0 \\ \hline Accounts payable & & & 0 \\ \hline Accrued compensation & & & 0 \\ \hline Accrued income taxes & & & 0 \\ \hline \end{tabular} \begin{tabular}{|l|c|} \hline Accounts payable & 0 \\ \hline Accrued compensation & 0 \\ \hline Accrued income taxes & 0 \\ \hline Other accrued expenses & 0 \\ \hline 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 & $ \\ \hline \end{tabular}