Thread: IRR
View Single Post
  #13   Report Post  
Posted to microsoft.public.excel.worksheet.functions
joeu2004 joeu2004 is offline
external usenet poster
 
Posts: 2,059
Default IRR

Oops....

On Jan 24, 9:31*am, I wrote:
The terms of the NPV formula include the factor 1/(1+i)^n.
If i = -100%, the factor is incalculable. *If i < -100%,
we can calculate the factor only for even-numbered cash flows.


That's only half right (i = -100%). No problem with i < -100% as long
n = 0 and n = 1.

(When I say "no problem", I mean the factor can be calculated. I'm
not sure it makes sense for the sign of the denominator to alternate.)