In: Finance
Suppose you pay $100, 000 now for a piece of equipment which earns you $50, 000 a year for the next 4 years. At the end of year 4, you can resell the piece of equipment for $30, 000. (a) What is the internal rate of return on this investment? (b) Suppose that you also have to pay $10, 000 in year 2 for a repair. What is the internal rate of return now?
a
| Equipment | |||||
| IRR is the rate at which NPV =0 | |||||
| IRR | 0.401690644 | ||||
| Year | 0 | 1 | 2 | 3 | 4 | 
| Cash flow stream | -100000 | 50000 | 50000 | 50000 | 80000 | 
| Discounting factor | 1 | 1.401691 | 1.964737 | 2.753953 | 3.8601902 | 
| Discounted cash flows project | -100000 | 35671.21 | 25448.7 | 18155.72 | 20724.368 | 
| NPV = Sum of discounted cash flows | |||||
| NPV Equipment = | 1.4461E-08 | ||||
| Where | |||||
| Discounting factor = | (1 + IRR)^(Corresponding period in years) | ||||
| Discounted Cashflow= | Cash flow stream/discounting factor | ||||
| IRR= | 40.17% | ||||
b
| Equipment | |||||
| IRR is the rate at which NPV =0 | |||||
| IRR | 0.369775698 | ||||
| Year | 0 | 1 | 2 | 3 | 4 | 
| Cash flow stream | -100000 | 50000 | 40000 | 50000 | 80000 | 
| Discounting factor | 1 | 1.369776 | 1.876285 | 2.57009 | 3.5204471 | 
| Discounted cash flows project | -100000 | 36502.33 | 21318.72 | 19454.57 | 22724.386 | 
| NPV = Sum of discounted cash flows | |||||
| NPV Equipment = | 0.000345499 | ||||
| Where | |||||
| Discounting factor = | (1 + IRR)^(Corresponding period in years) | ||||
| Discounted Cashflow= | Cash flow stream/discounting factor | ||||
| IRR= | 36.98% | ||||