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

jeff jeffy answered 1 year ago
Next > < Previous

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?
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
You obtained a home mortgage of $85,000 for 20 years at 4.5% compounded monthly. How much...
You obtained a home mortgage of $85,000 for 20 years at 4.5% compounded monthly. How much is your monthly payment.
A 25 year home loan of $125000 at 7.25% compounded monthly is obtained. a.  Find the monthly...
A 25 year home loan of $125000 at 7.25% compounded monthly is obtained. a.  Find the monthly payments rounded up to the next cent. b.  State the total amount of interest paid on the loan assuming that it is kept for 25 years and all payments are the same.
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT