Average Rate of Return Method, Net Present Value Method, and Analysis for a service company
The capital investment committee of Arches Landscaping Company is considering two capital investments. The estimated operating income and net cash flows from each investment are as follows:
Front-End Loader | Greenhouse | |||||||||
Year | Operating Income |
Net Cash Flow |
Operating Income |
Net Cash Flow |
||||||
1 | $39,600 | $124,000 | $83,000 | $198,000 | ||||||
2 | 39,600 | 124,000 | 63,000 | 167,000 | ||||||
3 | 39,600 | 124,000 | 32,000 | 118,000 | ||||||
4 | 39,600 | 124,000 | 14,000 | 81,000 | ||||||
5 | 39,600 | 124,000 | 6,000 | 56,000 | ||||||
Total | $198,000 | $620,000 | $198,000 | $620,000 |
Each project requires an investment of $360,000. Straight-line depreciation will be used, and no residual value is expected. The committee has selected a rate of 10% for purposes of the net present value analysis.
Present Value of $1 at Compound Interest | |||||
Year | 6% | 10% | 12% | 15% | 20% |
1 | 0.943 | 0.909 | 0.893 | 0.870 | 0.833 |
2 | 0.890 | 0.826 | 0.797 | 0.756 | 0.694 |
3 | 0.840 | 0.751 | 0.712 | 0.658 | 0.579 |
4 | 0.792 | 0.683 | 0.636 | 0.572 | 0.482 |
5 | 0.747 | 0.621 | 0.567 | 0.497 | 0.402 |
6 | 0.705 | 0.564 | 0.507 | 0.432 | 0.335 |
7 | 0.665 | 0.513 | 0.452 | 0.376 | 0.279 |
8 | 0.627 | 0.467 | 0.404 | 0.327 | 0.233 |
9 | 0.592 | 0.424 | 0.361 | 0.284 | 0.194 |
10 | 0.558 | 0.386 | 0.322 | 0.247 | 0.162 |
Required:
1a. Compute the average rate of return for each investment. If required, round your answer to one decimal place.
Average Rate of Return | |
Front-End Loader | % |
Greenhouse | % |
1b. Compute the net present value for each investment. Use the present value of $1 table above. If required, round to the nearest dollar. If required, use the minus sign to indicate a negative net present value.
Front-End Loader | Greenhouse | |
Present value of net cash flow | $ | $ |
Amount to be invested | ||
Net present value | $ | $ |
1a) Average rate of return :
Front end loader = 39600/180000 = 22%
Greenhouse = 39600/180000 = 22%
1b. Compute the net present value for each investment. Use the present value of $1 table above. If required, round to the nearest dollar. If required, use the minus sign to indicate a negative net present value.
Front-End Loader | Greenhouse | |
Present value of net cash flow | 124000*3.79 = 469960 | $496641 |
Amount to be invested | -360000 | -360000 |
Net present value | 109960 | $136641 |
Get Answers For Free
Most questions answered within 1 hours.