90.2K

Verified Solution

Link Copied!

Consider the following income statement. Please use excel. You have to use the Percentages.

Income Statement $-$ Seagate Technology

$($in millions$)7/1/2022$

Revenue $$11,661\mathrm{.}0$

Cost of revenue $8,192\mathrm{.}0$

Product development costs $941\mathrm{.}0$

Marketing & administrative expenses $559\mathrm{.}0$

Amortization of intangibles $11\mathrm{.}0$

Restructuring & other operating expenses, net $3\mathrm{.}0$

Income from operations $1,955\mathrm{.}0$

Interest income $($expense$)(247\mathrm{.}0)$

Other income $($expense$)(29\mathrm{.}0)$

Income before income taxes $1,679\mathrm{.}0$

Provision for $($benefit$)$ income taxes $30\mathrm{.}0$

Net income $$1,649\mathrm{.}0$

An analyst provides the following assumptions used to forecast earnings in year $2023.$ Assume $$no change$$ for accounts not listed. Depreciation expense is included in marketing & administrative expenses.

Assumptions used to forecast income statement in fiscal year $2023$

$($dollar amounts in millions$)$

Revenue change $(\%)-1\mathrm{.}8\%$

Cost of revenue, as a $\%$ of revenue $75\mathrm{.}2\%$

Product development costs, as a $\%$ of revenue $11\mathrm{.}0\%$

Marketing and administrative expenses, as a $\%$ of revenue $7\mathrm{.}2\%$

Restructuring & other operating expenses $$0\mathrm{.}0$

Provision for income taxes, as a $\%$ of pre$-$tax income $22\mathrm{.}0\%$

Use the information above to prepare a forecasted income statement for fiscal year $2023.$ Then, answer the following questions.

a$.$ Calculate forecasted cost of revenue for $2023.$

$$8,706\mathrm{.}0$

b$.$ Calculate forecasted income from operations for $2023.$

$$1,919\mathrm{.}8$

c$.$ Calculate forecasted net income for $2023.$

$[$ Select $]$

Answer & Explanation Solved by verified expert

See Answer