Question

Use excel to build a monthly amortization table for a 30-year 5% fix-rate mortgage on a...

Use excel to build a monthly amortization table for a 30-year 5% fix-rate mortgage on a $320,000 home, with a $15,000 down payment.

a. How much money will you still owe on the loan after making one full year of payments?

b. How much money will you still owe on the loan after making 15 full years of payments?

c. If you want to refinance after 8 years of making payments, how much financing would you need to secure from your bank to do so?

d. How much money can you expect to pay in interests alone during the full life of the mortgage?

Homework Answers

Answer #1

a. $300,500.14 still owe on the loan after making one full year of payments.

b. $207,045.92 still owe on the loan after making 15 full years of payments.

c. If you want to refinance after 8 years of making payments, how much financing would you need to secure from your bank to do so?is $ 261,851.33

d. How much money can you expect to pay in interests alone during the full life of the mortgage? is $ 284,430.14

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
2.   Suppose you have decided to buy a house. The mortgage is a 30-year mortgage with...
2.   Suppose you have decided to buy a house. The mortgage is a 30-year mortgage with an interest rate of 7%, compounded monthly. You borrow a total of $250,000. Given this, by the time you pay off the loan, how much in total (interest + principal) would the house cost you? (20 pts) 3.   How, reconsider the previous problem. Suppose you pay the mortgage according to those specifications (7% APR, monthly) for the first 10 years, but then you refinance...
Robert and Rebecca Richardson have just signed a 30-year, 4% fixed rate mortgage for $320,000 to...
Robert and Rebecca Richardson have just signed a 30-year, 4% fixed rate mortgage for $320,000 to buy their house. Find out this couple's monthly mortgage payment by preparing a loan amortization schedule for the Richardson’s for the first 2 months; find out how much of their payments applied to interest; and after 2 payments, how much of their principal will be reduced. (Please construct a loan amortization schedule and show your calculations).
You have taken out a standard $250,000, 30-year mortgage, at a nominal annual rate of 4.9%,...
You have taken out a standard $250,000, 30-year mortgage, at a nominal annual rate of 4.9%, with monthly compounding. Determine how much you will still owe on your mortgage, as a percent of the original $250,000, after 15 years (180 payments) if you only make the required monthly payments. A) 65.56% B) 66.23% C) 66.90% D) 67.56% E) 68.21% Pleasse do not use excel to explain this to me thank you.
The mortgage on your house is five years old. It required monthly payments of $1,390​, had...
The mortgage on your house is five years old. It required monthly payments of $1,390​, had an original term of 30​ years, and had an interest rate of 10% ​(APR). In the intervening five​ years, interest rates have fallen and so you have decided to refinance—that ​is, you will roll over the outstanding balance into a new mortgage. The new mortgage has a​ 30-year term, requires monthly​ payments, and has an interest rate of 5.625% ​(APR). a. What monthly repayments...
Derek borrows $264,831.00 to buy a house. He has a 30-year mortgage with a rate of...
Derek borrows $264,831.00 to buy a house. He has a 30-year mortgage with a rate of 5.26%. After making 149.00 payments, how much does he owe on the mortgage?
Derek borrows $332,034.00 to buy a house. He has a 30-year mortgage with a rate of...
Derek borrows $332,034.00 to buy a house. He has a 30-year mortgage with a rate of 5.99%. After making 125.00 payments, how much does he owe on the mortgage?
Derek borrows $333,334.00 to buy a house. He has a 30-year mortgage with a rate of...
Derek borrows $333,334.00 to buy a house. He has a 30-year mortgage with a rate of 5.73%. After making 118.00 payments, how much does he owe on the mortgage?
Derek borrows $250,744.00 to buy a house. He has a 30-year mortgage with a rate of...
Derek borrows $250,744.00 to buy a house. He has a 30-year mortgage with a rate of 5.91%. After making 118.00 payments, how much does he owe on the mortgage?
Derek borrows $291,519.00 to buy a house. He has a 30-year mortgage with a rate of...
Derek borrows $291,519.00 to buy a house. He has a 30-year mortgage with a rate of 4.67%. After making 124.00 payments, how much does he owe on the mortgage?
Mr. H issues a 20 year mortgage of $275,000 at an annual interest rate of 4.4%...
Mr. H issues a 20 year mortgage of $275,000 at an annual interest rate of 4.4% to buy a house.The mortgage payments are made annually. 1.What is Mr. H's annual payment of principal and interest? $20,958 $22,425 $18,653 $24,102 2.How much interest does Mr. H pay in the second year of the mortgage? $11,710 $13,467 $12,530 $10,422 3.Suppose that immediately after making the second annual payment, Mr. H has the opportunity to refinance the remaining mortgage balance at an annual...