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.

The Bottom Line . Using Excel to calculate the internal rate of return requires the IRR function and reference cells that list the cash flows for a series of periods, plus an optional guess for ...

IRR on Microsoft Excel. We will use the same example we used above. Open Excel and enter -100 (that is negative 100) in cell A1, 0 (that is zero) in A2 and 132.25 in A3.

Find the IRR in Excel by employing the IRR function, then use it as the discount rate that causes NPV to equal zero. Use What-If analysis, a built-in calculator in Excel, to solve for the discount ...

If you want to calculate IRR using Excel, you can use the IRR function, which is IRR(values, [guess]). Aly J. Yale Her work has been published in Forbes, Money Magazine, Bankrate, The Motley Fool ...

The Difference Between Yield and IRR Calculations in Excel. When it comes to calculating interest rates for investments and bonds, the Yield and IRR formulas in Excel can quickly become your friends.

How to Use Excel to Calculate a Bond's Yield to Call. Bonds are investment vehicles that make regular coupon payments until maturity, at which time the bond's face value is paid.

In Excel, you can use the program's XIRR function to solve for "r" -- the IRR -- for each project. The XIRR function first asks for the dates, followed by the cash flows, and then a guess at the ...