Question

In: Finance

A family has a $ 144447 , 20 -year mortgage at 6.6 % compounded monthly. Find...

A family has a $ 144447 , 20 -year mortgage at 6.6 % compounded monthly. Find the monthly payment. Also find the unpaid balance after 5 years and after 10 years.

Solutions

Expert Solution

We can compute the monthly payments and unpaid balances using Excel functions as per formulae in the image.

1: Monthly payment = 1085.48

2:

Principal paid in 5 years -20620.69832

Balance remaining = 144447-20620.70 = 123826.30

3:

Principal paid in 10 years -49277.50965

Balance remaining = 95169.49

WORKINGS


Related Solutions

A family has a $ 113,739 25​-year mortgage at 5.4 % compounded monthly. ​(A) Find the...
A family has a $ 113,739 25​-year mortgage at 5.4 % compounded monthly. ​(A) Find the monthly payment and the total interest paid. ​(B) Suppose the family decides to add an extra​ $100 to its mortgage payment each month starting with the very first payment. How long will it take the family to pay off the​ mortgage? How much interest will the family​ save? ​(A) Monthly​ payment: ​$ nothing ​(Round to two decimal​ places.)
A family took a 20 year mortgage of $195,000 at 5.75% per year compounded monthly. Immediately...
A family took a 20 year mortgage of $195,000 at 5.75% per year compounded monthly. Immediately after the 85th monthly payment, they decided to re-finance this mortgage because they found a lower rate of 3.75% per month compounded monthly. If they continue the same amount of monthly payments as before, how long will it take to pay off this mortgage?
A family took a 20 year mortgage of $195,000 at 5.75% per year compounded monthly. Immediately...
A family took a 20 year mortgage of $195,000 at 5.75% per year compounded monthly. Immediately after the 85th monthly payment, they decided to re-finance this mortgage because they found a lower rate of 3.75% per month compounded monthly. If they continue the same amount of monthly payments as before, how long will it take to pay off this mortgage?
A $40,000 mortgage loan charges interest at 6.6% compounded monthly for a four-year term. Monthly payments...
A $40,000 mortgage loan charges interest at 6.6% compounded monthly for a four-year term. Monthly payments were calculated for a 15-year amortization and then rounded up to the next higher $10. a) What will be the principal balance at the end of the first term? b) What will the monthly payments be on renewal for a three-year term if it is calculated for an interest rate of 7.2% compounded monthly and an 11-year amortization period, but again rounded to the...
Monthly payments on a $165,000 mortgage are based on an interest rate of 6.6% compounded semiannually...
Monthly payments on a $165,000 mortgage are based on an interest rate of 6.6% compounded semiannually and a 30-year amortization. If a $5000 prepayment is made along with the thirty-second payment: (Do not round the intermediate calculations.) a. How much will the amortization period be shortened? (Round UP to the next whole number.)    The amortization period will be shortened by years and month(s).    b.What will be the principal balance after four years? (Round your answer to two decimal...
A 20-year, $ 490,000 mortgage at 4.20\% compounded annually is repaid wit monthly payments . a....
A 20-year, $ 490,000 mortgage at 4.20\% compounded annually is repaid wit monthly payments . a. What is the size of the monthly payments ? Round to the nearest cent. b. Find the balance of the mortgage at the end of 5 years 00 Round to the nearest cent c. By how much did the amortization period shorten by if the monthly payments are increased by $ 200 at the end of year five
Ann obtains a $150,000, 20-year mortgage with a bank at 9% p.a., compounded monthly. a. What...
Ann obtains a $150,000, 20-year mortgage with a bank at 9% p.a., compounded monthly. a. What is her monthly repayment? b. Suppose that after 5 years, Ann plans to repay the loan by making an additional payment each month along with her regular payment. How much must Ann pay each month if she wishes to pay off the loan in 10 years?
Consider a 30-year mortgage with an interest rate of 10% compounded monthly and a monthly payment...
Consider a 30-year mortgage with an interest rate of 10% compounded monthly and a monthly payment of $850. (1) Calculate the principal. (2) How much of the principal is paid the first, 5th, 20th and last year? (3) How much interest is paid the first, 5th, 20th and last year year? (4) What is the total amount of money paid during the 30 years? (5) What is the total amount of interest paid during the 30 years? (6) What is...
Consider a 30-year mortgage with an interest rate of 10% compounded monthly and a monthly payment...
Consider a 30-year mortgage with an interest rate of 10% compounded monthly and a monthly payment of $850. (5) What is the total amount of interest paid during the 30 years? (6) What is the unpaid balance after 25 years? (7) How much has to be deposited into a savings account with an interest rate of 4% compounded quarterly in order to pay the unpaid balance of the mortgage after 25 years? (8) How much has to be deposited each...
Find the EAR in each of the following cases: a.20% compounded quarterly b.13% compounded monthly c....
Find the EAR in each of the following cases: a.20% compounded quarterly b.13% compounded monthly c. 18% compounded daily d. 16%with continuous compounding
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT