Question

You are arranging a $350,000 Canadian mortgage with a 25-year amortization period and a 7 percent...

You are arranging a $350,000 Canadian mortgage with a 25-year amortization period and a 7 percent posted interest rate. What is the monthly mortgage payment? Suppose the bank offers you the opportunity to pay your monthly payments in two equal installments (pay on-half of the monthly payment every two weeks). How much faster will you pay off your mortgage this way?

Homework Answers

Answer #1

Monthly payment can be calculated using PMT function

N = 25 x 12 = 300, PV = 350,000, I/Y = 7%/12, FV = 0

=> Compute PMT = $2,473.73

EAR = (1 + APR/n)^n - 1 = (1 + 7%/12)^12 - 1 = 7.23% for 12 months payments

If payments are made twice every month, APR = ((1 + EAR)^(1/n) - 1) x n = ((1 + 7.23%)^(1/24) - 1) x 24 = 6.99%

No. of payments can be calculated using N function

I/Y = 6.99%/24, PV = 350,000, PMT = 2,473.73 / 2 = $1,236.86, FV = 0

=> Compute N = 597.65 payments

Hence, you would only be able to pay your mortgage by 2.35 months.

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Oppenheimer Bank is offering 30​-year mortgage with an APR 5% based on monthly compounding. With this...
Oppenheimer Bank is offering 30​-year mortgage with an APR 5% based on monthly compounding. With this mortgage your monthly payments would be $1,970 per month. In​ addition, Oppenheimer Bank offers you the following​ deal: Instead of making the monthly payment of $1,970 every​ month, you can make half the payment every two weeks​ (so that you will make 52/2 =26 payments per​ year). With this​ plan, how long will it take to pay off the mortgage if the EAR of...
Oppenheimer Bank is offering a 30 year mortgage with an APR of 4.78% based on monthly...
Oppenheimer Bank is offering a 30 year mortgage with an APR of 4.78% based on monthly compounding. With this mortgage your monthly payment would be $1,986 every month, you can make half the payment every two weeks (so that you will make 52/2 =26 payment per year). With this plan, how long will it take to pay off the mortgage if the EAR of the loan is unchanged? The number of payments will be _____, which is approximately ____ years.
Oppenheimer Bank is offering a 30​-year mortgage with an APR of 4.84% based on monthly compounding....
Oppenheimer Bank is offering a 30​-year mortgage with an APR of 4.84% based on monthly compounding. With this mortgage your monthly payments would be $2,040 per month. In​ addition, Oppenheimer Bank offers you the following​ deal: Instead of making the monthly payment of $2,040 every​ month, you can make half the payment every two weeks​ (so that you will make 52/2=26 payments per​ year). With this​ plan, how long will it take to pay off the mortgage if the EAR...
You are offered a 30-year fixed-rate mortgage on your dream home costing $350,000 at an APR...
You are offered a 30-year fixed-rate mortgage on your dream home costing $350,000 at an APR of 6% compounded monthly. You will make 360 monthly payments, but your first payment will not be due until Month 4 (Months 1-3 are part of a grace period where interest is still compounded but no payments are due). The final payment will therefore be due at the end of Month 363. a) What will be the value of your equal monthly payments (don't...
A $200,000 mortgage at 6.6% compounded semiannually with a 25-year amortization requires monthly payments. The mortgage...
A $200,000 mortgage at 6.6% compounded semiannually with a 25-year amortization requires monthly payments. The mortgage allows the borrower to prepay up to 10% of the original principal once each year. How much will the amortization period be shortened if, on the first anniversary of the mortgage, the borrower makes (in addition to the regular payment) a prepayment of: a. $10,000? (Do not round the intermediate calculations.) The amortization period will be shortened by months. b. $20,000? (Do not round...
You need a 25-year, fixed-rate mortgage to buy a new home for $190,000. Your mortgage bank...
You need a 25-year, fixed-rate mortgage to buy a new home for $190,000. Your mortgage bank will lend you the money at a 9.1 percent APR for this 300-month loan. However, you can afford monthly payments of only $800, so you offer to pay off any remaining loan balance at the end of the loan in the form of a single balloon payment. How large will this balloon payment have to be for you to keep your monthly payments at...
You need a 25-year, fixed-rate mortgage to buy a new home for $240,000. Your mortgage bank...
You need a 25-year, fixed-rate mortgage to buy a new home for $240,000. Your mortgage bank will lend you the money at a 6.1 percent APR for this 300-month loan. However, you can afford monthly payments of only $800, so you offer to pay off any remaining loan balance at the end of the loan in the form of a single balloon payment. Required: How large will this balloon payment have to be for you to keep your monthly payments...
You need a 25-year, fixed-rate mortgage to buy a new home for $250,000. Your mortgage bank...
You need a 25-year, fixed-rate mortgage to buy a new home for $250,000. Your mortgage bank will lend you the money at a 7.1 percent APR for this 300-month loan. However, you can afford monthly payments of only $900, so you offer to pay off any remaining loan balance at the end of the loan in the form of a single balloon payment. Required: How large will this balloon payment have to be for you to keep your monthly payments...
You plan to purchase a house for $290,000 using a 30-year mortgage obtained from your local...
You plan to purchase a house for $290,000 using a 30-year mortgage obtained from your local bank. You will make a down payment of 20 percent of the purchase price. You will not pay off the mortgage early. Assume the homeowner will remain in the house for the full term and ignore taxes in your analysis. Your bank offers you the following two options for payment. Option 1: Mortgage rate of 6.50 percent and zero points. Option 2: Mortgage rate...
To buy your first home, you take out a 15 year (fully amortizing) mortgage for $350,000...
To buy your first home, you take out a 15 year (fully amortizing) mortgage for $350,000 which requires equal yearly payments. The effective annual interest rate is 3.6%. How much principal do you pay off in year 2? $18,653.49 $42,557.10 $30,605.29 None of these $11,951.81