﻿

# Calculating mortgages

January 21 2013 by
false
Maple

1

Although unfinished, this project I had left idle for a while and just thought to share with the community.  Not fancy by any means, no graphs or anything, was just having fun creating a worksheet on mortgages but then ran out of free time to work on things as usual, anywyas.  I skipped the derivation for the formula after n payments at the end and just provided the formula and dove right into an example.  For interest, my applications usually have numbers after them referring to the number of revisions.

Mortgage variations

I've seen different variations on the Mortgage equations for monthly payments but they are all just different forms of the same thing.

Here's one:

 (1.1)

And the other more simplified version

 (1.2)

or sometimes written like

 (1.3)

Are they the same?  Well we can check...

 (1.4)

Proof that the above M and P are the same

We can first divide the numerator and denominator by (1+i)^n

 (1.1.1)

 (1.1.2)

 (1.1.3)

 (1.1.4)

 (1.1.5)

 (1.1.6)

 (1.1.7)

Interest demystified

Another thing that usually confuses people is the interest.  The banks don't actually use the number they give you in the calculations.  The rate they give you is usually the nominal interest rate, the rate they use in the calculations is usually called the effective interest rate.

Take for example your mortgage is borrowed at 6% (that's the nominal rate the bank quoted you) however Canadian mortgages are compounded semi-annually and usually paid on a monthly basis.  So that 6% is actually.

 (1.2.1)

 (1.2.2)

 (1.2.3)

 (1.2.4)

 (1.2.5)

6.09% is the effective yearly interest rate.

Now we normally pay on a monthly basis so we need to find out what the monthly effective interest is.

 (1.2.6)

 (1.2.7)

So 0.49% is our monthly interest rate.

Usually the confusion is in taking the 6% and dividing it by twelve.  =  a difference of slightly less than 0.01% than the actual value.  But it's enough to make your numbers not match up and not understand what the bank is doing, then you just throw up your hands and decide to just leave it all up to them.

Examples

We take out a $200,000 30 year mortgage for a house at 6%. For a fixed rate over the life of the mortgage what is our monthly payments and how long will it take to pay it off? How long? 30years. It's a 30 year mortgage - that question was just to see if you were paying attention.  (1.3.1)  (1.3.2)  (1.3.3)  (1.3.4)  (1.3.5) So if we have a monthly payment of$1189.65 we will have our $200,000 mortgage payed off in 30 years. How much did we actaully spend on our house?  (1.3.6) So we spent$428,272.86 on our house.  More than double the actual cost.  And  =  was all spent on interest alone !!  No wonder so many people are in debt.

Could we have spent less if we paid it off quicker?  You bet.  Okay so let's instead decide to pay it off in 20 years instead of 30.  In that case.

 (1.3.7)

and solving M we have:

 (1.3.8)

So our monthly payments should be $1424.38 per month and we have spent = almost a full$100,000 less.  The difference  = That's a couple of new cars if we can afford the monthly payments.  $1424 is a little steep, however let's suppose we could afford to pay$1500 a month.  Families with both parents working full time, $1500 is fairly easy to come up with but extremely hard for the single working parent families, both parents working low wages or part time, given the everyday expenses we all have to deal with (rising grocery prices, rising hydro prices, etc...) First we need to solve for n in our monthly payment equation.  (1.3.9)  (1.3.10)  (1.3.11)  (1.3.12)  (1.3.13)  (1.3.14) Great! So we'll get our number of payments down from 240 to 218 and pay it off instead of in 20 years we'll pay it off in = years. Now how much do we save by increasing our monthly payments? = - We'll save over$14,000 just by increasing our monthly payments by $75.62 to$1500 a month.

Now what if we want to find out how much is left on our balance, let's say after 24 payments?

 Deriving the formula for remaining principle after n payments (unfinished)

 (1.3.15)

 (1.3.16)

 (1.3.17)

 (1.3.18)

 (1.3.19)

And to see how many payments (months) are left until we pay it all off we just solve remainingbalance=0

 (1.3.20)

and divide by 12 for years or insert the value into the

 (1.3.21)

How about how long will it take until we have 1/2 our original principle left?

 (1.3.22)

So after 132 payments we will have almost half our principle remaining.  And how much is that?

 (1.3.23)