Internal Rate of Return RUMLO Barry Marshall-Kalina Internal Rate of Return This is an alternative accounting appraisal method within the Discounted Cash Flow family of methods. It aims to show a maximum value for the interest rate of a project. Consider the previous example that used 10%: the Net Present Value of this project was minus £214. If a different discount rate were chosen then the Net Present Value would become another figure. Reworking this example, but this time using a discount rate of 8%, it is found that the Net Present Value is now a positive one: £176. Cash Flows Discount Factor Present Values £ 8% £ End of Year 0 -10,000 1.000 -10,000 1 + 3,000 0.926 + 2,778 2 + 4,000 0.857 + 3,428 3 + 5,000 0.794 + 3,970 NET PRESENT VALUE = +176 Using a discount rate of 10% gives a negative NPV; using 8% gives a positive one. So, somewhere between 8% and 10% there is a discount rate that will produce an NPV equal to zero. And it is that discount rate that is called the INTERNAL RATE OF RETURN (IRR) of the project. The Internal Rate of Return is the discount rate of the project that will generate a Net Present Value equal to zero. Before spreadsheets became readily available the only way of calculating a project’s Internal Rate of Return was by trial and error. However, with spreadsheets they may be readily calculated. If no computer is handy then for a rough and ready answer interpolation may be used. In example 4, an 8% discount factor gives an NPV of = +£176 and a 10% discount factor gives an NPV of = -£214 So, a 2% discount swing produces a swing from positive to negative in the NPV of 176 176 + 214 = £390. The IRR must therefore be at 8% + ( /390)*2% = 8.9%. We’ll call this 9%. What does this 9% mean? It presents the maximum rate of interest that could be paid on funds borrowed to finance the investment for it to be worthwhile. So, if money can only be borrowed to fund the project at, say, 12% interest rates then the project is not economically viable. It’s like borrowing money at 12% and investing it at 9% - a good way of going bust. On the other hand if money can be borrowed at 4% then it is economic to use such money to fund a project that will be generating 9%. It is a sort of break-even figure. If money can be borrowed more cheaply than that, then go ahead; if it cannot, abandon the project. Of course, it should always be remembered that factors other than the purely economic and financial may quite legitimately affect the decision as to whether to go ahead with an investment or not.