Question

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 $694,151 $468,140 $249,778
Annual net cash flows:
Year 1 316,000 234,000 136,000
Year 2 294,000 211,000 94,000
Year 3 269,000 187,000 68,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 12%, prepare a net present value analysis for each project. Use the present value of $1 table presented above in your computations. If the net present value is negative, enter a negative amount.

Product Line Expansion Distribution Facilities Computer Network
Present value of net cash flow total $ $ $
Amount to be invested
Net present value $ $ $

2. Determine a present value index for each proposal. Round your answers to two decimal places.

Present Value Index (Rounded)
Product Line Expansion
Distribution Facilities
Computer Network

Homework Answers

Answer #1

Present value of net cash flow total = [PVF 12%,1*CF1]+[PVF 12%,2*CF2]+[PVF 12%,3*CF3]

Product Line Expansion Distribution Facilities Computer Network
Present value of net cash flow total

[.893*316000]+[.797*294000]+[.712*269000].

282188+ 234318+ 191528

708034

[.893*234000]+[.797*211000]+[.712*187000]

208962+ 168167+ 133144

510273

[.893*136000]+[.797*94000]+[.712*68000]

121448+ 74918+ 48416

244782

Amount to be invested (694151) (468140) (249778)
NPV 13883 42133 -4996

B)Profitability index = Present value /Initial investment

Product Line Expansion 708034/694151=1.02
Distribution Facilities 510273/468140= 1.09
Computer Network 244782/249778= .98
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
United Bankshores, Inc. wishes to evaluate three capital investment proposals by using the net present value...
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 $532,596 $353,235 $210,792 Annual net cash flows: Year 1 311,000 208,000 146,000 Year 2 289,000 187,000 101,000 Year 3 264,000 166,000 73,000 Present Value of $1 at Compound Interest Year 6% 10% 12% 15% 20% 1 0.943 0.909 0.893 0.870...
United Bankshores, Inc. wishes to evaluate three capital investment proposals by using the net present value...
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 $1,111,121 $656,453 $354,891 Annual net cash flows: Year 1 425,000 315,000 183,000 Year 2 395,000 284,000 126,000 Year 3 361,000 252,000 92,000 Present Value of $1 at Compound Interest Year 6% 10% 12% 15% 20% 1 0.943 0.909 0.893 0.870...
Cash Payback Period, Net Present Value Method, and Analysis Elite Apparel Inc. is considering two investment...
Cash Payback Period, Net Present Value Method, and Analysis 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 $160,000 $133,000 2 130,000 157,000 3 113,000 107,000 4 102,000 75,000 5 32,000 65,000 Total $537,000 $537,000 Each project requires an investment of $290,000. A rate of 10% has been selected for the net present value analysis. Present Value of $1 at Compound Interest Year...
Average Rate of Return Method, Net Present Value Method, and Analysis The capital investment committee of...
Average Rate of Return Method, Net Present Value Method, and Analysis 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 $63,800 $205,000 $134,000 $328,000 2 63,800 205,000 102,000 277,000 3 63,800 205,000 51,000 195,000 4 63,800 205,000 22,000 133,000 5 63,800 205,000...
Average Rate of Return Method, Net Present Value Method, and Analysis The capital investment committee of...
Average Rate of Return Method, Net Present Value Method, and Analysis 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 $55,000 $173,000 $116,000 $277,000 2 55,000 173,000 88,000 234,000 3 55,000 173,000 44,000 164,000 4 55,000 173,000 19,000 112,000 5 55,000 173,000...
Average Rate of Return Method, Net Present Value Method, and Analysis The capital investment committee of...
Average Rate of Return Method, Net Present Value Method, and Analysis 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 $55,000 $178,000 $116,000 $285,000 2 55,000 178,000 88,000 240,000 3 55,000 178,000 44,000 169,000 4 55,000 178,000 19,000 116,000 5 55,000 178,000...
APPLY THE CONCEPTS: Net present value and Present value index Underwood Inc. is looking to invest...
APPLY THE CONCEPTS: Net present value and Present value index Underwood Inc. is looking to invest in Project A or Project B. The data surrounding each project is provided below. Underwood's cost of capital is 11%. Project A Project B This project requires an initial investment of $172,500. The project will have a life of 6 years. Annual revenues associated with the project will be $130,000 and expenses associated with the project will be $35,000. This project requires an initial...
APPLY THE CONCEPTS: Net present value and Present value index Sutherland Inc. is looking to invest...
APPLY THE CONCEPTS: Net present value and Present value index Sutherland Inc. is looking to invest in Project A or Project B. The data surrounding each project is provided below. Sutherland's cost of capital is 10%. Project A Project B This project requires an initial investment of $172,500. The project will have a life of 3 years. Annual revenues associated with the project will be $130,000 and expenses associated with the project will be $35,000. This project requires an initial...
Average Rate of Return Method, Net Present Value Method, and Analysis for a service company The...
Average Rate of Return Method, Net Present Value Method, and Analysis for a service company The capital investment committee of Arches Landscaping Company is considering two capital investments. The estimated operating income and net cash flows from each investment are as follows: Front-End Loader Greenhouse Year Operating Income Net Cash Flow Operating Income Net Cash Flow 1 $39,600 $124,000 $83,000 $198,000 2 39,600 124,000 63,000 167,000 3 39,600 124,000 32,000 118,000 4 39,600 124,000 14,000 81,000 5 39,600 124,000 6,000...
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 f two machines. The sewing machine will increase productivity from sewing 130 baseballs per hour to sewing 234 per hour. The contribution margin per unit is $0.42 per basebal. Assume that any increase 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
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT