A lender makes a 100,000 mortgage at 12% interest with monthly payments for 25 years. How...

A lender makes a 100,000 mortgage at 12% interest with monthly payments for 25 years. How much principal will be repaid during the 10th year of the loan? How much interest will be paid during the 10th year of the loan? Show Calculations using a financial calculator. (i.e. I=?, PMT=? etc)

Solutions

Expert Solution

Mortgage Loan = $100,000

Annual Interest rate = 12%

Monthly Interest rate = 12% / 12

= 1%

Tenure = 25 year or 300 months

Monthly payment on mortgage loan is calculated in excel and screen shot provided below:

Monthly payment on mortgage loan is $1,053.22.

Total outstanding balance after 10 year will be present value of monthly payment of next 15 year (total 25 year). So total outstanding balance after 10 year is calculated in excel and screen shot provided below:

Outstanding balance after 10 year is $87,756.39.

Total principle payment = $100,000 - $87,756.39

= $12,243.61.

Total principle payment upto 10th year is $12,243.61.

Total Interest payment = ($1,053.22 × 10 × 12) - $12,243.61

= $126,386.90 - $12,243.61

= $114,143.29.

Total Interest payment is $114,143.29.

jeff jeffy answered 1 year ago

Next > < Previous

Related Solutions

A lender originates a $90,000 mortgage at 9% APR interest, with monthly payments for 25 years....

A lender originates a $90,000 mortgage at 9% APR interest, with monthly payments for 25 years. How much principal will be repaid during year 4 of the loan? (note: use the amortization schedule in your calculator ) -7,787 -1,376 -7,749 -4,617.57 -1,314

A $86,000 mortgage is to be amortized by making monthly payments for 25 years. Interest is...

A $86,000 mortgage is to be amortized by making monthly payments for 25 years. Interest is 5.1% compounded semi-annually for a six-year term. (a) Compute the size of the monthly payment. (b) Determine the balance at the end of the six-year term. (c) If the mortgage is renewed for a six-year term at 6% compounded semi-annually, what is the size of the monthly payment for the renewal term? (a) The size of the monthly payment is $__. (Round the final...

A $95,000 mortgage is to be amortized by making monthly payments for 25 years. Interest is...

A $95,000 mortgage is to be amortized by making monthly payments for 25 years. Interest is 8.6% compounded semi-annually for a six-year term. (a)Compute the size of the monthly payment. (b) Determine the balance at the end of the six-year term. (c)If the mortgage is renewed for a six-year term at 6% compounded semi-annually, what is the size of the monthly payment for the renewal term? (a) The size of the monthly payment is $__.(Round the final answer to the...

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?

Dave currently makes monthly payments towards a 25-year mortgage of $290000 with an interest rate of...

Dave currently makes monthly payments towards a 25-year mortgage of $290000 with an interest rate of 13.2% compounded monthly. After making the 65th payment, Dave refinanced his mortgage at an interest rate of 8.4% compounded monthly and renegotiated his term. This resulted in Dave's monthly payments being reduced by $400. How large will Dave's final drop payment be?

An $600,000 Mortgage is amortized by monthly payments over 25 years. The interest rate charged is...

An $600,000 Mortgage is amortized by monthly payments over 25 years. The interest rate charged is 4% compounded semi-annually. 1.What is the size of the monthly payment to the nearest dollars? 2.How much interest paid in the first payment? 3.What is the outstanding balance after the first payment?

The Grewals agreed to monthly payments on a mortgage of $363,000.00 amortized over 25 years. Interest...

The Grewals agreed to monthly payments on a mortgage of $363,000.00 amortized over 25 years. Interest for the first five years was 4.3% compounded semi-annually. a. Determine the Grewals’ monthly payments. b. Determine the balance owing after the 5-year term. c. Before renewing for another term of 5 years at 4.5% compounded semiannually, the Grewals make an additional payment of $21,000. If they keep the same monthly payments, by how much will the amortization period be shortened? note; sir i...

A mortgage of $100,000 is amortized over 25 years using level payments at the end of...

A mortgage of $100,000 is amortized over 25 years using level payments at the end of each quarter and the first interest payment at the end of the first quarter is $2411.37. Calculate the 62nd principal payment amount. a. 1074.21 b. 1048.92 c. 1100.11 d. 1024.22 e. None of these answers

1. What are the monthly payments for a $100,000 mortgage amount, 8 percent interest rate, and...

1. What are the monthly payments for a $100,000 mortgage amount, 8 percent interest rate, and a 30-year term? A - 8,883 B - 740 C - 734 D - 8,000 2. You are borrowing $10,000 to purchase a car. You plan to make monthly payments for 24 months, and the interest rate is 12%. What is your monthly payment? A - 471 B - 1,285 C - 371 D - 5,075

You have borrowed $100,000 on a 40-year mortgage with monthly payments. The annual interest rate is...

You have borrowed $100,000 on a 40-year mortgage with monthly payments. The annual interest rate is 16 percent. How much will you pay over the course of the loan? With four years left on the loan, how much will you still owe? Excel

Subjects