Calculators     Interest FAQ     Directory     Excel templates     

 irr calculation
Theory of Interest   Introduction   Net Present Value   Internal Rate of Return   IRR in Practice   Limitation of the IRR
Internal Rate of Return

The IRR - the net present value approaches zero

Net Yields:137866  
Installment Credits:84383  
Net Present Values:73812  
Savings Plans:24670  
Performance of the system
Computation of the internal rate of return(IRR)

The fundamental calculation of interest

On the previous page I have tried to explain how the net present value (NPV) of a sequence of payments is calculated from a comparison net yield and the dates of the payments.

To compute the yield of a security we have to do many calculations of the net present value. We thereby have to find that comparison yield where the NPV of the security is zero. This is the net yield of the security.

The formula of the net present value was:
NBW(B, t, r) = Sum B[i]/(1+r)^t[i]

The NPV should become zero. Unfortunately one cannot solve and compute this equation easily after r. One must start with a value of r and change it in such a way, that the NPV approaches zero. Repeating a calculation many times to find a maximum or minimum is called iteration or a iterative procedure. With this procedure one can receive the net yield from payment sequences that follows no rules. The net yield is a very good measure for the success of investments. Naturally, this method has also its limitations.

read further-->

  Analysis - Internal Rate of Return (IRR)
  Internal rate of return (IRR)
  Return on Investment (ROI)

The information on this page is not sufficient? Search the web with new keywords.
Theory site with articles from many contributors, which are specialists in the different topics.

Modified Internal Rate Of Return - MIRR
The MIRR more accurately reflects the profitability of a project.

Economics Interactive Tutorial
Perils of the Internal Rate of Return.

Internal rate of return: A cautionary tale
Article about the limitations of the IRR-method.

Performance of the system    about IRRQ    Contact form    Disclaimer

Mistakes? Help to improve this page.

Valid HTML 4.01 Transitional