In: Finance
A.i)Calculation of cost of equity as per CAPM
Cosy of equity(Ke)=Risk free rate+Beta(Market rate of return-Risk free rate)
=8%+1.5(15%-8%)
=18.50%
ii)Calculation of after tax cost of debt(Kd)
Kd=Interest(1-tax rate)
=10%(1-0.20)=8%
iii)Calculation of WACC
Weight of debt(Wd)=40% or 0.40
Weight of equity(We)=(1-Weight of debt)
=1-0.40=0.60
WACC=Ke*We+Kd*Wd
=18.50%*0.60+8%*0.40
=14.30%
iv)Calculation of NPV
Discount rate=WACC=14.30%
NPV=Present value of cash inflows-Present value of cash outflows
Year | Cash flow(GH₵) (a) | Present value [email protected]% (b) | Present value(a*b) |
0 | (100,000) | 1 | (100,000) |
1 | 20,000 | 0.875 | 17,500 |
2 | 25,000 | 0.765 | 19,125 |
3 | 32,000 | 0.670 | 21,440 |
4 | 35,000 | 0.586 | 20,510 |
Net Present value(NPV) | (21,425) |
v)Calculation of IRR of the project
IRR is the rate at which NPV of the project is zero
Since the NPV at 14.30% is negative,hence IRR must be lower than 14.30%.Lets calculate the NPV at 2%
Year | Cash flow(GH₵) (a) | Present value factor@2% (b) | Present value(a*b) |
0 | (100,000) | 1 | (100,000) |
1 | 20,000 | 0.980 | 19,600 |
2 | 25,000 | 0.961 | 24,025 |
3 | 32,000 | 0.942 | 30,144 |
4 | 35,000 | 0.924 | 32,340 |
Net Present value(NPV) | 6,109 |
Since the NPV at 2% is positive, hence IRR must be between 2% and 14.30%.IRR shall be calculated as follows;
IRR=Lower rate+[NPV at lower rate/Present value of cash inflows at(Lower rate-Higher rate)]*Higher rate-lower rate]
=2%+[6,109/(106109-78,575)]*(14.30%-2%)
=2%+2.73%
=4.73%
vi)Since the NPV of the Project at WACC is negative and also IRR is lower than the WACC,hence the project is not viable.