Docstoc

Mortgage Loan Calculator

Document Sample
Mortgage Loan Calculator Powered By Docstoc
					Mortgage Loan Calculator

                      Enter Values                                                Loan Summary
                        Loan Amount $ 100,000.00                               Scheduled Payment $         599.55
                Annual Interest Rate       6.00%                    Scheduled Number of Payments              360
                Loan Period in Years           30                      Actual Number of Payments              360
        Number of Payments Per Year            12                             Total Early Payments $          -
                   Start Date of Loan    1/6/2004                                     Total Interest $ 115,838.19
            Optional Extra Payments $         -




Pmt                     Beginning        Scheduled          Extra                                                          Ending        Cumulative
No.   Payment Date        Balance         Payment        Payment    Total Payment        Principal        Interest        Balance           Interest
1         2/6/2004 $    100,000.00   $     599.55    $       -      $     599.55    $       99.55    $    500.00     $   99,900.45   $       500.00
2         3/6/2004       99,900.45         599.55            -            599.55           100.05         499.50         99,800.40           999.50
3         4/6/2004       99,800.40         599.55            -            599.55           100.55         499.00         99,699.85         1,498.50
4         5/6/2004       99,699.85         599.55            -            599.55           101.05         498.50         99,598.80         1,997.00
5         6/6/2004       99,598.80         599.55            -            599.55           101.56         497.99         99,497.24         2,495.00
6         7/6/2004       99,497.24         599.55            -            599.55           102.06         497.49         99,395.18         2,992.48
7         8/6/2004       99,395.18         599.55            -            599.55           102.57         496.98         99,292.61         3,489.46
8         9/6/2004       99,292.61         599.55            -            599.55           103.09         496.46         99,189.52         3,985.92
9        10/6/2004       99,189.52         599.55            -            599.55           103.60         495.95         99,085.92         4,481.87
10       11/6/2004       99,085.92         599.55            -            599.55           104.12         495.43         98,981.79         4,977.30
11       12/6/2004       98,981.79         599.55            -            599.55           104.64         494.91         98,877.15         5,472.21
12        1/6/2005       98,877.15         599.55            -            599.55           105.16         494.39         98,771.99         5,966.59
13        2/6/2005       98,771.99         599.55            -            599.55           105.69         493.86         98,666.30         6,460.45
14        3/6/2005       98,666.30         599.55            -            599.55           106.22         493.33         98,560.08         6,953.79
15        4/6/2005       98,560.08         599.55            -            599.55           106.75         492.80         98,453.33         7,446.59
16        5/6/2005       98,453.33         599.55            -            599.55           107.28         492.27         98,346.04         7,938.85
17        6/6/2005       98,346.04         599.55            -            599.55           107.82         491.73         98,238.22         8,430.58
18        7/6/2005       98,238.22         599.55            -            599.55           108.36         491.19         98,129.86         8,921.77
19        8/6/2005       98,129.86         599.55            -            599.55           108.90         490.65         98,020.96         9,412.42
20        9/6/2005       98,020.96         599.55            -            599.55           109.45         490.10         97,911.52         9,902.53
21       10/6/2005       97,911.52         599.55            -            599.55           109.99         489.56         97,801.53        10,392.09
22       11/6/2005       97,801.53         599.55            -            599.55           110.54         489.01         97,690.98        10,881.09
23       12/6/2005       97,690.98         599.55            -            599.55           111.10         488.45         97,579.89        11,369.55
24        1/6/2006       97,579.89         599.55            -            599.55           111.65         487.90         97,468.24        11,857.45
25        2/6/2006       97,468.24         599.55            -            599.55           112.21         487.34         97,356.03        12,344.79
26        3/6/2006       97,356.03         599.55            -            599.55           112.77         486.78         97,243.26        12,831.57
27        4/6/2006       97,243.26         599.55            -            599.55           113.33         486.22         97,129.92        13,317.79
28        5/6/2006       97,129.92         599.55            -            599.55           113.90         485.65         97,016.02        13,803.44
29        6/6/2006       97,016.02         599.55            -            599.55           114.47         485.08         96,901.55        14,288.52
30        7/6/2006       96,901.55         599.55            -            599.55           115.04         484.51         96,786.51        14,773.02
31        8/6/2006       96,786.51         599.55            -            599.55           115.62         483.93         96,670.89        15,256.96
32        9/6/2006       96,670.89         599.55            -            599.55           116.20         483.35         96,554.69        15,740.31
33       10/6/2006       96,554.69         599.55            -            599.55           116.78         482.77         96,437.92        16,223.08
34       11/6/2006       96,437.92         599.55            -            599.55           117.36         482.19         96,320.56        16,705.27
35       12/6/2006       96,320.56         599.55            -            599.55           117.95         481.60         96,202.61        17,186.88
36        1/6/2007       96,202.61         599.55            -            599.55           118.54         481.01         96,084.07        17,667.89
37        2/6/2007       96,084.07         599.55            -            599.55           119.13         480.42         95,964.94        18,148.31
38        3/6/2007       95,964.94         599.55            -            599.55           119.73         479.82         95,845.21        18,628.13
Pmt                  Beginning   Scheduled      Extra                                             Ending   Cumulative
No.   Payment Date     Balance    Payment    Payment    Total Payment   Principal   Interest     Balance      Interest
39        4/6/2007   95,845.21      599.55       -             599.55    120.32      479.23    95,724.89    19,107.36
40        5/6/2007   95,724.89      599.55       -             599.55    120.93      478.62    95,603.96    19,585.98
41        6/6/2007   95,603.96      599.55       -             599.55    121.53      478.02    95,482.43    20,064.00
42        7/6/2007   95,482.43      599.55       -             599.55    122.14      477.41    95,360.29    20,541.42
43        8/6/2007   95,360.29      599.55       -             599.55    122.75      476.80    95,237.55    21,018.22
44        9/6/2007   95,237.55      599.55       -             599.55    123.36      476.19    95,114.18    21,494.41
45       10/6/2007   95,114.18      599.55       -             599.55    123.98      475.57    94,990.20    21,969.98
46       11/6/2007   94,990.20      599.55       -             599.55    124.60      474.95    94,865.60    22,444.93
47       12/6/2007   94,865.60      599.55       -             599.55    125.22      474.33    94,740.38    22,919.26
48        1/6/2008   94,740.38      599.55       -             599.55    125.85      473.70    94,614.53    23,392.96
49        2/6/2008   94,614.53      599.55       -             599.55    126.48      473.07    94,488.05    23,866.03
50        3/6/2008   94,488.05      599.55       -             599.55    127.11      472.44    94,360.94    24,338.47
51        4/6/2008   94,360.94      599.55       -             599.55    127.75      471.80    94,233.20    24,810.28
52        5/6/2008   94,233.20      599.55       -             599.55    128.38      471.17    94,104.81    25,281.44
53        6/6/2008   94,104.81      599.55       -             599.55    129.03      470.52    93,975.79    25,751.97
54        7/6/2008   93,975.79      599.55       -             599.55    129.67      469.88    93,846.12    26,221.84
55        8/6/2008   93,846.12      599.55       -             599.55    130.32      469.23    93,715.80    26,691.07
56        9/6/2008   93,715.80      599.55       -             599.55    130.97      468.58    93,584.82    27,159.65
57       10/6/2008   93,584.82      599.55       -             599.55    131.63      467.92    93,453.20    27,627.58
58       11/6/2008   93,453.20      599.55       -             599.55    132.28      467.27    93,320.91    28,094.84
59       12/6/2008   93,320.91      599.55       -             599.55    132.95      466.60    93,187.97    28,561.45
60        1/6/2009   93,187.97      599.55       -             599.55    133.61      465.94    93,054.36    29,027.39
61        2/6/2009   93,054.36      599.55       -             599.55    134.28      465.27    92,920.08    29,492.66
62        3/6/2009   92,920.08      599.55       -             599.55    134.95      464.60    92,785.13    29,957.26
63        4/6/2009   92,785.13      599.55       -             599.55    135.62      463.93    92,649.50    30,421.19
64        5/6/2009   92,649.50      599.55       -             599.55    136.30      463.25    92,513.20    30,884.43
65        6/6/2009   92,513.20      599.55       -             599.55    136.98      462.57    92,376.22    31,347.00
66        7/6/2009   92,376.22      599.55       -             599.55    137.67      461.88    92,238.55    31,808.88
67        8/6/2009   92,238.55      599.55       -             599.55    138.36      461.19    92,100.19    32,270.07
68        9/6/2009   92,100.19      599.55       -             599.55    139.05      460.50    91,961.14    32,730.57
69       10/6/2009   91,961.14      599.55       -             599.55    139.74      459.81    91,821.39    33,190.38
70       11/6/2009   91,821.39      599.55       -             599.55    140.44      459.11    91,680.95    33,649.49
71       12/6/2009   91,680.95      599.55       -             599.55    141.15      458.40    91,539.80    34,107.89
72        1/6/2010   91,539.80      599.55       -             599.55    141.85      457.70    91,397.95    34,565.59
73        2/6/2010   91,397.95      599.55       -             599.55    142.56      456.99    91,255.39    35,022.58
74        3/6/2010   91,255.39      599.55       -             599.55    143.27      456.28    91,112.12    35,478.86
75        4/6/2010   91,112.12      599.55       -             599.55    143.99      455.56    90,968.13    35,934.42
76        5/6/2010   90,968.13      599.55       -             599.55    144.71      454.84    90,823.42    36,389.26
77        6/6/2010   90,823.42      599.55       -             599.55    145.43      454.12    90,677.99    36,843.38
78        7/6/2010   90,677.99      599.55       -             599.55    146.16      453.39    90,531.82    37,296.77
79        8/6/2010   90,531.82      599.55       -             599.55    146.89      452.66    90,384.93    37,749.42
80        9/6/2010   90,384.93      599.55       -             599.55    147.63      451.92    90,237.31    38,201.35
81       10/6/2010   90,237.31      599.55       -             599.55    148.36      451.19    90,088.94    38,652.54
82       11/6/2010   90,088.94      599.55       -             599.55    149.11      450.44    89,939.84    39,102.98
83       12/6/2010   89,939.84      599.55       -             599.55    149.85      449.70    89,789.99    39,552.68
84        1/6/2011   89,789.99      599.55       -             599.55    150.60      448.95    89,639.39    40,001.63
85        2/6/2011   89,639.39      599.55       -             599.55    151.35      448.20    89,488.03    40,449.83
86        3/6/2011   89,488.03      599.55       -             599.55    152.11      447.44    89,335.92    40,897.27
87        4/6/2011   89,335.92      599.55       -             599.55    152.87      446.68    89,183.05    41,343.95
88        5/6/2011   89,183.05      599.55       -             599.55    153.64      445.92    89,029.42    41,789.86
89        6/6/2011   89,029.42      599.55       -             599.55    154.40      445.15    88,875.01    42,235.01
90        7/6/2011   88,875.01      599.55       -             599.55    155.18      444.38    88,719.84    42,679.38
Pmt                  Beginning   Scheduled      Extra                                             Ending   Cumulative
No.   Payment Date     Balance    Payment    Payment    Total Payment   Principal   Interest     Balance      Interest
91        8/6/2011   88,719.84      599.55       -             599.55    155.95      443.60    88,563.89    43,122.98
92        9/6/2011   88,563.89      599.55       -             599.55    156.73      442.82    88,407.15    43,565.80
93       10/6/2011   88,407.15      599.55       -             599.55    157.51      442.04    88,249.64    44,007.84
94       11/6/2011   88,249.64      599.55       -             599.55    158.30      441.25    88,091.34    44,449.09
95       12/6/2011   88,091.34      599.55       -             599.55    159.09      440.46    87,932.24    44,889.54
96        1/6/2012   87,932.24      599.55       -             599.55    159.89      439.66    87,772.35    45,329.20
97        2/6/2012   87,772.35      599.55       -             599.55    160.69      438.86    87,611.67    45,768.07
98        3/6/2012   87,611.67      599.55       -             599.55    161.49      438.06    87,450.17    46,206.12
99        4/6/2012   87,450.17      599.55       -             599.55    162.30      437.25    87,287.87    46,643.38
100       5/6/2012   87,287.87      599.55       -             599.55    163.11      436.44    87,124.76    47,079.81
101       6/6/2012   87,124.76      599.55       -             599.55    163.93      435.62    86,960.84    47,515.44
102       7/6/2012   86,960.84      599.55       -             599.55    164.75      434.80    86,796.09    47,950.24
103       8/6/2012   86,796.09      599.55       -             599.55    165.57      433.98    86,630.52    48,384.22
104       9/6/2012   86,630.52      599.55       -             599.55    166.40      433.15    86,464.12    48,817.38
105      10/6/2012   86,464.12      599.55       -             599.55    167.23      432.32    86,296.89    49,249.70
106      11/6/2012   86,296.89      599.55       -             599.55    168.07      431.48    86,128.83    49,681.18
107      12/6/2012   86,128.83      599.55       -             599.55    168.91      430.64    85,959.92    50,111.83
108       1/6/2013   85,959.92      599.55       -             599.55    169.75      429.80    85,790.17    50,541.62
109       2/6/2013   85,790.17      599.55       -             599.55    170.60      428.95    85,619.57    50,970.58
110       3/6/2013   85,619.57      599.55       -             599.55    171.45      428.10    85,448.12    51,398.67
111       4/6/2013   85,448.12      599.55       -             599.55    172.31      427.24    85,275.81    51,825.91
112       5/6/2013   85,275.81      599.55       -             599.55    173.17      426.38    85,102.63    52,252.29
113       6/6/2013   85,102.63      599.55       -             599.55    174.04      425.51    84,928.60    52,677.81
114       7/6/2013   84,928.60      599.55       -             599.55    174.91      424.64    84,753.69    53,102.45
115       8/6/2013   84,753.69      599.55       -             599.55    175.78      423.77    84,577.91    53,526.22
116       9/6/2013   84,577.91      599.55       -             599.55    176.66      422.89    84,401.25    53,949.11
117      10/6/2013   84,401.25      599.55       -             599.55    177.54      422.01    84,223.70    54,371.11
118      11/6/2013   84,223.70      599.55       -             599.55    178.43      421.12    84,045.27    54,792.23
119      12/6/2013   84,045.27      599.55       -             599.55    179.32      420.23    83,865.95    55,212.46
120       1/6/2014   83,865.95      599.55       -             599.55    180.22      419.33    83,685.72    55,631.79
121       2/6/2014   83,685.72      599.55       -             599.55    181.12      418.43    83,504.60    56,050.22
122       3/6/2014   83,504.60      599.55       -             599.55    182.03      417.52    83,322.58    56,467.74
123       4/6/2014   83,322.58      599.55       -             599.55    182.94      416.61    83,139.64    56,884.35
124       5/6/2014   83,139.64      599.55       -             599.55    183.85      415.70    82,955.79    57,300.05
125       6/6/2014   82,955.79      599.55       -             599.55    184.77      414.78    82,771.01    57,714.83
126       7/6/2014   82,771.01      599.55       -             599.55    185.70      413.86    82,585.32    58,128.68
127       8/6/2014   82,585.32      599.55       -             599.55    186.62      412.93    82,398.69    58,541.61
128       9/6/2014   82,398.69      599.55       -             599.55    187.56      411.99    82,211.14    58,953.60
129      10/6/2014   82,211.14      599.55       -             599.55    188.49      411.06    82,022.64    59,364.66
130      11/6/2014   82,022.64      599.55       -             599.55    189.44      410.11    81,833.21    59,774.77
131      12/6/2014   81,833.21      599.55       -             599.55    190.38      409.17    81,642.82    60,183.94
132       1/6/2015   81,642.82      599.55       -             599.55    191.34      408.21    81,451.48    60,592.15
133       2/6/2015   81,451.48      599.55       -             599.55    192.29      407.26    81,259.19    60,999.41
134       3/6/2015   81,259.19      599.55       -             599.55    193.25      406.30    81,065.94    61,405.71
135       4/6/2015   81,065.94      599.55       -             599.55    194.22      405.33    80,871.72    61,811.04
136       5/6/2015   80,871.72      599.55       -             599.55    195.19      404.36    80,676.52    62,215.40
137       6/6/2015   80,676.52      599.55       -             599.55    196.17      403.38    80,480.36    62,618.78
138       7/6/2015   80,480.36      599.55       -             599.55    197.15      402.40    80,283.21    63,021.18
139       8/6/2015   80,283.21      599.55       -             599.55    198.13      401.42    80,085.07    63,422.60
140       9/6/2015   80,085.07      599.55       -             599.55    199.13      400.43    79,885.95    63,823.02
141      10/6/2015   79,885.95      599.55       -             599.55    200.12      399.43    79,685.83    64,222.45
142      11/6/2015   79,685.83      599.55       -             599.55    201.12      398.43    79,484.71    64,620.88
Pmt                  Beginning   Scheduled      Extra                                             Ending   Cumulative
No.   Payment Date     Balance    Payment    Payment    Total Payment   Principal   Interest     Balance      Interest
143      12/6/2015   79,484.71      599.55       -             599.55    202.13      397.42    79,282.58    65,018.30
144       1/6/2016   79,282.58      599.55       -             599.55    203.14      396.41    79,079.44    65,414.72
145       2/6/2016   79,079.44      599.55       -             599.55    204.15      395.40    78,875.29    65,810.11
146       3/6/2016   78,875.29      599.55       -             599.55    205.17      394.38    78,670.11    66,204.49
147       4/6/2016   78,670.11      599.55       -             599.55    206.20      393.35    78,463.91    66,597.84
148       5/6/2016   78,463.91      599.55       -             599.55    207.23      392.32    78,256.68    66,990.16
149       6/6/2016   78,256.68      599.55       -             599.55    208.27      391.28    78,048.42    67,381.44
150       7/6/2016   78,048.42      599.55       -             599.55    209.31      390.24    77,839.11    67,771.69
151       8/6/2016   77,839.11      599.55       -             599.55    210.35      389.20    77,628.75    68,160.88
152       9/6/2016   77,628.75      599.55       -             599.55    211.41      388.14    77,417.35    68,549.03