IRR measures the rate needed to break even on an investment. Calculate IRR by setting NPV to zero and solving for the discount rate. Use Excel's IRR function by inputting initial cost and cash inflow.

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

Chris Gallant, CFA, is a senior manager of interest rate risk for ATB Financial with 10 years of experience in the financial markets. Suzanne is a content marketer, writer, and fact-checker. She holds ...

The internal rate of return, or IRR, is the interest rate that provides a net present value, or NPV, of future cash flows equal to the initial investment amount. Flip that definition around, and the ...