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 | $4,000,000 | $2,500,000 | $500,000 | ||||
Annual net cash flows: | |||||||
Year 1 | 4,200,000 | 1,000,000 | 600,000 | ||||
Year 2 | 3,600,000 | 1,200,000 | 600,000 | ||||
Year 3 | 3,000,000 | 1,300,000 | 550,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 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 project. Round your answers to two decimal places.
Present Value Index (Rounded) | |
Product Line Expansion | |
Distribution Facilities | |
Computer Network |
Calculation of present value of cash flow | |||||
Product line expansion | |||||
years | Cash flow | PVF @20% | Present value of cash flow | ||
1 | 4200000 | 0.833 | 3498600 | ||
2 | 3600000 | 0.694 | 2498400 | ||
3 | 3000000 | 0.579 | 1737000 | ||
total present value | 7734000 | ||||
Distribution facilities | |||||
years | Cash flow | PVF @20% | Present value of cash flow | ||
1 | 1000000 | 0.833 | 833000 | ||
2 | 1200000 | 0.694 | 832800 | ||
3 | 1300000 | 0.579 | 752700 | ||
total present value | 2418500 | ||||
Computer network | |||||
years | Cash flow | PVF @20% | Present value of cash flow | ||
1 | 600000 | 0.833 | 499800 | ||
2 | 600000 | 0.694 | 416400 | ||
3 | 550000 | 0.579 | 318450 | ||
total present value | 1234650 | ||||
Net present value analysis | |||||
Product line expansion | Distribution facilities | Computer network | |||
present value of net cash flow total | 7734000 | 2418500 | 1234650 | ||
amount to be invested | -4000000 | -2500000 | -500000 | ||
Net present value | 3734000 | -81500 | 734650 | ||
2) present value index = present value of cash flow/amount to be invested | |||||
present value index (rounded) | |||||
Production line expansion | 7734000/4000000 = 2.47 | ||||
Distribution facilities | 2418500/2500000 = 0.97 | ||||
Computer network | 1234650/500000 = 2.47 |
Please give a thumbs up if it is helpful & let me know if any doubt
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 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 $754,749 $499,898 $249,409 Annual net cash flows: Year 1 316,000 224,000 149,000 Year 2 294,000 202,000 103,000 Year 3 269,000 179,000 75,000 Present Value of $1 at Compound Interest Year 6% 10%...
Net Present Value Method, Present Value Index, and Analysis for a service company Continental Railroad Company is evaluating three capital investment proposals by using the net present value method. Relevant data related to the proposals are summarized as follows: Maintenance Equipment Ramp Facilities Computer Network Amount to be invested $790,276 $544,897 $263,378 Annual net cash flows: Year 1 405,000 292,000 186,000 Year 2 377,000 263,000 128,000 Year 3 344,000 234,000 93,000 Present Value of $1 at Compound Interest Year 6%...
Net Present Value Method, Present Value Index, and Analysis for a service company Continental Railroad Company is evaluating three capital investment proposals by using the net present value method. Relevant data related to the proposals are summarized as follows: Maintenance Equipment Ramp Facilities Computer Network Amount to be invested $568,602 $336,893 $171,869 Annual net cash flows: Year 1 277,000 186,000 119,000 Year 2 258,000 167,000 82,000 Year 3 235,000 149,000 60,000 Present Value of $1 at Compound Interest Year 6%...
Net Present Value Method, An index computed by dividing the total present value of the net cash flow to be received from a proposed capital investment by the amount to be invested.Present Value Index, and Analysis for a service company Continental Railroad Company is evaluating three capital investment proposals by using the net present value method. Relevant data related to the proposals are summarized as follows: Maintenance Equipment Ramp Facilities Computer Network Amount to be invested $584,896 $335,577 $171,714 Annual...
Net Present Value Method, Present Value Index, and Analysis for a service company Continental Railroad Company is evaluating three capital investment proposals by using the net present value method. Relevant data related to the proposals are summarized as follows: Maintenance Equipment Ramp Facilities Computer Network Amount to be invested $890,159 $542,860 $263,813 Annual net cash flows: Year 1 369,000 258,000 159,000 Year 2 343,000 232,000 110,000 Year 3 314,000 206,000 80,000 Present Value of $1 at Compound Interest Year 6%...
Net Present Value Method, Present Value Index, and Analysis for a service company Continental Railroad Company is evaluating three capital investment proposals by using the net present value method. Relevant data related to the proposals are summarized as follows: Maintenance Ramp Computer Equipment Facilities Network Amount to be invested $1,068,881 $673,825 $337,950 Annual net cash flows: 443,000 Year 1 323,000 204,000 141,000 Year 2 412,000 291,000 Year 3 377,000 258,000 102,000 Present Value of $1 at Compound Interest Year 6%...
Net Present Value Method, Present Value Index, and Analysis for a service company Continental Railroad Company is evaluating three capital investment proposals by using the net present value method. Relevant data related to the proposals are summarized as follows: Maintenance Equipment Ramp Facilities Computer Network Amount to be invested $797,601 $545,351 $237,855 Annual net cash flows: Year 1 363,000 265,000 152,000 Year 2 338,000 239,000 105,000 Year 3 309,000 212,000 76,000 Present Value of $1 at Compound Interest Year 6%...
Net Present Value Method, Present Value Index, and Analysis for a service company Continental Railroad Company is evaluating three capital investment proposals by using the net present value method. Relevant data related to the proposals are summarized as follows: Maintenance Ramp Facilities Computer Network Equipment Amount to be invested $912,141 $576,731 $259,018 Annual net cash flows: Year 1 391,000 160,000 Year 2 278,000 250,000 222,000 364,000 332,000 110,000 Year 3 80,000 Present Value of $1 at Compound Interest Year 6%...
Net Present Value Method, Present Value Index, and Analysis for a service company Continental Railroad Company is evaluating three capital investment proposals by using the net present value method. Relevant data related to the proposals are summarized as follows: Maintenance Equipment Ramp Facilities Computer Network Amount to be invested $638,832 $414,645 $209,562 Annual net cash flows: Year 1 288,000 Year 2 268,000 196,000 176,000 157,000 135,000 93,000 68,000 Year 3 245,000 Present Value of $1 at Compound Interest 6% 10%...