Docstoc

mortgage calculator (Excel)

Document Sample
mortgage calculator (Excel) Powered By Docstoc
					Home Mortgage Calculator                                                             &       Amortization Schedule
                   Mortgage Information                                                  Balance at a Specified Year
                                 Loan Amount          9,000,000.00                                Balance at Year …               3
                         Annual Interest Rate                5.00%                                              Date          6/8/2014
                       Term Length (in Years)             30                                            Interest Paid        1,320,225.54
                          First Payment Date          7/8/2011                                         Principal Paid          419,076.66
                            Compound Period            Monthly                                 Outstanding Balance           8,580,923.34
                          Payment Frequency            Monthly
                            Monthly Payment         $    48,313.95 .

                          Home Value or Price       $        650,000
                    Est. Yearly Property Taxes      $            -
                    Est. Yearly H.O. Insurance      $            -
                                  Monthly PMI       $            -
                                 PITI Payment       $      48,313.95

[42]               Extra Payments
                                 Extra Payment      $             -
                              Payment Interval                       1                                   Totals Assuming No Extra Payments
                         Extra Annual Payment       $             -                                  Total Payments           $17,393,019
                           Starting Payment #                        0                                Total Interest           $8,393,019
                          Total Extra Payments                   0.00
                               Interest Savings     $             -

                   Summary
                               Total Payments           17,393,018.56                            Years Until Paid Off            30
                                Total Interest           8,393,018.56                             Last Payment Date           6/8/2041




Payment Schedule                                                                                                                                                         [42]
                      Payment                                Interest    Payment              Extra           Additional         Principal
       No.               Date       Interest Rate                Due         Due           Payments            Payment               Paid          Balance        Year
                                                                                                                                             $9,000,000.00
        1              7/8/2011            5.000%           37,500.00    48,313.95                0.00                           10,813.95     8,989,186.05
        2              8/8/2011            5.000%           37,454.94    48,313.95                0.00                           10,859.01     8,978,327.04
        3              9/8/2011            5.000%           37,409.70    48,313.95                0.00                           10,904.25     8,967,422.79
        4             10/8/2011            5.000%           37,364.26    48,313.95                0.00                           10,949.69     8,956,473.10
        5             11/8/2011            5.000%           37,318.64    48,313.95                0.00                           10,995.31     8,945,477.79
        6             12/8/2011            5.000%           37,272.82    48,313.95                0.00                           11,041.13     8,934,436.66
        7              1/8/2012            5.000%           37,226.82    48,313.95                0.00                           11,087.13     8,923,349.53
        8              2/8/2012            5.000%           37,180.62    48,313.95                0.00                           11,133.33     8,912,216.20
        9              3/8/2012            5.000%           37,134.23    48,313.95                0.00                           11,179.72     8,901,036.48
       10              4/8/2012            5.000%           37,087.65    48,313.95                0.00                           11,226.30     8,889,810.18
       11              5/8/2012            5.000%           37,040.88    48,313.95                0.00                           11,273.07     8,878,537.11
       12              6/8/2012            5.000%           36,993.90    48,313.95                0.00                           11,320.05     8,867,217.06   1
       13              7/8/2012            5.000%           36,946.74    48,313.95                0.00                           11,367.21     8,855,849.85
       14              8/8/2012            5.000%           36,899.37    48,313.95                0.00                           11,414.58     8,844,435.27
       15              9/8/2012            5.000%           36,851.81    48,313.95                0.00                           11,462.14     8,832,973.13
       16             10/8/2012            5.000%           36,804.05    48,313.95                0.00                           11,509.90     8,821,463.23
       17             11/8/2012            5.000%           36,756.10    48,313.95                0.00                           11,557.85     8,809,905.38
       18             12/8/2012            5.000%           36,707.94    48,313.95                0.00                           11,606.01     8,798,299.37
       19              1/8/2013            5.000%           36,659.58    48,313.95                0.00                           11,654.37     8,786,645.00
       20              2/8/2013            5.000%           36,611.02    48,313.95                0.00                           11,702.93     8,774,942.07
       21              3/8/2013            5.000%           36,562.26    48,313.95                0.00                           11,751.69     8,763,190.38
       22              4/8/2013            5.000%           36,513.29    48,313.95                0.00                           11,800.66     8,751,389.72
       23              5/8/2013            5.000%           36,464.12    48,313.95                0.00                           11,849.83     8,739,539.89
       24              6/8/2013            5.000%           36,414.75    48,313.95                0.00                           11,899.20     8,727,640.69   2
       25              7/8/2013            5.000%           36,365.17    48,313.95                0.00                           11,948.78     8,715,691.91
       26              8/8/2013            5.000%           36,315.38    48,313.95                0.00                           11,998.57     8,703,693.34
       27              9/8/2013            5.000%           36,265.39    48,313.95                0.00                           12,048.56     8,691,644.78
       28             10/8/2013            5.000%           36,215.19    48,313.95                0.00                           12,098.76     8,679,546.02
       29             11/8/2013            5.000%           36,164.78    48,313.95                0.00                           12,149.17     8,667,396.85
       30             12/8/2013            5.000%           36,114.15    48,313.95                0.00                           12,199.80     8,655,197.05
       31              1/8/2014            5.000%           36,063.32    48,313.95                0.00                           12,250.63     8,642,946.42
       32              2/8/2014            5.000%           36,012.28    48,313.95                0.00                           12,301.67     8,630,644.75
       33              3/8/2014            5.000%           35,961.02    48,313.95                0.00                           12,352.93     8,618,291.82
       34              4/8/2014            5.000%           35,909.55    48,313.95                0.00                           12,404.40     8,605,887.42
       35              5/8/2014            5.000%           35,857.86    48,313.95                0.00                           12,456.09     8,593,431.33
       36              6/8/2014            5.000%           35,805.96    48,313.95                0.00                           12,507.99     8,580,923.34   3
       37              7/8/2014            5.000%           35,753.85    48,313.95                0.00                           12,560.10     8,568,363.24
       38              8/8/2014            5.000%           35,701.51    48,313.95                0.00                           12,612.44     8,555,750.80
       39              9/8/2014            5.000%           35,648.96    48,313.95                0.00                           12,664.99     8,543,085.81
       40             10/8/2014            5.000%           35,596.19    48,313.95                0.00                           12,717.76     8,530,368.05
       41             11/8/2014            5.000%           35,543.20    48,313.95                0.00                           12,770.75     8,517,597.30
       42             12/8/2014            5.000%           35,489.99    48,313.95                0.00                           12,823.96     8,504,773.34
       43              1/8/2015            5.000%           35,436.56    48,313.95                0.00                           12,877.39     8,491,895.95
       44              2/8/2015            5.000%           35,382.90    48,313.95                0.00                           12,931.05     8,478,964.90
       45              3/8/2015            5.000%           35,329.02    48,313.95                0.00                           12,984.93     8,465,979.97
       46              4/8/2015            5.000%           35,274.92    48,313.95                0.00                           13,039.03     8,452,940.94
       47              5/8/2015            5.000%           35,220.59    48,313.95                0.00                           13,093.36     8,439,847.58
       48              6/8/2015            5.000%           35,166.03    48,313.95                0.00                           13,147.92     8,426,699.66   4
       49              7/8/2015            5.000%           35,111.25    48,313.95                0.00                           13,202.70     8,413,496.96
       50              8/8/2015            5.000%           35,056.24    48,313.95                0.00                           13,257.71     8,400,239.25
       51              9/8/2015            5.000%           35,001.00    48,313.95                0.00                           13,312.95     8,386,926.30
       52             10/8/2015            5.000%           34,945.53    48,313.95                0.00                           13,368.42     8,373,557.88
       53             11/8/2015            5.000%           34,889.82    48,313.95                0.00                           13,424.13     8,360,133.75
       54             12/8/2015            5.000%           34,833.89    48,313.95                0.00                           13,480.06     8,346,653.69
       55              1/8/2016            5.000%           34,777.72    48,313.95                0.00                           13,536.23     8,333,117.46
       56              2/8/2016            5.000%           34,721.32    48,313.95                0.00                           13,592.63     8,319,524.83
       57              3/8/2016            5.000%           34,664.69    48,313.95                0.00                           13,649.26     8,305,875.57
       58              4/8/2016            5.000%           34,607.81    48,313.95                0.00                           13,706.14     8,292,169.43
       59              5/8/2016            5.000%           34,550.71    48,313.95                0.00                           13,763.24     8,278,406.19
       60              6/8/2016            5.000%           34,493.36    48,313.95                0.00                           13,820.59     8,264,585.60   5
       61              7/8/2016            5.000%           34,435.77    48,313.95                0.00                           13,878.18     8,250,707.42
       62              8/8/2016            5.000%           34,377.95    48,313.95                0.00                           13,936.00     8,236,771.42
       63              9/8/2016            5.000%           34,319.88    48,313.95                0.00                           13,994.07     8,222,777.35
       64             10/8/2016            5.000%           34,261.57    48,313.95                0.00                           14,052.38     8,208,724.97
       65             11/8/2016            5.000%           34,203.02    48,313.95                0.00                           14,110.93     8,194,614.04
       66             12/8/2016            5.000%           34,144.23    48,313.95                0.00                           14,169.72     8,180,444.32
       67              1/8/2017            5.000%           34,085.18    48,313.95                0.00                           14,228.77     8,166,215.55
       68              2/8/2017            5.000%           34,025.90    48,313.95                0.00                           14,288.05     8,151,927.50
       69              3/8/2017            5.000%           33,966.36    48,313.95                0.00                           14,347.59     8,137,579.91
       70              4/8/2017            5.000%           33,906.58    48,313.95                0.00                           14,407.37     8,123,172.54
       71              5/8/2017            5.000%           33,846.55    48,313.95                0.00                           14,467.40     8,108,705.14
       72              6/8/2017            5.000%           33,786.27    48,313.95                0.00                           14,527.68     8,094,177.46   6
       73              7/8/2017            5.000%           33,725.74    48,313.95                0.00                           14,588.21     8,079,589.25
       74              8/8/2017            5.000%           33,664.96    48,313.95                0.00                           14,648.99     8,064,940.26
       75              9/8/2017            5.000%           33,603.92    48,313.95                0.00                           14,710.03     8,050,230.23
       76             10/8/2017            5.000%           33,542.63    48,313.95                0.00                           14,771.32     8,035,458.91
       77             11/8/2017            5.000%           33,481.08    48,313.95                0.00                           14,832.87     8,020,626.04
       78             12/8/2017            5.000%           33,419.28    48,313.95                0.00                           14,894.67     8,005,731.37
       79              1/8/2018            5.000%           33,357.21    48,313.95                0.00                           14,956.74     7,990,774.63
       80              2/8/2018            5.000%           33,294.89    48,313.95                0.00                           15,019.06     7,975,755.57
       81              3/8/2018            5.000%           33,232.31    48,313.95                0.00                           15,081.64     7,960,673.93
       82              4/8/2018            5.000%           33,169.47    48,313.95                0.00                           15,144.48     7,945,529.45
       83              5/8/2018            5.000%           33,106.37    48,313.95                0.00                           15,207.58     7,930,321.87
       84              6/8/2018            5.000%           33,043.01    48,313.95                0.00                           15,270.94     7,915,050.93   7
       85              7/8/2018            5.000%           32,979.38    48,313.95                0.00                           15,334.57     7,899,716.36
       86              8/8/2018            5.000%           32,915.48    48,313.95                0.00                           15,398.47     7,884,317.89
       87              9/8/2018            5.000%           32,851.32    48,313.95                0.00                           15,462.63     7,868,855.26
       88             10/8/2018            5.000%           32,786.90    48,313.95                0.00                           15,527.05     7,853,328.21
       89             11/8/2018            5.000%           32,722.20    48,313.95                0.00                           15,591.75     7,837,736.46
       90             12/8/2018            5.000%           32,657.24    48,313.95                0.00                           15,656.71     7,822,079.75
       91              1/8/2019            5.000%           32,592.00    48,313.95                0.00                           15,721.95     7,806,357.80
       92              2/8/2019            5.000%           32,526.49    48,313.95                0.00                           15,787.46     7,790,570.34
       93              3/8/2019            5.000%           32,460.71    48,313.95                0.00                           15,853.24     7,774,717.10
       94              4/8/2019            5.000%           32,394.65    48,313.95                0.00                           15,919.30     7,758,797.80
       95              5/8/2019            5.000%           32,328.32    48,313.95                0.00                           15,985.63     7,742,812.17
       96              6/8/2019            5.000%           32,261.72    48,313.95                0.00                           16,052.23     7,726,759.94   8
       97              7/8/2019            5.000%           32,194.83    48,313.95                0.00                           16,119.12     7,710,640.82
       98              8/8/2019            5.000%           32,127.67    48,313.95                0.00                           16,186.28     7,694,454.54
      Payment                      Interest   Payment        Extra   Additional   Principal
No.       Date    Interest Rate        Due         Due    Payments    Payment          Paid       Balance         Year
99     9/8/2019         5.000%    32,060.23   48,313.95       0.00                16,253.72   7,678,200.82
100   10/8/2019         5.000%    31,992.50   48,313.95       0.00                16,321.45   7,661,879.37
101   11/8/2019         5.000%    31,924.50   48,313.95       0.00                16,389.45   7,645,489.92
102   12/8/2019         5.000%    31,856.21   48,313.95       0.00                16,457.74   7,629,032.18
103    1/8/2020         5.000%    31,787.63   48,313.95       0.00                16,526.32   7,612,505.86
104    2/8/2020         5.000%    31,718.77   48,313.95       0.00                16,595.18   7,595,910.68
105    3/8/2020         5.000%    31,649.63   48,313.95       0.00                16,664.32   7,579,246.36
106    4/8/2020         5.000%    31,580.19   48,313.95       0.00                16,733.76   7,562,512.60
107    5/8/2020         5.000%    31,510.47   48,313.95       0.00                16,803.48   7,545,709.12
108    6/8/2020         5.000%    31,440.45   48,313.95       0.00                16,873.50   7,528,835.62   9
109    7/8/2020         5.000%    31,370.15   48,313.95       0.00                16,943.80   7,511,891.82
110    8/8/2020         5.000%    31,299.55   48,313.95       0.00                17,014.40   7,494,877.42
111    9/8/2020         5.000%    31,228.66   48,313.95       0.00                17,085.29   7,477,792.13
112   10/8/2020         5.000%    31,157.47   48,313.95       0.00                17,156.48   7,460,635.65
113   11/8/2020         5.000%    31,085.98   48,313.95       0.00                17,227.97   7,443,407.68
114   12/8/2020         5.000%    31,014.20   48,313.95       0.00                17,299.75   7,426,107.93
115    1/8/2021         5.000%    30,942.12   48,313.95       0.00                17,371.83   7,408,736.10
116    2/8/2021         5.000%    30,869.73   48,313.95       0.00                17,444.22   7,391,291.88
117    3/8/2021         5.000%    30,797.05   48,313.95       0.00                17,516.90   7,373,774.98
118    4/8/2021         5.000%    30,724.06   48,313.95       0.00                17,589.89   7,356,185.09
119    5/8/2021         5.000%    30,650.77   48,313.95       0.00                17,663.18   7,338,521.91
120    6/8/2021         5.000%    30,577.17   48,313.95       0.00                17,736.78   7,320,785.13   10
121    7/8/2021         5.000%    30,503.27   48,313.95       0.00                17,810.68   7,302,974.45
122    8/8/2021         5.000%    30,429.06   48,313.95       0.00                17,884.89   7,285,089.56
123    9/8/2021         5.000%    30,354.54   48,313.95       0.00                17,959.41   7,267,130.15
124   10/8/2021         5.000%    30,279.71   48,313.95       0.00                18,034.24   7,249,095.91
125   11/8/2021         5.000%    30,204.57   48,313.95       0.00                18,109.38   7,230,986.53
126   12/8/2021         5.000%    30,129.11   48,313.95       0.00                18,184.84   7,212,801.69
127    1/8/2022         5.000%    30,053.34   48,313.95       0.00                18,260.61   7,194,541.08
128    2/8/2022         5.000%    29,977.25   48,313.95       0.00                18,336.70   7,176,204.38
129    3/8/2022         5.000%    29,900.85   48,313.95       0.00                18,413.10   7,157,791.28
130    4/8/2022         5.000%    29,824.13   48,313.95       0.00                18,489.82   7,139,301.46
131    5/8/2022         5.000%    29,747.09   48,313.95       0.00                18,566.86   7,120,734.60
132    6/8/2022         5.000%    29,669.73   48,313.95       0.00                18,644.22   7,102,090.38   11
133    7/8/2022         5.000%    29,592.04   48,313.95       0.00                18,721.91   7,083,368.47
134    8/8/2022         5.000%    29,514.04   48,313.95       0.00                18,799.91   7,064,568.56
135    9/8/2022         5.000%    29,435.70   48,313.95       0.00                18,878.25   7,045,690.31
136   10/8/2022         5.000%    29,357.04   48,313.95       0.00                18,956.91   7,026,733.40
137   11/8/2022         5.000%    29,278.06   48,313.95       0.00                19,035.89   7,007,697.51
138   12/8/2022         5.000%    29,198.74   48,313.95       0.00                19,115.21   6,988,582.30
139    1/8/2023         5.000%    29,119.09   48,313.95       0.00                19,194.86   6,969,387.44
140    2/8/2023         5.000%    29,039.11   48,313.95       0.00                19,274.84   6,950,112.60
141    3/8/2023         5.000%    28,958.80   48,313.95       0.00                19,355.15   6,930,757.45
142    4/8/2023         5.000%    28,878.16   48,313.95       0.00                19,435.79   6,911,321.66
143    5/8/2023         5.000%    28,797.17   48,313.95       0.00                19,516.78   6,891,804.88
144    6/8/2023         5.000%    28,715.85   48,313.95       0.00                19,598.10   6,872,206.78   12
145    7/8/2023         5.000%    28,634.19   48,313.95       0.00                19,679.76   6,852,527.02
146    8/8/2023         5.000%    28,552.20   48,313.95       0.00                19,761.75   6,832,765.27
147    9/8/2023         5.000%    28,469.86   48,313.95       0.00                19,844.09   6,812,921.18
148   10/8/2023         5.000%    28,387.17   48,313.95       0.00                19,926.78   6,792,994.40
149   11/8/2023         5.000%    28,304.14   48,313.95       0.00                20,009.81   6,772,984.59
150   12/8/2023         5.000%    28,220.77   48,313.95       0.00                20,093.18   6,752,891.41
151    1/8/2024         5.000%    28,137.05   48,313.95       0.00                20,176.90   6,732,714.51
152    2/8/2024         5.000%    28,052.98   48,313.95       0.00                20,260.97   6,712,453.54
153    3/8/2024         5.000%    27,968.56   48,313.95       0.00                20,345.39   6,692,108.15
154    4/8/2024         5.000%    27,883.78   48,313.95       0.00                20,430.17   6,671,677.98
155    5/8/2024         5.000%    27,798.66   48,313.95       0.00                20,515.29   6,651,162.69
156    6/8/2024         5.000%    27,713.18   48,313.95       0.00                20,600.77   6,630,561.92   13
157    7/8/2024         5.000%    27,627.34   48,313.95       0.00                20,686.61   6,609,875.31
158    8/8/2024         5.000%    27,541.15   48,313.95       0.00                20,772.80   6,589,102.51
159    9/8/2024         5.000%    27,454.59   48,313.95       0.00                20,859.36   6,568,243.15
160   10/8/2024         5.000%    27,367.68   48,313.95       0.00                20,946.27   6,547,296.88
161   11/8/2024         5.000%    27,280.40   48,313.95       0.00                21,033.55   6,526,263.33
162   12/8/2024         5.000%    27,192.76   48,313.95       0.00                21,121.19   6,505,142.14
163    1/8/2025         5.000%    27,104.76   48,313.95       0.00                21,209.19   6,483,932.95
164    2/8/2025         5.000%    27,016.39   48,313.95       0.00                21,297.56   6,462,635.39
165    3/8/2025         5.000%    26,927.65   48,313.95       0.00                21,386.30   6,441,249.09
166    4/8/2025         5.000%    26,838.54   48,313.95       0.00                21,475.41   6,419,773.68
167    5/8/2025         5.000%    26,749.06   48,313.95       0.00                21,564.89   6,398,208.79
168    6/8/2025         5.000%    26,659.20   48,313.95       0.00                21,654.75   6,376,554.04   14
169    7/8/2025         5.000%    26,568.98   48,313.95       0.00                21,744.97   6,354,809.07
170    8/8/2025         5.000%    26,478.37   48,313.95       0.00                21,835.58   6,332,973.49
171    9/8/2025         5.000%    26,387.39   48,313.95       0.00                21,926.56   6,311,046.93
172   10/8/2025         5.000%    26,296.03   48,313.95       0.00                22,017.92   6,289,029.01
173   11/8/2025         5.000%    26,204.29   48,313.95       0.00                22,109.66   6,266,919.35
174   12/8/2025         5.000%    26,112.16   48,313.95       0.00                22,201.79   6,244,717.56
175    1/8/2026         5.000%    26,019.66   48,313.95       0.00                22,294.29   6,222,423.27
176    2/8/2026         5.000%    25,926.76   48,313.95       0.00                22,387.19   6,200,036.08
177    3/8/2026         5.000%    25,833.48   48,313.95       0.00                22,480.47   6,177,555.61
178    4/8/2026         5.000%    25,739.82   48,313.95       0.00                22,574.13   6,154,981.48
179    5/8/2026         5.000%    25,645.76   48,313.95       0.00                22,668.19   6,132,313.29
180    6/8/2026         5.000%    25,551.31   48,313.95       0.00                22,762.64   6,109,550.65   15
181    7/8/2026         5.000%    25,456.46   48,313.95       0.00                22,857.49   6,086,693.16
182    8/8/2026         5.000%    25,361.22   48,313.95       0.00                22,952.73   6,063,740.43
183    9/8/2026         5.000%    25,265.59   48,313.95       0.00                23,048.36   6,040,692.07
184   10/8/2026         5.000%    25,169.55   48,313.95       0.00                23,144.40   6,017,547.67
185   11/8/2026         5.000%    25,073.12   48,313.95       0.00                23,240.83   5,994,306.84
186   12/8/2026         5.000%    24,976.28   48,313.95       0.00                23,337.67   5,970,969.17
187    1/8/2027         5.000%    24,879.04   48,313.95       0.00                23,434.91   5,947,534.26
188    2/8/2027         5.000%    24,781.39   48,313.95       0.00                23,532.56   5,924,001.70
189    3/8/2027         5.000%    24,683.34   48,313.95       0.00                23,630.61   5,900,371.09
190    4/8/2027         5.000%    24,584.88   48,313.95       0.00                23,729.07   5,876,642.02
191    5/8/2027         5.000%    24,486.01   48,313.95       0.00                23,827.94   5,852,814.08
192    6/8/2027         5.000%    24,386.73   48,313.95       0.00                23,927.22   5,828,886.86   16
193    7/8/2027         5.000%    24,287.03   48,313.95       0.00                24,026.92   5,804,859.94
194    8/8/2027         5.000%    24,186.92   48,313.95       0.00                24,127.03   5,780,732.91
195    9/8/2027         5.000%    24,086.39   48,313.95       0.00                24,227.56   5,756,505.35
196   10/8/2027         5.000%    23,985.44   48,313.95       0.00                24,328.51   5,732,176.84
197   11/8/2027         5.000%    23,884.07   48,313.95       0.00                24,429.88   5,707,746.96
198   12/8/2027         5.000%    23,782.28   48,313.95       0.00                24,531.67   5,683,215.29
199    1/8/2028         5.000%    23,680.06   48,313.95       0.00                24,633.89   5,658,581.40
200    2/8/2028         5.000%    23,577.42   48,313.95       0.00                24,736.53   5,633,844.87
201    3/8/2028         5.000%    23,474.35   48,313.95       0.00                24,839.60   5,609,005.27
202    4/8/2028         5.000%    23,370.86   48,313.95       0.00                24,943.09   5,584,062.18
203    5/8/2028         5.000%    23,266.93   48,313.95       0.00                25,047.02   5,559,015.16
204    6/8/2028         5.000%    23,162.56   48,313.95       0.00                25,151.39   5,533,863.77   17
205    7/8/2028         5.000%    23,057.77   48,313.95       0.00                25,256.18   5,508,607.59
206    8/8/2028         5.000%    22,952.53   48,313.95       0.00                25,361.42   5,483,246.17
207    9/8/2028         5.000%    22,846.86   48,313.95       0.00                25,467.09   5,457,779.08
208   10/8/2028         5.000%    22,740.75   48,313.95       0.00                25,573.20   5,432,205.88
209   11/8/2028         5.000%    22,634.19   48,313.95       0.00                25,679.76   5,406,526.12
210   12/8/2028         5.000%    22,527.19   48,313.95       0.00                25,786.76   5,380,739.36
211    1/8/2029         5.000%    22,419.75   48,313.95       0.00                25,894.20   5,354,845.16
212    2/8/2029         5.000%    22,311.85   48,313.95       0.00                26,002.10   5,328,843.06
213    3/8/2029         5.000%    22,203.51   48,313.95       0.00                26,110.44   5,302,732.62
214    4/8/2029         5.000%    22,094.72   48,313.95       0.00                26,219.23   5,276,513.39
215    5/8/2029         5.000%    21,985.47   48,313.95       0.00                26,328.48   5,250,184.91
216    6/8/2029         5.000%    21,875.77   48,313.95       0.00                26,438.18   5,223,746.73   18
217    7/8/2029         5.000%    21,765.61   48,313.95       0.00                26,548.34   5,197,198.39
218    8/8/2029         5.000%    21,654.99   48,313.95       0.00                26,658.96   5,170,539.43
219    9/8/2029         5.000%    21,543.91   48,313.95       0.00                26,770.04   5,143,769.39
220   10/8/2029         5.000%    21,432.37   48,313.95       0.00                26,881.58   5,116,887.81
221   11/8/2029         5.000%    21,320.37   48,313.95       0.00                26,993.58   5,089,894.23
222   12/8/2029         5.000%    21,207.89   48,313.95       0.00                27,106.06   5,062,788.17
223    1/8/2030         5.000%    21,094.95   48,313.95       0.00                27,219.00   5,035,569.17
224    2/8/2030         5.000%    20,981.54   48,313.95       0.00                27,332.41   5,008,236.76
225    3/8/2030         5.000%    20,867.65   48,313.95       0.00                27,446.30   4,980,790.46
226    4/8/2030         5.000%    20,753.29   48,313.95       0.00                27,560.66   4,953,229.80
227    5/8/2030         5.000%    20,638.46   48,313.95       0.00                27,675.49   4,925,554.31
228    6/8/2030         5.000%    20,523.14   48,313.95       0.00                27,790.81   4,897,763.50   19
      Payment                      Interest   Payment        Extra   Additional   Principal
No.       Date    Interest Rate        Due         Due    Payments    Payment          Paid       Balance         Year
229    7/8/2030         5.000%    20,407.35   48,313.95       0.00                27,906.60   4,869,856.90
230    8/8/2030         5.000%    20,291.07   48,313.95       0.00                28,022.88   4,841,834.02
231    9/8/2030         5.000%    20,174.31   48,313.95       0.00                28,139.64   4,813,694.38
232   10/8/2030         5.000%    20,057.06   48,313.95       0.00                28,256.89   4,785,437.49
233   11/8/2030         5.000%    19,939.32   48,313.95       0.00                28,374.63   4,757,062.86
234   12/8/2030         5.000%    19,821.10   48,313.95       0.00                28,492.85   4,728,570.01
235    1/8/2031         5.000%    19,702.38   48,313.95       0.00                28,611.57   4,699,958.44
236    2/8/2031         5.000%    19,583.16   48,313.95       0.00                28,730.79   4,671,227.65
237    3/8/2031         5.000%    19,463.45   48,313.95       0.00                28,850.50   4,642,377.15
238    4/8/2031         5.000%    19,343.24   48,313.95       0.00                28,970.71   4,613,406.44
239    5/8/2031         5.000%    19,222.53   48,313.95       0.00                29,091.42   4,584,315.02
240    6/8/2031         5.000%    19,101.31   48,313.95       0.00                29,212.64   4,555,102.38   20
241    7/8/2031         5.000%    18,979.59   48,313.95       0.00                29,334.36   4,525,768.02
242    8/8/2031         5.000%    18,857.37   48,313.95       0.00                29,456.58   4,496,311.44
243    9/8/2031         5.000%    18,734.63   48,313.95       0.00                29,579.32   4,466,732.12
244   10/8/2031         5.000%    18,611.38   48,313.95       0.00                29,702.57   4,437,029.55
245   11/8/2031         5.000%    18,487.62   48,313.95       0.00                29,826.33   4,407,203.22
246   12/8/2031         5.000%    18,363.35   48,313.95       0.00                29,950.60   4,377,252.62
247    1/8/2032         5.000%    18,238.55   48,313.95       0.00                30,075.40   4,347,177.22
248    2/8/2032         5.000%    18,113.24   48,313.95       0.00                30,200.71   4,316,976.51
249    3/8/2032         5.000%    17,987.40   48,313.95       0.00                30,326.55   4,286,649.96
250    4/8/2032         5.000%    17,861.04   48,313.95       0.00                30,452.91   4,256,197.05
251    5/8/2032         5.000%    17,734.15   48,313.95       0.00                30,579.80   4,225,617.25
252    6/8/2032         5.000%    17,606.74   48,313.95       0.00                30,707.21   4,194,910.04   21
253    7/8/2032         5.000%    17,478.79   48,313.95       0.00                30,835.16   4,164,074.88
254    8/8/2032         5.000%    17,350.31   48,313.95       0.00                30,963.64   4,133,111.24
255    9/8/2032         5.000%    17,221.30   48,313.95       0.00                31,092.65   4,102,018.59
256   10/8/2032         5.000%    17,091.74   48,313.95       0.00                31,222.21   4,070,796.38
257   11/8/2032         5.000%    16,961.65   48,313.95       0.00                31,352.30   4,039,444.08
258   12/8/2032         5.000%    16,831.02   48,313.95       0.00                31,482.93   4,007,961.15
259    1/8/2033         5.000%    16,699.84   48,313.95       0.00                31,614.11   3,976,347.04
260    2/8/2033         5.000%    16,568.11   48,313.95       0.00                31,745.84   3,944,601.20
261    3/8/2033         5.000%    16,435.84   48,313.95       0.00                31,878.11   3,912,723.09
262    4/8/2033         5.000%    16,303.01   48,313.95       0.00                32,010.94   3,880,712.15
263    5/8/2033         5.000%    16,169.63   48,313.95       0.00                32,144.32   3,848,567.83
264    6/8/2033         5.000%    16,035.70   48,313.95       0.00                32,278.25   3,816,289.58   22
265    7/8/2033         5.000%    15,901.21   48,313.95       0.00                32,412.74   3,783,876.84
266    8/8/2033         5.000%    15,766.15   48,313.95       0.00                32,547.80   3,751,329.04
267    9/8/2033         5.000%    15,630.54   48,313.95       0.00                32,683.41   3,718,645.63
268   10/8/2033         5.000%    15,494.36   48,313.95       0.00                32,819.59   3,685,826.04
269   11/8/2033         5.000%    15,357.61   48,313.95       0.00                32,956.34   3,652,869.70
270   12/8/2033         5.000%    15,220.29   48,313.95       0.00                33,093.66   3,619,776.04
271    1/8/2034         5.000%    15,082.40   48,313.95       0.00                33,231.55   3,586,544.49
272    2/8/2034         5.000%    14,943.94   48,313.95       0.00                33,370.01   3,553,174.48
273    3/8/2034         5.000%    14,804.89   48,313.95       0.00                33,509.06   3,519,665.42
274    4/8/2034         5.000%    14,665.27   48,313.95       0.00                33,648.68   3,486,016.74
275    5/8/2034         5.000%    14,525.07   48,313.95       0.00                33,788.88   3,452,227.86
276    6/8/2034         5.000%    14,384.28   48,313.95       0.00                33,929.67   3,418,298.19   23
277    7/8/2034         5.000%    14,242.91   48,313.95       0.00                34,071.04   3,384,227.15
278    8/8/2034         5.000%    14,100.95   48,313.95       0.00                34,213.00   3,350,014.15
279    9/8/2034         5.000%    13,958.39   48,313.95       0.00                34,355.56   3,315,658.59
280   10/8/2034         5.000%    13,815.24   48,313.95       0.00                34,498.71   3,281,159.88
281   11/8/2034         5.000%    13,671.50   48,313.95       0.00                34,642.45   3,246,517.43
282   12/8/2034         5.000%    13,527.16   48,313.95       0.00                34,786.79   3,211,730.64
283    1/8/2035         5.000%    13,382.21   48,313.95       0.00                34,931.74   3,176,798.90
284    2/8/2035         5.000%    13,236.66   48,313.95       0.00                35,077.29   3,141,721.61
285    3/8/2035         5.000%    13,090.51   48,313.95       0.00                35,223.44   3,106,498.17
286    4/8/2035         5.000%    12,943.74   48,313.95       0.00                35,370.21   3,071,127.96
287    5/8/2035         5.000%    12,796.37   48,313.95       0.00                35,517.58   3,035,610.38
288    6/8/2035         5.000%    12,648.38   48,313.95       0.00                35,665.57   2,999,944.81   24
289    7/8/2035         5.000%    12,499.77   48,313.95       0.00                35,814.18   2,964,130.63
290    8/8/2035         5.000%    12,350.54   48,313.95       0.00                35,963.41   2,928,167.22
291    9/8/2035         5.000%    12,200.70   48,313.95       0.00                36,113.25   2,892,053.97
292   10/8/2035         5.000%    12,050.22   48,313.95       0.00                36,263.73   2,855,790.24
293   11/8/2035         5.000%    11,899.13   48,313.95       0.00                36,414.82   2,819,375.42
294   12/8/2035         5.000%    11,747.40   48,313.95       0.00                36,566.55   2,782,808.87
295    1/8/2036         5.000%    11,595.04   48,313.95       0.00                36,718.91   2,746,089.96
296    2/8/2036         5.000%    11,442.04   48,313.95       0.00                36,871.91   2,709,218.05
297    3/8/2036         5.000%    11,288.41   48,313.95       0.00                37,025.54   2,672,192.51
298    4/8/2036         5.000%    11,134.14   48,313.95       0.00                37,179.81   2,635,012.70
299    5/8/2036         5.000%    10,979.22   48,313.95       0.00                37,334.73   2,597,677.97
300    6/8/2036         5.000%    10,823.66   48,313.95       0.00                37,490.29   2,560,187.68   25
301    7/8/2036         5.000%    10,667.45   48,313.95       0.00                37,646.50   2,522,541.18
302    8/8/2036         5.000%    10,510.59   48,313.95       0.00                37,803.36   2,484,737.82
303    9/8/2036         5.000%    10,353.07   48,313.95       0.00                37,960.88   2,446,776.94
304   10/8/2036         5.000%    10,194.90   48,313.95       0.00                38,119.05   2,408,657.89
305   11/8/2036         5.000%    10,036.07   48,313.95       0.00                38,277.88   2,370,380.01
306   12/8/2036         5.000%     9,876.58   48,313.95       0.00                38,437.37   2,331,942.64
307    1/8/2037         5.000%     9,716.43   48,313.95       0.00                38,597.52   2,293,345.12
308    2/8/2037         5.000%     9,555.60   48,313.95       0.00                38,758.35   2,254,586.77
309    3/8/2037         5.000%     9,394.11   48,313.95       0.00                38,919.84   2,215,666.93
310    4/8/2037         5.000%     9,231.95   48,313.95       0.00                39,082.00   2,176,584.93
311    5/8/2037         5.000%     9,069.10   48,313.95       0.00                39,244.85   2,137,340.08
312    6/8/2037         5.000%     8,905.58   48,313.95       0.00                39,408.37   2,097,931.71   26
313    7/8/2037         5.000%     8,741.38   48,313.95       0.00                39,572.57   2,058,359.14
314    8/8/2037         5.000%     8,576.50   48,313.95       0.00                39,737.45   2,018,621.69
315    9/8/2037         5.000%     8,410.92   48,313.95       0.00                39,903.03   1,978,718.66
316   10/8/2037         5.000%     8,244.66   48,313.95       0.00                40,069.29   1,938,649.37
317   11/8/2037         5.000%     8,077.71   48,313.95       0.00                40,236.24   1,898,413.13
318   12/8/2037         5.000%     7,910.05   48,313.95       0.00                40,403.90   1,858,009.23
319    1/8/2038         5.000%     7,741.71   48,313.95       0.00                40,572.24   1,817,436.99
320    2/8/2038         5.000%     7,572.65   48,313.95       0.00                40,741.30   1,776,695.69
321    3/8/2038         5.000%     7,402.90   48,313.95       0.00                40,911.05   1,735,784.64
322    4/8/2038         5.000%     7,232.44   48,313.95       0.00                41,081.51   1,694,703.13
323    5/8/2038         5.000%     7,061.26   48,313.95       0.00                41,252.69   1,653,450.44
324    6/8/2038         5.000%     6,889.38   48,313.95       0.00                41,424.57   1,612,025.87   27
325    7/8/2038         5.000%     6,716.77   48,313.95       0.00                41,597.18   1,570,428.69
326    8/8/2038         5.000%     6,543.45   48,313.95       0.00                41,770.50   1,528,658.19
327    9/8/2038         5.000%     6,369.41   48,313.95       0.00                41,944.54   1,486,713.65
328   10/8/2038         5.000%     6,194.64   48,313.95       0.00                42,119.31   1,444,594.34
329   11/8/2038         5.000%     6,019.14   48,313.95       0.00                42,294.81   1,402,299.53
330   12/8/2038         5.000%     5,842.91   48,313.95       0.00                42,471.04   1,359,828.49
331    1/8/2039         5.000%     5,665.95   48,313.95       0.00                42,648.00   1,317,180.49
332    2/8/2039         5.000%     5,488.25   48,313.95       0.00                42,825.70   1,274,354.79
333    3/8/2039         5.000%     5,309.81   48,313.95       0.00                43,004.14   1,231,350.65
334    4/8/2039         5.000%     5,130.63   48,313.95       0.00                43,183.32   1,188,167.33
335    5/8/2039         5.000%     4,950.70   48,313.95       0.00                43,363.25   1,144,804.08
336    6/8/2039         5.000%     4,770.02   48,313.95       0.00                43,543.93   1,101,260.15   28
337    7/8/2039         5.000%     4,588.58   48,313.95       0.00                43,725.37   1,057,534.78
338    8/8/2039         5.000%     4,406.39   48,313.95       0.00                43,907.56   1,013,627.22
339    9/8/2039         5.000%     4,223.45   48,313.95       0.00                44,090.50     969,536.72
340   10/8/2039         5.000%     4,039.74   48,313.95       0.00                44,274.21     925,262.51
341   11/8/2039         5.000%     3,855.26   48,313.95       0.00                44,458.69     880,803.82
342   12/8/2039         5.000%     3,670.02   48,313.95       0.00                44,643.93     836,159.89
343    1/8/2040         5.000%     3,484.00   48,313.95       0.00                44,829.95     791,329.94
344    2/8/2040         5.000%     3,297.21   48,313.95       0.00                45,016.74     746,313.20
345    3/8/2040         5.000%     3,109.64   48,313.95       0.00                45,204.31     701,108.89
346    4/8/2040         5.000%     2,921.29   48,313.95       0.00                45,392.66     655,716.23
347    5/8/2040         5.000%     2,732.15   48,313.95       0.00                45,581.80     610,134.43
348    6/8/2040         5.000%     2,542.23   48,313.95       0.00                45,771.72     564,362.71   29
349    7/8/2040         5.000%     2,351.51   48,313.95       0.00                45,962.44     518,400.27
350    8/8/2040         5.000%     2,160.00   48,313.95       0.00                46,153.95     472,246.32
351    9/8/2040         5.000%     1,967.69   48,313.95       0.00                46,346.26     425,900.06
352   10/8/2040         5.000%     1,774.58   48,313.95       0.00                46,539.37     379,360.69
353   11/8/2040         5.000%     1,580.67   48,313.95       0.00                46,733.28     332,627.41
354   12/8/2040         5.000%     1,385.95   48,313.95       0.00                46,928.00     285,699.41
355    1/8/2041         5.000%     1,190.41   48,313.95       0.00                47,123.54     238,575.87
356    2/8/2041         5.000%       994.07   48,313.95       0.00                47,319.88     191,255.99
357    3/8/2041         5.000%       796.90   48,313.95       0.00                47,517.05     143,738.94
358    4/8/2041         5.000%       598.91   48,313.95       0.00                47,715.04      96,023.90
      Payment                     Interest   Payment        Extra   Additional   Principal
No.       Date    Interest Rate       Due         Due    Payments    Payment          Paid    Balance         Year
359    5/8/2041         5.000%      400.10   48,313.95       0.00                47,913.85   48,110.05
360    6/8/2041         5.000%      200.46   48,310.51       0.00                48,110.05        0.00   30
      Payment                   Interest   Payment      Extra   Additional   Principal
No.      Date   Interest Rate       Due        Due   Payments    Payment         Paid    Balance   Year
      Payment                   Interest   Payment      Extra   Additional   Principal
No.      Date   Interest Rate       Due        Due   Payments    Payment         Paid    Balance   Year
      Payment                   Interest   Payment      Extra   Additional   Principal
No.      Date   Interest Rate       Due        Due   Payments    Payment         Paid    Balance   Year
      Payment                   Interest   Payment      Extra   Additional   Principal
No.      Date   Interest Rate       Due        Due   Payments    Payment         Paid    Balance   Year
      Payment                   Interest   Payment      Extra   Additional   Principal
No.      Date   Interest Rate       Due        Due   Payments    Payment         Paid    Balance   Year
      Payment                   Interest   Payment      Extra   Additional   Principal
No.      Date   Interest Rate       Due        Due   Payments    Payment         Paid    Balance   Year
      Payment                   Interest   Payment      Extra   Additional   Principal
No.      Date   Interest Rate       Due        Due   Payments    Payment         Paid    Balance   Year
      Payment                   Interest   Payment      Extra   Additional   Principal
No.      Date   Interest Rate       Due        Due   Payments    Payment         Paid    Balance   Year
             Payment                   Interest   Payment      Extra   Additional   Principal
       No.      Date   Interest Rate       Due        Due   Payments    Payment         Paid    Balance   Year




[42]

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:7
posted:5/18/2012
language:English
pages:13
fanzhongqing fanzhongqing http://
About