Answered step by step
Verified Expert Solution
Link Copied!

Question

...
1 Approved Answer

How to calculate the cash and equivalent? Forecast the Balance Sheet Following is the balance sheet for Medtronic PLC for FY2019 ended April 26, 2019.

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

How to calculate the cash and equivalent?

Forecast the Balance Sheet Following is the balance sheet for Medtronic PLC for FY2019 ended April 26, 2019. Consolidated Balance Sheet ($ millions) April 26, 2019 Current assets Cash and cash equivalents $ 4,393 Investments 5,455 Accounts receivable, net 6,222 Inventories, net 3,753 Other current assets 2,144 Total current assets 21,967 Property, plant, and equipment, net 4,675 Goodwill 39,959 Other intangible assets, net 20,560 Tax assets 1,519 Other assets 1,014 Total assets $89,694 Current liabilities Current debt obligations $ 838 Accounts payable 1,953 Accrued compensation 2,189 Accrued income taxes 567 Other accrued expenses 2,925 Total current liabilities 8,472 Long-term debt 24,486 Accrued compensation and retirement benefits 1,651 Accrued income taxes 2,838 Deferred tax liabilities 1,278 Other liabilities 757 Total liabilities 39,482 39,482 0 26,532 26,270 Total liabilities Shareholders' equity Ordinary shares Additional paid-in capital Retained earnings Accumulated other comprehensive loss Total shareholders' equity Noncontrolling interests Total equity Total liabilities and equity (2,711) 50,091 121 50,212 $89,694 Use the following assumptions to forecast the company's balance sheet for FY2020. Forecasted FY2020 net income $4,927 million Forecasted FY2020 net sales $33,002 million Accounts receivable, less allowance 20.4% of net sales Inventories, net 12.3% of net sales Other current assets 7% of net sales Goodwill No change Tax assets 5% of net sales Other assets 3.3% of net sales Accounts payable 6.4% of net sales Accrued compensation (current liability) 7.2% of net sales Accrued compensation and retirement benefits (noncurrent liability) No change Accrued income taxes (current liability) 1.9% of net sales Other accrued expenses 9.6% of net sales Accrued income taxes (noncurrent liability) 9.3% of net sales Deferred tax liabilities 4.2% of net sales Other liabilities Ordinary shares Accumulated other comprehensive loss Net income attributable to noncontrolling interest Dividends in FY2020 2.5% of net sales No change No change $19 million $2,853 million $1,134 million $950 million CAPEX in FY2019 (to be forecast as % of net sales) Depreciation expense in FY2020 Amortization expense in FY2020 Debt due in FY2020 $1,914 million $838 million Debt due in FY2021 $2,058 million MEDTRONIC PLC Forecasted Balance Sheet Current assets April 2020 Cash and cash equivalents $ 0 x Investments 5,455 6,732 4,059 2,310 Accounts receivable, net Inventories, net Other current assets Total current assets Property, plant, and equipment, net Goodwill Other intangible assets, net 0 X OX 39,959 18,646 Tax assets 1,650 1,089 Other assets Total assets 91,986 Current liabilities Current debt obligations Accounts payable $ 2,058 2,112 Current liabilities $ Current debt obligations Accounts payable Accrued compensation Accrued income taxes 2,058 2,112 ~ 2,376 627 Other accrued expenses Total current liabilities 3,168 10,341 22,428 Long-term debt Accrued compensation and retirement benefits Accrued income taxes 1,651 3,069 1,386 Deferred tax liabilities Other liabilities 825 Total liabilities 39,700 0 Shareholders' equity Ordinary shares Additional paid-in capital Retained earnings Accumulated other comprehensive loss Total shareholders' equity Noncontrolling interests Total equity Total liabilities and equity 26,532 28,325 (2,711) 52,146 140 52,286 91,986 $

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Microeconomics An Intuitive Approach with Calculus

Authors: Thomas Nechyba

1st edition

978-0538453257

Students also viewed these Accounting questions