$1))$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.

$($a$)$ Use Excel's Formula Auditing tools to audit this model and correct any errors found. What is the total discounted cash flow $($in dollars$)$ calculated by the corrected spreadsheet? $($Round you

answer to the nearest dollar.$)$

$

$($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.

What is the range of values for the Total Discounted Cash Flow $($in dollars$)$ for these scenarios? $($Round your answer to the nearest dollar.$)$

$