Doing so allows us to determine the internal rate of return (IRR) of a project or an asset. The IRR is the rate of growth that ... of capital. The Excel formula for calculating the discount ...

Meanwhile, CAGR shows the average annual growth rate, factoring in compound ... but you can also use Microsoft Excel. The program's XIRR function will calculate CAGR after you input the relevant ...