Ms. Juliet bought a house for $360,000 exactly five years ago. After making a 20%...

Question

Ms. Juliet bought a house for $360,000 exactly five years ago. After making a 20%...

          Ms. Juliet bought a house for $360,000 exactly five years ago. After making a 20% down-payment, she borrowed the rest of the house payment in the form of a 15-year mortgage from her local cooperative credit union. She negotiated a mortgage rate of 3.5% APR with semi-annual compounding. She makes mortgage payments of an equal dollar amount every two weeks (i.e., biweekly), and her first mortgage payment was due two weeks after she signed the mortgage contract.

If Ms. Juliet can renegotiate a new 10-year mortgage rate of 2.5% APR with monthly compounding on her current mortgage balance, what will be her new biweekly mortgage payment?       

Answer

we have to calculate bi - weekly rate

Effective annual rate(EAR)  = (1 + (r/n))^n - 1

where r = APR

n = compounding periods

EAR = (1 + (3.5%/2))^2 - 1 = 3.5306%

(1 + x)^26 - 1 = 3.5306% (let x = bi-weekly rate)

so x = 0.1335%

Down payment = 20%

so balance = 360000*(1 - 20%) = 288,000

number of periods = 26 weeks*15years = 390

first we have to find monthly payments and balance of loan after 5 years

now we can find new bi - weekly payments:

New EAR = (1 + (2.5%/12))^12 - 1

= 2.53%

Bi - weekly rate = (1+2.53%)^(1/26) - 1

= 0.096%

Bi weekly payments:

so New Bi - weekly Payments = $904.89

Formulas will be as follows:

(E5 cell is interest rate = 0.1335%)

(formula for second part will be same as above Except number change)