Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Standards And Audits For Ethics Management Systems The European Perspective

Authors: Josef Wieland

1st Edition

3642072925, 978-3642072925

More Books

Students also viewed these Accounting questions

Question

Find the derivative of y= cos cos (x + 2x)

Answered: 1 week ago

Question

What is the best conclusion for Xbar Chart? UCL A X B C B A LCL

Answered: 1 week ago

Question

Discuss the importance of workforce planning.

Answered: 1 week ago

Question

Differentiate between a mission statement and a vision statement.

Answered: 1 week ago