Excel and Google Sheets have three functions to calculate the internal rate of return: IRR, XIRR, and MIRR. Learn how these functions can calculate investment returns.

If your investments in mutual funds are through the SIP route, then calculating the returns that your investments have earned may not be as simple as calculating the returns from a lump sum ...

Calculating the return One of the best methods for calculating an average return for a stock investment is the XIRR function in Excel.

If your expected return on the individual investments in your portfolio is known or can be anticipated, you can calculate the portfolio's overall rate of return using Microsoft Excel.

But Microsoft Excel makes it easy. Using the Extended Internal Rate of Return (XIRR) function, you can calculate returns from any investment where there are multiple inflows or outflows.