208 RATEOF RETURN ANALYSIS
Using a net present worth of 0, tryi=10%:
NPW =-100 +20(P/F,10%, 1) +30(P/F,10%,2) +20(P/F,10%,3)
- 40(P/F,10%,4) +40(P/F,10%, 5)
=-100 + 20(0.9091) + 30(0.8264) + 20(0.7513) + 40(0.6830)
+ 40(0.6209)
=-100 + 18.18 + 24.79 + 15.03 + 27.32 + 24.84
=-100 + 110.16=+10.16
The trial interest rateiis too low. Select a second trial,i=15%:
NPW=-100 + 20(0.8696) + 30(0.7561) + 20(0.6575) + 40(0.5718)
+ 40(0.4972)
= -100 + 17.39 + 22.68 + 13.15 + 22.87 + 19.89
=-100 + 95.98
=-4.02
FIGURE 7-1 Plot of NPW versus
interest ratei.
IS
'€ 10
~
fi'" S
~
Q.V 0
Z
...:..S
S%
These 10 and 15% points are plotted in Figure 7-1. By linear interpolation we compute the rate
of return as follows:.
, i
(
10.16
IRR=10% + (15% -10%) 10.1 + 4.02.. 6.. )-13.5%
- ..
We can prove that the rate of return is very close to 131/2%by showing that the
unrecovered investment is very close to zero at the end of the life of the investment.
--