Question

Mr. Wilson’s house was purchased for $280,000 five years ago and is worth $300,000 now, and...

Mr. Wilson’s house was purchased for $280,000 five years ago and is worth $300,000 now, and his mortgage was $ 260,000 and amortized over 25 years, at four percent interest, compounded semi-annually, what is his equity in his house now? (To the nearest $1000) (Show your calculations—You must assume monthly mortgage payment frequency; hint, and use amortization schedule)

Homework Answers

Answer #1

Effective monthly interest rate, r = (1 + 0.04/2)^(1/6) - 1

r = 0.003305890325

First, let's find the monthly payment.

Initial mortgage = $260,000

n = 25 * 12 = 300

Now, let's find the outstanding balance after 5 years.

n = (25 - 5) * 12 = 240

Mr. Wilson's equity = Current worth - Mortgage balance

Mr. Wilson's equity = 300,000 - 226,340.179655602

Mr. Wilson's equity = $73,659.820344398

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
A house that was bought 8 years ago for $150,000 is now worth $300,000. Originally,the house...
A house that was bought 8 years ago for $150,000 is now worth $300,000. Originally,the house was purchased by paying 20% down with the rest financed through a 25-year mortage at 10.5%. The owner (after making 96 equal monthly payments) is in need of cash, and would like to refinance the house. The finance company is willing to loan 80% of the new value of the house amortized over 25 years with the same interest rate. How much cash will...
Lucy purchased a house for $400,000. She made a down payment of 25.00% of the value...
Lucy purchased a house for $400,000. She made a down payment of 25.00% of the value of the house and received a mortgage for the rest of the amount at 4.62% compounded semi-annually amortized over 20 years. The interest rate was fixed for a 5 year period. a. Calculate the monthly payment amount. b. Calculate the principal balance at the end of the 5 year term. c. Calculate the monthly payment amount if the mortgage was renewed for another 5...
Lionel purchased a house for $475,000. He made a downpayment of 25.00% of the value of...
Lionel purchased a house for $475,000. He made a downpayment of 25.00% of the value of the house and received a mortgage for the rest of the amount at 5.82% compounded semi-annually amortized over 20 years. The interest rate was fixed for a 4 year period. a. Calculate the monthly payment amount. b. Calculate the principal balance at the end of the 4 year term c. Calculate the monthly payment amount if the mortgage was renewed for another 4 years...
Ali purchased a house for $450,000. He made a down payment of 15.00% of the value...
Ali purchased a house for $450,000. He made a down payment of 15.00% of the value of the house and received a mortgage for the rest of the amount at 6.22% compounded semi-annually amortized over 20 years. The interest rate was fixed for a 5 year period. a. Calculate the monthly payment amount. Round to the nearest cent b. Calculate the principal balance at the end of the 5 year term. Round to the nearest cent c. Calculate the monthly...
Ali purchased a house for $450,000. He made a down payment of 15.00% of the value...
Ali purchased a house for $450,000. He made a down payment of 15.00% of the value of the house and received a mortgage for the rest of the amount at 6.22% compounded semi-annually amortized over 20 years. The interest rate was fixed for a 5 year period. a. Calculate the monthly payment amount. Round to the nearest cent b. Calculate the principal balance at the end of the 5 year term. Round to the nearest cent c. Calculate the monthly...
1. You want to purchase a house that is priced at $300,000. You can get a...
1. You want to purchase a house that is priced at $300,000. You can get a loan for 80 percent of the bank's appraised value at 5.25% for 30 years with monthly amortization. The bank's appraiser has a theory that the value of a house is 95% of the asking price and appraises it accordingly. What will be your monthly payment if you take the loan? 2.Set up an amortization schedule for years 1 through 5 for Problem 1 showing...
You want to buy a house in 15 years that costs $300,000 now. Inflation is 3%....
You want to buy a house in 15 years that costs $300,000 now. Inflation is 3%. How much do you need to save each year to be able to buy the house (for cash, without a mortgage,) if you can earn 6% (compounded annually) on your savings? (Answer to the nearest cent.) How do I solve this in excel?
It’s been exactly five years since Mr. Smith bought his house with a 30-year mortgage which...
It’s been exactly five years since Mr. Smith bought his house with a 30-year mortgage which had an interest rate of 9.00% (APR, monthly compounding). The outstanding balance of the current mortgage is $178,799.01. In the intervening five years, interest rates have fallen and so Mr. Smith has decided to refinance the remaining balance on his current mortgage with a new 32-year mortgage which has monthly payments and an interest rate of 5.7% (APR, monthly compounding). How much would the...
Mr. and Mrs. Spirit purchased a $35,000 house 20 years ago. They took a 30-year mortgage...
Mr. and Mrs. Spirit purchased a $35,000 house 20 years ago. They took a 30-year mortgage for $30,000 at a 3% annual interest rate. Their bank, the First Amityville National Bank, has recently offered the Spirits two alternatives by which they could prepay their mortgage. The Spirits have just made their 20th annual payment. [A] Under the first alternative, the Spirits could prepay their mortgage at a 30% discount from the current principal outstanding. If current 10-year mortgage rates are...
You have decided to become a student landlord and plan to buy a house  for $920,000. You...
You have decided to become a student landlord and plan to buy a house  for $920,000. You parents have agreed to supply $200,000 to be used as a down payment, leaving $720,000 to be financed by means of a mortgage. The mortgage broker has quoted 5.25% quoted rate based on a 25-year amortization, which will be compounded semi-annually in accordance with Canadian law. Required: a) What would be the amount of monthly payments on the mortgage? b) What would be the...