Either reference another cell or enter a formula into each of the cells marked with a $?$

Requirements for Excel #$4$:

$$ Worth $10$ points

$$ No partial credit

$$ Rows $35$ and beyond must be calculated amounts. Other than dividing by the numeral $4$ to convert an annual amount to a quarterly amount there should be no $$hard$$ numbers in your solution.$$

$$ Cell C$4$: change to read "change per quarter"

$$ First quarter unit sales should be $30,000$ with the expected change in unit sales to be a $12\%$ increase every quarter.

$$ Since you will have step by step guide late submissions with not be counted.

$$ Use the supplied template only.

FOR THOSE THAT BEGAN THE ASSIGNMENT PRIOR TO NOV $2--$ CHANGE YOUR SELLING PRICE $($cell B$8)$ to $$45$

Please Provide formulas as well as answers.