Question

In: Finance

​You just bought a house for $300,000. You put $100,000 as a down payment and borrow the remaining $200,000 from a bank.

You just bought a house for $300,000. You put $100,000 as a down payment and borrow the remaining $200,000 from a bank. You take out a 30-year mortgage that charges you 6 percent APR but with monthly compounding.

              A. (15 points) How much is your monthly mortgage payment? Show your work.

              B. (5 points) How much of your second mortgage payment goes towards interest? Show your work.

Solutions

Expert Solution

- Loan amount = $200,000

a). Calculating the Monthly Payment of Loan:-

Where, P = Loan amount = $200,000

r = Periodic Interest rate = 6%/12 = 0.5%

n= no of periods = 30 years*12 = 360

Monthly Payment = $1199.10

b). Calculating the Amortization schedule of first 2 payments:-

Year Beg bal. Payment Interest amount Principal Amount End Bal.
1 200,000.00               1,199.10                     1,000.00                              199.10             199,800.90
2              199,800.90               1,199.10                        999.00                              200.10             199,600.80

So, Interest of 2nd Mortgage Payment is $999

Note- The following Columns are calculated based on:

- Interest amount = beg. Balnace*Monthly interest rate

- Principal maount = Payment - Interest amount

- End Bal. = Beg. Bal + Interest - Payment


Related Solutions

1. You just bought a house for $300,000. You put $100,000 as a down payment and...
1. You just bought a house for $300,000. You put $100,000 as a down payment and borrow the remaining $200,000 from a bank. You take out a 30-year mortgage that charges you 6 percent APR but with monthly compounding. a. How much is your monthly mortgage payment? Show your work. b. How much of your second mortgage payment goes towards interest? Show your work.
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...
"I recently bought a new house for $200,000. There was a 20% down payment, and the...
"I recently bought a new house for $200,000. There was a 20% down payment, and the rest was financed at 4.8 percent APR with monthly compounding. Monthly payments starting from next month will be $1,248.66. How many years will it take the firm to pay off this debt?" Please let me know values used in calculator or any formulas.
I recently bought a new house for $200,000. There was a 20% down payment, and the...
I recently bought a new house for $200,000. There was a 20% down payment, and the rest was financed at 4.8 percent APR with monthly compounding. Monthly payments starting from next month will be $1,248.66. How many years will it take the firm to pay off this debt?
Jingfei bought a house 6 years ago for $200,000. Her down payment on the house was...
Jingfei bought a house 6 years ago for $200,000. Her down payment on the house was the minimum required 10% at that time she financed the remainder with a 30-year fixed rate mortgage. The annual interest rate was 8% and she was required to make monthly payments, and she has just made her 72th payment. A new bank has offered to refinance the remaining balance on Jingfei's loan and she will have to pay $1,320 per month for the next...
You just purchased a $400,000 house and gave a 20% down payment. For the remaining portion,...
You just purchased a $400,000 house and gave a 20% down payment. For the remaining portion, you obtained a 30-year mortgage at a 6% interest rate. (6 points) What are the monthly payments on this mortgage? If the house appreciates at a 3 percent annually, what will be the value of the house in ten years? In ten years, how much equity will you have on this home? Answer all questions and show work in Excel. SHOW ME IN EXCEL...
I have bought a house for $300,000. I made a 20% down payment and borrowed the...
I have bought a house for $300,000. I made a 20% down payment and borrowed the rest at 4.2% APR with monthly compounding. It is a 30-year amortized loan. Prepare the first two rows of the amortization table (beginning balance, PMT, interest paid, principal paid, ending balance).
I have bought a house for $300,000. I made a 20% down payment and borrowed the...
I have bought a house for $300,000. I made a 20% down payment and borrowed the rest at 4.2% APR with monthly compounding. It is a 30-year amortized loan. What will be my payments each month at t=1,2,…,360?
1. (10 pts) You just bought a house for $400,000. You put 20% down and financed...
1. (10 pts) You just bought a house for $400,000. You put 20% down and financed the rest over 30 years at 6% nominal interest. Assuming equal monthly payments over the term of the loan, what are the monthly payments? What is the effective rate? (Chapter 4) 2. (10 pts) What would you need to invest today in an account that had a nominal rate of 8% compounded quarterly, if you wanted $12,000 in 4 years? What would be the...
Mr. Jones has just bought a house for $250,000. He will make a down payment of...
Mr. Jones has just bought a house for $250,000. He will make a down payment of 5% on the house, and pay for the rest with a mortgage. The Bank Le Friendly offers 10-year mortgage loans at 13% APR compounded semi-annually, with monthly mortgage payments starting today. What is the amount of Mr. Jones’s monthly mortgage payment? A. $3,462.31 B. $3,498.84 C. $3,546.13 D. $3,647.40 E. $3,605.56
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT