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,176 $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,170 5,291
Interest expense, net 955 955
Income from operations before income taxes 6,215 4,336
Provision for income taxes 1,243 798
Net income $4,972 $3,538

Medtronic plc
Consolidated Balance Sheets
($ millions) 2017 EST. Apr. 29, 2016
Current assets
Cash and cash equivalents $5,600 $2,876
Investments 9,758 9,758
Accounts receivable 6,789 5,562
Inventories 4,221 3,473
Tax assets 844 697
Prepaid expenses and other current assets 1,513 1,234
Total current assets 28,725 23,600
Property, plant, and equipment, net 5,192 4,841
Goodwill 41,500 41,500
Other intangible assets, net 24,968 26,899
Long-term tax assets 1,688 1,383
Other assets 1,900 1,559
Total assets $103,973 $99,782
Current liabilities
Short-term borrowing 6,176 993
Accounts payable 2,075 1,709
Accrued compensation 2,075 1,712
Accrued income taxes 704 566
Other accrued expenses 2,673 2,185
Total current liabilities 13,703 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,553 2,903
Long-term deferred tax liabilities 4,538 3,729
Other long-term liabilities 2,322 1,916
Total liabilities 49,946 47,719
Shareholders' equity
Ordinary shares - -
Retained earnings 55,895 53,931
Accumulated other comprehensive (loss) (1,868) (1,868)
Total shareholders' equity 54,027 52,063
Total liabilities and stockholders' equity $103,973 $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

Fraud Risk Assessment Building A Fraud Audit Program

Authors: Leonard W. Vona

1st Edition

047012945X, 978-0470129456

More Books

Students also viewed these Accounting questions

Question

Identify the elements that make up the employee reward package.

Answered: 1 week ago

Question

Understand the purpose, value and drawbacks of the interview.

Answered: 1 week ago