Question

In: Accounting

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

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 $580,000. The estimated net cash flows from each project are as follows: Net Cash Flow Year Office Expansion Server Upgrade 1 $162,000 $214,000 2 162,000 214,000 3 162,000 214,000 4 162,000 214,000 5 162,000 6 162,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 $203,000.

Present Value of $1 at Compound Interest
Year 6% 10% 12% 15% 20%
1 0.9434 0.9091 0.8929 0.8696 0.8333
2 0.8900 0.8265 0.7972 0.7561 0.6944
3 0.8396 0.7513 0.7118 0.6575 0.5787
4 0.7921 0.6830 0.6355 0.5718 0.4823
5 0.7473 0.6209 0.5674 0.4972 0.4019
6 0.7050 0.5645 0.5066 0.4323 0.3349
7 0.6651 0.5132 0.4523 0.3759 0.2791
8 0.6274 0.4665 0.4039 0.3269 0.2326
9 0.5919 0.4241 0.3606 0.2843 0.1938
10 0.5584 0.3855 0.3220 0.2472 0.1615
Present Value of an Annuity of $1 at Compound Interest
Year 6% 10% 12% 15% 20%
1 0.9434 0.9091 0.8929 0.8696 0.8333
2 1.8334 1.7355 1.6901 1.6257 1.5278
3 2.6730 2.4868 2.4018 2.2832 2.1065
4 3.4651 3.1699 3.0374 2.8550 2.5887
5 4.2124 3.7908 3.6048 3.3522 2.9906
6 4.9173 4.3553 4.1114 3.7845 3.3255
7 5.5824 4.8684 4.5638 4.1604 3.6046
8 6.2098 5.3349 4.9676 4.4873 3.8372
9 6.8017 5.7590 5.3283 4.7716 4.0301
10 7.3601 6.1446 5.6502 5.0188 4.1923

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. Note: Round final answers to the nearest whole dollar. 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. Check My Work

Solutions

Expert Solution

Solution 1):

Calculation of Net present Value of Office Expansion

Initial Investment = $580,000

Year

Net Cash Inflows $

Present Value Factor @ 15%

Present Value of Net Cash Inflows $

1

1,62,000.00

0.869565

1,40,869.57

2

1,62,000.00

0.756144

1,22,495.27

3

1,62,000.00

0.657516

1,06,517.63

4

1,62,000.00

0.571753

92,624.03

5

1,62,000.00

0.497177

80,542.63

6

1,62,000.00

0.432328

70,037.07

Total Value of Net Cash Inflows

6,13,086.20

Net present Value of Office Expansion = Total Value of Net Cash Inflows – Initial Investment

                                                                          = $613,086.20 - $580,000

                                                                          = $33,086.20

Calculation of Net present Value of Server Upgrade

Initial Investment = $580,000

Year

Net Cash Inflows $

Present Value Factor @ 15%

Present Value of Net Cash Inflows $

1

2,14,000.00

0.869565

1,86,086.96

2

2,14,000.00

0.756144

1,61,814.74

3

2,14,000.00

0.657516

1,40,708.47

4

2,14,000.00

0.571753

1,22,355.19

Total Value of Net Cash Inflows

6,10,965.37

Net present Value of Server Upgrade = Total Value of Net Cash Inflows – Initial Investment

                                                                          = $610,965.37 - $580,000

                                                                          = $30,965.37

Office Expansion

Server Upgrade

Initial Investment $

                5,80,000.00

                        5,80,000.00

Duration (Years)

6

4

NPV $

33,086.20

30,965.37

Om comparing the NPV of the two proposals, the company should go for Office Expansion as it has a higher NPV.

Solution 2) Calculation of NPV of Office Expansion after adjusting the duration of the project to 4 years

Year

Net Cash Inflows $

Present Value Factor @ 15%

Present Value of Net Cash Inflows $

1

1,62,000.00

0.869565

1,40,869.57

2

1,62,000.00

0.756144

1,22,495.27

3

1,62,000.00

0.657516

1,06,517.63

4

3,65,000.00

0.571753

2,08,689.93

Total Value of Net Cash Inflows

5,78,572.40

Note: The Cash Inflows for the fourth year also includes the Scrap value $203,000

Net present Value of Office Expansion after adjusting duration to 4 years

= Total Value of Net Cash Inflows – Initial Investment

= $5,78,572.40 - $580,000

= -$1427.60

Office Expansion

Server Upgrade

Initial Investment $

                5,80,000.00

                        5,80,000.00

Duration (Years)

4

4

NPV $

-1,427.60

30,965.37

If the Duration of the Office Expansion is adjusted to 4 years, then the company should go for Server Upgrade as the Net Present Value of Office Expansion is negative.


Related Solutions

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 $1,117,000. The estimated net cash flows from each project are as follows: Net Cash Flow Year      Office Expansion      Server 1 $312,000 $412,000 2 312,000 412,000 3 312,000 412,000 4 312,000 412,000 5 312,000 6 312,000 The committee has selected a rate of 15% for purposes of net present...
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 $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...
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 $49,300 $162,000 $104,000 $259,000 2 49,300 162,000 79,000 219,000 3 49,300 162,000 39,000 154,000 4 49,300 162,000 17,000 105,000 5 49,300 162,000 7,500 73,000 Total $246,500 $810,000 $246,500 $810,000 Each project requires an...
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 $50,400 $164,000 $106,000 $262,000 2 50,400 164,000 81,000 221,000 3 50,400 164,000 40,000 156,000 4 50,400 164,000 18,000 107,000 5 50,400 164,000 7,000 74,000 Total $252,000 $820,000 $252,000 $820,000 Each project requires an...
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 $44,000 $138,000 $92,000 $221,000 2 44,000 138,000 70,000 186,000 3 44,000 138,000 35,000 131,000 4 44,000 138,000 15,000 90,000 5 44,000 138,000 8,000 62,000 Total $220,000 $690,000 $220,000 $690,000 Each project requires an...
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 $36,100 $115,000 $76,000 $184,000 2 36,100 115,000 58,000 155,000 3 36,100 115,000 29,000 109,000 4 36,100 115,000 13,000 75,000 5 36,100 115,000 4,500 52,000 Total $180,500 $575,000 $180,500 $575,000 Each project requires an...
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...
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 $37,800 $120,000 $79,000 $192,000 2 37,800 120,000 60,000 162,000 3 37,800 120,000 30,000 114,000 4 37,800 120,000 13,000 78,000 5 37,800 120,000 7,000 54,000 Total $189,000 $600,000 $189,000 $600,000 Each project requires an...
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 $47,500 $147,000 $100,000 $235,000 2 47,500 147,000 76,000 198,000 3 47,500 147,000 38,000 140,000 4 47,500 147,000 17,000 96,000 5 47,500 147,000 6,500 66,000 Total $237,500 $735,000 $237,500 $735,000 Each project requires an...
t he capital investment committee of Ellis Transport and Storage Inc. is considering two investment projects....
t he 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 $44,000 $137,000 $92,000 $219,000 2 44,000 137,000 70,000 185,000 3 44,000 137,000 35,000 130,000 4 44,000 137,000 15,000 89,000 5 44,000 137,000 8,000 62,000 Total $220,000 $685,000 $220,000 $685,000 Each project requires...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT