View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Seth M Seth M is offline
external usenet poster
 
Posts: 2
Default XIRR versus IRR help!

Hi:

I am trying to figure out how to calculate the IRR of a series of
cashflows. There are 177 cashflows of $41,422, and the up-front cost
is $3,330,786. I tried using an IRR, but that just gives me an error I
think because there are too many cashflows. I used an XIRR, but this
compounds daily, and thus gives me a different result than an HP-12C.
Please advise!