ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKAL
1
360,000.00
Change the highlighted boxs with current rates
2
Annual Principle repayed10,000.00
Then find the rate where the Average over that term is less than or equal to the fortnightly cost for the
Historic approx average rates
3
Loan balance after1 year350,000.00(assuming same longer term mortgage. Term12345
4
2 years340,000.00amount of principle 2009-20155.66.26.877.2
5
3 years330,000.00repayed each year)EG if the 2 year duration is 1,353.85
per fortnight, find the number in column k that is just less than this value.
2015-20204.14.74.84.95.5
6
This is the rate the one year mortgage would have to be at for the 2nd one year mortgage to be the best deal.
7
8
1 year durationInterestInterest & PrincipleFortnightly cost
See historic interest rates here
https://www.interest.co.nz/charts/interest-rates/fixed-mortgage-rates
9
7.2526,100.0036,100.001,388.46
10
11
2 year durationTotal cost over 2 years
12
725,200.0035,200.001,353.8570,400.001,353.85
13
3 year durationTotal cost over 2 yearsTotal cost over 3 years
14
6.9525,020.0035,020.001,346.9270,040.001,346.92105,060.001,346.92
15
16
17
18
Cost over 3 years locking in 3x1 year duration with different rates.
19
2nd year interest rateUsing loan value left of:350,000.00Using loan value left of 340,000.00Average over 3 years using x.x for second year rate
20
1st yearInterestInterest & principleFortnightly CostInterestInterest & principleFortnightly CostAverage over 2 years 3rd yearInterestInterest & principleFortnightly Cost3.003.103.203.303.403.503.603.703.803.904.004.104.204.304.404.504.604.704.804.905.00
21
7.2526,100.0036,100.001,388.463.0010,500.0020,500.00788.461,088.46One year term is better3.0010,200.0020,200.00776.921,084.621,086.861,089.101,091.351,093.591,095.831,098.081,100.321,102.561,104.811,107.051,109.291,111.541,113.781,116.031,118.271,120.511,122.761,125.001,127.241,129.49
22
3.1010,850.0020,850.00801.921,095.193.1010,540.0020,540.00790.001,088.971,091.221,093.461,095.711,097.951,100.191,102.441,104.681,106.921,109.171,111.411,113.651,115.901,118.141,120.381,122.631,124.871,127.121,129.361,131.601,133.85
23
3.2011,200.0021,200.00815.381,101.923.2010,880.0020,880.00803.081,093.331,095.581,097.821,100.061,102.311,104.551,106.791,109.041,111.281,113.531,115.771,118.011,120.261,122.501,124.741,126.991,129.231,131.471,133.721,135.961,138.21
24
3.3011,550.0021,550.00828.851,108.653.3011,220.0021,220.00816.151,097.691,099.941,102.181,104.421,106.671,108.911,111.151,113.401,115.641,117.881,120.131,122.371,124.621,126.861,129.101,131.351,133.591,135.831,138.081,140.321,142.56
25
3.4011,900.0021,900.00842.311,115.383.4011,560.0021,560.00829.231,102.051,104.291,106.541,108.781,111.031,113.271,115.511,117.761,120.001,122.241,124.491,126.731,128.971,131.221,133.461,135.711,137.951,140.191,142.441,144.681,146.92
26
3.5012,250.0022,250.00855.771,122.123.5011,900.0021,900.00842.311,106.411,108.651,110.901,113.141,115.381,117.631,119.871,122.121,124.361,126.601,128.851,131.091,133.331,135.581,137.821,140.061,142.311,144.551,146.791,149.041,151.28
27
3.6012,600.0022,600.00869.231,128.853.6012,240.0022,240.00855.381,110.771,113.011,115.261,117.501,119.741,121.991,124.231,126.471,128.721,130.961,133.211,135.451,137.691,139.941,142.181,144.421,146.671,148.911,151.151,153.401,155.64
28
3.7012,950.0022,950.00882.691,135.583.7012,580.0022,580.00868.461,115.131,117.371,119.621,121.861,124.101,126.351,128.591,130.831,133.081,135.321,137.561,139.811,142.051,144.291,146.541,148.781,151.031,153.271,155.511,157.761,160.00
29
3.8013,300.0023,300.00896.151,142.313.8012,920.0022,920.00881.541,119.491,121.731,123.971,126.221,128.461,130.711,132.951,135.191,137.441,139.681,141.921,144.171,146.411,148.651,150.901,153.141,155.381,157.631,159.871,162.121,164.36
30
3.9013,650.0023,650.00909.621,149.043.9013,260.0023,260.00894.621,123.851,126.091,128.331,130.581,132.821,135.061,137.311,139.551,141.791,144.041,146.281,148.531,150.771,153.011,155.261,157.501,159.741,161.991,164.231,166.471,168.72
31
4.0014,000.0024,000.00923.081,155.774.0013,600.0023,600.00907.691,128.211,130.451,132.691,134.941,137.181,139.421,141.671,143.911,146.151,148.401,150.641,152.881,155.131,157.371,159.621,161.861,164.101,166.351,168.591,170.831,173.08
32
4.1014,350.0024,350.00936.541,162.504.1013,940.0023,940.00920.771,132.561,134.811,137.051,139.291,141.541,143.781,146.031,148.271,150.511,152.761,155.001,157.241,159.491,161.731,163.971,166.221,168.461,170.711,172.951,175.191,177.44
33
4.2014,700.0024,700.00950.001,169.234.2014,280.0024,280.00933.851,136.921,139.171,141.411,143.651,145.901,148.141,150.381,152.631,154.871,157.121,159.361,161.601,163.851,166.091,168.331,170.581,172.821,175.061,177.311,179.551,181.79
34
4.3015,050.0025,050.00963.461,175.96Two year term is better4.3014,620.0024,620.00946.921,141.281,143.531,145.771,148.011,150.261,152.501,154.741,156.991,159.231,161.471,163.721,165.961,168.211,170.451,172.691,174.941,177.181,179.421,181.671,183.911,186.15
35
4.4015,400.0025,400.00976.921,182.694.4014,960.0024,960.00960.001,145.641,147.881,150.131,152.371,154.621,156.861,159.101,161.351,163.591,165.831,168.081,170.321,172.561,174.811,177.051,179.291,181.541,183.781,186.031,188.271,190.51
36
4.5015,750.0025,750.00990.381,189.424.5015,300.0025,300.00973.081,150.001,152.241,154.491,156.731,158.971,161.221,163.461,165.711,167.951,170.191,172.441,174.681,176.921,179.171,181.411,183.651,185.901,188.141,190.381,192.631,194.87
37
4.6016,100.0026,100.001,003.851,196.154.6015,640.0025,640.00986.151,154.361,156.601,158.851,161.091,163.331,165.581,167.821,170.061,172.311,174.551,176.791,179.041,181.281,183.531,185.771,188.011,190.261,192.501,194.741,196.991,199.23
38
4.7016,450.0026,450.001,017.311,202.884.7015,980.0025,980.00999.231,158.721,160.961,163.211,165.451,167.691,169.941,172.181,174.421,176.671,178.911,181.151,183.401,185.641,187.881,190.131,192.371,194.621,196.861,199.101,201.351,203.59
39
4.8016,800.0026,800.001,030.771,209.624.8016,320.0026,320.001,012.311,163.081,165.321,167.561,169.811,172.051,174.291,176.541,178.781,181.031,183.271,185.511,187.761,190.001,192.241,194.491,196.731,198.971,201.221,203.461,205.711,207.95
40
4.9017,150.0027,150.001,044.231,216.354.9016,660.0026,660.001,025.381,167.441,169.681,171.921,174.171,176.411,178.651,180.901,183.141,185.381,187.631,189.871,192.121,194.361,196.601,198.851,201.091,203.331,205.581,207.821,210.061,212.31
41
5.0017,500.0027,500.001,057.691,223.085.0017,000.0027,000.001,038.461,171.791,174.041,176.281,178.531,180.771,183.011,185.261,187.501,189.741,191.991,194.231,196.471,198.721,200.961,203.211,205.451,207.691,209.941,212.181,214.421,216.67
42
5.1017,340.0027,340.001,051.541,176.151,178.401,180.641,182.881,185.131,187.371,189.621,191.861,194.101,196.351,198.591,200.831,203.081,205.321,207.561,209.811,212.051,214.291,216.541,218.781,221.03
43
Cost over 3 years using a 2 year and a 1 year term
interest rate for 1 year term at start of 3rd yearUsing loan value left of:340,000.005.2017,680.0027,680.001,064.621,180.511,182.761,185.001,187.241,189.491,191.731,193.971,196.221,198.461,200.711,202.951,205.191,207.441,209.681,211.921,214.171,216.411,218.651,220.901,223.141,225.38
44
2 year mortgage rate InterestInterest & principleFortnightly CostAverage over 3 years 5.3018,020.0028,020.001,077.691,184.871,187.121,189.361,191.601,193.851,196.091,198.331,200.581,202.821,205.061,207.311,209.551,211.791,214.041,216.281,218.531,220.771,223.011,225.261,227.501,229.74
45
7.0025,200.0035,200.001,353.853.0010,200.0020,200.00776.92801.752 + 1 term is better5.4018,360.0028,360.001,090.771,189.231,191.471,193.721,195.961,198.211,200.451,202.691,204.941,207.181,209.421,211.671,213.911,216.151,218.401,220.641,222.881,225.131,227.371,229.621,231.861,234.10
46
3.1010,540.0020,540.00790.00806.115.5018,700.0028,700.001,103.851,193.591,195.831,198.081,200.321,202.561,204.811,207.051,209.291,211.541,213.781,216.031,218.271,220.511,222.761,225.001,227.241,229.491,231.731,233.971,236.221,238.46
47
3.2010,880.0020,880.00803.08810.475.6019,040.0029,040.001,116.921,197.951,200.191,202.441,204.681,206.921,209.171,211.411,213.651,215.901,218.141,220.381,222.631,224.871,227.121,229.361,231.601,233.851,236.091,238.331,240.581,242.82
48
3.3011,220.0021,220.00816.15814.825.7019,380.0029,380.001,130.001,202.311,204.551,206.791,209.041,211.281,213.531,215.771,218.011,220.261,222.501,224.741,226.991,229.231,231.471,233.721,235.961,238.211,240.451,242.691,244.941,247.18
49
3.4011,560.0021,560.00829.23819.185.8019,720.0029,720.001,143.081,206.671,208.911,211.151,213.401,215.641,217.881,220.131,222.371,224.621,226.861,229.101,231.351,233.591,235.831,238.081,240.321,242.561,244.811,247.051,249.291,251.54
50
3.5011,900.0021,900.00842.31823.545.9020,060.0030,060.001,156.151,211.031,213.271,215.511,217.761,220.001,222.241,224.491,226.731,228.971,231.221,233.461,235.711,237.951,240.191,242.441,244.681,246.921,249.171,251.411,253.651,255.90
51
3.6012,240.0022,240.00855.38827.906.0020,400.0030,400.001,169.231,215.381,217.631,219.871,222.121,224.361,226.601,228.851,231.091,233.331,235.581,237.821,240.061,242.311,244.551,246.791,249.041,251.281,253.531,255.771,258.011,260.26
52
3.7012,580.0022,580.00868.46832.26
53
3.8012,920.0022,920.00881.54836.62
54
3.9013,260.0023,260.00894.62840.98
55
4.0013,600.0023,600.00907.69845.34
56
4.1013,940.0023,940.00920.77849.70
57
4.2014,280.0024,280.00933.85854.06
58
4.3014,620.0024,620.00946.92858.41
59
4.4014,960.0024,960.00960.00862.77
60
4.5015,300.0025,300.00973.08867.13
61
4.6015,640.0025,640.00986.15871.49
62
4.7015,980.0025,980.00999.23875.85
63
4.8016,320.0026,320.001,012.31880.213 yr is better
64
4.9016,660.0026,660.001,025.38884.57
65
5.0017,000.0027,000.001,038.46888.93
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100