How to Calculate IRR by Hand

by Christopher Rosenbaum; Updated September 26, 2017
...

The internal rate of return (IRR) is used to evaluate how profitable a proposed project is when investigating options during capital budgeting decisions. When considering several projects for investment, the project with the higher IRRs are almost always selected over those with lower IRRs. IRR is the value at which a project returns a net present value (NPV) of zero. While calculating IRR is easier with a financial calculator or spreadsheet software, you can do it by hand using a trial and error process.

Create Table

Step 1

Make a table with "Period" and "Cash Flow" as column headers. Cash flow (CF) periods are typically done on a monthly or yearly basis.

Step 2

List period numbers in ascending order, starting with 0, until the number of periods for the project has been reached.

Step 3

List the cash flows for each period. Cash flows are typically done on a monthly or yearly basis. Be sure to include a negative value for cash flow at period 0, to represent initial cash outlay.

Setup Equation

Step 1

Write out the equation: NPV = CF(0) + CF(1)/(1+r) + CF(2)/(1+r)^2 + CF(3)/(1+r)^3 + CF(4)/(1+r)^4.... Keep going until the cash flow number matches the number of cash flows you have in the table. Note that the "^" indicates an exponential power.

Step 2

Substitute the cash flow value of period 0 for CF(0).

Step 3

Substitute the cash flow value of period 1 for CF (1). Repeat this for each period until all cash flow values are substituted.

Solve for r Using Trial and Error

Step 1

Pick an an arbitrary value for r. For example, 10 percent.

Step 2

Calculate the total for NPV as dictated by the operational signs in the formula. If NPV is positive, the value of r is too low and needs to be increased. If NPV is positive, the value of r is too high and must be decreased.

Step 3

Repeat until an NPV value of 0 is reached. When NPV equals 0, r represents the IRR of the project. Once the gap between two r-values is narrowed to one (e.g., 12 and 13 percent), decimal places are added to the r-value to give a more precise measure of NPV.

About the Author

Christopher Rosenbaum began writing a blog in 2008 for two newspapers, "The Independent" and the "Cedar Rapids Gazette." This blog was also published in Major League Baseball's MLBlogs.com. Rosenbaum earned his Master of Business Administration in management information systems and his Bachelor of Science in finance from The University of Tampa.

Photo Credits

  • financial calculations image by Albert Lozano from Fotolia.com