Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Goal Kick Sports New Store Financial Model Parameters $ Store Size (square feet) Total Fixed Assets Straight Line Depreciation period Discount Rate Tax Rate Inflation
Goal Kick Sports New Store Financial Model Parameters $ Store Size (square feet) Total Fixed Assets Straight Line Depreciation period Discount Rate Tax Rate Inflation Rate Cost of Merchandise % of sales) 7,500 280,000 5 10% 33% 2% 28% $ First Year Sales Revenue Annual Growth Rate of Sales 950,000 15% Operating Expenses Rent Per Square Foot $ Labor Cost $ Other Expenses $ 30 150,000 235,000 Year Sales Revenue 1 $950,000 2 $1,092,500 3 $1,256,375 4 $1,444,831 5 $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 $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 on $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 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 38% 21% 31% 33% Inflation Rate 2% 4% 3% 1% Annual Growth of Sales 26% 19% 7% 13% 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) Total Fixed Assets Straight Line Depreciation period Discount Rate Tax Rate Inflation Rate Cost of Merchandise % of sales) 7,500 280,000 5 10% 33% 2% 28% $ First Year Sales Revenue Annual Growth Rate of Sales 950,000 15% Operating Expenses Rent Per Square Foot $ Labor Cost $ Other Expenses $ 30 150,000 235,000 Year Sales Revenue 1 $950,000 2 $1,092,500 3 $1,256,375 4 $1,444,831 5 $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 $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 on $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 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 38% 21% 31% 33% Inflation Rate 2% 4% 3% 1% Annual Growth of Sales 26% 19% 7% 13% What is the range of values for the Total Discounted Cash Flow (in dollars) for these scenarios? (Round your answer to the nearest dollar.) $ $
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started