Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Refine Assumptions for PPE Forecast Following are the income statement and balance sheet for Medtronic PLC. Medtronic PLC Consolidated Statement of Income For Fiscal Year

Refine Assumptions for PPE Forecast Following are the income statement and balance sheet for Medtronic PLC. Medtronic PLC Consolidated Statement of Income For Fiscal Year Ended Net sales Costs and expenses $ millions 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 April 26, 2019 $36,668 10,986 2,796 12,502 2,117 238 199 310 7,520 (448) 1,733 6,235 656 5,579 (23) $5,556
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
Refine Assumptions for PPE Forecast Following are the income statement and balance sheet for Medtronic PLC. \begin{tabular}{|l|r|} \hline \multicolumn{1}{|c|}{ \$ millions } & April 26, \\ \hline Current assets & 2019 \\ \hline Cash and cash equivalents & $5,272 \\ \hline Investments & 6,546 \\ \hline Accounts receivable, net & 7,466 \\ \hline Inventories, net & 4,504 \\ \hline Other current assets & 2,573 \\ \hline Total current assets & 26,361 \\ \hline Property, plant, and equipment, net & 5,610 \\ \hline Goodwill & 47,951 \\ \hline Other intangible assets, net & 24,672 \\ \hline Tax assets & 1,823 \\ \hline Other assets & 1,217 \\ \hline Total assets & $107,634 \\ \hline Current liabilities & \\ \hline Current debt obligations & $1,006 \\ \hline Accounts payable & 2,344 \\ \hline Accrued compensation & 2,627 \\ \hline Accrued income taxes & 680 \\ \hline Other accrued expenses & 3,510 \\ \hline Total current liabilities & 10,167 \\ \hline Long-term debt & 29,383 \\ \hline Accrued compensation and retirement benefits & 1,981 \\ \hline Accrued income taxes & 3,406 \\ \hline Deferred taxliablities & 1,534 \\ \hline Other liabilities & 908 \\ \hline Total liabilites & 47,379 \\ \hline Shareholders equity & \\ \hline \end{tabular} Note: Complete the entire question in Excel using the following template: Excel Template. Format each answer to two decimal places. Then enter the answers decimal places. a. Use the financial statements alongr with the additional information below to forecast property, plant and equipment, net for fiscal year ended April 2020. b. Suppose the company discloses in a press release that accompanies its year-end SEC filing that anticipated CAPEX for fiscal year ended April 2020 is as follor compary anticipated CApex for fiscal year ended April 202051,000 mition Use this guidance to refine your forecast of property, plant and equipment, net for fiscal year ended April 2020. Note: Complete the entire question in Excel using the following template: Excel Template. Format each answer to two decimal places. Then enter the answers int decimal places. a. Use the financial statements along with the additional information below to forecast property. plant and equipment, net for fiscal year ended April 2020 . b. Suppose the company discloses in a press release that accompanies its year-end SEC filing that anticipated CAPEX for fiscal year ended April 2020 is as follows. Compary anticipated CAPEX for fiscal year ended Apnil 2020$1,800 millica Use this guidance to refine your forecast of property, plant and equipment, net for fiscal year ended April 2020. Property, plant and equipment net Emilion

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

Auditing A Quality System For The Defense Industry

Authors: Charles B. Robinson

1st Edition

0873890787, 978-0873890786

More Books

Students also viewed these Accounting questions

Question

1. Give extra points for correct and creative answers.

Answered: 1 week ago

Question

Prepare an electronic rsum.

Answered: 1 week ago

Question

Strengthen your personal presence.

Answered: 1 week ago

Question

Identify the steps to follow in preparing an oral presentation.

Answered: 1 week ago