Tab $1$:

#$1.$ Using the $1$st tab of the starter file and Goal Seek.

Set the initial field values to: Unit Cost: $$6\mathrm{.}00.$

If our goal is for the Contribution Margin Percent to be $54\%,$ Invoke Goal Seek so as to figure out what the Sales Price $($changing cell$)$ is and the answer is $

A

B

C

D

E

F

$H$

$1$

One$-$Variable Table

$2$ Loan Conditions

$\backslash$table$[[,$Down Payment,$500\mathrm{.}00],[,$APR,$6\mathrm{.}00\%$