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 $838,000. The estimated net cash flows from each project are as follows:   Net Cash Flow Year     Office Expansion     Server 1 $234,000       $309,000       2 234,000       309,000       3 234,000       309,000       4 234,000       309,000       5 234,000               6 234,000               The committee has selected a rate of 15% 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 $293,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.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 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 $ ? $ ?

Principles of Accounting Volume 2
19th Edition
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax
Chapter11: Capital Budgeting Decisions
Section: Chapter Questions
Problem 7PA: There are two projects under consideration by the Rainbow factory. Each of the projects will require...
icon
Related questions
Question

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 $838,000. The estimated net cash flows from each project are as follows:

  Net Cash Flow
Year     Office Expansion     Server
1 $234,000       $309,000      
2 234,000       309,000      
3 234,000       309,000      
4 234,000       309,000      
5 234,000              
6 234,000              

The committee has selected a rate of 15% 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 $293,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.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

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 $ ? $ ?
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Knowledge Booster
Capital Budgeting
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Principles of Accounting Volume 2
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College