In: Accounting
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 | 106,000 | 127,000 | ||
| 3 | 91,000 | 87,000 | ||
| 4 | 83,000 | 61,000 | ||
| 5 | 26,000 | 52,000 | ||
| Total | $435,000 | $435,000 | ||
Each project requires an investment of $235,000. A rate of 10% 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 | 2 years | 
| Retail Store Expansion | 2 years | 
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, BLANK the offers a higher BLANK .
Solution
Elite Apparel Inc
1b. computation of the net present value for each project:
| 
 Plant Expansion  | 
 Retail Store Expansion  | 
|
| 
 Present Value of net cash flow Total  | 
 $346,072  | 
 $342,449  | 
| 
 Less: Amount to be invested  | 
 $235,000  | 
 $235,000  | 
| 
 Net Present Value  | 
 $111,072  | 
 $107,449  | 
Computations:
| 
 Plant Expansion  | 
|||||||
| 
 Year  | 
 0  | 
 1  | 
 2  | 
 3  | 
 4  | 
 5  | 
 Total  | 
| 
 Initial Investment  | 
 ($235,000)  | 
 ($235,000)  | 
|||||
| 
 Cash Flow  | 
 -  | 
 $129,000  | 
 $106,000  | 
 $91,000  | 
 $83,000  | 
 $26,000  | 
 $435,000  | 
| 
 present value factor at 10%  | 
 1  | 
 0.9091  | 
 0.8264  | 
 0.7513  | 
 0.683  | 
 0.6209  | 
|
| 
 present values  | 
 ($235,000)  | 
 $117,274  | 
 $87,598  | 
 $68,368  | 
 $56,689  | 
 $16,143  | 
 $346,072  | 
| 
 Net Present Value = present value of cash flows - present value of initial investment  | 
 $111,072  | 
||||||
| 
 Retail Store Expansion  | 
|||||||
| 
 Year  | 
 0  | 
 1  | 
 2  | 
 3  | 
 4  | 
 5  | 
 Total  | 
| 
 Initial Investment  | 
 ($235,000)  | 
 ($235,000)  | 
|||||
| 
 Cash Flows  | 
 -  | 
 $108,000  | 
 $127,000  | 
 $87,000  | 
 $61,000  | 
 $52,000  | 
 $435,000  | 
| 
 present value factor at 10%  | 
 1  | 
 0.9091  | 
 0.8264  | 
 0.7513  | 
 0.683  | 
 0.6209  | 
|
| 
 present values  | 
 ($235,000)  | 
 $98,183  | 
 $104,953  | 
 $65,363  | 
 $41,663  | 
 $32,287  | 
 $342,449  | 
| 
 Net Present Value = present value of cash flows - present value of initial investment  | 
 $107,449  | 
||||||
Because of the timing of the receipt of the net cash flows, Plant Expansion offers a higher Net Present Value.