Register now or log in to join your professional community.
IRR can be reach through the following process:
First find out Present Value:
PV = FV / (1+r)n
And let's use the formula:
Use the formula to calculate Present Value of $900 in3 years:
PV = FV / (1+r)n PV = $900 / (1 +0.10)3 = $900 /1.103 = $676.18 (to nearest cent).
The interest rate (r) is now6%, which is 0.06 as a decimal:
PV = FV / (1+r)n PV = $900 / (1 + 0.06)3 = $900 / 1.063 = $755.66 (to nearest cent). Net Present Value (NPV)Now we are equipped to calculate the Net Present Value.
For each amount (either coming in, or going out) work out its Present Value, then:
Like this:
Money Out: $500 now
You invest $500 now, so PV = -$500.00Money In: $570 next year
PV = $570 / (1+0.10)1 = $570 /1.10 = $518.18 (to nearest cent)And the Net Amount is:
Net Present Value = $518.18 - $500.00 = $18.18
So, at10% interest, that investment has NPV = $18.18
But your choice of interest rate can change things!
Money Out: $500 now
You invest $500 now, so PV = -$500.00Money In: $570 next year:
PV = $570 / (1+0.15)1 = $570 /1.15 = = $495.65 (to nearest cent)Work out the Net Amount:
Net Present Value = $495.65 - $500.00 = -$4.35
So, at15% interest, that investment has NPV = -$4.35
It has gone negative!
Now it gets interesting ... what Interest Rate would make the NPV exactly zero? Let's try14%:
Money Out: $500 now
You invest $500 now, so PV = -$500.00Money In: $570 next year:
PV = $570 / (1+0.14)1 = $570 /1.14 = $500 (exactly)Work out the Net Amount:
Net Present Value = $500 - $500.00 = $0
Exactly zero!
At14% interest NPV = $0
And we have discovered the Internal Rate of Return ... it is 14% for that investment.
Because14% made the NPV zero.
Internal Rate of ReturnSo the Internal Rate of Return is the interest rate that makes the Net Present Value zero.
The discount rate often used in capital budgeting that makes the net present value of all cash flows from a particular project equal to zero. Generally speaking, the higher a project's internal rate of return, the more desirable it is to undertake the project. As such, IRR can be used to rank several prospective projects a firm is considering. Assuming all other factors are equal among the various projects, the project with the highest IRR would probably be considered the best and undertaken first.
Calculating IRRThe simplest example of computing an IRR is by using the example of a mortgage with even payments. Assume an initial mortgage amount of $200,000 and monthly payments of $1,050 for30 years. The IRR (or implied interest rate) on this loan annually is4.8%. Because the a stream of payments is equal and spaced at even intervals, an alternative approach is to discount these payments at a4.8% interest rate, which will produce a net present value of $200,000. Alternatively, if the payments are raised to, say $1,100, the IRR of that loan will rise to5.2%.The formula for IRR, using this example, is as follows: