In: Accounting
Problem 12-17 Net Present Value Analysis; Internal Rate of Return; Simple Rate of Return [LO12-2, LO12-3, LO12-6]
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,510,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,900,000 | ||
| Variable expenses | 2,200,000 | |||
| Contribution margin | 2,700,000 | |||
| Fixed expenses: | ||||
| Advertising, salaries, and other fixed out-of-pocket costs  | 
$ | 850,000 | ||
| Depreciation | 1,102,000 | |||
| Total fixed expenses | 1,952,000 | |||
| Net operating income | $ | 748,000 | ||
Brewer_8e_Rechecks_2020_01_30
Click here to view Exhibit 12B-1 and Exhibit 12B-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?
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,47,300 | ||
| 2 | IRR | = | 20% | ||
| 3 | Simple rate of return | = | 13.6% | ||
| 4 - a. | Yes | ||||
| 4 - b. | No | ||||
| 1 | |||||
| Year | Value Flows | Present Factor @19% | Present Value | ||
| Initial Cost | 0 | $ -55,10,000 | 1 | $ -55,10,000 | |
| Cash Inflows ($748000 + $1102000) | 1 - 5 | $ 18,50,000 | 3.058 | $ 56,57,300 | |
| Net Present Value | $ 1,47,300 | ||||
| 2 | Computation of IRR | ||||
| Year | Value Flows | ||||
| 0 | $ -55,10,000 | ||||
| 1 | $ 18,50,000 | ||||
| 2 | $ 18,50,000 | ||||
| 3 | $ 18,50,000 | ||||
| 4 | $ 18,50,000 | ||||
| 5 | $ 18,50,000 | ||||
| IRR | = | 20% | |||
| 3 | Computation of Simple rate of return: | ||||
| Simple rate of return | = | Net Profit / Investment | |||
| = | $748000 / $5510000 | ||||
| = | 13.6% | 
| 4 - a. | Yes | ||||
| As the Net Present value is positive it is beneficial for company. | |||||
| 4 - b. | No | ||||
| ROI | = | 23% | |||
| Simple rate of return | = | 13.6% | |||
| As, ROI is more than Simple rate of return. It is not recommended to accept the Investment opportunity. |