In: Finance
A company project has an initial cost of $40,000, expected net cash flows of $9,000 per year for 7 years. The company has a target capital structure of 10% short term debt at an interest rate of 6.0%, 50% long term debt at an interest rate of 9.0%, and 40% equity with a cost of 18%. The company’s tax rate is 28%.
a. What is the WACC to be used when evaluating this project?
b. What is the projects NPV, IRR, PB, DPB?
c. What is the projects PI?
a. WACC =Weight of Short term debt *Cost of Debt*(1-tax
rate)+Weight of long term debt *Cost of Debt*(1-tax rate)+Weight of
equity*Cost of equity =10%*6%*(1-28%)+50%*9%*(1-28%)+40%*18%
=10.872%
b. NPV =PV of Cash Flows-Initial Investment
=9000*((1-(1+10.872%)^-7)/10.872%)-40000 =2585.73
Using excel to calculate IRR,PB
A | B | C | D | E | F | G | H | I | J | |
Year | 0.00 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 |
Project A | -40000.00 | 9000 | 9000 | 9000 | 9000 | 9000 | 9000 | 9000 | 9000 | 9000 |
Cumulative Cash flow | -40000.00 | -$31,000.00 | -$22,000.00 | -$13,000.00 | -$4,000.00 | $5,000.00 | $14,000.00 | $23,000.00 | $32,000.00 | $41,000.00 |
IRR | 17.04% | IRR(A2:J2) | ||||||||
Payback Period | $4.44 | 4+4000/9000 |
A | B | C | D | E | F | G | H | I | J | |
Year | 0.00 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 |
Project A | -40000.00 | 9000 | 9000 | 9000 | 9000 | 9000 | 9000 | 9000 | 9000 | 9000 |
Discounted Cash flow | -40000.00 | 8117.47 | 7321.48 | 6603.54 | 5956.00 | 5371.96 | 4845.19 | 4370.08 | 3941.55 | 3555.05 |
Cumulative Cash flow | -40000.00 | -$31,882.53 | -$24,561.05 | -$17,957.51 | -$12,001.51 | -$6,629.54 | -$1,784.35 | $2,585.73 | $6,527.28 | $10,082.33 |
Discounted Payback Period | $6.41 | (6+1784.35/4370.08) |
c. PI =1+NPV/Investment =1+2585.73/40000 =1.06