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 value (use a 15% discount rate), and c) internal rate of return. Be sure to show your work in an excel file! Cost $120,000 Discount Rate 15% a) What is the Payback Period for for each alternative? Emily Blank 1 Frank Blank 2 Gina Blank 3 Henrique Blank 4 Which alternative would you choose using the payback period? Blank 5 b) What is the Net Present Value for each project using a 15% discount rate? Emily Blank 6 Frank Blank 7 Gina Blank 8 Henrique Blank 9 Which alternative would you choose using the NPV using a 15% discount rate? Blank 10 c) What is the IRR for each Project? Emily Blank 11 Frank Blank 12 Gina Blank 13 Henrique Blank 14 Which alternative would you choose using the IRR? Blank 15

Solutions

Expert Solution

Payback period for Emily is calculated in excel and screen shot provided below:

Payback period for Emily is 3.67 years.

Payback period for Frank is calculated in excel and screen shot provided below:

Payback period for Frank is 2.17 years.

Payback period for Gina is calculated in excel and screen shot provided below:

Payback period for Gina is 3.33 years.

Payback period for Henrique is calculated in excel and screen shot provided below:

Payback period for henrique is 3.85 years.

Payback period for Project Frank is lowest among all four projects. So, based on payback period, project Frank should be accepted.

NPV of all four projects is calculated in excel and screen shot provided below:

NPV for Emily is $6,970.70, NPV for Frank is -$1,962.69, NPV for Gina is $677.58 and NPV for Henrique is $19,266.66.

NPV of project Henrique is highest among all four project. So, based on NPV, project Henrique should be accepted.

IRR of all four projects is calculated in excel and screen shot provided below:

IRR for Emily is 17.02%, IRR for Frank is 13.87%, IRR for Gina is 15.24% and IRR for Henrique is 19.19%.

IRR of project Henrique is highest among all four project. So, based on IRR, project Henrique should be accepted.

jeff jeffy answered 1 year ago

Next > < Previous

Related Solutions

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.

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

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. The company’s...

Medical Technology Enterprises is trying to select the best investment from among four alternatives. The company’s cost ofcapital (CCC) 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 provide formulas used. 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 0 60,000 100,000 3 70,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 (CCC) is 14%. The initial cost and future cash flows of the alternatives are presented below. 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 0 60,000 100,000 3 70,000 90,000 60,000 100,000 4 40,000 100,000 60,000 0 5 30,000 100,000 60,000 0 (If...

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

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

Problem 1 Medical Technology Enterprises is trying to select the best investment from among four alternatives....

Problem 1 Medical Technology Enterprises is trying to select the best investment from among four alternatives. The company’s cost ofcapital (CCC) is 14%. 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 -200,000 -200,000 -200,000 -200,000 1...

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

Subjects