home *** CD-ROM | disk | FTP | other *** search
/ Fresh Fish 4 / FreshFish_May-June1994.bin / bbs / amigalib / d987 / loancalc.lha / LoanCalc / Monthly.data < prev    next >
Encoding:
Text File  |  1994-04-05  |  5.3 KB  |  89 lines
  1.  TABLE FOR LOAN       :  Monthly                 COMMENCED ON  : Jan  1, 2000
  2.  
  3.  OPENING PRINCIPAL    :    $50,000.00            AMORT. PERIOD : 60 months
  4.  
  5.  MONTHLY PAYMENT      :     $1,063.28            INTEREST RATE : 10.250 %
  6.  
  7. ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  8.  
  9.                  Am't  to         Total          Am't  off
  10.     Date         Interest        Interest        Principal        Balance
  11.     ----         --------        --------        ---------        -------
  12.  
  13.  Feb  1, 2000     $418.24         $418.24          $645.04      $49,354.96
  14.  Mar  1, 2000     $412.84         $831.08          $650.44      $48,704.52
  15.  Apr  1, 2000     $407.40       $1,238.48          $655.88      $48,048.64
  16.  May  1, 2000     $401.92       $1,640.40          $661.36      $47,387.28
  17.  Jun  1, 2000     $396.38       $2,036.78          $666.90      $46,720.38
  18.  Jul  1, 2000     $390.81       $2,427.59          $672.47      $46,047.91
  19.  Aug  1, 2000     $385.18       $2,812.77          $678.10      $45,369.81
  20.  Sep  1, 2000     $379.51       $3,192.28          $683.77      $44,686.04
  21.  Oct  1, 2000     $373.79       $3,566.07          $689.49      $43,996.55
  22.  Nov  1, 2000     $368.02       $3,934.09          $695.26      $43,301.29
  23.  Dec  1, 2000     $362.21       $4,296.30          $701.07      $42,600.22
  24.  
  25.  Jan  1, 2001     $356.34       $4,652.64          $706.94      $41,893.28
  26.  Feb  1, 2001     $350.43       $5,003.07          $712.85      $41,180.43
  27.  Mar  1, 2001     $344.47       $5,347.54          $718.81      $40,461.62
  28.  Apr  1, 2001     $338.45       $5,685.99          $724.83      $39,736.79
  29.  May  1, 2001     $332.39       $6,018.38          $730.89      $39,005.90
  30.  Jun  1, 2001     $326.28       $6,344.66          $737.00      $38,268.90
  31.  Jul  1, 2001     $320.11       $6,664.77          $743.17      $37,525.73
  32.  Aug  1, 2001     $313.89       $6,978.66          $749.39      $36,776.34
  33.  Sep  1, 2001     $307.63       $7,286.29          $755.65      $36,020.69
  34.  Oct  1, 2001     $301.31       $7,587.60          $761.97      $35,258.72
  35.  Nov  1, 2001     $294.93       $7,882.53          $768.35      $34,490.37
  36.  Dec  1, 2001     $288.50       $8,171.03          $774.78      $33,715.59
  37.  
  38.  Jan  1, 2002     $282.02       $8,453.05          $781.26      $32,934.33
  39.  Jan  1, 2002         Lump Sum Payment of        $1,000.00
  40.                                        Remaining Principal      $31,934.33
  41.  Feb  1, 2002     $267.12       $8,720.17          $796.16      $31,138.17
  42.  Mar  1, 2002     $260.46       $8,980.63          $802.82      $30,335.35
  43.  Apr  1, 2002     $253.75       $9,234.38          $809.53      $29,525.82
  44.  May  1, 2002     $246.98       $9,481.36          $816.30      $28,709.52
  45.  Jun  1, 2002     $240.15       $9,721.51          $823.13      $27,886.39
  46.  Jul  1, 2002     $233.26       $9,954.77          $830.02      $27,056.37
  47.  Aug  1, 2002     $226.32      $10,181.09          $836.96      $26,219.41
  48.  Sep  1, 2002     $219.32      $10,400.41          $843.96      $25,375.45
  49.  Oct  1, 2002     $212.26      $10,612.67          $851.02      $24,524.43
  50.  Nov  1, 2002     $205.14      $10,817.81          $858.14      $23,666.29
  51.  Dec  1, 2002     $197.96      $11,015.77          $865.32      $22,800.97
  52.  
  53.  Jan  1, 2003     $190.73      $11,206.50          $872.55      $21,928.42
  54.  Feb  1, 2003     $183.43      $11,389.93          $879.85      $21,048.57
  55.  Mar  1, 2003     $176.07      $11,566.00          $887.21      $20,161.36
  56.  Apr  1, 2003     $168.65      $11,734.65          $894.63      $19,266.73
  57.  May  1, 2003     $161.16      $11,895.81          $902.12      $18,364.61
  58.  Jun  1, 2003     $153.62      $12,049.43          $909.66      $17,454.95
  59.  Jul  1, 2003     $146.01      $12,195.44          $917.27      $16,537.68
  60.  Aug  1, 2003     $138.33      $12,333.77          $924.95      $15,612.73
  61.  Sep  1, 2003     $130.60      $12,464.37          $932.68      $14,680.05
  62.  Oct  1, 2003     $122.80      $12,587.17          $940.48      $13,739.57
  63.  Nov  1, 2003     $114.93      $12,702.10          $948.35      $12,791.22
  64.  Dec  1, 2003     $107.00      $12,809.10          $956.28      $11,834.94
  65.  
  66.  
  67.                  Am't  to         Total          Am't  off
  68.     Date         Interest        Interest        Principal        Balance
  69.     ----         --------        --------        ---------        -------
  70.  
  71.  Jan  1, 2004      $99.00      $12,908.10          $964.28      $10,870.66
  72.  Feb  1, 2004      $90.93      $12,999.03          $972.35       $9,898.31
  73.  Mar  1, 2004      $82.80      $13,081.83          $980.48       $8,917.83
  74.  Apr  1, 2004      $74.60      $13,156.43          $988.68       $7,929.15
  75.  May  1, 2004      $66.33      $13,222.76          $996.95       $6,932.20
  76.  Jun  1, 2004      $57.99      $13,280.75        $1,005.29       $5,926.91
  77.  Jul  1, 2004      $49.58      $13,330.33        $1,013.70       $4,913.21
  78.  Aug  1, 2004      $41.10      $13,371.43        $1,022.18       $3,891.03
  79.  Sep  1, 2004      $32.55      $13,403.98        $1,030.73       $2,860.30
  80.  Oct  1, 2004      $23.93      $13,427.91        $1,039.35       $1,820.95
  81.  Nov  1, 2004      $15.23      $13,443.14        $1,048.05         $772.90
  82.  Dec  1, 2004       $6.47      $13,449.61          $772.90           $0.00
  83.  
  84.  
  85.  
  86.                      Last Payment was         $    779.37
  87.  
  88.                      Total Interest paid was  $ 13,449.61
  89.