Question

The investment committee of Sentry Insurance Co. is evaluating two projects, office expansion and upgrade to...

The investment committee of Sentry Insurance Co. is evaluating two projects, office expansion and upgrade to computer servers. The projects have different useful lives, but each requires an investment of $490,000. The estimated net cash flows from each project are as follows:

Net Cash Flows
Year Office Expansion Servers
1 $125,000 $165,000
2   125,000   165,000
3   125,000   165,000
4   125,000   165,000
5   125,000
6   125,000

The committee has selected a rate of 12% for purposes of net present value analysis. It also estimates that the residual value at the end of each project's useful life is $0, but at the end of the fourth year, the office expansion's residual value would be $180,000.

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
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.353 2.991
6 4.917 4.355 4.111 3.785 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

Required:

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 server upgrade has a higher net present value and would be a superior investment.

Homework Answers

Answer #1

1.

Office Expansion Server Upgrade
Present value of annual net cash flows $125000*4.111 = $513875 $165000*3.037 = $501105
Amount to be invested 490000 490000
Net present value $23875 $11105

2.

Office Expansion Server Upgrade
Present value of net cash flow total $125000*3.037+180000*0.636 = $494105 $165000*3.037 = $501105
Amount to be invested 490000 490000
Net present value $4105 $11105

3. The net present value of the two projects over equal lives indicates that the Server Upgrade has a higher net present value and would be a superior investment.

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Alternative Capital Investments The investment committee of Sentry Insurance Co. is evaluating two projects, office expansion...
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 lives, but each requires an investment of $1,476,000. The estimated net cash flows from each project are as follows: Net Cash Flow Year      Office Expansion      Server 1 $371,000 $490,000 2 371,000 490,000 3 371,000 490,000 4 371,000 490,000 5 371,000 6 371,000 The committee has selected a rate of 10% for purposes...
Alternative Capital Investments The investment committee of Sentry Insurance Co. is evaluating two projects, office expansion...
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 lives, but each requires an investment of $629,000. The estimated net cash flows from each project are as follows: Net Cash Flow Year      Office Expansion      Server 1 $176,000 $232,000 2 176,000 232,000 3 176,000 232,000 4 176,000 232,000 5 176,000 6 176,000 The committee has selected a rate of 15% for purposes...
Alternative Capital Investments The investment committee of Shield Insurance Co. is evaluating two projects, office expansion...
Alternative Capital Investments The investment committee of Shield Insurance Co. is evaluating two projects, office expansion and upgrade to computer servers. The projects have different useful lives, but each requires an investment of $1,406,000. The estimated net cash flows from each project are as follows: Net Cash Flow Year      Office Expansion      Server Upgrade 1 $354,000 $467,000 2 354,000 467,000 3 354,000 467,000 4 354,000 467,000 5 354,000 6 354,000 The committee has selected a rate of 10% for...
Alternative Capital Investments The investment committee of Auntie M's Restaurants Inc. is evaluating two restaurant sites....
Alternative Capital Investments The investment committee of Auntie M's Restaurants Inc. is evaluating two restaurant sites. The sites have different useful lives, but each requires an investment of $900,000. The estimated net cash flows from each site are as follows: Net Cash Flows Year Wichita Topeka 1 $310,000 $400,000 2   310,000   400,000 3   310,000   400,000 4   310,000   400,000 5   310,000 6   310,000 The committee has selected a rate of 20% for purposes of net present value analysis. It also estimates...
The capital investment committee of Ellis Transport and Storage Inc. is considering two investment projects. The...
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,400 $135,000 $ 34,400 $108,000 2    51,400   125,000    34,400   108,000 3    36,400   110,000    34,400   108,000 4    26,400   100,000    34,400   108,000 5    (3,600)    70,000    34,400   108,000 Total $172,000 $540,000 $172,000 $540,000 Each project...
Elite Apparel Inc. is considering two investment projects. The estimated net cash flows from each project...
Elite Apparel Inc. is considering two investment projects. The estimated net cash flows from each project are as follows: Year Plant Expansion Retail Store Expansion 1 $130,000 $109,000 2 107,000 128,000 3 92,000 88,000 4 83,000 61,000 5 26,000 52,000 Total $438,000 $438,000 Each project requires an investment of $237,000. A rate of 20% has been selected for 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...
Elite Apparel Inc. is considering two investment projects. The estimated net cash flows from each project...
Elite Apparel Inc. is considering two investment projects. The estimated net cash flows from each project are as follows: Year Plant Expansion Retail Store Expansion 1 $118,000 $98,000 2 96,000 116,000 3 83,000 79,000 4 75,000 55,000 5 24,000 48,000 Total $396,000 $396,000 Each project requires an investment of $214,000. A rate of 20% has been selected for 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...
Net Present Value—Unequal Lives Project 1 requires an original investment of $76,700. The project will yield...
Net Present Value—Unequal Lives Project 1 requires an original investment of $76,700. The project will yield cash flows of $12,000 per year for seven years. Project 2 has a calculated net present value of $16,500 over a five-year life. Project 1 could be sold at the end of five years for a price of $56,000. Use the Present Value of $1 at Compound Interest and the Present Value of an Annuity of $1 at Compound Interest tables shown below. Present...
Net Present Value—Unequal Lives Project 1 requires an original investment of $54,000. The project will yield...
Net Present Value—Unequal Lives Project 1 requires an original investment of $54,000. The project will yield cash flows of $10,000 per year for eight years. Project 2 has a calculated net present value of $10,800 over a six-year life. Project 1 could be sold at the end of six years for a price of $41,000. Use the Present Value of $1 at Compound Interest and the Present Value of an Annuity of $1 at Compound Interest tables shown below. Present...
Net Present Value—Unequal Lives Project 1 requires an original investment of $40,500. The project will yield...
Net Present Value—Unequal Lives Project 1 requires an original investment of $40,500. The project will yield cash flows of $9,000 per year for seven years. Project 2 has a calculated net present value of $8,300 over a five-year life. Project 1 could be sold at the end of five years for a price of $40,000. Use the Present Value of $1 at Compound Interest and the Present Value of an Annuity of $1 at Compound Interest tables shown below. Present...