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 24% each of the last three years. Casey is considering a capital budgeting project that would require a $4,900,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:
Sales | $ | 4,600,000 | ||
Variable expenses | 2,080,000 | |||
Contribution margin | 2,520,000 | |||
Fixed expenses: | ||||
Advertising, salaries, and other fixed out-of-pocket costs |
$ | 820,000 | ||
Depreciation | 980,000 | |||
Total fixed expenses | 1,800,000 | |||
Net operating income | $ | 720,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?
1 | Net Present Value | = | $ 1,84,700 | ||
2 | IRR | = | 22% | ||
3 | Simple rate of return | = | 14.7% | ||
4 - a. | Yes | ||||
4 - b. | No | ||||
1 | |||||
Year | Value Flows | Present Factor @20% | Present Value | ||
Initial Cost | 0 | $ -49,00,000 | 1 | $ -49,00,000 | |
Cash Inflows ($980000 + $720000) | 1 - 5 | $ 17,00,000 | 2.991 | $ 50,84,700 | |
Net Present Value | $ 1,84,700 | ||||
2 | Computation of IRR | ||||
Year | Value Flows | ||||
0 | $ -49,00,000 | ||||
1 | $ 17,00,000 | ||||
2 | $ 17,00,000 | ||||
3 | $ 17,00,000 | ||||
4 | $ 17,00,000 | ||||
5 | $ 17,00,000 | ||||
IRR | = | 22% | |||
Formula | =IRR(I15:I20) | ||||
3 | Computation of Simple rate of return: | ||||
Simple rate of return | = | Net Profit / Investment | |||
= | $720000 / $4900000 | ||||
= | 14.7% | ||||
4 - a. | Yes | ||||
As the Net Present value is positive it is beneficial for company. | |||||
4 - b. | No | ||||
ROI | = | 24% | |||
Simple rate of return | = | 14.7% | |||
As, ROI is more than Simple rate of return. It is not recommended to accept the Investment opportunity. | |||||
If it is helpful, please rate the answer and if any doubt arises let me know |