How to calculate irr manually
Internal Rate of Return (IRR) is a financial metric commonly used by investors and financial analysts to assess the profitability of an investment project. It represents the annualized rate of return at which the net present value (NPV) of cash flows from an investment becomes zero. To calculate IRR manually, you can use either the trial-and-error method or the interpolation method. This article provides a step-by-step guide on how to calculate IRR manually using both methods.
1. Trial-and-Error Method
Step 1: List down all the cash flows
Prepare a list of all cash inflows and outflows associated with the investment project, including the initial investment and any revenues generated throughout its lifetime.
Step 2: Choose an initial guess for IRR
Select an initial percentage as your first guess for the IRR. A common starting point is to assume a 10% IRR as most investors seek returns higher than that.
Step 3: Calculate NPV
Using your initial guess for IRR, calculate the NPV of the investment project using the following formula:
NPV = Σ[(CFi) / (1+IRR)^i] – Initial Investment
Where CFi is the cash flow in year i, and i is the year number.
Step 4: Adjust your IRR guess
If your calculated NPV is greater than zero, increase your IRR guess. If it’s less than zero, decrease your IRR guess.
Step 5: Repeat steps 3 and 4 until NPV is close to zero
Keep adjusting your IRR guess and recalculating NPV until you reach an NPV value that’s very close to zero. The corresponding IRR will be your final estimated value for Internal Rate of Return.
2. Interpolation Method
This method is faster and more accurate than the trial-and-error method, especially for investments with irregular cash flows. You’ll need a spreadsheet software like Excel or Google Sheets for this method.
Step 1: List down all the cash flows
List all cash inflows and outflows associated with the investment project in a column of your spreadsheet.
Step 2: Calculate NPV at two different discount rates
Choose two discount rates, say, 10% and 20%, to calculate NPV for each rate using the following formula:
NPV = Σ[(CFi) / (1 + Discount Rate)^i] – Initial Investment
Step 3: Apply interpolation formula
Apply the linear interpolation formula to estimate IRR using the calculated NPVs. The formula is:
IRR = Lower Discount Rate + [(Higher Discount Rate – Lower Discount Rate) x (0 – NPV at Lower Discount Rate)] /
(NPV at Higher Discount Rate – NPV at Lower Discount Rate)
Step 4: Confirm the IRR value
Use the estimated IRR value to calculate the project’s NPV. If it’s very close to zero, you’ve found an accurate IRR.
In conclusion, calculating IRR manually may be time-consuming and challenging. However, it’s a valuable skill for understanding investment profitability and making informed decisions. Whether you use the trial-and-error method or interpolation method, having a clear understanding of IRR calculations is essential in any financial analysis.