Question

In: Finance

B&E Incorporated is trying to select the best alternative from two options. Each alternative has an...

B&E Incorporated is trying to select the best alternative from two options. Each alternative has an initial cash outlay of $100,000. The cash flows for the alternatives are as follows:

Year

Investment A

Investment B

1

$ 10,000

$ 50,000

2

   20,000

40,000

3

30,000

30,000

4

5

   40,000

150,000

0

0

For each alternative investments, compute the Payback Method and select the best investment (using the Payback Method Results).

Solutions

Expert Solution

Payback Period for INVESTMENT-A

Year

Cash Flows ($)

Cumulative net Cash flow ($)

0

(100,000)

(100,000)

1

10,000

(90,000)

2

20,000

(70,000)

3

30,000

(40,000)

4

40,000

-  

5

150,000

150,000

Payback Period = Years before full recover + (Unrecovered cash inflow at start of the year/cash flow during the year)

= 3.00 Years + ($40,000 / $40,000)

= 3.00 Years + 1.00 Years

= 4.00 Years

Payback Period for INVESTMENT-B

Year

Cash Flows ($)

Cumulative net Cash flow ($)

0

(100,000)

(100,000)

1

50,000

(50,000)

2

40,000

(10,000)

3

30,000

20,000

4

0  

20,000

5

0

20,000

Payback Period = Years before full recover + (Unrecovered cash inflow at start of the year/cash flow during the year)

= 2.00 Years + ($10,000 / $30,000)

= 2.00 Years + 0.33 Years

= 2.33 Years


Related Solutions

A&B Enterprises is trying to select the best investment from among three alternatives. Each alternative involves...
A&B Enterprises is trying to select the best investment from among three alternatives. Each alternative involves an initial outlay of $100,000. The company’s cost of capital is 10%. The incremental after tax cash inflows for each project are as follows: ​​ ​​Year​ A​ B​ C 1​ 20,000​$50,000​$25,000​ ​​ 2​ 20,000​ 40,000​ 25,000​ ​​ 3​ 20,000​ 30,000​ 25,000​ ​​ 4​ 30,000​ 0​ 25,000​ ​​ 5​ 60,000​ 0​ 25,000​ ​​ a) Payback i) Calculate the payback period (1 decimal) for each project...
A & B Enterprises is trying to select the best investment from among two alternatives. Each...
A & B Enterprises is trying to select the best investment from among two alternatives. Each alternative involves an initial outlay of $100,000. Their cash flows follow: YEAR   A      B     130,000      0   230,000 25,000   330,000 35,000       430,000 45,000   530,000 50,000 Evaluate and rank each alternative based on   a.payback period b.net present value (use a 10% discount rate) and c.internal rate of return.
Henry is trying to select the best investment from among 3 alternatives. Each alternative involves an...
Henry is trying to select the best investment from among 3 alternatives. Each alternative involves an initial outlay of 200,000$. Their cash flows returns for each project are as follows (in $): year           project A         project B          project C 1                110,000           150,000           0 2               120,000           140,000           0 3                130,000           130,000           145,000 4                140,000           0                      155,000 5                150,000           0                      160,000 a) Evaluate and rank each alternative based...
Medical Technology Enterprises is trying to select the best investment from among four alternatives. Each alternative...
Medical Technology Enterprises is trying to select the best investment from among four alternatives. Each alternative involves an initial outlay of $100,000. and the company’s cost of capital (WACC) is 8%. Their future cash flows follow: Evaluate and rank each alternative based on payback period, net present value, and internal rate of return. Year Alternative A ($) Alternative B (S) Alternative C ($) 1 10,000 50,000 25,000 2 20,000 40,000 25,000 3 30,000 30,000 25,000 4 40,000 0 25,000 5...
Select all of the possible alternative hypotheses from the list below. Question options p = 0.37...
Select all of the possible alternative hypotheses from the list below. Question options p = 0.37 p>0.84 p<0.42 p≠0.10
John Andrews, the CFO of Fitch Services is trying to select the best investment from among...
John Andrews, the CFO of Fitch Services is trying to select the best investment from among four proposals submitted by his divisional managers. Each proposal involves an initial outlay of $120,000. Their cash flows follow: Year Emily Frank Gina Henrique 1 $ 24,000 $72,000 $36,000 $ - 2 30,000 42,000 36,000 - 3 30,000 36,000 36,000 54,000 4 54,000 - 36,000 78,000 5 66,000 - 36,000 119,000 Evaluate and rank each alternative based on a) payback period, b) net present...
Determine the best alternative among the options in the table below if the MARR is 6%....
Determine the best alternative among the options in the table below if the MARR is 6%. Option A B C Initial cost $2500 $4000 $5000 Annual net benefits $410 $639 $700 n= 20 years. NPV= IRR= NPV i A B C 0% 1% 2% 3% 4% 5% 6% 7% 8% 9% 10% 11% 12% 13% 14% 15% 16% 17% 18% 19% 20% 21% 22% 23% 24% 25% a) Using Excel, construct a choice table for interest rates from 0% to...
Capital Budgeting Tools: Payback and NPV NJF Enterprises is trying to select the best investment from...
Capital Budgeting Tools: Payback and NPV NJF Enterprises is trying to select the best investment from among four alternatives. Each alternative involves an initial outlay of $87,900, and the company uses a 13 percent discount rate. The cash inflows for each investment follow: Year A B C D 1 $10,000 $50,000 $25,000 $ 0 2 20,000 40,000 25,000 0 3 30,000 30,000 25,000 0 4 40,000 0 25,000 55,000 5 50,000 0 5,000 60,000 Evaluate each investment alternative by answering...
Computer Technology Enterprises is trying to select the best investment from among four alternatives. The company’s...
Computer Technology Enterprises is trying to select the best investment from among four alternatives. The company’s required rate of return is 14%. The initial cost and future cash flows of the alternatives are presented below. You can use Excel to solve this problem. If you do, please submit your homework document and the Excel file. Year Alternative A ($) Alternative B (S) Alternative C ($) Alternative D ($) 0 -200,000 -200,000 -200,000 -200,000 1 70,000 0 60,000 90,000 2 80,000...
Medical Technology Enterprises is trying to select the best investment from among four alternatives. The company’s...
Medical Technology Enterprises is trying to select the best investment from among four alternatives. The company’s cost of capital (WACC) is 12%. The initial cost and future cash flows of the alternatives are presented below (See pages 383 – 390). You can use Excel to solve this problem. If you do, please submit your homework document and the Excel file. Year Alternative A ($) Alternative B (S) Alternative C ($) Alternative D ($) 0 -400,000 -400,000 -400,000 -400,000 1 1400,000...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT