80.2K

Verified Solution

Link Copied!

goal kick

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 34% 22% 39% 22% Inflation Rate 3% 4% 1% 2% UP Annual Growth of Sales 23% 17% 7% 7% 15% What is the range of values for the Total Discounted Cash Flow (in dollars) for these scenarlos? (Round your answer to the nearest dollar.) Rent Per Square Foot $ 30 Labor Cost $ 150,000 Other Expenses $ 235,000 Year Sales Revenue 2 3 $1,092,500 $1,256,375 4 $1,444,831 $950,000 $1,661,556 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 $404,553 $159,181 $238,772 $249,384 S465,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 S111,191 S480,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 S61,873 $106,304 $149,770 $192,440 $234,475 Total Discounted Cash Flow $744,862

Answer & Explanation Solved by verified expert

See Answer