Question

In: Finance

Given a $200,000 loan, monthly payments, 30 years at 3.75%, how much interest is paid on...

Given a $200,000 loan, monthly payments, 30 years at 3.75%, how much interest is paid on the 36th payment?

Solutions

Expert Solution

Given,

Loan amount = $200000

Term = 30 years

Interest rate = 3.75% or 0.0375

Solution :-

Number of payments (n) = 30 years x 12 = 360

Monthly interest rate (r) = 0.0375/12 = 0.003125

Monthly payment = (Loan amount x r) [1 - (1 + r)-n]

= ($200000 x 0.003125) [1 - (1 + 0.003125)-360]

= $625 [1 - (1.003125)-360]

= $625 [1 - 0.32522245917231]

= $625 0.67477754082769 = $926.2311831442518

We have to calculate interest paid on 36th payment. At that time, 35 payments have been made.

So, remaining payments (t) = 360 - 35 = 325

Outstanding loan balance at the time of 36th payment

= Monthly payment/r x [1 - (1 + r)-t]

= $926.2311831442518/0.003125 x [1 - (1 + 0.003125)-325]

= $926.2311831442518/0.003125 x [1 - (1.003125)-325]

= $926.2311831442518/0.003125 x [1 - 0.36275000106599]

= $926.2311831442518/0.003125 x 0.63724999893401

= $188877.06

Now,

Interest paid on the 36th payment = Outstanding loan balance at the time of 36th payment x r

= $188877.06 x 0.003125 = $590.24


Related Solutions

Given a $200,000 loan, monthly payments, 30 years at 3.75%, how much principle is paid over...
Given a $200,000 loan, monthly payments, 30 years at 3.75%, how much principle is paid over the first 72 months?
A) For a loan of $160,000 at 7% annual interest, monthly payments, for 30 years, how...
A) For a loan of $160,000 at 7% annual interest, monthly payments, for 30 years, how much total interest will be paid over the life of the loan? Group of answer choices $279,785.00 $81,002.00 $223,214.00 $265,778.00 B) For a loan of $250,000 at 6% annual interest, with monthly payments over 15 years, if you pay an additional $100 in principle per month, how much total interest will you pay over the life of the loan? Group of answer choices $218,090.00...
A borrower takes out a 30-year adjustable rate mortgage loan for $200,000 with monthly payments. The...
A borrower takes out a 30-year adjustable rate mortgage loan for $200,000 with monthly payments. The first two years of the loan have a "teaser" rate of 2%, after that, the rate can reset with a 7% annual payment cap. On the reset date, the composite rate is 6%. Assume that the loan allows for negative amortization. What would be the outstanding balance on the loan at the end of Year 3?
A borrower takes out a 30-year adjustable rate mortgage loan for $200,000 with monthly payments. The...
A borrower takes out a 30-year adjustable rate mortgage loan for $200,000 with monthly payments. The first two years of the loan have a “teaser” rate of 4%, after that, the rate can reset with a 5% annual payment cap. On the reset date, the composite rate is 6%. What would the Year 3 monthly payment be? with the way please.
A loan will be repaid in 5 years with monthly payments at a nominal interest rate...
A loan will be repaid in 5 years with monthly payments at a nominal interest rate of 9% monthly convertible. The first payment is $1000 and is to be paid one month from the date of the loan. Each succeeding monthly payment will be 2% lower than the prior payment. Calculate the outstanding loan balance immediately after the 40th payment is made.
5. (a) What are the monthly payments on a 20-year, $200,000 loan having 6% annual interest,...
5. (a) What are the monthly payments on a 20-year, $200,000 loan having 6% annual interest, compounded monthly? Interest is computed based on the balance at the beginning of each month, and payments are made at the end of eachmonth. (b) How much must be deposited each month to achieve a balance of $200,000 at the end of 25 years, at 6% annual interest compounded monthly? Deposits are made at the beginning of each month, and interest is paid on...
A borrower takes out a 30-year price level adjusted mortgage loan for $200,000 with monthly payments....
A borrower takes out a 30-year price level adjusted mortgage loan for $200,000 with monthly payments. The initial interest rate is 4% with 4 points. Assuming that inflation is expected to increase at the rate of 3% for the next 5 years, and a fully amortizing loan is made. a) What is the monthly payment in year 2? b) What is the expected effective yield to the lender if the loan is repaid in 2 years?
How many monthly payments remain to be paid on an 12% interest rate mortgage with monthly...
How many monthly payments remain to be paid on an 12% interest rate mortgage with monthly payments of $733.76, when the balance outstanding on the mortgage reaches $40,000?
suppose you take a mortgage for $95,000 at 6.50% for 30 years, monthly payments. the loan...
suppose you take a mortgage for $95,000 at 6.50% for 30 years, monthly payments. the loan has a 5% prepayment penalty if the loan is repaid within the first 5 years of life. if you repay the loan at the end of year 4 what is the payoff of the loan? A- 0 B- 4,515 C- 90,307 D-156,250 You to refinance your current mortgage that has a current balance of $150,000 and does not have a prepayment penalty. Your lender...
A fully amortizing mortgage loan is made for $200,000 at 6 percent interest for 30 years....
A fully amortizing mortgage loan is made for $200,000 at 6 percent interest for 30 years. Payments are to be made monthly. (Ignore origination fee and other fees). a.      Using Excel, construct fully amortizing mortgage loan table including beginning balance, payment, interest, principal, and ending balance. (Please check your ending balance by using PV function in Excel) b.      Interest and principal payments during month 1. c.       Total Principal and total interest paid over 30 years. d.      The outstanding loan balance...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT