Following are the income statement and balance sheet of Seagate Technology for fiscal 2019. Note: Complete the entire question using the following Excel template: Excel Template. Then enter th SEGATE TECHNOLOGY PLC Consolidated Statement of Income For Year Ended June 28, 2019, $ millions Revenue Cost of revenue Product development Marketing and administrative Amortization of intangibles Restructuring and other, net Total operating expenses Income from operations Interest income Interest expense Other, net Other expense, net Income before income taxes (Benefit) provision for income taxes Net income $7,481 5,370 714 326 17 (16) 6,411 1,070 60 (161) 18 (83) 987 (461) $1,448

Following are the income statement and balance sheet of Seagate Technology for fiscal 2019. Note: Complete the entire question using the following Excel template: Excel Template. Then enter SEAGATE TECHNOLOGY PLC Consolidated Balance Sheet Consolidated Balance Sheet \begin{tabular}{|l|r|} \hline Accrued warranty & 66 \\ \hline Accrued expenses & 397 \\ \hline Total current liabilities & 1,607 \\ \hline Long-term accrued warranty & 75 \\ \hline Long-term accrued income taxes. & 3 \\ \hline Other noncurrent liabilities & 94 \\ \hline Long-term debt, less current portion & 3,062 \\ \hline Total liabilities & 4,841 \\ \hline Shareholders' equity & \\ \hline Ordinary shares - par value \$o.0001, 2.6 billion shares authorized, 1,340,697,595 and & \\ \hline 1,354,218,154 shares issued and outstanding, respectively & 0 \\ \hline Additional paid-in capital & 1.721 \\ \hline Accumulated other comprehensive loss & (34) \\ \hline Accumulated deficit & (3,131) \\ \hline Total shareholders' equity & 1.556 \\ \hline Total liabilities and shareholders' equity & $6,397 \\ \hline \end{tabular} Forecast Seagate Technology's 2020 income statement using the following forecast assumptions, which are expressed as a per Note: Complete the entire question in Excel (template provided above). Using Excel, format each answer to two decim 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. SEGATE TECHNOLOGY PLC Consolidated Statement of Income Forecast Seagate Technology's 2020 balance sheet using the following forecast assumptions, which are expressed as a percentage of revenue unless otherwise if Note: Complete the entire question in Excel (template provided above), Using Excel, format each answer to two decimal places, Use Increase Decimal 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 \begin{tabular}{|l|r|l|} \hline Accumulated other comprehensive loss & No change \\ \hline CAPEX & 5.8% & of revenue \\ \hline Depreciation expense & 5.4% & of beginning Property, equipment and leas \\ \hline Beginning Property, equipment and leasehold improvements, gross & $7.081 & million \\ \hline Stock-based compensation & $99 & million, increases Capital in excess of par v \\ \hline Dividend payout ratio & 35.4% & \\ \hline \end{tabular} \begin{tabular}{|l|l|} \hline Long-term accrued warranty & 0 \\ \hline Long-term accrued income taxes . & 0 \\ \hline Other noncurrent liabilities & 0 \\ \hline Long-term debt, less current portion & 0 \\ \hline Total liabilities & 0 \\ \hline Shareholders equity & \\ \hline Ordinary shares - par value \$0.0001, 2.6 billion shares authorized, 1,340,697,595 and & \\ \hline 1,354,218,154 shares issued and outstanding, respectively & 0 \\ \hline Additional paid-in capital & 0 \\ \hline Accumulated other comprehensive loss & 0 \\ \hline Accumulated deficit & 0 \\ \hline Total shareholders' equity & 0 \\ \hline Total liabilities and shareholders' equity & $ \\ \hline \end{tabular}