help with creating a balance sheet!!!
Forecast income Statement and Balance Sheet Followng 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 Balance Sheet $ millions April 26, 2019 \begin{tabular}{|l|r|} \hline Current assets \\ \hline Cash and cash equivalents \\ \hline Investments & $4,393 \\ \hline Accounts receivable, net & 5,455 \\ \hline Inventories, net & 6,222 \\ \hline Other current assets & 3,753 \\ \hline Total current assets & 900 \\ \hline Property, plant, and equipment, net & 20,723 \\ \hline Goodwill & 4,675 \\ \hline Other intangible assets, net & 39,959 \\ \hline Tax assets & 20,560 \\ \hline Other assets & 638 \\ \hline Total assets & 1,014 \\ \hline Current liabilities & $87,569 \\ \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 \end{tabular} \begin{tabular}{|l|r|} \hline Total liabilities & 39,043 \\ \hline Shareholders' equity & 0 \\ \hline Ordinary shares & 24,846 \\ \hline Additional paid-in capital & 26,270 \\ \hline Retained earnings & (2,711) \\ \hline Accumulated other comprehensive loss & 48,405 \\ \hline Total shareholders' equity & 121 \\ \hline Noncontrolling interests & 48,526 \\ \hline Total equity & $87,569 \\ \hline Total liabilities and equity & \end{tabular} \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.3% & 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) & a & 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 & X & 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 CAPEX in FY2019 & $1,134 & Smillion, forecast CAPEX at historic % of net sales \\ \hline Depreciation expense in Fy2020 & $950 & miltion \\ \hline Amortization expense in Fy2020 & $1.914 & million \\ \hline Debt due in FY2020 & $838 & million \\ \hline Debt due in FY2021 & $2,058 & million \\ \hline \end{tabular} Medtronic PLC Consolidated Balance Sheet $ millions 2020 \begin{tabular}{|c|c|c|} \hline Current assets & & \\ \hline Cash and cash equivalents & $ & 4,393 \\ \hline Investments & & 5,455 \\ \hline Accounts receivable, net & & 16,290.83 \\ \hline Inventories, net & & 3,758.51 \\ \hline Other current assets & & 916.71 \\ \hline Total current assets & & 20,723 \\ \hline Property, plant, and equipment, net & & 4,675 \\ \hline Goodwill & & 39,959 \\ \hline Other intangible assets, net & & 916.71 \\ \hline Tax assets & & 0 \\ \hline Other assets & & 0 \\ \hline Total assets & $ & 0 \\ \hline Current liabilities & & \\ \hline Current debt obligations & $ & 0 \\ \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 Oth & & 0x \\ \hline \end{tabular} \begin{tabular}{|c|c|} \hline Other liabilities & 0 \\ \hline Total liabilities & 0 \\ \hline \multicolumn{2}{|l|}{ Shareholders' equity } \\ \hline Ordinary shares & 0 \\ \hline Additional paid-in capital & 02 \\ \hline Retained earnings & 0x \\ \hline Accumulated other comprehensive loss & 0x \\ \hline Total shareholders' equity & 0x \\ \hline Noncontrolling interests & 0 \\ \hline Total equity & 0 \\ \hline Total liabilities and equity & 0 \\ \hline \end{tabular} Forecast income Statement and Balance Sheet Followng 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 Balance Sheet $ millions April 26, 2019 \begin{tabular}{|l|r|} \hline Current assets \\ \hline Cash and cash equivalents \\ \hline Investments & $4,393 \\ \hline Accounts receivable, net & 5,455 \\ \hline Inventories, net & 6,222 \\ \hline Other current assets & 3,753 \\ \hline Total current assets & 900 \\ \hline Property, plant, and equipment, net & 20,723 \\ \hline Goodwill & 4,675 \\ \hline Other intangible assets, net & 39,959 \\ \hline Tax assets & 20,560 \\ \hline Other assets & 638 \\ \hline Total assets & 1,014 \\ \hline Current liabilities & $87,569 \\ \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 \end{tabular} \begin{tabular}{|l|r|} \hline Total liabilities & 39,043 \\ \hline Shareholders' equity & 0 \\ \hline Ordinary shares & 24,846 \\ \hline Additional paid-in capital & 26,270 \\ \hline Retained earnings & (2,711) \\ \hline Accumulated other comprehensive loss & 48,405 \\ \hline Total shareholders' equity & 121 \\ \hline Noncontrolling interests & 48,526 \\ \hline Total equity & $87,569 \\ \hline Total liabilities and equity & \end{tabular} \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.3% & 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) & a & 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 & X & 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 CAPEX in FY2019 & $1,134 & Smillion, forecast CAPEX at historic % of net sales \\ \hline Depreciation expense in Fy2020 & $950 & miltion \\ \hline Amortization expense in Fy2020 & $1.914 & million \\ \hline Debt due in FY2020 & $838 & million \\ \hline Debt due in FY2021 & $2,058 & million \\ \hline \end{tabular} Medtronic PLC Consolidated Balance Sheet $ millions 2020 \begin{tabular}{|c|c|c|} \hline Current assets & & \\ \hline Cash and cash equivalents & $ & 4,393 \\ \hline Investments & & 5,455 \\ \hline Accounts receivable, net & & 16,290.83 \\ \hline Inventories, net & & 3,758.51 \\ \hline Other current assets & & 916.71 \\ \hline Total current assets & & 20,723 \\ \hline Property, plant, and equipment, net & & 4,675 \\ \hline Goodwill & & 39,959 \\ \hline Other intangible assets, net & & 916.71 \\ \hline Tax assets & & 0 \\ \hline Other assets & & 0 \\ \hline Total assets & $ & 0 \\ \hline Current liabilities & & \\ \hline Current debt obligations & $ & 0 \\ \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 Oth & & 0x \\ \hline \end{tabular} \begin{tabular}{|c|c|} \hline Other liabilities & 0 \\ \hline Total liabilities & 0 \\ \hline \multicolumn{2}{|l|}{ Shareholders' equity } \\ \hline Ordinary shares & 0 \\ \hline Additional paid-in capital & 02 \\ \hline Retained earnings & 0x \\ \hline Accumulated other comprehensive loss & 0x \\ \hline Total shareholders' equity & 0x \\ \hline Noncontrolling interests & 0 \\ \hline Total equity & 0 \\ \hline Total liabilities and equity & 0 \\ \hline \end{tabular}
