Question

In: Accounting

Suppose that a loan is being repaid with 60 equal monthly payments, the first coming a...

Suppose that a loan is being repaid with 60 equal monthly payments, the first coming a month after the loan is made. If the rate of interest is 9.7 percent convertible monthly, and the amount of principal in the 22nd payment is 260, how much interest is in the 44th payment?

Solutions

Expert Solution

If the loan amount is $100 then the percent of principal paid on 22nd payment is 1.5414%

Principal paid (nth payment) = Payment ÷ [1+R)^(N-n+1)
Payment 2.1100
Rate of interest R= 0.8083%
nth payment n= 22
Total payments N= 60
Principal paid = 2.11/[1+0.008083^(60-22+1)
Principal paid =                                                       1.5414
Monthly payment = [P * R * (1+R)^N ] / [(1+R)^N -1]
Using the formula:
Loan amount P                                                                100.00
Rate of interest per period:
Annual rate of interest 9.700%
Frequency of payment = Once in 1 month period
Numer of payments in a year = 12/1 = 12
Rate of interest per period R 0.097 /12 = 0.8083%
Total number of payments:
Frequency of payment = Once in 1 month period
Number of years of loan repayment =                                                                          5
Total number of payments N 5*12 = 60
Period payment using the formula = [ 100*0.00808*(1+0.00808)^60] / [(1+0.00808 ^60 -1]
Monthly payment = 2.1100

As principal paid on 22nd payment is 1.5414%, loan amount is 260/1.5414% = 16,867.76

Now the monthly payment on loan amount is:

Monthly payment = [P * R * (1+R)^N ] / [(1+R)^N -1]
Using the formula:
Loan amount P                                                           16,867.76
Rate of interest per period:
Annual rate of interest 9.700%
Frequency of payment = Once in 1 month period
Numer of payments in a year = 12/1 = 12
Rate of interest per period R 0.097 /12 = 0.8083%
Total number of payments:
Frequency of payment = Once in 1 month period
Number of years of loan repayment =                                                                          5
Total number of payments N 5*12 = 60
Period payment using the formula = [ 16867.76*0.00808*(1+0.00808)^60] / [(1+0.00808 ^60 -1]
Monthly payment = 355.91

Interest paid on 44th payment is:

Principal paid (nth payment) = Payment ÷ [1+R)^(N-n+1)
Payment 355.91
Rate of interest R= 0.8083%
nth payment n= 44
Total payments N= 60
Principal paid = 355.91/[1+0.008083^(60-44+1)
Principal paid =                                                310.38091
Interest paid ( balance) =                                                         45.52

Related Solutions

a) A loan of $5,000 is to be repaid in equal monthly payments over the next...
a) A loan of $5,000 is to be repaid in equal monthly payments over the next 2 years. Determine the payment amount if interest is charged at a nominal annual rate of 15% compounded semiannually. b) Net receipts from a continuously producing oil well add up to $120,000 over 1 year. What is the present amount of the well if it maintains steady output until it runs dry in 8 years if r = 10% compounded continuously?
A $10,000 loan is to be repaid in monthly equal payments in 10 years with an...
A $10,000 loan is to be repaid in monthly equal payments in 10 years with an annual effective interest rate of 19.56% charged against the unpaid balance. What principal remains to be paid after the third payment?
A loan of $9,000 is to be repaid in 3 equal payments 60, 180, and 300...
A loan of $9,000 is to be repaid in 3 equal payments 60, 180, and 300 days respectively after the date of the loan. If the interest rate charged on the loan is 7¼%, what will be the size of each equal payment?  (Do not round intermediate calculations and round your final answer to 2 decimal places.)
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
Eve borrows 10,000. The loan is being repaid with the following sequence of monthly payments: 100,...
Eve borrows 10,000. The loan is being repaid with the following sequence of monthly payments: 100, 150, 100, 150, 100, 150, etc. The annual nominal interest rate is 7.56% payable monthly. Calculate the amount of principal repaid in the 13th payment.
Create AS for a $250,000 M to be repaid in equal monthly payments at the end...
Create AS for a $250,000 M to be repaid in equal monthly payments at the end of each month for the next 15 years. AIR=5% compounded monthly. AS= amortization schedule, M=mortgage, AIR = annual interest rate b. How large must each MP be if the loan is for $350,000? IR stays at 5% and that the loan is paid off over 15 years. MP=monthly payment, IR = interest rate c. How large must each payment be if the loan is...
A firm borrows $5000 and the loan is to be repaid in 4 equal payments at...
A firm borrows $5000 and the loan is to be repaid in 4 equal payments at the end of each of the next 4 years so that the ending balance at the end of year 4 is 0. The interest rate on the loan is 10 percent. The principal repayment in year 3 is:
A firm borrows $5000 and the loan is to be repaid in 4 equal payments at...
A firm borrows $5000 and the loan is to be repaid in 4 equal payments at the end of each of the next 4 years so that the ending balance at the end of year 4 is 0. The interest rate on the loan is 10 percent. The beginning balance in year 2 is:
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.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT