Real Estate Articles Index

IRR Equation

The IRR, or the internal rate of return, is a method of capital budgeting that comes in handy when determining if it is appropriate to make a long term investment. The IRR Equation is frequently used by companies and firms that want to calculate the worthiness of a certain business or venture. The internal rate of return is actually the amount of money that comes from the invested assets and funds. The definition of the IRR is the discount rate that determines a zero NPV (net present value). The IRR and the NPV are related concepts, but are not one and the same. When using the IRR Equation it is always important to have an NPV that equals zero. Positive values of NPV are acceptable, but the negative NPV values may not be used.

A business is more profitable when its IRR is greater than any other IRR that could possibly come from other investments. So, when investing capital, it is essential to calculate the IRR and compare it to other figures to establish a comparative return. The IRR should be greater than the costs of the investment, and can add more value to the investing company or firm. The IRR Equation is a mathematic procedure that involves the time value of money by considering the cash flows over the duration of a certain project or investment.

The IRR Equation is the sum of the initial investment and the cash flows of each year that the project lasts, divided by 1 plus the IRR. This sum equals the NPV, which as mentioned earlier is zero.

The IRR Equation must look like this:

NPV=0= I+ cash flow year 1 +....+ cash flow year n (1+IRR)1 (1+IRR)n

In this equation, I stands for the initial investment, and n stands for the total number of years the project is intended to last. The cash flow of each year during the project is calculated as the real amount of money that the company or firm obtains in a year after having paid all the taxes and expenses of the investments.

The IRR Equation is actually a trial and error process, in which the discount rate is calculated so as the NPV is always at zero. To put it in other words, the IRR can be considered as being the limit acceptable discount rate that can obtain profit out of one project or investment. The IRR is considered also to be a break-even rate of return.

The IRR can also be calculated using a computer that was programmed to generate these values. You only have to introduce a few values and the program will do the job for you.

There are also several online calculators available that can do the IRR Equation in a matter of seconds. These calculators are reliable in giving approximate values so you can forecast whether or not the investment will be profitable.

All in all, the IRR Equation is not an easy one, but there are several methods in which you can calculate the internal rate of return more easily, and this can be of great help when it comes to investing in a profitable business.

If your not very good at using your HP12C calculator or you don’t have one, the great thing about the KISCL software is that it calculates the IRR for you. Check out this static screen shot showing you just how easy it is to not only calculate your IRR, but how easy it is to change numbers and see many ‘What If’ scenarios. Sample of the Loan Sizer Tool.