Question

In: Accounting

A homeowner borrows $300,000 over a 15-year mortgage term, fully amortising and

A homeowner borrows $300,000 over a 15-year mortgage term, fully amortising and payable monthly, at an interest rate of 4.5% per year fixed for 6 years, and is charged a closing fee of 2% on the principal sum.

a)       What is the monthly repayment amount for the initial 6-year period?

b)      What is the APR (annual percentage rate) over the full loan term?

At the expiry of the 6-year interest period, the interest rate changes to 5.5% for the remainder of the loan.

c)       What is the principal balance at the end of the 6-year period?

d)      What is the monthly repayment amount for the remainder of the loan?

e)      How much interest would be saved over the remainder of the loan if the homeowner chooses to repay an extra $100 a month on top of the above repayment amount?

Solutions

Expert Solution

a)What is the monthly repayment amount for the initial 

6-year period?

ANSWER

$1,814.45

 

WORKING

4.5% = 0.045

0.045/12 = 0.00375

P = 300000

N = 15*12i = 0.00375

 

c = P*i*((1+i)^N)/((1+i)^N-1)

c = $1,814.45   

 

b)What is the APR (annual percentage rate) over the full loan 

term?

ANSWER

4.735%

 

WORKING

4.5% = 0.045

0.045 + 2% = 0.065

0.065/12 = 0.00542

P = 300000

N = 15*12i = 0.00542

c = P*i*((1+i)^N)/((1+i)^N-1)

c = $2,011.01

APR = c*12 - P/NAPR = 4.735%

 

 

 

c)  What is the principal balance at the end of the 

6-year period?

ANSWER

$267,859.03

 

WORKING

4.5% = 0.045

0.045/12 = 0.00375

P = 300000

N = 15*12i = 0.00375

c = P*i*((1+i)^N)/((1+i)^N-1)

c = $1,814.45

P6 = P(1+i)^(N-6N) - c(1+i)^(N-6N-1)

P6 = $267,859.03

 

d) What is the monthly repayment amount for the remainder of the loan?

ANSWER

$2,067.91

 

WORKING

5.5% = 0.0550.055/12 = 0.00458

P = 300000

N = 15*12i = 0.00458

c = P*i*((1+i)^N)/((1+i)^N-1)

c = $2,067.91

 

 

e) How much interest would be saved over the remainder of 

the loan if the homeowner chooses to repay an extra $100 a month on top of the above repayment amount?

ANSWER

$40,767.61

 

WORKING

5.5% = 0.055

0.055/12 = 0.00458

P = 300000

N = 15*12i = 0.00458

c = P*i*((1+i)^N)/((1+i)^N-1)

c = $2,067.91

$100/month extra repayments

c = $2,167.91P9 = P(1+i)^(N-9N) - c(1+i)^(N-9N-1)

P9 = $259,232.39

Interest saved = $40,767.61


Related Solutions

A homeowner borrows $325,000 over a 25-year mortgage term, fully amortising and payable monthly, at an...
A homeowner borrows $325,000 over a 25-year mortgage term, fully amortising and payable monthly, at an interest rate of 3% per year fixed for 6 years, and is charged a closing fee of 3.5% on the principal sum. a) What is the monthly repayment amount for the initial 6-year period? b) What is the APR(annual percentage rate) over the full loan term? At the expiry of the 6-year interest period, the interest rate changes to 5.5% for the remainder of...
A homeowner takes out a 15-year mortgage in the amount of $400,000, fully amortized, monthly compounded,...
A homeowner takes out a 15-year mortgage in the amount of $400,000, fully amortized, monthly compounded, monthly payable, with an interest rate of 4.8% p.a. What is the remaining balance of the mortgage after 8 years (i.e., after the 96th payment)? (in %, 2 decimal places)
A homeowner could take out a 15 year mortgage at a 3.5% annual rate on a...
A homeowner could take out a 15 year mortgage at a 3.5% annual rate on a $250,000 mortgage amount or she could refinance the purchase with a 30 year mortgage at a 4% annual rate. How much total interest over the entire mortgage periods could she save by financing her home with a 15 year mortgage to the nearest dollar? 1.) 130,408 2.) 110,105 3.)107,977 4.) 95,107 5.) 150,250
Suppose a homeowner started out with a mortgage in the amount of $225,000, repayable over a...
Suppose a homeowner started out with a mortgage in the amount of $225,000, repayable over a 30 year period, making payments at an interest rate of 4.5% APR, compounded monthly. After making 60 payments, the homeowner received a substantial bonus from her employer, allowing her to make a $50,000 principal reduction on the mortgage loan. If she continues to make the same payment, by approximately how many years will this one time payment reduce the amount of time it takes...
A homeowner takes a 15-year fixed-rate mortgage for $110,000 at 7.3 percent. After three years, the...
A homeowner takes a 15-year fixed-rate mortgage for $110,000 at 7.3 percent. After three years, the homeowner sells the house and pays off the remaining principal. How much is the principal payment? (Do not round intermediate calculations. Round your answer to 2 decimal places.) Principal Payment: ________
15. Ann is looking for a fully amortizing 30 year Fixed Rate Mortgage with monthly payments...
15. Ann is looking for a fully amortizing 30 year Fixed Rate Mortgage with monthly payments for $3,200,000. Mortgage A has a 4.38% interest rate and requires Ann to pay 1.5 points upfront. Mortgage B has a 6% interest rate and requires Ann to pay zero fees upfront. Assuming Ann makes payments for 2 years before she sells the house and pays the bank the balance, which mortgage has the lowest cost of borrowing (ie lowest annualized IRR)? Type 1...
Suppose that you are considering a conventional, fixed-rate 15-year mortgage loan for $300,000. The lender quotes...
Suppose that you are considering a conventional, fixed-rate 15-year mortgage loan for $300,000. The lender quotes an APR of 4%, compounded monthly; mortgage payments would be monthly, beginning one month after the closing on your home purchase. In the tenth year of your mortgage (months 109 through 120), what would be the total dollar amount of the interest paid? Do not round at intermediate steps in your calculation A) $9,619.05 B)$6,412.70 C)$5,284.99 D)$7,500.27 .
1. Suppose that you are considering a conventional, fixed-rate 15-year mortgage loan for $300,000. The lender...
1. Suppose that you are considering a conventional, fixed-rate 15-year mortgage loan for $300,000. The lender quotes an APR of 4%, compounded monthly; mortgage payments would be monthly, beginning one month after the closing on your home purchase. In the tenth year of your mortgage (months 109 through 120), what would be the total dollar amount of the interest paid? Do not round at intermediate steps in your calculation. 2. Suppose that you take out a mortgage loan with the...
Suppose that you are considering a conventional, fixed-rate 15-year mortgage loan for $300,000. The lender quotes...
Suppose that you are considering a conventional, fixed-rate 15-year mortgage loan for $300,000. The lender quotes an APR of 4%, compounded monthly; mortgage payments would be monthly, beginning one month after the closing on your home purchase. In the tenth year of your mortgage (months 109 through 120), what would be the total dollar amount of the interest paid? Do not round at intermediate steps in your calculation.
You plan to purchase a $300,000 house using a 15-year mortgage obtained from your bank. The...
You plan to purchase a $300,000 house using a 15-year mortgage obtained from your bank. The mortgage rate offered to you is 4.70 percent. You will make a down payment of 25 percent of the purchase price. a. Calculate your monthly payments on this mortgage. b. Construct the amortization schedule for the mortgage. How much total interest is paid on this mortgage?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT