Amortization Schedule_2_ by fanzhongqing

VIEWS: 5 PAGES: 10

									                                                                                                                                                                        Prepared by T imothy R. Mayes 5/15/2012   Page 1




House Price               300,000
                                                                                              Note: To generate an amortization schedule simply enter the correct
Downpayment %              10.00%
                                                                                              numbers into B1, B2, B4, and B5. If you do not plan on making extra
Original Principal       270,000                                                              principal payments, enter 0 into every cell in the E7:E366 range (or
Number of Payments             360                                                            leave them blank). This worksheet is protected so that the formulas
Annual Interest Rate        6.25%                                                             cannot be changed in any way by mistake. You can only change B 1,
Payment                $1,662.44                                                              B2, B4, B5 and E7:E366. If you wish to edit the formulas, choose Tools
                                     Amortiz ation Sche dule                                  - Protection - Unprotect Sheet from the menus.
        Period            Pmt             Int          Prin     Extra Prin        Balance
                                                                                               One more thing: I have set up this sheet so that if there are extra
           0                                                                 $   270,000.00
                                                                                              principal payments or a shorter amortization period (i.e., a 15 year
           1           $ 1,662.44      $ 1,406.25   $ 256.19    $     -      $   269,743.81   mortgage) all of the cells beyond the payoff point are blanked out.
           2           $ 1,662.44      $ 1,404.92   $ 257.52    $     -      $   269,486.29
           3           $ 1,662.44      $ 1,403.57   $ 258.86    $     -      $   269,227.43   By the way, I do not provide any guarantees. Use this sheet at your own
           4           $ 1,662.44      $ 1,402.23   $ 260.21                 $   268,967.22   risk, though I'm 99.99% confident that it is correct.
           5           $ 1,662.44      $ 1,400.87   $ 261.57    $     -      $   268,705.66
           6           $ 1,662.44      $ 1,399.51   $ 262.93    $     -      $   268,442.73
           7           $ 1,662.44      $ 1,398.14   $ 264.30    $     -      $   268,178.43
           8           $ 1,662.44      $ 1,396.76   $ 265.67    $     -      $   267,912.76
           9           $ 1,662.44      $ 1,395.38   $ 267.06    $     -      $   267,645.70
          10           $ 1,662.44      $ 1,393.99   $ 268.45    $     -      $   267,377.25
          11           $ 1,662.44      $ 1,392.59   $ 269.85    $     -      $   267,107.40
          12           $ 1,662.44      $ 1,391.18   $ 271.25    $     -      $   266,836.15
          13           $ 1,662.44      $ 1,389.77   $ 272.66    $     -      $   266,563.49
          14           $ 1,662.44      $ 1,388.35   $ 274.08    $     -      $   266,289.40
          15           $ 1,662.44      $ 1,386.92   $ 275.51    $     -      $   266,013.89
          16           $ 1,662.44      $ 1,385.49   $ 276.95    $     -      $   265,736.94
          17           $ 1,662.44      $ 1,384.05   $ 278.39    $     -      $   265,458.55
          18           $ 1,662.44      $ 1,382.60   $ 279.84    $     -      $   265,178.71
          19           $ 1,662.44      $ 1,381.14   $ 281.30    $     -      $   264,897.41
          20           $ 1,662.44      $ 1,379.67   $ 282.76    $     -      $   264,614.65
          21           $ 1,662.44      $ 1,378.20   $ 284.24    $     -      $   264,330.42
          22           $ 1,662.44      $ 1,376.72   $ 285.72    $     -      $   264,044.70
          23           $ 1,662.44      $ 1,375.23   $ 287.20    $     -      $   263,757.50
          24           $ 1,662.44      $ 1,373.74   $ 288.70    $     -      $   263,468.80
          25           $ 1,662.44      $ 1,372.23   $ 290.20    $     -      $   263,178.60
          26           $ 1,662.44      $ 1,370.72   $ 291.71    $     -      $   262,886.88
          27           $ 1,662.44      $ 1,369.20   $ 293.23    $     -      $   262,593.65
          28           $ 1,662.44      $ 1,367.68   $ 294.76    $     -      $   262,298.89
          29           $ 1,662.44      $ 1,366.14   $ 296.30    $     -      $   262,002.59
          30           $ 1,662.44      $ 1,364.60   $ 297.84    $     -      $   261,704.75
          31           $ 1,662.44      $ 1,363.05   $ 299.39    $     -      $   261,405.36
          32           $ 1,662.44      $ 1,361.49   $ 300.95    $     -      $   261,104.41
          33           $ 1,662.44      $ 1,359.92   $ 302.52    $     -      $   260,801.89
          34           $ 1,662.44      $ 1,358.34   $ 304.09    $     -      $   260,497.80
          35           $ 1,662.44      $ 1,356.76   $ 305.68    $     -      $   260,192.12
          36           $ 1,662.44      $ 1,355.17   $ 307.27    $     -      $   259,884.85
          37           $ 1,662.44      $ 1,353.57   $ 308.87    $     -      $   259,575.98
          38           $ 1,662.44      $ 1,351.96   $ 310.48    $     -      $   259,265.50
          39           $ 1,662.44      $ 1,350.34   $ 312.10    $     -      $   258,953.41
          40           $ 1,662.44      $ 1,348.72   $ 313.72    $     -      $   258,639.69
          41           $ 1,662.44      $ 1,347.08   $ 315.35    $     -      $   258,324.33
          42           $ 1,662.44      $ 1,345.44   $ 317.00    $     -      $   258,007.34
          43           $ 1,662.44      $ 1,343.79   $ 318.65    $     -      $   257,688.69
          44           $ 1,662.44      $ 1,342.13   $ 320.31    $     -      $   257,368.38
          45           $ 1,662.44      $ 1,340.46   $ 321.98    $     -      $   257,046.40
          46           $ 1,662.44      $ 1,338.78   $ 323.65    $     -      $   256,722.75
          47           $ 1,662.44      $ 1,337.10   $ 325.34    $     -      $   256,397.41
          48           $ 1,662.44      $ 1,335.40   $ 327.03    $     -      $   256,070.38
          49           $ 1,662.44      $ 1,333.70   $ 328.74    $     -      $   255,741.64
          50           $ 1,662.44      $ 1,331.99   $ 330.45    $     -      $   255,411.19
          51           $ 1,662.44      $ 1,330.27   $ 332.17    $     -      $   255,079.02
          52           $ 1,662.44      $ 1,328.54   $ 333.90    $     -      $   254,745.12
          53           $ 1,662.44      $ 1,326.80   $ 335.64    $     -      $   254,409.48
          54           $ 1,662.44      $ 1,325.05   $ 337.39    $     -      $   254,072.10
          55           $ 1,662.44      $ 1,323.29   $ 339.14    $     -      $   253,732.95
          56           $ 1,662.44      $ 1,321.53   $ 340.91    $     -      $   253,392.04
          57           $ 1,662.44      $ 1,319.75   $ 342.69    $     -      $   253,049.36
          58           $ 1,662.44      $ 1,317.97   $ 344.47    $     -      $   252,704.89
          59           $ 1,662.44      $ 1,316.17   $ 346.27    $     -      $   252,358.62
          60           $ 1,662.44      $ 1,314.37   $ 348.07    $     -      $   252,010.55
          61           $ 1,662.44      $ 1,312.55   $ 349.88    $     -      $   251,660.67
          62           $ 1,662.44      $ 1,310.73   $ 351.70    $     -      $   251,308.97
          63           $ 1,662.44      $ 1,308.90   $ 353.54    $     -      $   250,955.43
          64           $ 1,662.44      $ 1,307.06   $ 355.38    $     -      $   250,600.05
          65           $ 1,662.44      $ 1,305.21   $ 357.23    $     -      $   250,242.83
          66           $ 1,662.44      $ 1,303.35   $ 359.09    $     -      $   249,883.74
          67           $ 1,662.44      $ 1,301.48   $ 360.96    $     -      $   249,522.78
          68           $ 1,662.44      $ 1,299.60   $ 362.84    $     -      $   249,159.94
          69           $ 1,662.44      $ 1,297.71   $ 364.73    $     -      $   248,795.21
          70           $ 1,662.44      $ 1,295.81   $ 366.63    $     -      $   248,428.58
          71           $ 1,662.44      $ 1,293.90   $ 368.54    $     -      $   248,060.05
          72           $ 1,662.44      $ 1,291.98   $ 370.46    $     -      $   247,689.59
          73           $ 1,662.44      $ 1,290.05   $ 372.39    $     -      $   247,317.20
          74           $ 1,662.44      $ 1,288.11   $ 374.33    $     -      $   246,942.88
          75           $ 1,662.44      $ 1,286.16   $ 376.28    $     -      $   246,566.60
          76           $ 1,662.44      $ 1,284.20   $ 378.24    $     -      $   246,188.37
          77           $ 1,662.44      $ 1,282.23   $ 380.21    $     -      $   245,808.16
          78           $ 1,662.44      $ 1,280.25   $ 382.19    $     -      $   245,425.98
          79           $ 1,662.44      $ 1,278.26   $ 384.18    $     -      $   245,041.80
          80           $ 1,662.44      $ 1,276.26   $ 386.18    $     -      $   244,655.62
          81           $ 1,662.44      $ 1,274.25   $ 388.19    $     -      $   244,267.43
          82           $ 1,662.44      $ 1,272.23   $ 390.21    $     -      $   243,877.22
          83           $ 1,662.44      $ 1,270.19   $ 392.24    $     -      $   243,484.98
          84           $ 1,662.44      $ 1,268.15   $ 394.29    $     -      $   243,090.70
          85           $ 1,662.44      $ 1,266.10   $ 396.34    $     -      $   242,694.36
          86           $ 1,662.44      $ 1,264.03   $ 398.40    $     -      $   242,295.95
          87           $ 1,662.44      $ 1,261.96   $ 400.48    $     -      $   241,895.47
          88           $ 1,662.44      $ 1,259.87   $ 402.56    $     -      $   241,492.91
          89           $ 1,662.44      $ 1,257.78   $ 404.66    $     -      $   241,088.25
          90           $ 1,662.44      $ 1,255.67   $ 406.77    $     -      $   240,681.48
          91           $ 1,662.44      $ 1,253.55   $ 408.89    $     -      $   240,272.59
          92           $ 1,662.44      $ 1,251.42   $ 411.02    $     -      $   239,861.58
          93           $ 1,662.44      $ 1,249.28   $ 413.16    $     -      $   239,448.42
          94           $ 1,662.44      $ 1,247.13   $ 415.31    $     -      $   239,033.11
          95           $ 1,662.44      $ 1,244.96   $ 417.47    $     -      $   238,615.64
          96           $ 1,662.44      $ 1,242.79   $ 419.65    $     -      $   238,195.99
          97           $ 1,662.44      $ 1,240.60   $ 421.83    $     -      $   237,774.16
          98           $ 1,662.44      $ 1,238.41   $ 424.03    $     -      $   237,350.13
          99           $ 1,662.44      $ 1,236.20   $ 426.24    $     -      $   236,923.89
         100           $ 1,662.44      $ 1,233.98   $ 428.46    $     -      $   236,495.43
         101           $ 1,662.44      $ 1,231.75   $ 430.69    $     -      $   236,064.74
         102           $ 1,662.44      $ 1,229.50   $ 432.93    $     -      $   235,631.81
         103           $ 1,662.44      $ 1,227.25   $ 435.19    $     -      $   235,196.62
         104           $ 1,662.44      $ 1,224.98   $ 437.45    $     -      $   234,759.17
         105           $ 1,662.44      $ 1,222.70   $ 439.73    $     -      $   234,319.44
         106           $ 1,662.44      $ 1,220.41   $ 442.02    $     -      $   233,877.42
         107           $ 1,662.44      $ 1,218.11   $ 444.32    $     -      $   233,433.09
         108           $ 1,662.44      $ 1,215.80   $ 446.64    $     -      $   232,986.45
         109           $ 1,662.44      $ 1,213.47   $ 448.97    $     -      $   232,537.49
         110           $ 1,662.44      $ 1,211.13   $ 451.30    $     -      $   232,086.18
         111           $ 1,662.44      $ 1,208.78   $ 453.65    $     -      $   231,632.53
         112           $ 1,662.44      $ 1,206.42   $ 456.02    $     -      $   231,176.51
         113           $ 1,662.44      $ 1,204.04   $ 458.39    $     -      $   230,718.12
         114           $ 1,662.44      $ 1,201.66   $ 460.78    $     -      $   230,257.34
         115           $ 1,662.44      $ 1,199.26   $ 463.18    $     -      $   229,794.16
         116           $ 1,662.44      $ 1,196.84   $ 465.59    $     -      $   229,328.57
         117           $ 1,662.44      $ 1,194.42   $ 468.02    $     -      $   228,860.55
         118           $ 1,662.44      $ 1,191.98   $ 470.45    $     -      $   228,390.10
         119           $ 1,662.44      $ 1,189.53   $ 472.90    $     -      $   227,917.19
         120           $ 1,662.44      $ 1,187.07   $ 475.37    $     -      $   227,441.82
         121           $ 1,662.44      $ 1,184.59   $ 477.84    $     -      $   226,963.98
         122           $ 1,662.44      $ 1,182.10   $ 480.33    $     -      $   226,483.65
         123           $ 1,662.44      $ 1,179.60   $ 482.83    $     -      $   226,000.81
         124           $ 1,662.44      $ 1,177.09   $ 485.35    $     -      $   225,515.47
         125           $ 1,662.44      $ 1,174.56   $ 487.88    $     -      $   225,027.59
         126           $ 1,662.44      $ 1,172.02   $ 490.42    $     -      $   224,537.17
         127           $ 1,662.44      $ 1,169.46   $ 492.97    $     -      $   224,044.20
         128           $ 1,662.44      $ 1,166.90   $ 495.54    $     -      $   223,548.66
         129           $ 1,662.44      $ 1,164.32   $ 498.12    $     -      $   223,050.54
         130           $ 1,662.44      $ 1,161.72   $ 500.71    $     -      $   222,549.82
         131           $ 1,662.44      $ 1,159.11   $ 503.32    $     -      $   222,046.50
         132           $ 1,662.44      $ 1,156.49   $ 505.94    $     -      $   221,540.56
         133           $ 1,662.44      $ 1,153.86   $ 508.58    $     -      $   221,031.98
         134           $ 1,662.44      $ 1,151.21   $ 511.23    $     -      $   220,520.75
         135           $ 1,662.44      $ 1,148.55   $ 513.89    $     -      $   220,006.86
         136           $ 1,662.44      $ 1,145.87   $ 516.57    $     -      $   219,490.29
         137           $ 1,662.44      $ 1,143.18   $ 519.26    $     -      $   218,971.03
         138           $ 1,662.44      $ 1,140.47   $ 521.96    $     -      $   218,449.07
         139           $ 1,662.44      $ 1,137.76   $ 524.68    $     -      $   217,924.39
         140           $ 1,662.44      $ 1,135.02   $ 527.41    $     -      $   217,396.98
         141           $ 1,662.44      $ 1,132.28   $ 530.16    $     -      $   216,866.82
         142           $ 1,662.44      $ 1,129.51   $ 532.92    $     -      $   216,333.89
         143           $ 1,662.44      $ 1,126.74   $ 535.70    $     -      $   215,798.20
         144           $ 1,662.44      $ 1,123.95   $ 538.49    $     -      $   215,259.71
         145           $ 1,662.44      $ 1,121.14   $ 541.29    $     -      $   214,718.42
         146           $ 1,662.44      $ 1,118.33   $ 544.11    $     -      $   214,174.31
         147           $ 1,662.44      $ 1,115.49   $ 546.95    $     -      $   213,627.36
         148           $ 1,662.44      $ 1,112.64   $ 549.79    $     -      $   213,077.57
         149           $ 1,662.44      $ 1,109.78   $ 552.66    $     -      $   212,524.91
         150           $ 1,662.44      $ 1,106.90   $ 555.54    $     -      $   211,969.37
         151           $ 1,662.44      $ 1,104.01   $ 558.43    $     -      $   211,410.94
         152           $ 1,662.44      $ 1,101.10   $ 561.34    $     -      $   210,849.61
         153           $ 1,662.44      $ 1,098.18   $ 564.26    $     -      $   210,285.35
         154           $ 1,662.44      $ 1,095.24   $ 567.20    $     -      $   209,718.15
         155           $ 1,662.44      $ 1,092.28   $ 570.15    $     -      $   209,147.99
         156           $ 1,662.44      $ 1,089.31   $ 573.12    $     -      $   208,574.87
         157           $ 1,662.44      $ 1,086.33   $ 576.11    $     -      $   207,998.76
         158           $ 1,662.44      $ 1,083.33   $ 579.11    $     -      $   207,419.65
         159           $ 1,662.44      $ 1,080.31   $ 582.13    $     -      $   206,837.52
         160           $ 1,662.44      $ 1,077.28   $ 585.16    $     -      $   206,252.36
         161           $ 1,662.44      $ 1,074.23   $ 588.21    $     -      $   205,664.16
         162           $ 1,662.44      $ 1,071.17   $ 591.27    $     -      $   205,072.89
         163           $ 1,662.44      $ 1,068.09   $ 594.35    $     -      $   204,478.54
         164           $ 1,662.44      $ 1,064.99   $ 597.44    $     -      $   203,881.10
         165           $ 1,662.44      $ 1,061.88   $ 600.56    $     -      $   203,280.54
         166           $ 1,662.44      $ 1,058.75   $ 603.68    $     -      $   202,676.86
         167           $ 1,662.44      $ 1,055.61   $ 606.83    $     -      $   202,070.03
         168           $ 1,662.44      $ 1,052.45   $ 609.99    $     -      $   201,460.04
         169           $ 1,662.44      $ 1,049.27   $ 613.17    $     -      $   200,846.88
         170           $ 1,662.44      $ 1,046.08   $ 616.36    $     -      $   200,230.52
         171           $ 1,662.44      $ 1,042.87   $ 619.57    $     -      $   199,610.95
         172           $ 1,662.44      $ 1,039.64   $ 622.80    $     -      $   198,988.15
         173           $ 1,662.44      $ 1,036.40   $ 626.04    $     -      $   198,362.11
         174           $ 1,662.44      $ 1,033.14   $ 629.30    $     -      $   197,732.81
         175           $ 1,662.44      $ 1,029.86   $ 632.58    $     -      $   197,100.23
         176           $ 1,662.44      $ 1,026.56   $ 635.87    $     -      $   196,464.36
         177           $ 1,662.44      $ 1,023.25   $ 639.18    $     -      $   195,825.18
         178           $ 1,662.44      $ 1,019.92   $ 642.51    $     -      $   195,182.66
         179           $ 1,662.44      $ 1,016.58   $ 645.86    $     -      $   194,536.80
         180           $ 1,662.44      $ 1,013.21   $ 649.22    $     -      $   193,887.58
         181           $ 1,662.44      $ 1,009.83   $ 652.61    $     -      $   193,234.97
         182           $ 1,662.44      $ 1,006.43   $ 656.00    $     -      $   192,578.97
         183           $ 1,662.44      $ 1,003.02   $ 659.42    $     -      $   191,919.55
         184           $ 1,662.44      $ 999.58     $ 662.86    $     -      $   191,256.69
         185           $ 1,662.44      $ 996.13     $ 666.31    $     -      $   190,590.39
         186           $ 1,662.44      $ 992.66     $ 669.78    $     -      $   189,920.61
         187           $ 1,662.44      $ 989.17     $ 673.27    $     -      $   189,247.34
         188           $ 1,662.44      $ 985.66     $ 676.77    $     -      $   188,570.57
         189           $ 1,662.44      $ 982.14     $ 680.30    $     -      $   187,890.27
         190           $ 1,662.44      $ 978.60     $ 683.84    $     -      $   187,206.43
         191           $ 1,662.44      $ 975.03     $ 687.40    $     -      $   186,519.03
         192           $ 1,662.44      $ 971.45     $ 690.98    $     -      $   185,828.04
         193           $ 1,662.44      $ 967.85     $ 694.58    $     -      $   185,133.46
         194           $ 1,662.44      $ 964.24     $ 698.20    $     -      $   184,435.26
         195           $ 1,662.44      $ 960.60     $ 701.84    $     -      $   183,733.42
         196           $ 1,662.44      $ 956.94     $ 705.49    $     -      $   183,027.93
         197           $ 1,662.44      $ 953.27     $ 709.17    $     -      $   182,318.77
         198           $ 1,662.44      $ 949.58     $ 712.86    $     -      $   181,605.91
         199           $ 1,662.44      $ 945.86     $ 716.57    $     -      $   180,889.33
         200           $ 1,662.44      $ 942.13     $ 720.30    $     -      $   180,169.03
         201           $ 1,662.44      $ 938.38     $ 724.06    $     -      $   179,444.97
         202           $ 1,662.44      $ 934.61     $ 727.83    $     -      $   178,717.15
         203           $ 1,662.44      $ 930.82     $ 731.62    $     -      $   177,985.53
         204           $ 1,662.44      $ 927.01     $ 735.43    $     -      $   177,250.10
         205           $ 1,662.44      $ 923.18     $ 739.26    $     -      $   176,510.84
         206           $ 1,662.44      $ 919.33     $ 743.11    $     -      $   175,767.73
         207           $ 1,662.44      $ 915.46     $ 746.98    $     -      $   175,020.75
         208           $ 1,662.44      $ 911.57     $ 750.87    $     -      $   174,269.88
         209           $ 1,662.44      $ 907.66     $ 754.78    $     -      $   173,515.10
         210           $ 1,662.44      $ 903.72     $ 758.71    $     -      $   172,756.39
         211           $ 1,662.44      $ 899.77     $ 762.66    $     -      $   171,993.73
         212           $ 1,662.44      $ 895.80     $ 766.64    $     -      $   171,227.09
         213           $ 1,662.44      $ 891.81     $ 770.63    $     -      $   170,456.46
         214           $ 1,662.44      $ 887.79     $ 774.64    $     -      $   169,681.82
         215           $ 1,662.44      $ 883.76     $ 778.68    $     -      $   168,903.14
         216           $ 1,662.44      $ 879.70     $ 782.73    $     -      $   168,120.41
         217           $ 1,662.44      $ 875.63     $ 786.81    $     -      $   167,333.60
         218           $ 1,662.44      $ 871.53     $ 790.91    $     -      $   166,542.69
         219           $ 1,662.44      $ 867.41     $ 795.03    $     -      $   165,747.67
         220           $ 1,662.44      $ 863.27     $ 799.17    $     -      $   164,948.50
         221           $ 1,662.44      $ 859.11     $ 803.33    $     -      $   164,145.17
         222           $ 1,662.44      $ 854.92     $ 807.51    $     -      $   163,337.66
         223           $ 1,662.44      $ 850.72     $ 811.72    $     -      $   162,525.94
         224           $ 1,662.44      $ 846.49     $ 815.95    $     -      $   161,709.99
         225           $ 1,662.44      $ 842.24     $ 820.20    $     -      $   160,889.79
         226           $ 1,662.44      $ 837.97     $ 824.47    $     -      $   160,065.32
         227           $ 1,662.44      $ 833.67     $ 828.76    $     -      $   159,236.56
         228           $ 1,662.44      $ 829.36     $ 833.08    $     -      $   158,403.48
         229           $ 1,662.44      $ 825.02     $ 837.42    $     -      $   157,566.06
         230           $ 1,662.44      $ 820.66     $ 841.78    $     -      $   156,724.28
         231           $ 1,662.44      $ 816.27     $ 846.16    $     -      $   155,878.12
         232           $ 1,662.44      $ 811.87     $ 850.57    $     -      $   155,027.55
         233           $ 1,662.44      $ 807.44     $ 855.00    $     -      $   154,172.55
         234           $ 1,662.44      $ 802.98     $ 859.45    $     -      $   153,313.09
         235           $ 1,662.44      $ 798.51     $ 863.93    $     -      $   152,449.16
         236           $ 1,662.44      $ 794.01     $ 868.43    $     -      $   151,580.73
         237           $ 1,662.44      $ 789.48     $ 872.95    $     -      $   150,707.78
         238           $ 1,662.44      $ 784.94     $ 877.50    $     -      $   149,830.28
         239           $ 1,662.44      $ 780.37     $ 882.07    $     -      $   148,948.21
         240           $ 1,662.44      $ 775.77     $ 886.66    $     -      $   148,061.54
         241           $ 1,662.44      $ 771.15     $ 891.28    $     -      $   147,170.26
         242           $ 1,662.44      $ 766.51     $ 895.92    $     -      $   146,274.34
         243           $ 1,662.44      $ 761.85     $ 900.59    $     -      $   145,373.75
         244           $ 1,662.44      $ 757.15     $ 905.28    $     -      $   144,468.46
         245           $ 1,662.44      $ 752.44     $ 910.00    $     -      $   143,558.47
         246           $ 1,662.44      $ 747.70     $ 914.74    $     -      $   142,643.73
         247           $ 1,662.44      $ 742.94     $ 919.50    $     -      $   141,724.23
         248           $ 1,662.44      $ 738.15     $ 924.29    $     -      $   140,799.94
         249           $ 1,662.44      $ 733.33     $ 929.10    $     -      $   139,870.84
         250           $ 1,662.44      $ 728.49     $ 933.94    $     -      $   138,936.90
         251           $ 1,662.44      $ 723.63     $ 938.81    $     -      $   137,998.09
         252           $ 1,662.44      $ 718.74     $ 943.70    $     -      $   137,054.39
         253           $ 1,662.44      $ 713.82     $ 948.61    $     -      $   136,105.78
         254           $ 1,662.44      $ 708.88     $ 953.55    $     -      $   135,152.23
         255           $ 1,662.44      $ 703.92     $ 958.52    $     -      $   134,193.71
         256           $ 1,662.44      $ 698.93     $ 963.51    $     -      $   133,230.20
         257           $ 1,662.44      $ 693.91     $ 968.53    $     -      $   132,261.67
         258           $ 1,662.44      $ 688.86     $ 973.57    $     -      $   131,288.10
         259           $ 1,662.44      $ 683.79     $ 978.64    $     -      $   130,309.45
         260           $ 1,662.44      $ 678.70     $ 983.74    $     -      $   129,325.71
         261           $ 1,662.44      $ 673.57     $ 988.87    $     -      $   128,336.85
         262           $ 1,662.44      $ 668.42     $ 994.02    $     -      $   127,342.83
         263           $ 1,662.44      $ 663.24     $ 999.19    $     -      $   126,343.64
         264           $ 1,662.44      $ 658.04     $1,004.40   $     -      $   125,339.24
         265           $ 1,662.44      $ 652.81     $1,009.63   $     -      $   124,329.61
         266           $ 1,662.44      $ 647.55     $1,014.89   $     -      $   123,314.73
         267           $ 1,662.44      $ 642.26     $1,020.17   $     -      $   122,294.55
         268           $ 1,662.44      $ 636.95     $1,025.49   $     -      $   121,269.07
         269           $ 1,662.44      $ 631.61     $1,030.83   $     -      $   120,238.24
         270           $ 1,662.44      $ 626.24     $1,036.20   $     -      $   119,202.05
         271           $ 1,662.44      $ 620.84     $1,041.59   $     -      $   118,160.45
         272           $ 1,662.44      $ 615.42     $1,047.02   $     -      $   117,113.44
         273           $ 1,662.44      $ 609.97     $1,052.47   $     -      $   116,060.97
         274           $ 1,662.44      $ 604.48     $1,057.95   $     -      $   115,003.01
         275           $ 1,662.44      $ 598.97     $1,063.46   $     -      $   113,939.55
         276           $ 1,662.44      $ 593.44     $1,069.00   $     -      $   112,870.55
         277           $ 1,662.44      $ 587.87     $1,074.57   $     -      $   111,795.98
         278           $ 1,662.44      $ 582.27     $1,080.17   $     -      $   110,715.82
         279           $ 1,662.44      $ 576.64     $1,085.79   $     -      $   109,630.02
         280           $ 1,662.44      $ 570.99     $1,091.45   $     -      $   108,538.58
         281           $ 1,662.44      $ 565.31     $1,097.13   $     -      $   107,441.45
         282           $ 1,662.44      $ 559.59     $1,102.85   $     -      $   106,338.60
         283           $ 1,662.44      $ 553.85     $1,108.59   $     -      $   105,230.01
         284           $ 1,662.44      $ 548.07     $1,114.36   $     -      $   104,115.65
         285           $ 1,662.44      $ 542.27     $1,120.17   $     -      $   102,995.48
         286           $ 1,662.44      $ 536.43     $1,126.00   $     -      $   101,869.48
         287           $ 1,662.44      $ 530.57     $1,131.87   $     -      $   100,737.61
         288           $ 1,662.44      $ 524.68     $1,137.76   $     -      $    99,599.85
         289           $ 1,662.44      $ 518.75     $1,143.69   $     -      $    98,456.16
         290           $ 1,662.44      $ 512.79     $1,149.64   $     -      $    97,306.52
         291           $ 1,662.44      $ 506.80     $1,155.63   $     -      $    96,150.89
         292           $ 1,662.44      $ 500.79     $1,161.65   $     -      $    94,989.24
         293           $ 1,662.44      $ 494.74     $1,167.70   $     -      $    93,821.54
         294           $ 1,662.44      $ 488.65     $1,173.78   $     -      $    92,647.75
         295           $ 1,662.44      $ 482.54     $1,179.90   $     -      $    91,467.86
         296           $ 1,662.44      $ 476.40     $1,186.04   $     -      $    90,281.82
         297           $ 1,662.44      $ 470.22     $1,192.22   $     -      $    89,089.60
         298           $ 1,662.44      $ 464.01     $1,198.43   $     -      $    87,891.17
         299           $ 1,662.44      $ 457.77     $1,204.67   $     -      $    86,686.50
         300           $ 1,662.44      $ 451.49     $1,210.94   $     -      $    85,475.56
         301           $ 1,662.44      $ 445.19     $1,217.25   $     -      $    84,258.30
         302           $ 1,662.44      $ 438.85     $1,223.59   $     -      $    83,034.71
         303           $ 1,662.44      $ 432.47     $1,229.96   $     -      $    81,804.75
         304           $ 1,662.44      $ 426.07     $1,236.37   $     -      $    80,568.38
         305           $ 1,662.44      $ 419.63     $1,242.81   $     -      $    79,325.57
         306           $ 1,662.44      $ 413.15     $1,249.28   $     -      $    78,076.29
         307           $ 1,662.44      $ 406.65     $1,255.79   $     -      $    76,820.50
         308           $ 1,662.44      $ 400.11     $1,262.33   $     -      $    75,558.17
         309           $ 1,662.44      $ 393.53     $1,268.90   $     -      $    74,289.26
         310           $ 1,662.44      $ 386.92     $1,275.51   $     -      $    73,013.75
         311           $ 1,662.44      $ 380.28     $1,282.16   $     -      $    71,731.59
         312           $ 1,662.44      $ 373.60     $1,288.83   $     -      $    70,442.76
         313           $ 1,662.44      $ 366.89     $1,295.55   $     -      $    69,147.21
         314           $ 1,662.44      $ 360.14     $1,302.29   $     -      $    67,844.92
         315           $ 1,662.44      $ 353.36     $1,309.08   $     -      $    66,535.84
         316           $ 1,662.44      $ 346.54     $1,315.90   $     -      $    65,219.94
         317           $ 1,662.44      $ 339.69     $1,322.75   $     -      $    63,897.20
         318           $ 1,662.44      $ 332.80     $1,329.64   $     -      $    62,567.56
         319           $ 1,662.44      $ 325.87     $1,336.56   $     -      $    61,230.99
         320           $ 1,662.44      $ 318.91     $1,343.53   $     -      $    59,887.47
         321           $ 1,662.44      $ 311.91     $1,350.52   $     -      $    58,536.95
         322           $ 1,662.44      $ 304.88     $1,357.56   $     -      $    57,179.39
         323           $ 1,662.44      $ 297.81     $1,364.63   $     -      $    55,814.76
         324           $ 1,662.44      $ 290.70     $1,371.73   $     -      $    54,443.03
         325           $ 1,662.44      $ 283.56     $1,378.88   $     -      $    53,064.15
         326           $ 1,662.44      $ 276.38     $1,386.06   $     -      $    51,678.09
         327           $ 1,662.44      $ 269.16     $1,393.28   $     -      $    50,284.81
         328           $ 1,662.44      $ 261.90     $1,400.54   $     -      $    48,884.27
         329           $ 1,662.44      $ 254.61     $1,407.83   $     -      $    47,476.44
         330           $ 1,662.44      $ 247.27     $1,415.16   $     -      $    46,061.28
         331           $ 1,662.44      $ 239.90     $1,422.53   $     -      $    44,638.74
         332           $ 1,662.44      $ 232.49     $1,429.94   $     -      $    43,208.80
         333           $ 1,662.44      $ 225.05     $1,437.39   $     -      $    41,771.41
         334           $ 1,662.44      $ 217.56     $1,444.88   $     -      $    40,326.53
         335           $ 1,662.44      $ 210.03     $1,452.40   $     -      $    38,874.13
         336           $ 1,662.44      $ 202.47     $1,459.97   $     -      $    37,414.16
         337           $ 1,662.44      $ 194.87     $1,467.57   $     -      $    35,946.59
         338           $ 1,662.44      $ 187.22     $1,475.21   $     -      $    34,471.38
         339           $ 1,662.44      $ 179.54     $1,482.90   $     -      $    32,988.48
         340           $ 1,662.44      $ 171.82     $1,490.62   $     -      $    31,497.86
         341           $ 1,662.44      $ 164.05     $1,498.39   $     -      $    29,999.47
         342           $ 1,662.44      $ 156.25     $1,506.19   $     -      $    28,493.28
         343           $ 1,662.44      $ 148.40     $1,514.03   $     -      $    26,979.25
         344           $ 1,662.44      $ 140.52     $1,521.92   $     -      $    25,457.33
         345           $ 1,662.44      $ 132.59     $1,529.85   $     -      $    23,927.48
         346           $ 1,662.44      $ 124.62     $1,537.81   $     -      $    22,389.67
         347           $ 1,662.44      $ 116.61     $1,545.82   $     -      $    20,843.85
         348           $ 1,662.44      $ 108.56     $1,553.87   $     -      $    19,289.97
         349           $ 1,662.44      $ 100.47     $1,561.97   $     -      $    17,728.00
         350           $ 1,662.44      $ 92.33      $1,570.10   $     -      $    16,157.90
         351           $ 1,662.44      $ 84.16      $1,578.28   $     -      $    14,579.62
         352           $ 1,662.44      $ 75.94      $1,586.50   $     -      $    12,993.12
         353           $ 1,662.44      $ 67.67      $1,594.76   $     -      $    11,398.36
         354           $ 1,662.44      $ 59.37      $1,603.07   $     -      $     9,795.29
         355           $ 1,662.44      $ 51.02      $1,611.42   $     -      $     8,183.87
         356           $ 1,662.44      $ 42.62      $1,619.81   $     -      $     6,564.05
         357           $ 1,662.44      $ 34.19      $1,628.25   $     -      $     4,935.81
         358           $ 1,662.44      $ 25.71      $1,636.73   $     -      $     3,299.08
         359           $ 1,662.44      $ 17.18      $1,645.25   $     -      $     1,653.82
         360           $ 1,653.82      $     8.61   $1,645.21   $     -      $          -
Month   Interest   Principal        Balance
   0         0           0     $   270,000
   1      1406         256     $   269,744                                                          Loan Amortization
   2      1405         258     $   269,486
   3      1404         259     $   269,227                            $300,000




                                              Outstanding Balance
   4      1402         260     $   268,967                            $250,000
   5      1401         262     $   268,706                            $200,000
   6      1400         263     $   268,443
                                                                      $150,000
   7      1398         264     $   268,178
   8      1397         266     $   267,913                            $100,000
   9      1395         267     $   267,646                             $50,000
  10      1394         268     $   267,377                                     $-
  11      1393         270     $   267,107                                           1        29   57   85 113 141 169 197 225 253 281
  12      1391         271     $   266,836
                                                                                                                   Months
  13      1390         273     $   266,563
  14      1388         274     $   266,289
  15      1387         276     $   266,014
  16      1385         277     $   265,737                                     Loan Amortization: % Interest & Principal
  17      1384         278     $   265,459
  18      1383         280     $   265,179
                                                                    100%
  19      1381         281     $   264,897                           90%
  20      1380         283     $   264,615                           80%
  21      1378         284     $   264,330                           70%                                                Principal
                                                                     60%
  22      1377         286     $   264,045                           50%
  23      1375         287     $   263,757                           40%
  24      1374         289     $   263,469                           30%
  25      1372         290     $   263,179
                                                                     20%                           Interest
                                                                     10%
  26      1371         292     $   262,887                            0%
  27      1369         293     $   262,594                                 1    26       51    76 101 126 151 176 201 226 251 276 301
  28      1368         295     $   262,299                                                                     Months
  29      1366         296     $   262,003
  30      1365         298     $   261,705
  31      1363         299     $   261,405
  32      1361         301     $   261,104
  33      1360         303     $   260,802
  34      1358         304     $   260,498
  35      1357         306     $   260,192
  36      1355         307     $   259,885
  37      1354         309     $   259,576
  38      1352         310     $   259,266
  39      1350         312     $   258,953
  40      1349         314     $   258,640
  41      1347         315     $   258,324
  42      1345         317     $   258,007
  43      1344         319     $   257,689
  44      1342         320     $   257,368
  45      1340         322     $   257,046
  46      1339         324     $   256,723
  47      1337         325     $   256,397
  48      1335         327     $   256,070
49   1334   329   $   255,742
50   1332   330   $   255,411
51   1330   332   $   255,079
52   1329   334   $   254,745
53   1327   336   $   254,409
54   1325   337   $   254,072
55   1323   339   $   253,733
56   1322   341   $   253,392
57   1320   343   $   253,049
58   1318   344   $   252,705
59   1316   346   $   252,359
60   1314   348   $   252,011
61   1313   350   $   251,661
62   1311   352   $   251,309
63   1309   354   $   250,955
64   1307   355   $   250,600
65   1305   357   $   250,243
66   1303   359   $   249,884
67   1301   361   $   249,523
68   1300   363   $   249,160
69   1298   365   $   248,795
70   1296   367   $   248,429
71   1294   369   $   248,060
72   1292   370   $   247,690
73   1290   372   $   247,317
74   1288   374   $   246,943
75   1286   376   $   246,567
76   1284   378   $   246,188
77   1282   380   $   245,808
78   1280   382   $   245,426
79   1278   384   $   245,042
80   1276   386   $   244,656
81   1274   388   $   244,267
82   1272   390   $   243,877
83   1270   392   $   243,485
84   1268   394   $   243,091
85   1266   396   $   242,694
86   1264   398   $   242,296
87   1262   400   $   241,895
88   1260   403   $   241,493
89   1258   405   $   241,088
90   1256   407   $   240,681
91   1254   409   $   240,273
92   1251   411   $   239,862
93   1249   413   $   239,448
94   1247   415   $   239,033
95   1245   417   $   238,616
96   1243   420   $   238,196
97   1241   422   $   237,774
98   1238   424   $   237,350
 99   1236   426   $   236,924
100   1234   428   $   236,495
101   1232   431   $   236,065
102   1230   433   $   235,632
103   1227   435   $   235,197
104   1225   437   $   234,759
105   1223   440   $   234,319
106   1220   442   $   233,877
107   1218   444   $   233,433
108   1216   447   $   232,986
109   1213   449   $   232,537
110   1211   451   $   232,086
111   1209   454   $   231,633
112   1206   456   $   231,177
113   1204   458   $   230,718
114   1202   461   $   230,257
115   1199   463   $   229,794
116   1197   466   $   229,329
117   1194   468   $   228,861
118   1192   470   $   228,390
119   1190   473   $   227,917
120   1187   475   $   227,442
121   1185   478   $   226,964
122   1182   480   $   226,484
123   1180   483   $   226,001
124   1177   485   $   225,515
125   1175   488   $   225,028
126   1172   490   $   224,537
127   1169   493   $   224,044
128   1167   496   $   223,549
129   1164   498   $   223,051
130   1162   501   $   222,550
131   1159   503   $   222,047
132   1156   506   $   221,541
133   1154   509   $   221,032
134   1151   511   $   220,521
135   1149   514   $   220,007
136   1146   517   $   219,490
137   1143   519   $   218,971
138   1140   522   $   218,449
139   1138   525   $   217,924
140   1135   527   $   217,397
141   1132   530   $   216,867
142   1130   533   $   216,334
143   1127   536   $   215,798
144   1124   538   $   215,260
145   1121   541   $   214,718
146   1118   544   $   214,174
147   1115   547   $   213,627
148   1113   550   $   213,078
149   1110   553   $   212,525
150   1107   556   $   211,969
151   1104   558   $   211,411
152   1101   561   $   210,850
153   1098   564   $   210,285
154   1095   567   $   209,718
155   1092   570   $   209,148
156   1089   573   $   208,575
157   1086   576   $   207,999
158   1083   579   $   207,420
159   1080   582   $   206,838
160   1077   585   $   206,252
161   1074   588   $   205,664
162   1071   591   $   205,073
163   1068   594   $   204,479
164   1065   597   $   203,881
165   1062   601   $   203,281
166   1059   604   $   202,677
167   1056   607   $   202,070
168   1052   610   $   201,460
169   1049   613   $   200,847
170   1046   616   $   200,231
171   1043   620   $   199,611
172   1040   623   $   198,988
173   1036   626   $   198,362
174   1033   629   $   197,733
175   1030   633   $   197,100
176   1027   636   $   196,464
177   1023   639   $   195,825
178   1020   643   $   195,183
179   1017   646   $   194,537
180   1013   649   $   193,888
181   1010   653   $   193,235
182   1006   656   $   192,579
183   1003   659   $   191,920
184   1000   663   $   191,257
185    996   666   $   190,590
186    993   670   $   189,921
187    989   673   $   189,247
188    986   677   $   188,571
189    982   680   $   187,890
190    979   684   $   187,206
191    975   687   $   186,519
192    971   691   $   185,828
193    968   695   $   185,133
194    964   698   $   184,435
195    961   702   $   183,733
196    957   705   $   183,028
197    953   709   $   182,319
198    950   713   $   181,606
199   946   717   $   180,889
200   942   720   $   180,169
201   938   724   $   179,445
202   935   728   $   178,717
203   931   732   $   177,986
204   927   735   $   177,250
205   923   739   $   176,511
206   919   743   $   175,768
207   915   747   $   175,021
208   912   751   $   174,270
209   908   755   $   173,515
210   904   759   $   172,756
211   900   763   $   171,994
212   896   767   $   171,227
213   892   771   $   170,456
214   888   775   $   169,682
215   884   779   $   168,903
216   880   783   $   168,120
217   876   787   $   167,334
218   872   791   $   166,543
219   867   795   $   165,748
220   863   799   $   164,948
221   859   803   $   164,145
222   855   808   $   163,338
223   851   812   $   162,526
224   846   816   $   161,710
225   842   820   $   160,890
226   838   824   $   160,065
227   834   829   $   159,237
228   829   833   $   158,403
229   825   837   $   157,566
230   821   842   $   156,724
231   816   846   $   155,878
232   812   851   $   155,028
233   807   855   $   154,173
234   803   859   $   153,313
235   799   864   $   152,449
236   794   868   $   151,581
237   789   873   $   150,708
238   785   878   $   149,830
239   780   882   $   148,948
240   776   887   $   148,062
241   771   891   $   147,170
242   767   896   $   146,274
243   762   901   $   145,374
244   757   905   $   144,468
245   752   910   $   143,558
246   748   915   $   142,644
247   743   920   $   141,724
248   738   924   $   140,800
249   733    929   $   139,871
250   728    934   $   138,937
251   724    939   $   137,998
252   719    944   $   137,054
253   714    949   $   136,106
254   709    954   $   135,152
255   704    959   $   134,194
256   699    964   $   133,230
257   694    969   $   132,262
258   689    974   $   131,288
259   684    979   $   130,309
260   679    984   $   129,326
261   674    989   $   128,337
262   668    994   $   127,343
263   663    999   $   126,344
264   658   1004   $   125,339
265   653   1010   $   124,330
266   648   1015   $   123,315
267   642   1020   $   122,295
268   637   1025   $   121,269
269   632   1031   $   120,238
270   626   1036   $   119,202
271   621   1042   $   118,160
272   615   1047   $   117,113
273   610   1052   $   116,061
274   604   1058   $   115,003
275   599   1063   $   113,940
276   593   1069   $   112,871
277   588   1075   $   111,796
278   582   1080   $   110,716
279   577   1086   $   109,630
280   571   1091   $   108,539
281   565   1097   $   107,441
282   560   1103   $   106,339
283   554   1109   $   105,230
284   548   1114   $   104,116
285   542   1120   $   102,995
286   536   1126   $   101,869
287   531   1132   $   100,738
288   525   1138   $    99,600
289   519   1144   $    98,456
290   513   1150   $    97,307
291   507   1156   $    96,151
292   501   1162   $    94,989
293   495   1168   $    93,822
294   489   1174   $    92,648
295   483   1180   $    91,468
296   476   1186   $    90,282
297   470   1192   $    89,090
298   464   1198   $    87,891
299   458   1205   $   86,686
300   451   1211   $   85,476
301   445   1217   $   84,258
302   439   1224   $   83,035
303   432   1230   $   81,805
304   426   1236   $   80,568
305   420   1243   $   79,326
306   413   1249   $   78,076
307   407   1256   $   76,820
308   400   1262   $   75,558
309   394   1269   $   74,289
310   387   1276   $   73,014
311   380   1282   $   71,732
312   374   1289   $   70,443
313   367   1296   $   69,147
314   360   1302   $   67,845
315   353   1309   $   66,536
316   347   1316   $   65,220
317   340   1323   $   63,897
318   333   1330   $   62,568
319   326   1337   $   61,231
320   319   1344   $   59,887
321   312   1351   $   58,537
322   305   1358   $   57,179
323   298   1365   $   55,815
324   291   1372   $   54,443
325   284   1379   $   53,064
326   276   1386   $   51,678
327   269   1393   $   50,285
328   262   1401   $   48,884
329   255   1408   $   47,476
330   247   1415   $   46,061
331   240   1423   $   44,639
332   232   1430   $   43,209
333   225   1437   $   41,771
334   218   1445   $   40,327
335   210   1452   $   38,874
336   202   1460   $   37,414
337   195   1468   $   35,947
338   187   1475   $   34,471
339   180   1483   $   32,988
340   172   1491   $   31,498
341   164   1498   $   29,999
342   156   1506   $   28,493
343   148   1514   $   26,979
344   141   1522   $   25,457
345   133   1530   $   23,927
346   125   1538   $   22,390
347   117   1546   $   20,844
348   109   1554   $   19,290
349   100   1562   $   17,728
350    92   1570   $   16,158
351    84   1578   $   14,580
352    76   1587   $   12,993
353    68   1595   $   11,398
354    59   1603   $    9,795
355    51   1611   $    8,184
356    43   1620   $    6,564
357    34   1628   $    4,936
358    26   1637   $    3,299
359    17   1645   $    1,654
360     9   1645   $      -
281 309 337




 301 326 351

								
To top