Question

In: Finance

A 18 year loan is being repaid with level payments at the end of each month....

A 18 year loan is being repaid with level payments at the end of each month. The loan rate of interest is 15.6% compounded monthly. In which month is the interest portion approximately equal to 5 times principal the portion? Give an integer answer.

Solutions

Expert Solution

Let us assume $ 100000 as loan

EMI:

EMI = Loan / PVAF (r%, n)
PVAF = SUm [ PVF(r%, n) ]
PVF(r%, n) = 1 / ( 1 + r)^n
r = Int rate per period
n = No. of periods

= $ 100000 / PVAF(1.3%, 216 )

= $ 100000 / 72.1979

= $ 1385.08

Loan Amortization:

As the full table is not supported by server, I am able to display portion where Int/ Principal is 5.

Month Opening Bal Instalment Int Principal Repay Clsoing Bal Int/ Principal
75 $ 89,523.51 $ 1,385.08 $ 1,163.81 $ 221.28 $ 89,302.23          5.26
76 $ 89,302.23 $ 1,385.08 $ 1,160.93 $ 224.15 $ 89,078.08          5.18
77 $ 89,078.08 $ 1,385.08 $ 1,158.02 $ 227.07 $ 88,851.01          5.10
78 $ 88,851.01 $ 1,385.08 $ 1,155.06 $ 230.02 $ 88,621.00          5.02
79 $ 88,621.00 $ 1,385.08 $ 1,152.07 $ 233.01 $ 88,387.99          4.94
80 $ 88,387.99 $ 1,385.08 $ 1,149.04 $ 236.04 $ 88,151.95          4.87
81 $ 88,151.95 $ 1,385.08 $ 1,145.98 $ 239.11 $ 87,912.84          4.79
82 $ 87,912.84 $ 1,385.08 $ 1,142.87 $ 242.21 $ 87,670.63          4.72
83 $ 87,670.63 $ 1,385.08 $ 1,139.72 $ 245.36 $ 87,425.27          4.65
84 $ 87,425.27 $ 1,385.08 $ 1,136.53 $ 248.55 $ 87,176.71          4.57
85 $ 87,176.71 $ 1,385.08 $ 1,133.30 $ 251.78 $ 86,924.93          4.50
86 $ 86,924.93 $ 1,385.08 $ 1,130.02 $ 255.06 $ 86,669.87          4.43
87 $ 86,669.87 $ 1,385.08 $ 1,126.71 $ 258.37 $ 86,411.50          4.36

Pls do rate, if the answer is correct and comment, if any further assistance is required.


Related Solutions

A $1000 loan is being repaid with level payments at the end of each year for...
A $1000 loan is being repaid with level payments at the end of each year for 4 years using a sinking fund method. The loan has 10% effective interest per year and the sinking fund has 8% interest per year. Create a sinking fund table for this payment plan. Include a column for the period, interest paid that period, sinking fund deposit that period, interest earned in the sinking fund that period and the balance in the sinking fund at...
A loan of €50,000 is being repaid with monthly level payments at the end of each...
A loan of €50,000 is being repaid with monthly level payments at the end of each year for 6 years at 5% effective rate. Just after making the payment of the second annuity, it is decided to change the amortization method, the loan is being repaid with constant annual principal repayments for the remaining 3 years at an interest rate of 4.5%. A) find the outstanding debt just after the payment of the third annuity
A loan of €50,000 is being repaid with monthly level payments at the end of each...
A loan of €50,000 is being repaid with monthly level payments at the end of each year for 6 years at 5% effective rate. Just after making the payment of the second annuity, it is decided to change the amortization method, the loan is being repaid with constant annual principal repayments for the remaining 3 years at an interest rate of 4.5%. find the outstanding debt just after the payment of the third annuity
A loan of $10,000 is being repaid with 10 payments at the end of each year,...
A loan of $10,000 is being repaid with 10 payments at the end of each year, where each payment includes equal amount of repayment of the principal and the interest at a rate of 5% based on the outstanding balance after the previous payment. Immediately after the loan was made, the right of the loan was sold at a price that yields an annual effective rate of 10%. Find the price paid for the right of the loan. (Answer: $8072.28)...
A loan is being repaid with 20 payments of $ 1,000 at the end of each...
A loan is being repaid with 20 payments of $ 1,000 at the end of each quarter. Given that the nominal rate of interest is 8% per year compounded quarterly, find the outstanding balance of the loan immediately after 10 payments have been made (a) by the prospective method, (b) by the retrospective method.
1. A $1000 loan is being repaid by payments of $100 at the end of each...
1. A $1000 loan is being repaid by payments of $100 at the end of each quarter for as long as necessary, plus a smaller final payment. If the nominal rate of interest convertible quarterly is 16%, find the amount of principal and interest in the fourth payment. 2. A loan is being repaid with level payments at the end of each year for 20 years at 9% effective annual interest. In which payment are the principal and the interest...
8. (6pts) A loan is being repaid by payments of $2000 at the end of each...
8. (6pts) A loan is being repaid by payments of $2000 at the end of each half-year at nominal rate of 6% convertible semiannually, and a smaller final payment is made after the last regular payment. If the loan balance at the end of the third year is $15,000, find (1) the amount of the loan. (Answer: $23,396.65) (2) the loan balance right after the last regular payment. (Answer: $1,216.88) (3) the amount of principal and the amount of interest...
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 10-year loan of 120,000 is to be repaid with payments at the end of each...
A 10-year loan of 120,000 is to be repaid with payments at the end of each month. Interest is at an annual effective rate of 6.00%. The first monthly payment is 800. Each additional payment will be k more than the previous month payment. Find k.
A loan of $5000 is repaid with annual payments at the end of each year of...
A loan of $5000 is repaid with annual payments at the end of each year of $1200,$800,$1300 and X. Assume the loan has 10% effective interest per year. a) Determine X b) Determine the amount of interest paid with the third payment.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT