Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Forecast Income Statement and Balance Sheet Following are the income statement and balance sheet for Medtronic PLC. Note: Complete the entire question using the following
Forecast Income Statement and Balance Sheet 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. \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 recelvable, net & 6,222 \\ \hline Inventories, net & 3,753 \\ \hline Other current assets & 858 \\ \hline Total current assets & 20,681 \\ \hline Property, plant, and equipment, net & 4,675 \\ \hline Goodwill & 39,959 \\ \hline Other intanglble assets, net & 20,560 \\ \hline Tax assets & 608 \\ \hline Other assets & 1,014 \\ \hline Total assets & $87,497 \\ \hline \multicolumn{2}{|l|}{ 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 llabilities & 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 llabilities & 303 \\ \hline Total liabilities & 39,028 \\ \hline \multicolumn{2}{|l|}{ Shareholders equity } \\ \hline Ordinary shares & 0 \\ \hline Additional paid-in capital & 24,789 \\ \hline Retained earnings & 26,270 \\ \hline Accumulated other comprehensive loss & (2,711) \\ \hline Total shareholders' equity & 48,348 \\ \hline Noncontrolling interests & 121 \\ \hline Total equity & 48,469 \\ \hline Total liabilities and equity & $87,497 \\ \hline \end{tabular} \begin{tabular}{|c|c|} \hline \begin{tabular}{c} Medtronic PLC \\ Consolidated Balance Sheet \\ \$ millilons \end{tabular} & 2020 \\ \hline Current assets & \\ \hline Cash and cash equivalents & $7,137.35x \\ \hline Investments & 5,455 \\ \hline Accounts recelvable, net & 6,732.32 \\ \hline Inventories, net & 4,059.19 \\ \hline Other current assets & 2,310.11 \\ \hline Total current assets & 25,693.97 \\ \hline Property, plant, and equipment, net & 4,949.72 \\ \hline Goodwill & 39,959 \\ \hline Other intangible assets, net & 18,646 \\ \hline Tax assets & 1,650.08 \\ \hline Other assets & 1,089.05 \\ \hline Total assets & $91,987.81x \\ \hline Current liabilities & \\ \hline Current debt obligations & 2,058 \\ \hline Accounts payable & 2,112.1 \\ \hline Accrued compensation & 627.03 \\ \hline Accrued income taxes & 3,168.15 \\ \hline Other accrued expenses & 3,168.15 \\ \hline Total current llabilities & 10,341.39 \\ \hline Long-term debt & 22,428 \\ \hline Accrued compensation and retirement benefits & 1,651 \\ \hline Accrued income taxes & 3,069.15 \\ \hline Deferred tax llabilities & 1,386.07 \\ \hline Other llabilities & 825.04 \\ \hline Total liabilities & 39,700.64 \\ \hline Shareholders equity & \\ \hline Ordinary shares & 0 \\ \hline Additional paid-In capital & 26,532 \\ \hline Retained earnings & 28,326.17 \\ \hline Accumulated other comprehensive loss & (2,711) \\ \hline Total shareholders' equity & 52,147.17 \\ \hline Noncontrolling interests & 140 \\ \hline Total equity & 52,287.17 \\ \hline Total llabilities and equity & $91,987.81x \\ \hline \end{tabular} Forecast Income Statement and Balance Sheet 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. \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 recelvable, net & 6,222 \\ \hline Inventories, net & 3,753 \\ \hline Other current assets & 858 \\ \hline Total current assets & 20,681 \\ \hline Property, plant, and equipment, net & 4,675 \\ \hline Goodwill & 39,959 \\ \hline Other intanglble assets, net & 20,560 \\ \hline Tax assets & 608 \\ \hline Other assets & 1,014 \\ \hline Total assets & $87,497 \\ \hline \multicolumn{2}{|l|}{ 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 llabilities & 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 llabilities & 303 \\ \hline Total liabilities & 39,028 \\ \hline \multicolumn{2}{|l|}{ Shareholders equity } \\ \hline Ordinary shares & 0 \\ \hline Additional paid-in capital & 24,789 \\ \hline Retained earnings & 26,270 \\ \hline Accumulated other comprehensive loss & (2,711) \\ \hline Total shareholders' equity & 48,348 \\ \hline Noncontrolling interests & 121 \\ \hline Total equity & 48,469 \\ \hline Total liabilities and equity & $87,497 \\ \hline \end{tabular} \begin{tabular}{|c|c|} \hline \begin{tabular}{c} Medtronic PLC \\ Consolidated Balance Sheet \\ \$ millilons \end{tabular} & 2020 \\ \hline Current assets & \\ \hline Cash and cash equivalents & $7,137.35x \\ \hline Investments & 5,455 \\ \hline Accounts recelvable, net & 6,732.32 \\ \hline Inventories, net & 4,059.19 \\ \hline Other current assets & 2,310.11 \\ \hline Total current assets & 25,693.97 \\ \hline Property, plant, and equipment, net & 4,949.72 \\ \hline Goodwill & 39,959 \\ \hline Other intangible assets, net & 18,646 \\ \hline Tax assets & 1,650.08 \\ \hline Other assets & 1,089.05 \\ \hline Total assets & $91,987.81x \\ \hline Current liabilities & \\ \hline Current debt obligations & 2,058 \\ \hline Accounts payable & 2,112.1 \\ \hline Accrued compensation & 627.03 \\ \hline Accrued income taxes & 3,168.15 \\ \hline Other accrued expenses & 3,168.15 \\ \hline Total current llabilities & 10,341.39 \\ \hline Long-term debt & 22,428 \\ \hline Accrued compensation and retirement benefits & 1,651 \\ \hline Accrued income taxes & 3,069.15 \\ \hline Deferred tax llabilities & 1,386.07 \\ \hline Other llabilities & 825.04 \\ \hline Total liabilities & 39,700.64 \\ \hline Shareholders equity & \\ \hline Ordinary shares & 0 \\ \hline Additional paid-In capital & 26,532 \\ \hline Retained earnings & 28,326.17 \\ \hline Accumulated other comprehensive loss & (2,711) \\ \hline Total shareholders' equity & 52,147.17 \\ \hline Noncontrolling interests & 140 \\ \hline Total equity & 52,287.17 \\ \hline Total llabilities and equity & $91,987.81x \\ \hline \end{tabular}
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started