View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MB Burgis
 
Posts: n/a
Default IRR formula for monthly cash flows

What is the best formula to use when calculating an IRR for monthly cash flows?

XIRR? or ((1+IRR(range,-0.01))^12)-1 ? or can just IRR be used?

Thank you