In: Finance
You are a consultant to a large manufacturing corporation considering a project with the following net after-tax cash flows (in millions of dollars).
Years From Now | After-tax CF |
0 | -36 |
1-9 | 12 |
10 | 24 |
The project's beta is 1.5. Assuming rf = 4% and E(rm) = 12%
a. What is the net present value of the project? (Do not round intermediate calculations. Enter your answer in millions rounded to 2 decimal places)
b. What is the highest possible beta estimate for the project before its NPV becomes negative? (Do not round intermediate calculations. Round your answer to 2 decimal places).
We are given,
Beta = 1.5
rf = 4%
E(rm) = 12%
According to CAPM equation,
Return on Equity (r) = rf + Beta ( rm - rf)
r = 4% + 1.5 ( 12% - 4%)
r = 4% + 12% = 16%
Hence return on equity or discount rate is 16%.
Calculation of NPV
Yr | Cash Flow | Discounting factor (PV @ 16%) | PV of cashflow |
0 | -36 | 1.00000 | -36.00 |
1 | 12 | 0.86207 | 10.34 |
2 | 12 | 0.74316 | 8.92 |
3 | 12 | 0.64066 | 7.69 |
4 | 12 | 0.55229 | 6.63 |
5 | 12 | 0.47611 | 5.71 |
6 | 12 | 0.41044 | 4.93 |
7 | 12 | 0.35383 | 4.25 |
8 | 12 | 0.30503 | 3.66 |
9 | 12 | 0.26295 | 3.16 |
10 | 24 | 0.22668 | 5.44 |
NPV | 24.72 |
a) Hence NPV = $24.72 million.
b) highest possible beta estimate for the project before its NPV becomes negative?
NPV > 0 if IRR > discount rate
To calculate the highest possible β estimate (and therefore the highest possible discount rate) for a positive NPV, we will calculate the project's IRR.
By using Excel
IRR | 31.91% | (=IRR(All cash flows)) |
The highest Beta before the hurdle rate exceeds the IRR is
E(r) = rf + Beta ( rm - rf)
Beta = [0.3191 - 0.04] / [ 0.12 - 0.04] = 0.2791 / 0.08 = 3.49(approx)
Hence the highest possible beta estimate for the project before its NPV becomes negative is 3.49.
If you have any doubts please let me know in the comments. Please give a positive rating if the answer is helpful to you. Thanks.