| 10-Oct-02 | G Drive 'Irr' | |||
| IRR Examples-- Student Loan to a Professor | ||||
| Case A | ||||
| Loan Amount | $1,000 | |||
| Year | ||||
| 1 | $1,200 | |||
| -$1,000 + $1,200/(1+irr)^1 = 0 | ||||
| irr = | 20% | |||
| Case B | ||||
| Loan Amount | $1,000 | |||
| Year | ||||
| 1 | $0 | |||
| 2 | $1,200 | |||
| -$1,000 + 0/(1+irr)^1 + $1,200/(1+irr)^2 = 0 | ||||
| irr = sqrt(1.2) - 1 | 9.5% | 1.095445 | ||
| Case C | ||||
| Loan Amount | ($1,000) | |||
| Year | ||||
| 1 | $200 | |||
| 2 | $1,200 | |||
| -$1,000 + 200/(1+irr)^1 + $1,200/(1+irr)^2 = 0 | ||||
| Trial 1 | irr = 15% | |||
| -$1,000 + 200/(1.15) + 1200/(1.15)^2 = 0 | 173.913 | |||
| 907.3724 | ||||
| -1000 + 173.91 + 907.37 = 0 | ||||
| 1081.285 | ||||
| -1000 + 1081 > 0 | ||||
| Trial 2 | irr = 20% | |||
| -$1,000 + 200/(1.20) + 1200/(1.20)^2 = 0 | 166.6667 | |||
| 833.3333 | ||||
| -1000 + 166.67 + 833.33 = 0 | ||||
| 1000 | ||||
| -1000 + 1000 = 0 | Q.E.D. | |||