Use IRR if your cash flows are regular (ie, every month). Use XIRR if they are
irregular.

--
Regards,
Fred


"MB Burgis" <MB wrote in message
...
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