Forecast Income Statement and Balance Sheet Following are the income statement and balance sheet for Medtronic...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Forecast 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. Net sales Medtronic PLC Consolidated Statement of Income $ millions, For Fiscal Year Ended Costs and expenses April 26, 2019 $30,557 Cost of products sold 9,155 Research and development expense 2,330 Selling, general, and administrative expense 10,418 Amortization of intangible assets 1,764 Restructuring charges, net 198 Certain litigation charges, net 166 Other operating expense, net 258 Operating profit 6,268 Other nonoperating income, net (373) Interest expense 1,444 Income before income taxes 5,197 Income tax provision 547 Net income Net income loss attributable to noncontrolling interests Net income attributable to Medtronic 4,650 (19) $4,631 Medtronic PLC Consolidated Balance Sheet $ millions Current assets April 26, 2019 Cash and cash equivalents Investments Accounts receivable, net Inventories, net $4,393 5,455 6,222 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 Total liabilities 757 39,482 Shareholders' equity Ordinary shares 0 Additional paid-in capital 26,532 Retained earnings 26,270 Accumulated other comprehensive loss (2,711) Total shareholders' equity Noncontrolling interests Total equity Total liabilities and equity Income Statement Balance Sheet 50,091 121 50,212 $89,694 Use the following assumptions to prepare a forecast of the company's balance sheet for fis 2020. Note: Complete the entire question in Excel (template provided above). Using Excel, f each answer to two decimal places. Use Increase Decimal or Decrease Decimal to adj decimal places. Do not round answers. Then enter the answers into the provided spaces with _two decimal places_. Note: Use negative signs with answers, when appropriate. Investments Balance sheet assumptions Accounts receivable, less allowance Inventories, net Other current assets Goodwill Tax assets Other assets Accounts payable No change 20.4% of net sales 12.3% of net sales 7% of net sales No change 5% of net sales 3.3% of net sales 6.4% of net sales Accrued compensation (current liability) Accrued compensation and retirement benefits (noncurrent liability) 7.2% of net sales No change Accrued income taxes (current liability) Other accrued expenses Accrued income taxes (noncurrent liability) Deferred tax liabilities Other liabilities Ordinary shares Accumulated other comprehensive loss 1.9% of net sales 9.6% of net sales 9.3% of net sales 4.2% of net sales 2.5% of net sales No change No change Accumulated other comprehensive loss Net income attributable to noncontrolling interest Dividends in FY2020 CAPEX in FY2019 Depreciation expense in FY2020 Amortization expense in FY2020 Debt due in FY2020 Debt due in FY2021 No change $19 million $2,853 million $1,134 $million, forecast CAPEX at historic % of $950 million $1,914 million $838 million $2,058 million Medtronic PLC Consolidated Balance Sheet $ millions 2020 Current assets Cash and cash equivalents 0 x Investments 0 x Accounts receivable, net 0 x Inventories, net 0 x Other current assets 0 % Total current assets 0 x Property, plant, and equipment, net 0 x Goodwill 0 x Other intangible assets, net 0 x Tax assets 0 % Other assets 0 x Total assets $ 0 x Current liabilities Current debt obligations $ 0 % Accounts payable 0 x Accrued compensation 0 x Accrued income taxes 0 % Other accrued expenses 0 % Total current liabilities 0 x Long-term debt 0 x Accrued compensation and retirement benefits 0 x Accrued income taxes 0 % Deferred tax liabilities 0 x Other intangible assets, net Tax assets Other assets Total assets 0 x 0 % 0 x $ 0 % Current liabilities Current debt obligations $ 0 % Accounts payable Accrued compensation Accrued income taxes 0 x 0 x 0 x Other accrued expenses 0 % Total current liabilities 0 x Long-term debt 0 x Accrued compensation and retirement benefits 0 x Accrued income taxes 0 % Deferred tax liabilities 0 % Other liabilities Total liabilities 0 x 0 x Shareholders' equity Ordinary shares 0 Additional paid-in capital Retained earnings 0 % 0 x Accumulated other comprehensive loss 0 % Total shareholders' equity 0 x Noncontrolling interests 0 % Total equity 0 x Total liabilities and equity $ 0 % Use the following assumptions to prepare a forecast of the company's 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 Certain litigation charges, net 75% of 2019 restructuring expense $150 million No change in $ amount Other operating expense, net Other nonoperating income, net Interest expense Income tax provision Income attributable to noncontrolling interests No change in $ amount No change in $ amount 15% of pretax income No change in $ amount Medtronic PLC Consolidated Statement of Income $ millions For Fiscal Year Ended Net sales 2020 33,002 Costs and expenses Cost of products sold 10,165 x Research and development expense 2,508 Selling, general, and administrative expense 11,254 Amortization of intangible assets 1,914 Restructuring charges, net 149 Certain litigation charges, net 150 Selling, general, and administrative expense 11,254 Amortization of intangible assets 1,914 Restructuring charges, net 149 Certain litigation charges, net 150 Other operating expense, net 258 Operating profit 6,604 x Other nonoperating income, net Interest expense Income before income taxes Income tax provision 374 x 1,444 5,534 x 830 x 4,704 x Net income Net income loss attributable to noncontrolling interests Net income attributable to Medtronic 119 x $ 4,585 x Forecast 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. Net sales Medtronic PLC Consolidated Statement of Income $ millions, For Fiscal Year Ended Costs and expenses April 26, 2019 $30,557 Cost of products sold 9,155 Research and development expense 2,330 Selling, general, and administrative expense 10,418 Amortization of intangible assets 1,764 Restructuring charges, net 198 Certain litigation charges, net 166 Other operating expense, net 258 Operating profit 6,268 Other nonoperating income, net (373) Interest expense 1,444 Income before income taxes 5,197 Income tax provision 547 Net income Net income loss attributable to noncontrolling interests Net income attributable to Medtronic 4,650 (19) $4,631 Medtronic PLC Consolidated Balance Sheet $ millions Current assets April 26, 2019 Cash and cash equivalents Investments Accounts receivable, net Inventories, net $4,393 5,455 6,222 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 Total liabilities 757 39,482 Shareholders' equity Ordinary shares 0 Additional paid-in capital 26,532 Retained earnings 26,270 Accumulated other comprehensive loss (2,711) Total shareholders' equity Noncontrolling interests Total equity Total liabilities and equity Income Statement Balance Sheet 50,091 121 50,212 $89,694 Use the following assumptions to prepare a forecast of the company's balance sheet for fis 2020. Note: Complete the entire question in Excel (template provided above). Using Excel, f each answer to two decimal places. Use Increase Decimal or Decrease Decimal to adj decimal places. Do not round answers. Then enter the answers into the provided spaces with _two decimal places_. Note: Use negative signs with answers, when appropriate. Investments Balance sheet assumptions Accounts receivable, less allowance Inventories, net Other current assets Goodwill Tax assets Other assets Accounts payable No change 20.4% of net sales 12.3% of net sales 7% of net sales No change 5% of net sales 3.3% of net sales 6.4% of net sales Accrued compensation (current liability) Accrued compensation and retirement benefits (noncurrent liability) 7.2% of net sales No change Accrued income taxes (current liability) Other accrued expenses Accrued income taxes (noncurrent liability) Deferred tax liabilities Other liabilities Ordinary shares Accumulated other comprehensive loss 1.9% of net sales 9.6% of net sales 9.3% of net sales 4.2% of net sales 2.5% of net sales No change No change Accumulated other comprehensive loss Net income attributable to noncontrolling interest Dividends in FY2020 CAPEX in FY2019 Depreciation expense in FY2020 Amortization expense in FY2020 Debt due in FY2020 Debt due in FY2021 No change $19 million $2,853 million $1,134 $million, forecast CAPEX at historic % of $950 million $1,914 million $838 million $2,058 million Medtronic PLC Consolidated Balance Sheet $ millions 2020 Current assets Cash and cash equivalents 0 x Investments 0 x Accounts receivable, net 0 x Inventories, net 0 x Other current assets 0 % Total current assets 0 x Property, plant, and equipment, net 0 x Goodwill 0 x Other intangible assets, net 0 x Tax assets 0 % Other assets 0 x Total assets $ 0 x Current liabilities Current debt obligations $ 0 % Accounts payable 0 x Accrued compensation 0 x Accrued income taxes 0 % Other accrued expenses 0 % Total current liabilities 0 x Long-term debt 0 x Accrued compensation and retirement benefits 0 x Accrued income taxes 0 % Deferred tax liabilities 0 x Other intangible assets, net Tax assets Other assets Total assets 0 x 0 % 0 x $ 0 % Current liabilities Current debt obligations $ 0 % Accounts payable Accrued compensation Accrued income taxes 0 x 0 x 0 x Other accrued expenses 0 % Total current liabilities 0 x Long-term debt 0 x Accrued compensation and retirement benefits 0 x Accrued income taxes 0 % Deferred tax liabilities 0 % Other liabilities Total liabilities 0 x 0 x Shareholders' equity Ordinary shares 0 Additional paid-in capital Retained earnings 0 % 0 x Accumulated other comprehensive loss 0 % Total shareholders' equity 0 x Noncontrolling interests 0 % Total equity 0 x Total liabilities and equity $ 0 % Use the following assumptions to prepare a forecast of the company's 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 Certain litigation charges, net 75% of 2019 restructuring expense $150 million No change in $ amount Other operating expense, net Other nonoperating income, net Interest expense Income tax provision Income attributable to noncontrolling interests No change in $ amount No change in $ amount 15% of pretax income No change in $ amount Medtronic PLC Consolidated Statement of Income $ millions For Fiscal Year Ended Net sales 2020 33,002 Costs and expenses Cost of products sold 10,165 x Research and development expense 2,508 Selling, general, and administrative expense 11,254 Amortization of intangible assets 1,914 Restructuring charges, net 149 Certain litigation charges, net 150 Selling, general, and administrative expense 11,254 Amortization of intangible assets 1,914 Restructuring charges, net 149 Certain litigation charges, net 150 Other operating expense, net 258 Operating profit 6,604 x Other nonoperating income, net Interest expense Income before income taxes Income tax provision 374 x 1,444 5,534 x 830 x 4,704 x Net income Net income loss attributable to noncontrolling interests Net income attributable to Medtronic 119 x $ 4,585 x
Expert Answer:
Related Book For
Posted Date:
Students also viewed these finance questions
-
Which type of mutual fund is most likely to have the lowest investment management fees? a. A bond fund. b. An equity growth fund. c. A small cap fund. d. An index fund.
-
Assume that a bond sells at 9 8 3 / 4 ( paid 1 4 % interest ) . Mary buys four bonds. What is the total interest Mary would receive at the end of each year? Total interest:
-
The drawing shows a jet engine suspended beneath the wing of an airplane. The weight W of the engine is 10 200 N and acts as shown in the drawing. In flight the engine produces a thrust T of 62 300 N...
-
Are there any other methods besides self-report inventories that would provide for an assessment of personality traits that might improve the validity in the assessment of these traits?
-
Robert Thumme owns a $140,000 townhouse and still has an unpaid mortgage of $110,000. In addition to his mortgage, he has the following liabilities: Visa....................................$565...
-
The coefficient measures the specific risk of a security. True or false?
-
Ledfords is a chain of home improvement stores. Suppose Ledfords is trying to de-cide whether to produce its own line of Formica countertops, cabinets, and picnic tables. Assume Ledford would incur...
-
On April 1, 2019, Ayayal issued $2,600,000, 9% bonds for $2,796,903 including accrued interest. Interest is payable annually on January 1, and the bonds mature on January 1, 2029. (Credit account...
-
Identify the number or shipments that will take place over the course or the year to import the pre- established annual requirement from Romania to canada of children rubber mats Note: the size of...
-
Ex. 02: Workbook 10-8 Able Energy, Inc. is a company listed on NASDAQ (symbol: ABLE). A trader sold 100 shares of this company on May 10, 2004 at 15:52:59 at a price of $2.66 per share. All the...
-
Why do accountants differentiate between the differences between the flow of goods in a warehouse, and the cost flow of goods in a warehouse?
-
11. Given the following equivalency 2.5 centimeters = 1.00 inches. a) Identify the two conversion factors. b) How many centimeters are there in 5.0 inches? c) How many inches are there in 21.0...
-
What are the direct and indirect cost in Disneyland ?? Also, mention what are the relevant, irrelevant, variable, fixed, and other sunk costs of Disneyland Parks and Resorts
-
The following data were taken from the financial statements of Gates Inc. for the current fiscal year. Property, plant, and equipment (net) Liabilities: Current liabilities Note payable, 6%, due in...
-
This assignment is worth a total of 50 points. Content: point values vary but are indicated in the template and total 40 points. Format: point values vary but are indicated in the template for 8 pts....
-
Danielle has an insurance policy with a premium of $75 per month. In September she is in an accident and receives a bill worth $2990 for the repair of her own property. Her deductible is $250 and her...
-
Your manager wants you to write a report detailing the internal and external benchmarks available and explaining why he should be using them in reviewing performance.
-
Identify the key priorities for a small events company which specialises in wedding planning and arrangement for each of the four dimensions of the Balanced Scorecard, identify suitable measures for...
-
Define strategic management accounting.
Study smarter with the SolutionInn App