Question

In: Finance

Assume a $52,000 investment and the following cash flows for two alternatives. Year Investment A Investment...

Assume a $52,000 investment and the following cash flows for two alternatives.

Year Investment A Investment B
1 $15,000

$25,000

2 15,000

15,000

3 15,000

20,000

4 10,000 -
5 15,000 -

a. Calculate the payback for investment A and B. Round your answers to 2 decimal places.

Investment A years
Investment B years

b. Which investment would you select under the payback method?

-Investment A

-Investment B

c. If the inflow in the fifth year for Investment A was $15,000,000 instead of $15,000, would your answer change under the payback method?

-Yes

-No

Solutions

Expert Solution

a.

A:

Year Cash flows Cumulative Cash flows
0 (52000) (52000)
1 15000 (37000)
2 15000 (22000)
3 15000 (7000)
4 10000 3000
5 15000 18000

Hence Payback period=Last period with a negative cumulative cash flow+(Absolute value of cumulative cash flows at that period/Cash flow after that period).

3+(7000/10000)

=3.7 years.

B:

Year Cash flows Cumulative Cash flows
0 (52000) (52000)
1 25000 (27000)
2 15000 (12000)
3 20000 8000

Hence Payback period=Last period with a negative cumulative cash flow+(Absolute value of cumulative cash flows at that period/Cash flow after that period).

2+(12000/2000)

=2.6 years

Investment A 3.7 years
Investment B 2.6 years

b.Hence B is better having lower payback.

c.Payback method considers cash flows only till the time period the initial investment is recovered .Hence cash flow change for year 5 for investment A would not affect the payback decision.

Hence the correct option is 'No'.


Related Solutions

Assume a $40,000 investment and the following cash flows for two alternatives. Year Investment A Investment...
Assume a $40,000 investment and the following cash flows for two alternatives. Year Investment A Investment B 1 $ 5,000 $ 25,000 2 12,000 10,000 3 15,000 20,000 4 10,000 — 5 10,000 — a. Calculate the payback for investment A and B. (Round your answers to 2 decimal places.) b. Which investment would you select under the payback method? Investment A Investment B c. If the inflow in the fifth year for Investment A was $10,000,000 instead of $10,000,...
Assume a $95,000 investment and the following cash flows for two alternatives: Year Investment A Investment...
Assume a $95,000 investment and the following cash flows for two alternatives: Year Investment A Investment B 1 $25,000 $30,000 2 15,000 30,000 3 30,000 40,000 4 30,000 — 5 20,000 — Calculate the payback period for investment A and investment B. Show calculation. (Do not round intermediate calculations. Round the final answers to 2 decimal places.) Payback period   Investment A years   Investment B years
Assume a $95,000 investment and the following cash flows for two alternatives. Year Investment A Investment...
Assume a $95,000 investment and the following cash flows for two alternatives. Year Investment A Investment B 1 $ 35,000 $ 40,000 2 30,000 35,000 3 20,000 25,000 4 20,000 — 5 20,000 — a. Calculate the payback for investment A and B. (Round your answers to 2 decimal places.)    b. Which investment would you select under the payback method?    Investment A Investment B c. If the inflow in the fifth year for Investment A was $20,000,000 instead...
Assume a $105,000 investment and the following cash flows for two alternatives. Year Investment X Investment...
Assume a $105,000 investment and the following cash flows for two alternatives. Year Investment X Investment Y 1 $30,000 $40,000 2 45,000 35,000 3 15,000 35,000 4 30,000 — 5 10,000 — a. Calculate the payback for investment X and Y. (Do not round intermediate calculations. Round your answers to 2 decimal places.)    b. Which alternative would you select under the payback method?    Investment X Investment Y
Assume a $70,000 investment and the following cash flows for two alternatives. Year Investment X Investment...
Assume a $70,000 investment and the following cash flows for two alternatives. Year Investment X Investment Y 1 $15,000 $35,000 2 20,000 20,000 3 20,000 20,000 4 20,000 — 5 15,000 — a. Calculate the payback for investment X and Y. (Do not round intermediate calculations. Round your answers to 2 decimal places.)    b. Which alternative would you select under the payback method?    Investment X Investment Y
Assume a $62,000 investment and the following cash flows for two alternatives. Year Investment X Investment...
Assume a $62,000 investment and the following cash flows for two alternatives. Year Investment X Investment Y 1 $20,000 $35,000 2 15,000 15,000 3 15,000 22,000 4 15,000 — 5 25,000 — a. Calculate the payback for investment X and Y. (Do not round intermediate calculations. Round your answers to 2 decimal places.)    b. Which alternative would you select under the payback method? Investment X or Y?
Payback method Assume a $90,000 investment and the following cash flows for two alternatives. Year Investment...
Payback method Assume a $90,000 investment and the following cash flows for two alternatives. Year Investment A Investment B 1................ $25,000 $40,000 2................ 30,000 40,000 3................ 25,000 28,000 4................ 19,000 — 5................ 25,000 —          a. Calculate the payback for investment A and B.          b. If the inflow in the fifth year for Investment A was $25,000,000 instead of $25,000, would your answer change under the payback method?
Assume a $250,000 investment and the following cash flows for two alternatives: Year Product X   ...
Assume a $250,000 investment and the following cash flows for two alternatives: Year Product X    Product Y 1 $ 90,000   $ 50,000 2 90,000 80,000 3 60,000 60,000 4 20,000   70,000 a. Calculate the payback for products X and Y. (Do not round intermediate calculations. Round your answers to 2 decimal places.) Payback Product X years Product Y years b. Which of the alternatives would you select under the payback method? Product X Product Y
Assume a $250,000 investment and the following cash flows for two products: Year Product X Product...
Assume a $250,000 investment and the following cash flows for two products: Year Product X Product Y 1 $90,000 $50,000 2 90,000 80,000 3 60,000 60,000 4 20,000 70,000 Which alternatives would you select under the payback method?
5. Assume a $200,000 investment and the following cash flows for two alternative capital projects: Year...
5. Assume a $200,000 investment and the following cash flows for two alternative capital projects: Year Project A Project B 1 $60,000 $40,000 2 90,000 70,000 3 50,000 80,000 4 40,000 20,000 a. Calculate the payback period for each project. b. Using the payback method, if the projects are mutually exclusive, which project would you select and why? c. If the year four cash flows were $100,000 for Project A and $500,000 for Project B, would your decision change under...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT