Question

In: Finance

A couple is planning to purchase a house in Nepean for a price of $350,000. They...

A couple is planning to purchase a house in Nepean for a price of $350,000. They are planning to pay a down payment of $75,000 and would finance the remainder by a mortgage of $275,000 (i.e. $350,000 - $75,000 = $275,000). They are considering a 20-year mortgage, with bi-weekly payments. The quoted rate would 3.5 percent, semi-annual compounded. Calculate the following:

Question 31 (1 point)

What would be the Effective Annual Rate? (1 mark)

Question 31 options:

3.557%

3.561%

3.531%

3.5%

None of the Above

Question 32 (1 point)

Saved

What would be effective bi-weekly rate? (1 mark)

Question 32 options:

0.134%

0.29%

0.067%

1.75%

None of the Above

Question 33 (1 point)

How many bi-weekly, mortgage payments would they pay during the 20-year period? (1 mark)

Question 33 options:

1040

240

480

520

None of the Above

Question 34 (1 point)

How much would their bi-weekly mortgage payments be? (1 mark)

Question 34 options:

$732.91

$1,338.21

$488.73

$366.77

None of the Above

Question 35 (2 points)

How much interest would they have paid during the total 20-year period (Hint: (number of payments * amount of payments) minus loan amount)?

Question 35 options:

$106,111.35

$105,814.88

$106,238.49

$106,347.57

None of the Above

Solutions

Expert Solution

Ans 31

Effective Annual Rate = (1 + Nominal interest rate/ No. of compounding periods)no. of compounding periods - 1

= (1+ 0.035/2)2 - 1

= 0.03531

= 3.531 %

Ans 32

Effective Bi-Weekly rates = (1.0175)2/26 - 1

= 0.00134

= 0.134%

Ans 33

No. bi-weekly mortgage payments= No.of bi-weekly mortage payment a year x No. of years

= 26 x 20

= 520

Ans 34

Bi -weekly payments in amounts

=(Loan Amount x EBWR) x {(1+ EBWR)No. of BWMP} / {(1+ EBWR)No. of BWMP - 1}

= (275000 X 0.00134) X {(1.00134)520 } / {(1.00134)520 - 1}

=368.5 X 2.0064/1.0064

= 368.5 x 1.9936

= 734.64

= 732.91 (approximately)

Note : 1. Diiference in ans is due to round off as 0.00134 is not exact figure. It is rounded off.

2. EBWR = Effective Bi-Weekly rate

3.BWMP = Bi weekly mortgage payment

Ans 35

(number of payments * amount of payments) minus loan amount

= (520 X 732.91 ) - 275000

= 106113.20

=106111.35 (approximately)

Note : Diiference in ans is due to round off


Related Solutions

You are planning to buy a house today. The house costs $350,000. You have $50,000 in...
You are planning to buy a house today. The house costs $350,000. You have $50,000 in cash that you can use as a down payment on the​ house, but you need to borrow the rest of the purchase price. The bank is offering a 30​-year mortgage that requires annual payments and has an EAR of 5% per year. What will be your annual mortgage​ payment?
The Applegate family is planning to purchase a house. The house they are interested in is...
The Applegate family is planning to purchase a house. The house they are interested in is listed for $250,000. The current 30-years Mortgage rate is 5.3% (APR). Your task is to find out what will happen to their monthly payment if they put down 10%, 20%, and 30%. Additionally, they would like to see what happens when they choose a 15-year mortgage with 4.2% APR. Create an Excel spreadsheet to answer the questions above. You will be using Data Tables...
A couple must decide between a blue house and a red house. To purchase the red...
A couple must decide between a blue house and a red house. To purchase the red house they must tae a $155000 mortgage to be repaid over 20 years, interest rate is given as j2 = 7.8%. To purchase the blue house, they must take a mortgage to be repaid over 25 years at interest rate given as j12 - 8%. Both of those two mortgages have semi-annual payments and the semi annual mortgage payments are equal. (a) Determine the...
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...
A couple is looking to purchase their first home. The house is for sale at $125,000....
A couple is looking to purchase their first home. The house is for sale at $125,000. They can obtain an 80% LTV with a 7% interest rate and monthly payments. The loan is to be fully amortized over 30 years. Alternatively, they could obtain a 90% LTV at a 7.5% interest rate amortized over the same term. What is the incremental cost of borrowing the additional funds? Assuming the couple took the 80% loan, after fifteen years, the couple has...
1.) Find a house: House Price is ($350,000) 2.) Use interest rate of: 6% compounded monthly...
1.) Find a house: House Price is ($350,000) 2.) Use interest rate of: 6% compounded monthly for a 30 year loan and 5.5% compounded monthly for a 15 year loan. 3.) Determine how much a monthly principal and interest payment on your house would be if you financed it: a. for 30 years b. for 15 years c. for 30 years with 20% down d. for 15 years with 10% down 4.) How much would you pay for the home...
A couple has decided to purchase a $240000 house using a down payment of $30000. They...
A couple has decided to purchase a $240000 house using a down payment of $30000. They can amortize the balance at 10% over 20 years. a) What is their monthly payment? Answer = $ b) What is the total interest paid? Answer = $ c) How much of their first payment went toward paying interest? Answer = $ d) How much of their first payment went toward paying the balance of the loan. Answer = $
A couple has decided to purchase a $200000 house using a down payment of $15000. They...
A couple has decided to purchase a $200000 house using a down payment of $15000. They can amortize the balanxe at 10% over 25 years. What is their monthly payment? What is the total interest paid? What is the equity after 5 years? What is the equity after 20 years?
A couple has decided to purchase a $150000 house using a down payment of $12000. They...
A couple has decided to purchase a $150000 house using a down payment of $12000. They can amortize the balance at 9% over 25 years. a) What is their monthly payment? Answer = $   b) What is the total interest paid? Answer = $   c) What is the equity after 5 years? Answer = $   d) What is the equity after 20 years? Answer = $
A couple has decided to purchase a $370000 house using a down payment of $21000. They...
A couple has decided to purchase a $370000 house using a down payment of $21000. They can amortize the balance at 12% over 30 years. a) What is their monthly payment? Answer = $ b) What is the total interest paid? Answer = $ c) How much of their first payment went toward paying interest? Answer = $ d) How much of their first payment went toward paying the balance of the loan. Answer = $
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT