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.

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 for these scenarios?

Transcribed Image Text:

Scenario 3 33% 2 25% 2% 15% 4 33% 1% 20% Tax Rate 25% 3% 12% Inflation Rate Annual Growth of Sales 10%