Question

You are doing some bookkeeping concerning a mortgage you took out 10 years ago, $500,000 used...

You are doing some bookkeeping concerning a mortgage you took out 10 years ago, $500,000 used to finance a home. You presume it is a 30-year mortgage. You are trying to determine the interest rate (mortgage equivalent yield) on the loan. You know that the monthly payments are $4,023.11. So, you assume therefore that the interest rate on the loan is 9% and call your mortgage broker to check this out. Looking at your numbers, he tells you that you have two things incorrect. First, this was a weird mortgage that did not start with a 30-year maturity. Second, the 9%, it turns out, was purely coincidental. He also tells you that the actual interest paid thus far is 8.78% less than that shown in your calculations based on the 9% interest rate and a $500,000 loan – that is the interest paid is .9122 times the figure calculated from your mortgage calculation. From this information, can you determine the actual terms of the mortgage: rate and maturity?

0 0
Add a comment Improve this question Transcribed image text
Answer #1

Interest rate on the loan: 8.5%

Maturity: 25 years

First, assuming 9% interest rate on a 30-year mortgage, I can use Excel to calculate howmuch interest I have paid in the past 10 years.

Month 1 2. 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 Total monthly Payment 4023.11 4023.11 4023.11 4023.1

29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 4023.11

79 80 81 82 83 84 85 86 87 88 80 90 91 92 93 94 95 96 97 4023.11 4023.11 4023.11 4023.11 4023.11 4023.11 4023.11 4023.11 4023

99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 Total 4023.11 4023.11 4023.11 4023.11

As you can see from the table, the total interest payment that I have made in the past 10 yearsis $429,922.52, assuming 9% interest rate on a 30-year mortgage.

Then, according my broker’s description, I can calculate my actual interest payment, whichis: 429,922.52 * 0.9122 = $392,175.32

Then, using Excel, I keep plugging in different interest rates into my formula until I get thetotal interest payment equals $392,175.32. Using this method, I figure out the interest rate onthe loan is 8.5% and the monthly rate is 0.7083%.

Then, I put monthly payment 4023.11 and monthly rate 0.7083% into the annuity formulaand solve for the maturity, getting the maturity is 300 months, which is equivalent to 25years.

Therefore, I know this is a 25-year mortgage with 8.5% annul interest

Add a comment
Know the answer?
Add Answer to:
You are doing some bookkeeping concerning a mortgage you took out 10 years ago, $500,000 used...
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. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Ten years ago you obtained a 30-year mortgage for $400,000 with a fixed interest rate of...

    Ten years ago you obtained a 30-year mortgage for $400,000 with a fixed interest rate of 3% APR compounded monthly. The mortgage is a standard fixed rate mortgage with equal monthly payments over the life of the loan. What are the monthly fixed mortgage payments on this mortgage (i.e., the minimum required monthly payments to pay down the mortgage in 30 years)? What is the remaining loan balance immediately after making the 120th monthly payment (i.e., 10 years after initially...

  • years ago you took out a $350,000​, 25​-year mortgage with an annual interest rate of 77...

    years ago you took out a $350,000​, 25​-year mortgage with an annual interest rate of 77 percent and monthly payments of ​$2,473.732. What is the outstanding balance on your current loan if you just make the 108th ​payment?

  • [2 points] Suppose that 15 years ago you bought a home for $500,000, paying 20% as...

    [2 points] Suppose that 15 years ago you bought a home for $500,000, paying 20% as a down payment, and financing the rest at 5% interest for 30 years. How much money did you pay as your down payment? [2 points] How much money was your existing mortgage (loan) for? [2 points] What is your current monthly payment on your existing mortgage? Note: Carry at least 4 decimal places during calculations, but round your final answer to the nearest cent....

  • 10 Years ago you took out a 30-year mortgage to buy a house. Your annual payment...

    10 Years ago you took out a 30-year mortgage to buy a house. Your annual payment is $18,162 and your current interest rate is 6%. Suppose you now want to refinance and still pay off the house in 20 years, how much principal do you still owe on the mortgage? I keep getting the wrong answer using my BA II Plus Calculator. The correct Answer is $208,316.71

  • Five years ago you took out a​ 5/1 adjustable rate mortgage and the​ five-year fixed rate...

    Five years ago you took out a​ 5/1 adjustable rate mortgage and the​ five-year fixed rate period has just expired. The loan was originally for $ 294,000with 360 payments at 4.2 % APR, compounded monthly. a. Now that you have made 60 ​payments, what is the remaining balance on the​ loan? b. If the interest rate increases by1 %​, to 5.2 % APR, compounded​ monthly, what will be your new​ payments? a. Now that you have made 60 ​payments, what...

  • Five years ago you took out a​ 5/1 adjustable rate mortgage and the​ five-year fixed rate...

    Five years ago you took out a​ 5/1 adjustable rate mortgage and the​ five-year fixed rate period has just expired. The loan was originally for $ 310 comma 000 with 360 payments at 4.4 % ​APR, compounded monthly. a. Now that you have made 60 ​payments, what is the remaining balance on the​ loan? b. If the interest rate increases by 0.9 %​, to 5.3 % ​APR, compounded​ monthly, what will be your new​ payments? a. Now that you have...

  • You've decided to buy a house that is valued at $1 million. You have $500,000 to...

    You've decided to buy a house that is valued at $1 million. You have $500,000 to use as a down payment on the house and want to take out a mortgage for the remainder of the purchase price. Your bank has approved your $500,000 mortgage and is offering a standard 30-year mortgage at a 9% Foxed nominal interest rate (called the loan's annual percentage rate, or APR). Under this loan proposal, your mortgage payment will be per month (Note: Round...

  • Five years ago you took out a 5/1 adjustable rate mortgage and the five-year fixed rate...

    Five years ago you took out a 5/1 adjustable rate mortgage and the five-year fixed rate period has just expired. The loan was originally for $302,000 with 360 payments at 4.3% APR, compounded monthly a. Now that you have made 60 payments, what is the remaining balance on the loan? b. If the interest rate increases by 1.1%, to 5.4% APR, compounded monthly, what will be your new payments? a. Now that you have made 60 payments, what is the...

  • aSuppose you bought a house and took out a mortgage for $100,000. The interest rate is...

    aSuppose you bought a house and took out a mortgage for $100,000. The interest rate is 3%, and you must amortize the loan over 10 years with equal end-of-year payments. A. Calculate the mortgage payment using the Excel function Rate Nper PV FV Payment B. Set up an amortization schedule that shows the annual payments and the amount of each payment that repays the principal and the amount that constitutes interest expense to the borrower and interest income to the...

  • 1.) When you purchased your house 12 years ago, you took out a $300,225 mortgage to...

    1.) When you purchased your house 12 years ago, you took out a $300,225 mortgage to be paid back monthly over 30 years, with an APR of 6% compounded monthly. You have just made a payment and now have decided to pay the mortgage off by repaying the outstanding balance. a) What is your monthly payment on the mortgage? b.) What is the remaining balance of your mortgage? (Note there are 18 years left on the mortgage.)

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT