How to calculate your Mortgage Payment – A two part series (Part 1)

Quite often we are asked to calculate payments or we are asked why the payment is different from the one I calculated online? Or have you ever wondered why the cost of borrowing rate is higher than the rate you thought you were locked-in at. Well normally there is a simple answer. In Canada, interest charged on mortgages is determined using a semi-annual interest calculation. Click here for an Excel based Canadian mortgage calculator, or to learn how to do these calculations by hand see below. I will write a two part article this week on how to calculate your mortgage payment by hand. Here is how to calculate the effective interest rate:-

The first thing to realize is that there are three types of interest calculations:- simple interest, compound interest and effective interest.

Simple Interest – The cost of borrowing money, calculated by applying the interest rate to the original principal amount only. In contrast to compound interest, interest is not charged on interest.

(Simple Interest = P x i x n)

Compound Interest – Interest charged not only on the principal sum but also on interest amounts charged, but not paid, in preceding periods that accumulate as new principal.

Effective Interest – The actual rate that the borrower must pay on a loan after the effects of compounding are considered. It is also known as the true rate. It differs from the nominal interest rate.

(Efffective Interst = (1+(i/m)^m- 1)

Mortgage interest is always compounded semi-annually in Canada. In the US this is not the case, mortgage interest is compounded annually.

To Calculate Mortgage Payments and Interest Rates you will need the following information:

1. Nominal or Annual Interest Rate (I)

2. Compounding Periods per Year

3. Effective Annual Rate

4. Mortgage Amount (Present Value)

5. Future Value of the Mortgage

6. Total Number of Compounding Periods (# of years x # of periods per year)

7. Payment per compounding period

Calculating the Effective Interest Rate

Annual Interest Rate = 7%

Mortgage Amount = $150,000

Since mortgage interest is calculated on a semi-annual basis there are 2 compounding periods:

1. Calculate the Semi-Annual Interest Rate

Semi-Annual Interest Rate = Annual Interest Rate/2

Semi-Annual Interest Rate = 3.5% (7%/2)

2. Calculate the Interest for the First Period

Interest = Mortgage Amount * Semi-Annual Rate

Interest = $150,000*3.5%

Interest = $5,250

Add interest to the original total mortgage amount

$150,000+$5,250=$155,250 (New Mortgage Amount)

3. Calculate the Interest for the Second Period

Interest=New Mortgage Amount*Semi-Annual Rate

Interest=$155,250*3.5%

Interest=$5,433.75

4. Calculate the Total Interest

Add interest from the first period to the second period

Total Interest = $5,250+$5,433.75

Total Interest = $10,683.75

5. Calculate the Effective Interest Rate

Effective Interest Rate = Total Interest/Original Mortgage Amount

Effective Interest Rate = $10,683.75/$150,000

Effective Interest Rate = 7.12%

Stayed tuned for how to calculate your Mortgage Payment and future blogs on determining mortgage affordability.

Share and Enjoy:

Wednesday, March 11th, 2009, by OttawaMortgageSolutions.com | Send a Trackback from your own site.

Comments about “How to calculate your Mortgage Payment – A two part series (Part 1)”

[1]Wednesday, March 11th, 2009 at 6:01 pmInterest Rates » How to calculate your Mortgage Payment – A two part series (Part 1)
[2]Thursday, March 12th, 2009 at 1:12 amAdjustable Rate Mortgages – a Beginners’ Guide : Smarter Finances - Credit Cards, Loans, Mortgages, Investments
[3]Thursday, March 12th, 2009 at 4:29 pmHow to calculate your Mortgage Payment - Can you afford it! (Part 2)
[4]Friday, March 13th, 2009 at 8:41 pmWells Fargo, another bank sued over alleged discrimination
[5]Sunday, March 15th, 2009 at 8:14 pmThe Great American Mortgage Scam & The Latino Community
[6]Thursday, July 2nd, 2009 at 7:33 amMortgage Lending Drops as Interest Rates Rise - Surprised

HotWomen
Thursday, March 26th, 2009 at 10:33 am

Your are Great. And so is your site! Awesome content. Good job guys! Interesting article, adding it to my favourites!
Chris Grimes
Monday, March 30th, 2009 at 11:38 am

Thanks for the kind comments. We look forward to any discussions in the future.

Regards,
Chris Grimes
Jessicadowl
Sunday, May 10th, 2009 at 7:04 pm

I think you love dark color
Arianabino
Wednesday, May 13th, 2009 at 2:56 pm

I really liked this post. Can I copy it to my site? Thank you in advance.
Chris Grimes
Saturday, May 16th, 2009 at 2:44 pm

Absoultely, feel free to post it on your site. Send us your site so we can take a look.
Thanks
Chris
electromozzo
Saturday, July 25th, 2009 at 12:19 pm

Nice site. go to my favorites. TNx
MishaPowerauto
Tuesday, July 28th, 2009 at 1:05 pm

Just wanted to say HI. I found your blog a few days ago on Technorati and have been reading it over the past few days.
ottawamortgagesolutions.com - cool!!!!
VitalikGromovss
Saturday, August 8th, 2009 at 7:08 am

Thanks for posting about this, I would like to read more about this topic.
NatmumnReut
Monday, August 17th, 2009 at 9:41 pm

Hello everybody,

I’m glad to provide here an a worth thinking of
type of earning. Do you know that one
may earn up to 3% a per day through investments without limitations in sums ?
I. e. that even if one has US$1.000,00 one can make the same money in a month !

If someone gets interested welcome to visit my web site http://www.theinvestblog.com.
Debt Settlement Program
Friday, August 21st, 2009 at 6:50 am

punctilious post. due one detail where I bicker with it. I am emailing you in detail.
NatmumnReut
Monday, August 24th, 2009 at 11:59 am

Hi everybody,

I’m glad to describe at this page http://www.theinvestblog.com an a worth thinking of
type of making money. Do you know a person
can earn up to 3% a per day through by investing without limitations in without sum limits?
I. e. that even having US$1.000,00 one may earn the same amount in a month !

If anyone is interested welcome to my blog http://www.theinvestblog.com .
doctorbiml
Thursday, September 24th, 2009 at 1:24 am

Great post Jon! I have been following the #p2 effort since you started it, and although I have understood its purpose this post does a really great job solidifying the full rationale.
Kelli Garner
Tuesday, September 29th, 2009 at 9:39 am

Great site, how do I subscribe?
meensache
Wednesday, September 30th, 2009 at 3:15 pm

Delightful post — this unquestionably hits lodgings towards me.
JosephCar
Wednesday, October 14th, 2009 at 3:22 am

Good article, thank you
You never really learn to swear until you learn to drive.

http://top-get.com

best regards
Jackynora
Friday, October 23rd, 2009 at 6:34 pm

Hiya
I saw the thread on ottawamortgagesolutions.com
Very well constructed
In fact I have been researching for this for yonks
ottawamortgagesolutions.com will see me back again
Great effort well done !
John
home equity mortgage loan
End of the World
Wednesday, October 28th, 2009 at 5:12 am

Thank’s for sharing this
This is really interesting
JoJo John Jnr
Saturday, November 7th, 2009 at 10:28 am

Hey Wasup
I i saw the post on ottawamortgagesolutions.com
Very interesting
In fact I have been searching for this for yonks
ottawamortgagesolutions.com is just what I was looking for.
Great effort congrats !
John
texas in car used cheap
forex_account_
Tuesday, November 24th, 2009 at 4:50 pm

I like this web really much.

This is really a extraordinary website.
And it is not like other money directed web, the information here is truly important.

I am definitely bookmarking it as well as sharing it with my friends.
Bailee
Thursday, November 26th, 2009 at 8:45 am

Nice blog! Can’t wait to start my own blog.
wheyp.roteinsideeffects
Thursday, December 3rd, 2009 at 7:54 am

Very great site.
The content here is truly valuable.

I will refer it to my friends.

Cheers
Affiliate Network
Friday, December 18th, 2009 at 3:33 am

Such a great site. I am bookmarking this page.
Sitesell
Friday, December 18th, 2009 at 7:44 am

Such a good site. I am bookmarking this page.
Foreign Exchange Swap
Friday, December 18th, 2009 at 5:41 pm

I somehow dont agree with a few things, but its great anyways.
High School
Thursday, February 4th, 2010 at 4:15 pm

Thanks.what a lengthy and in depth article but full of useful information
Soputtert
Monday, March 1st, 2010 at 8:36 pm

cool posting
Cheapest-Insurance-653
Monday, April 5th, 2010 at 6:17 pm

hm. hope to see same more info. Can we speake about it?