View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
IRR calculator IRR calculator is offline
external usenet poster
 
Posts: 1
Default What compounding assumption does excel use for its XIRR functi

Thanks for your help. I guess that I am still confused. I thought that
continous compounding was essentially another form of daily compounding.
Are you saying that it compounds as of each transaction date?

"Harlan Grove" wrote:

effective annual transformed to effective periodic as needed for any
nonannual periods, essentially equivalent to continuous compounding