Question

In: Finance

Without excel or excel steps Review Question 2 Suppose you bought a house 12 years ago...

Without excel or excel steps

Review Question 2 Suppose you bought a house 12 years ago with a 30-year mortgage for $200,000. The mortgage has a fixed interest rate of 7 percent compounded monthly. (a) What are the monthly mortgage payments? (b) What is the amount if you pay off your mortgage today? You just made the recent mortgage payment earlier today. A. monthly mortgage payments ? B. of 360 payments 144 done, 216 left but I made one today 3-25-2019 so 215 left how do you find out what the pay off if you wanted to payoff house today?

Solutions

Expert Solution

AS SEE THE IMAGE. ANY DOUBTS, FEEL FREE TO ASK. THUMBS UP PLEASE

As you are paying off mortgage today, we have to take 216 instalments left and not 215.

it is already given that you made one payment earlier today, that means 144th payment is done. and 216 are left. Thank you


Related Solutions

You bought your house five years ago and you believe you will be in the house...
You bought your house five years ago and you believe you will be in the house only about five more years before it gets too small for your family. Your original home value when you bought it was $500,000, you paid 10 percent down, and you financed closing costs equal to 3 percent of the mortgage amount. The mortgage was a 25-year fixed- rate mortgage with a 5 percent annual interest rate. Rates on 30-year mortgages are now at 3...
Suppose that 2 years ago you bought an old record player at a yard sale for...
Suppose that 2 years ago you bought an old record player at a yard sale for $8. You saw today on E-bay that the same record player is selling for $55. If you were to sell the record play at that price today, what would be the implied return percentage? (Convert to a percent. An investment will pay $18,219 in 16 years. If the interest rate is 11.09%, how much is it worth today? 3      An investment will pay...
Three years ago, you bought a 12% bond that had 7 years to maturity and a...
Three years ago, you bought a 12% bond that had 7 years to maturity and a yield to maturity of 12%. Today (after the sixth interest payment), you sold the bond when it is yielding 13%. What is your annual rate of return for the three year period? All coupon payments are semi-annual, and the par value is $1,000.
1. You bought your house 5 years ago, and your original home value when you bought...
1. You bought your house 5 years ago, and your original home value when you bought it was $450,000, you paid 20% down and you financed closing costs equal to 4% of the mortgage amount. The mortgage was a 30-year fixed rate mortgage with a 6.5% annual interest rate. Rates on 30-year mortgages are now at 5% if you pay 2 points upfront. Your refinancing costs will be 2% of the new mortgage amount (excluding points). You won't finance the...
Three years ago, you bought a house. You took out a $350,000.00 mortgage at 4.75% for...
Three years ago, you bought a house. You took out a $350,000.00 mortgage at 4.75% for 30 years. Now that interest rates have fallen (beginning of year 4 of your current mortgage), you are considering refinancing your existing loan with a new 30 year loan. Your new loan must pay off the remaining balance of your old loan plus pay for all of the fees, associated with the new loan. In addition to all of the standard fees, you choose...
You bought a house two years ago and the hot water heater just died. You are...
You bought a house two years ago and the hot water heater just died. You are considering replacing it with an updated version of the same model, which would cost you $200 including installation. Your family consumes about 110 gal of hot water daily, which costs you $230 in utilities each year. The new tank comes with a 20-year guarantee, and at the end of that time, you assume it would be discarded and a new version installed, so zero...
You bought a house 8 years ago with a $250,000 mortgage. It was a 15 year loan with
You bought a house 8 years ago with a $250,000 mortgage. It was a 15 year loan with monthly payments which will pay off the loan when you make the last payment. The interest rate was 6%. What are your monthly payment and your current loan balance? How much interest will you pay in the upcoming year?  
A few years ago, you got married and bought a house with an adjustable rate mortgage...
A few years ago, you got married and bought a house with an adjustable rate mortgage with the following terms: Loan: $240,000 Term: 20 years Initial Rate: 4% Margin: 2% over the Index Rate Lifetime Max: 4.5% The index rate was 2% in year 1, 1.5% in year 2, 4% in year 3, 1% in year 4, and 1% in year 5. a) What is your loan balance at year 5? (5pts) b) What is the effective interest rate is...
A few years ago, you got married and bought a house with an adjustable rate mortgage...
A few years ago, you got married and bought a house with an adjustable rate mortgage with the following terms: Loan: $240,000 Term: 20 years Initial Rate: 4% Margin: 2% over the Index Rate Lifetime Max: 4.5% The index rate was 2% in year 1, 1.5% in year 2, 4% in year 3, 1% in year 4, and 1% in year 5. a) What is your loan balance at year 5? (5pts) b) What is the effective interest rate is...
A few years ago, you got married and bought a house with an adjustable rate mortgage...
A few years ago, you got married and bought a house with an adjustable rate mortgage with the following terms:            Loan:               $240,000             Term:              20 years            Initial Rate:      4%            Margin:          2% over the Index Rate            Lifetime Max: 4.5% The index rate was 2% in year 1, 1.5% in year 2, 4% in year 3, 1% in year 4, and 1% in year 5. What is your loan balance at year 5? What is the effective interest rate is paid off after year 5?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT