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.

Learn how to calculate the discount rate in Microsoft Excel, what the discount factor is, and how the discount rate and discount factor compare.

When it comes to calculating interest rates for investments and bonds, the Yield and IRR formulas in Excel can quickly become your friends. Whether you're considering buying a bond or investing in ...

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 ...

Calculating the IRR, or an investment’s expected annual rate of growth, is no easy task for investors. Find the formula and tips for calculating IRR.

Next, in the IRR function, in the Values field, select the array of cells that contains the values of the payments and receipts for which you want to calculate the IRR. In our example, it is A1:A13.