Question

In: Accounting

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 $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 6% 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
Total present value of net cash flow $ $
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  .

Solutions

Expert Solution

Answer-1-a)-Cash payback period- Plant Expansion = 2 years.

Retail Store Expansion = 2 years.

Explanation- Payback period is the time in which the initial cash outflow of an investment is expected to be recovered from the cash inflows generated by the investment. It is one of the simplest investment appraisal techniques.

When cash inflows are uneven, then calculate cumulative net cash flow for each period and

Then use the following formula for payback period:

Payback period =A+B/C

Where:-A is the last period with a negative cumulative cash flow;
B is the absolute value of cumulative cash flow at the end of the period A;
C is the total cash flow during the period after A

Plant Expansion= 1 years + ($119000/$119000)

= 2 years

Retail Store Expansion= 1 years + ($143000/$143000)

= 2 years

1-b)-

Particulars Plant Expansion Retail Store Expansion
$ $
Total present value of net cash flow 423644 420875
Less- Amount to be invested 264000 264000
Net Present Value $ 159644 156875

Explanation-

Calculation of Net Present Value
Plant Expansion
Year Net Cash Flows (a) Present Value of 1 at 6% (b) Present Value of cash flows (c=a*b)
Year 1 145000 0.943 136735
Year 2 119000 0.890 105910
Year 3 102000 0.840 85680
Year 4 93000 0.792 73656
Year 5 29000 0.747 21663
Totals
Total present value of cash inflow (a) 423644
Total cash outflow (b) 264000
Net Present Value (c=a-b) 159644
Calculation of Net Present Value
Retail Store Expansion
Year Net Cash Flows (a) Present Value of 1 at 6% (b) Present Value of cash flows (c=a*b)
Year 1 121000 0.943 114103
Year 2 143000 0.890 127270
Year 3 98000 0.840 82320
Year 4 68000 0.792 53856
Year 5 58000 0.747 43326
Totals
Total present value of cash inflow (a) 420875
Total cash outflow (b) 264000
Net Present Value (c=a-b) 156875

2)-Because of the timing of the receipts of the net cash flows, the plant expansion offers a higher net present value.


Related Solutions

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 $101,000 $85,000 2 83,000 99,000 3 71,000 68,000 4 65,000 48,000 5 20,000 40,000 Total $340,000 $340,000 Each project requires an investment of $184,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...
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 $175,000 $146,000 2 143,000 172,000 3 123,000 118,000 4 112,000 82,000 5 35,000 70,000 Total $588,000 $588,000 Each project requires an investment of $318,000. A rate of 6% 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...
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 $111,000 $93,000 2 91,000 109,000 3 79,000 75,000 4 71,000 52,000 5 22,000 45,000 Total $374,000 $374,000 Each project requires an investment of $202,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...
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 $144,000 $121,000 2 118,000 141,000 3 102,000 97,000 4 92,000 68,000 5 29,000 58,000 Total $485,000 $485,000 Each project requires an investment of $262,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...
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 $144,000 2 141,000 170,000 3 122,000 116,000 4 110,000 81,000 5 35,000 70,000 Total $581,000 $581,000 Each project requires an investment of $314,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...
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 $143,000 $120,000 2 117,000 140,000 3 101,000 96,000 4 91,000 67,000 5 29,000 58,000 Total $481,000 $481,000 Each project requires an investment of $260,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...
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 $169,000 $142,000 2 139,000 166,000 3 120,000 114,000 4 108,000 80,000 5 34,000 68,000 Total $570,000 $570,000 Each project requires an investment of $308,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...
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 $114,000 $95,000 2 93,000 112,000 3 80,000 77,000 4 73,000 54,000 5 23,000 45,000 Total $383,000 $383,000 Each project requires an investment of $207,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...
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 $167,000 $140,000 2 137,000 164,000 3 118,000 112,000 4 107,000 79,000 5 33,000 67,000 Total $562,000 $562,000 Each project requires an investment of $304,000. A rate of 6% 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...
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 $109,000 $91,000 2 89,000 107,000 3 77,000 73,000 4 70,000 51,000 5 21,000 44,000 Total $366,000 $366,000 Each project requires an investment of $198,000. A rate of 20% has been selected for the net present value analysis. Present Value of $1 at Compound Interest Year...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT