View Single Post
  #2   Report Post  
kevwags kevwags is offline
Junior Member
 
Posts: 2
Default

In case anyone cares I solved this myself. I think it's just a bug in excel.

The first nominal value I was using of -0.0001 to start the CF's with a negative value I changed to -5. Luckily my CF's are 100k or larger so the IRR will not be affected. This small change in combination with the SIGN guess logic described above fixed the problem....

I guess sometimes guess and check is the best way when you are dealing with an excel bug workaround.