In cell H$3,$type an absolute cell reference to the cell calculate the profits for

$2022.$Copy the formula across the row to cell N$3.$In cell $H3,$ type an absolute cell reference to the cell that calculates the profits for $2022.$

Copy the formula across the row to cell N$3.$ This will display results for $7$ years of stagnant

profits. $($Increase the width of columns I: N if necessary.$)$

Use the values in the list below as the estimated growth rates of annual profits in cells $H4$:$N4.$

Format the values as percentage with $2$ decimal places.

Year $1$: $\mathrm{.}0925$

Year $2$: $10$

Year $3.\mathrm{.}0825$

Years $4-7$:$\mathrm{.}05$

In cell H$5,$ calculate the Estimated Annual Profits in year $1$ based on the "Stagnant Annual

Profit" amount in H$3$ and the "Estimated Growth Rate" in H$4.$ Format results in Currency with

zero decimals.

Hint: No function is necessary; simple math. Your answers in cells $H5$ : $N5$ will all be greater

than $$152,213.$

In cell H$6,$ calculate the difference between the Year $1$ "Stagnant Annual Profits" and the Year

$1$ "Estimated Annual Profits". AutoFill the calculation over to N$6$ and format as Currency with

zero decimals.

In cell H$7,$ use the SUM function to calculate the total amount of additional profits eamed

throughout the $7-$year period. Format cell as Currency with zero decimals.

In cell $17,$ use an IF function that will display "Yes" if the Total Additional Profits $)$ would be

more than the annual cost of monthly payments $($D$16).$ Otherwise, have cell $17$ display $"$No$".$This will display results for $7$years of stagnant profits.