Question

In: Finance

28. John and Peggy recently bought a house. They financed the house with a $278,000, 30-year...

28. John and Peggy recently bought a house. They financed the house with a $278,000, 30-year mortgage with a nominal interest rate of 9.04%. Mortgage payments are made at the end of each month. What total dollar amount of their mortgage payments during the first 4 years will go towards repayment of principal?

Solutions

Expert Solution

No of monthly installments (N) = 30 * 12 = 360
PV of loan = $ 278000

Monthly interest rate = 9.04%/12 = 0.7533%

Monthly installment (PMT) = ??

Using financial calculator or PMT function in excel,

Monthly installment (PMT) = $2,244.86

Value of loan at the end of 4th year

No of monthly installments pending (N) = 26 * 12 = 312
Monthly interest rate = 9.04%/12 = 0.7533%

Monthly installment (PMT) = $2,244.86

Therefore value of loan at the end of year 4 (PV) = ??

Using financial calculator or PV function in excel,

value of loan at the end of year 4 (PV) = $269,330.80

Therefore, total principal repayment in 4 years = value of loan at beginning - value of loan at the end of year 4

total principal repayment in 4 years = $ 278,000 - $ 269,330.80 = $8,669.20

Therefore dollar amount of their mortgage payments during the first 4 years will go towards repayment of principal = $8,669.20

Thumbs up please if satisfied. Thanks :)

Comment for further doubts


Related Solutions

28) John and Peggy recently bought a house. They financed the house with a $229,000, 30-year...
28) John and Peggy recently bought a house. They financed the house with a $229,000, 30-year mortgage with a nominal interest rate of 6.63%. Mortgage payments are made at the end of each month. What total dollar amount of their mortgage payments during the first 4 years will go towards repayment of principal? $66,025.39 $59,359.34 $10,106.84 $11,059.99 $14,249.02
John and Peggy recently bought a house. They financed the house with a $150,000, 30-year mortgage...
John and Peggy recently bought a house. They financed the house with a $150,000, 30-year mortgage with a nominal interest rate of 6.68%. Mortgage payments are made at the end of each month. What total dollar amount of their mortgage payments during the first 4 years will go towards repayment of principal?
1. Peggy and John Schultz bought the house of their dreams seven years ago. The price...
1. Peggy and John Schultz bought the house of their dreams seven years ago. The price was $475,000, though they negotiated it down to a more agreeable $449,500. They paid 20% of that in cash, as a down payment and financed the rest using a 25-year, 4.15% mortgage. Peggy was doing bills the other day and decided to figure out just how much their monthly payment was and how much interest they had paid thus far. She also wants to...
You have financed a house with a 30-year, monthly payable mortgage in the amount of $400,000...
You have financed a house with a 30-year, monthly payable mortgage in the amount of $400,000 at a fixed rate of 8% per year compounded monthly. a. What are your monthly mortgage payments? b. How much of the first month’s payment is accounted for by interest on your loan? c. To help pay off the mortgage early, you pay an extra $2000 with the 1st payment. How many payments will you need to make to pay off the remainder of...
You bought a $225,000 house with a $40,000 down payment and financed the remaining $185,000 with...
You bought a $225,000 house with a $40,000 down payment and financed the remaining $185,000 with a 30-year mortgage (home loan). The interest rate on the loan is 5%. a) Find the monthly payment. b) After 12 years of paying on this mortgage, you decide to explore refinancing. With 18 years left to go, what is your remaining loan balance? c) If you do refinance the amount from part (b) with a new 15-year loan at 3% interest, how much...
Jackie bought a $200,000 house and has a 30 year mortgage at anominal interest rate...
Jackie bought a $200,000 house and has a 30 year mortgage at a nominal interest rate of 4.8% convertible monthly. Jackie must pay level payments at the end of each month. Find the amount of her monthly mortgage payment. After 200 payments have been made, what is the ratio of total interest paid to total principal repaid?
. A promissory note was executed by Billy when he bought his house. He financed the...
. A promissory note was executed by Billy when he bought his house. He financed the purchase with No Fraud National Bank. This purchase was in 2017 and the note was for 360 equal monthly payments, with a fixed rate of interest, with the payments due the first of each month, beginning on February 1, 2017. No Fraud sold the note to Investments, Inc on February 15, 2017. Investments, Inc sold the note to We Buy Notes on July 1,...
Wally has just bought a house by taking a 30-year, $127,500 mortgage from the bank. The...
Wally has just bought a house by taking a 30-year, $127,500 mortgage from the bank. The interest rate is 8.25%. The mortgage is to be retired by payments made every month starting next month. How much does Wally have to pay each month to repay the mortgage? What would the monthly payments be if Wally opts for a 15-year mortgage at the same interest rate?
Tom Miller owns a house that he bought 5 years ago for $200,000. He financed the...
Tom Miller owns a house that he bought 5 years ago for $200,000. He financed the purchase with an 80% LTV loan at 7% interest and a 30-year amortization term with monthly payments. Interest rates have since fallen and a new loan (which is equal to the balance of the original loan) is now available at 5.25% interest rate with 4 discount points and is amortized over 25 years with monthly payments. Neither mortgage requires a prepayment penalty. Assume that...
A promissory note was executed by Billy when he bought his house. He financed the purchase...
A promissory note was executed by Billy when he bought his house. He financed the purchase with No Fraud National Bank. This purchase was in 2017 and the note was for 360 equal monthly payments, with a fixed rate of interest, with the payments due the first of each month, beginning on February 1, 2017. No Fraud sold the note to Investments, Inc on February 15, 2017. Investments, Inc sold the note to We Buy Notes on July 1, 2017....
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT