View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
joeu2004 joeu2004 is offline
external usenet poster
 
Posts: 2,059
Default IRR Calculation Frustrations

PS....

On Dec 3, 12:51*pm, I wrote:
But the real problem is: *the discount factor becomes 0 around
411,300,000,000%, and NPV still is not zero (0.000000207148 rounded).


Of course, 1/x is never zero. I forgot to mention that it becomes
zero because of the computational limitations of binary computer
arithmetic.