Question: I need your help please! Forecast Income Statement and Balance Sheet Following are the income statement and balance sheet for Medtronic PLC. Note: Complete the

I need your help please!
I need your help please! Forecast Income Statement and Balance Sheet Following
are the income statement and balance sheet for Medtronic PLC. Note: Complete
the entire question ipsing the following Excel template: Excel Template. Then enter
the answers into the pronded spaces below with two decimil places Medtronic
PLC Consolidated Balance Sheet $ millions April 26, 2019 Current assets Use
the foliowing assumptions to prepare a forecast of the company's income statement
for fiscal year 2020. Note: Complete the entire question in Excel (template

Forecast Income Statement and Balance Sheet Following are the income statement and balance sheet for Medtronic PLC. Note: Complete the entire question ipsing the following Excel template: Excel Template. Then enter the answers into the pronded spaces below with two decimil places Medtronic PLC Consolidated Balance Sheet $ millions April 26, 2019 Current assets Use the foliowing 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 Decimaf or 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. 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 Decimalor 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. 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 oecimal or oecrease Decimal to adjust decimal places. Do not round answers. Then enter the answers into the provided spaces below with two decmal places. Note: Use negative signs with answers, when appropriate. Medtronic PLC Consolidated Balance Sheet $ millions 2020 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 Ordinanushares 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 Total liabilities and equity $ Forecast Income Statement and Balance Sheet Following are the income statement and balance sheet for Medtronic PLC. Note: Complete the entire question ipsing the following Excel template: Excel Template. Then enter the answers into the pronded spaces below with two decimil places Medtronic PLC Consolidated Balance Sheet $ millions April 26, 2019 Current assets Use the foliowing 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 Decimaf or 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. 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 Decimalor 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. 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 oecimal or oecrease Decimal to adjust decimal places. Do not round answers. Then enter the answers into the provided spaces below with two decmal places. Note: Use negative signs with answers, when appropriate. Medtronic PLC Consolidated Balance Sheet $ millions 2020 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 Ordinanushares 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 Total liabilities and equity $

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!