Question

In: Finance

You borrowed $220,000 for 30 years to buy a house. The mortgage, which has constant monthly...

You borrowed $220,000 for 30 years to buy a house. The mortgage, which has constant monthly payments and is fully amortizing, has an interest rate of 4.75% per year. What is the amount of interest you pay in the third year?

Question 2 options:

1)

$9,941

2)

$10,107

3)

$9,972

4)

$10,088

5)

$10,039

Solutions

Expert Solution

Loan Amount = PV = $220,000

n = 30 * 12 = 360 months

r = monthly interest rate = 4.75%/12 = 0.395833333%

Monthly loan payment = [r*PV] / [1 - (1+r)^-n]

= [0.395833333% * $220,000] / [1 - (1+0.395833333%)^-360]

= $870.833333 / 0.758813772

= $1,147.62457

Monthly loan payment is $1,147.62

x1 = 2*12 = 24 months

x2 = 3*12 = 36 months

Loan balance at the end of 2nd year = P * [1 - (1+r)^-(n-x1)] / r

= $1,147.62 * [1 - (1+0.395833333%)^-(360-24)] / 0.395833333%

= $1,147.62 * 0.734827181 / 0.00395833333

= $213,044.809

= $213,044.81

Loan balance at the end of 3rd year = P * [1 - (1+r)^-(n-x1)] / r

= $1,147.62 * [1 - (1+0.395833333%)^-(360-36)] / 0.395833333%

= $1,147.62 * 0.721953614 / 0.00395833333

= $209,246.78

Total amount paid in 3rd year = 12 * $1,147.62 = $13,771.44

Principal reduction in year 3 = loan balance at the end of year 2 - loan balance at the end of year 3

= $213,044.81 - $209,246.78

= $3,798.03

Interest paid in year 3 = Total amount paid in year 3 - principal reduction in year 3

= $13,771.44 - $3,798.03

= $9,973.41

Therefore, interest paid in year 3 is $9,973

Option 3 is correct


Related Solutions

You borrowed $270,000 for 30 years to buy a house with a graduated payment mortgage with...
You borrowed $270,000 for 30 years to buy a house with a graduated payment mortgage with an interest rate of 5.25% per year. The first year’s monthly payments are $1,123.74, and the payments increase 7.0% per year for five years. What is the monthly payment at the beginning of the third year? Question 14 options: 1) $1,376.63 2) $1,472.99 3) $1,576.10 4) $1,286.57 5) $1,328.95
You have borrowed $56000 as a mortgage loan to buy a house. The bank will charge...
You have borrowed $56000 as a mortgage loan to buy a house. The bank will charge interest at the rate of 9% annually and requires a minimum monthly payment of $500. At the end of five years, you must pay off the entire mortgage by a “balloon payment”. You plan to pay only the minimum amount each month and then pay off the loan with the final payment. Find this balloon payment. (Answer: $49966.07) please answer in excel format
This morning, you borrowed $162,000 to buy a house. The mortgage rate is 4.35 percent. The...
This morning, you borrowed $162,000 to buy a house. The mortgage rate is 4.35 percent. The loan is to be repaid in equal monthly payments over 20 years with the first payment due one month from today. Assume each month is equal to 1/12 of a year and all taxes and insurance premiums are paid separately. How much of the five payment applies to the principal balance?
A 30-year mortgage for $220,000 has monthly payments at a 6% nominal annual rate. If a...
A 30-year mortgage for $220,000 has monthly payments at a 6% nominal annual rate. If a borrower’s loan origination fee is 3% and is added to the initial balance, what is the true effective cost of the loan? (8 pts) If the house is sold after six years and the loan is paid off, what is the effective interest rate? (4 pts) Graph the effective interest rate as the time to sell the house and pay off the loan varies...
You are borrowing $200,000 to buy a house. The terms of the mortgage call for monthly...
You are borrowing $200,000 to buy a house. The terms of the mortgage call for monthly payments for 30 years at 6% interest. What is the amount of each monthly payment? A. $1171.91 B. $1199.10 C. $1161.14 D. $1230.15
On June 1, you borrowed $230,000 to buy a house. The mortgage rate is 8 percent....
On June 1, you borrowed $230,000 to buy a house. The mortgage rate is 8 percent. The loan is to be repaid in equal monthly payments over 20 years. The first payment is due on July 1. Assume that each month is equal to 1/12 of a year. How much of the second payment (on August 1) applies to the principal balance? $ How much of the second payment (on August 1) is interest? $ How much of the third...
#1) On June 1, you borrowed $195,000 to buy a house. The mortgage rate is 5.20...
#1) On June 1, you borrowed $195,000 to buy a house. The mortgage rate is 5.20 percent. The loan is to be repaid in equal monthly payments over 15 years. How much of the first payment applies to the principal balance? $714.43 $722.50 $717.51 $756.70 $658.56 #13) You want to borrow $34,800 and can afford monthly payments of $960 for 48 months, but no more. Assume monthly compounding. What is the highest APR rate you can afford? 13.18 percent 14.52...
You are looking for a $312,598 mortgage to buy a house. The mortgage has a 7...
You are looking for a $312,598 mortgage to buy a house. The mortgage has a 7 year term with a 22 year amortization. The rate on the mortgage is 2.75% APR with monthly compounding and monthly payments. What is the balloon payment on the mortgage? Round your answer to 2 decimal places. (For example 2.437 = 2.44)
Bubba bought his house 20 years ago, he is borrowed $200,000 with a 30-year mortgage with...
Bubba bought his house 20 years ago, he is 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? What are Bubba's present value savings after paying the points if he plans to live in the house until the mortgage is paid off?
On 1/1/20x1 you have borrowed $450,000 from a mortgage bank to buy a new house, and...
On 1/1/20x1 you have borrowed $450,000 from a mortgage bank to buy a new house, and wish to repay the mortgage loan and the interest in 5 equal annual payments, the first one being payable on 12/31/20x1. The mortgage loan bears interest at 7%.         a) Calculate the annual mortgage payment required. Round off to the nearest cent (e.g.,    $112,753.32). b) Construct the mortgage payment schedule to see if the loan and interest will be paid    in full...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT