Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please answer the full statements. Forecast Income Statement and Balance Sheet Following are the income statement and balance sheet for Medtronic PLC. Note: Complete the

Please answer the full statements.

image text in transcribedimage text in transcribedimage 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. \begin{tabular}{|l|r|} \hline \multicolumn{1}{|c|}{ Inventories, net } & 3,753 \\ \hline \multicolumn{1}{|c|}{ Other current assets } & 900 \\ \hline \multicolumn{1}{|c|}{ Total current assets } & 20,723 \\ \hline Property, plant, and equipment, net & 4,675 \\ \hline Goodwill & 39,959 \\ \hline Other intangible assets, net & 20,560 \\ \hline Tax assets & 638 \\ \hline Other assets & 1,014 \\ \hline Total assets & $87,569 \\ \hline Current liabilities & \\ \hline \multicolumn{1}{|c|}{ Current debt obligations } & $838 \\ \hline \multicolumn{1}{|c|}{ Accounts payable } & 1,953 \\ \hline \multicolumn{1}{|c|}{ Accrued compensation } & 2,189 \\ \hline \multicolumn{1}{|c|}{ Accrued income taxes } & 567 \\ \hline \multicolumn{1}{|c|}{ Other accrued expenses } & 2,925 \\ \hline \multicolumn{1}{|c|}{ 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 Other liabilities & 318 \\ \hline Total liabilities & 39,043 \\ \hline Shareholders' equity & 26,846 \\ \hline Ordinary shares & 26,270 \\ \hline Additional paid-in capital & (2,711) \\ \hline Retained earnings & 48,405 \\ \hline Accumulated other comprehensive loss & 121 \\ \hline Total shareholders' equity & \\ \hline Noncontrolling interests & \\ \hline \hline \end{tabular} Income Statement Balance Sheet Use the following assumptions to prepare a forecast of the company's balance sheet for fiscal year 2020. Note: Complete the entire question in Excel (template provided above). Using Excel, format each answer to two decimal places. Use Increase Decimal or Decrease Decimal to adjust decimal places. Do not round answers. Then enter the answers into the provided spaces below with two decimal places_. Note: Use negative signs with answers, when appropriate. Current assets Cash and cash equivalents Investments Accounts receivable, net Inventories, net Other current assets Total current assets Property, plant, and equipment, net Goodwill Other intangible assets, net Tax assets Other assets Total assets Current liabilities Current debt obligations $ Accounts payable Accrued compensation Accrued income taxes Other accrued expenses Total current liabilities Long-term debt Accrued compensation and retirement benefits Accrued income taxes Deferred tax liabilities Other liabilities Total liabilities Shareholders' equity Ordinary shares Additional paid-in capital Retained earnings Accumulated other comprehensive loss Total shareholders' equity Noncontrolling interests Total equity Use the following assumptions to prepare a forecast of the company's income statement for fiscal year 2020. Note: Complete the entire question in Excel (template provided above). Using Excel, format each answer to two decimal places. Use Increase Decimal or Decrease Decimal to adjust decimal places. Do not round answers. Then enter the answers into the provided spaces below with _two decimal places_. Note: Use negative signs with answers, when appropriate

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

Wiley CIA Exam Review Test Bank Part 1 Essentials Of Internal Auditing

Authors: S. Rao Vallabhaneni

1st Edition

1119987237, 978-1119987239

More Books

Students also viewed these Accounting questions

Question

=+ (c) Show that if & is countable, then f(. ) is countable.

Answered: 1 week ago