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,380,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,800,000 | ||
| Variable expenses | 2,160,000 | |||
| Contribution margin | 2,640,000 | |||
| Fixed expenses: | ||||
| Advertising,
salaries, and other fixed out-of-pocket costs |
$ | 840,000 | ||
| Depreciation | 1,076,000 | |||
| Total fixed expenses | 1,916,000 | |||
| Net operating income | $ | 724,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?
Net present value _______________
2. What is the project’s internal rate of return to the nearest whole percent?
| Internal rate of return | % |
3. What is the project’s simple rate of return?
| 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?
Solution 1:
Annual cash inflows = Net operating income + Depreciation = $724,000 + $1,076,000 = $1,800,000
| Computation of NPV - Pigeon company | ||||
| Particulars | Period | Amount | PV factor at 19% | Present Value |
| Cash outflows: | ||||
| Initial investment | 0 | $5,380,000.00 | 1 | $5,380,000 |
| Present Value of Cash outflows (A) | $5,380,000 | |||
| Cash Inflows | ||||
| Annual cash inflows | 1-5 | $1,800,000.00 | 3.058 | $5,504,400 |
| Present Value of Cash Inflows (B) | $5,504,400 | |||
| Net Present Value (NPV) (B-A) | $124,400 |
Solution 2:
| Computation of IRR | ||
| Period | Cash Flows | IRR |
| 0 | -$5,380,000.00 | 20% |
| 1 | $1,800,000.00 | |
| 2 | $1,800,000.00 | |
| 3 | $1,800,000.00 | |
| 4 | $1,800,000.00 | |
| 5 | $1,800,000.00 |
Solution 3:
Simple rate of return = Net operating income / Initial investment = $724,000 / $5,380,000 = 13.46%
Solution 4:
As NPV is positive therefore company want casey to pursue this investment opportunity.
Solution 5:
No Casey do not want pursue this investment opportunity as it will result in decrease of ROI of the division,