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