Question: Forecast the Balance Sheet Following is the balance sheet for Medtronic PLC for the year ended April 29, 2016. Medtronic plc Consolidated Balance Sheets ($
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 |
| Deferred tax liabilities | | | | - | 119 |
| Other accrued expenses | | | | 2,185 | 2,464 |
| Total current liabilities | | | | 7,277 | 9,173 |
| Long-term debt | | | | 30,247 | 33,752 |
| Long-term accrued compensation | | | | 1,759 | 1,535 |
| Long-term accrued income taxes | | | | 2,903 | 2,476 |
| Long-term deferred tax liabilities | | | | 3,729 | 4,700 |
| Other long-term liabilities | | | | 1,916 | 1,819 |
| Total liabilities | | | | 47,831 | 53,455 |
| Shareholders’ equity | | | | | |
| Ordinary shares | | | | - | - |
| Retained earnings | | | | 53,931 | 54,414 |
| Accumulated other comprehensive (loss) | | | | (1,868) | (1,184) |
| Total shareholders’ equity | | | | 52,063 | 53,230 |
| Total liabilities and shareholders’ equity | | | | $99,894 | $106,685 |
Use the following assumptions to forecast the company’s balance sheet for FY2017.
| Forecasted FY2017 net income | | | | | | | $5,151 | million |
| Forecasted FY2017 net sales | | | | | | | $36,274 | million |
| Accounts receivable | | | | | | | 19.3% | of net sales |
| Inventories | | | | | | | 12.0% | of net sales |
| Tax assets | | | | | | | 2.4% | of net sales |
| Prepaid expenses and other current assets | | | | | | | 4.3% | of net sales |
| Long-term tax assets | | | | | | | 4.8% | of net sales |
| Other assets | | | | | | | 5.4% | of net sales |
| Accounts payable | | | | | | | 5.9% | of net sales |
| Accrued compensation | | | | | | | 5.9% | of net sales |
| Accrued income taxes | | | | | | | 2.0% | of net sales |
| Other accrued expenses | | | | | | | 7.6% | of net sales |
| Long-term accrued income taxes | | | | | | | 10.1% | of net sales |
| Long-term deferred tax liabilities | | | | | | | 12.9% | of net sales |
| Other long-term liabilities | | | | | | | 6.6% | of net sales |
| Investments | | | | | | | No change | |
| Goodwill | | | | | | | No change | |
| Long-term accrued compensation and retirement benefits | | | | | | | No change | |
| Ordinary shares | | | | | | | No change | |
| Accumulated other comprehensive (loss) | | | | | | | No change | |
| CAPEX | | | | | | | 3.6% | of net sales |
| Depreciation expense | | | | | | | 18.9% | of prior year PPE, net |
| Amortization expense in FY2016 | | | | | | | $1,931 | million |
| Current maturities of debt due in FY2017 | | | | | | | $1,105 | million |
| Current maturities of debt due in FY2018 | | | | | | | $6,176 | million |
| Dividend payout ratio | | | | | | | 60.5% | |
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 | | | | $Answer |
| Investments | | | | Answer |
| Accounts receivable | | | | Answer |
| Inventories | | | | Answer |
| Tax assets | | | | Answer |
| Prepaid expenses and other current assets | | | | Answer |
| Total current assets | | | | Answer |
| Property, plant, and equipment, net | | | | Answer |
| Goodwill | | | | Answer |
| Other intangible assets, net | | | | Answer |
| Long-term tax assets | | | | Answer |
| Other assets | | | | Answer |
| Total assets | | | | $Answer |
| Current liabilities | | | | |
| Short-term borrowings | | | | $Answer |
| Accounts payable | | | | Answer |
| Accrued compensation | | | | Answer |
| Accrued income taxes | | | | Answer |
| Other accrued expenses | | | | Answer |
| Total current liabilities | | | | Answer |
| Long-term debt | | | | Answer |
| Long-term accrued compensation | | | | Answer |
| Long-term accrued income taxes | | | | Answer |
| Long-term deferred tax liabilities | | | | Answer |
| Other long-term liabilities | | | | Answer |
| Total liabilities | | | | Answer |
| Shareholders’ equity | | | | |
| Ordinary shares | | | | - |
| Retained earnings | | | | Answer |
| Accumulated other comprehensive (loss) | | | | Answer |
| Total shareholders’ equity | | | | Answer |
| Total liabilities and shareholders’ equity | | | | $Answer |
Step by Step Solution
3.44 Rating (147 Votes )
There are 3 Steps involved in it
To forecast the balance sheet for Medtronic PLC for FY2017 well follow a stepbystep approach using the provided assumptions Step 1 Calculate Key Assets 1 Accounts Receivable textAccounts Receivable te... View full answer
Get step-by-step solutions from verified subject matter experts
