In: Finance
| What is the IRR of the following set of cash flows? |
| Year | Cash Flow |
| 0 | –$11,768 |
| 1 | 6,500 |
| 2 | 5,400 |
| 3 | 6,200 |
24.09%
25.36%
26.63%
25.87%
24.85%
| IRR is 25.36% as shown below | ||||
| Statement showing Cash flows | ||||
| Particulars | Time | PVf 25% | Amount | PV |
| Cash Outflows | - | 1.00 | (11,768.00) | (11,768.00) |
| PV of Cash outflows = PVCO | (11,768.00) | |||
| Cash inflows | 1.00 | 0.8000 | 6,500.00 | 5,200.00 |
| Cash inflows | 2.00 | 0.6400 | 5,400.00 | 3,456.00 |
| Cash inflows | 3.00 | 0.5120 | 6,200.00 | 3,174.40 |
| PV of Cash Inflows =PVCI | 11,830.40 | |||
| NPV= PVCI - PVCO | 62.40 | |||
| Statement showing Cash flows | ||||
| Particulars | Time | PVf 26% | Amount | PV |
| Cash Outflows | - | 1.00 | (11,768.00) | (11,768.00) |
| PV of Cash outflows = PVCO | (11,768.00) | |||
| Cash inflows | 1.00 | 0.7937 | 6,500.00 | 5,158.73 |
| Cash inflows | 2.00 | 0.6299 | 5,400.00 | 3,401.36 |
| Cash inflows | 3.00 | 0.4999 | 6,200.00 | 3,099.42 |
| PV of Cash Inflows =PVCI | 11,659.51 | |||
| NPV= PVCI - PVCO | (108.49) | |||
| NPV at 25% | 62.40 | |||
| NPV at 26% | (108.49) | |||
| Difference at 1%= 62.40 - (108.49) | 170.89 | |||
| IRR = 25% + 62.40/170.89*1% | ||||
| IRR = 25.36% | ||||