Excel's built-in XIRR function allows investors to input cash flows and their respective dates to get an accurate rate of return.

You can calculate XIRR on MS Excel using the symbol function. The formula syntax is: =XIRR (values, dates, [guess]) Wherein: Values are your investment and redemption amounts (inflows are negative ...