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. Medtronic PLC Consolidated Balance Sheet $ millions April 26, 2019 Current assets \begin{tabular}{|l|r|} \hline \multicolumn{1}{|l|}{ Cash and cash equivalents } & $4,393 \\ \hline \multicolumn{1}{|c|}{ Investments } & 5,455 \\ \hline Accounts receivable, net & 6,222 \\ \hline Inventories, net & 3,753 \\ \hline \hline Other current assets & 2,144 \\ \hline Total current assets & 21,967 \\ \hline Property, plant, and equipment, net & 4,675 \\ \hline Goodwill & 39,959 \\ \hline Other intangible assets, net & 20,560 \\ \hline Tax assets & 1,519 \\ \hline Other assets & 1,014 \\ \hline Total assets & $89,694 \\ \hline Current liabilities & 121 \\ \hline \hline Current debt obligations & 50,212 \\ \hline Accounts payable & $89,694 \\ \hline Accrued compensation & 1838 \\ \hline Accrued income taxes & 1,953 \\ \hline Total liabilities and equity & 2,189 \\ \hline Other accrued expenses & 567 \\ \hline Total current liabilities & 2,925 \\ \hline Long-term debt & 8,472 \\ \hline Accrued compensation and retirement benefits & 24,486 \\ \hline Accrued income taxes & 1,651 \\ \hline Deferred tax liabilities & 2,838 \\ \hline Other liabilities & 1,278 \\ \hline Total liabilities & 757 \\ \hline Shareholders' equity & 39,482 \\ \hline Ordinary shares & 26,532 \\ \hline Additional paid-in capital & 26,270 \\ \hline Retained earnings & (2,711) \\ \hline Accumulated other comprehensive loss & 50,091 \\ \hline \hline \end{tabular} Ise the following assumptions to prepare a forecast of the company's balance sheet for fiscal year 2020. nswers into the provided spaces below with _two decimal places_. lote: Use negative signs with answers, when appropriate. Medtronic PLC Consolidated Balance Sheet $millions 2020 Current assets 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. Medtronic PLC Consolidated Balance Sheet $ millions April 26, 2019 Current assets \begin{tabular}{|l|r|} \hline \multicolumn{1}{|l|}{ Cash and cash equivalents } & $4,393 \\ \hline \multicolumn{1}{|c|}{ Investments } & 5,455 \\ \hline Accounts receivable, net & 6,222 \\ \hline Inventories, net & 3,753 \\ \hline \hline Other current assets & 2,144 \\ \hline Total current assets & 21,967 \\ \hline Property, plant, and equipment, net & 4,675 \\ \hline Goodwill & 39,959 \\ \hline Other intangible assets, net & 20,560 \\ \hline Tax assets & 1,519 \\ \hline Other assets & 1,014 \\ \hline Total assets & $89,694 \\ \hline Current liabilities & 121 \\ \hline \hline Current debt obligations & 50,212 \\ \hline Accounts payable & $89,694 \\ \hline Accrued compensation & 1838 \\ \hline Accrued income taxes & 1,953 \\ \hline Total liabilities and equity & 2,189 \\ \hline Other accrued expenses & 567 \\ \hline Total current liabilities & 2,925 \\ \hline Long-term debt & 8,472 \\ \hline Accrued compensation and retirement benefits & 24,486 \\ \hline Accrued income taxes & 1,651 \\ \hline Deferred tax liabilities & 2,838 \\ \hline Other liabilities & 1,278 \\ \hline Total liabilities & 757 \\ \hline Shareholders' equity & 39,482 \\ \hline Ordinary shares & 26,532 \\ \hline Additional paid-in capital & 26,270 \\ \hline Retained earnings & (2,711) \\ \hline Accumulated other comprehensive loss & 50,091 \\ \hline \hline \end{tabular} Ise the following assumptions to prepare a forecast of the company's balance sheet for fiscal year 2020. nswers into the provided spaces below with _two decimal places_. lote: Use negative signs with answers, when appropriate. Medtronic PLC Consolidated Balance Sheet $millions 2020 Current assets
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