Answered step by step
Verified Expert Solution
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,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 |
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 | 844 | 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% |
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started