Docstoc

Mortgage-Calculator

Document Sample
Mortgage-Calculator Powered By Docstoc
					 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 fanzhongqing http://
About