Think of any retailer that operates many stores throughout the country. The retailer is often seeking to open now stores and needs to evaluate the profitability of a proposed location that would be leased for five years. An Excel model is provided in the New Store Financial Model spreadsheet. Use the Scenario Manager to ovalute the cumulative discounted cash flow for the fifth your under the scenarios. Click to view the scenarios Click to view the New Store. Financial Model Spreadsheet with numbers Click to view the New Store Financial Model Spreadsheet with Excel Functions. Complete the table below Scenario 1 Scenario 2 Scenario 3 Cumulative Discounted O Cash Flow (Round to the nearest Integer as needed) Scenario 1 5% 30% Scenario 2 4% 31% Scenario 3 2% 20% Inflation Rate Cost of Merchandise % of sales) Labor Cost Other Expenses First-year sales revenue Sales Growth year 2 Sales Growth year 3 Sales Growth $225000 $350000 $600000 $350000 $280000 $700000 $200000 $325000 $800000 22% 17% 24% 15% 13% 20% 11% 11% 14% year 4 5% 5% 8% Sales Growth year 5 Think of any retailer that operates many stores throughout the country. The retailer is often seeking to open now stores and needs to evaluate the profitability of a proposed location that would be leased for five years. An Excel model is provided in the New Store Financial Model spreadsheet. Use the Scenario Manager to ovalute the cumulative discounted cash flow for the fifth your under the scenarios. Click to view the scenarios Click to view the New Store. Financial Model Spreadsheet with numbers Click to view the New Store Financial Model Spreadsheet with Excel Functions. Complete the table below Scenario 1 Scenario 2 Scenario 3 Cumulative Discounted O Cash Flow (Round to the nearest Integer as needed) Scenario 1 5% 30% Scenario 2 4% 31% Scenario 3 2% 20% Inflation Rate Cost of Merchandise % of sales) Labor Cost Other Expenses First-year sales revenue Sales Growth year 2 Sales Growth year 3 Sales Growth $225000 $350000 $600000 $350000 $280000 $700000 $200000 $325000 $800000 22% 17% 24% 15% 13% 20% 11% 11% 14% year 4 5% 5% 8% Sales Growth year 5