ave a copy to edit.

Copy the formula from cell $B13$ to the range $C13$:$H13.$

In cell B$14,$ create a formula without using a function that adds $1$ to the value in cell

$B12$ and then multiplies the result by the value in cell $B13.$ In this formula, use a mixed

reference for cell $B12$ by including an absolute reference to row $12.$ Copy the formula

from cell $B14$ to the range $B15$:$B17$ and then copy the formulas from the range $B14$:$B17$

to the range $C14$:$H17.$

Delete row $19.$

Your workbook should look like the Final Figures on the following pages. Save your changes,

close the workbook, and then exit Excel. Follow the directions on the SAM website to submit your

completed project.

$($Note: The value in cell H$7$ of the Profit Projections worksheet may differ from that shown below.$)$