Goal Kick Sports New Store Financial Model Parameters Store Size (square feet) 7,500 5 Total Fixed Assets 280,000 Straight Line Depreciation period S Discount Rate 10% 3 Tax Rate 33% Inflation Rate 2% o Cost of Merchandise % of sales) 28% 1 2 First Year Sales Revenue $ 950,000 3 Annual Growth Rate of Sales 15% 4 5 Operating Expenses 6 Rent Per Square Foot $ 30 7 Labor Cost $ 150,000 8 Other Expenses $ 235,000 9 o Model 1 Year 2 Sales Revenue 3 4 Cost of Merchandise 5 Labor Cost 6 Rent 7 Other Expenses 8 9 Net Operating Income 0 Depreciation Expense 1 2 Net Income Before Tax 3 Income Tax 4 5 Net After Tax Income Dl Dantasistian Cranes 2 $1,092,500 3 $1,256,375 5 $1,661,556 $950,000 $1,444,831 $266,000 $150,000 $225,000 $235,000 $305,900 $153,000 $229,500 $239,700 $351,785 $156,060 $234,090 $244,494 $404,553 $159,181 $238,772 $249,384 $465,236 $162,365 $243,547 $254,372 $74,000 $56,000 $164,400 $56,000 $269,946 $56,000 $392,942 $56,000 S536,037 $56,000 $18,000 $5,940 $108,400 $35,772 $213,946 $70,602 $336,942 $111,191 $480,037 $158,412 $12,060 56000 $72,628 56.000 $143,344 056 000 $225,751 56.000 $321,625 656 000 Year 1 $950,000 2 $1,092,500 3 $1,256,375 4 $1,444,831 5 $1,661,556 Sales Revenue Cost of Merchandise Labor Cost Rent Other Expenses $266,000 $150,000 $225,000 $235,000 $305,900 $153,000 $229,500 $239,700 $351,785 $156,060 $234,090 $244,494 aan $404,553 $159,181 $238,772 $249,384 $465,236 $162,365 $243,547 $254,372 Net Operating Income Depreciation Expense $74,000 $56,000 $164,400 $56,000 $269,946 $56,000 $392,942 $56,000 $536,037 $56,000 Net Income Before Tax Income Tax $18,000 $5,940 $108,400 $35,772 $213,946 $70,602 $336,942 $111,191 $480,037 $158,412 Net After Tax Income Plus Depreciation Expense Annual Cash Flow $12,060 $56,000 $68,060 $72,628 $56,000 $128,628 $143,344 $56,000 $199,344 $225,751 $56,000 $281,751 $321,625 $56,000 $377,625 Discounted Cash Flow $61,873 $106,304 $149,770 $192,440 $234,475 Total Discounted Cash Flow $744,862 DATAFile:TGoalKick 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. Use Scenario Manager to generate a Scenario Summary report that gives Total Discounted Cash Flow for the following scenarios. Scenario 1 2 3 4 Tax Rate 37% 26% 31% 21% Inflation Rate 1% 4% 3% 2% Annual Growth of Sales 24% 17% 6% 16% What is the range of values for the Total Discounted Cash Flow (in dollars) for these scenarios? (Round your answer to the nearest dollar.) Goal Kick Sports New Store Financial Model Parameters Store Size (square feet) 7,500 5 Total Fixed Assets 280,000 Straight Line Depreciation period S Discount Rate 10% 3 Tax Rate 33% Inflation Rate 2% o Cost of Merchandise % of sales) 28% 1 2 First Year Sales Revenue $ 950,000 3 Annual Growth Rate of Sales 15% 4 5 Operating Expenses 6 Rent Per Square Foot $ 30 7 Labor Cost $ 150,000 8 Other Expenses $ 235,000 9 o Model 1 Year 2 Sales Revenue 3 4 Cost of Merchandise 5 Labor Cost 6 Rent 7 Other Expenses 8 9 Net Operating Income 0 Depreciation Expense 1 2 Net Income Before Tax 3 Income Tax 4 5 Net After Tax Income Dl Dantasistian Cranes 2 $1,092,500 3 $1,256,375 5 $1,661,556 $950,000 $1,444,831 $266,000 $150,000 $225,000 $235,000 $305,900 $153,000 $229,500 $239,700 $351,785 $156,060 $234,090 $244,494 $404,553 $159,181 $238,772 $249,384 $465,236 $162,365 $243,547 $254,372 $74,000 $56,000 $164,400 $56,000 $269,946 $56,000 $392,942 $56,000 S536,037 $56,000 $18,000 $5,940 $108,400 $35,772 $213,946 $70,602 $336,942 $111,191 $480,037 $158,412 $12,060 56000 $72,628 56.000 $143,344 056 000 $225,751 56.000 $321,625 656 000 Year 1 $950,000 2 $1,092,500 3 $1,256,375 4 $1,444,831 5 $1,661,556 Sales Revenue Cost of Merchandise Labor Cost Rent Other Expenses $266,000 $150,000 $225,000 $235,000 $305,900 $153,000 $229,500 $239,700 $351,785 $156,060 $234,090 $244,494 aan $404,553 $159,181 $238,772 $249,384 $465,236 $162,365 $243,547 $254,372 Net Operating Income Depreciation Expense $74,000 $56,000 $164,400 $56,000 $269,946 $56,000 $392,942 $56,000 $536,037 $56,000 Net Income Before Tax Income Tax $18,000 $5,940 $108,400 $35,772 $213,946 $70,602 $336,942 $111,191 $480,037 $158,412 Net After Tax Income Plus Depreciation Expense Annual Cash Flow $12,060 $56,000 $68,060 $72,628 $56,000 $128,628 $143,344 $56,000 $199,344 $225,751 $56,000 $281,751 $321,625 $56,000 $377,625 Discounted Cash Flow $61,873 $106,304 $149,770 $192,440 $234,475 Total Discounted Cash Flow $744,862 DATAFile:TGoalKick 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. Use Scenario Manager to generate a Scenario Summary report that gives Total Discounted Cash Flow for the following scenarios. Scenario 1 2 3 4 Tax Rate 37% 26% 31% 21% Inflation Rate 1% 4% 3% 2% Annual Growth of Sales 24% 17% 6% 16% What is the range of values for the Total Discounted Cash Flow (in dollars) for these scenarios? (Round your answer to the nearest dollar.)