This assignment allows you to use the various skills presented over the past week.$$ In this exercise, you will prepare a spreadsheet to model the financial results of the fictional company XYZ in a mini$-$income statement format, for $20242030.$ XYZ is a fictional grocery store planning to introduce Ready Meals to increase revenue.

$$

$1.$ Your spreadsheet will consist of the following information for each of the years $2024-2030$: Revenue, Cost of Goods Sold, Gross Margin, Sales, General and Administrative Costs and Net Profit.$$ The model created must allow for flexibility, i$.$e$.,$ a change in assumptions so that different scenarios can be run.

$2.$ XYZ$$s Revenue for $2023$ was $$2\mathrm{.}5$ million

$3.$ For $2024,$ XYZ$$s Revenue is expected to increase $8\mathrm{.}9\%$ from $2023$s level.

$4.$ For $2025$ to $2030,$ XYZ is projecting annual Revenue increases of $7\mathrm{.}5\%$

$5.$ XYZ$$s Cost of Goods Sold is calculated as a percentage of Revenue and is estimated at $34\%$ of Revenue in $2024$

$6.$ For $2025$ to $2030,$ XYZ$$s Cost of Goods Sold is expected to decrease by $3\mathrm{.}0\%$ per year

$7.$ Sales, General and Administrative Expenses are expected to be $60\%$ of Revenue in $2024.$

$8.$ From $2025-2030,$ Sales, General and Administrative Costs are expected to decrease to $45\%$ of Revenue