Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Statement of Cash Flows (Indirect Method) Following are the income statement and balance sheet for Seagate Technology for the year ended June 28, 2019, and

Statement of Cash Flows (Indirect Method) Following are the income statement and balance sheet for Seagate Technology for the year ended June 28, 2019, and a forecasted income statement and balance sheet for 2020.

image text in transcribedimage text in transcribedimage text in transcribed

The following additional information pertains to the balance sheet and income statement for the year ended June 30, 2020 ($ millions).

image text in transcribed

Required Prepare a forecasted statement of cash flows for June 2020 using the indirect method. (Hint: Stockbased compensation is a noncash expense like depreciation and must be added back in the operating section. The amount expensed is also added to the companys Additional paid-in capital account in the balance sheet.)

image text in transcribed \begin{tabular}{|l|r|r|} \hline \multicolumn{3}{|c|}{ Consolidated Statements of Income } \\ \hline \multicolumn{1}{|c|}{ For Years Ended (\$ millions) } & \multicolumn{1}{c|}{ Actual } & \multicolumn{1}{c|}{ Est. } \\ \hline Revenue & $51,950 & $54,550 \\ \hline Cost of revenue & 37,290 & 39,165 \\ \hline Product development & 4955 & 5,180 \\ \hline Marketing and administrative & 2265 & 2400 \\ \hline Amortization of intangibles & 115 & 115 \\ \hline Restructuring and other, net & (110) & 0 \\ \hline Total operating expense & 44,515 & 46,860 \\ \hline Income from operations & 7,435 & 7,690 \\ \hline Interest income & 420 & 420 \\ \hline Interest expense & (1,120) & (1,120) \\ \hline Other, net & 125 & 125 \\ \hline Other expense, net & (575) & (575) \\ \hline Income before income taxes & 6,860 & 7,115 \\ \hline (Benefit) provision for income taxes & (3,200) & 1495 \\ \hline Net income & $10,060 & $5,620 \\ \hline \hline \end{tabular} \begin{tabular}{|c|c|c|} \hline \multirow[b]{2}{*}{ For Years Ended (\$ millions) } & \begin{tabular}{l} June \\ 2019 \end{tabular} & \begin{tabular}{l} June \\ 2020 \end{tabular} \\ \hline & Actual & Est. \\ \hline \multicolumn{3}{|l|}{ Current assets } \\ \hline Cash and cash equivalents & $11,100 & $12,915 \\ \hline Accounts receivable, net & 4945 & 5,180 \\ \hline Inventories & 4850 & 5,075 \\ \hline Other current assets & 920 & 980 \\ \hline Total current assets & 21,815 & 24,150 \\ \hline Property, equipment and leasehold improvements, net & 9,345 & 9,855 \\ \hline Goodwill & 6,185 & 6,185 \\ \hline Other intangible assets, net & 555 & 440 \\ \hline Deferred income taxes & 5,570 & 5,835 \\ \hline Other assets, net & 955 & 980 \\ \hline Total Assets & $44,425 & $47,445 \\ \hline \multicolumn{3}{|l|}{ Current liabilities } \\ \hline Accounts payable & $7,100 & $7,475 \\ \hline Accrued employee compensation & 845 & 875 \\ \hline Accrued warranty & 455 & 490 \\ \hline Accrued expenses & 2760 & 2890 \\ \hline Total current liabilities & 11,160 & 11,730 \\ \hline Long-term accrued warranty & 520 & 545 \\ \hline Long-term accrued income taxes & 20 & 20 \\ \hline Other noncurrent liabilities & 650 & 710 \\ \hline Long-term debt, less current portion & 21,265 & 21,265 \\ \hline Total liabilities & 33,615 & 34,270 \\ \hline \multicolumn{3}{|l|}{ Shareholders' equity } \\ \hline \multicolumn{3}{|l|}{ Ordinary shares-par value $0.0001, } \\ \hline 2.6 billion shares authorized & - & - \\ \hline Additional paid-in capital & 32,725 & 33,220 \\ \hline \end{tabular} \begin{tabular}{|l|r|r|} \hline Accumulated other comprehensive loss & (170) & (170) \\ \hline Accumulated deficit & (21,745) & (19,875) \\ \hline Total shareholders' equity & 10,810 & 13,175 \\ \hline Total liabilities and shareholders' equity & $44,425 & $47,445 \\ \hline \end{tabular} \begin{tabular}{|l|r|} \hline Depreciation expense (included in operating expenses) & $2,655 \\ \hline Stock-based compensation & 495 \\ \hline Amortization expense & 115 \\ \hline Capital expenditures & 3165 \\ \hline Dividends & 3750 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|} \hline \begin{tabular}{r} SEAGATE TECHNOLOGY PLC \\ Statement of Cash Flows (\$ Milli \\ Forecasted for Year Ended June 30 \end{tabular} & & \\ \hline Net income & $ & 0 \\ \hline Add: Depreciation & & 0 \\ \hline Add: Amortization & & 0 \\ \hline^ & & 0 \\ \hline Accounts receivable, net increase & & 0 \\ \hline Inventories increase & & 0 \\ \hline Other current assets increase & & 0 \\ \hline Deferred income taxes increase & & 0 \\ \hline Other assets, net increase & & 0 \\ \hline Accounts payable increase & & 0 \\ \hline Accrued employee compensation increase & & 0 \\ \hline Accrued warranty increase & & 0 \\ \hline Accrued expenses increase & & 0 \\ \hline Long-term accrued warranty increase & & 0 \\ \hline Other non-current liabilities increase & & 0 \\ \hline & & 0 \\ \hline & & 0 \\ \hline^ & & 0 \\ \hline^ & & 0 \\ \hline^ & & 0 \\ \hline Net change in cash & & 0 \\ \hline Beginning cash & & 0 \\ \hline Ending cash & $ & 0 \\ \hline \end{tabular}

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_2

Step: 3

blur-text-image_3

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

Accountability Of Local Authorities In England And Wales, 1831-1935 Volume 1

Authors: Hugh Coombs, J. R. Edwards

1st Edition

1138965758, 9781138965751

More Books

Students also viewed these Accounting questions

Question

Where in the hiring process are you?

Answered: 1 week ago