Linear interpolation: Difference between revisions
imported>Administrator (CSV import) |
imported>Doug Williamson m (Spacing 22/8/13) |
||
| Line 2: | Line 2: | ||
For example, consider a set of cashflows which has a net present value (NPV) of +$4m at a yield of 5%, and an NPV of -$4m at a yield of 6%. | For example, consider a set of cashflows which has a net present value (NPV) of +$4m at a yield of 5%, and an NPV of -$4m at a yield of 6%. | ||
Using linear interpolation, the estimated yield at which the cashflows have an NPV of $Nil is given by: | Using linear interpolation, the estimated yield at which the cashflows have an NPV of $Nil is given by: | ||
5% + [+4/(+4 --4 = +8)] x (6 - 5)% = 5.5%. | 5% + [+4/(+4 --4 = +8)] x (6 - 5)% = 5.5%. | ||
5.5% is the estimated internal rate of return (IRR) of the cashflows. | 5.5% is the estimated internal rate of return (IRR) of the cashflows. | ||
Interpolation is often used in conjunction with Iteration. | Interpolation is often used in conjunction with Iteration. | ||
Using iteration the straight-line estimated IRR of 5.5% would then be used, in turn, to recalculate the NPV at the estimated IRR of 5.5%, producing a recalculated NPV even closer to $0. | Using iteration the straight-line estimated IRR of 5.5% would then be used, in turn, to recalculate the NPV at the estimated IRR of 5.5%, producing a recalculated NPV even closer to $0. | ||
5.5% and the recalculated NPV would then be used with interpolation once again to further refine the estimate of the IRR. | 5.5% and the recalculated NPV would then be used with interpolation once again to further refine the estimate of the IRR. | ||
This iteration process can be repeated as often as required until the result converges on a sufficiently stable final figure. | This iteration process can be repeated as often as required until the result converges on a sufficiently stable final figure. | ||
Another closely related linear estimation technique is | |||
Another closely related linear estimation technique is extrapolation. | |||
This involves the straight-line estimation of values outside the range of the data used to do the estimation with. | |||
For example, using the data above, the estimated net present value at 7%, using extrapolation = -$4m - $8m = -$12m. | For example, using the data above, the estimated net present value at 7%, using extrapolation = -$4m - $8m = -$12m. | ||
== See also == | == See also == | ||
| Line 22: | Line 32: | ||
* [[Linear]] | * [[Linear]] | ||
* [[Straight line]] | * [[Straight line]] | ||
Revision as of 11:20, 22 August 2013
A straight-line estimation method for determining an intermediate value.
For example, consider a set of cashflows which has a net present value (NPV) of +$4m at a yield of 5%, and an NPV of -$4m at a yield of 6%.
Using linear interpolation, the estimated yield at which the cashflows have an NPV of $Nil is given by:
5% + [+4/(+4 --4 = +8)] x (6 - 5)% = 5.5%.
5.5% is the estimated internal rate of return (IRR) of the cashflows.
Interpolation is often used in conjunction with Iteration.
Using iteration the straight-line estimated IRR of 5.5% would then be used, in turn, to recalculate the NPV at the estimated IRR of 5.5%, producing a recalculated NPV even closer to $0.
5.5% and the recalculated NPV would then be used with interpolation once again to further refine the estimate of the IRR.
This iteration process can be repeated as often as required until the result converges on a sufficiently stable final figure.
Another closely related linear estimation technique is extrapolation.
This involves the straight-line estimation of values outside the range of the data used to do the estimation with.
For example, using the data above, the estimated net present value at 7%, using extrapolation = -$4m - $8m = -$12m.
