Question

In: Accounting

Net Present Value Method, Present Value Index, and Analysis United Bankshores, Inc. wishes to evaluate three...

Net Present Value Method, Present Value Index, and Analysis United Bankshores, Inc. wishes to evaluate three capital investment proposals by using the net present value method. Relevant data related to the proposals are summarized as follows: Branch Office Expansion Computer System Upgrade Install Internet Bill-Pay Amount to be invested $713,368 $471,275 $236,700 Annual net cash flows: Year 1 344,000 248,000 155,000 Year 2 320,000 223,000 107,000 Year 3 292,000 198,000 78,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 Required: 1. Assuming that the desired rate of return is 20%, prepare a net present value analysis for each proposal. Use the present value of $1 table above. If required, use the minus sign to indicate a negative net present value. If required, round to the nearest dollar. Branch Office Expansion Computer System Upgrade Install Internet Bill-Pay Present value of net cash flow total $ $ $ Amount to be invested $ $ $ Net present value $ $ $ 2. Determine a present value index for each proposal. If required, round your answers to two decimal places. Present Value Index Branch Office Expansion Computer System Upgrade Install Internet Bill-Pay 3. Which proposal offers the largest amount of present value per dollar of investment?

Solutions

Expert Solution

Required: 1. Assuming that the desired rate of return is 20%, prepare a net present value analysis for each proposal.

Year

Discounting @20%

Branch Office Expansion

Computer system upgrade

Install internet

Cash
Flow

NPV

Cash
Flow

NPV

Cash
Flow

NPV

(A)

(B)

(C=A*B)

D

E=A*D

F

G=A*F

1

0.833

344000

286552

248000

206584

155000

129115

2

0.694

320000

222080

223000

154762

107000

74258

3

0.579

292000

169068

198000

114642

78000

45162

Total

956000

677700

669000

475988

340000

248535

Net Present Value Analysis:

Branch Office Expansion

Computer system upgrade

Install internet

Present value of net cash flow total (A)

677700

475988

248535

Less amount to be invested(B)

713368

471275

236700

Net present value(A-B)

-35668

4713

11835

Branch Office Expansion

Computer system upgrade

Install internet

Net present value

-35668

4713

11835

______________________________________________________________________

2. Determine a present value index for each proposal.

Present value index (PVI)

= sum of present value of future cash flows/initial outlay

=677700/713368

=0.95

PVI of branch office expansion project

=475988/471275

=1.01

PVI of install internet

=248535 /236700

=1.05

Branch Office Expansion

Computer system upgrade

Install internet

Present value Index

0.95

1.01

1.05

______________________________________________________________

3. Which proposal offers the largest amount of present value per dollar of investment?

Install internet offers the largest amount of present value per dollar of investment


Related Solutions

Net Present Value Method, Present Value Index, and Analysis United Bankshores, Inc. wishes to evaluate three...
Net Present Value Method, Present Value Index, and Analysis United Bankshores, Inc. wishes to evaluate three capital investment proposals by using the net present value method. Relevant data related to the proposals are summarized as follows: Branch Office Expansion Computer System Upgrade Install Internet Bill-Pay Amount to be invested $575,292 $377,600 $191,050 Annual net cash flows: Year 1 286,000 200,000 123,000 Year 2 266,000 180,000 85,000 Year 3 243,000 160,000 62,000 Present Value of $1 at Compound Interest Year 6%...
Net Present Value Method, Present Value Index, and Analysis United Bankshores, Inc. wishes to evaluate three...
Net Present Value Method, Present Value Index, and Analysis United Bankshores, Inc. wishes to evaluate three capital investment proposals by using the net present value method. Relevant data related to the proposals are summarized as follows: Branch Office Expansion Computer System Upgrade Install Internet Bill-Pay Amount to be invested $837,326 $465,641 $258,271 Annual net cash flows: Year 1 320,000 218,000 141,000 Year 2 298,000 196,000 97,000 Year 3 272,000 174,000 71,000 Present Value of $1 at Compound Interest Year 6%...
Net Present Value Method, Present Value Index, and Analysis Donahue Industries Inc. wishes to evaluate three...
Net Present Value Method, Present Value Index, and Analysis Donahue Industries Inc. wishes to evaluate three capital investment projects by using the net present value method. Relevant data related to the projects are summarized as follows: Product Line Expansion Distribution Facilities Computer Network Amount to be invested $735,596 $447,586 $274,176 Annual net cash flows: Year 1 362,000 250,000 156,000 Year 2 337,000 225,000 108,000 Year 3 308,000 200,000 78,000 Present Value of $1 at Compound Interest Year 6% 10% 12%...
Net Present Value Method, Present Value Index, and Analysis Donahue Industries Inc. wishes to evaluate three...
Net Present Value Method, Present Value Index, and Analysis Donahue Industries Inc. wishes to evaluate three capital investment projects by using the net present value method. Relevant data related to the projects are summarized as follows: Product Line Expansion Distribution Facilities Computer Network Amount to be invested $568,347 $365,363 $216,394 Annual net cash flows: Year 1 280,000 190,000 123,000 Year 2 260,000 171,000 85,000 Year 3 238,000 152,000 62,000 Present Value of $1 at Compound Interest Year 6% 10% 12%...
Net Present Value Method, Present Value Index, and Analysis Donahue Industries Inc. wishes to evaluate three...
Net Present Value Method, Present Value Index, and Analysis Donahue Industries Inc. wishes to evaluate three capital investment projects by using the net present value method. Relevant data related to the projects are summarized as follows: Product Line Expansion Distribution Facilities Computer Network Amount to be invested $783,240 $531,394 $308,533 Annual net cash flows: Year 1 382,000 279,000 172,000 Year 2 355,000 251,000 119,000 Year 3 325,000 223,000 86,000 Present Value of $1 at Compound Interest Year 6% 10% 12%...
Net Present Value Method, Present Value Index, and Analysis Donahue Industries Inc. wishes to evaluate three...
Net Present Value Method, Present Value Index, and Analysis Donahue Industries Inc. wishes to evaluate three capital investment projects by using the net present value method. Relevant data related to the projects are summarized as follows: Product Line Expansion Distribution Facilities Computer Network Amount to be invested $733,787 $514,437 $260,321 Annual net cash flows: Year 1 365,000 270,000 150,000 Year 2 339,000 243,000 103,000 Year 3 310,000 216,000 75,000 Present Value of $1 at Compound Interest Year 6% 10% 12%...
Net Present Value Method, Present Value Index, and Analysis First United Bank Inc. is evaluating three...
Net Present Value Method, Present Value Index, and Analysis First United Bank Inc. is evaluating three capital investment projects using the net present value method. Relevant data related to the projects are summarized as follows: Branch Office Expansion Computer System Upgrade ATM Kiosk Expansion Amount to be invested $601,461 $411,359 $216,033 Annual net cash flows: Year 1 317,000 219,000 133,000 Year 2 295,000 197,000 92,000 Year 3 269,000 175,000 67,000 Present Value of $1 at Compound Interest Year 6% 10%...
Donahue Industries Inc. wishes to evaluate three capital investment projects by using the net present value...
Donahue Industries Inc. wishes to evaluate three capital investment projects by using the net present value method. Relevant data related to the projects are summarized as follows: Product Line Expansion Distribution Facilities Computer Network Amount to be invested $790,052 $535,506 $310,018 Annual net cash flows: Year 1 413,000 301,000 186,000 Year 2 384,000 271,000 128,000 Year 3 351,000 241,000 93,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...
Net Present Value Method and Present Value Index Diamond and Turf Inc. is considering an investment...
Net Present Value Method and Present Value Index Diamond and Turf Inc. is considering an investment in one of two machines. The sewing machine will increase productivity from sewing 150 baseballs per hour to sewing 270 per hour. The contribution margin per unit is $0.42 per baseball. Assume that any increased production of baseballs can be sold. The second machine is an automatic packing machine for the golf ball line. The packing machine will reduce packing labor cost. The labor...
Net Present Value Method and Present Value Index Diamond and Turf Inc. is considering an investment...
Net Present Value Method and Present Value Index Diamond and Turf Inc. is considering an investment in one of two machines. The sewing machine will increase productivity from sewing 180 baseballs per hour to sewing 324 per hour. The contribution margin per unit is $0.46 per baseball. Assume that any increased production of baseballs can be sold. The second machine is an automatic packing machine for the golf ball line. The packing machine will reduce packing labor cost. The labor...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT