Question

In: Finance

A loan of 100,000 is being repaid by 15 equal installments made at the end of...

A loan of 100,000 is being repaid by 15 equal installments made at the end of each year at 6% interest effective annually. Immediately after the eighth payment, the loan is renegotiated as follows: (i) The borrower will make seven annual payments of K to repay the loan, with the first payment made three years from the date of renegotiation. (ii) The interest rate is changed from 7.5% effective annually. Calculate K (do not use excel)

(A) 11,068 (B) 11,666 (C) 11,900 (D) 12,193 (E) 12,540

Solutions

Expert Solution

Answer is (D) = 12,540

Calculation is given below

1st Step - Calculate Original Annual Payment (Here payment is made at end of the year)

Formula - {P * R * (1+R)^N} / { (1+R)^N - 1}

P = Principal Amount (1,00,000)

R = Annual Interest Rate (6%)

N = Loan Tenure (15 Years)

Using the above formula we get Original Annual EMI = 10,296

The following will be repayment schedule

Evident from abive table, now after 8th payment pending payable principal is 57,478 (Rounded Off)

Now post renegotiation borrower will make 7 annual payments starting 3 years from now, new interest rate will be 7.5%

Pending after 3 years (which will be repaid in 7 annual payments of amount K)

= 57,478 (1.075)^3

= 71,405

Now 7 annual payments (Of Amount K) will be made at the beginning of each year

Amount (K) of which will be calculated using formula used abive for calculating original annual payment with a slight modification since here payments are made at the beginning of the year

Formula will be

K = { (P - K) * R * (1+ R)^(N-1) } / { (1 + R) ^ (N - 1) - 1 }

It will be solved as below giving K = 12,540


Related Solutions

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?
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 5% compounded annually. What is the remaining balance of the loan after 2 years ? $62,900 $76,903 $62,336 $23,097 $53,805
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 7% compounded annually. What is the remaining balance of the loan after 2 years? $63,456 $24,389 $64,005 $75,611 $51,222
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 $   $  ...
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 $    $   ...
Amortization Schedule Consider a $15,000 loan to be repaid in equal installments at the end of...
Amortization Schedule Consider a $15,000 loan to be repaid in equal installments at the end of each of the next 5 years. The interest rate is 7%. 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 $   $  ...
Amortization Schedule Consider a $30,000 loan to be repaid in equal installments at the end of...
Amortization Schedule 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. 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 five-year loan is being repaid with level monthly installments, one at the end of each...
A five-year loan is being repaid with level monthly installments, one at the end of each month beginning on 1/1/2018 and ending on 12/31/2022. A 12% nominal annual interest rate compounded monthly was used to determine the amount of each monthly installment. In which of the following periods does the outstanding loan balance first fall below one-half of the original amount of the loan? a) January 2018 through March 2020 b) April 2020 through June 2020 c) July 2020 through...
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...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT