Loan Calculator-EMI

Document Sample
Loan Calculator-EMI Powered By Docstoc
					Loan Calculator with Extra Payments
                                             Enter Values            Instructions
Loan Amount                                      100,000
Annual Interest Rate                               8.500%
Loan Period in Years                                   10            Must be between 1 and 30 years.
Start Date of Loan                             10/1/2006
Optional Extra Payments                                              If your extra payments vary, enter them in the table below.


Scheduled Monthly Payment              INR      1,239.86
Scheduled Number of Payments                         120
Actual Number of Payments                            120
Total Early Payments                   INR           -
Total Interest                         INR     48,782.83
                                                            Extra
          Payment         Beginning          Scheduled      Paymen        Total                                           Ending
No.       Date            Balance            Payment        t             Payment         Principal      Interest         Balance
   1     11/1/2006        100,000.00            1,239.86       -           1,239.86         531.52         708.33        99,468.48
   2     12/1/2006         99,468.48            1,239.86       -           1,239.86         535.29         704.57        98,933.19
   3      1/1/2007         98,933.19            1,239.86       -           1,239.86         539.08         700.78        98,394.11
   4      2/1/2007         98,394.11            1,239.86       -           1,239.86         542.90         696.96        97,851.21
   5      3/1/2007         97,851.21            1,239.86       -           1,239.86         546.74         693.11        97,304.47
   6      4/1/2007         97,304.47            1,239.86       -           1,239.86         550.62         689.24        96,753.85
   7      5/1/2007         96,753.85            1,239.86       -           1,239.86         554.52         685.34        96,199.33
   8      6/1/2007         96,199.33            1,239.86       -           1,239.86         558.44         681.41        95,640.89
   9      7/1/2007         95,640.89            1,239.86       -           1,239.86         562.40         677.46        95,078.49
  10      8/1/2007         95,078.49            1,239.86       -           1,239.86         566.38         673.47        94,512.10
  11      9/1/2007         94,512.10            1,239.86       -           1,239.86         570.40         669.46        93,941.70
  12     10/1/2007         93,941.70            1,239.86       -           1,239.86         574.44         665.42        93,367.27
  13     11/1/2007         93,367.27            1,239.86       -           1,239.86         578.51         661.35        92,788.76
  14     12/1/2007         92,788.76            1,239.86       -           1,239.86         582.60         657.25        92,206.16
  15      1/1/2008         92,206.16            1,239.86       -           1,239.86         586.73         653.13        91,619.43
  16      2/1/2008         91,619.43            1,239.86       -           1,239.86         590.89         648.97        91,028.54
  17      3/1/2008         91,028.54            1,239.86       -           1,239.86         595.07         644.79        90,433.47
  18      4/1/2008         90,433.47            1,239.86       -           1,239.86         599.29         640.57        89,834.19
  19      5/1/2008         89,834.19            1,239.86       -           1,239.86         603.53         636.33        89,230.65
  20      6/1/2008         89,230.65            1,239.86       -           1,239.86         607.81         632.05        88,622.85
  21      7/1/2008         88,622.85            1,239.86       -           1,239.86         612.11         627.75        88,010.74
  22      8/1/2008         88,010.74            1,239.86       -           1,239.86         616.45         623.41        87,394.29
  23      9/1/2008         87,394.29            1,239.86       -           1,239.86         620.81         619.04        86,773.48
  24     10/1/2008         86,773.48            1,239.86       -           1,239.86         625.21         614.65        86,148.26
  25     11/1/2008         86,148.26            1,239.86       -           1,239.86         629.64         610.22        85,518.62
  26     12/1/2008         85,518.62            1,239.86       -           1,239.86         634.10         605.76        84,884.52
  27      1/1/2009         84,884.52            1,239.86       -           1,239.86         638.59         601.27        84,245.93
  28      2/1/2009         84,245.93            1,239.86       -           1,239.86         643.11         596.74        83,602.82
  29      3/1/2009         83,602.82            1,239.86       -           1,239.86         647.67         592.19        82,955.15
  30      4/1/2009         82,955.15            1,239.86       -           1,239.86         652.26         587.60        82,302.89
  31      5/1/2009         82,302.89            1,239.86       -           1,239.86         656.88         582.98        81,646.01
  32      6/1/2009         81,646.01            1,239.86       -           1,239.86         661.53         578.33        80,984.48
  33      7/1/2009         80,984.48            1,239.86       -           1,239.86         666.22         573.64        80,318.26
  34      8/1/2009         80,318.26            1,239.86       -           1,239.86         670.94         568.92        79,647.33
  35      9/1/2009         79,647.33            1,239.86       -           1,239.86         675.69         564.17        78,971.64
  36     10/1/2009         78,971.64            1,239.86       -           1,239.86         680.47         559.38        78,291.16
  37     11/1/2009         78,291.16            1,239.86       -           1,239.86         685.29         554.56        77,605.87
  38     12/1/2009         77,605.87            1,239.86       -           1,239.86         690.15         549.71        76,915.72
  39      1/1/2010         76,915.72            1,239.86       -           1,239.86         695.04         544.82        76,220.68
  40      2/1/2010         76,220.68            1,239.86       -           1,239.86         699.96         539.90        75,520.72
  41      3/1/2010         75,520.72            1,239.86       -           1,239.86         704.92         534.94        74,815.81
  42      4/1/2010         74,815.81            1,239.86       -           1,239.86         709.91         529.95        74,105.89
  43      5/1/2010         74,105.89            1,239.86       -           1,239.86         714.94         524.92        73,390.95
  44      6/1/2010         73,390.95            1,239.86       -           1,239.86         720.00         519.85        72,670.95
  45      7/1/2010         72,670.95            1,239.86       -           1,239.86         725.10         514.75        71,945.85
  46      8/1/2010         71,945.85            1,239.86       -           1,239.86         730.24         509.62        71,215.60
  47      9/1/2010         71,215.60            1,239.86       -           1,239.86         735.41         504.44        70,480.19
  48     10/1/2010         70,480.19            1,239.86       -           1,239.86         740.62         499.23        69,739.57
  49     11/1/2010         69,739.57            1,239.86       -           1,239.86         745.87         493.99        68,993.70
  50     12/1/2010         68,993.70            1,239.86       -           1,239.86         751.15         488.71        68,242.55
  51      1/1/2011         68,242.55            1,239.86       -           1,239.86         756.47         483.38        67,486.08
  52      2/1/2011         67,486.08            1,239.86       -           1,239.86         761.83         478.03        66,724.25
  53      3/1/2011         66,724.25            1,239.86       -           1,239.86         767.23         472.63        65,957.02
  54      4/1/2011         65,957.02            1,239.86       -           1,239.86         772.66         467.20        65,184.36
  55      5/1/2011         65,184.36            1,239.86       -           1,239.86         778.13         461.72        64,406.22
  56      6/1/2011         64,406.22            1,239.86       -           1,239.86         783.65         456.21        63,622.58
  57      7/1/2011         63,622.58            1,239.86       -           1,239.86         789.20         450.66        62,833.38
  58      8/1/2011         62,833.38            1,239.86       -           1,239.86         794.79         445.07        62,038.59
  59      9/1/2011         62,038.59            1,239.86       -           1,239.86         800.42         439.44        61,238.18
  60     10/1/2011         61,238.18            1,239.86       -           1,239.86         806.09         433.77        60,432.09
                                              Extra
       Payment     Beginning    Scheduled     Paymen   Total                              Ending
No.    Date        Balance      Payment       t        Payment     Principal   Interest   Balance
  61   11/1/2011    60,432.09      1,239.86      -      1,239.86     811.80     428.06    59,620.29
  62   12/1/2011    59,620.29      1,239.86      -      1,239.86     817.55     422.31    58,802.75
  63    1/1/2012    58,802.75      1,239.86      -      1,239.86     823.34     416.52    57,979.41
  64    2/1/2012    57,979.41      1,239.86      -      1,239.86     829.17     410.69    57,150.24
  65    3/1/2012    57,150.24      1,239.86      -      1,239.86     835.04     404.81    56,315.20
  66    4/1/2012    56,315.20      1,239.86      -      1,239.86     840.96     398.90    55,474.24
  67    5/1/2012    55,474.24      1,239.86      -      1,239.86     846.91     392.94    54,627.33
  68    6/1/2012    54,627.33      1,239.86      -      1,239.86     852.91     386.94    53,774.41
  69    7/1/2012    53,774.41      1,239.86      -      1,239.86     858.95     380.90    52,915.46
  70    8/1/2012    52,915.46      1,239.86      -      1,239.86     865.04     374.82    52,050.42
  71    9/1/2012    52,050.42      1,239.86      -      1,239.86     871.17     368.69    51,179.25
  72   10/1/2012    51,179.25      1,239.86      -      1,239.86     877.34     362.52    50,301.92
  73   11/1/2012    50,301.92      1,239.86      -      1,239.86     883.55     356.31    49,418.36
  74   12/1/2012    49,418.36      1,239.86      -      1,239.86     889.81     350.05    48,528.55
  75    1/1/2013    48,528.55      1,239.86      -      1,239.86     896.11     343.74    47,632.44
  76    2/1/2013    47,632.44      1,239.86      -      1,239.86     902.46     337.40    46,729.98
  77    3/1/2013    46,729.98      1,239.86      -      1,239.86     908.85     331.00    45,821.13
  78    4/1/2013    45,821.13      1,239.86      -      1,239.86     915.29     324.57    44,905.84
  79    5/1/2013    44,905.84      1,239.86      -      1,239.86     921.77     318.08    43,984.06
  80    6/1/2013    43,984.06      1,239.86      -      1,239.86     928.30     311.55    43,055.76
  81    7/1/2013    43,055.76      1,239.86      -      1,239.86     934.88     304.98    42,120.88
  82    8/1/2013    42,120.88      1,239.86      -      1,239.86     941.50     298.36    41,179.38
  83    9/1/2013    41,179.38      1,239.86      -      1,239.86     948.17     291.69    40,231.21
  84   10/1/2013    40,231.21      1,239.86      -      1,239.86     954.89     284.97    39,276.33
  85   11/1/2013    39,276.33      1,239.86      -      1,239.86     961.65     278.21    38,314.68
  86   12/1/2013    38,314.68      1,239.86      -      1,239.86     968.46     271.40    37,346.22
  87    1/1/2014    37,346.22      1,239.86      -      1,239.86     975.32     264.54    36,370.89
  88    2/1/2014    36,370.89      1,239.86      -      1,239.86     982.23     257.63    35,388.66
  89    3/1/2014    35,388.66      1,239.86      -      1,239.86     989.19     250.67    34,399.48
  90    4/1/2014    34,399.48      1,239.86      -      1,239.86     996.19     243.66    33,403.28
  91    5/1/2014    33,403.28      1,239.86      -      1,239.86   1,003.25     236.61    32,400.03
  92    6/1/2014    32,400.03      1,239.86      -      1,239.86   1,010.36     229.50    31,389.68
  93    7/1/2014    31,389.68      1,239.86      -      1,239.86   1,017.51     222.34    30,372.16
  94    8/1/2014    30,372.16      1,239.86      -      1,239.86   1,024.72     215.14    29,347.44
  95    9/1/2014    29,347.44      1,239.86      -      1,239.86   1,031.98     207.88    28,315.46
  96   10/1/2014    28,315.46      1,239.86      -      1,239.86   1,039.29     200.57    27,276.17
  97   11/1/2014    27,276.17      1,239.86      -      1,239.86   1,046.65     193.21    26,229.52
  98   12/1/2014    26,229.52      1,239.86      -      1,239.86   1,054.06     185.79    25,175.46
  99    1/1/2015    25,175.46      1,239.86      -      1,239.86   1,061.53     178.33    24,113.93
 100    2/1/2015    24,113.93      1,239.86      -      1,239.86   1,069.05     170.81    23,044.88
 101    3/1/2015    23,044.88      1,239.86      -      1,239.86   1,076.62     163.23    21,968.26
 102    4/1/2015    21,968.26      1,239.86      -      1,239.86   1,084.25     155.61    20,884.01
 103    5/1/2015    20,884.01      1,239.86      -      1,239.86   1,091.93     147.93    19,792.08
 104    6/1/2015    19,792.08      1,239.86      -      1,239.86   1,099.66     140.19    18,692.42
 105    7/1/2015    18,692.42      1,239.86      -      1,239.86   1,107.45     132.40    17,584.96
 106    8/1/2015    17,584.96      1,239.86      -      1,239.86   1,115.30     124.56    16,469.67
 107    9/1/2015    16,469.67      1,239.86      -      1,239.86   1,123.20     116.66    15,346.47
 108   10/1/2015    15,346.47      1,239.86      -      1,239.86   1,131.15     108.70    14,215.32
 109   11/1/2015    14,215.32      1,239.86      -      1,239.86   1,139.17     100.69    13,076.15
 110   12/1/2015    13,076.15      1,239.86      -      1,239.86   1,147.23      92.62    11,928.92
 111    1/1/2016    11,928.92      1,239.86      -      1,239.86   1,155.36      84.50    10,773.56
 112    2/1/2016    10,773.56      1,239.86      -      1,239.86   1,163.54      76.31     9,610.01
 113    3/1/2016     9,610.01      1,239.86      -      1,239.86   1,171.79      68.07     8,438.23
 114    4/1/2016     8,438.23      1,239.86      -      1,239.86   1,180.09      59.77     7,258.14
 115    5/1/2016     7,258.14      1,239.86      -      1,239.86   1,188.45      51.41     6,069.70
 116    6/1/2016     6,069.70      1,239.86      -      1,239.86   1,196.86      42.99     4,872.83
 117    7/1/2016     4,872.83      1,239.86      -      1,239.86   1,205.34      34.52     3,667.49
 118    8/1/2016     3,667.49      1,239.86      -      1,239.86   1,213.88      25.98     2,453.61
 119    9/1/2016     2,453.61      1,239.86      -      1,239.86   1,222.48      17.38     1,231.14
 120   10/1/2016     1,231.14      1,239.86      -      1,239.86   1,231.14       8.72         0.00

				
DOCUMENT INFO