WLC Company is a company in Franklin, WI. It 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 13B-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?
Solution 1:
Computation of NPV - WLC Company | ||||
Particulars | Amount | Period | PV Factor | Present Value |
Cash Outflows: | ||||
Initial Investment in working capital | $800,000 | 0 | 1 | $800,000 |
Present Value of Cash Outflows (A) | $800,000 | |||
Cash Inflows: | ||||
Increase in annual contribution | $150,000 | 1-3 | 2.24589 | $336,883 |
Release of working capital | $800,000 | 3 | 0.640658 | $512,526 |
Present Value of Cash Inflows (B) | $849,410 | |||
Net Present Value (B-A) | $49,410 |
Solution 2:
Annual margin of store manager's investment opportunity = Additional Sales - Additional variable cost
= $400,000 - $250,000 = $150,000
Annual margin percentage = $150,000 / $400,000 = 37.50%
Turnvoer ratio = Sales / Investment = $400,000 / $800,000 = 0.50
ROI = Margin * Turnover = 37.50%*0.5 = 18.75%
Solution 3:
Minimum required return on investment opportunity = $800,000 * 16% = $128,000
Actual annual income from investment opportunity = $150,000
Residual Income for each year 1 to 3 = $150,000 - $128,000 = $22000
Solution 4:
As store manager pay raise determined by ROI which has exceeded 22% in last 3 years, if store manager will pursue this investment opportunity then store ROI will decrease beacuse ROI provided by new investment opportunity is only 18.75%. Therefore store manager would not pursue this investment opportunity.
As ROI provided by investment opportunity is higher than minimum required return of the company, therefore company want the store manager to pursue it.
WLC Company is a company in Franklin, WI. It is a merchandiser with multiple store locations....
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...
Integration Exercise 7 Capital Budgeting, Return on Investment, Residual Income [LO 10-1, LO 10-2, LO 12-2]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...
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...
could you plz help me with question number 5, I did question 1
through 4 I hope my answers are correct! you can see the answer it
is in excel pic
A с . о EF 1 1) Calculate net present value of store managers Investment Investment Year 0 Year 1 Year 2 Year 3 Total 3 Amount to be invested $(800,000.00) $ (800,000.00) 4 Annual cash Inflow $ 400,000.00 $ 400,000.00 $ 400,000.00 $1,200,000.00 5 Annual cash Outflow $(250,000.00)...
Derrick Iverson is a divisional manager for Holston Company. His annual pay raises are largely determined by his division’s return on investment (ROI), which has been above 20% each of the last three years. Derrick is considering a capital budgeting project that would require a $3,050,000 investment in equipment with a useful life of five years and no salvage value. Holston Company’s discount rate is 16%. The project would provide net operating income each year for five years as follows:...
Casey Nelson is a divisional manager for Pigeon Company. His annual pay raises are largely determined by his division’s return on investment (ROI), which has been above 23% each of the last three years. Casey is considering a capital budgeting project that would require a $5,620,000 investment in equipment with a useful life of five years and no salvage value. Pigeon Company’s discount rate is 19%. The project would provide net operating income each year for five years as follows:...
Casey Nelson is a divisional manager for Pigeon Company. His annual pay raises are largely determined by his division’s return on investment (ROI), which has been above 22% each of the last three years. Casey is considering a capital budgeting project that would require a $3,900,000 investment in equipment with a useful life of five years and no salvage value. Pigeon Company’s discount rate is 18%. The project would provide net operating income each year for five years as follows:...
Casey Nelson is a divisional manager for Pigeon Company. His annual pay raises are largely determined by his division’s return on investment (ROI), which has been above 23% each of the last three years. Casey is considering a capital budgeting project that would require a $4,700,000 investment in equipment with a useful life of five years and no salvage value. Pigeon Company’s discount rate is 19%. The project would provide net operating income each year for five years as follows:...
Casey Nelson is a divisional manager for Pigeon Company. His annual pay raises are largely determined by his division’s return on investment (ROI), which has been above 23% each of the last three years. Casey is considering a capital budgeting project that would require a $5,510,000 investment in equipment with a useful life of five years and no salvage value. Pigeon Company’s discount rate is 19%. The project would provide net operating income each year for five years as follows:...
Casey Nelson is a divisional manager for Pigeon Company. His annual pay raises are largely determined by his division’s return on investment (ROI), which has been above 24% each of the last three years. Casey is considering a capital budgeting project that would require a $5,850,000 investment in equipment with a useful life of five years and no salvage value. Pigeon Company’s discount rate is 20%. The project would provide net operating income each year for five years as follows:...