In: Finance
Project K costs $57,758.92, its expected cash inflows are $13,000 per year for 9 years, and its WACC is 9%. What is the project's IRR? Round your answer to two decimal places.
Let’s use trial and error method to compute IRR.
Let’s compute NPV at discount rate of 17 %
Year |
Cash Flow (C) |
Calculation of PV Factor |
PV Factor @ 17 % (F) |
PV(= F x C) |
0 |
($57,758.92) |
1/(1+17%)^0 |
1 |
($57,758.92) |
1 |
$13,000 |
1/(1+17%)^1 |
0.854700855 |
$11,111.11 |
2 |
$13,000 |
1/(1+17%)^2 |
0.730513551 |
$9,496.68 |
3 |
$13,000 |
1/(1+17%)^3 |
0.624370556 |
$8,116.82 |
4 |
$13,000 |
1/(1+17%)^4 |
0.533650048 |
$6,937.45 |
5 |
$13,000 |
1/(1+17%)^5 |
0.456111152 |
$5,929.44 |
6 |
$13,000 |
1/(1+17%)^6 |
0.389838592 |
$5,067.90 |
7 |
$13,000 |
1/(1+17%)^7 |
0.333195378 |
$4,331.54 |
8 |
$13,000 |
1/(1+17%)^8 |
0.284782374 |
$3,702.17 |
9 |
$13,000 |
1/(1+17%)^9 |
0.243403738 |
$3,164.25 |
NPV1 |
$98.441178 |
As NPV is positive let’s compute NPV at discount rate of 18 %.
Year |
Cash Flow (C) |
Calculation of PV Factor |
PV Factor @ 18 % (F) |
PV(= F x C) |
0 |
($57,758.92) |
1/(1+18%)^0 |
1 |
($57,758.92) |
1 |
$13,000 |
1/(1+18%)^1 |
0.847457627 |
$11,016.95 |
2 |
$13,000 |
1/(1+18%)^2 |
0.71818443 |
$9,336.40 |
3 |
$13,000 |
1/(1+18%)^3 |
0.608630873 |
$7,912.20 |
4 |
$13,000 |
1/(1+18%)^4 |
0.515788875 |
$6,705.26 |
5 |
$13,000 |
1/(1+18%)^5 |
0.437109216 |
$5,682.42 |
6 |
$13,000 |
1/(1+18%)^6 |
0.370431539 |
$4,815.61 |
7 |
$13,000 |
1/(1+18%)^7 |
0.313925033 |
$4,081.03 |
8 |
$13,000 |
1/(1+18%)^8 |
0.266038164 |
$3,458.50 |
9 |
$13,000 |
1/(1+18%)^9 |
0.225456071 |
$2,930.93 |
NPV2 |
($1,819.636236) |
IRR= R1+ [NPV1 x (R2-R1) %/( NPV1-NPV2)]
= 17 % + $ 98.44 x (18 % - 17 %)/ ($ 98.441178 - (-$ 1,819.636236)
= 17 % + $ 98.44 x (18 % - 17 %)/ ($ 98.441178 + $ 1,819.636236)
= 17 % + $ 98.441178 x 0.01/ $ 1,918.07741369
= 17 % + $ 0.98441178/$ 1,918.07741369
= 17 % + 0.00051323
= 17 % + 0.051323 %
= 17.05 %
IRR of the project is 17.05 %