Question

In: Finance

You are evaluating the following project. All $ are in millions Initial cost of the project...

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 %. 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 project. The same demand continues throughout the life of the project. (That is, the demand is high-high-high with 30%, avg-avg-avg with 40%, and low-low-low with 30%). The demand cannot be, for example, high-low-avg.

In Q3, the following paragraph provides further information. 3. Now assume that if we wait one year, we will gain additional information regarding demand and can decide whether to do the project or not at t=1. That is, at t=1, we will know whether the demand for the product 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). If you decide to do the project at t=1, the initial cost occurs at t=1, and cash flow according to the demand type will stay the same during the life of the project until t=4. Find out the expected NPV of the project at t=0.

Solutions

Expert Solution

All cash flows are in $ mn

Initial investment, C0 = 70

N = number of years = 3

Cost of debt, Kd = YTM = Coupon rate (as bond is issued at par) = 5%

Cost of equity, Ke = risk free rate + Beta x market premium = 2.07% + 2.1 x 6% = 14.67%

Proportion of debt = Wd = 40%

Proportion of equity, We = 60%

Tax rate, T = 40%

Hence, Discount rate = R = WACC = Wd x Kd x (1 - T) + We x Ke = 40% x 5% x (1 - 40%) + 60% x 14.67% = 10.00%

Part (1)

Probability of high demand = Phigh = 30%; Expected annual cash flows, Chigh = 45

Hence, NPVhigh = - C0 + Chigh / R x [1 - (1 + R)-N] = - 70 + 45 / 10% x [1 - (1 + 10%)-3] = $ 41.90

Probability of average demand = Paverage = 40%; Expected annual cash flows, Caverage = 30

Hence, NPVaverage = - C0 + Caverage / R x [1 - (1 + R)-N] = - 70 + 30 / 10% x [1 - (1 + 10%)-3] = $ 4.60

Probability of low demand = Plow = 30%; Expected annual cash flows, Clow = 15

Hence, NPVlow = - C0 + Clow / R x [1 - (1 + R)-N] = - 70 + 15 / 10% x [1 - (1 + 10%)-3] = - $ 32.70

Hence, expected NPV = Phigh x NPVhigh + Paverage x NPVaverage​​​​ + Plow x NPVlow​​​ = 30% x 41.90 + 40% x 4.06 + 30% x (- 32.70) = 4.60

Part (2)

Features leading to hesitation:

  • Very high risk of the project evident in high beta
  • 30% probability of low demand leading to a low annual cash inflows

Part (3)

After waiting for 1 year, the demand will be certain and the firm will undertake the project only if it has positive NPV. That means the firm will undertake the project only if demand is high or average. It will not undertake the project if demand is low.

Hence, expected NPV after one year i.e. at t= 1 will be = Phigh x NPVhigh + Paverage x NPVaverage​​​​ = 30% x 41.90 + 40% x 4.60 = 14.41

Hence, NPV today = NPV after 1 year / (1 + R) = 14.41 / (1 + 10%) = 13.10


Related Solutions

You are evaluating the following project. All $ are in millions Initial cost of the project...
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...
Dell is evaluating a project which has the initial cost of $10,000 and generates the following...
Dell is evaluating a project which has the initial cost of $10,000 and generates the following cash flow/ Year 1 2 3 4 5 Cash Flow 5,000 3,000 4,000 8,000 10,000 The firm's cost of capital is 10%. Calculate NPV, PI, IRR, MIRR, discounted payback, and payback period
A). You are evaluating a project with the following cash flows: initial investment is $-12, and...
A). You are evaluating a project with the following cash flows: initial investment is $-12, and the expected cash flows for years 1 - 3 are $10, $11 and $17 (all cash flows are in millions of dollars). What is this projects NPV? The company's WACC is 10%. B). You are evaluating a project with an initial investment of $16.9 million dollars, and expected cash flows of $7 million dollars each for years 1-3. What is the project's simple payback?...
10) Make a benefit/cost analysis by evaluating B/C for the following: a) a project with initial...
10) Make a benefit/cost analysis by evaluating B/C for the following: a) a project with initial cost = $7,254 , annual cost= $868, annual benefits= $ 1,867, disbenefits having a present worth PW value of $1,613, interest rate= 9% and life = 5 years b) a project with initial cost = $2,126 , annual cost= $1,806, annual benefits= $ 1,434, annual disbenefits= $408, interest rate= 3% and life = 9 years. c) a project with total annual cost= $7,744, annual...
You are evaluating a project with the following cash flows: initial investment is $-23, and the  expected...
You are evaluating a project with the following cash flows: initial investment is $-23, and the  expected cash flows for years 1 - 3 are $12, $9 and $8 (all cash flows are in millions of dollars). What is this projects NPV? The company's WACC is 9%. Express your answer in millions of dollars, rounded to 2 decimals and without the dollar sign. So, if your answer is 23.5678, just enter 23.57.
You are evaluating a project for your company. The initial outlay for the project is $5,000,000,...
You are evaluating a project for your company. The initial outlay for the project is $5,000,000, and free cash flows for the project are $1,000,000, $3,000,000, $3,000,000, $4,000,000 and $4,000,000. For risk analysis, you utilize the Payback and Discounted Payback methods to trigger increased risk scrutiny. Your standard is, any project that goes longer than 3 years under either metric will go through these increased risk tests. If your required rate is 12%, does this project qualify for increased scrutiny?...
You are evaluating a project and during the initial evaluation you determine that there are nine...
You are evaluating a project and during the initial evaluation you determine that there are nine states that could occur along two variables. The first variable is the cost of money, and you predict the following costs and probabilities: -- the company could borrow at a weighted average cost of capital of 8% -- this has a 25% chance of occurring -- the company could borrow at a weighted average cost of capital of 9%-- this has a 40% chance...
You are evaluating a project based on the following: Initial Investment: $1,250,000 Cash Flows: $275,000 per...
You are evaluating a project based on the following: Initial Investment: $1,250,000 Cash Flows: $275,000 per year for 5 years (end of year) Required Return: 10% Required Payback: 5 Years 1. Would you accept or reject the project based on the Net Present Value (NPV)? 2. Would you accept or reject the project based on the Payback Period? 3. Would you accept or reject the project based on the Discounted Payback Period? 4. Based on your answers to Questions 1-3,...
You are analyzing a project with an initial cost of £48,000. The project is expected to...
You are analyzing a project with an initial cost of £48,000. The project is expected to return £11,000 the first year, £36,000 the second year and £38,000 the third and final year. There is no salvage value. The current spot rate is £0.6211. The nominal return relevant to the project is 12 percent in the U.S. The nominal risk-free rate in the U.S. is 4 percent while it is 5 percent in the U.K. Assume that uncovered interest rate parity...
You are evaluating a mining project that will require an initial investment outlay (time 0) of...
You are evaluating a mining project that will require an initial investment outlay (time 0) of $700,000. The project will generate cash flows of $200,000 in Year 1, $300,000 in Year 2, and $400,000 in Year 3. There are no cash flows beyond Year 3. Show work in excel A. What is the NPV of the project at a discount rate of 10%? Explain calculations. B. What is the IRR of the project? Explain calculations. C. Should you invest in...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT