Question

In: Accounting

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

(a): The answers are:

Payback Discounted payback NPV PI IRR MIRR
Project A 3.91 4.67 12,145.72 1.11 12.50 11.62
Project B 2.85 3.88 10,916.75 1.09 13.95 11.40

Calculations:

Payback:

Year A's cash flow Cumulative cash flow of A B's cash flow Cumulative cash flow of B
0 -115,000.00 -115,000.00 -115,000.00 -115,000.00
1 7,188.00 -107,812.00 51,750.00 -63,250.00
2 21,562.00 -86,250.00 38,812.00 -24,438.00
3 40,250.00 -46,000.00 28,750.00 4,312.00
4 50,315.00 4,315.00 21,563.00
5 57,500.00 14,375.00

A's payback = 3+(46000/50315) = 3.91 years

B's payback = 2+(24438/28750) = 2.85 years

Discounted payback:

Year A's cash flow 1+r PVIF A's discounted cash flow Cumulative discounted cash flow of A B's cash flow B's discounted cash flow Cumulative discounted cash flow of B
0 -115,000.00 1.094 1.0000 -115,000.00 -115,000.00 -115,000.00 -115,000.00 -115,000.00
1 7,188.00 0.9141 6,570.38 -108,429.62 51,750.00 47,303.47 -67,696.53
2 21,562.00 0.8355 18,015.84 -90,413.78 38,812.00 32,428.84 -35,267.69
3 40,250.00 0.7637 30,740.71 -59,673.07 28,750.00 21,957.65 -13,310.04
4 50,315.00 0.6981 35,125.96 -24,547.11 21,563.00 15,053.58 1,743.55
5 57,500.00 0.6381 36,692.83 12,145.72 14,375.00 9,173.21

A's discounted payback = 4+(24547.11/36692.83) = 4.67 years

B's discounted payback = 3+(13310.04/15053.58) = 3.88 years

NPV:

Year A's cash flow 1+r PVIF A's discounted cash flow B's discounted cash flow
0 -115,000.00 1.094 1.0000 -115,000.00 -115,000.00
1 7,188.00 0.9141 6,570.38 47,303.47
2 21,562.00 0.8355 18,015.84 32,428.84
3 40,250.00 0.7637 30,740.71 21,957.65
4 50,315.00 0.6981 35,125.96 15,053.58
5 57,500.00 0.6381 36,692.83 9,173.21
NPV 12,145.72 10,916.75

PI: PI = present value of cash inflows/present value of cash outflows

A's cash flow 1+r PVIF A's discounted cash flow B's discounted cash flow
-115,000.00 1.094 1.0000 -115,000.00 -115,000.00
7,188.00 0.9141 6,570.38 47,303.47
21,562.00 0.8355 18,015.84 32,428.84
40,250.00 0.7637 30,740.71 21,957.65
50,315.00 0.6981 35,125.96 15,053.58
57,500.00 0.6381 36,692.83 9,173.21
Present value of inflows 127,145.72 125,916.75
Present value of outflow 115,000.00 115,000.00
PI 1.11 1.09

IRR: it is the rate that makes NPV as nil:

A's cash flow 1+r PVIF A's discounted cash flow
-115,000.00 1.1250402 1.0000 -115,000.00
7,188.00 0.8889 6,389.11
21,562.00 0.7901 17,035.43
40,250.00 0.7023 28,265.83
50,315.00 0.6242 31,406.92
57,500.00 0.5548 31,902.72
NPV 0.00

B's IRR:

Year 1+r PVIF B's cash flow B's discounted cash flow
0 1.139537 1.0000 -115,000.00 -115,000.00
1 0.8775 51,750.00 45,413.18
2 0.7701 38,812.00 29,888.84
3 0.6758 28,750.00 19,429.09
4 0.5930 21,563.00 12,787.79
5 0.5204 14,375.00 7,481.10
Total 0.00

MIRR: Present value of cash outflow = Terminal value/(1+MIRR)^5

Terminal value of A = 7188*1.094^4 + 21562*1.094^3 + 40250*1.094^2 + 50315*1.094^1 + 57500 = 199,245.43

or 115,000 = 199245.43/(1+MIRR)^5. Solving this we get MIRR = 11.62%

For B: Terminal value = 51750*1.094^4+38812*1.094^3 + 28750*1.094^2 + 21563*1.094^1 + 14375 = 197,319.56

or 115,000 = 197319.56/(1+MIRR)^5. Solving we get MIRR = 11.40%

(b) Exact cross over rate is the rate at which NPV is same for both the projects. The cross over rate is = 10.1883% or 10.19% (rounded off to 2 decimal place)

Graph:

60,000.00 50,000.00 As NPV 30,000.00 10,000.00 0.00 0.00 2.00 4.00 6.00 8.00 10.00 12.00 14.00


Related Solutions

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...
Swenson's is considering two mutually exclusive projects, Projects A and B, and has determined that the...
Swenson's is considering two mutually exclusive projects, Projects A and B, and has determined that the crossover rate for these projects is 11.7 percent and the required return for both projects is 9 percent. Given this you know that: Multiple Choice both projects have a zero NPV at a discount rate of 11.7 percent. neither project will be accepted if the discount rate is less than 11.7 percent. the project that is acceptable at a discount rate of 11 percent...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT