$9.$ Go to the Estimated Earnings worksheet. Hwan has entered most of the income and expense data on the worksheet. He estimates sales will be $$825,000$ in Year $1$ and $$1,800,000$ in Year $5.$ He needs to calculate the sales amounts for Years $24.$ The sales should increase at a constant amount from year to year.

Project the sales amounts for Years $24($cells D$9$:F$9)$ using a Linear Trend interpolation.

$10.$ Hwan also needs to calculate some expense amounts. He knows the starting amount of the miscellaneous expense and has estimated the amount in Year $5.$ He thinks this expense will increase by a constant percentage.

Project the miscellaneous expenses for Years $24($cells D$17$:F$17)$ using a Growth Trend interpolation.

$11.$ Hwan also knows the rent will be $$45,000$ in Year $1$ and will increase by at least $4$ percent per year.

Project the rent expenses as follows:

a$.$ Project the expenses for rent for Years $25($cells D$19$:G$19)$ using a Growth Trend extrapolation.

b$.$ Use $1\mathrm{.}04($a $4$ percent increase$)$ as the step value.