In: Accounting
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:
| Sales | $ | 4,400,000 | ||
| Variable expenses | 2,000,000 | |||
| Contribution margin | 2,400,000 | |||
| Fixed expenses: | ||||
| Advertising, salaries, and other fixed out-of-pocket costs |
$ | 800,000 | ||
| Depreciation | 940,000 | |||
| Total fixed expenses | 1,740,000 | |||
| Net operating income | $ | 660,000 | ||
Click here to view Exhibit 13B-1 and Exhibit 13B-2, to determine the appropriate discount factor(s) using tables.
Required:
1. What is the project’s net present value?
2. What is the project’s internal rate of return to the nearest whole percent?
3. What is the project’s simple rate of return?
4-a. Would the company want Casey to pursue this investment opportunity?
4-b. Would Casey be inclined to pursue this investment opportunity?
I need assistance with the entire problem. Thank you!
| Net operating income | 660000 | |||||
| Add: Depreciation | 940000 | |||||
| Net cash flows | 1600000 | |||||
| 1 | ||||||
| Now | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | |
| Investment cost | -4700000 | |||||
| Net cash flows | 1600000 | 1600000 | 1600000 | 1600000 | 1600000 | |
| Total cash flows | -4700000 | 1600000 | 1600000 | 1600000 | 1600000 | 1600000 |
| PV factor @ 19% | 1 | 0.840 | 0.706 | 0.593 | 0.499 | 0.419 |
| Present value of cash flows | -4700000 | 1344000 | 1129600 | 948800 | 798400 | 670400 |
| Net present value | 191200 | |||||
| 2 | ||||||
| PV factor internal rate of return=4700000/1600000 = 2.938 | ||||||
| The PV factor 2.938 for 5 years is closest to 21% | ||||||
| Internal rate of return = 21% | ||||||
| 3 | ||||||
| Simple rate of return = Net operating income/Investment cost | ||||||
| Simple rate of return = 660000/4700000= 14.0% | ||||||
| 4a | ||||||
| Yes, the company would want Casey to pursue this investment as Net Present value is positive | ||||||
| 4b | ||||||
| No, Casey would not be inclined to pursue this investment as as his ROI will decrease | ||||||