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.

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

Calculate the expected annual return of your portfolio in Microsoft Excel by using the value and expected rate of return of each investment.

Next, have Excel run the regression on the two columns of return data you generated. Under the Data menu, the Data Analysis button allows you to select Regression.