 鲜花( 0)  鸡蛋( 0)
|
Assume: House value 300,000
/ t+ D6 P) `: q: U- t; z7 e! O: J 10% down payment
/ n; s; O' u- a/ a( ]1 m) a; Y 25 years mortgage (25 * 12 = 300 months)
1 j7 F! |$ u0 L; U) T$ L9 I rate 5.24
+ f& @ J/ l. o/ V" e9 N7 d- @2 b3 y) j
1.effective rate 0.43197466' a: e) M. J* l: W9 N9 i- l
in Canada it is common to have mortgages that have interest compounded semi-annually(5.24/2), with payments made monthly. 1 h: g7 ]: i* `+ V
1 pv, 0 pmt, 1.0262 FV, 6 N ----- CPT I/Y = 0.43197466
1 O% n5 Q M0 R2.Adjusted mortgage balance% C" e- _( X' Y# E0 [
300,000 * 10% = 30,000 downpayment
9 b; H3 V# P& k 300,000-30,000 = 270,000 mortgage requried* T8 Q% u9 g% \1 H( D
270,000/300,000 = 90% ---- 2% premium % of loan amount (CMHC)) @2 A. y, W+ a# z8 w8 }" r; }) g/ F1 W
270,000 * 2% = 5,400
- x A8 E) z; C adjusted mortgage balance: 270,000 + 5,400 = 275,400
% j. Y. B$ ]+ e- X$ w3. PV 275,400, N 300, 0.43197466 I/Y, 0 FV, CPT PMT = $1637.20 monthly payment5 Z" n5 f( x, U# I' f
4. TOTAL INTEREST PAID IN 25 YEAR ABOUT $216,157.48  |
|