Question

The firm must choose between two mutually exclusive investments each requiring initial outlay of $8000 with...

  1. The firm must choose between two mutually exclusive investments each requiring initial outlay of $8000 with the following net cash flows:

Year Investment A Investment B

1 3200 4800

2 2400 3200

3 4800 2400

The firm’s required rate of return is 14%

  1. Calculate the payback period and the net present value method for each investment.

  2. Which (or both) investment should be chosen?

Homework Answers

Answer #1

Using Excel to calculate payback period.

Year 0 1 2 3
Cash Flow -8000 3200 2400 4800
Cumulative Cash Flow -8000 -4800 -2400 2400
Payback Period 2.5 (PB=2+2400/4800)
Year 0 1 2 3
Cash Flow -8000 4800 3200 2400
Cumulative Cash Flow -8000 -3200 0 2400
Payback Period 2 PB= 2
A B
0 -8000 -8000
1 3200 4800
2 2400 3200
3 4800 2400
NPV -106.40 292.75
Excel Formula NPV(14%,A1:A3)+A0 NPV(14%,B1:B3)+B0

Since NPV of Project B is higher it should be accepted

Please Discuss in case of Doubt

Best of Luck. God Bless
Please Rate Well

Please Discuss in case of Doubt

Best of Luck. God Bless
Please Rate Well

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
A firm is considering the two mutually exclusive investments projects. Project Alpha requires an initial outlay...
A firm is considering the two mutually exclusive investments projects. Project Alpha requires an initial outlay of $600 and will return $160 per year for the next seven years; Project Beta requires an initial outlay of $1,100 and will return $350 per year for the next five years. Assuming a 11% required return, calculate the NPV, Payback Period, and MIRR of each project. Please help by showing Excel calculations. Thanks!
A firm must choose between two mutually exclusive projects, A & B. Project A has an...
A firm must choose between two mutually exclusive projects, A & B. Project A has an initial cost of $11000. Its projected net cash flows are $900, $2000, $3000, $4000, and $5000 at the end of years 1 through 5, respectively. Project B has an initial cost of $15000, and its projected net cash flows are $7000, $5000, $3000, $2000, and $1000 at the end of years 1 through 5, respectively. If the firm’s cost of capital is 6.00%: Project...
A firm must choose between two mutually exclusive projects, A & B. Project A has an...
A firm must choose between two mutually exclusive projects, A & B. Project A has an initial cost of $10000. Its projected net cash flows are $800, $2000, $3000, $4000, and $5000 at the end of years 1 through 5, respectively. Project B has an initial cost of $14000, and its projected net cash flows are $7000, $5000, $3000, $2000, and $1000 at the end of years 1 through 5, respectively. The firm’s cost of capital is 6.00%. Choose the...
A firm must choose between two mutually exclusive projects, A & B. Project A has an...
A firm must choose between two mutually exclusive projects, A & B. Project A has an initial cost of $11000. Its projected net cash flows are $900, $2000, $3000, $4000, and $5000 at the end of years 1 through 5, respectively. Project B has an initial cost of $15000, and its projected net cash flows are $7000, $5000, $3000, $2000, and $1000 at the end of years 1 through 5, respectively. If the firm’s cost of capital is 6.00%: A....
a firm must choose between two mutually exclusive projects, a & b. project a has an...
a firm must choose between two mutually exclusive projects, a & b. project a has an initial cost of $10000. its projected net cash flows are $800, $2000, $3000, $4000, and $5000 at the end of years 1 through 5, respectively. project b has an initial cost of $14000, and its projected net cash flows are $7000, $5000, $3000, $2000, and $1000 at the end of years 1 through 5, respectively. at what cost of capital would the firm be...
A firm must choose between two mutually exclusive projects, A & B. Project A has an...
A firm must choose between two mutually exclusive projects, A & B. Project A has an initial cost of $11000. Its projected net cash flows are $900, $2000, $3000, $4000, and $5000 at the end of years 1 through 5, respectively. Project B has an initial cost of $15000, and its projected net cash flows are $7000, $5000, $3000, $2000, and $1000 at the end of years 1 through 5, respectively. At what cost of capital would the firm be...
All techniques—Decision among mutually exclusive investments??? Pound Industries is attempting to select the best of three...
All techniques—Decision among mutually exclusive investments??? Pound Industries is attempting to select the best of three mutually exclusive projects. The initial investment and?after-tax cash inflows associated with these projects are shown in the following table. Cash flows Project A Project B Project C Initial investment? (CF)    ?$40,000 ?$80,000 ?$90,000 Cash inflows? (CF), tequals=1 to 5 ?$15,000 ?$26,500 ?$27,500 a. Calculate the payback period for each project. b. Calculate the net present value? (NPV) of each? project, assuming that the...
A firm must choose between two mutually exclusive projects, A & B. Project A has an...
A firm must choose between two mutually exclusive projects, A & B. Project A has an initial cost of $11000. Its projected net cash flows are $900, $2000, $3000, $4000, and $5000 at the end of years 1 through 5, respectively. Project B has an initial cost of $15000, and its projected net cash flows are $7000, $5000, $3000, $2000, and $1000 at the end of years 1 through 5, respectively. If the firm’s cost of capital is 6.00%: The...
 Shell Camping​ Gear, Inc., is considering two mutually exclusive projects. Each requires an initial investment of...
 Shell Camping​ Gear, Inc., is considering two mutually exclusive projects. Each requires an initial investment of ​$140,000. John​ Shell, president of the​ company, has set a maximum payback period of 4 years. The​ after-tax cash inflows associated with each project are shown in the following​ table: 1 20,000 50,000 2 30,000 40,000 3 40,000 30,000 4 50,000 20,000 5 30,000 30,000 a.  Determine the payback period of each project. b.  Because they are mutually​ exclusive, Shell must choose one. Which...
Q2) A firm has a WACC of 8.64% and is deciding between two mutually exclusive projects....
Q2) A firm has a WACC of 8.64% and is deciding between two mutually exclusive projects. Project A has an initial investment of $61.55. The additional cash flows for project A are: year 1 = $19.98, year 2 = $38.47, year 3 = $61.67. Project B has an initial investment of $72.32. The cash flows for project B are: year 1 = $59.90, year 2 = $35.62, year 3 = $28.78. Calculate the Following: a) Payback Period for Project A:...