Question
Please help to answer part C only. Answer is $49,331.78
Ten years ago, you entered into an 25-year, fixed-rate mortgage at 6 % annual interest rate with monthly payments of $1,198.4
(b) Today, you would like to make an immediate $50,000 lump sum payment to shorten the payment duration. When will you pay of
0 0
Add a comment Improve this question Transcribed image text
Answer #1

Original Tenure = 25 years, Remaining Tenure = 25 - 10 = 15 years, Fixed Rate = 6%, Monthly Repayments = $ 1198.4

Applicable Monthly Rate = 6/12 = 0.5 %

Outstanding Mortgage at the end of Year 10 = 1198.4 x (1/0.005) x [1-{1/(1.005)^(180)}] = $ 142014.612

Lump sum Payment = $ 50000

Remaining Mortgage = 142014.612 - 50000 = $ 92014.612

Let the number of additional required payments be N

Therefore, 92014.612 = 1198.4 x (1/0.005) x [1-{1/(1.005)^(N)}]

0.3839061 = [1-{1/(1.005)^(N)}]

1/(1.005)^(N) = 0.616094

(1.005)^(N) = 1.62313

N = log1.0051.62313 = 97.113 months ~ 98 months

Total Payment Made = 98 x 1198.4 + 120 x 1198.4 = 260188.4016

Total Payment under Original Repayment Plan = 300 x 1198.4 = $ 359520

Interest Saved = 359520 - 260188.4016 = $ 99331.78

NOTE: Please check the answer provided by you as I have checked the calculation multiple times and the answer for portion (b) is indeed $ 99331.78

Add a comment
Know the answer?
Add Answer to:
Please help to answer part C only. Answer is $49,331.78 Ten years ago, you entered into...
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...

  • Question 5 Ten years ago you borrowed $258000. The term of the loan was 23 years...

    Question 5 Ten years ago you borrowed $258000. The term of the loan was 23 years and required monthly payments of $2756.90. The interest rate on the loan was 12 percent compounded monthly. You have just made the 138th payment. What is the principal outstanding? $190069.34 $171546.34 $129000.00 $205855.27

  • 3. Five years ago the Jones purchased a $380,000 home in New Westminster. They made a...

    3. Five years ago the Jones purchased a $380,000 home in New Westminster. They made a down payment of exactly 25% and mortgaged the balance with New Westminster Credit Union. The interest rate was 5.25% compounded semi-annually, for a five-year term, amortized over 25 years. (a) Calculate the size of the monthly payment required. The credit union rounds the payment up to the next dollar. [5 marks] ANSWER (b) How much interest did the Jones pay in the third year...

  • sixty months ago, you got a loan from your bank for $10,000. This is a ten...

    sixty months ago, you got a loan from your bank for $10,000. This is a ten year loan with an APR of 12% and with monthly payments of $143.47 each. Today, you decided you want to pay off the loan in two years rather than the remaining life of the loan. What is the balance of the loan today? 2. How much more do you have to add to your monthly payment in order to accomplish your goal of paying...

  • answer for e and f written show steps please QuestIuI120 pm Enter the complete solution for...

    answer for e and f written show steps please QuestIuI120 pm Enter the complete solution for each part in the space provided below. Highlight in BOLD your final answer for each part. Note for Part a, b, c, d, and e the solutions only require the financial calculator. For Part f you will need to use some algebra to solve the question. A $200,000 mortgage is to be amortized over 25 years with monthly payments at an interest rate of...

  • 6. A company issued a 25-year bond two years ago at a coupon rate of 5.3...

    6. A company issued a 25-year bond two years ago at a coupon rate of 5.3 percent. The bond makes semiannual coupon payments. If the bond currently sells for 105 percent of its par value of $1,000, what is the YTM? 7. Bond X makes semiannual payments. The bond pays a coupon rate of 7 percent, has a YTM of 6.2 percent, and has 13 years to maturity. Bond Y makes semiannual payments. This bond pays a coupon rate of...

  • please do C part only Assume that your group represents the Credit Manager of a North...

    please do C part only Assume that your group represents the Credit Manager of a North Vancouver Credit Union and that Mr. Wayne Gretski, on his way through Vancouver to the 2022 Olympics, has asked that you analyze the history of his previous and current mortgage transactions. Exactly 10 years ago, Mr. Wayne Gretski purchased a beautiful condo at Whistler for $760,000 and made a down payment of $295,000. The balance was mortgaged at the Canada Bank at 4.30% compounded...

  • Five years ago you borrowed $230,000 to finance the purchase of a $290,000 house. The interest...

    Five years ago you borrowed $230,000 to finance the purchase of a $290,000 house. The interest rate on the old mortgage is 5.5%. Payment terms are being made monthly to amortize the loan over 30 years. You have found another lender who will refinance the current outstanding loan balance at 3.5% with monthly payments for 25 years. There are no prepayment penalties associated with either loan. You feel the appropriate refinancing cost is 5% of the new loan amount. a....

  • 1. Ten years ago Heather borrowed $400,000 to buy a house. She has a 30 year,...

    1. Ten years ago Heather borrowed $400,000 to buy a house. She has a 30 year, 4.50% fixed rate mortgage. She made the 120th payment today. Payments are made monthly. She now owes $_________ on the house. 2. Today is your 25th birthday. You will begin making equal deposits on each birthday until your 65th birthday into an account that earns 6%. The first deposit will be made today. You want to withdraw $75,000 per year beginning on your 71st...

  • Ten years ago you sold some land to a neighbor for $100,000 under an agreement for...

    Ten years ago you sold some land to a neighbor for $100,000 under an agreement for sale which stated that the payments were to be equal installments of principal and interest made on an annual basis over 20 years at an interest rate of 5% per year. Ten payments have been made and now the neighbor wants to pay off the balance owing with a bank loan at 4%. What is the minimum you should be willing to accept assuming...

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