Question

In: Finance

A loan of Kenya Shs 5,000,000/= disbursed today is repaid in four installments commencing at the...

A loan of Kenya Shs 5,000,000/= disbursed today is repaid in four installments commencing at the end of year one. The second repayment is at the end of year two and is half as much again as the first installment and is 15% less than the third installment (due at the end of year four). The final installment is due at the end of year five and is 25% more than the first installment.

The rate of interest is 14% per annum in years one and two; 15% per annum in years three and four; and 11% per annum in years, five and six. Compute the amount of each installment.

Solutions

Expert Solution

Let the loan amount paid at the end of year 1 be "x". Thus second repayment amount = x/2. Also 2nd repayment is 15% less than the 3rd repayment. Thus 3rd repayment - 0.15*3rd repayment = 2nd repayment

or 0.85*3rd repayment = x/2

or 3rd repayment = x/(2*0.85)

Thus 3rd repayment = x/1.70

4th repayment = 1.25x

Thus putting the above values in the loan amortization table we get the following:

Year Loan amount due at the beginning of the period Amount paid during the year Interest rate (%) Interest amount Principal amount paid Loan amount due at the end of the period
1 5,000,000.00 2,212,986.47 14.00 700,000.00 1,512,986.47 3,487,013.53
2 3,487,013.53 1,106,493.24 14.00 488,181.89 618,311.34 2,868,702.18
3 2,868,702.18 0.00 15.00 430,305.33 0.00 3,299,007.51
4 3,299,007.51 1,301,756.75 15.00 494,851.13 806,905.62 2,492,101.89
5 2,492,101.89 2,766,233.09 11.00 274,131.21 2,492,101.89 0.00

Thus 1st installment = $2,212,986.47

2nd installment = 1,106,493.24

3rd installment = 1,301,756.75

4th installment = 2,766,233.09


Related Solutions

A loan of Shs 4,000,000/= disbursed today is repaid in four installments commencing at the end...
A loan of Shs 4,000,000/= disbursed today is repaid in four installments commencing at the end of year one. The second repayment is at the end of year two and is half as much again as the first installment and is 20% less than the third installment (due at the end of year four). The final installment is due at the end of year five and is 15% more than the first installment. The rate of interest is 13% per...
The Beta Corporation obtains a bank loan that is disbursed as follows: Shs 320 million, Shs...
The Beta Corporation obtains a bank loan that is disbursed as follows: Shs 320 million, Shs 240 million, Shs 160 million and Shs 80 million at the beginning of years one, two, three, and four respectively. The loan is repaid in five equal annual installments of Shs 300 million at the end of years four to eight, and a final amount at the beginning of year 12. Given a rate of inflation of 4.0% per annum during the period, and...
A firm is advanced a Shs 5 million= loan by a bank to be repaid in...
A firm is advanced a Shs 5 million= loan by a bank to be repaid in equal monthly installments over five years at a rate of interest of 18% per annum. After the 24th installment, the rate of interest is adjusted to 20% per annum and the monthly installment size recomputed such that the loan is fully repaid in the remaining duration of the initially agreed term. After the 36th installment, the rate of interest is lowered by 3% per...
Consider a $35,000 loan to be repaid in equal installments at the end of each of...
Consider a $35,000 loan to be repaid in equal installments at the end of each of the next 5 years. The interest rate is 6%. Set up an amortization schedule for the loan. Round your answers to the nearest cent. Enter "0" if required Year Payment Repayment Interest Repayment of Principal Balance 1 $   $   $   $   2 $   $   $   $   3 $   $   $   $   4 $   $   $   $   5 $   $   $   $   Total $   $  ...
a. Complete an amortization schedule for a $44,000 loan to be repaid in equal installments at...
a. Complete an amortization schedule for a $44,000 loan to be repaid in equal installments at the end of each of the next three years. The interest rate is 11% compounded annually. Round all answers to the nearest cent. Beginning Repayment Ending Year Balance Payment Interest of Principal Balance 1 $   $   $   $   $   2 $   $   $   $   $   3 $   $   $   $   $   b. What percentage of the payment represents interest and what percentage represents principal...
a. Complete an amortization schedule for a $38,000 loan to be repaid in equal installments at...
a. Complete an amortization schedule for a $38,000 loan to be repaid in equal installments at the end of each of the next three years. The interest rate is 12% compounded annually. Round all answers to the nearest cent. Beginning Balance -Payment -Interest -Repayment of Principal -Ending Balance 1 $ $ $ $ $ 2 $ $ $ $ $ 3 $ $ $ $ $ b. What percentage of the payment represents interest and what percentage represents principal for...
a. complete an amortization schedule for a 33,000 loan to be repaid in equal installments at...
a. complete an amortization schedule for a 33,000 loan to be repaid in equal installments at the end of each of the next three years. The interest rate is 12% compounded annually. round all answers to the nearest cent. b. what percentage of the payment represents interest and what percentage represents principal for each of the three years? round all answers to two decimal places .
Consider a $30,000 loan to be repaid in equal installments at the end of each of...
Consider a $30,000 loan to be repaid in equal installments at the end of each of the next 5 years. The interest rate is 6%. Set up an amortization schedule for the loan. Do not round intermediate calculations. Round your answers to the nearest cent. If your answer is zero, enter "0". Year Payment Repayment Interest Repayment of Principal Balance 1 $   $   $   $   2 $   $   $   $   3 $   $   $   $   4 $   $   $   $  ...
Consider a $50,000 loan to be repaid in equal installments at the end of each of...
Consider a $50,000 loan to be repaid in equal installments at the end of each of the next 5 years. The interest rate is 10%. Set up an amortization schedule for the loan. Round your answers to the nearest cent. Enter "0" if required Year Payment Repayment Interest Repayment of Principal Balance 1 $    $    $    $    2 $    $    $    $    3 $    $    $    $    4 $    $    $    $    5 $    $    $    $    Total $    $   ...
Consider a loan for $100,000 to be repaid in equal installments at the end of each...
Consider a loan for $100,000 to be repaid in equal installments at the end of each of the next 5 years. The interest rate is 6% compounded annually. What is the remaining balance of the loan after 2 years?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT