In: Accounting
|
Lou Barlow, a divisional manager for Sage Company, has an opportunity to manufacture and sell one of two new products for a five-year period. His annual pay raises are determined by his division’s return on investment (ROI), which has exceeded 25% each of the last three years. He has computed the cost and revenue estimates for each product as follows: |
| Product A | Product B | ||||
| Initial investment: | |||||
| Cost of equipment (zero salvage value) | $ | 360,000 | $ | 530,000 | |
| Annual revenues and costs: | |||||
| Sales revenues | $ | 400,000 | $ | 510,000 | |
| Variable expenses | $ | 180,000 | $ | 250,000 | |
| Depreciation expense | $ | 72,000 | $ | 106,000 | |
| Fixed out-of-pocket operating costs | $ | 85,000 | $ | 65,000 | |
|
|
|||||
| The company’s discount rate is 19%. |
2.
|
|
|
|||||||||||
|
| Computation of annual cash inflows and annual net income | |||||
| Product A | Product B | ||||
| Sales revenue | 400000 | 510,000 | |||
| Less: Variable expense | 180000 | 250,000 | |||
| Less: Fixed cost out of pocket exp | 85000 | 65,000 | |||
| Annual Cash inflows | 135000 | 195,000 | |||
| Less: depreciation | 72000 | 106,000 | |||
| Annual Net income | 63000 | 89,000 | |||
| Average investment | 180000 | 265000 | |||
| (Investment /2) | |||||
| NPV: | |||||
| Product A | Product B | ||||
| Annual Cash inflows | 135000 | 195000 | |||
| Annuity Factor at 19% for 5 years | 3.0576 | 3.0576 | |||
| Present value of inflows | 412776 | 596232 | |||
| Less: Initial Investment | 360000 | 530000 | |||
| Net present value | 52776 | 66232 | |||
| Project Profitability index: | |||||
| Product A | Product B | ||||
| Present value of Inflows | 412776 | 596232 | |||
| Divide: Initial Investment | 360000 | 530000 | |||
| Profitability Index | 1.15 | 1.125 | |||
| Rate of return: | |||||
| Product A | Product B | ||||
| Annual net income | 63000 | 89000 | |||
| Divide: Average investment | 180000 | 265000 | |||
| Average rate of return | 35% | 33.58% | |||
| Choice of projeect | |||||
| NPV | PI | Rate of return | |||
| Selection | Product B | Product A | Product A | ||