Docstoc

Mortgage Calculator Xls

Document Sample
Mortgage Calculator Xls Powered By Docstoc
					Murcia Mortgages Free Repayment Calculator

How to use our detailed Mortgage calculator : Firstly, decide which type of Mortgage suits you best and then just input the loan amo
the interest rate and the number of years the loan is to be repaid over, into the highlighted blue boxes below.




For Repayment mortgage (Capital + Interest)

Loan Amount                       100,000.00
Interest Rate %                            5%
Number Of Years                               10


Payment Amount                        1060.66
Per Month approx
Repayment Schedule
 Payment       Payment Made        Interest        Reduction Outstanding
           0                 0                0            0 100,000.00
           1          1060.66          416.67          643.99    99356.01
           2          1060.66          413.98          646.67    98709.34
           3          1060.66          411.29          649.37    98059.97
           4          1060.66          408.58          652.07    97407.90
           5          1060.66          405.87          654.79    96753.11
           6          1060.66          403.14          657.52    96095.60
          7           1060.66          400.40          660.26    95435.34
          8           1060.66          397.65          663.01    94772.33
          9           1060.66          394.88          665.77    94106.56
         10           1060.66          392.11          668.54    93438.02
         11           1060.66          389.33          671.33    92766.69
         12           1060.66          386.53          674.13    92092.56
         13           1060.66          383.72          676.94    91415.62
         14           1060.66          380.90          679.76    90735.87
         15           1060.66          378.07          682.59    90053.28
         16           1060.66          375.22          685.43    89367.84
         17           1060.66          372.37          688.29    88679.55
         18           1060.66          369.50          691.16    87988.40
         19           1060.66          366.62          694.04    87294.36
         20           1060.66          363.73          696.93    86597.43
         21           1060.66          360.82          699.83    85897.60
         22           1060.66          357.91          702.75    85194.85
         23           1060.66          354.98          705.68    84489.17
         24           1060.66          352.04          708.62    83780.56
         25           1060.66          349.09          711.57    83068.99
         26           1060.66          346.12          714.53    82354.45
         27           1060.66          343.14          717.51    81636.94
         28           1060.66          340.15          720.50    80916.44
         29           1060.66          337.15          723.50    80192.94
         30           1060.66          334.14          726.52    79466.42
         31           1060.66          331.11          729.55    78736.87
         32           1060.66          328.07          732.58    78004.29
33   1060.66   325.02   735.64   77268.65
34   1060.66   321.95   738.70   76529.95
35   1060.66   318.87   741.78   75788.17
36   1060.66   315.78   744.87   75043.30
37   1060.66   312.68   747.97   74295.32
38   1060.66   309.56   751.09   73544.23
39   1060.66   306.43   754.22   72790.01
40   1060.66   303.29   757.36   72032.65
41   1060.66   300.14   760.52   71272.13
42   1060.66   296.97   763.69   70508.44
43   1060.66   293.79   766.87   69741.57
44   1060.66   290.59   770.07   68971.51
45   1060.66   287.38   773.27   68198.23
46   1060.66   284.16   776.50   67421.74
47   1060.66   280.92   779.73   66642.00
48   1060.66   277.68   782.98   65859.02
49   1060.66   274.41   786.24   65072.78
50   1060.66   271.14   789.52   64283.26
51   1060.66   267.85   792.81   63490.46
52   1060.66   264.54   796.11   62694.34
53   1060.66   261.23   799.43   61894.91
54   1060.66   257.90   802.76   61092.16
55   1060.66   254.55   806.10   60286.05
56   1060.66   251.19   809.46   59476.59
57   1060.66   247.82   812.84   58663.75
58   1060.66   244.43   816.22   57847.53
59   1060.66   241.03   819.62   57027.90
60   1060.66   237.62   823.04   56204.87
61   1060.66   234.19   826.47   55378.40
62   1060.66   230.74   829.91   54548.49
63   1060.66   227.29   833.37   53715.12
64   1060.66   223.81   836.84   52878.27
65   1060.66   220.33   840.33   52037.94
66   1060.66   216.82   843.83   51194.11
67   1060.66   213.31   847.35   50346.77
68   1060.66   209.78   850.88   49495.89
69   1060.66   206.23   854.42   48641.47
70   1060.66   202.67   857.98   47783.49
71   1060.66   199.10   861.56   46921.93
72   1060.66   195.51   865.15   46056.78
73   1060.66   191.90   868.75   45188.03
74   1060.66   188.28   872.37   44315.66
75   1060.66   184.65   876.01   43439.65
76   1060.66   181.00   879.66   42560.00
77   1060.66   177.33   883.32   41676.67
78   1060.66   173.65   887.00   40789.67
79   1060.66   169.96   890.70   39898.97
80   1060.66   166.25   894.41   39004.56
81   1060.66   162.52   898.14   38106.43
82   1060.66   158.78   901.88   37204.55
83   1060.66   155.02   905.64   36298.91
84   1060.66   151.25   909.41   35389.50
85   1060.66   147.46   913.20   34476.30
86   1060.66   143.65   917.00   33559.30
87   1060.66   139.83   920.82   32638.48
88   1060.66   135.99   924.66   31713.81
 89   1060.66   132.14    928.51   30785.30
 90   1060.66   128.27    932.38   29852.92
 91   1060.66   124.39    936.27   28916.65
 92   1060.66   120.49    940.17   27976.48
 93   1060.66   116.57    944.09   27032.39
 94   1060.66   112.63    948.02   26084.37
 95   1060.66   108.68    951.97   25132.40
 96   1060.66   104.72    955.94   24176.47
 97   1060.66   100.74    959.92   23216.55
 98   1060.66    96.74    963.92   22252.63
 99   1060.66    92.72    967.94   21284.69
100   1060.66    88.69    971.97   20312.72
101   1060.66    84.64    976.02   19336.70
102   1060.66    80.57    980.09   18356.62
103   1060.66    76.49    984.17   17372.45
104   1060.66    72.39    988.27   16384.18
105   1060.66    68.27    992.39   15391.79
106   1060.66    64.13    996.52   14395.27
107   1060.66    59.98   1000.67   13394.59
108   1060.66    55.81   1004.84   12389.75
109   1060.66    51.62   1009.03   11380.72
110   1060.66    47.42   1013.24   10367.48
111   1060.66    43.20   1017.46    9350.02
112   1060.66    38.96   1021.70    8328.33
113   1060.66    34.70   1025.95    7302.37
114   1060.66    30.43   1030.23    6272.15
115   1060.66    26.13   1034.52    5237.62
116   1060.66    21.82   1038.83    4198.79
117   1060.66    17.49   1043.16    3155.63
118   1060.66    13.15   1047.51    2108.13
119   1060.66     8.78   1051.87    1056.25
120   1060.66     4.40   1056.25       0.00
e which type of Mortgage suits you best and then just input the loan amount,
epaid over, into the highlighted blue boxes below.




                      For Interest only mortgage

                      Loan Amount                                              100,000.00
                      Interest Rate %                                              5.00%
                      Number Of Years                                                  10
                      Annual Interest                                                5000


                      Payment Amount                                               416.67
                      Per Month approx

                      Important - At the end of the 'Interest Only' loan period you will still have the
                      full amount of the original loan outstanding !!


                      Please contact us for any further assistance you may need.

                            For further details please call:
                             +34 968 580 735
                      or e-mail us at :                        info@murciamortgages.com

				
DOCUMENT INFO
Shared By:
Stats:
views:157
posted:6/29/2009
language:English
pages:4