home *** CD-ROM | disk | FTP | other *** search
/ Shareware Overload / ShartewareOverload.cdr / finance / amortize.zip / AMORTIZE.RPT < prev    next >
Text File  |  1991-02-10  |  20KB  |  312 lines
  1.  
  2.  
  3.  
  4.  
  5.  
  6.  
  7.  
  8.  
  9.  
  10.                  =============================================
  11.  
  12.                              AMORTIZATION SCHEDULE
  13.  
  14.  
  15.  
  16.  
  17.  
  18.                  For:                            Any Name Here
  19.  
  20.                  Property :                 NOTE: Rate Changes
  21.                  Address :             Reduces Affect of Extra
  22.                  City, State, Zip :               Payments!!!!
  23.  
  24.                  Original Loan Amount :             145,000.00
  25.                  Initial Interest Rate :                 10.50
  26.                  Term of Loan :                            180
  27.                  Payments in                           Arrears
  28.                  Payment Period :                      Monthly
  29.                  Compounding Period :                  Monthly
  30.                  Display Year:                        Calendar
  31.                  Amortization Method:                   Normal
  32.                  Days Per Year:                            360
  33.  
  34.                  =============================================
  35.  
  36.  
  37.  
  38.  
  39.  
  40.  
  41.  
  42.  
  43.  
  44.  
  45.  
  46.  
  47.  
  48.  
  49.  
  50.  
  51.  
  52.                   Prepared By :                    I. M. Smart
  53.   Any Name Here                                                                       Page  1
  54.  
  55.                                                                      Remaining
  56.   Per/Yr     Date         Payment      Principal       Interest        Balance  ____________________________________________________________________________
  57.     1/ 1    1/30/91      1,602.83         334.08       1,268.75     144,665.92
  58.     2/ 1    3/02/91      1,602.83         337.00       1,265.83     144,328.92
  59.     3/ 1    4/02/91      1,602.83         339.95       1,262.88     143,988.97
  60.     4/ 1    5/02/91      1,602.83         342.93       1,259.90     143,646.04
  61.   Extra Payment:           500.00
  62.     5/ 1    6/02/91      2,102.83         845.93       1,256.90     142,800.11
  63.     6/ 1    7/02/91      1,602.83         353.33       1,249.50     142,446.78
  64.     7/ 1    8/02/91      1,602.83         356.42       1,246.41     142,090.36
  65.     8/ 1    9/02/91      1,602.83         359.54       1,243.29     141,730.82
  66.     9/ 1   10/02/91      1,602.83         362.69       1,240.14     141,368.13
  67.    10/ 1   11/02/91      1,602.83         365.86       1,236.97     141,002.27
  68.    11/ 1   12/02/91      1,602.83         369.06       1,233.77     140,633.21
  69.   Extra Payment:         1,000.00
  70.    12/ 1    1/02/92      2,602.83       1,372.29       1,230.54     139,260.92
  71.   YTD TOTALS:           20,733.96       5,739.08      14,994.88     139,260.92
  72.   RUNNING TOTALS:       20,733.96       5,739.08      14,994.88
  73.  
  74.   Rate:       10.75%
  75.   Extra Payment:           200.00
  76.    13/ 2    2/02/92      1,806.64         559.09       1,247.55     138,701.83
  77.    14/ 2    3/02/92      1,606.64         364.10       1,242.54     138,337.73
  78.    15/ 2    4/02/92      1,606.64         367.36       1,239.28     137,970.37
  79.    16/ 2    5/02/92      1,606.64         370.66       1,235.98     137,599.71
  80.   Extra Payment:           200.00
  81.    17/ 2    6/02/92      1,806.64         573.98       1,232.66     137,025.73
  82.    18/ 2    7/02/92      1,606.64         379.12       1,227.52     136,646.61
  83.    19/ 2    8/02/92      1,606.64         382.51       1,224.13     136,264.10
  84.    20/ 2    9/02/92      1,606.64         385.94       1,220.70     135,878.16
  85.    21/ 2   10/02/92      1,606.64         389.40       1,217.24     135,488.76
  86.    22/ 2   11/02/92      1,606.64         392.89       1,213.75     135,095.87
  87.    23/ 2   12/02/92      1,606.64         396.41       1,210.23     134,699.46
  88.    24/ 2    1/02/93      1,606.64         399.96       1,206.68     134,299.50
  89.   YTD TOTALS:           19,679.68       4,961.42      14,718.26     134,299.50
  90.   RUNNING TOTALS:       40,413.64      10,700.50      29,713.14
  91.  
  92.   Rate:       11.00%
  93.   Extra Payment:         1,200.00
  94.    25/ 3    2/02/93      2,821.71       1,590.63       1,231.08     132,708.87
  95.    26/ 3    3/02/93      1,621.71         405.21       1,216.50     132,303.66
  96.    27/ 3    4/02/93      1,621.71         408.93       1,212.78     131,894.73
  97.    28/ 3    5/02/93      1,621.71         412.67       1,209.04     131,482.06
  98.    29/ 3    6/02/93      1,621.71         416.46       1,205.25     131,065.60
  99.    30/ 3    7/02/93      1,621.71         420.28       1,201.43     130,645.32
  100.    31/ 3    8/02/93      1,621.71         424.13       1,197.58     130,221.19
  101.    32/ 3    9/02/93      1,621.71         428.02       1,193.69     129,793.17
  102.    33/ 3   10/02/93      1,621.71         431.94       1,189.77     129,361.23
  103.    34/ 3   11/02/93      1,621.71         435.90       1,185.81     128,925.33
  104.    35/ 3   12/02/93      1,621.71         439.89       1,181.82     128,485.44
  105.    36/ 3    1/02/94      1,621.71         443.93       1,177.78     128,041.51
  106.   YTD TOTALS:           20,660.52       6,257.99      14,402.53     128,041.51
  107.   RUNNING TOTALS:       61,074.16      16,958.49      44,115.67
  108.  
  109.   Rate:       10.50%
  110.    37/ 4    2/02/94      1,567.41         447.05       1,120.36     127,594.46
  111.   Any Name Here                                                                       Page  2
  112.  
  113.                                                                      Remaining
  114.   Per/Yr     Date         Payment      Principal       Interest        Balance  ____________________________________________________________________________
  115.    38/ 4    3/02/94      1,567.41         450.96       1,116.45     127,143.50
  116.    39/ 4    4/02/94      1,567.41         454.90       1,112.51     126,688.60
  117.    40/ 4    5/02/94      1,567.41         458.88       1,108.53     126,229.72
  118.    41/ 4    6/02/94      1,567.41         462.90       1,104.51     125,766.82
  119.    42/ 4    7/02/94      1,567.41         466.95       1,100.46     125,299.87
  120.    43/ 4    8/02/94      1,567.41         471.04       1,096.37     124,828.83
  121.    44/ 4    9/02/94      1,567.41         475.16       1,092.25     124,353.67
  122.    45/ 4   10/02/94      1,567.41         479.32       1,088.09     123,874.35
  123.    46/ 4   11/02/94      1,567.41         483.51       1,083.90     123,390.84
  124.    47/ 4   12/02/94      1,567.41         487.74       1,079.67     122,903.10
  125.    48/ 4    1/02/95      1,567.41         492.01       1,075.40     122,411.09
  126.   YTD TOTALS:           18,808.92       5,630.42      13,178.50     122,411.09
  127.   RUNNING TOTALS:       79,883.08      22,588.91      57,294.17
  128.  
  129.   Rate:        9.87%
  130.    49/ 5    2/02/95      1,523.93         516.59       1,007.34     121,894.50
  131.    50/ 5    3/02/95      1,523.93         520.84       1,003.09     121,373.66
  132.    51/ 5    4/02/95      1,523.93         525.13         998.80     120,848.53
  133.    52/ 5    5/02/95      1,523.93         529.45         994.48     120,319.08
  134.    53/ 5    6/02/95      1,523.93         533.80         990.13     119,785.28
  135.    54/ 5    7/02/95      1,523.93         538.20         985.73     119,247.08
  136.    55/ 5    8/02/95      1,523.93         542.63         981.30     118,704.45
  137.    56/ 5    9/02/95      1,523.93         547.09         976.84     118,157.36
  138.    57/ 5   10/02/95      1,523.93         551.59         972.34     117,605.77
  139.    58/ 5   11/02/95      1,523.93         556.13         967.80     117,049.64
  140.    59/ 5   12/02/95      1,523.93         560.71         963.22     116,488.93
  141.    60/ 5    1/02/96      1,523.93         565.32         958.61     115,923.61
  142.   YTD TOTALS:           18,287.16       6,487.48      11,799.68     115,923.61
  143.   RUNNING TOTALS:       98,170.24      29,076.39      69,093.85
  144.  
  145.   Rate:       10.50%
  146.    61/ 6    2/02/96      1,564.22         549.89       1,014.33     115,373.72
  147.    62/ 6    3/02/96      1,564.22         554.70       1,009.52     114,819.02
  148.    63/ 6    4/02/96      1,564.22         559.55       1,004.67     114,259.47
  149.    64/ 6    5/02/96      1,564.22         564.45         999.77     113,695.02
  150.    65/ 6    6/02/96      1,564.22         569.39         994.83     113,125.63
  151.    66/ 6    7/02/96      1,564.22         574.37         989.85     112,551.26
  152.    67/ 6    8/02/96      1,564.22         579.40         984.82     111,971.86
  153.    68/ 6    9/02/96      1,564.22         584.47         979.75     111,387.39
  154.    69/ 6   10/02/96      1,564.22         589.58         974.64     110,797.81
  155.    70/ 6   11/02/96      1,564.22         594.74         969.48     110,203.07
  156.    71/ 6   12/02/96      1,564.22         599.94         964.28     109,603.13
  157.    72/ 6    1/02/97      1,564.22         605.19         959.03     108,997.94
  158.   YTD TOTALS:           18,770.64       6,925.67      11,844.97     108,997.94
  159.   RUNNING TOTALS:      116,940.88      36,002.06      80,938.82
  160.  
  161.   Rate:       10.33%
  162.    73/ 7    2/02/97      1,554.29         615.70         938.59     108,382.24
  163.    74/ 7    3/02/97      1,554.29         621.00         933.29     107,761.24
  164.    75/ 7    4/02/97      1,554.29         626.35         927.94     107,134.89
  165.    76/ 7    5/02/97      1,554.29         631.74         922.55     106,503.15
  166.    77/ 7    6/02/97      1,554.29         637.18         917.11     105,865.97
  167.    78/ 7    7/02/97      1,554.29         642.67         911.62     105,223.30
  168.    79/ 7    8/02/97      1,554.29         648.20         906.09     104,575.10
  169.   Any Name Here                                                                       Page  3
  170.  
  171.                                                                      Remaining
  172.   Per/Yr     Date         Payment      Principal       Interest        Balance  ____________________________________________________________________________
  173.    80/ 7    9/02/97      1,554.29         653.79         900.50     103,921.31
  174.    81/ 7   10/02/97      1,554.29         659.41         894.88     103,261.90
  175.    82/ 7   11/02/97      1,554.29         665.09         889.20     102,596.81
  176.    83/ 7   12/02/97      1,554.29         670.82         883.47     101,925.99
  177.    84/ 7    1/02/98      1,554.29         676.60         877.69     101,249.39
  178.   YTD TOTALS:           18,651.48       7,748.55      10,902.93     101,249.39
  179.   RUNNING TOTALS:      135,592.36      43,750.61      91,841.75
  180.  
  181.   Rate:       10.50%
  182.    85/ 8    2/02/98      1,563.29         677.36         885.93     100,572.03
  183.    86/ 8    3/02/98      1,563.29         683.28         880.01      99,888.75
  184.    87/ 8    4/02/98      1,563.29         689.26         874.03      99,199.49
  185.    88/ 8    5/02/98      1,563.29         695.29         868.00      98,504.20
  186.    89/ 8    6/02/98      1,563.29         701.38         861.91      97,802.82
  187.    90/ 8    7/02/98      1,563.29         707.52         855.77      97,095.30
  188.    91/ 8    8/02/98      1,563.29         713.71         849.58      96,381.59
  189.    92/ 8    9/02/98      1,563.29         719.95         843.34      95,661.64
  190.    93/ 8   10/02/98      1,563.29         726.25         837.04      94,935.39
  191.    94/ 8   11/02/98      1,563.29         732.61         830.68      94,202.78
  192.    95/ 8   12/02/98      1,563.29         739.02         824.27      93,463.76
  193.    96/ 8    1/02/99      1,563.29         745.48         817.81      92,718.28
  194.   YTD TOTALS:           18,759.48       8,531.11      10,228.37      92,718.28
  195.   RUNNING TOTALS:      154,351.84      52,281.72     102,070.12
  196.  
  197.    97/ 9    2/02/99      1,563.29         752.01         811.28      91,966.27
  198.    98/ 9    3/02/99      1,563.29         758.59         804.70      91,207.68
  199.   Extra Payment:           750.00
  200.    99/ 9    4/02/99      2,313.29       1,515.22         798.07      89,692.46
  201.   100/ 9    5/02/99      1,563.29         778.48         784.81      88,913.98
  202.   101/ 9    6/02/99      1,563.29         785.29         778.00      88,128.69
  203.   102/ 9    7/02/99      1,563.29         792.16         771.13      87,336.53
  204.   103/ 9    8/02/99      1,563.29         799.10         764.19      86,537.43
  205.   104/ 9    9/02/99      1,563.29         806.09         757.20      85,731.34
  206.   105/ 9   10/02/99      1,563.29         813.14         750.15      84,918.20
  207.   Extra Payment:           400.00
  208.   106/ 9   11/02/99      1,963.29       1,220.26         743.03      83,697.94
  209.   107/ 9   12/02/99      1,563.29         830.93         732.36      82,867.01
  210.   108/ 9    1/02/00      1,563.29         838.20         725.09      82,028.81
  211.   YTD TOTALS:           19,909.48      10,689.47       9,220.01      82,028.81
  212.   RUNNING TOTALS:      174,261.32      62,971.19     111,290.13
  213.  
  214.   109/10    2/02/00      1,563.29         845.54         717.75      81,183.27
  215.   Extra Payment:           300.00
  216.   110/10    3/02/00      1,863.29       1,152.94         710.35      80,030.33
  217.   111/10    4/02/00      1,563.29         863.02         700.27      79,167.31
  218.   112/10    5/02/00      1,563.29         870.58         692.71      78,296.73
  219.   113/10    6/02/00      1,563.29         878.19         685.10      77,418.54
  220.   114/10    7/02/00      1,563.29         885.88         677.41      76,532.66
  221.   115/10    8/02/00      1,563.29         893.63         669.66      75,639.03
  222.   116/10    9/02/00      1,563.29         901.45         661.84      74,737.58
  223.   117/10   10/02/00      1,563.29         909.34         653.95      73,828.24
  224.   118/10   11/02/00      1,563.29         917.29         646.00      72,910.95
  225.   119/10   12/02/00      1,563.29         925.32         637.97      71,985.63
  226.   120/10    1/02/01      1,563.29         933.42         629.87      71,052.21
  227.   Any Name Here                                                                       Page  4
  228.  
  229.                                                                      Remaining
  230.   Per/Yr     Date         Payment      Principal       Interest        Balance  ____________________________________________________________________________
  231.   YTD TOTALS:           19,059.48      10,976.60       8,082.88      71,052.21
  232.   RUNNING TOTALS:      193,320.80      73,947.79     119,373.01
  233.  
  234.   121/11    2/02/01      1,563.29         941.58         621.71      70,110.63
  235.   122/11    3/02/01      1,563.29         949.82         613.47      69,160.81
  236.   123/11    4/02/01      1,563.29         958.13         605.16      68,202.68
  237.   124/11    5/02/01      1,563.29         966.52         596.77      67,236.16
  238.   125/11    6/02/01      1,563.29         974.97         588.32      66,261.19
  239.   126/11    7/02/01      1,563.29         983.50         579.79      65,277.69
  240.   127/11    8/02/01      1,563.29         992.11         571.18      64,285.58
  241.   128/11    9/02/01      1,563.29       1,000.79         562.50      63,284.79
  242.   129/11   10/02/01      1,563.29       1,009.55         553.74      62,275.24
  243.   130/11   11/02/01      1,563.29       1,018.38         544.91      61,256.86
  244.   131/11   12/02/01      1,563.29       1,027.29         536.00      60,229.57
  245.   132/11    1/02/02      1,563.29       1,036.28         527.01      59,193.29
  246.   YTD TOTALS:           18,759.48      11,858.92       6,900.56      59,193.29
  247.   RUNNING TOTALS:      212,080.28      85,806.71     126,273.57
  248.  
  249.   133/12    2/02/02      1,563.29       1,045.35         517.94      58,147.94
  250.   134/12    3/02/02      1,563.29       1,054.50         508.79      57,093.44
  251.   135/12    4/02/02      1,563.29       1,063.72         499.57      56,029.72
  252.   136/12    5/02/02      1,563.29       1,073.03         490.26      54,956.69
  253.   137/12    6/02/02      1,563.29       1,082.42         480.87      53,874.27
  254.   138/12    7/02/02      1,563.29       1,091.89         471.40      52,782.38
  255.   139/12    8/02/02      1,563.29       1,101.44         461.85      51,680.94
  256.   140/12    9/02/02      1,563.29       1,111.08         452.21      50,569.86
  257.   141/12   10/02/02      1,563.29       1,120.80         442.49      49,449.06
  258.   142/12   11/02/02      1,563.29       1,130.61         432.68      48,318.45
  259.   143/12   12/02/02      1,563.29       1,140.50         422.79      47,177.95
  260.   144/12    1/02/03      1,563.29       1,150.48         412.81      46,027.47
  261.   YTD TOTALS:           18,759.48      13,165.82       5,593.66      46,027.47
  262.   RUNNING TOTALS:      230,839.76      98,972.53     131,867.23
  263.  
  264.   145/13    2/02/03      1,563.29       1,160.55         402.74      44,866.92
  265.   146/13    3/02/03      1,563.29       1,170.70         392.59      43,696.22
  266.   147/13    4/02/03      1,563.29       1,180.95         382.34      42,515.27
  267.   148/13    5/02/03      1,563.29       1,191.28         372.01      41,323.99
  268.   149/13    6/02/03      1,563.29       1,201.71         361.58      40,122.28
  269.   150/13    7/02/03      1,563.29       1,212.22         351.07      38,910.06
  270.   151/13    8/02/03      1,563.29       1,222.83         340.46      37,687.23
  271.   152/13    9/02/03      1,563.29       1,233.53         329.76      36,453.70
  272.   153/13   10/02/03      1,563.29       1,244.32         318.97      35,209.38
  273.   154/13   11/02/03      1,563.29       1,255.21         308.08      33,954.17
  274.   155/13   12/02/03      1,563.29       1,266.19         297.10      32,687.98
  275.   156/13    1/02/04      1,563.29       1,277.27         286.02      31,410.71
  276.   YTD TOTALS:           18,759.48      14,616.76       4,142.72      31,410.71
  277.   RUNNING TOTALS:      249,599.24     113,589.29     136,009.95
  278.  
  279.   157/14    2/02/04      1,563.29       1,288.45         274.84      30,122.26
  280.   158/14    3/02/04      1,563.29       1,299.72         263.57      28,822.54
  281.   159/14    4/02/04      1,563.29       1,311.09         252.20      27,511.45
  282.   160/14    5/02/04      1,563.29       1,322.56         240.73      26,188.89
  283.   161/14    6/02/04      1,563.29       1,334.14         229.15      24,854.75
  284.   162/14    7/02/04      1,563.29       1,345.81         217.48      23,508.94
  285.   Any Name Here                                                                       Page  5
  286.  
  287.                                                                      Remaining
  288.   Per/Yr     Date         Payment      Principal       Interest        Balance  ____________________________________________________________________________
  289.   163/14    8/02/04      1,563.29       1,357.59         205.70      22,151.35
  290.   164/14    9/02/04      1,563.29       1,369.47         193.82      20,781.88
  291.   165/14   10/02/04      1,563.29       1,381.45         181.84      19,400.43
  292.   166/14   11/02/04      1,563.29       1,393.54         169.75      18,006.89
  293.   167/14   12/02/04      1,563.29       1,405.73         157.56      16,601.16
  294.   168/14    1/02/05      1,563.29       1,418.03         145.26      15,183.13
  295.   YTD TOTALS:           18,759.48      16,227.58       2,531.90      15,183.13
  296.   RUNNING TOTALS:      268,358.72     129,816.87     138,541.85
  297.  
  298.   169/15    2/02/05      1,563.29       1,430.44         132.85      13,752.69
  299.   170/15    3/02/05      1,563.29       1,442.95         120.34      12,309.74
  300.   171/15    4/02/05      1,563.29       1,455.58         107.71      10,854.16
  301.   172/15    5/02/05      1,563.29       1,468.32          94.97       9,385.84
  302.   173/15    6/02/05      1,563.29       1,481.16          82.13       7,904.68
  303.   174/15    7/02/05      1,563.29       1,494.12          69.17       6,410.56
  304.   175/15    8/02/05      1,563.29       1,507.20          56.09       4,903.36
  305.   176/15    9/02/05      1,563.29       1,520.39          42.90       3,382.97
  306.   177/15   10/02/05      1,563.29       1,533.69          29.60       1,849.28
  307.   178/15   11/02/05      1,563.29       1,547.11          16.18         302.17
  308.   179/15   12/02/05        304.81         302.17           2.64           0.00
  309.   YTD TOTALS:           15,937.71      15,183.13         754.58           0.00
  310.   RUNNING TOTALS:      284,296.43     145,000.00     139,296.43
  311.  
  312.