Learn how to calculate the internal rate of return (IRR) in Excel and how it’s used to determine whether a capital investment can be profitable.

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