Amortization Tables

Document Sample
Amortization Tables Powered By Docstoc
					                                      Initialization Information
              LOAN DATA                                                        TABLE DATA
                  Loan amount: >         $250,000
            Annual interest rate: >         7.15%                                Table starts at date: >          1/1/2002
                 Term in years: >               30                               or payment number: >                 1
             Payments per year: >               12
             First payment due: >         1/1/2002

                                           Periodic Payment
              Entered payment: >             $0.00       Table uses the calculated periodic payment amount
            Calculated payment: >        $1,688.52       unless you enter a value for "Entered payment".

                                               Calculations
                 Use payment of: >     $1,688.52              Beginning balance at payment 1: >                       $250,000
            1st payment in table: >        1             Cumulative interest prior to payment 1: >                          $0
                                                    Table
    Based on payment of >              $1,688.52                      For 30 Years
             Payment                  Beginning                                   Ending                      Cumulative
    No.        Date                    Balance         Interest         Principal Balance                      Interest
     1            01/01/02             250,000.00      1,489.58             198.93          249,801.07            1,489.58
     2            02/01/02             249,801.07      1,488.40             200.12          249,600.95            2,977.98
     3            03/01/02             249,600.95      1,487.21             201.31          249,399.64            4,465.19
     4            04/01/02             249,399.64      1,486.01             202.51          249,197.13            5,951.19
     5            05/01/02             249,197.13      1,484.80             203.72          248,993.41            7,435.99
     6            06/01/02             248,993.41      1,483.59             204.93          248,788.48            8,919.58
     7            07/01/02             248,788.48      1,482.36             206.15          248,582.32           10,401.94
     8            08/01/02             248,582.32      1,481.14             207.38          248,374.94           11,883.08
     9            09/01/02             248,374.94      1,479.90             208.62          248,166.33           13,362.98
     10           10/01/02             248,166.33      1,478.66             209.86          247,956.47           14,841.64
     11           11/01/02             247,956.47      1,477.41             211.11          247,745.36           16,319.05
     12           12/01/02             247,745.36      1,476.15             212.37          247,532.99           17,795.19
     13           01/01/03             247,532.99      1,474.88             213.63          247,319.36           19,270.08
     14           02/01/03             247,319.36      1,473.61             214.91          247,104.45           20,743.69
     15           03/01/03             247,104.45      1,472.33             216.19          246,888.27           22,216.02
     16           04/01/03             246,888.27      1,471.04             217.47          246,670.79           23,687.06
     17           05/01/03             246,670.79      1,469.75             218.77          246,452.02           25,156.81
     18           06/01/03             246,452.02      1,468.44             220.07          246,231.95           26,625.25
     19           07/01/03             246,231.95      1,467.13             221.38          246,010.56           28,092.39
     20           08/01/03             246,010.56      1,465.81             222.70          245,787.86           29,558.20
     21           09/01/03             245,787.86      1,464.49             224.03          245,563.83           31,022.68
     22           10/01/03             245,563.83      1,463.15             225.37          245,338.46           32,485.84
     23           11/01/03             245,338.46      1,461.81             226.71          245,111.76           33,947.64
     24           12/01/03             245,111.76      1,460.46             228.06          244,883.70           35,408.10
     25           01/01/04             244,883.70      1,459.10             229.42          244,654.28           36,867.20
     26           02/01/04             244,654.28      1,457.73             230.79          244,423.49           38,324.93
     27           03/01/04             244,423.49      1,456.36             232.16          244,191.33           39,781.29
     28           04/01/04             244,191.33      1,454.97             233.54          243,957.79           41,236.26
     29           05/01/04             243,957.79      1,453.58             234.94          243,722.85           42,689.84
     30           06/01/04             243,722.85      1,452.18             236.33          243,486.52           44,142.03
     31           07/01/04             243,486.52      1,450.77             237.74          243,248.78           45,592.80

9/16/2008                                                                                          d7bc8998-7f12-4a55-a38d-af39f7b71e83.xls
                                      Initialization Information
              LOAN DATA                                                        TABLE DATA
                  Loan amount: >         $250,000
            Annual interest rate: >         7.15%                                Table starts at date: >          1/1/2002
                 Term in years: >               30                               or payment number: >                 1
             Payments per year: >               12
             First payment due: >         1/1/2002

                                           Periodic Payment
              Entered payment: >             $0.00       Table uses the calculated periodic payment amount
            Calculated payment: >        $1,688.52       unless you enter a value for "Entered payment".

                                               Calculations
                 Use payment of: >     $1,688.52              Beginning balance at payment 1: >                       $250,000
            1st payment in table: >        1             Cumulative interest prior to payment 1: >                          $0
                                                    Table
    Based on payment of >              $1,688.52                      For 30 Years
             Payment                  Beginning                                   Ending                      Cumulative
    No.        Date                    Balance         Interest         Principal Balance                      Interest
     32           08/01/04             243,248.78      1,449.36             239.16          243,009.62           47,042.16
     33           09/01/04             243,009.62      1,447.93             240.58          242,769.03           48,490.09
     34           10/01/04             242,769.03      1,446.50             242.02          242,527.01           49,936.59
     35           11/01/04             242,527.01      1,445.06             243.46          242,283.55           51,381.64
     36           12/01/04             242,283.55      1,443.61             244.91          242,038.64           52,825.25
     37           01/01/05             242,038.64      1,442.15             246.37          241,792.27           54,267.40
     38           02/01/05             241,792.27      1,440.68             247.84          241,544.43           55,708.08
     39           03/01/05             241,544.43      1,439.20             249.31          241,295.12           57,147.28
     40           04/01/05             241,295.12      1,437.72             250.80          241,044.32           58,585.00
     41           05/01/05             241,044.32      1,436.22             252.29          240,792.03           60,021.22
     42           06/01/05             240,792.03      1,434.72             253.80          240,538.23           61,455.94
     43           07/01/05             240,538.23      1,433.21             255.31          240,282.92           62,889.14
     44           08/01/05             240,282.92      1,431.69             256.83          240,026.09           64,320.83
     45           09/01/05             240,026.09      1,430.16             258.36          239,767.73           65,750.99
     46           10/01/05             239,767.73      1,428.62             259.90          239,507.82           67,179.60
     47           11/01/05             239,507.82      1,427.07             261.45          239,246.37           68,606.67
     48           12/01/05             239,246.37      1,425.51             263.01          238,983.37           70,032.18
     49           01/01/06             238,983.37      1,423.94             264.57          238,718.79           71,456.12
     50           02/01/06             238,718.79      1,422.37             266.15          238,452.64           72,878.49
     51           03/01/06             238,452.64      1,420.78             267.74          238,184.91           74,299.27
     52           04/01/06             238,184.91      1,419.19             269.33          237,915.57           75,718.45
     53           05/01/06             237,915.57      1,417.58             270.94          237,644.64           77,136.03
     54           06/01/06             237,644.64      1,415.97             272.55          237,372.09           78,552.00
     55           07/01/06             237,372.09      1,414.34             274.17          237,097.91           79,966.34
     56           08/01/06             237,097.91      1,412.71             275.81          236,822.10           81,379.05
     57           09/01/06             236,822.10      1,411.07             277.45          236,544.65           82,790.11
     58           10/01/06             236,544.65      1,409.41             279.11          236,265.55           84,199.53
     59           11/01/06             236,265.55      1,407.75             280.77          235,984.78           85,607.27
     60           12/01/06             235,984.78      1,406.08             282.44          235,702.34           87,013.35
     61           01/01/07             235,702.34      1,404.39             284.12          235,418.21           88,417.74
     62           02/01/07             235,418.21      1,402.70             285.82          235,132.40           89,820.44

9/16/2008                                                                                          d7bc8998-7f12-4a55-a38d-af39f7b71e83.xls
                                      Initialization Information
              LOAN DATA                                                        TABLE DATA
                  Loan amount: >         $250,000
            Annual interest rate: >         7.15%                                Table starts at date: >          1/1/2002
                 Term in years: >               30                               or payment number: >                 1
             Payments per year: >               12
             First payment due: >         1/1/2002

                                           Periodic Payment
              Entered payment: >             $0.00       Table uses the calculated periodic payment amount
            Calculated payment: >        $1,688.52       unless you enter a value for "Entered payment".

                                               Calculations
                 Use payment of: >     $1,688.52              Beginning balance at payment 1: >                       $250,000
            1st payment in table: >        1             Cumulative interest prior to payment 1: >                          $0
                                                    Table
    Based on payment of >              $1,688.52                      For 30 Years
             Payment                  Beginning                                   Ending                      Cumulative
    No.        Date                    Balance         Interest         Principal Balance                      Interest
     63           03/01/07             235,132.40      1,401.00             287.52          234,844.88            91,221.44
     64           04/01/07             234,844.88      1,399.28             289.23          234,555.64            92,620.73
     65           05/01/07             234,555.64      1,397.56             290.96          234,264.69            94,018.29
     66           06/01/07             234,264.69      1,395.83             292.69          233,972.00            95,414.11
     67           07/01/07             233,972.00      1,394.08             294.43          233,677.56            96,808.20
     68           08/01/07             233,677.56      1,392.33             296.19          233,381.38            98,200.53
     69           09/01/07             233,381.38      1,390.56             297.95          233,083.42            99,591.09
     70           10/01/07             233,083.42      1,388.79             299.73          232,783.70           100,979.88
     71           11/01/07             232,783.70      1,387.00             301.51          232,482.18           102,366.88
     72           12/01/07             232,482.18      1,385.21             303.31          232,178.87           103,752.09
     73           01/01/08             232,178.87      1,383.40             305.12          231,873.75           105,135.49
     74           02/01/08             231,873.75      1,381.58             306.94          231,566.82           106,517.07
     75           03/01/08             231,566.82      1,379.75             308.76          231,258.05           107,896.82
     76           04/01/08             231,258.05      1,377.91             310.60          230,947.45           109,274.73
     77           05/01/08             230,947.45      1,376.06             312.46          230,634.99           110,650.79
     78           06/01/08             230,634.99      1,374.20             314.32          230,320.68           112,024.99
     79           07/01/08             230,320.68      1,372.33             316.19          230,004.49           113,397.32
     80           08/01/08             230,004.49      1,370.44             318.07          229,686.41           114,767.77
     81           09/01/08             229,686.41      1,368.55             319.97          229,366.45           116,136.31
     82           10/01/08             229,366.45      1,366.64             321.88          229,044.57           117,502.96
     83           11/01/08             229,044.57      1,364.72             323.79          228,720.78           118,867.68
     84           12/01/08             228,720.78      1,362.79             325.72          228,395.05           120,230.47
     85           01/01/09             228,395.05      1,360.85             327.66          228,067.39           121,591.33
     86           02/01/09             228,067.39      1,358.90             329.62          227,737.78           122,950.23
     87           03/01/09             227,737.78      1,356.94             331.58          227,406.20           124,307.17
     88           04/01/09             227,406.20      1,354.96             333.55          227,072.64           125,662.13
     89           05/01/09             227,072.64      1,352.97             335.54          226,737.10           127,015.10
     90           06/01/09             226,737.10      1,350.98             337.54          226,399.56           128,366.08
     91           07/01/09             226,399.56      1,348.96             339.55          226,060.01           129,715.04
     92           08/01/09             226,060.01      1,346.94             341.58          225,718.43           131,061.98
     93           09/01/09             225,718.43      1,344.91             343.61          225,374.82           132,406.89

9/16/2008                                                                                          d7bc8998-7f12-4a55-a38d-af39f7b71e83.xls
                                      Initialization Information
              LOAN DATA                                                        TABLE DATA
                  Loan amount: >         $250,000
            Annual interest rate: >         7.15%                                Table starts at date: >          1/1/2002
                 Term in years: >               30                               or payment number: >                 1
             Payments per year: >               12
             First payment due: >         1/1/2002

                                           Periodic Payment
              Entered payment: >             $0.00       Table uses the calculated periodic payment amount
            Calculated payment: >        $1,688.52       unless you enter a value for "Entered payment".

                                               Calculations
                 Use payment of: >     $1,688.52              Beginning balance at payment 1: >                       $250,000
            1st payment in table: >        1             Cumulative interest prior to payment 1: >                          $0
                                                    Table
    Based on payment of >              $1,688.52                      For 30 Years
             Payment                  Beginning                                   Ending                      Cumulative
    No.        Date                    Balance         Interest         Principal Balance                      Interest
      94          10/01/09             225,374.82      1,342.86             345.66          225,029.16           133,749.75
      95          11/01/09             225,029.16      1,340.80             347.72          224,681.44           135,090.55
      96          12/01/09             224,681.44      1,338.73             349.79          224,331.65           136,429.27
      97          01/01/10             224,331.65      1,336.64             351.87          223,979.78           137,765.92
      98          02/01/10             223,979.78      1,334.55             353.97          223,625.81           139,100.46
      99          03/01/10             223,625.81      1,332.44             356.08          223,269.73           140,432.90
     100          04/01/10             223,269.73      1,330.32             358.20          222,911.53           141,763.21
     101          05/01/10             222,911.53      1,328.18             360.34          222,551.19           143,091.40
     102          06/01/10             222,551.19      1,326.03             362.48          222,188.71           144,417.43
     103          07/01/10             222,188.71      1,323.87             364.64          221,824.06           145,741.30
     104          08/01/10             221,824.06      1,321.70             366.82          221,457.25           147,063.01
     105          09/01/10             221,457.25      1,319.52             369.00          221,088.25           148,382.52
     106          10/01/10             221,088.25      1,317.32             371.20          220,717.05           149,699.84
     107          11/01/10             220,717.05      1,315.11             373.41          220,343.64           151,014.94
     108          12/01/10             220,343.64      1,312.88             375.64          219,968.00           152,327.83
     109          01/01/11             219,968.00      1,310.64             377.87          219,590.13           153,638.47
     110          02/01/11             219,590.13      1,308.39             380.13          219,210.00           154,946.86
     111          03/01/11             219,210.00      1,306.13             382.39          218,827.61           156,252.99
     112          04/01/11             218,827.61      1,303.85             384.67          218,442.94           157,556.83
     113          05/01/11             218,442.94      1,301.56             386.96          218,055.98           158,858.39
     114          06/01/11             218,055.98      1,299.25             389.27          217,666.71           160,157.64
     115          07/01/11             217,666.71      1,296.93             391.59          217,275.13           161,454.57
     116          08/01/11             217,275.13      1,294.60             393.92          216,881.21           162,749.17
     117          09/01/11             216,881.21      1,292.25             396.27          216,484.94           164,041.42
     118          10/01/11             216,484.94      1,289.89             398.63          216,086.32           165,331.31
     119          11/01/11             216,086.32      1,287.51             401.00          215,685.31           166,618.82
     120          12/01/11             215,685.31      1,285.12             403.39          215,281.92           167,903.95
     121          01/01/12             215,281.92      1,282.72             405.80          214,876.13           169,186.67
     122          02/01/12             214,876.13      1,280.30             408.21          214,467.91           170,466.97
     123          03/01/12             214,467.91      1,277.87             410.65          214,057.27           171,744.84
     124          04/01/12             214,057.27      1,275.42             413.09          213,644.17           173,020.27

9/16/2008                                                                                          d7bc8998-7f12-4a55-a38d-af39f7b71e83.xls
                                      Initialization Information
              LOAN DATA                                                        TABLE DATA
                  Loan amount: >         $250,000
            Annual interest rate: >         7.15%                                Table starts at date: >          1/1/2002
                 Term in years: >               30                               or payment number: >                 1
             Payments per year: >               12
             First payment due: >         1/1/2002

                                           Periodic Payment
              Entered payment: >             $0.00       Table uses the calculated periodic payment amount
            Calculated payment: >        $1,688.52       unless you enter a value for "Entered payment".

                                               Calculations
                 Use payment of: >     $1,688.52              Beginning balance at payment 1: >                       $250,000
            1st payment in table: >        1             Cumulative interest prior to payment 1: >                          $0
                                                    Table
    Based on payment of >              $1,688.52                      For 30 Years
             Payment                  Beginning                                   Ending                      Cumulative
    No.        Date                    Balance         Interest         Principal Balance                      Interest
     125          05/01/12             213,644.17      1,272.96             415.55          213,228.62           174,293.23
     126          06/01/12             213,228.62      1,270.49             418.03          212,810.59           175,563.72
     127          07/01/12             212,810.59      1,268.00             420.52          212,390.07           176,831.72
     128          08/01/12             212,390.07      1,265.49             423.03          211,967.04           178,097.21
     129          09/01/12             211,967.04      1,262.97             425.55          211,541.50           179,360.18
     130          10/01/12             211,541.50      1,260.43             428.08          211,113.42           180,620.61
     131          11/01/12             211,113.42      1,257.88             430.63          210,682.78           181,878.50
     132          12/01/12             210,682.78      1,255.32             433.20          210,249.58           183,133.81
     133          01/01/13             210,249.58      1,252.74             435.78          209,813.80           184,386.55
     134          02/01/13             209,813.80      1,250.14             438.38          209,375.43           185,636.69
     135          03/01/13             209,375.43      1,247.53             440.99          208,934.44           186,884.22
     136          04/01/13             208,934.44      1,244.90             443.62          208,490.82           188,129.12
     137          05/01/13             208,490.82      1,242.26             446.26          208,044.56           189,371.38
     138          06/01/13             208,044.56      1,239.60             448.92          207,595.65           190,610.98
     139          07/01/13             207,595.65      1,236.92             451.59          207,144.05           191,847.90
     140          08/01/13             207,144.05      1,234.23             454.28          206,689.77           193,082.13
     141          09/01/13             206,689.77      1,231.53             456.99          206,232.78           194,313.66
     142          10/01/13             206,232.78      1,228.80             459.71          205,773.07           195,542.47
     143          11/01/13             205,773.07      1,226.06             462.45          205,310.61           196,768.53
     144          12/01/13             205,310.61      1,223.31             465.21          204,845.41           197,991.84
     145          01/01/14             204,845.41      1,220.54             467.98          204,377.43           199,212.38
     146          02/01/14             204,377.43      1,217.75             470.77          203,906.66           200,430.12
     147          03/01/14             203,906.66      1,214.94             473.57          203,433.09           201,645.07
     148          04/01/14             203,433.09      1,212.12             476.39          202,956.69           202,857.19
     149          05/01/14             202,956.69      1,209.28             479.23          202,477.46           204,066.47
     150          06/01/14             202,477.46      1,206.43             482.09          201,995.37           205,272.90
     151          07/01/14             201,995.37      1,203.56             484.96          201,510.41           206,476.46
     152          08/01/14             201,510.41      1,200.67             487.85          201,022.56           207,677.12
     153          09/01/14             201,022.56      1,197.76             490.76          200,531.80           208,874.88
     154          10/01/14             200,531.80      1,194.84             493.68          200,038.12           210,069.72
     155          11/01/14             200,038.12      1,191.89             496.62          199,541.50           211,261.61

9/16/2008                                                                                          d7bc8998-7f12-4a55-a38d-af39f7b71e83.xls
                                      Initialization Information
              LOAN DATA                                                        TABLE DATA
                  Loan amount: >         $250,000
            Annual interest rate: >         7.15%                                Table starts at date: >          1/1/2002
                 Term in years: >               30                               or payment number: >                 1
             Payments per year: >               12
             First payment due: >         1/1/2002

                                           Periodic Payment
              Entered payment: >             $0.00       Table uses the calculated periodic payment amount
            Calculated payment: >        $1,688.52       unless you enter a value for "Entered payment".

                                               Calculations
                 Use payment of: >     $1,688.52              Beginning balance at payment 1: >                       $250,000
            1st payment in table: >        1             Cumulative interest prior to payment 1: >                          $0
                                                    Table
    Based on payment of >              $1,688.52                      For 30 Years
             Payment                  Beginning                                   Ending                      Cumulative
    No.        Date                    Balance         Interest         Principal Balance                      Interest
     156          12/01/14             199,541.50      1,188.93             499.58          199,041.91           212,450.55
     157          01/01/15             199,041.91      1,185.96             502.56          198,539.35           213,636.51
     158          02/01/15             198,539.35      1,182.96             505.55          198,033.80           214,819.47
     159          03/01/15             198,033.80      1,179.95             508.57          197,525.24           215,999.42
     160          04/01/15             197,525.24      1,176.92             511.60          197,013.64           217,176.34
     161          05/01/15             197,013.64      1,173.87             514.64          196,499.00           218,350.22
     162          06/01/15             196,499.00      1,170.81             517.71          195,981.29           219,521.02
     163          07/01/15             195,981.29      1,167.72             520.80          195,460.49           220,688.74
     164          08/01/15             195,460.49      1,164.62             523.90          194,936.59           221,853.36
     165          09/01/15             194,936.59      1,161.50             527.02          194,409.57           223,014.86
     166          10/01/15             194,409.57      1,158.36             530.16          193,879.41           224,173.22
     167          11/01/15             193,879.41      1,155.20             533.32          193,346.09           225,328.41
     168          12/01/15             193,346.09      1,152.02             536.50          192,809.60           226,480.43
     169          01/01/16             192,809.60      1,148.82             539.69          192,269.90           227,629.26
     170          02/01/16             192,269.90      1,145.61             542.91          191,727.00           228,774.87
     171          03/01/16             191,727.00      1,142.37             546.14          191,180.85           229,917.24
     172          04/01/16             191,180.85      1,139.12             549.40          190,631.45           231,056.36
     173          05/01/16             190,631.45      1,135.85             552.67          190,078.78           232,192.21
     174          06/01/16             190,078.78      1,132.55             555.96          189,522.82           233,324.76
     175          07/01/16             189,522.82      1,129.24             559.28          188,963.54           234,454.00
     176          08/01/16             188,963.54      1,125.91             562.61          188,400.93           235,579.91
     177          09/01/16             188,400.93      1,122.56             565.96          187,834.97           236,702.46
     178          10/01/16             187,834.97      1,119.18             569.33          187,265.64           237,821.64
     179          11/01/16             187,265.64      1,115.79             572.73          186,692.91           238,937.44
     180          12/01/16             186,692.91      1,112.38             576.14          186,116.77           240,049.81
     181          01/01/17             186,116.77      1,108.95             579.57          185,537.20           241,158.76
     182          02/01/17             185,537.20      1,105.49             583.02          184,954.18           242,264.25
     183          03/01/17             184,954.18      1,102.02             586.50          184,367.68           243,366.27
     184          04/01/17             184,367.68      1,098.52             589.99          183,777.69           244,464.80
     185          05/01/17             183,777.69      1,095.01             593.51          183,184.18           245,559.80
     186          06/01/17             183,184.18      1,091.47             597.04          182,587.14           246,651.28

9/16/2008                                                                                          d7bc8998-7f12-4a55-a38d-af39f7b71e83.xls
                                      Initialization Information
              LOAN DATA                                                        TABLE DATA
                  Loan amount: >         $250,000
            Annual interest rate: >         7.15%                                Table starts at date: >          1/1/2002
                 Term in years: >               30                               or payment number: >                 1
             Payments per year: >               12
             First payment due: >         1/1/2002

                                           Periodic Payment
              Entered payment: >             $0.00       Table uses the calculated periodic payment amount
            Calculated payment: >        $1,688.52       unless you enter a value for "Entered payment".

                                               Calculations
                 Use payment of: >     $1,688.52              Beginning balance at payment 1: >                       $250,000
            1st payment in table: >        1             Cumulative interest prior to payment 1: >                          $0
                                                    Table
    Based on payment of >              $1,688.52                      For 30 Years
             Payment                  Beginning                                   Ending                      Cumulative
    No.        Date                    Balance         Interest         Principal Balance                      Interest
     187          07/01/17             182,587.14      1,087.92             600.60          181,986.53           247,739.19
     188          08/01/17             181,986.53      1,084.34             604.18          181,382.35           248,823.53
     189          09/01/17             181,382.35      1,080.74             607.78          180,774.57           249,904.26
     190          10/01/17             180,774.57      1,077.12             611.40          180,163.17           250,981.38
     191          11/01/17             180,163.17      1,073.47             615.04          179,548.13           252,054.85
     192          12/01/17             179,548.13      1,069.81             618.71          178,929.42           253,124.66
     193          01/01/18             178,929.42      1,066.12             622.40          178,307.02           254,190.78
     194          02/01/18             178,307.02      1,062.41             626.10          177,680.92           255,253.19
     195          03/01/18             177,680.92      1,058.68             629.83          177,051.08           256,311.88
     196          04/01/18             177,051.08      1,054.93             633.59          176,417.49           257,366.81
     197          05/01/18             176,417.49      1,051.15             637.36          175,780.13           258,417.96
     198          06/01/18             175,780.13      1,047.36             641.16          175,138.97           259,465.32
     199          07/01/18             175,138.97      1,043.54             644.98          174,493.99           260,508.85
     200          08/01/18             174,493.99      1,039.69             648.82          173,845.17           261,548.55
     201          09/01/18             173,845.17      1,035.83             652.69          173,192.48           262,584.37
     202          10/01/18             173,192.48      1,031.94             656.58          172,535.90           263,616.31
     203          11/01/18             172,535.90      1,028.03             660.49          171,875.41           264,644.34
     204          12/01/18             171,875.41      1,024.09             664.43          171,210.98           265,668.43
     205          01/01/19             171,210.98      1,020.13             668.38          170,542.60           266,688.56
     206          02/01/19             170,542.60      1,016.15             672.37          169,870.23           267,704.71
     207          03/01/19             169,870.23      1,012.14             676.37          169,193.86           268,716.85
     208          04/01/19             169,193.86      1,008.11             680.40          168,513.45           269,724.97
     209          05/01/19             168,513.45      1,004.06             684.46          167,829.00           270,729.03
     210          06/01/19             167,829.00       999.98              688.54          167,140.46           271,729.01
     211          07/01/19             167,140.46       995.88              692.64          166,447.82           272,724.89
     212          08/01/19             166,447.82       991.75              696.77          165,751.06           273,716.64
     213          09/01/19             165,751.06       987.60              700.92          165,050.14           274,704.24
     214          10/01/19             165,050.14       983.42              705.09          164,345.05           275,687.66
     215          11/01/19             164,345.05       979.22              709.29          163,635.75           276,666.88
     216          12/01/19             163,635.75       975.00              713.52          162,922.23           277,641.88
     217          01/01/20             162,922.23       970.74              717.77          162,204.46           278,612.63

9/16/2008                                                                                          d7bc8998-7f12-4a55-a38d-af39f7b71e83.xls
                                      Initialization Information
              LOAN DATA                                                        TABLE DATA
                  Loan amount: >         $250,000
            Annual interest rate: >         7.15%                                Table starts at date: >          1/1/2002
                 Term in years: >               30                               or payment number: >                 1
             Payments per year: >               12
             First payment due: >         1/1/2002

                                           Periodic Payment
              Entered payment: >             $0.00       Table uses the calculated periodic payment amount
            Calculated payment: >        $1,688.52       unless you enter a value for "Entered payment".

                                               Calculations
                 Use payment of: >     $1,688.52              Beginning balance at payment 1: >                       $250,000
            1st payment in table: >        1             Cumulative interest prior to payment 1: >                          $0
                                                    Table
    Based on payment of >              $1,688.52                      For 30 Years
             Payment                  Beginning                                   Ending                      Cumulative
    No.        Date                    Balance         Interest         Principal Balance                      Interest
     218          02/01/20             162,204.46       966.47              722.05          161,482.41           279,579.09
     219          03/01/20             161,482.41       962.17              726.35          160,756.06           280,541.26
     220          04/01/20             160,756.06       957.84              730.68          160,025.38           281,499.10
     221          05/01/20             160,025.38       953.48              735.03          159,290.35           282,452.58
     222          06/01/20             159,290.35       949.11              739.41          158,550.94           283,401.69
     223          07/01/20             158,550.94       944.70              743.82          157,807.12           284,346.39
     224          08/01/20             157,807.12       940.27              748.25          157,058.87           285,286.65
     225          09/01/20             157,058.87       935.81              752.71          156,306.16           286,222.46
     226          10/01/20             156,306.16       931.32              757.19          155,548.97           287,153.79
     227          11/01/20             155,548.97       926.81              761.70          154,787.27           288,080.60
     228          12/01/20             154,787.27       922.27              766.24          154,021.02           289,002.87
     229          01/01/21             154,021.02       917.71              770.81          153,250.22           289,920.58
     230          02/01/21             153,250.22       913.12              775.40          152,474.81           290,833.70
     231          03/01/21             152,474.81       908.50              780.02          151,694.79           291,742.20
     232          04/01/21             151,694.79       903.85              784.67          150,910.12           292,646.04
     233          05/01/21             150,910.12       899.17              789.34          150,120.78           293,545.22
     234          06/01/21             150,120.78       894.47              794.05          149,326.73           294,439.69
     235          07/01/21             149,326.73       889.74              798.78          148,527.95           295,329.42
     236          08/01/21             148,527.95       884.98              803.54          147,724.42           296,214.40
     237          09/01/21             147,724.42       880.19              808.33          146,916.09           297,094.59
     238          10/01/21             146,916.09       875.38              813.14          146,102.95           297,969.97
     239          11/01/21             146,102.95       870.53              817.99          145,284.96           298,840.50
     240          12/01/21             145,284.96       865.66              822.86          144,462.10           299,706.16
     241          01/01/22             144,462.10       860.75              827.76          143,634.34           300,566.91
     242          02/01/22             143,634.34       855.82              832.70          142,801.64           301,422.73
     243          03/01/22             142,801.64       850.86              837.66          141,963.99           302,273.59
     244          04/01/22             141,963.99       845.87              842.65          141,121.34           303,119.46
     245          05/01/22             141,121.34       840.85              847.67          140,273.67           303,960.31
     246          06/01/22             140,273.67       835.80              852.72          139,420.95           304,796.10
     247          07/01/22             139,420.95       830.72              857.80          138,563.15           305,626.82
     248          08/01/22             138,563.15       825.61              862.91          137,700.24           306,452.43

9/16/2008                                                                                          d7bc8998-7f12-4a55-a38d-af39f7b71e83.xls
                                      Initialization Information
              LOAN DATA                                                        TABLE DATA
                  Loan amount: >         $250,000
            Annual interest rate: >         7.15%                                Table starts at date: >          1/1/2002
                 Term in years: >               30                               or payment number: >                 1
             Payments per year: >               12
             First payment due: >         1/1/2002

                                           Periodic Payment
              Entered payment: >             $0.00       Table uses the calculated periodic payment amount
            Calculated payment: >        $1,688.52       unless you enter a value for "Entered payment".

                                               Calculations
                 Use payment of: >     $1,688.52              Beginning balance at payment 1: >                       $250,000
            1st payment in table: >        1             Cumulative interest prior to payment 1: >                          $0
                                                    Table
    Based on payment of >              $1,688.52                      For 30 Years
             Payment                  Beginning                                   Ending                      Cumulative
    No.        Date                    Balance         Interest         Principal Balance                      Interest
     249          09/01/22             137,700.24       820.46              868.05          136,832.18           307,272.89
     250          10/01/22             136,832.18       815.29              873.23          135,958.96           308,088.18
     251          11/01/22             135,958.96       810.09              878.43          135,080.53           308,898.27
     252          12/01/22             135,080.53       804.85              883.66          134,196.87           309,703.13
     253          01/01/23             134,196.87       799.59              888.93          133,307.94           310,502.72
     254          02/01/23             133,307.94       794.29              894.22          132,413.72           311,297.01
     255          03/01/23             132,413.72       788.97              899.55          131,514.17           312,085.97
     256          04/01/23             131,514.17       783.61              904.91          130,609.25           312,869.58
     257          05/01/23             130,609.25       778.21              910.30          129,698.95           313,647.79
     258          06/01/23             129,698.95       772.79              915.73          128,783.22           314,420.58
     259          07/01/23             128,783.22       767.33              921.18          127,862.04           315,187.92
     260          08/01/23             127,862.04       761.84              926.67          126,935.37           315,949.76
     261          09/01/23             126,935.37       756.32              932.19          126,003.17           316,706.08
     262          10/01/23             126,003.17       750.77              937.75          125,065.43           317,456.85
     263          11/01/23             125,065.43       745.18              943.34          124,122.09           318,202.03
     264          12/01/23             124,122.09       739.56              948.96          123,173.14           318,941.59
     265          01/01/24             123,173.14       733.91              954.61          122,218.52           319,675.50
     266          02/01/24             122,218.52       728.22              960.30          121,258.23           320,403.72
     267          03/01/24             121,258.23       722.50              966.02          120,292.21           321,126.22
     268          04/01/24             120,292.21       716.74              971.78          119,320.43           321,842.96
     269          05/01/24             119,320.43       710.95              977.57          118,342.86           322,553.91
     270          06/01/24             118,342.86       705.13              983.39          117,359.47           323,259.03
     271          07/01/24             117,359.47       699.27              989.25          116,370.22           323,958.30
     272          08/01/24             116,370.22       693.37              995.14          115,375.08           324,651.67
     273          09/01/24             115,375.08       687.44             1,001.07         114,374.01           325,339.12
     274          10/01/24             114,374.01       681.48             1,007.04         113,366.97           326,020.60
     275          11/01/24             113,366.97       675.48             1,013.04         112,353.93           326,696.07
     276          12/01/24             112,353.93       669.44             1,019.07         111,334.85           327,365.52
     277          01/01/25             111,334.85       663.37             1,025.15         110,309.71           328,028.89
     278          02/01/25             110,309.71       657.26             1,031.25         109,278.45           328,686.15
     279          03/01/25             109,278.45       651.12             1,037.40         108,241.05           329,337.27

9/16/2008                                                                                          d7bc8998-7f12-4a55-a38d-af39f7b71e83.xls
                                      Initialization Information
              LOAN DATA                                                        TABLE DATA
                  Loan amount: >         $250,000
            Annual interest rate: >         7.15%                                Table starts at date: >          1/1/2002
                 Term in years: >               30                               or payment number: >                 1
             Payments per year: >               12
             First payment due: >         1/1/2002

                                           Periodic Payment
              Entered payment: >             $0.00       Table uses the calculated periodic payment amount
            Calculated payment: >        $1,688.52       unless you enter a value for "Entered payment".

                                               Calculations
                 Use payment of: >     $1,688.52              Beginning balance at payment 1: >                       $250,000
            1st payment in table: >        1             Cumulative interest prior to payment 1: >                          $0
                                                    Table
    Based on payment of >              $1,688.52                      For 30 Years
             Payment                  Beginning                                   Ending                      Cumulative
    No.        Date                    Balance         Interest         Principal Balance                      Interest
     280          04/01/25             108,241.05       644.94             1,043.58         107,197.47           329,982.20
     281          05/01/25             107,197.47       638.72             1,049.80         106,147.67           330,620.92
     282          06/01/25             106,147.67       632.46             1,056.05         105,091.62           331,253.38
     283          07/01/25             105,091.62       626.17             1,062.35         104,029.27           331,879.55
     284          08/01/25             104,029.27       619.84             1,068.68         102,960.60           332,499.40
     285          09/01/25             102,960.60       613.47             1,075.04         101,885.56           333,112.87
     286          10/01/25             101,885.56       607.07             1,081.45         100,804.11           333,719.94
     287          11/01/25             100,804.11       600.62             1,087.89          99,716.21           334,320.56
     288          12/01/25              99,716.21       594.14             1,094.37          98,621.84           334,914.70
     289          01/01/26              98,621.84       587.62             1,100.90          97,520.94           335,502.33
     290          02/01/26              97,520.94       581.06             1,107.45          96,413.49           336,083.39
     291          03/01/26              96,413.49       574.46             1,114.05          95,299.44           336,657.85
     292          04/01/26              95,299.44       567.83             1,120.69          94,178.75           337,225.68
     293          05/01/26              94,178.75       561.15             1,127.37          93,051.38           337,786.83
     294          06/01/26              93,051.38       554.43             1,134.09          91,917.29           338,341.26
     295          07/01/26              91,917.29       547.67             1,140.84          90,776.45           338,888.93
     296          08/01/26              90,776.45       540.88             1,147.64          89,628.81           339,429.81
     297          09/01/26              89,628.81       534.04             1,154.48          88,474.33           339,963.85
     298          10/01/26              88,474.33       527.16             1,161.36          87,312.97           340,491.01
     299          11/01/26              87,312.97       520.24             1,168.28          86,144.69           341,011.25
     300          12/01/26              86,144.69       513.28             1,175.24          84,969.46           341,524.52
     301          01/01/27              84,969.46       506.28             1,182.24          83,787.22           342,030.80
     302          02/01/27              83,787.22       499.23             1,189.28          82,597.93           342,530.03
     303          03/01/27              82,597.93       492.15             1,196.37          81,401.56           343,022.18
     304          04/01/27              81,401.56       485.02             1,203.50          80,198.06           343,507.20
     305          05/01/27              80,198.06       477.85             1,210.67          78,987.39           343,985.04
     306          06/01/27              78,987.39       470.63             1,217.88          77,769.51           344,455.68
     307          07/01/27              77,769.51       463.38             1,225.14          76,544.37           344,919.05
     308          08/01/27              76,544.37       456.08             1,232.44          75,311.93           345,375.13
     309          09/01/27              75,311.93       448.73             1,239.78          74,072.14           345,823.86
     310          10/01/27              74,072.14       441.35             1,247.17          72,824.97           346,265.21

9/16/2008                                                                                          d7bc8998-7f12-4a55-a38d-af39f7b71e83.xls
                                      Initialization Information
              LOAN DATA                                                       TABLE DATA
                  Loan amount: >         $250,000
            Annual interest rate: >         7.15%                               Table starts at date: >          1/1/2002
                 Term in years: >               30                              or payment number: >                 1
             Payments per year: >               12
             First payment due: >         1/1/2002

                                           Periodic Payment
              Entered payment: >             $0.00      Table uses the calculated periodic payment amount
            Calculated payment: >        $1,688.52      unless you enter a value for "Entered payment".

                                               Calculations
                 Use payment of: >     $1,688.52             Beginning balance at payment 1: >                       $250,000
            1st payment in table: >        1            Cumulative interest prior to payment 1: >                          $0
                                                   Table
    Based on payment of >              $1,688.52                     For 30 Years
             Payment                  Beginning                                  Ending                      Cumulative
    No.        Date                    Balance        Interest         Principal Balance                      Interest
     311          11/01/27             72,824.97       433.92             1,254.60          71,570.37           346,699.13
     312          12/01/27             71,570.37       426.44             1,262.08          70,308.30           347,125.57
     313          01/01/28             70,308.30       418.92             1,269.60          69,038.70           347,544.49
     314          02/01/28             69,038.70       411.36             1,277.16          67,761.54           347,955.84
     315          03/01/28             67,761.54       403.75             1,284.77          66,476.77           348,359.59
     316          04/01/28             66,476.77       396.09             1,292.43          65,184.34           348,755.68
     317          05/01/28             65,184.34       388.39             1,300.13          63,884.21           349,144.07
     318          06/01/28             63,884.21       380.64             1,307.87          62,576.34           349,524.71
     319          07/01/28             62,576.34       372.85             1,315.67          61,260.67           349,897.56
     320          08/01/28             61,260.67       365.01             1,323.51          59,937.17           350,262.57
     321          09/01/28             59,937.17       357.13             1,331.39          58,605.78           350,619.70
     322          10/01/28             58,605.78       349.19             1,339.32          57,266.45           350,968.89
     323          11/01/28             57,266.45       341.21             1,347.30          55,919.15           351,310.10
     324          12/01/28             55,919.15       333.18             1,355.33          54,563.82           351,643.29
     325          01/01/29             54,563.82       325.11             1,363.41          53,200.41           351,968.40
     326          02/01/29             53,200.41       316.99             1,371.53          51,828.88           352,285.38
     327          03/01/29             51,828.88       308.81             1,379.70          50,449.17           352,594.20
     328          04/01/29             50,449.17       300.59             1,387.92          49,061.25           352,894.79
     329          05/01/29             49,061.25       292.32             1,396.19          47,665.06           353,187.11
     330          06/01/29             47,665.06       284.00             1,404.51          46,260.54           353,471.12
     331          07/01/29             46,260.54       275.64             1,412.88          44,847.66           353,746.75
     332          08/01/29             44,847.66       267.22             1,421.30          43,426.36           354,013.97
     333          09/01/29             43,426.36       258.75             1,429.77          41,996.60           354,272.72
     334          10/01/29             41,996.60       250.23             1,438.29          40,558.31           354,522.95
     335          11/01/29             40,558.31       241.66             1,446.86          39,111.45           354,764.61
     336          12/01/29             39,111.45       233.04             1,455.48          37,655.97           354,997.65
     337          01/01/30             37,655.97       224.37             1,464.15          36,191.82           355,222.02
     338          02/01/30             36,191.82       215.64             1,472.87          34,718.95           355,437.66
     339          03/01/30             34,718.95       206.87             1,481.65          33,237.30           355,644.53
     340          04/01/30             33,237.30       198.04             1,490.48          31,746.82           355,842.56
     341          05/01/30             31,746.82       189.16             1,499.36          30,247.46           356,031.72

9/16/2008                                                                                         d7bc8998-7f12-4a55-a38d-af39f7b71e83.xls
                                      Initialization Information
              LOAN DATA                                                       TABLE DATA
                  Loan amount: >         $250,000
            Annual interest rate: >         7.15%                               Table starts at date: >          1/1/2002
                 Term in years: >               30                              or payment number: >                 1
             Payments per year: >               12
             First payment due: >         1/1/2002

                                           Periodic Payment
              Entered payment: >             $0.00      Table uses the calculated periodic payment amount
            Calculated payment: >        $1,688.52      unless you enter a value for "Entered payment".

                                               Calculations
                 Use payment of: >     $1,688.52             Beginning balance at payment 1: >                       $250,000
            1st payment in table: >        1            Cumulative interest prior to payment 1: >                          $0
                                                   Table
    Based on payment of >              $1,688.52                     For 30 Years
             Payment                  Beginning                                  Ending                      Cumulative
    No.        Date                    Balance        Interest         Principal Balance                      Interest
     342          06/01/30             30,247.46       180.22             1,508.29          28,739.17           356,211.95
     343          07/01/30             28,739.17       171.24             1,517.28          27,221.89           356,383.19
     344          08/01/30             27,221.89       162.20             1,526.32          25,695.57           356,545.38
     345          09/01/30             25,695.57       153.10             1,535.41          24,160.16           356,698.49
     346          10/01/30             24,160.16       143.95             1,544.56          22,615.60           356,842.44
     347          11/01/30             22,615.60       134.75             1,553.77          21,061.83           356,977.19
     348          12/01/30             21,061.83       125.49             1,563.02          19,498.81           357,102.68
     349          01/01/31             19,498.81       116.18             1,572.34          17,926.47           357,218.86
     350          02/01/31             17,926.47       106.81             1,581.71          16,344.76           357,325.68
     351          03/01/31             16,344.76        97.39             1,591.13          14,753.64           357,423.06
     352          04/01/31             14,753.64        87.91             1,600.61          13,153.03           357,510.97
     353          05/01/31             13,153.03        78.37             1,610.15          11,542.88           357,589.34
     354          06/01/31             11,542.88        68.78             1,619.74           9,923.14           357,658.12
     355          07/01/31              9,923.14        59.13             1,629.39           8,293.75           357,717.24
     356          08/01/31              8,293.75        49.42             1,639.10           6,654.65           357,766.66
     357          09/01/31              6,654.65        39.65             1,648.87           5,005.78           357,806.31
     358          10/01/31              5,005.78        29.83             1,658.69           3,347.09           357,836.14
     359          11/01/31              3,347.09        19.94             1,668.57           1,678.52           357,856.08
     360          12/01/31              1,678.52        10.00             1,678.52             0.00             357,866.08




9/16/2008                                                                                         d7bc8998-7f12-4a55-a38d-af39f7b71e83.xls

				
DOCUMENT INFO
Stats:
views:157
posted:9/16/2008
language:English
pages:12
Description: This is an example of amortization tables. This document is useful for studying amortization tables.