Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Forecast the Statement of Cash Flows Refer to the Medtronic PLC financial statement below. Use the information to forecast Medtronic's FY2017 statement of cash flows.

Forecast the Statement of Cash Flows Refer to the Medtronic PLC financial statement below. Use the information to forecast Medtronic's FY2017 statement of cash flows.

Medtronic plc
Consolidated Statements of Income
12 Months Ended ($ millions) 2017 EST. Apr. 29, 2016
Net sales $35,642 $28,833
Costs and expenses
Cost of products sold 11,151 9,142
Research and development expense 2,709 2,224
Selling, general, and administrative expense 11,538 9,469
Special charges (gains), net - 70
Restructuring charges, net 218 290
Certain litigation charges, net - 26
Acquisition-related items 352 283
Amortization of intangible assets 1,931 1,931
Other expense, net 107 107
Operating profit 7,636 5,291
Interest expense, net 955 955
Income from operations before income taxes 6,681 4,336
Provision for income taxes 1,336 798
Net income $5,345 $3,538

Medtronic plc
Consolidated Balance Sheets
($ millions) 2017 EST. Apr. 29, 2016
Current assets
Cash and cash equivalents $5,686 $2,876
Investments 9,758 9,758
Accounts receivable 6,800 5,562
Inventories 4,232 3,473
Tax assets 844 697
Prepaid expenses and other current assets 1,513 1,234
Total current assets 28,833 23,600
Property, plant, and equipment, net 5,209 4,841
Goodwill 41,500 41,500
Other intangible assets, net 24,968 26,899
Long-term tax assets 1,699 1,383
Other assets 1,900 1,559
Total assets $104,109 $99,782
Current liabilities
Short-term borrowing 6,176 993
Accounts payable 2,064 1,709
Accrued compensation 2,075 1,712
Accrued income taxes 693 566
Other accrued expenses 2,673 2,185
Total current liabilities 13,681 7,165
Long-term debt 24,071 30,247
Long-term accrued compensation & retirement benefits 1,759 1,759
Long-term accrued income taxes 3,564 2,903
Long-term deferred tax liabilities 4,538 3,729
Other long-term liabilities 2,322 1,916
Total liabilities 49,935 47,719
Shareholders' equity
Ordinary shares - -
Retained earnings 56,042 53,931
Accumulated other comprehensive (loss) (1,868) (1,868)
Total shareholders' equity 54,174 52,063
Total liabilities and stockholders' equity $104,109 $99,782

Additional information

CAPEX/Net sales 3.6%
Depreciation expense/Prior year PPE, net 18.9%
Dividend payout ratio 60.5%

Use a negative sign with you answer to indicate a decrease in cash.

Medtronic plc
Forecasted Statement of Cash Flows ($ millions)
2016 Est.
Net income $Answer

Depreciation Answer

Amortization Answer

Accounts receivable Answer

Inventories Answer

Tax assets Answer

Prepaid expense & other current assets Answer

Long-term tax assets Answer

Other assets Answer

Accounts payable Answer

Accrued compensation Answer

Accrued income taxes Answer

Other accrued expenses Answer

Long-term accrued income taxes Answer

Long-term deferred tax liabilities Answer

Other long-term liabilities Answer

Cash from operating activites Answer

CAPEX Answer

Cash from investing activites Answer

Dividends Answer

Current maturities of L-T debt Answer

L-T debt Answer

Cash from financing activites Answer

Change in cash Answer

Cash at start of year Answer

Cash at end of year $Answer

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

More Books

Students also viewed these Accounting questions