Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Someone please help with this question! Forecast the Statement of Cash Flows Refer to the Medtronic PLC financial statements below. Use the information to forecast

image text in transcribed

image text in transcribed

image text in transcribed

Someone please help with this question!

Forecast the Statement of Cash Flows Refer to the Medtronic PLC financial statements 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,531 $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,525 5,291 Interest expense, net 955 955 Income from operations before income taxes 6,570 4,336 Provision for income taxes 1,314 798 Net income $5,256 $3,538 844 Medtronic plc Consolidated Balance Sheets ($ millions) 2017 EST. Apr. 29, 2016 Current assets Cash and cash equivalents $5,663 $2,876 Investments 9,758 9,758 Accounts receivable 6,798 5,562 Inventories 4,230 3,473 Tax assets 697 Prepaid expenses and other current assets 1,513 1,234 Total current assets 28,806 23,600 Property, plant, and equipment, net 5,205 4,841 Goodwill 41,500 41,500 Other intangible assets, net 24,968 26,899 Long-term tax assets 1,697 1,383 Other assets 1,900 1,559 Total assets $104,076 $99,782 Current liabilities Short-term borrowing 6,176 993 Accounts payable 2,066 1,709 Accrued compensation 2,075 1,712 Accrued income taxes 695 566 Other accrued expenses 2,673 2,185 Total current liabilities 13,685 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,562 2,903 Long-term deferred tax liabilities 4,538 3,729 Other long-term liabilities 2,322 1,916 Total liabilities 49,937 47,719 Shareholders' equity Ordinary shares Retained earnings 56,007 53,931 Accumulated other comprehensive (loss) (1,868) (1,868) Total shareholders' equity 54,139 52,063 Total liabilities and stockholders' equity $104,076 $99,782 Additional information CAPEX/Net sales 3.6% Depreciation expense/Prior year PPE, net 18.9% Dividend payout ratio 60.5% Additional information CAPEX/Net sales 3.6% Depreciation expense/Prior year PPE, net 18.9% Dividend payout ratio 60.5% Round answers to the nearest whole number, if applicable. Use a negative signs with you answers to indicate a use of cash/decrease in cash. Medtronic plc Forecasted Statement of Cash Flows ($ millions) 2017 Est. Net income $ 1528 Depreciation 984 Amortization Accounts receivable Inventories Tax assets Prepaid expense & 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 Cash from operating activities Capital expenditures Cash from investing activities Dividends Current maturities of L-T debt L-T debt Cash from financing activities Change in cash Cash at start of year Cash at end of year $

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

Financial Accounting The Impact On Decision Makers

Authors: Gary A. Porter, Curtis L. Norton

6th Edition

0324655231, 978-0324655230

More Books

Students also viewed these Accounting questions

Question

1. What is the origin of the communication discipline?

Answered: 1 week ago

Question

2. What methods do communication scholars use to conduct research?

Answered: 1 week ago