Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I am getting conflicting (and confusing) results using the IRR and NPV
functions in Excel. Here is the cashflow data for each year: Year 1: (2,057) Year 2: 155,849 Year 3: 333,756 Year 4: 459,403 Year 5: 592,126 Year 6: 725,751 Year 7: 860,094 Year 8: 976,671 Year 9: 1,036,326 Year 10: 5,247,233 When I compute the IRR I come up with 7688%. However, knowing that the IRR should be the interest rate which makes the NPV = 0, when I use the NPV calculation I should be using 76.88%, not 7688%. Therefore, I am assuming I must divide the IRR result by 100 to get an appropriate IRR. Is this correct? Thanks for anyone's assistance. |