Project $3$: $10-$Year Financial Model, Valuation, and Ownership

$($Submission deadline: $9$:$30$am Tucson time, Tuesday, Nov $21,2023)$

The goals of Project $3$ are to $(1)$ estimate the value of business using key ratios and $(2)$ estimate the business ownership with stock sold.

Start with your completed and correct project $2$ solution.

$1.$ Copy the Excel template available in D$2$L called $$Tables$.$xlsx$$ into your Project $3$ spreadsheet. A screenshot of the Table $1$ template is shown below.

$2.$ Fill in Table $1$ with the provided key ratio equations for each year in the yellow$-$highlighted cells.

$3.$ Calculate the average of the three$-$year key ratios and record it in the $$Average$$ column.

$4.$ In the $$Conclusion$$ column, answer this question: Is our $5-$year average ratio better than the industry standard? If yes, enter $$better$$; otherwise, enter $$worse$.$ Use $$if$$ statement than hard$-$coding $$better$$ or $$worse$.$