Answered step by step
Verified Expert Solution
Link Copied!

Question

...
1 Approved Answer

Forecast Income Statement and Balance SheetFollowing are the income statement and balance sheet for Medtronic PLC . Note: Complete the entire question using the following

Forecast Income Statement and Balance SheetFollowing are the income statement and balance sheet for Medtronic PLC.Note: Complete the entire question using the following Excel template: Excel Template . Then enter the answers into the provided spaces below with two decimal places.Medtronic PLCConsolidated Statement of Income$ millions, For Fiscal Year EndedApril 26,2019Net sales$30,557Costs and expensesCost of products sold9,155Research and development expense932Selling, general, and administrative expense10,418Amortization of intangible assets1,764Restructuring charges, net79Certain litigation charges, net166Other operating expense, net258Operating profit7,785Other nonoperating income, net(149)Interest expense1,444Income before income taxes6,490Income tax provision547Net income5,943Net income loss attributable to noncontrolling interests(19)Net income attributable to Medtronic$5,924Medtronic PLCConsolidated Balance Sheet$ millionsApril 26,2019Current assetsCash and cash equivalents$4,393Investments5,455Accounts receivable, net6,222Inventories, net3,753Other current assets858Total current assets20,681Property, plant, and equipment, net4,675Goodwill39,959Other intangible assets, net20,560Tax assets608Other assets1,014Total assets$87,497Current liabilitiesCurrent debt obligations$838Accounts payable1,953Accrued compensation2,189Accrued income taxes567Other accrued expenses2,925Total current liabilities8,472Long-term debt24,486Accrued compensation and retirement benefits1,651Accrued income taxes2,838Deferred tax liabilities1,278Other liabilities303Total liabilities39,028Shareholders equityOrdinary shares0Additional paid-in capital24,789Retained earnings26,270Accumulated other comprehensive loss(2,711)Total shareholders equity48,348Noncontrolling interests121Total equity48,469Total liabilities and equity$87,497Income StatementBalance SheetUse the following assumptions to prepare a forecast of the companys income statement for fiscal year 2020.Note: Complete the entire question in Excel (template provided above). Using Excel, format each answer to two decimal places. 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 assumptionsNet sales increase8%growthCost of products sold30.0%of net salesResearch and development expense7.6%of net salesSelling, general, and administrative expense34.1%of net salesAmortization of intangible assets5.8%of net salesRestructuring charges, net75%of 2019 restructuring expenseCertain litigation charges, net$150millionOther operating expense, netNo change in $ amountOther nonoperating income, netNo change in $ amountInterest expenseNo change in $ amountIncome tax provision15%of pretax incomeIncome attributable to noncontrolling interestsNo change in $ amount
\table[[Net sales,$33,001.56
image text in transcribed

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

Calculus

Authors: Ron Larson, Bruce H. Edwards

10th Edition

9781285057095

Students also viewed these Accounting questions