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.

Using Excel to calculate IRR with unequal timing of cash flows In the chart below, we have management's estimation for the initial cost and cash flow returns for both the expansion and new ...

Earlier, we had seen how the RATE function can be used to calculate the return on investments, whether lump-sum or periodic. This can come in handy in the calculation of SIP returns, too.

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