Calculating Internal Rate of Return

￿￿3UHVV￿*&￿￿VWRUH￿QXPEHU￿RI￿SHULRGV￿SHU￿\HDU￿LQ￿3￿<5￿

￿￿(QWHU￿WKH￿FDVK￿IORZV￿XVLQJ￿,￿DQG￿C￿

￿￿3UHVV￿*9￿

:KHQ￿\RX￿FDOFXODWH￿,55￿<5￿￿\RX￿JHW￿WKH￿DQQXDO￿QRPLQDO￿UDWH￿WKDW￿JLYHV￿ DQ￿139￿RI￿]HUR￿

7KH￿IROORZLQJ￿H[DPSOH￿XVHV￿WKH￿FDVK￿IORZV￿WKDW￿ZHUH￿HQWHUHG￿LQ￿WKH￿SUHYLRXV￿H[DPSOH￿

0RUH￿WKDQ￿RQH￿,55￿<5￿FDQ￿H[LVW￿￿,I￿\RX￿JHW￿WKH￿No Solution￿PHVVDJH￿VHH￿ $SSHQGL[￿%￿￿SDJH ￿￿￿￿￿

Example. ,I￿WKH￿VHOOHU￿RI￿WKH￿FRQWUDFW￿LQ￿WKH￿SUHYLRXV￿H[DPSOH￿ZDQWV￿￿￿￿￿￿￿￿￿DQG￿\RX￿DFFHSW￿WKDW￿SULFH￿￿ZKDW￿LV￿\RXU￿\LHOG"￿7KLV￿LV￿DQ￿,55￿<5￿

FDOFXODWLRQ￿WKDW￿UHTXLUHV￿D￿VOLJKW￿PRGLILFDWLRQ￿WR￿WKH￿FXUUHQWO\￿VWRUHG￿FDVK￿ IORZV￿

5,000

10,000

7,500

5,000

1

3

5

7

9

11

13

15

17

19

21

23

25

 

 

 

 

 

 

IRR/YR = ?

 

 

 

 

 

-28,000

 

 

 

 

 

 

 

 

 

 

 

Keys:

 

 

 

 

Display:

 

 

Description:

 

￿￿￿￿￿(*!

 

–28,000.00

 

 

&KDQJHV￿LQLWLDO￿FDVK￿IORZ￿

,￿￿

 

 

 

 

 

 

 

 

 

 

 

 

*9

 

 

 

 

12.49

 

 

&DOFXODWHV￿DQQXDO￿

 

 

 

 

 

 

 

 

 

QRPLQDO￿\LHOG￿

 

0RUH￿H[DPSOHV￿WKDW￿XVH￿139￿DQG￿,55￿<5￿FDOFXODWLRQV￿DUH￿JLYHQ￿LQ￿ FKDSWHU￿￿￿￿´$GGLWLRQDO￿([DPSOHV￿µ

6: Cash Flow Calculations 83