Internal Rate of return
In case you forgot the formula:
Let P0, P1, P2,..., Pk be a future payment flow. This means that at the time instant 0 we pay P0, at the time instant 1, we pay P1 and so on. If a payment is negative, usually P0, this means that we receive money instead of paying. The Net Present Value of this flow, denoted by NPV(r), is defined as the sum of all present values of the above payments, for a given interest rate r. The rate r is the rate which is applied at each time instant. To find the Internal Rate of Return (IRR) of this flow, we follow the next steps:
-
We define a set of interest rates r0, r1, r2,... rn.
-
We calculate the quantities: NPV (r0), NPV (r1), NPV (r2),..., NPV (rn).
-
We find successive ra, rb such that NPV(ra) > 0 and NPV(rb) < 0.
-
We find a straight line joining the points: (ra, NPV(ra)), (rb, NPV(rb)).
-
We find the value r* where this straight line meets the horizontal r-axis.
-
IRR = r*
A company takes, at the "zero" time instant, a loan equal to 71 money units and plans to pay the first month 15 money units, the second 28 and the third 30, that is P1 = 15, P2 = 28, P3 = 30
(a) (10 rp) Using the above procedure calculate the IRR for this payment flow. Use r0 = 0.14, applied annually, and increase it with step h = 0.01 up to the value r = 0.16.
Ответ
For r0=0,14 we have:
For r0=0,15 we have:
For r0=0,16 we have:
Therefore, we seek for a straight line y=Ar+B, passing through the points (0,15, 0,0302743), (0,16, 0,09806). By substitution we find:
А = −12,8334; B=1,95529
So, this straight line is vanished at the point
(b) (10 rp) If the company, instead of following this payment policy, decides to give 25 money units on the third month and some amount of money the fifth month, what should this amount be, in order the whole loan to be repaid? As an annual interest rate, use the IRR we found before.
Ответ
The present value of the 25 money units, paid at the third month is:
where, we have taken the interest rate equal to 0,15. So, the rest of the loan is:
In order to repay it the fifth month, we must pay:
money units. This is the requested P5 value.
(c) (10 rp) The company has started to repay the loan by 5 equal monthly payments, covering both principal and interest and with an interest rate equal to the IRR, found before. Suddenly after the second payment, the interest rate is increased by 3%. The government, in order to help, decides to cover the 25% of the loan which has not been paid yet and to extend the number of total payments from 5 to 8. Find the amount of each equal monthly payment, the company must pay from now on, to repay the loan.
Ответ
First, we have to calculate how much the original equal-payment was. Let us denote it by R, we have:
or
where Using the formula for adding terms of geometric progression, we get:
Therefore, the present value of the two already-done payments is:
So, the rest of the loan is . This amount is reduced by 25%, due to the government intervention. So, the new rest of the loan is:
This quantity must be repaid with six equal payments (denoted by H), starting the third month, with new annually interest rate equal to This means that:
with:
Working as before, we get:
This is the new monthly payment, upon request.