Mortgage interest calculation: For 800K, interest rates of 6.5%, 5 Year term, 12 payments a year.
In Excel I get total interest of : $139,175
In RBC: $137,236
https://www.rbcroyalbank.com/cgi-bin/mortgage/mortcalc.pl
In TD:$137,115
http://www.tdcanadatrust.com/mortgages/afford.html
In Scotia: $137,200
http://cgi.scotiabank.com/mortgage/payment.html
CIBC:$137,236
http://www.cibc.com/ca/mortgages/article-tools/home-free-fast.html
In Mortgage Sum Calculator: $139,175.11
http://www.mortgagesum.com/mortgagecalculator/amortization-calculator.php
By calculation: 800K * (i*N*(1+i)^N / [(1+i)^N-1] -1)=$139,175.114

Seem to me banks calculate the interest differently (by$2,000), Anyone knows the reason?
thx.