Question

You are evaluating the following project. All $ are in millions Initial cost of the project at t-0 is $70. Annual cash flows from the project depends on the demand for the product and is estimated to be as follows: With probability of 30%, the demand is high and the annual cash flow is $45 With probability of 40%, the demand is average and the annual cash flow is $30 With probability of 30%, the demand is low and the annual cash flow is $15 The above cash flows occur for the next 3 years, that is, until from t-1 to t-3. The company plans to finance the project by issuing bonds and stocks. The company will issue a ten-year bond at par with the coupon rate of 5%. The company's stock has a beta of 2.1. The risk-free rate is 2.07% and the market risk premium is 6%. The marginal tax rate of the firm is 40%. The firm's target and current capital structure is 40% debt and 60% equity. Questions: (in your calculations, please keep up to two decimal points after 90 For example, 12.34%.) 1. What is the expected NPV of the project? 2. What feature of the project makes the managers hesitant with starting this project? 3. Now assume that if we wait one year, we will gain additional information regarding demand. That is, at t-1, we will know whether the demand will be high, average, or low. (The probability of the demand is 30%,40%,30% at t-0 and then becomes certain at t=1). Find out the expected NPV of the proiect.

I need it the excel document, not a screenshot please

I need question 3 answered please

Answer 1

Part 3 :

Let’s assume at t=1 we certainly know demand will be high.

WACC = 0.6*(2.07 + 2.1*6) + 0.4*(5*(1-0.4))

= 10.90%

We know that demand is high at t= 1, therefore annual cash flow is 45 starting t=2.

NPV = -70 + (0.3*45 + 0.4*30 + 0.3*15)/(1.109) + 45/(1.109^2) + 45/(1.109^3)

= 26.63

similarly, use the cases for when demand is known to be average and low at t=1.