Question

In: Finance

You want to take out a $324,000 mortgage (home loan). The interest rate on the loan...

You want to take out a $324,000 mortgage (home loan). The interest rate on the loan is 5.3%, and the loan is for 30 years. Your monthly payments are $1,799.19.

  1. How much will still be owed after making payments for 10 years? $__________Round your answers to the nearest dollar.
  2. How much will still be owed after making payments for 15 years? $__________ Round your answers to the nearest dollar.
  3. How much will still be owed after making payments for 20 years? $__________ Round your answers to the nearest dollar.

Solutions

Expert Solution

Monthly Payment = $1,799.19

Annual Interest Rate = 5.30%
Monthly Interest Rate = 5.30% / 12
Monthly Interest Rate = 0.441667%

Answer a.

Time Period = 20 years or 240 months

Loan Outstanding = $1,799.19/1.00441667 + $1,799.19/1.00441667^2 + … + $1,799.19/1.00441667^239 + $1,799.19/1.00441667^240
Loan Outstanding = $1,799.19 * (1 - (1/1.00441667)^240) / 0.00441667
Loan Outstanding = $1,799.19 * 147.788924
Loan Outstanding = $265,900

Answer b.

Time Period = 15 years or 180 months

Loan Outstanding = $1,799.19/1.00441667 + $1,799.19/1.00441667^2 + … + $1,799.19/1.00441667^179 + $1,799.19/1.00441667^180
Loan Outstanding = $1,799.19 * (1 - (1/1.00441667)^180) / 0.00441667
Loan Outstanding = $1,799.19 * 123.991121
Loan Outstanding = $223,084

Answer c.

Time Period = 10 years or 120 months

Loan Outstanding = $1,799.19/1.00441667 + $1,799.19/1.00441667^2 + … + $1,799.19/1.00441667^119 + $1,799.19/1.00441667^120
Loan Outstanding = $1,799.19 * (1 - (1/1.00441667)^120) / 0.00441667
Loan Outstanding = $1,799.19 * 92.990414
Loan Outstanding = $167,307


Related Solutions

Suppose that you take out a 30-year mortgage loan of $200,000 at an interest rate of...
Suppose that you take out a 30-year mortgage loan of $200,000 at an interest rate of 10%. What is your total monthly payment? How much of the first month’s payment goes to reduce the size of the loan? If you can afford to pay $2,000 per month, how long would it take you to pay for this loan (still at 10% interest)? If you can only pay $1,700 per month, and still want to finish paying in 30 years, what...
Suppose you take out a $107,000, 20-year mortgage loan to buy a condo. The interest rate...
Suppose you take out a $107,000, 20-year mortgage loan to buy a condo. The interest rate on the loan is 4%. To keep things simple, we will assume you make payments on the loan annually at the end of each year. a. What is your annual payment on the loan? (Do not round intermediate calculations. Round your answer to 2 decimal places.) b. Construct a mortgage amortization. (Do not round intermediate calculations. Round your answers to 2 decimal places.) c....
Assume you want to take out a $300,000 loan on a 25-year mortgage with end of...
Assume you want to take out a $300,000 loan on a 25-year mortgage with end of month payments. The annual rate of interest is 8 percent. 20 years from now, you need to make an ending additional lump sum payment of $45,000. Because you expect your income to increase, you want to structure the loan so that the beginning of each year your monthly payments increase by 2.5 percent. Determine the amount of each year’s monthly payment with Excel Solver.
If you take out a car loan for $35,000, will pay an annual interest rate of...
If you take out a car loan for $35,000, will pay an annual interest rate of 4% on the loan, and make monthly payments of $547.58, how many payments will you need to make? -What are you solving for? -What is your answer?
This morning, you took out a loan of $386,000 to purchase a home. The interest rate...
This morning, you took out a loan of $386,000 to purchase a home. The interest rate on the 30-year mortgage is 3.75 percent and you will make monthly payment. You have decided to make additional monthly payment of $360 beginning with the first payment that will occur one month from today. By how many years will you shorten the length of time it will take you to pay off the loan? Group of answer choices 11.06 years 9.33 years 12.84...
You take out a 15-year $335,000 mortgage loan with a rate of 6% and annual payments....
You take out a 15-year $335,000 mortgage loan with a rate of 6% and annual payments. In 6 years you decide to pay off the mortgage. What is the principal balance on the loan after 6 years?
Suppose you take out a 30 year mortgage for $460000 at an annual interest rate of...
Suppose you take out a 30 year mortgage for $460000 at an annual interest rate of 3.5%. You plan to sell the house after 10 years. Question 1 How much do you owe on the house after five years? Question 2 How much do you owe on the house after ten years? After five years you have the opportunity to refinance what you owe at an interest rate of 3.25% for 30 years. Question 3 How much would you gain...
Suppose you take out a 30 year mortgage for $490000 at an annual interest rate of...
Suppose you take out a 30 year mortgage for $490000 at an annual interest rate of 4.0%. You plan to sell the house after 10 years. Question 1 How much do you owe on the house after five years?(No Response) Question 2 How much do you owe on the house after ten years?(No Response) After five years you have the opportunity to refinance what you owe at an interest rate of 3.75% for 30 years. Question 3 How much would...
A family needs to take out a 30​-year home mortgage loan of $140,000 through a local...
A family needs to take out a 30​-year home mortgage loan of $140,000 through a local bank. Annual interest rates for 30-year mortgages at the bank are 8.1 % compounded monthly. ​(a) Compute the​ family's monthly mortgage payment under this loan. ​(b) How much interest will the family pay over the life of the​ loan?
1. Suppose you take out a 30-year mortgage for $207,418 at an annual interest rate of...
1. Suppose you take out a 30-year mortgage for $207,418 at an annual interest rate of 3.1%. After 20 years, you refinance to an annual rate of 2.0%. How much interest did you pay on this loan? Round your answer to the nearest dollar. _____________________ 2. Consider a 20-year mortgage for $183,858 at an annual interest rate of 4.9%. After 10 years, the mortgage is refinanced to an annual interest rate of 2.9%. What are the monthly payments after refinancing?...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT