The best software product for preparing business plans in Word and Excel format
Strategic-Line Harmony of planning in your business

Internal rate of return – IRR


The discount rate at which the total present value of income from investments is equal to the value of these investments. IRR is calculated as the discount rate at which NPV = 0.

    Discount rate at which the total present value of income from investments is equal to the value of these investments. Budget-Plan Express calculates all key performance indicators of investments
    IRR is calculated as the value of the discount rate at which NPV=0. Budget-Plan Express calculates all key performance indicators of investments

To find IR, the program uses a cyclic algorithm with an accuracy of 10-2 percentages, the calculations use the discount step specified by the user (month, quarter, year).

IRR defines the maximum cost of the attracted capital, at which the investments in the project remain profitable:
  1. when NPV > 0, in this case IRR > r;
  2. when NPV < 0, in this case IRR is not defined;
  3. when NPV = 0, in this case IRR = r.
Calculation of the algorithm ends when the IRR value is 1000%. Also, in the case when ∑CFn (1 + r)-n = 0 or ∑In (1 + r)-n = 0, IRR is not calculated.

Internal rate of return is the second indicator after NPV, on the basis of which the attractiveness of investments is determined.

☛ Note that only the net cash flow (NCF) is used to calculate the internal rate of return of IRR and the modified internal rate of return of MIRR. Also, the result of calculations is influenced by the discounting step chosen by the user.

Budget-Plan Express is a software product for preparing business plans and presentations in Word and Excel format - for small businesses and studies (students, MBI students, etc.)

Calculate project performance indicators (РВ, DPB, NPV, PI, IRR and others) in the new version of the program (6.02) More ...



Оплатите лицензию в личном кабинете Select your Budget-Plan Express licenses and pay in your personal account - in rubles or other currency






Share:
Copyright © 2007-, support@strategic-line.ru: send a message