How to Manually Calculate an IRR

Written by paige turner | 13/05/2017
How to Manually Calculate an IRR
IRR indicates the quality of the investment. (Ryouchin/Digital Vision/Getty Images)

Internal rate of return -- or IRR -- is the discounted cash flow rate of return and is used to determine the profitability of different projects. The internal rate of return on a project that produces cash flows over time is the interest rate that makes the net present value of the cash flows equal to zero.

Calculate the Net Present Value (NPV) using the following formula:


Sum C[i]/(1+d)^t[i] = NPV(C, t, d)


in which d is the estimated discount rate, C[i] is the i-th cash flow, N is the total number of cash flows + 1 and t[N] is the total length of time under consideration.

Determine whether your cash flows are negative or positive by identifying the direction of cash flow. If the cash flows into the project, it can be given a positive sign for the calculation. If the cash flows out of the project, it can be given a negative sign for the calculation.

Calculate IRR iteratively using the trial-and-error method by setting NPV(C,t, IRR) = 0. Pick a value for IRR and plug it into the NPV calculation. If NPV doesn't equal to zero with this value, keep picking values iteratively until NPV is as close to zero as possible.

Repeat the calculation for different assumed discount rates to get a more accurate view of the value of IRR over a range of possible discount rates.

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.