Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Forecast the Statement of Cash Flows Medtronic PLC Consolidated Statement of Income $ millions, For Fiscal Year Ended April 2 6 , 2 0 1
Forecast the Statement of Cash Flows
Medtronic PLC Consolidated Statement of Income $ millions, For Fiscal Year Ended April
Net sales $
Costs and expenses
Cost of products sold
Research and development expense
Selling, general, and administrative expense
Amortization of intangible assets
Restructuring charges, net
Certain litigation charges, net
Other operating expense, net
Operating profit
Other nonoperating income, net
Interest expense
Income before income taxes
Income tax provision
Net income
Net income loss attributable to noncontrolling interests
Net income attributable to Medtronic $
Medtronic PLC Consolidated Balance Sheet $ millions April
Current assets
Cash and cash equivalents $
Investments
Accounts receivable, net
Inventories, net
Other current assets
Total current assets
Property, plant, and equipment, net
Goodwill
Other intangible assets, net
Tax assets
Other assets
Total assets $
Current liabilities
Current debt obligations $
Accounts payable
Accrued compensation
Accrued income taxes
Other accrued expenses
Total current liabilities
Longterm debt
Accrued compensation and retirement benefits
Accrued income taxes
Deferred tax liabilities
Other liabilities
Total liabilities
Shareholders equity
Ordinary shares
Additional paidin capital
Retained earnings
Accumulated other comprehensive loss
Total shareholders equity
Noncontrolling interests
Total equity
Total liabilities and equity $
Prepare a forecast of the FY statement of cash flows using the provided financial information and following assumptions. Use Increase Decimal or Decrease Decimal to adjust decimal places. Do not round answers. Then enter the answers into the provided spaces below with two decimal places
Note: Use negative signs with answers, when appropriate.
Income statement assumptions
Net sales increase growth Cost of products sold of net sales Research and development expense of net sales Selling, general, and administrative expense of net sales Amortization of intangible assets of net sales Restructuring charges, net of restructuring expense Certain litigation charges, net $ million Other operating expense, net No change in $ amount Other nonoperating income, net No change in $ amount Interest expense No change in $ amount Income tax provision of pretax income Income attributable to noncontrolling interests No change in $ amount
Balance sheet assumptions
Investments No change
Accounts receivable, less allowance of net sales
Inventories, net of net sales
Other current assets of net sales
Goodwill No change
Tax assets of net sales
Other assets of net sales
Accounts payable of net sales
Accrued compensation current liability of net sales
Accrued compensation and retirement benefits noncurrent liability No change
Accrued income taxes current liability of net sales
Other accrued expenses of net sales
Accrued income taxes noncurrent liability of net sales
Deferred tax liabilities of net sales
Other liabilities of net sales
Ordinary shares No change
Accumulated other comprehensive loss No change
Net income attributable to noncontrolling interest $ million
Dividends in FY $ million
CAPEX in FY $ $million, forecast CAPEX at historic of net sales Depreciation expense in FY $ million
Amortization expense in FY $ million
Debt due in FY $ million
Debt due in FY $ million
Medtronic PLC Forecasted Statement of Cash Flows For year ended $ millions
Net income before noncontrolling interest
Add: Depreciation
Add: Amortization
Change in Accounts receivable
Change in Inventories, net
Change in Other current assets
Change in Tax assets
Change in Accounts payable
Change in Accrued compensation
Change in Accrued income taxes
Change in Other accrued expenses
Change in Accrued income taxes
Change in Deferred tax liabilities
Change in Other liabilities
Net cash from operating activities
Capital expenditures
Net cash from investing activities
Dividends
Change in current debt obligations
Change in LT Debt
Net cash from financing activities
Net change in cash
Beginning cash
Ending cash
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