Question

5 years ago, Jimmie borrowed $281,900 to purchase a house in Sandy Lake. At the time,...

5 years ago, Jimmie borrowed $281,900 to purchase a house in Sandy Lake. At the time, the quoted rate on the mortgage was 6 percent, the amortization period was 25 years, the term was 5 years, and the payments were made monthly. Now that the term of the mortgage is complete, Jimmie must renegotiate his mortgage. If the current market rate for mortgages is 7 percent. What is Jimmie’s new monthly payment? (Round effective monthly rate to 6 decimal places, e.g. 25.125412% and final answer to 2 decimal places, e.g. 125.12. Do not round your intermediate calculations.)

New monthly payment

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

New monthly payment= $1965.53

Calculation as follows:

D17 f =PMT(D16,D13,D14*-1,D9,010) A B с D Function 1 Formula arguments Values 2 Interest rate per year (R) Given 6% 3 Interes

Add a comment
Know the answer?
Add Answer to:
5 years ago, Jimmie borrowed $281,900 to purchase a house in Sandy Lake. At the time,...
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
  • 5 years ago, Jimmie borrowed $281,900 to purchase a house in Sandy Lake. At the time,...

    5 years ago, Jimmie borrowed $281,900 to purchase a house in Sandy Lake. At the time, the quoted rate on the mortgage was 6 percent, the amortization period was 25 years, the term was 5 years, and the payments were made monthly. Now that the term of the mortgage is complete, Jimmie must renegotiate his mortgage. If the current market rate for mortgages is 7 percent. What is Jimmie’s new monthly payment? (Round effective monthly rate to 6 decimal places,...

  •           Ms. Juliet bought a house for $360,000 exactly five years ago. After making a 20%...

              Ms. Juliet bought a house for $360,000 exactly five years ago. After making a 20% down-payment, she borrowed the rest of the house payment in the form of a 15-year mortgage from her local cooperative credit union. She negotiated a mortgage rate of 3.5% APR with semi-annual compounding. She makes mortgage payments of an equal dollar amount every two weeks (i.e., biweekly), and her first mortgage payment was due two weeks after she signed the mortgage contract. If Ms....

  • 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....

  • Question 14 1 pts 15 years ago you borrowed $149,811 to buy a house. The interest...

    Question 14 1 pts 15 years ago you borrowed $149,811 to buy a house. The interest rate quoted to you was 5.2 percent for 30 years with monthly payments. Assuming you have made regular monthly payments up to now, what is the amount (in $) you still owe on the loan today? Answer to two decimals. Hint: The hard way to do this is to use an amortization table. There is an easier way - see if you can find...

  • Bubba bought his house 20 years ago, he borrowed $200,000 with a 30-year mortgage with a...

    Bubba bought his house 20 years ago, he borrowed $200,000 with a 30-year mortgage with a 5.0% APR. His mortgage broker has offered him a 10-year mortgage with a 4% APR with 3 points closing costs. What is Charlie's old monthly payment?   What is the balance on Bubba's mortgage?    What is Bubba's new monthly payment?   How many months does Bubba need to live in the house to justify the refinancing costs?

  • John and Katie bought a house in Edmonton exactly 7 years ago. They took out a...

    John and Katie bought a house in Edmonton exactly 7 years ago. They took out a mortgage of $500,000 at that time. The mortgage has a 25-year amortization period, monthly mortgage payments, and a quoted interest rate of 5% (APR, semi-annually compounded). John and Katie recently decided to buy a new house, also in Edmonton. Today they will receive payment from the buyer of their old home and make a down payment on the new house. If the old house...

  • You plan to purchase a $360,000 house using either a 30-year mortgage obtained from your local...

    You plan to purchase a $360,000 house using either a 30-year mortgage obtained from your local savings bank with a rate of 8.60 percent, or a 20-year mortgage with a rate of 7.50 percent. You will make a down payment of 15 percent of the purchase price. a. Calculate the amount of interest and, separately, principal paid on each mortgage. What is the difference in interest paid? b. Calculate your monthly payments on the two mortgages. What is the difference...

  • Problem 4 and 5-8 House Appreciation and Mortgage Payments Say that you purchase a house for $216,000 by getting a m...

    Problem 4 and 5-8 House Appreciation and Mortgage Payments Say that you purchase a house for $216,000 by getting a mortgage for $190,000 and paying a down payment of $26,000. If you get a 20-year mortgage with an interest rate of 8 percent, what are the monthly payments? (Round your final answer to 2 decimal places.) Payment What would the loan balance be in five years? (Use a payment value rounded to 2 decimal places. Round your final answer to...

  • Problem 4 and 5-7 House Appreciation and Mortgage Payments Say that you purchase a house for...

    Problem 4 and 5-7 House Appreciation and Mortgage Payments Say that you purchase a house for $320,000 by getting a mortgage for $280,000 and paying a $40.000 down payment you get a 30 year mortgage with an interest rate of 8 percent, what are the monthly payments (Do not round Intermediate calculations and round your final answer to 2 decimal places.) sont What would the loan balance be in ten years? (Round the payment amount to the nearest cent but...

  • Different types of mortgages: Suppose you are buying a house and have to borrow $200,000 by...

    Different types of mortgages: Suppose you are buying a house and have to borrow $200,000 by taking out one of the following mortgages. a) A fixed rate mortgage with 30-year-term and with mortgage rate of 7.5%. What would be the monthly payment? b) An adjustable-rate mortgage with 30-year-term and the initial mortgage rate of 7.5%. However after one year (12 months), the rate will increase to 8.5%. What will be the monthly payment after one year? c) An interest-only and...

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