# Mortgage-Calculator

Document Sample

```					 Excel-Sheets.com
Mortgage Calculator
Friday, May 18, 2012

Input
Payment
Principal                  €   1,000,000.00   5,000.00 €
PeriodLoan term in years                 30
4,500.00 €
Intrest Rate p.a.                    4.000%
4,000.00 €
Output                                        3,500.00 €
Total payment amount       €   1,703,886.27   3,000.00 €
Total Intrest payment      €     703,886.27   2,500.00 €
Monthly payment            €       4,733.02   2,000.00 €
1,500.00 €
Computations figures
1,000.00 €
Monthly Intrest Rate                0.327%
500.00 €
Termins                                360
0.00 €

,
Year Term       Payment
Intrest

1     €    1,459.28
2     €    1,464.05
3     €    1,468.85

4     €    1,473.66
5     €    1,478.48
6     €    1,483.32
1
7     €    1,488.18
8     €    1,493.05

9     €    1,497.94
10     €    1,502.84
11     €    1,507.76
12     €    1,512.70
13     €    1,517.65
14     €    1,522.62

15     €    1,527.60
16     €    1,532.60
17     €    1,537.62
2    18     €    1,542.65
19     €    1,547.70
20     €    1,552.77
21     €    1,557.85
22     €    1,562.95
23     €    1,568.07
24     €    1,573.20
25     €    1,578.35
26     €    1,583.52
27     €    1,588.71
28     €    1,593.91
29     €    1,599.12
30     €    1,604.36
3
31     €    1,609.61
32     €    1,614.88
33     €    1,620.17
34     €    1,625.47
35     €    1,630.79
36     €    1,636.13
37     €    1,641.49
38   €   1,646.86
39   €   1,652.25
40   €   1,657.66
41   €   1,663.09
42   €   1,668.53
4
43   €   1,674.00
44   €   1,679.48
45   €   1,684.98
46   €   1,690.49
47   €   1,696.03
48   €   1,701.58
49   €   1,707.15
50   €   1,712.74
51   €   1,718.34
52   €   1,723.97
53   €   1,729.61
54   €   1,735.28
5
55   €   1,740.96
56   €   1,746.66
57   €   1,752.37
58   €   1,758.11
59   €   1,763.87
60   €   1,769.64
61   €   1,775.43
62   €   1,781.25
63   €   1,787.08
64   €   1,792.93
65   €   1,798.80
66   €   1,804.69
6
67   €   1,810.59
68   €   1,816.52
69   €   1,822.47
70   €   1,828.44
71   €   1,834.42
72   €   1,840.43
73   €   1,846.45
74   €   1,852.50
75   €   1,858.56
76   €   1,864.65
77   €   1,870.75
78   €   1,876.87
7
79   €   1,883.02
80   €   1,889.18
81   €   1,895.37
82   €   1,901.57
83   €   1,907.80
84   €   1,914.04
85    €   1,920.31
86    €   1,926.60
87    €   1,932.90
88    €   1,939.23
89    €   1,945.58
90    €   1,951.95
8
91    €   1,958.34
92    €   1,964.75
93    €   1,971.18
94    €   1,977.64
95    €   1,984.11
96    €   1,990.61
97    €   1,997.12
98    €   2,003.66
99    €   2,010.22
100   €   2,016.80
101   €   2,023.40
102   €   2,030.03
9
103   €   2,036.67
104   €   2,043.34
105   €   2,050.03
106   €   2,056.74
107   €   2,063.47
108   €   2,070.23
109   €   2,077.01
110   €   2,083.81
111   €   2,090.63
112   €   2,097.47
113   €   2,104.34
114   €   2,111.23
10
115   €   2,118.14
116   €   2,125.07
117   €   2,132.03
118   €   2,139.01
119   €   2,146.01
120   €   2,153.04
121   €   2,160.09
122   €   2,167.16
123   €   2,174.25
124   €   2,181.37
125   €   2,188.51
126   €   2,195.68
11
127   €   2,202.87
128   €   2,210.08
129   €   2,217.31
130   €   2,224.57
131   €   2,231.85
132   €   2,239.16
133   €   2,246.49
134   €   2,253.85
135   €   2,261.22
136   €   2,268.63
137   €   2,276.05
138   €   2,283.50
12
139   €   2,290.98
140   €   2,298.48
141   €   2,306.00
142   €   2,313.55
143   €   2,321.13
144   €   2,328.73
145   €   2,336.35
146   €   2,344.00
147   €   2,351.67
148   €   2,359.37
149   €   2,367.10
150   €   2,374.84
13
151   €   2,382.62
152   €   2,390.42
153   €   2,398.25
154   €   2,406.10
155   €   2,413.97
156   €   2,421.88
157   €   2,429.80
158   €   2,437.76
159   €   2,445.74
160   €   2,453.75
161   €   2,461.78
162   €   2,469.84
14
163   €   2,477.92
164   €   2,486.04
165   €   2,494.17
166   €   2,502.34
167   €   2,510.53
168   €   2,518.75
169   €   2,527.00
170   €   2,535.27
171   €   2,543.57
172   €   2,551.90
173   €   2,560.25
174   €   2,568.63
15
175   €   2,577.04
176   €   2,585.48
177   €   2,593.94
178   €   2,602.43
179   €   2,610.95
180   €   2,619.50
181   €   2,628.08
182   €   2,636.68
183   €   2,645.31
184   €   2,653.97
185   €   2,662.66
186   €   2,671.38
16
187   €   2,680.12
188   €   2,688.90
189   €   2,697.70
190   €   2,706.53
191   €   2,715.39
192   €   2,724.28
193   €   2,733.20
194   €   2,742.15
195   €   2,751.12
196   €   2,760.13
197   €   2,769.17
198   €   2,778.23
17
199   €   2,787.33
200   €   2,796.45
201   €   2,805.61
202   €   2,814.79
203   €   2,824.01
204   €   2,833.25
205   €   2,842.53
206   €   2,851.83
207   €   2,861.17
208   €   2,870.54
209   €   2,879.93
210   €   2,889.36
18
211   €   2,898.82
212   €   2,908.31
213   €   2,917.83
214   €   2,927.38
215   €   2,936.97
216   €   2,946.58
217   €   2,956.23
218   €   2,965.91
219   €   2,975.62
220   €   2,985.36
221   €   2,995.13
222   €   3,004.94
19
223   €   3,014.77
224   €   3,024.64
225   €   3,034.55
19

226   €   3,044.48
227   €   3,054.45
228   €   3,064.45
229   €   3,074.48
230   €   3,084.54
231   €   3,094.64
232   €   3,104.77
233   €   3,114.94
234   €   3,125.13
20
235   €   3,135.36
236   €   3,145.63
237   €   3,155.93
238   €   3,166.26
239   €   3,176.62
240   €   3,187.02
241   €   3,197.46
242   €   3,207.92
243   €   3,218.43
244   €   3,228.96
245   €   3,239.53
246   €   3,250.14
21
247   €   3,260.78
248   €   3,271.45
249   €   3,282.16
250   €   3,292.91
251   €   3,303.69
252   €   3,314.50
253   €   3,325.36
254   €   3,336.24
255   €   3,347.16
256   €   3,358.12
257   €   3,369.11
258   €   3,380.14
22
259   €   3,391.21
260   €   3,402.31
261   €   3,413.45
262   €   3,424.63
263   €   3,435.84
264   €   3,447.08
265   €   3,458.37
266   €   3,469.69
267   €   3,481.05
268   €   3,492.45
269   €   3,503.88
270   €   3,515.35
23
271   €   3,526.86
272   €   3,538.40
23

273   €   3,549.99
274   €   3,561.61
275   €   3,573.27
276   €   3,584.97
276   €   3,596.70
276   €   3,608.48
276   €   3,620.29
276   €   3,632.14
276   €   3,644.03
276   €   3,655.96
24
276   €   3,667.93
276   €   3,679.94
276   €   3,691.99
276   €   3,704.07
276   €   3,716.20
276   €   3,728.37
276   €   3,740.57
276   €   3,752.82
276   €   3,765.10
276   €   3,777.43
276   €   3,789.80
276   €   3,802.20
25
276   €   3,814.65
276   €   3,827.14
276   €   3,839.67
276   €   3,852.24
276   €   3,864.85
276   €   3,877.50
276   €   3,890.20
276   €   3,902.93
276   €   3,915.71
276   €   3,928.53
276   €   3,941.39
276   €   3,954.29
26
276   €   3,967.24
276   €   3,980.22
276   €   3,993.25
276   €   4,006.33
276   €   4,019.44
276   €   4,032.60
276   €   4,045.80
276   €   4,059.05
276   €   4,072.34
276   €   4,085.67
276   €   4,099.04
276   €   4,112.46
27
276   €   4,125.93
27

276   €   4,139.43
276   €   4,152.98
276   €   4,166.58
276   €   4,180.22
276   €   4,193.91
276   €   4,207.64
276   €   4,221.41
276   €   4,235.23
276   €   4,249.09
276   €   4,263.01
276   €   4,276.96
28
276   €   4,290.96
276   €   4,305.01
276   €   4,319.10
276   €   4,333.24
276   €   4,347.43
276   €   4,361.66
276   €   4,375.94
276   €   4,390.27
276   €   4,404.64
276   €   4,419.06
276   €   4,433.53
276   €   4,448.04
29
276   €   4,462.60
276   €   4,477.21
276   €   4,491.87
276   €   4,506.57
276   €   4,521.33
276   €   4,536.13
276   €   4,550.98
276   €   4,565.88
276   €   4,580.82
276   €   4,595.82
276   €   4,610.87
276   €   4,625.96
30
276   €   4,641.11
276   €   4,656.30
276   €   4,671.54
276   €   4,686.84
276   €   4,702.18
276   €   4,717.57
Intrest         Principal
€   1,000,000.00
€   3,273.74 €     998,540.72
€   3,268.96 €     997,076.67
€   3,264.17 €     995,607.82

€   3,259.36 €     994,134.16
€   3,254.54 €     992,655.68
€   3,249.70 €     991,172.36
€   3,244.84 €     989,684.18
€   3,239.97 €     988,191.14

€   3,235.08 €     986,693.20
€   3,230.18 €     985,190.36
€   3,225.26 €     983,682.60
€   3,220.32 €     982,169.90
€   3,215.37 €     980,652.25
€   3,210.40 €     979,129.64

€   3,205.42 €     977,602.03
€   3,200.41 €     976,069.43
€   3,195.40 €     974,531.81
€   3,190.36 €     972,989.16
€   3,185.31 €     971,441.45
€   3,180.25 €     969,888.68
€   3,175.16 €     968,330.83
€   3,170.06 €     966,767.87
€   3,164.95 €     965,199.80
€   3,159.81 €     963,626.60
€   3,154.66 €     962,048.24
€   3,149.50 €     960,464.72
€   3,144.31 €     958,876.02
€   3,139.11 €     957,282.11
€   3,133.89 €     955,682.98
€   3,128.66 €     954,078.62
€   3,123.41 €     952,469.01
€   3,118.14 €     950,854.13
€   3,112.85 €     949,233.96
€   3,107.54 €     947,608.49
€   3,102.22 €     945,977.70
€   3,096.88 €     944,341.56
€   3,091.53 €     942,700.07
€   3,086.15 €   941,053.21
€   3,080.76 €   939,400.96
€   3,075.35 €   937,743.29
€   3,069.93 €   936,080.20
€   3,064.48 €   934,411.67
€   3,059.02 €   932,737.67
€   3,053.54 €   931,058.20
€   3,048.04 €   929,373.22
€   3,042.53 €   927,682.73
€   3,036.99 €   925,986.70
€   3,031.44 €   924,285.13
€   3,025.87 €   922,577.98
€   3,020.28 €   920,865.24
€   3,014.67 €   919,146.90
€   3,009.05 €   917,422.93
€   3,003.40 €   915,693.31
€   2,997.74 €   913,958.04
€   2,992.06 €   912,217.08
€   2,986.36 €   910,470.42
€   2,980.64 €   908,718.05
€   2,974.91 €   906,959.94
€   2,969.15 €   905,196.07
€   2,963.38 €   903,426.43
€   2,957.58 €   901,651.00
€   2,951.77 €   899,869.75
€   2,945.94 €   898,082.67
€   2,940.09 €   896,289.74
€   2,934.22 €   894,490.95
€   2,928.33 €   892,686.26
€   2,922.42 €   890,875.66
€   2,916.50 €   889,059.14
€   2,910.55 €   887,236.67
€   2,904.58 €   885,408.24
€   2,898.60 €   883,573.82
€   2,892.59 €   881,733.39
€   2,886.57 €   879,886.94
€   2,880.52 €   878,034.44
€   2,874.46 €   876,175.88
€   2,868.37 €   874,311.24
€   2,862.27 €   872,440.49
€   2,856.14 €   870,563.61
€   2,850.00 €   868,680.59
€   2,843.83 €   866,791.41
€   2,837.65 €   864,896.04
€   2,831.44 €   862,994.47
€   2,825.22 €   861,086.67
€   2,818.97 €   859,172.63
€   2,812.71 €   857,252.32
€   2,806.42 €   855,325.72
€   2,800.11 €   853,392.82
€   2,793.79 €   851,453.59
€   2,787.44 €   849,508.01
€   2,781.07 €   847,556.06
€   2,774.68 €   845,597.72
€   2,768.27 €   843,632.97
€   2,761.83 €   841,661.78
€   2,755.38 €   839,684.15
€   2,748.91 €   837,700.04
€   2,742.41 €   835,709.43
€   2,735.90 €   833,712.31
€   2,729.36 €   831,708.65
€   2,722.80 €   829,698.43
€   2,716.22 €   827,681.63
€   2,709.61 €   825,658.23
€   2,702.99 €   823,628.20
€   2,696.34 €   821,591.53
€   2,689.68 €   819,548.19
€   2,682.99 €   817,498.16
€   2,676.28 €   815,441.41
€   2,669.54 €   813,377.94
€   2,662.79 €   811,307.71
€   2,656.01 €   809,230.70
€   2,649.21 €   807,146.90
€   2,642.39 €   805,056.27
€   2,635.54 €   802,958.80
€   2,628.68 €   800,854.46
€   2,621.79 €   798,743.23
€   2,614.88 €   796,625.09
€   2,607.94 €   794,500.01
€   2,600.99 €   792,367.98
€   2,594.01 €   790,228.97
€   2,587.00 €   788,082.96
€   2,579.98 €   785,929.92
€   2,572.93 €   783,769.83
€   2,565.86 €   781,602.67
€   2,558.76 €   779,428.42
€   2,551.65 €   777,247.05
€   2,544.50 €   775,058.54
€   2,537.34 €   772,862.86
€   2,530.15 €   770,659.99
€   2,522.94 €   768,449.92
€   2,515.71 €   766,232.60
€   2,508.45 €   764,008.03
€   2,501.16 €   761,776.18
€   2,493.86 €   759,537.02
€   2,486.53 €   757,290.53
€   2,479.17 €   755,036.68
€   2,471.79 €   752,775.46
€   2,464.39 €   750,506.83
€   2,456.96 €   748,230.78
€   2,449.51 €   745,947.27
€   2,442.04 €   743,656.29
€   2,434.54 €   741,357.81
€   2,427.01 €   739,051.81
€   2,419.46 €   736,738.25
€   2,411.89 €   734,417.13
€   2,404.29 €   732,088.40
€   2,396.67 €   729,752.05
€   2,389.02 €   727,408.05
€   2,381.34 €   725,056.38
€   2,373.65 €   722,697.01
€   2,365.92 €   720,329.91
€   2,358.17 €   717,955.07
€   2,350.40 €   715,572.45
€   2,342.60 €   713,182.03
€   2,334.77 €   710,783.78
€   2,326.92 €   708,377.68
€   2,319.04 €   705,963.71
€   2,311.14 €   703,541.84
€   2,303.21 €   701,112.03
€   2,295.26 €   698,674.27
€   2,287.28 €   696,228.53
€   2,279.27 €   693,774.79
€   2,271.24 €   691,313.01
€   2,263.18 €   688,843.17
€   2,255.09 €   686,365.24
€   2,246.98 €   683,879.21
€   2,238.84 €   681,385.03
€   2,230.68 €   678,882.69
€   2,222.49 €   676,372.16
€   2,214.27 €   673,853.41
€   2,206.02 €   671,326.41
€   2,197.75 €   668,791.14
€   2,189.45 €   666,247.57
€   2,181.12 €   663,695.68
€   2,172.77 €   661,135.43
€   2,164.39 €   658,566.80
€   2,155.98 €   655,989.75
€   2,147.54 €   653,404.28
€   2,139.08 €   650,810.34
€   2,130.58 €   648,207.90
€   2,122.06 €   645,596.95
€   2,113.52 €   642,977.45
€   2,104.94 €   640,349.37
€   2,096.34 €   637,712.69
€   2,087.71 €   635,067.38
€   2,079.05 €   632,413.41
€   2,070.36 €   629,750.75
€   2,061.64 €   627,079.37
€   2,052.89 €   624,399.25
€   2,044.12 €   621,710.35
€   2,035.32 €   619,012.65
€   2,026.49 €   616,306.12
€   2,017.63 €   613,590.73
€   2,008.74 €   610,866.45
€   1,999.82 €   608,133.25
€   1,990.87 €   605,391.10
€   1,981.89 €   602,639.97
€   1,972.89 €   599,879.84
€   1,963.85 €   597,110.68
€   1,954.78 €   594,332.44
€   1,945.69 €   591,545.12
€   1,936.56 €   588,748.66
€   1,927.41 €   585,943.06
€   1,918.23 €   583,128.26
€   1,909.01 €   580,304.26
€   1,899.77 €   577,471.00
€   1,890.49 €   574,628.48
€   1,881.18 €   571,776.64
€   1,871.85 €   568,915.47
€   1,862.48 €   566,044.94
€   1,853.08 €   563,165.00
€   1,843.66 €   560,275.64
€   1,834.20 €   557,376.82
€   1,824.71 €   554,468.51
€   1,815.19 €   551,550.68
€   1,805.63 €   548,623.30
€   1,796.05 €   545,686.33
€   1,786.44 €   542,739.75
€   1,776.79 €   539,783.52
€   1,767.11 €   536,817.61
€   1,757.40 €   533,841.99
€   1,747.66 €   530,856.64
€   1,737.89 €   527,861.51
€   1,728.08 €   524,856.57
€   1,718.24 €   521,841.80
€   1,708.37 €   518,817.15
€   1,698.47 €   515,782.61
€   1,688.54 €   512,738.13
€   1,678.57 €   509,683.68
€   1,668.57 €   506,619.24
€   1,658.54 €   503,544.76
€   1,648.47 €   500,460.22
€   1,638.38 €   497,365.58
€   1,628.25 €   494,260.80
€   1,618.08 €   491,145.87
€   1,607.88 €   488,020.73
€   1,597.65 €   484,885.37
€   1,587.39 €   481,739.74
€   1,577.09 €   478,583.81
€   1,566.76 €   475,417.55
€   1,556.39 €   472,240.93
€   1,545.99 €   469,053.91
€   1,535.56 €   465,856.45
€   1,525.09 €   462,648.53
€   1,514.59 €   459,430.10
€   1,504.05 €   456,201.14
€   1,493.48 €   452,961.60
€   1,482.88 €   449,711.46
€   1,472.24 €   446,450.68
€   1,461.56 €   443,179.23
€   1,450.85 €   439,897.07
€   1,440.11 €   436,604.16
€   1,429.33 €   433,300.47
€   1,418.51 €   429,985.96
€   1,407.66 €   426,660.61
€   1,396.78 €   423,324.37
€   1,385.85 €   419,977.20
€   1,374.90 €   416,619.08
€   1,363.90 €   413,249.97
€   1,352.87 €   409,869.82
€   1,341.81 €   406,478.61
€   1,330.71 €   403,076.30
€   1,319.57 €   399,662.85
€   1,308.39 €   396,238.22
€   1,297.18 €   392,802.39
€   1,285.93 €   389,355.30
€   1,274.65 €   385,896.93
€   1,263.33 €   382,427.24
€   1,251.97 €   378,946.19
€   1,240.57 €   375,453.75
€   1,229.14 €   371,949.87
€   1,217.67 €   368,434.52
€   1,206.16 €   364,907.66
€   1,194.61 €   361,369.25
€   1,183.03 €   357,819.26
€   1,171.41 €   354,257.65
€   1,159.75 €   350,684.38
€   1,148.05 €   347,099.42
€   1,136.31 €   343,502.71
€   1,124.54 €   339,894.23
€   1,112.73 €   336,273.94
€   1,100.87 €   332,641.80
€   1,088.98 €   328,997.76
€   1,077.05 €   325,341.80
€   1,065.08 €   321,673.87
€   1,053.08 €   317,993.92
€   1,041.03 €   314,301.94
€   1,028.94 €   310,597.86
€   1,016.82 €   306,881.66
€   1,004.65 €   303,153.29
€    992.44 €    299,412.72
€    980.20 €    295,659.90
€    967.91 €    291,894.80
€    955.59 €    288,117.37
€    943.22 €    284,327.57
€    930.81 €    280,525.37
€    918.37 €    276,710.72
€    905.88 €    272,883.58
€    893.35 €    269,043.91
€    880.78 €    265,191.68
€    868.17 €    261,326.83
€    855.52 €    257,449.33
€    842.82 €    253,559.13
€    830.09 €    249,656.20
€    817.31 €    245,740.49
€    804.49 €    241,811.97
€    791.63 €    237,870.58
€    778.73 €    233,916.29
€    765.78 €    229,949.05
€    752.79 €    225,968.83
€    739.76 €    221,975.57
€    726.69 €    217,969.24
€    713.57 €    213,949.80
€    700.42 €    209,917.20
€    687.21 €    205,871.40
€    673.97 €    201,812.35
€    660.68 €    197,740.01
€    647.35 €    193,654.35
€    633.97 €    189,555.30
€    620.55 €    185,442.84
€    607.09 €    181,316.91
€   593.58 €   177,177.48
€   580.03 €   173,024.50
€   566.44 €   168,857.92
€   552.80 €   164,677.70
€   539.11 €   160,483.79
€   525.38 €   156,276.15
€   511.61 €   152,054.74
€   497.79 €   147,819.51
€   483.92 €   143,570.42
€   470.01 €   139,307.41
€   456.06 €   135,030.45
€   442.05 €   130,739.49
€   428.01 €   126,434.48
€   413.91 €   122,115.38
€   399.77 €   117,782.13
€   385.59 €   113,434.70
€   371.36 €   109,073.04
€   357.08 €   104,697.10
€   342.75 €   100,306.84
€   328.38 €    95,902.20
€   313.96 €    91,483.14
€   299.49 €    87,049.61
€   284.98 €    82,601.57
€   270.42 €    78,138.97
€   255.81 €    73,661.76
€   241.15 €    69,169.89
€   226.44 €    64,663.32
€   211.69 €    60,141.99
€   196.89 €    55,605.86
€   182.04 €    51,054.89
€   167.14 €    46,489.01
€   152.19 €    41,908.18
€   137.20 €    37,312.36
€   122.15 €    32,701.50
€   107.06 €    28,075.54
€   91.91 €     23,434.43
€   76.72 €     18,778.13
€   61.47 €     14,106.59
€   46.18 €      9,419.75
€   30.84 €      4,717.57
€   15.44 €          0.00

```
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
 views: 0 posted: 5/18/2012 language: pages: 24
fanzhongqing http://