Forecast Seagate Technology$$s $2020$ balance sheet using the following forecast assumptions, which are expressed as a percentage of revenue unless otherwise indicated.

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.

Assumptions

Accounts receivable, net $9\mathrm{.}5\%$ of revenue

Inventories $9\mathrm{.}3\%$ of revenue

Other current assets $1\mathrm{.}8\%$ of revenue

Deferred income taxes $10\mathrm{.}7\%$ of revenue

Other assets, net $1\mathrm{.}8\%$ of revenue

Accounts payable $13\mathrm{.}7\%$ of revenue

Accrued employee compensation $1\mathrm{.}6\%$ of revenue

Accrued warranty $0\mathrm{.}9\%$ of revenue

Accrued expenses $5\mathrm{.}3\%$ of revenue

Long$-$term accrued warranty $1\mathrm{.}0\%$ of revenue

Other noncurrent liabilities $1\mathrm{.}3\%$ of revenue

Goodwill No change

Long$-$term accrued income taxes No change

Long$-$term debt, less current portion No change

Ordinary Shares No change

Accumulated other comprehensive loss No change

CAPEX $5\mathrm{.}8\%$ of revenue

Depreciation expense $5\mathrm{.}4\%$ of beginning Property, equipment and leasehold improvements, gross

Beginning Property, equipment and leasehold improvements, gross $$9,835$ million

Stock$-$based compensation $$99$ million, increases Capital in excess of par value by the same amount. Assume that the company routinely includes this form of compensation in operating expenses each year.

Dividend payout ratio $35\mathrm{.}4\%$