Average rate of Return Method, Net Present Value Method, and analysis for a Service Company 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 Year Income from Operations Net Cash Flow 1 $ 61,400 51,400 2 Tracking Technology Net Income from Cash Operations Flow $ 34,400 $100,000 34,400 108,000 34,400 108,000 34,400 108,000 34,400 108,000 $172,000 $540,000 3 $135,000 125,000 110,000 100,000 70,000 36,400 26,400 (3,600) $172,000 4 5 Total $540,000 159 for Each project requires an investment of $368,000. Straight-line depreciation will be used, and no residual value is expected. The committee has selected a rate purposes of the net present value analysis. Year Present Value of $1 at Compound Interest 6% 10% 12% 15% 20% 0.943 0.909 0.893 0.870 0.833 1 2 0.890 0.826 0.797 0.756 0.694 3 0.840 0.751 0.658 0.579 0.712 0.636 4 0.792 0.572 0.482 0.683 0.621 5 0.402 0.747 0.567 0.497 0.432 6 0.705 0.564 0.507 0.335 0.279 7 0.665 0.513 0.452 0.376 3 0.751 0.712 0.658 0.579 0.840 0.792 4 0.683 0.636 0.572 0.482 5 0.747 0.621 0.497 6 0.705 0.564 0.335 0.452 0.376 0.279 0.622 0.467 0,404 9 0.592 10 0.247 0.567 0.402 0.507 0.432 7 0.665 0.513 8 0.327 0.233 0.424 0.361 0.284 0.194 0.558 0.386 0.322 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 15 X % Tracking Technology 150,000 X % 1b. Compute the net present value for each Investment. Use the present value of $1 table above. It required, use the minun sign to indicate a negative net present value If required, round to the nearest dollar Warehouse Tracking Technology Present value of net cash flow total Amount to be invested - doc Net present value 2. The warehouse net present value exceeds the selected rate established for discounted cash flows (15%), while the tracking technology not. Thus, considering only quantitative factors, the warehouse Investment should be selected