Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Forecast the Balance Sheet Following is the balance sheet for Medtronic PLC for the year ended April 29, 2016. Medtronic plc Consolidated Balance Sheets ($

image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
Forecast the Balance Sheet Following is the balance sheet for Medtronic PLC for the year ended April 29, 2016. Medtronic plc Consolidated Balance Sheets ($ millions) Apr. 29, 2016 Apr. 24, 2015 Current assets Cash and cash equivalents $2,988 $4,843 Investments 9,758 14,637 Accounts receivable 5,562 5,112 Inventories 3,473 3,463 Tax assets 697 1,335 Prepaid expenses and other current assets 1,234 1,454 Total current assets 23,712 30,844 Property, plant, and equipment, net 4,841 4,699 Goodwill 41,500 40,530 Other intangible assets, net 26,899 28, 101 Long-term tax assets 1,383 774 Other assets 1,559 1,737 Total assets $99,894 $106,685 Current liabilities Short-term borrowings $1,105 $2,434 Accounts payable 1,709 1,610 Accrued compensation 1,712 1,611 Accrued income taxes 566 935 Deferreditax liabilities Deferred tax liabilities Other accrued expenses Total current liabilities Long-term debt Long-term accrued compensation Long-term accrued income taxes Long-term deferred tax liabilities Other long-term liabilities Total liabilities Shareholders' equity Ordinary shares Retained earnings Accumulated other comprehensive (loss) Total shareholders' equity Total liabilities and shareholders' equity 2,185 7,277 30,247 1,759 2,903 3,729 1,916 47,831 119 2,464 9,173 33,752 1,535 2,476 4,700 1,819 53,455 53,931 (1,868) 52,063 $99,894 54,414 (1,184) 53,230 $106,685 Use the following assumptions to forecast the company's balance sheet for FY2017. Forecasted FY2017 net income Forecasted FY2017 net sales Accounts receivable Inventories Tax assets Prepaid expenses and other current assets Long-term tax assets Other assets Accounts payable Accrued compensation Accrued income taxes Other accrued expenses Long-term accrued income taxes Long-term deferred tax liabilities Other long-term liabilities Investments Goodwill Long-term accrued compensation and retirement benefits Ordinary shares Accumulated other comprehensive (loss) CAPEX Depreciation expense Amortization expense in FY2016 Current maturities of debt due in FY2017 $5,151 million $36,274 million 19.396 of net sales 12.0% of net sales 2.496 of net sales 4.396 of net sales 4.896 of net sales 5.496 of net sales 5.996 of net sales 5.996 of net sales 2.096 of net sales 7.6% of net sales 10.196 of net sales 12.996 of net sales 6.696 of net sales No change No change No change No change No change 3.696 of net sales 18.996 of prior year PPE, net $1,931 million $1,105 million Amortization expense in FY2016 Current maturities of debt due in FY2017 Current maturities of debt due in FY2018 Dividend payout ratio $1,931 $1,105 $6,176 60.596 million million million . Round your answers to the nearest whole number. . Do not use negative signs with any of your answers. Medtronic plc Forecasted Consolidated Balance Sheet ($ millions) EST. 2017 Current assets Cash and cash equivalents Investments Accounts receivable Inventories Tax assets Prepaid expenses and other curren Total current assets Property, plant, and equipment, net Goodwill Other intangible assets, net Long-term tax assets Other assets Total assets Current liabilities Short-term borrowings Accounts payable Accrued compensation Accrued income taxes Other aconued expenses X X X X X ooooooooooooo X X X X X X X X X ooooo X X X 0X 0 0 X X X X Accrued compensation Accrued income taxes Other accrued expenses Total current liabilities Long-term debt Long-term accrued compensation Long-term accrued income taxes Long-term deferred tax liabilities Other long-term liabilities Total liabilities Shareholders' equity Ordinary shares Retained earnings Accumulated other comprehensive (loss) Total shareholders' equity Total liabilities and shareholders' equity XXX

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Students also viewed these Accounting questions

Question

Draw a picture consisting parts of monocot leaf

Answered: 1 week ago