home *** CD-ROM | disk | FTP | other *** search
/ Fresh Fish 4 / FreshFish_May-June1994.bin / bbs / amigalib / d987 / loancalc.lha / LoanCalc / Semi-Monthly.data < prev    next >
Encoding:
Text File  |  1994-04-05  |  9.8 KB  |  149 lines
  1.  TABLE FOR LOAN       :  Semi-Monthly            COMMENCED ON  : Jan  1, 2000
  2.  
  3.  OPENING PRINCIPAL    :    $50,000.00            AMORT. PERIOD : 60 months
  4.  
  5.  SEMI-MONTHLY PAYMENT :       $530.53            INTEREST RATE : 10.250 %
  6.  
  7. ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  8.  
  9.                  Am't  to         Total          Am't  off
  10.     Date         Interest        Interest        Principal        Balance
  11.     ----         --------        --------        ---------        -------
  12.  Jan 15, 2000     $208.68         $208.68          $321.85      $49,678.15
  13.  Feb  1, 2000     $207.34         $416.02          $323.19      $49,354.96
  14.  Feb 15, 2000     $205.99         $622.01          $324.54      $49,030.42
  15.  Mar  1, 2000     $204.64         $826.65          $325.89      $48,704.53
  16.  Mar 15, 2000     $203.28       $1,029.93          $327.25      $48,377.28
  17.  Apr  1, 2000     $201.91       $1,231.84          $328.62      $48,048.66
  18.  Apr 15, 2000     $200.54       $1,432.38          $329.99      $47,718.67
  19.  May  1, 2000     $199.16       $1,631.54          $331.37      $47,387.30
  20.  May 15, 2000     $197.78       $1,829.32          $332.75      $47,054.55
  21.  Jun  1, 2000     $196.39       $2,025.71          $334.14      $46,720.41
  22.  Jun 15, 2000     $195.00       $2,220.71          $335.53      $46,384.88
  23.  Jul  1, 2000     $193.60       $2,414.31          $336.93      $46,047.95
  24.  Jul 15, 2000     $192.19       $2,606.50          $338.34      $45,709.61
  25.  Aug  1, 2000     $190.78       $2,797.28          $339.75      $45,369.86
  26.  Aug 15, 2000     $189.36       $2,986.64          $341.17      $45,028.69
  27.  Sep  1, 2000     $187.94       $3,174.58          $342.59      $44,686.10
  28.  Sep 15, 2000     $186.51       $3,361.09          $344.02      $44,342.08
  29.  Oct  1, 2000     $185.07       $3,546.16          $345.46      $43,996.62
  30.  Oct 15, 2000     $183.63       $3,729.79          $346.90      $43,649.72
  31.  Nov  1, 2000     $182.18       $3,911.97          $348.35      $43,301.37
  32.  Nov 15, 2000     $180.73       $4,092.70          $349.80      $42,951.57
  33.  Dec  1, 2000     $179.27       $4,271.97          $351.26      $42,600.31
  34.  Dec 15, 2000     $177.80       $4,449.77          $352.73      $42,247.58
  35.  
  36.  Jan  1, 2001     $176.33       $4,626.10          $354.20      $41,893.38
  37.  Jan 15, 2001     $174.85       $4,800.95          $355.68      $41,537.70
  38.  Feb  1, 2001     $173.37       $4,974.32          $357.16      $41,180.54
  39.  Feb 15, 2001     $171.87       $5,146.19          $358.66      $40,821.88
  40.  Mar  1, 2001     $170.38       $5,316.57          $360.15      $40,461.73
  41.  Mar 15, 2001     $168.87       $5,485.44          $361.66      $40,100.07
  42.  Apr  1, 2001     $167.36       $5,652.80          $363.17      $39,736.90
  43.  Apr 15, 2001     $165.85       $5,818.65          $364.68      $39,372.22
  44.  May  1, 2001     $164.33       $5,982.98          $366.20      $39,006.02
  45.  May 15, 2001     $162.80       $6,145.78          $367.73      $38,638.29
  46.  Jun  1, 2001     $161.26       $6,307.04          $369.27      $38,269.02
  47.  Jun 15, 2001     $159.72       $6,466.76          $370.81      $37,898.21
  48.  Jul  1, 2001     $158.18       $6,624.94          $372.35      $37,525.86
  49.  Jul 15, 2001     $156.62       $6,781.56          $373.91      $37,151.95
  50.  Aug  1, 2001     $155.06       $6,936.62          $375.47      $36,776.48
  51.  Aug 15, 2001     $153.49       $7,090.11          $377.04      $36,399.44
  52.  Sep  1, 2001     $151.92       $7,242.03          $378.61      $36,020.83
  53.  Sep 15, 2001     $150.34       $7,392.37          $380.19      $35,640.64
  54.  Oct  1, 2001     $148.75       $7,541.12          $381.78      $35,258.86
  55.  Oct 15, 2001     $147.16       $7,688.28          $383.37      $34,875.49
  56.  Nov  1, 2001     $145.56       $7,833.84          $384.97      $34,490.52
  57.  Nov 15, 2001     $143.95       $7,977.79          $386.58      $34,103.94
  58.  Dec  1, 2001     $142.34       $8,120.13          $388.19      $33,715.75
  59.  Dec 15, 2001     $140.72       $8,260.85          $389.81      $33,325.94
  60.  
  61.                  Am't  to         Total          Am't  off
  62.     Date         Interest        Interest        Principal        Balance
  63.     ----         --------        --------        ---------        -------
  64.  
  65.  Jan  1, 2002     $139.09       $8,399.94          $391.44      $32,934.50
  66.  Jan  1, 2002         Lump Sum Payment of        $1,000.00
  67.                                        Remaining Principal      $31,934.50
  68.  Jan 15, 2002     $133.28       $8,533.22          $397.25      $31,537.25
  69.  Feb  1, 2002     $131.63       $8,664.85          $398.90      $31,138.35
  70.  Feb 15, 2002     $129.96       $8,794.81          $400.57      $30,737.78
  71.  Mar  1, 2002     $128.29       $8,923.10          $402.24      $30,335.54
  72.  Mar 15, 2002     $126.61       $9,049.71          $403.92      $29,931.62
  73.  Apr  1, 2002     $124.93       $9,174.64          $405.60      $29,526.02
  74.  Apr 15, 2002     $123.23       $9,297.87          $407.30      $29,118.72
  75.  May  1, 2002     $121.53       $9,419.40          $409.00      $28,709.72
  76.  May 15, 2002     $119.83       $9,539.23          $410.70      $28,299.02
  77.  Jun  1, 2002     $118.11       $9,657.34          $412.42      $27,886.60
  78.  Jun 15, 2002     $116.39       $9,773.73          $414.14      $27,472.46
  79.  Jul  1, 2002     $114.66       $9,888.39          $415.87      $27,056.59
  80.  Jul 15, 2002     $112.93      $10,001.32          $417.60      $26,638.99
  81.  Aug  1, 2002     $111.18      $10,112.50          $419.35      $26,219.64
  82.  Aug 15, 2002     $109.43      $10,221.93          $421.10      $25,798.54
  83.  Sep  1, 2002     $107.67      $10,329.60          $422.86      $25,375.68
  84.  Sep 15, 2002     $105.91      $10,435.51          $424.62      $24,951.06
  85.  Oct  1, 2002     $104.14      $10,539.65          $426.39      $24,524.67
  86.  Oct 15, 2002     $102.36      $10,642.01          $428.17      $24,096.50
  87.  Nov  1, 2002     $100.57      $10,742.58          $429.96      $23,666.54
  88.  Nov 15, 2002      $98.78      $10,841.36          $431.75      $23,234.79
  89.  Dec  1, 2002      $96.97      $10,938.33          $433.56      $22,801.23
  90.  Dec 15, 2002      $95.17      $11,033.50          $435.36      $22,365.87
  91.  
  92.  Jan  1, 2003      $93.35      $11,126.85          $437.18      $21,928.69
  93.  Jan 15, 2003      $91.52      $11,218.37          $439.01      $21,489.68
  94.  Feb  1, 2003      $89.69      $11,308.06          $440.84      $21,048.84
  95.  Feb 15, 2003      $87.85      $11,395.91          $442.68      $20,606.16
  96.  Mar  1, 2003      $86.00      $11,481.91          $444.53      $20,161.63
  97.  Mar 15, 2003      $84.15      $11,566.06          $446.38      $19,715.25
  98.  Apr  1, 2003      $82.29      $11,648.35          $448.24      $19,267.01
  99.  Apr 15, 2003      $80.41      $11,728.76          $450.12      $18,816.89
  100.  May  1, 2003      $78.54      $11,807.30          $451.99      $18,364.90
  101.  May 15, 2003      $76.65      $11,883.95          $453.88      $17,911.02
  102.  Jun  1, 2003      $74.75      $11,958.70          $455.78      $17,455.24
  103.  Jun 15, 2003      $72.85      $12,031.55          $457.68      $16,997.56
  104.  Jul  1, 2003      $70.94      $12,102.49          $459.59      $16,537.97
  105.  Jul 15, 2003      $69.02      $12,171.51          $461.51      $16,076.46
  106.  Aug  1, 2003      $67.10      $12,238.61          $463.43      $15,613.03
  107.  Aug 15, 2003      $65.16      $12,303.77          $465.37      $15,147.66
  108.  Sep  1, 2003      $63.22      $12,366.99          $467.31      $14,680.35
  109.  Sep 15, 2003      $61.27      $12,428.26          $469.26      $14,211.09
  110.  Oct  1, 2003      $59.31      $12,487.57          $471.22      $13,739.87
  111.  Oct 15, 2003      $57.35      $12,544.92          $473.18      $13,266.69
  112.  Nov  1, 2003      $55.37      $12,600.29          $475.16      $12,791.53
  113.  Nov 15, 2003      $53.39      $12,653.68          $477.14      $12,314.39
  114.  Dec  1, 2003      $51.40      $12,705.08          $479.13      $11,835.26
  115.  Dec 15, 2003      $49.40      $12,754.48          $481.13      $11,354.13
  116.  
  117.                  Am't  to         Total          Am't  off
  118.     Date         Interest        Interest        Principal        Balance
  119.     ----         --------        --------        ---------        -------
  120.  
  121.  Jan  1, 2004      $47.39      $12,801.87          $483.14      $10,870.99
  122.  Jan 15, 2004      $45.37      $12,847.24          $485.16      $10,385.83
  123.  Feb  1, 2004      $43.35      $12,890.59          $487.18       $9,898.65
  124.  Feb 15, 2004      $41.31      $12,931.90          $489.22       $9,409.43
  125.  Mar  1, 2004      $39.27      $12,971.17          $491.26       $8,918.17
  126.  Mar 15, 2004      $37.22      $13,008.39          $493.31       $8,424.86
  127.  Apr  1, 2004      $35.16      $13,043.55          $495.37       $7,929.49
  128.  Apr 15, 2004      $33.10      $13,076.65          $497.43       $7,432.06
  129.  May  1, 2004      $31.02      $13,107.67          $499.51       $6,932.55
  130.  May 15, 2004      $28.93      $13,136.60          $501.60       $6,430.95
  131.  Jun  1, 2004      $26.84      $13,163.44          $503.69       $5,927.26
  132.  Jun 15, 2004      $24.74      $13,188.18          $505.79       $5,421.47
  133.  Jul  1, 2004      $22.63      $13,210.81          $507.90       $4,913.57
  134.  Jul 15, 2004      $20.51      $13,231.32          $510.02       $4,403.55
  135.  Aug  1, 2004      $18.38      $13,249.70          $512.15       $3,891.40
  136.  Aug 15, 2004      $16.24      $13,265.94          $514.29       $3,377.11
  137.  Sep  1, 2004      $14.09      $13,280.03          $516.44       $2,860.67
  138.  Sep 15, 2004      $11.94      $13,291.97          $518.59       $2,342.08
  139.  Oct  1, 2004       $9.78      $13,301.75          $520.75       $1,821.33
  140.  Oct 15, 2004       $7.60      $13,309.35          $522.93       $1,298.40
  141.  Nov  1, 2004       $5.42      $13,314.77          $525.11         $773.29
  142.  Nov 15, 2004       $3.23      $13,318.00          $527.30         $245.99
  143.  Dec  1, 2004       $1.03      $13,319.03          $245.99           $0.00
  144.  
  145.  
  146.                      Last Payment was         $    247.02
  147.  
  148.                      Total Interest paid was  $ 13,319.03
  149.