1. Midwest Fabricators Inc. is considering an investment in equipment that will replace direct labor. The equipment has a cost of $129,000 with a $11,000 residual value and a ten-year life. The equipment will replace one employee who has an average wage of $30,650 per year. In addition, the equipment will have operating and energy costs of $6,250 per year.
Determine the average rate of return on the equipment, giving
effect to straight-line depreciation on the investment. If
required, round to the nearest whole percent.
%
_________________________________________________
2.Prime Financial Inc. is evaluating two capital investment proposals for a drive-up ATM kiosk, each requiring an investment of $125,000 and each with an eight-year life and expected total net cash flows of $200,000. Location 1 is expected to provide equal annual net cash flows of $25,000, and Location 2 is expected to have the following unequal annual net cash flows:
Year 1 | $56,000 | Year 5 | $18,000 | |
Year 2 | 43,000 | Year 6 | 14,000 | |
Year 3 | 26,000 | Year 7 | 11,000 | |
Year 4 | 24,000 | Year 8 | 8,000 |
Determine the cash payback period for both location proposals.
Location 1 | years |
Location 2 | years |
___________________________________________________________
3. The capital investment committee of Ellis Transport and Storage Inc. is considering two investment projects. The estimated income from operations and net cash flows from each investment are as follows:
Warehouse | Tracking Technology | |||||||||
Year | Income from Operations |
Net Cash Flow |
Income from Operations |
Net Cash Flow |
||||||
1 | $61,600 | $189,000 | $129,000 | $302,000 | ||||||
2 | 61,600 | 189,000 | 99,000 | 255,000 | ||||||
3 | 61,600 | 189,000 | 49,000 | 180,000 | ||||||
4 | 61,600 | 189,000 | 22,000 | 123,000 | ||||||
5 | 61,600 | 189,000 | 9,000 | 85,000 | ||||||
Total | $308,000 | $945,000 | $308,000 | $945,000 |
Each project requires an investment of $560,000. Straight-line depreciation will be used, and no residual value is expected. The committee has selected a rate of 12% 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 | |
Warehouse | % |
Tracking Technology | % |
1b. Compute the net present value for each investment. Use the present value of $1 table above. If required, use the minus sign to indicate a negative net present value.
Warehouse | Tracking Technology | |
Present value of net cash flow total | $ | $ |
Less amount to be invested | $ | $ |
Net present value | $ | $ |
2. The warehouse has a net present value as tracking technology cash flows occur in time. Thus, if only one of the two projects can be accepted, the would be the more attractive.
________________________________________________________
4. The internal rate of return method is used by King Bros. Construction Co. in analyzing a capital expenditure proposal that involves an investment of $64,890 and annual net cash flows of $18,000 for each of the five years of its useful life.
Present Value of an Annuity of $1 at Compound Interest | |||||
Year | 6% | 10% | 12% | 15% | 20% |
1 | 0.943 | 0.909 | 0.893 | 0.870 | 0.833 |
2 | 1.833 | 1.736 | 1.690 | 1.626 | 1.528 |
3 | 2.673 | 2.487 | 2.402 | 2.283 | 2.106 |
4 | 3.465 | 3.170 | 3.037 | 2.855 | 2.589 |
5 | 4.212 | 3.791 | 3.605 | 3.352 | 2.991 |
6 | 4.917 | 4.355 | 4.111 | 3.784 | 3.326 |
7 | 5.582 | 4.868 | 4.564 | 4.160 | 3.605 |
8 | 6.210 | 5.335 | 4.968 | 4.487 | 3.837 |
9 | 6.802 | 5.759 | 5.328 | 4.772 | 4.031 |
10 | 7.360 | 6.145 | 5.650 | 5.019 | 4.192 |
a. Determine a present value factor for an annuity of $1 which can be used in determining the internal rate of return. If required, round your answer to three decimal places.
b. Using the factor determined in part (a) and
the present value of an annuity of $1 table above, determine the
internal rate of return for the proposal.
%
1. Midwest Fabricators Inc. is considering an investment in equipment that will replace direct labor. The...
Spanish Peaks Railroad Inc. is considering acquiring equipment at a cost of $134,000. The equipment has an estimated life of 10 years and no residual value. It is expected to provide yearly net cash flows of $67,000. The company's minimum desired rate of return for net present value analysis is 15%. Present Value of an Annuity of $1 at Compound Interest Year 6% 10% 12% 15% 20% 1 0.943 0.909 0.893 0.870 0.833 2 1.833 1.736 1.690 1.626 1.528 3...
Average Rate of Return Method, Net Present Value Method, and Analysis The capital investment committee of Ellis Transport and Storage Inc. is considering two investment projects. The estimated income from operations and net cash flows from each investment are as follows: Warehouse Tracking Technology Year Income from Operations Net Cash Flow Income from Operations Net Cash Flow 1 $52,200 $161,000 $110,000 $258,000 2 52,200 161,000 84,000 217,000 3 52,200 161,000 42,000 153,000 4 52,200 161,000 18,000 105,000 5 52,200 161,000...
average rate of Return Method, Net Present Value Method, and Analysis The capital investment committee of Cross Continent Trucking Inc. is considering two capital investments. The estimated income from operations and net cash flows from each investment are as follows: Warehouse Tracking Technology Income from Net Cash Income from Year Net Cash Operations Flow Operations Flow $44,000 $143,000 $92,000 $229,000 44,000 143,000 70,000 193,000 44,000 143,000 35,000 136,000 44,000 143,000 15,000 93,000 44,000 143,000 8,000 64,000 Total $220.000 $715,000 $220.000...
The management of Advanced Alternative Power Inc. is considering two capital investment projects. The estimated net cash flows from each project are as follows: Year Wind Turbines Biofuel Equipment 1 $160,000 $340,000 2 160,000 340,000 3 160,000 340,000 4 160,000 340,000 The wind turbines require an investment of $485,920, while the biofuel equipment requires an investment of $970,700. No residual value is expected from either project. Present Value of an Annuity of $1 at Compound Interest Year 6% 10% 12%...
Average rates of Return Method, Net Present Value Method, and And The capital investment committee of Ellis Transport and Storage Inc. is considering two The estimated income from operations and net cash flows from each investment are as follows: Tracking Technology Year Income from Net Cash $251.000 wNw Warehouse Income from Net Cash Operations Flow $52,200 $157,000 52,200 157,000 52,200 157,000 52,200 157,000 52,200 157,000 $261,000 $785,000 34,000 212.000 149.00 42,000 18,000 7.000 Total 61,000 $785,000 Each project requires an...
TEXT VERSION: Average Rate of Return Method, Net Present Value Method, and Analysis The capital investment committee of Ellis Transport and Storage Inc. is considering two investment projects. The estimated income from operations and net cash flows from each investment are as follows: Warehouse Tracking Technology Year Income from Operations Net Cash Flow Income from Operations Net Cash Flow 1 $47,500 $152,000 $100,000 $243,000 2 47,500 152,000 76,000 205,000 3 47,500 152,000 38,000 144,000 4 47,500 152,000 17,000 99,000 5...
Midwest Fabricators Inc. is considering an investment in equipment that will replace direct labor. The equipment has a cost of $143,000 with a $12,000 residual value and a five-year life. The equipment will replace one employee who has an average wage of $51,715 per year. In addition, the equipment will have operating and energy costs of $13,890 per year. Determine the average rate of return on the equipment, giving effect to straight-line depreciation on the investment. If required, round to...
Midwest Fabricators Inc. is considering an investment in equipment that will replace direct labor. The equipment has a cost of $140,000 with a $12,000 residual value and a five-year life. The equipment will replace one employee who has an average wage of $43,730 per year. In addition, the equipment will have operating and energy costs of $13,570 per year. Determine the average rate of return on the equipment, giving effect to straight-line depreciation on the investment. If required, round to...
Midwest Fabricators Inc. is considering an investment in equipment that will replace direct labor. The equipment has a cost of $98,000 with a $8,000 residual value and a five-year life. The equipment will replace one employee who has an average wage of $32,840 per year. In addition, the equipment will have operating and energy costs of $9,540 per year. Determine the average rate of return on the equipment, giving effect to straight-line depreciation on the investment. If required, round to...
Average Rate of Return Method, Net Present Value Method, and Analysis The capital investment committee of Ellis Transport and Storage Inc. is considering two investment projects. The estimated income from operations and net cash flows from each investment are as follows: Warehouse Net Cash Tracking Technology Income from Net Cash Operations Flow Year Flow $326,000 275,000 Income from Operations $65,100 65,100 65,100 65,100 65,100 $325,500 194,000 $204,000 204,000 204,000 204,000 204,000 $1,020,000 $137,000 104,000 52,000 23,000 9,500 9,500 $325,500 133,000...