$6.$ A firm performs its financial projections using excel. Sales for the year $2024$ were sh$\mathrm{.}1200000.$ Sales are expected to increase at the rate of $10\%$ per year up to $($and including$)2028$ then decrease at the rate of $2\%$ per year till $2032($inclusive$).$ Cost of sales is $60\%$ of sales. Purchases per year are sh$\mathrm{.}800000.$ Opening stock for $2024$ was sh$.90000.$ Opening stock in a year is closing stock for the immediate previous year. Gross profit is Sales less cost of sales. Cost of sales is opening stock added to purchases less closing stock. Make these entries to an excel worksheet, and hence make projections from $2024$ to $2032.$