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.

Method Two Let’s assume that we didn’t calculate the IRR of 57% as we did above and have no idea what the correct discount rate is. We can use Excel’s What-If calculator in this case.

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.

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.

Thankfully your handy spreadsheet program can make quick work of this problem. Using Excel to calculate IRR with unequal timing of cash flows ...

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

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.

IRR Examples Let us use a couple of examples to show you how simple the IRR concept is. If you invested $100 and at the end of one year you recouped a total of $115 then the IRR would be 15%.