In: Finance
An investment that Kevin is considering offers the following cash flows.
Year 1 Initial investment of $10,000
Year 2 Inflow of $2,000
Year 3 Inflow of $1,500
Year 4 Additional investment of $5,000
Year 5 Inflow of $1,200
Year 6 Inflow of $2,200
Year 7 Inflow of 1,500
Year 8 Inflow of $1,000
Year 9 Inflow of $1,200
Year 10 Sale proceeds of $17,000
5. What is the internal rate of return (IRR) that this investment offers if all cash flows occur at the end of each period?
a. 10.10%
b. 10.87%
c. 9.24%
d. 9.74%.
| 10.8700% | ||
| Cash flows | Year | Discounted CF | 
| - | 0 | 0.00 | 
| (10,000.00) | 1 | -9019.57 | 
| 2,000.00 | 2 | 1627.05 | 
| 1,500.00 | 3 | 1100.65 | 
| (5,000.00) | 4 | -3309.13 | 
| 1,200.00 | 5 | 716.33 | 
| 2,200.00 | 6 | 1184.51 | 
| 1,500.00 | 7 | 728.44 | 
| 1,000.00 | 8 | 438.01 | 
| 1,200.00 | 9 | 474.08 | 
| 17,000.00 | 10 | 6057.71 | 
IRR = 10.87% (use IRR function in Excel)