WowMart: WowMart, a regional retail company, needs to evaluate the profitability of a proposed location that would be leased for 5 years. The Excel spreadsheet named "WowMart" contains the financial details of the retailer and its 5-year projection of sales and income. Based on the provided estimates for Years 1 to 4. complete the content of Cells F11:F15 by using suitable Excel formulas (i.e, do not type numerical results into the cells). Based on the results, what is the "After Tax Profits" for Year 5? Center numeric digit(s) with up to 2 decimal places; do not use any comma, space or other unnecessary symbols) Question 9 of 27 A Moving to another question will save this response. 10 points Save Answer WowMart: WowMart, a regional retail company, needs to evaluate the profitability of a proposed location that would be leased for 5 years. The Excel spreadsheet named "Wow Mart" contains the financial details of the retailer and its 5-year projection of sales and income. Based on the 5-year estimates computed in the previous question, what is the total net present value of these five years' after-tax profits? Use the NPV function in Excel and the provided "Interest Rate" (Cell B8) to compute the total net present value in Cell B17). (enter numeric digit(s) with up to 2 decimal places; do not use any comma, space or other unnecessary symbols). WowMart: WowMart, a regional retail company, needs to evaluate the profitability of a proposed location that would be leased for 5 years. The Excel spreadsheet named "Wow Mart" contains the financial details of the retailer and its 5-year projection of sales and income. Use Scenario Manager in Excel to evaluate the cumulative discounted cash flow for the fifth year under these scenarios: Scenario 1 Scenario 2 Scenario 3 Sales Revenue (Year 1) $600,000 $300,000 $100,000 Sales Growth 696 896 9% Cost of sales (Year 1) 9096 75% 8596 Cost Growth 11% 10% 896 Interest Rate 596 396 2% Based on the results, what is the highest NPV produced by the best scenario out of these three and the original scenarios? (enter numeric digit(s) with up to 2 decimal places; do not use any comma, space or other unnecessary symbols). B C 34% $500,000 7% 80% 12% 4% 1 WowMart 2 3 Tax Rate 4 Sales Revenue (Year 1) 5 Sales Growth 6 Cost of Sales (Year 1) 7 Cost Growth 8 Interest Rate 9 10 Year 11 Sales Revenue 12 Cost of Sales 13 Before Tax Profits 14 Tax 15 After Tax Profits 16 17 Net Present Value 18 19 20 1 2 3 4 $500,000.00 $535,000.00 $572,450.00 $612,521.50 $400,000.00 $448,000.00 $501,760.00 $561,971.20 $100,000.00 $87,000.00 $70,690.00 $50,550.30 $34,000.00 $29,580.00 $24,034.60 $17,187.10 $66,000.00 $57,420.00 $46,655.40 $33,363.20 Sunshine Subtotal Pivot WowMart Select destination and press ENTER or choose Poste
