Question

In: Finance

HW 12, Problem 1, parts a and b You are considering an investment in two projects,...

HW 12, Problem 1, parts a and b

  1. You are considering an investment in two projects, A and B. Birth projects will cost $115,000, and the projected cash flows are as follows:

Year

Project A

Project B

1

$7,188

$51,750

2

21,562

38,812

3

40,250

28,750

4

50,315

21,563

5

57,500

14,375

  1. Assuming that the WACC is 9.4%, calculate the payback period, discounted payback period, NPV, PI, IRR and MIRR. If the projects are mutually exclusive, which project should be selected?
  2. Create an NPV profile chart for projects A and What is the exact crossover rate for these two projects?

Solutions

Expert Solution

As per rules I am answering the first 4 subparts of the question

A B
Payback 3.91 2.85
DPB 4.94 4.45
NPV 139097.42 137752.93
PI 1.11 1.09

Workings

Year Project A Cumulative CF DCF Cumulative DCF Project B Cumulative CF DCF Cumulative DCF
0 -115000.00 -115000.00 -115000.00 -115000.00 -115000.00 -115000.00 -115000.00 -115000.00
1 7188.00 -107812.00 6417.86 -108582.14 51750.00 -63250.00 46205.36 -68794.64
2 21562.00 -86250.00 17189.09 -91393.05 38812.00 -24438.00 30940.69 -37853.95
3 40250.00 -46000.00 28649.15 -62743.89 28750.00 4312.00 20463.68 -17390.27
4 50315.00 4315.00 31976.09 -30767.80 21563.00 25875.00 13703.68 -3686.60
5 57500.00 61815.00 32627.04 1859.24 14375.00 40250.00 8156.76 4470.17


Related Solutions

HW 12, Problem 1, parts a and b You are considering an investment in two projects,...
HW 12, Problem 1, parts a and b You are considering an investment in two projects, A and B. Birth projects will cost $115,000, and the projected cash flows are as follows: Year Project A Project B 1 $7,188 $51,750 2 21,562 38,812 3 40,250 28,750 4 50,315 21,563 5 57,500 14,375 Assuming that the WACC is 9.4%, calculate the payback period, discounted payback period, NPV, PI, IRR and MIRR. If the projects are mutually exclusive, which project should be...
You are considering an investment in two projects, A and B. Both projects will cost $115,000,...
You are considering an investment in two projects, A and B. Both projects will cost $115,000, and the projected cash flows are as follows: YEAR PROJECT A PROJECT B 1 $7,188    $51,750 2 $21,562    $38,812 3 $40,250    $28,750 4 $50,315    $21,563 5    $57,500 $14,375 Using Excel and show formulas a. Assuming that the WACC is 9.4%, calculate the payback period, discounted payback period, NPV, PI, IRR, and MIRR. If the projects are mutually exclusive, which...
Hw 12, alg 2: Problem 12-18 Parts 1, 3, 4) Relevant Cost Analysis in a Variety...
Hw 12, alg 2: Problem 12-18 Parts 1, 3, 4) Relevant Cost Analysis in a Variety of Situations [LO12-2, LO12-3, LO12-4] Andretti Company has a single product called a Dak. The company normally produces and sells 84,000 Daks each year at a selling price of $54 per unit. The company’s unit costs at this level of activity are given below: Direct materials $ 7.50 Direct labor 10.00 Variable manufacturing overhead 2.60 Fixed manufacturing overhead 3.00 ($252,000 total) Variable selling expenses...
Problem 12-7 NPV Your division is considering two investment projects, each of which requires an up-front...
Problem 12-7 NPV Your division is considering two investment projects, each of which requires an up-front expenditure of $15 million. You estimate that the investments will produce the following net cash flows: Year Project A Project B 1 $ 5,000,000 $20,000,000 2 10,000,000 10,000,000 3 20,000,000 6,000,000 What are the two projects' net present values, assuming the cost of capital is 5%? Round your answers to the nearest dollar. Project A $ Project B $ What are the two projects'...
1.) A company is considering two projects.   Project A Project B Initial investment $300,000 $300,000 Cash...
1.) A company is considering two projects.   Project A Project B Initial investment $300,000 $300,000 Cash inflow Year 1 $60,000 $90,000 Cash inflow Year 2 $60,000 $80,000 Cash inflow Year 3 $60,000 $80,000 Cash inflow Year 4 $60,000 $50,000 Cash inflow Year 5 $60,000 $70,000 What is the payback period for Project B? Select one: a. 2 years b. 5 years c. 3.5 years d. 4 years e. 3 years 2.) Ace Inc. produces custom widgets. The cost structure for...
Problem 9.12 There are two parts of the problem a and b i was able to...
Problem 9.12 There are two parts of the problem a and b i was able to get the answer for the first part, but for the second part I wasn't able to finish it The agency is also experimenting with a program that includes peer counseling for depressed teenagers. About half of all clients were randomly assigned to the new program. After a year, a random sample of teens from the new program was compared with a random sample that...
A firm is considering two mutually exclusive projects, A and B. The projects are different in...
A firm is considering two mutually exclusive projects, A and B. The projects are different in that they have different returns depending on general economic conditions. The firm forecasts that return on the market, and the returns on each project, along with their associated probabilities will be given by the following table. You can assume a 5% risk free rate and a 6% market risk premium. Assume the CAPM holds. Compare the expected returns to the cost of capital for...
Your firm is considering investment projects, A, B, and C. Given the budget constraints, you must...
Your firm is considering investment projects, A, B, and C. Given the budget constraints, you must choose either A or B, but not both. Project A will provide a net return of either $40, $50, or $60, respectively, depending on whether there will be a recession, normal conditions, or a boom. The figures for Project B are $20, $30, or $80, respectively. Project C’s figures are: $30, $40, or $70, respectively. Forecasts indicate that, given the current trends in appropriate...
Everest plc is considering investing in a number of new investment projects – A, B, and...
Everest plc is considering investing in a number of new investment projects – A, B, and C. The expected pattern of net cash flows for each project are: A B C 000 0 (370) (800) (950) 1 115 200 250 2 115 200 250 3 200 200 290 4 300 350 290 5 350 350 400 The company’s cost of capital is 8%. Everest plc wishes to use net present value (NPV) to assess the three projects. (i) Outline the...
you have $100 to invest in two different investment projects, A and B, the total returns...
you have $100 to invest in two different investment projects, A and B, the total returns from which (TR and TR) are given below. the cost of purchasing a unit of investment in each project is $10 per unit. your problem is to invest the $100 in the two invest the $100 in the two investments so as to maximize your total return (for example, if you invested the entire $100 in investment B, you would receive a total return...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT