Internal rate of return: Difference between revisions
imported>Administrator (CSV import) |
imported>Doug Williamson (Spacing, formatting, punctuation and subheadings.) |
||
| Line 1: | Line 1: | ||
(IRR). | (IRR). | ||
1. | |||
'''1.''' | |||
The internal rate of return of a set of cash flows is the cost of capital which, when applied to discount all of the cash flows (including any initial investment flow at Time 0) results in a Net Present Value (NPV) of NIL. | The internal rate of return of a set of cash flows is the cost of capital which, when applied to discount all of the cash flows (including any initial investment flow at Time 0) results in a Net Present Value (NPV) of NIL. | ||
For an investor, the IRR of an investment proposal therefore represents their expected rate of return on their investment in the project. | For an investor, the IRR of an investment proposal therefore represents their expected rate of return on their investment in the project. | ||
For example a project requires an investment today of $100m, with $110m being receivable one year from now. | |||
'''''Example''''' | |||
For example, a project requires an investment today of $100m, with $110m being receivable one year from now. | |||
The IRR of this project is 10%, because that is the cost of capital which results in an NPV of $0, as follows: | The IRR of this project is 10%, because that is the cost of capital which results in an NPV of $0, as follows: | ||
PV of Time 0 outflow $100m = $(100m) | PV of Time 0 outflow $100m = $(100m) | ||
PV of Time 1 inflow $110m = $110m x 1.1<sup>-1</sup> = $100m | PV of Time 1 inflow $110m = $110m x 1.1<sup>-1</sup> = $100m | ||
2. | NPV = -$100m + $100m | ||
= '''$0'''. | |||
'''2.''' | |||
It is normally only possible to determine IRR by trial and error (iterative) methods. | It is normally only possible to determine IRR by trial and error (iterative) methods. | ||
For example using straight line interpolation and the following data: | |||
First estimated rate of return 5%, NPV $+4m; and | '''''Example''''' | ||
Second estimated rate of return 6%, NPV $-4m | |||
The straight-line-interpolated estimated IRR is the mid-point between 5% and 6% | For example, using straight line interpolation and the following data: | ||
First estimated rate of return 5%, positive NPV = $+4m; and | |||
Second estimated rate of return 6%, negative NPV = $-4m. | |||
The straight-line-interpolated estimated IRR is the mid-point between 5% and 6%. | |||
This is '''5.5%'''. | |||
Using iteration, the straight-line estimation process could then be repeated, using the value of 5.5% to recalculate the NPV, and so on. | Using iteration, the straight-line estimation process could then be repeated, using the value of 5.5% to recalculate the NPV, and so on. | ||
| Line 25: | Line 48: | ||
The IRR function in Excel uses a similar trial and error method. | The IRR function in Excel uses a similar trial and error method. | ||
A more refined decision rule is that | '''3.''' | ||
In simple IRR project analysis the decision rule would be that: | |||
(1) All opportunities with above the required IRR should be accepted. | |||
(2) All other opportunities should be rejected. | |||
However this assumes the unlimited availability of further capital with no increase in the cost of capital. | |||
A more refined decision rule is that: | |||
(1) All opportunities with IRRs BELOW the required IRR should still be REJECTED; while | |||
(2) All other opportunities remain eligible for further consideration (rather than automatically being accepted). | |||
== See also == | == See also == | ||
| Line 42: | Line 80: | ||
* [[Shareholder value]] | * [[Shareholder value]] | ||
* [[Yield to maturity]] | * [[Yield to maturity]] | ||
Revision as of 11:15, 11 June 2013
(IRR).
1.
The internal rate of return of a set of cash flows is the cost of capital which, when applied to discount all of the cash flows (including any initial investment flow at Time 0) results in a Net Present Value (NPV) of NIL.
For an investor, the IRR of an investment proposal therefore represents their expected rate of return on their investment in the project.
Example
For example, a project requires an investment today of $100m, with $110m being receivable one year from now.
The IRR of this project is 10%, because that is the cost of capital which results in an NPV of $0, as follows:
PV of Time 0 outflow $100m = $(100m)
PV of Time 1 inflow $110m = $110m x 1.1-1 = $100m
NPV = -$100m + $100m
= $0.
2.
It is normally only possible to determine IRR by trial and error (iterative) methods.
Example
For example, using straight line interpolation and the following data:
First estimated rate of return 5%, positive NPV = $+4m; and
Second estimated rate of return 6%, negative NPV = $-4m.
The straight-line-interpolated estimated IRR is the mid-point between 5% and 6%.
This is 5.5%.
Using iteration, the straight-line estimation process could then be repeated, using the value of 5.5% to recalculate the NPV, and so on.
The IRR function in Excel uses a similar trial and error method.
3.
In simple IRR project analysis the decision rule would be that:
(1) All opportunities with above the required IRR should be accepted.
(2) All other opportunities should be rejected.
However this assumes the unlimited availability of further capital with no increase in the cost of capital.
A more refined decision rule is that:
(1) All opportunities with IRRs BELOW the required IRR should still be REJECTED; while
(2) All other opportunities remain eligible for further consideration (rather than automatically being accepted).
