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 | $138,000 | $115,000 | ||
2 | 113,000 | 136,000 | ||
3 | 97,000 | 93,000 | ||
4 | 88,000 | 65,000 | ||
5 | 28,000 | 55,000 | ||
Total | $464,000 | $464,000 |
Each project requires an investment of $251,000. A rate of 12% has been selected for the net present value analysis.
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:
1a. Compute the cash payback period for each project.
Cash Payback Period | |
Plant Expansion | |
Retail Store Expansion |
1b. Compute the net present value. Use the present value of $1 table above. If required, round to the nearest dollar.
Plant Expansion | Retail Store Expansion | |
Present value of net cash flow total | $ | $ |
Less amount to be invested | $ | $ |
Net present value | $ | $ |
2. Because of the timing of the receipt of the net cash flows, the offers a higher
1a | ||||||
Cash Payback Period | ||||||
Plant Expansion | 2 years | =2 (138000+113000) | ||||
Retail Store Expansion | 2 years | =2 (115000+136000) | ||||
1b | ||||||
Plant Expansion | Retail Store Expansion | |||||
Present value of net cash flow total | 354203 | 349828 | ||||
Less amount to be invested | 251000 | 251000 | ||||
Net present value | 103203 | 98828 | ||||
2 | ||||||
Because of the timing of the receipt of the net cash flows, the Plant Expansion offers a higher Net present value | ||||||
Workings: | ||||||
Plant Expansion | Retail Store Expansion | |||||
Cash flows | PV factor 12% | Present value | Cash flows | PV factor 12% | Present value | |
1 | 138000 | 0.893 | 123234 | 115000 | 0.893 | 102695 |
2 | 113000 | 0.797 | 90061 | 136000 | 0.797 | 108392 |
3 | 97000 | 0.712 | 69064 | 93000 | 0.712 | 66216 |
4 | 88000 | 0.636 | 55968 | 65000 | 0.636 | 41340 |
5 | 28000 | 0.567 | 15876 | 55000 | 0.567 | 31185 |
Total | 354203 | Total | 349828 |
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 Retail Store Expansion Plant Expansion $153,000 126,000 $128,000 151,000 108,000 103,000 98,000 72,000 31,000 62,000 Total $516,000 $516,000 Each project requires an investment of $279,000. A rate of 10% has been selected for the net present value analysis. Year 1 Present Value of $1 at Compound Interest 6% 10% 12% 15%...
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 $129,000 $108,000 2 105,000 126,000 3 91,000 87,000 4 82,000 61,000 5 26,000 51,000 Total $433,000 $433,000 Each project requires an investment of $234,000. A rate of 20% has been selected for the net present value analysis. Present Value of $1 at Compound Interest Year...
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 $173,000 $145,000 2 142,000 170,000 3 122,000 117,000 4 111,000 82,000 5 35,000 69,000 Total $583,000 $583,000 Each project requires an investment of $315,000. A rate of 12% has been selected for the net present value analysis. Present Value of $1 at Compound Interest Year...
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 $107,000 $90,000 2 88,000 105,000 76,000 72,000 4 69,000 51,000 21,000 43,000 Total $361,000 $361,000 - 5 Each project requires an investment of $195,000. A rate of 20% has been selected for the net present value analysis. Present Value of $1 at Compound Interest Year 6%...
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 $171,000 $143,000 2 140,000 168,000 3 121,000 115,000 4 109,000 81,000 5 34,000 68,000 Total $575,000 $575,000 Each project requires an investment of $311,000. A rate of 10% has been selected for the net present value analysis. Present Value of $1 at Compound Interest Year...
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 $172,000 $144,000 2 140,000 168,000 3 121,000 115,000 4 110,000 81,000 5 34,000 69,000 Total $577,000 $577,000 Each project requires an investment of $312,000. A rate of 20% has been selected for the net present value analysis. Present Value of $1 at Compound Interest Year...
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 $168,000 $141,000 2 138,000 165,000 3 119,000 113,000 4 108,000 79,000 5 33,000 68,000 Total $566,000 $566,000 Each project requires an investment of $306,000. A rate of 20% has been selected for the net present value analysis. Present Value of $1 at Compound Interest Year...
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 $145,000 $121,000 2 119,000 143,000 3 102,000 98,000 4 93,000 68,000 5 29,000 58,000 Total $488,000 $488,000 Each project requires an investment of $264,000. A rate of 10% has been selected for the net present value analysis. Present Value of $1 at Compound Interest Year...
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 $132,000 $110,000 2 108,000 130,000 3 93,000 89,000 4 84,000 62,000 5 27,000 53,000 Total $444,000 $444,000 Each project requires an investment of $240,000. A rate of 15% has been selected for the net present value analysis. Present Value of $1 at Compound Interest Year...
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 $113,000 $95,000 2 93,000 111,000 3 80,000 76,000 4 72,000 53,000 5 23,000 46,000 Total $381,000 $381,000 Each project requires an investment of $206,000. A rate of 10% has been selected for the net present value analysis. Present Value of $1 at Compound Interest Year...