In: Finance
14.
Following is project A's cash flow table
Year |
Cash Flow |
0 |
-26,000 |
1 |
6,200 |
2 |
6,200 |
3 |
6,200 |
4 |
6,200 |
5 |
9,700 |
Assuming that the project is found by 40% of equity and 60% of debt. The required rate of return of equity is 10%. The yield of debt is 6% and the tax rate is 30%.
Using the above information to answer Q1 - Q4.
Q1) What is the WACC of this project?
a)6.52% |
||
b)4% |
||
c)7.43% |
||
d)5% |
Q2) What is the NPV of this project?
a) 2303.50 |
||
b) 2823.21 |
||
c) 2795.86 |
||
d) 2187.62 |
Q3) What is the IRR of this project?
a) 10.27% |
||
b) 9.54% |
||
c) 8.78% |
||
d) 9.23% |
Q4) Should we invest in this project?
a) No, because the project payback year is too long |
||
b) No, because the IRR is too low |
||
c) Yes, because the project NPV is greater than 0 |
||
d) Not sure |
1
Weight of equity = 1-D/A |
Weight of equity = 1-0.6 |
W(E)=0.4 |
Weight of debt = D/A |
Weight of debt = 0.6 |
W(D)=0.6 |
After tax cost of debt = cost of debt*(1-tax rate) |
After tax cost of debt = 6*(1-0.3) |
= 4.2 |
WACC=after tax cost of debt*W(D)+cost of equity*W(E) |
WACC=4.2*0.6+10*0.4 |
WACC =6.52% |
2
Project | ||||||
Discount rate | 6.520% | |||||
Year | 0 | 1 | 2 | 3 | 4 | 5 |
Cash flow stream | -26000 | 6200 | 6200 | 6200 | 6200 | 9700 |
Discounting factor | 1.000 | 1.065 | 1.135 | 1.209 | 1.287 | 1.371 |
Discounted cash flows project | -26000.000 | 5820.503 | 5464.235 | 5129.774 | 4815.785 | 7073.200 |
NPV = Sum of discounted cash flows | ||||||
NPV Project = | 2303.50 | |||||
Where | ||||||
Discounting factor = | (1 + discount rate)^(Corresponding period in years) | |||||
Discounted Cashflow= | Cash flow stream/discounting factor |
3
IRR is the rate at which NPV =0 | ||||||
IRR | 9.54% | |||||
Year | 0 | 1 | 2 | 3 | 4 | 5 |
Cash flow stream | -26000.000 | 6200.000 | 6200.000 | 6200.000 | 6200.000 | 9700.000 |
Discounting factor | 1.000 | 1.095 | 1.200 | 1.314 | 1.440 | 1.577 |
Discounted cash flows project | -26000.000 | 5659.965 | 5166.968 | 4716.913 | 4306.058 | 6150.097 |
NPV = Sum of discounted cash flows | ||||||
NPV Project = | 0.000 | |||||
Where | ||||||
Discounting factor = | (1 + discount rate)^(Corresponding period in years) | |||||
Discounted Cashflow= | Cash flow stream/discounting factor | |||||
IRR= | 9.54% |
4