For those of you who like online tutorials, this video shows you how to calculate IRR on an HP12(c) calculator. Why Calculate Internal Rate of Return? It is important to calculate the expected internal rate of return so you may adequately compare investment alternatives. The investments made will be held until their maturity dates. The intermediate cash flows will be reinvested in IRR itself. All the cash flows are periodic in nature, or the time gaps between different cash flows are equal.; The IRR value provides the organization with a rate of growth that can be expected to be obtained by making an investment in the project considered. The internal rate of return, or IRR, shows managers the potential rate of return on an investment, adjusted for the time value of money. How to Calculate IRR in Excel. Using the IRR function in Excel makes calculating the IRR easy. Excel does all the necessary work for you, arriving at the discount rate you are seeking to find. The Internal Rate of Return (IRR) is the discount rate that makes the net present value (NPV) of a project zero. In other words, it is the expected compound annual rate of return that will be earned on a project or investment. The internal rate of return allows investments to be analyzed for profitability by calculating the expected growth rate of an investment’s returns and is expressed as a percentage. Calculate the Internal Rate of Return (IRR, discount rate) for any investment based on initial deposit and cash flow per period. Free IRR calculator online. IRR formula, how to calculate it and how to evaluate investments using it. How to Calculate an IRR in Excel. Businesses will often use the Internal Rate of Return (IRR) calculation to rank various projects by profitability and potential for growth. This is sometimes called the Discounted Cash Flow Method. Internal rate of return is a discount rate that is used in project analysis or capital budgeting that makes the net present value (NPV) of future cash flows exactly zero. Definition. The internal rate of return on an investment or project is the annualized effective compounded return rate or rate of return that sets the net present value of all cash flows (both positive and negative) from the investment equal to zero. Equivalently, it is the discount rate at which the net present value of the future cash flows is equal to the initial investment, and it is.