Question

Simmons Company is a merchandiser with multiple store locations. One of its store managers is considering a shift in her store's product mix in anticipation of a strengthening economy. Her store would invest $800,000 in more expensive merchandise (an Increase in its working capital) with the expectation that it would increase annual sales and variable expenses by $400,000 and $250,000, respectively for three years. At the end of the three-year period, the store manager believes that the economic surge will subside; therefore, she will release the additional investment in working capital. The store manager's pay raises are largely determined by her store's return on investment (ROI), which has exceeded 22% each of the last three years. Click here to view Exhibit 128-1 to determine the appropriate discount factor(s) using table, Required: 1. Assuming the company's discount rate is 16%, calculate the net present value of the store manager's investment opportunity. 2. Calculate the annual margin, turnover, and return on investment (ROI) provided by the store manager's investment opportunity. 3. Assuming that the company's minimum required rate of return is 16%, calculate the residual income earned by the store manager's investment opportunity for each of years 1 through 3. 4. Do you think the store manager would choose to pursue this investment opportunity? Do you think the company would want the store manager to pursue it? Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Required 4 Assuming the company's discount rate is 16%, calculate the net present value of the store manager's Investment opportunity. (Do not round your intermediate calculations and round your final answer to the nearest whole number.) Net present value Required 1 Required 2 >

Answer 1

Answer to sub part 2 (as required in question)

Annual margin                             Year 1        Year 2       Year 3

Sales (Turnover)                          400000       400000      400000

Variable Expenses                      250000        250000     250000

Margin                                      150000         150000     150000

ROI

Investment amount on year 0- 800000

Return on investment at year 1 (@22%)- 176000

Closing balance- 976000

ROI at year 2 (@22%)- 214720

closing balance- 1190720

ROI at year 3 (@22%)- 261958.40

Closing balance- 1452678