prepare an income statement and a balance sheet
Forecast income statement and Balance sheet Fotlowing ape the incorme staternent and balance sheet for Medtronic PLC Note: Complete the entire question using the following Excel template: Excel Template. Then enthr the answers into the provided spaces below with two decimal places. Use the following assumptions to prepare a focecast of the comparys income statement for focal year 2020 Note Complete the entire quwition in tricel (template provided above). Using Fxcel, format each answer to two decimal places, Use Increase Decimal or Decrease Decima/ to adjust decimal placet Do not round answers. Then enter the andwers into the provided spaces below with fWro decind places. Use the following aswamptions to prepare a fotecast of the companys income statement for fiscal year 2020 . Note: Complete the entire question in Excel fiemplate provided abovel. Using Excel, format each answer to two decimat places. Use increase Decima/ or Decrease Decima/ to adjust decimal places, Do not round answers. Then enter the answers into the provided spaces below with fwo decimal ploces. Note: Use nepative vgrs wh answers, when oppopprate. \begin{tabular}{l} \begin{tabular}{c} Medtronic PLC \\ Consolidated Statement of Income \\ \$ m millions \\ For Fiscal Year Ended \end{tabular} \\ \hline Net sales \\ \hline Costs and expenses \\ \hline Cost of products sold \\ \hline Research and development expense \\ \hline Selling general, and administrative expense \\ \hline Amortization of intangible assets \\ \hline Restructuring charges, net \\ \hline Certain litigation charges, net \\ \hline Other operating expense, net \\ \hline Operating profit \\ \hline Other nonoperating income, net \\ \hline Interest expense \\ \hline Income before income taxes \\ \hline Income tax provision \\ \hline Net income \\ \hline Net income loss attributable to noncontrolling interests \\ \hline Net income attributable to Medtronic \\ \hline \end{tabular} Medtronic PLC Consolidated Balance sheet 5 millions 2020 \begin{tabular}{|c|c|} \hline Current assets & \\ \hline Cash and cash equivalents & s \\ \hline Investments & \\ \hline Accounts receivable, net & \\ \hline Inwentaries net & \\ \hline Other current assets & \\ \hline Total current assets & \\ \hline Property, plant, and equipment, net & \\ \hline Goodwill & \\ \hline Other intang ble assets, net & \\ \hline Taxassets & \\ \hline Other assets & \\ \hline Total assets & 5 \\ \hline Current liabilites. & \\ \hline Current debt obligations & 3 \\ \hline Accounts payable & \\ \hline Accrued coropensation & \\ \hline Accrued income taxes & \\ \hline Other accrued expenses & \\ \hline Total current liabilities & \\ \hline Long-term debs & \\ \hline Accrued compensatoon and retiement benefits & \\ \hline Accrued income tares & \\ \hline Deferred tax liabilaties & \\ \hline Other Eabilities & \\ \hline Tocal liabilities & \\ \hline Sharcholders equity & \\ \hline \end{tabular} \begin{tabular}{l} Current debt obligations \\ \hline Accounts payable \\ \hline Accrued compensation \\ \hline Accrued income taxes \\ \hline Other accrued expenses \\ \hline Total current liabilities \\ \hline Long-term debt \\ \hline Accrued compensation and retirement benefits \\ \hline Accrued income taxes \\ \hline Deferred tax liabilities \\ \hline Other liabilities \\ \hline Total liabilities \\ \hline Shareholders equity \\ \hline Ordinary shares \\ \hline Additional paid-in capital \\ \hline Retained earnings \\ \hline Accumulated other comprehensive loss \\ \hline Total shareholders' equity \\ \hline Noncontrolling interests \\ \hline Total equity \\ \hline Total liabilities and equity \\ \hline \end{tabular}