Question

In: Finance

Question 3: Floating Rate Mortgage (8 marks) John is planning to buy a house worth $450,000,...

Question 3: Floating Rate Mortgage

John is planning to buy a house worth $450,000, has $100,000 in savings that he will use as adown-payment and will borrow the remainder via a mortgage. He selects a floating rate, closed mortgage with a 3 year term and 25 year amortization period. He will make monthly payments and be charged an interest rate of 3.35% p.a., compounded semi-annually.

Part A: How much will John owe after 1 year has passed if interest rates do not change?

Part B: How much will John owe at the end of his term if, after 1 year, interest rates rise to 3.65%p.a., semi-annual compounding? What fraction of his payments went to principal and what fraction went to interest?

Solutions

Expert Solution

Monthly equivalent rate applicable to APR of 3.35% compounded semi annually= ((1+3.35%/2)^2)^(1/12)-1 = 0.277238%

Monthly equivalent rate applicable to APR of 3.65% compounded semi annually= ((1+3.65%/2)^2)^(1/12)-1 = 0.301879%

Part A: Money that John owe after 1 year has passed if interest rates do not change= $340,867.37

Part B:

Money that John owe at the end of his term if, after 1 year, interest rates rise to 3.65%p.a., semi-annual compounding= $322,368.32

Fraction of his payments went to principal = 43.72152%

Fraction of his payments went to interest= 56.27848%

Calculation as below:


Related Solutions

Suppose you need a 5-year mortgage loan to purchase a house that worth $450,000. The bank...
Suppose you need a 5-year mortgage loan to purchase a house that worth $450,000. The bank offers two interest rate options for you to choose: (i). Fixed rate at 3.5%. Interest rate will remain fixed for that loan's entire term, no matter how the market interest rate changes. (ii). Variable rate which varies with market interest rate and is typical 1.5% above the market interest rate. Which one would you choose? Briefly explain why.
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...
You take out a mortgage to buy a house worth $300,000. If the down payment is...
You take out a mortgage to buy a house worth $300,000. If the down payment is 30%, the annual interest rate is 6% compounded monthly, and the term of the mortgage is 30 years, what are your monthly mortgage payments? a) $1,079 b) $1,259 c) $1,439 d) $1,505 e) $1,719
You are planning to buy a house appraised for $350,000 and finance it through a mortgage...
You are planning to buy a house appraised for $350,000 and finance it through a mortgage of $300,000. What is the loan-to-value ratio and is it be above or below the normal cutoff set by your lender of 80 percent for a prime mortgage? Being securely employed, your take-home pay is $2,300 per month and you have no substantial other debts. Your lender has offered you a 2.5 percent, 30 year, fixed-rate mortgage. What is the amount that you will...
: Mortgage Loan Analysis: A resident in Victoria is planning to buy a new house in...
: Mortgage Loan Analysis: A resident in Victoria is planning to buy a new house in March 2018. The sale price of the house is $336,000. He plans to pay 20% down payments and borrow additional 80% from Wells Fargo with a 30-year, 4.375% fixed-rate mortgage loan. He is expected to pay an equal MONTHLY payment starting from April 2018 for a total of 30 years. (1) Calculate the required monthly mortgage payment for Mr. Davidson. (2) Construct the 2018~2047...
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...
You are planning to buy a house worth $500,000 today. You plan to live there for...
You are planning to buy a house worth $500,000 today. You plan to live there for 15 years and then sell it. Suppose you have $100,000 savings for the down payment. There are two financing options: a 15-year fixed-rate mortgage (4.00% APR) and a 30-year fixed-rate mortgage (5.00% APR). The benefit of borrowing a 30-year loan is that the monthly payment is lower. But since you only plan to hold the house for 15 years, when you sell the house...
Mortgage Loan Analysis: A resident in Victoria is planning to buy a new house in March...
Mortgage Loan Analysis: A resident in Victoria is planning to buy a new house in March 2018. The sale price of the house is $336,000. He plans to pay 20% down payments and borrow additional 80% from Wells Fargo with a 30-year, 4.375% fixed-rate mortgage loan. He is expected to pay an equal MONTHLY payment starting from April 2018 for a total of 30 years. (1) Calculate the required monthly mortgage payment for Mr. Davidson. (2) Construct the 2018~2047 amortization...
Mortgage Loan Analysis: A resident in Victoria is planning to buy a new house in March...
Mortgage Loan Analysis: A resident in Victoria is planning to buy a new house in March 2018. The sale price of the house is $336,000. He plans to pay 20% down payments and borrow additional 80% from Wells Fargo with a 30-year, 4.375% fixed-rate mortgage loan. He is expected to pay an equal MONTHLY payment starting from April 2018 for a total of 30 years. (1) Calculate the required monthly mortgage payment for Mr. Davidson. (2) Construct the 2018~2047 amortization...
You are planning to buy a house worth $500,000 today. You have $100,000 savings for the...
You are planning to buy a house worth $500,000 today. You have $100,000 savings for the down payment. A 30-year fixed-rate mortgage is 6.00% APR. a. Suppose if you take the 30-year loan, how much is your monthly payment? b. Show the payment for interest and principal separately for the first three months. c. Ten years later, the 30-year fixed-rate mortgage rate reduces to 3% APR. So you decide to refinance the debt with a new 30-year fixed-rate loan. How...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT