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 138-1 to determine the appropriate discount factors) using table Required: I. 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 Required1Reqired 2 Required 3Required 4 Assuming he company's discount rate is 6% calculate the net present value of he store manager's investment opportunity. calculations and round your final answer to the nearest whole number.) Do not round your intermedia e Net present value Required 1 - Required 2 Required 3 Required 4 Calculate the annual margin, turnover, and return on investment (ROI) provided by the store manager's investment opportunity. (Round your answers to 2 decimal places.) Year 1 Year 2 Year 3 Margin Turnover Return on investment Required 1 Reqired 2Required 3 Required 4 Assuming that the company's minimum required rate o each of years 1 through 3 return is 16%, calculate the residual income earned by the store manager's investment opportunity or Year 1 Year 2 Year 3 Residual income Required 1Required 2 Required 3 Required 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? Do you think the store manager would choose to pursue this investment opportunity? OYes ONo Do you think the company would want the store manager to pursue it? OYes ONo