Alternative Capital Investments The Investment committee of Sentry Insurance Co is evaluating two projects, office expansion and upgrade to computer servers. The projects have different useful, but each requires an investment of $1,163,000. The estimated set ash flows from each project are as follows: Net Cash Flow Year Office Expansion Server 1 $305,000 $403,000 2 305,000 403,000 3 305,000 403,000 4 305,000 403,000 5 305,000 6 305.000 The committee has selected a rate of 125 for purposes of not present value analysis. It also estimates that the residual value at the end of each project's see is so, but the end of the fourth year, the office's residual value would be $381,000. Present Value of $1 at Compound Interest Year 109 20% 2 0.943 0.900 0.893 0.870 0.833 0.590 0.82 0.797 0.756 0.694 3 0.540 0.751 0.712 0.579 4 0.792 0.680 0.656 0.572 0.452 5 0.747 0.621 0.567 0.49 0.002 6 0.705 0.564 0.507 0.432 0.375 0.335 0.279 0.665 0.513 0.452 B 0.627 0.467 0.404 0.327 0.233 9 0.592 0.424 0.361 0.254 0.194 10 0.356 0.322 0.26 Present Value of an Annuity of $1 at Compound Interest Year 101 204 0.043 0.909 0.893 0.870 0.83 2 1.833 1.736 1.600 1.626 1.528 3 2.623 2.487 2.402 2.280 2.100 4 3.465 3.170 3,032 2.855 2.500 4.212 3.791 3.605 3.352 2.091 6 4.917 4.355 4.111 3.784 3.320 7 5.582 4.868 4.564 3.505 6.210 5.335 . 6.802 5.750 5.1 4.772 4.031 10 7.360 6.145 5.650 5.019 4.192 Required: If required, use the minus sign to indicate a negative net present value 1. For each project, compute the net present value. Use the present value of an annuity of $1 table above. Ignore the unequal lives of the projects. If required, round to the nearest dollar office Expansion Server Upgrade Present value of annual net cash flows Less amount to be invested Net present value 2. For each project compute the net present value, assuming that the office expansion is adjusted to a four-year life for purposes of analysis. Use the present value of $1 table above. Office Expansion Server Upgrade Present value of net cash flow total Less amount to be invested Net present value 3. The net present value of the two projects over equal lives indicates that the has a higher net present value and would be a superior investment