Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

orecast Income Statement and Balance Sheet Following are the income statement and balance sheet for Medtronic PLC . Note: Complete the entire question using the

orecast Income Statement and Balance Sheet
Following 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 PLC
Consolidated Statement of Income
$ millions, For Fiscal Year Ended April 26,2019
Net sales $30,557
Costs and expenses
Cost of products sold 9,155
Research and development expense 839
Selling, general, and administrative expense 10,418
Amortization of intangible assets 1,764
Restructuring charges, net 71
Certain litigation charges, net 166
Other operating expense, net 258
Operating profit 7,886
Other nonoperating income, net (134)
Interest expense 1,444
Income before income taxes 6,576
Income tax provision 547
Net income 6,029
Net (income) loss attributable to noncontrolling interests (19)
Net income attributable to Medtronic $6,010
Medtronic PLC
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 772
Total current assets 20,595
Property, plant, and equipment, net 4,675
Goodwill 39,959
Other intangible assets, net 20,560
Tax assets 547
Other assets 1,014
Total assets $87,350
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 273
Total liabilities 38,998
Shareholders equity
Ordinary shares 0
Additional paid-in capital 24,672
Retained earnings 26,270
Accumulated other comprehensive loss (2,711)
Total shareholders equity 48,231
Noncontrolling interests 121
Total equity 48,352
Total liabilities and equity $87,350
Income Statement
Balance Sheet
Use 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 assumptions
Net sales increase 8% growth
Cost of products sold 30.0% of net sales
Research and development expense 7.6% of net sales
Selling, general, and administrative expense 34.1% of net sales
Amortization of intangible assets 5.8% of net sales
Restructuring charges, net 75% of 2019 restructuring expense
Certain litigation charges, net $150 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 15% of pretax income
Income attributable to noncontrolling interests No change in $ amount
Medtronic PLC
Consolidated Statement of Income
$ millions
For Fiscal Year Ended 2020
Net sales
Answer
Costs and expenses
Cost of products sold
Answer
Research and development expense
Answer
Selling, general, and administrative expense
Answer
Amortization of intangible assets
Answer
Restructuring charges, net
Answer
Certain litigation charges, net
Answer
Other operating expense, net
Answer
Operating profit
Answer
Other nonoperating income, net
Answer
Interest expense
Answer
Income before income taxes
Answer
Income tax provision
Answer
Net income
Answer
Net (income) loss attributable to noncontrolling interests
Answer
Net income attributable to Medtronic
Answer

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored 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

Accounting Principles

Authors: Jerry Weygandt, Paul Kimmel, Donald Kieso

12th edition

1119132223, 978-1-119-0944, 1118875052, 978-1119132226, 978-1118875056

Students also viewed these Accounting questions

Question

consider the following grammer

Answered: 1 week ago