Question

In: Finance

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 $130,000 $109,000
2 107,000 128,000
3 92,000 88,000
4 83,000 61,000
5 26,000 52,000
Total $438,000 $438,000

Each project requires an investment of $237,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 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, the plant expansion  offers a higher net present value .

Feedback

Solutions

Expert Solution


Plant Expansion

Retail Store Expansion

Present value of net cash flow total

$334,403

$330,289

Less amount to be invested

$237,000

$237,000

Net present value

$97,403

$93,289

Net Present Value - Plant Expansion

Year

Annual cash inflow ($)

Present Value factor at 12%

Present Value of Annual cash inflow ($)

1

1,30,000

0.893

1,16,090

2

1,07,000

0.797

85,279

3

92,000

0.712

65,504

4

83,000

0.636

52,788

5

26,000

0.567

14,742

TOTAL

334,403

Net Present Value = Present Value of annual cash inflows - Initial Investment

= $334,403 - $237,00

= $97,403

Net Present Value - Retail Store Expansion

Year

Annual cash inflow ($)

Present Value factor at 12%

Present Value of Annual cash inflow ($)

1

1,09,000

0.893

97,337

2

1,28,000

0.797

1,02,016

3

88,000

0.712

62,656

4

61,000

0.636

38,796

5

52,000

0.567

29,484

TOTAL

330,289

Net Present Value = Present Value of annual cash inflows - Initial Investment

= $330,289 - $237,00

= $93,289


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 $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...
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...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT