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 $5,800,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 | $ | 5,100,000 | ||
Variable expenses | 2,280,000 | |||
Contribution margin | 2,820,000 | |||
Fixed expenses: | ||||
Advertising, salaries, and other fixed out-of-pocket costs |
$ | 870,000 | ||
Depreciation | 1,160,000 | |||
Total fixed expenses | 2,030,000 | |||
Net operating income | $ | 790,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?
Net operating income | 790000 | |||||
Add: Depreciation | 1160000 | |||||
Net cash flows | 1950000 | |||||
1 | ||||||
Now | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | |
Investment cost | -5800000 | |||||
Net cash flows | 1950000 | 1950000 | 1950000 | 1950000 | 1950000 | |
Total cash flows | -5800000 | 1950000 | 1950000 | 1950000 | 1950000 | 1950000 |
PV factor @ 19% | 1 | 0.840 | 0.706 | 0.593 | 0.499 | 0.419 |
Present value of cash flows | -5800000 | 1638000 | 1376700 | 1156350 | 973050 | 817050 |
Net present value | 161150 | |||||
2 | ||||||
PV factor internal rate of return=5800000/1950000 = 2.974 | ||||||
The PV factor 2.974 for 5 years is closest to 20% | ||||||
Internal rate of return = 20% | ||||||
3 | ||||||
Simple rate of return = Net operating income/Investment cost | ||||||
Simple rate of return = 790000/5800000= 13.6% | ||||||
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 |