Net Discounted Cash Flow. Goal Kick Sports $($GKS$)$ is a retail chain that sells youth and adult soccer equipment. The GKS financial planning group has developed a spreadsheet model to calculate the net discounted cash flow of the first five years of operations for a new store. This model is used to assess new locations under consideration for expansion. Data file GoalKick.

a$.$

Use Excel's Formula Auditing tools to audit this model and correct any errors found.

b$.$

Once you are comfortable that the model is correct, use Scenario Manager to generate a Scenario Summary report that gives Total Discounted Cash Flow for the following scenarios:

$\backslash$table$[[,1,2,3,4],[$Tax Rate,$3350,25\%,33\%,25\%$