home *** CD-ROM | disk | FTP | other *** search
/ Gold Fish 1 / GoldFishApril1994_CD2.img / d4xx / d492 / loancalc / semi-monthly.data < prev    next >
Text File  |  1991-06-06  |  9KB  |  140 lines
  1.  TABLE FOR LOAN       :   Semi-Monthly           COMMENCED ON  : Aug 25, 1987
  2.  
  3.  OPENING PRINCIPAL    :   $100,000.00            AMORT. PERIOD :  60 months
  4.  
  5.  SEMI-MONTHLY PAYMENT :     $1,120.07            INTEREST RATE :   12.75 %
  6.  
  7. ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  8.  
  9.                  Am't  to         Total          Am't  off
  10.     Date         Interest        Interest        Principal        Balance
  11.     ----         --------        --------        ---------        -------
  12.  Sep  1, 1987     $516.33         $516.33          $603.74      $99,396.26
  13.  Sep 15, 1987     $513.21       $1,029.55          $606.86      $98,789.40
  14.  Oct  1, 1987     $510.08       $1,539.63          $609.99      $98,179.41
  15.  Oct 15, 1987     $506.93       $2,046.56          $613.14      $97,566.27
  16.  Nov  1, 1987     $503.77       $2,550.32          $616.31      $96,949.96
  17.  Nov 15, 1987     $500.58       $3,050.90          $619.49      $96,330.47
  18.  Dec  1, 1987     $497.38       $3,548.29          $622.69      $95,707.79
  19.  Dec 15, 1987     $494.17       $4,042.46          $625.90      $95,081.88
  20.  
  21.  Jan  1, 1988     $490.94       $4,533.40          $629.13      $94,452.75
  22.  Jan 15, 1988     $487.69       $5,021.08          $632.38      $93,820.37
  23.  Feb  1, 1988     $484.42       $5,505.51          $635.65      $93,184.72
  24.  Feb 15, 1988     $481.14       $5,986.65          $638.93      $92,545.79
  25.  Mar  1, 1988     $477.84       $6,464.49          $642.23      $91,903.56
  26.  Mar 15, 1988     $474.53       $6,939.02          $645.55      $91,258.01
  27.  Apr  1, 1988     $471.19       $7,410.21          $648.88      $90,609.13
  28.  Apr 15, 1988     $467.84       $7,878.06          $652.23      $89,956.91
  29.  May  1, 1988     $464.48       $8,342.53          $655.60      $89,301.31
  30.  May 15, 1988     $461.09       $8,803.62          $658.98      $88,642.33
  31.  Jun  1, 1988     $457.69       $9,261.31          $662.38      $87,979.94
  32.  Jun 15, 1988     $454.27       $9,715.58          $665.80      $87,314.14
  33.  Jul  1, 1988     $450.83      $10,166.41          $669.24      $86,644.90
  34.  Jul 15, 1988     $447.37      $10,613.78          $672.70      $85,972.20
  35.  Aug  1, 1988     $443.90      $11,057.68          $676.17      $85,296.03
  36.  Aug 15, 1988     $440.41      $11,498.09          $679.66      $84,616.37
  37.  Sep  1, 1988     $436.90      $11,935.00          $683.17      $83,933.20
  38.  Sep 15, 1988     $433.37      $12,368.37          $686.70      $83,246.50
  39.  Oct  1, 1988     $429.83      $12,798.20          $690.24      $82,556.25
  40.  Oct 15, 1988     $426.26      $13,224.46          $693.81      $81,862.45
  41.  Nov  1, 1988     $422.68      $13,647.14          $697.39      $81,165.06
  42.  Nov 15, 1988     $419.08      $14,066.22          $700.99      $80,464.06
  43.  Dec  1, 1988     $415.46      $14,481.68          $704.61      $79,759.45
  44.  Dec 15, 1988     $411.82      $14,893.51          $708.25      $79,051.20
  45.  
  46.                  Am't  to         Total          Am't  off
  47.     Date         Interest        Interest        Principal        Balance
  48.     ----         --------        --------        ---------        -------
  49.  
  50.  Jan  1, 1989     $408.17      $15,301.67          $711.91      $78,339.30
  51.  Jan 15, 1989     $404.49      $15,706.16          $715.58      $77,623.72
  52.  Feb  1, 1989     $400.80      $16,106.96          $719.28      $76,904.44
  53.  Feb 15, 1989     $397.08      $16,504.04          $722.99      $76,181.45
  54.  Mar  1, 1989     $393.35      $16,897.39          $726.72      $75,454.73
  55.  Mar 15, 1989     $389.60      $17,286.98          $730.48      $74,724.25
  56.  Apr  1, 1989     $385.82      $17,672.81          $734.25      $73,990.00
  57.  Apr 15, 1989     $382.03      $18,054.84          $738.04      $73,251.96
  58.  May  1, 1989     $378.22      $18,433.06          $741.85      $72,510.12
  59.  May 15, 1989     $374.39      $18,807.46          $745.68      $71,764.44
  60.  Jun  1, 1989     $370.54      $19,178.00          $749.53      $71,014.91
  61.  Jun 15, 1989     $366.67      $19,544.67          $753.40      $70,261.51
  62.  Jul  1, 1989     $362.78      $19,907.45          $757.29      $69,504.22
  63.  Jul 15, 1989     $358.87      $20,266.33          $761.20      $68,743.02
  64.  Aug  1, 1989     $354.94      $20,621.27          $765.13      $67,977.89
  65.  Aug 15, 1989     $350.99      $20,972.26          $769.08      $67,208.81
  66.  Aug 15, 1989           Lump Sum Payment of     $10,000.00
  67.                                        Remaining Principal      $57,208.81
  68.  Sep  1, 1989     $295.39      $21,267.64          $824.69      $56,384.12
  69.  Sep 15, 1989     $291.13      $21,558.77          $828.94      $55,555.18
  70.  Oct  1, 1989     $286.85      $21,845.62          $833.22      $54,721.95
  71.  Oct 15, 1989     $282.55      $22,128.17          $837.53      $53,884.43
  72.  Nov  1, 1989     $278.22      $22,406.39          $841.85      $53,042.58
  73.  Nov 15, 1989     $273.88      $22,680.27          $846.20      $52,196.38
  74.  Dec  1, 1989     $269.51      $22,949.77          $850.57      $51,345.82
  75.  Dec 15, 1989     $265.11      $23,214.89          $854.96      $50,490.86
  76.  
  77.  Jan  1, 1990     $260.70      $23,475.59          $859.37      $49,631.49
  78.  Jan 15, 1990     $256.26      $23,731.85          $863.81      $48,767.68
  79.  Feb  1, 1990     $251.80      $23,983.65          $868.27      $47,899.41
  80.  Feb 15, 1990     $247.32      $24,230.97          $872.75      $47,026.66
  81.  Mar  1, 1990     $242.81      $24,473.79          $877.26      $46,149.40
  82.  Mar 15, 1990     $238.28      $24,712.07          $881.79      $45,267.61
  83.  Apr  1, 1990     $233.73      $24,945.80          $886.34      $44,381.27
  84.  Apr 15, 1990     $229.15      $25,174.95          $890.92      $43,490.35
  85.  May  1, 1990     $224.55      $25,399.51          $895.52      $42,594.83
  86.  May 15, 1990     $219.93      $25,619.44          $900.14      $41,694.69
  87.  Jun  1, 1990     $215.28      $25,834.72          $904.79      $40,789.90
  88.  Jun 15, 1990     $210.61      $26,045.33          $909.46      $39,880.44
  89.  Jul  1, 1990     $205.92      $26,251.25          $914.16      $38,966.29
  90.  Jul 15, 1990     $201.20      $26,452.44          $918.88      $38,047.41
  91.  Aug  1, 1990     $196.45      $26,648.89          $923.62      $37,123.79
  92.  Aug 15, 1990     $191.68      $26,840.58          $928.39      $36,195.40
  93.  Sep  1, 1990     $186.89      $27,027.46          $933.18      $35,262.21
  94.  Sep 15, 1990     $182.07      $27,209.53          $938.00      $34,324.21
  95.  Oct  1, 1990     $177.23      $27,386.76          $942.85      $33,381.37
  96.  Oct 15, 1990     $172.36      $27,559.12          $947.71      $32,433.65
  97.  Nov  1, 1990     $167.47      $27,726.58          $952.61      $31,481.05
  98.  Nov 15, 1990     $162.55      $27,889.13          $957.53      $30,523.52
  99.  Dec  1, 1990     $157.60      $28,046.73          $962.47      $29,561.05
  100.  Dec 15, 1990     $152.63      $28,199.37          $967.44      $28,593.61
  101.  
  102.                  Am't  to         Total          Am't  off
  103.     Date         Interest        Interest        Principal        Balance
  104.     ----         --------        --------        ---------        -------
  105.  
  106.  Jan  1, 1991     $147.64      $28,347.00          $972.43      $27,621.18
  107.  Jan 15, 1991     $142.62      $28,489.62          $977.46      $26,643.72
  108.  Feb  1, 1991     $137.57      $28,627.19          $982.50      $25,661.22
  109.  Feb 15, 1991     $132.50      $28,759.69          $987.58      $24,673.64
  110.  Mar  1, 1991     $127.40      $28,887.08          $992.67      $23,680.97
  111.  Mar 15, 1991     $122.27      $29,009.36          $997.80      $22,683.17
  112.  Apr  1, 1991     $117.12      $29,126.48        $1,002.95      $21,680.22
  113.  Apr 15, 1991     $111.94      $29,238.42        $1,008.13      $20,672.09
  114.  May  1, 1991     $106.74      $29,345.15        $1,013.34      $19,658.75
  115.  May 15, 1991     $101.50      $29,446.66        $1,018.57      $18,640.19
  116.  Jun  1, 1991      $96.25      $29,542.90        $1,023.83      $17,616.36
  117.  Jun 15, 1991      $90.96      $29,633.86        $1,029.11      $16,587.25
  118.  Jul  1, 1991      $85.65      $29,719.51        $1,034.43      $15,552.82
  119.  Jul 15, 1991      $80.30      $29,799.81        $1,039.77      $14,513.05
  120.  Aug  1, 1991      $74.94      $29,874.75        $1,045.14      $13,467.91
  121.  Aug 15, 1991      $69.54      $29,944.29        $1,050.53      $12,417.38
  122.  Sep  1, 1991      $64.11      $30,008.40        $1,055.96      $11,361.42
  123.  Sep 15, 1991      $58.66      $30,067.06        $1,061.41      $10,300.02
  124.  Oct  1, 1991      $53.18      $30,120.25        $1,066.89       $9,233.13
  125.  Oct 15, 1991      $47.67      $30,167.92        $1,072.40       $8,160.73
  126.  Nov  1, 1991      $42.14      $30,210.06        $1,077.94       $7,082.79
  127.  Nov 15, 1991      $36.57      $30,246.63        $1,083.50       $5,999.29
  128.  Dec  1, 1991      $30.98      $30,277.60        $1,089.10       $4,910.19
  129.  Dec 15, 1991      $25.35      $30,302.96        $1,094.72       $3,815.48
  130.  
  131.  Jan  1, 1992      $19.70      $30,322.66        $1,100.37       $2,715.10
  132.  Jan 15, 1992      $14.02      $30,336.68        $1,106.05       $1,609.05
  133.  Feb  1, 1992       $8.31      $30,344.98        $1,111.76         $497.29
  134.  Feb 15, 1992       $2.57      $30,347.55          $497.29           $0.00
  135.  
  136.  
  137.                      Last Payment was         $    499.86
  138.  
  139.                      Total Interest paid was  $ 30,347.55
  140.