<prompt> Human: Is there an easy way in excel to calculate the rate of return on a 401k? My 401k is through Fidelity and they list the return in the portal, but I am curious how they arrived at that return rate.  <response>: XIRR function on two columns of info using dates and amounts of your contributions. In last row enter todays date and current value, using opposite sign by convention. 