Docstoc

emi

Document Sample
emi Powered By Docstoc
					R.R.BAWKAR & CO. [CHARTERED ACCOUNTANTS]
              TABLE SHOWING E.M.I.FOR RS.1000/- FOR VARIOUS INTEREST RATES & MONTHS
mth Yrs.      6    7    8    9     10  10.5    12   12.5  13   13.5 14  14.5   15 15.5                                                                   16
  6    0.5   169.595   170.086   170.577   171.069   171.561   171.808   172.548   172.796   173.043   173.290   173.538   173.786   174.034   174.282   174.530
 12     1     86.066    86.527    86.988    87.451    87.916    88.149    88.849    89.083    89.317    89.552    89.787    90.023    90.258    90.494    90.731
 18    1.5    58.232    58.685    59.140    59.598    60.057    60.288    60.982    61.215    61.448    61.681    61.915    62.150    62.385    62.620    62.856
 24     2     44.321    44.773    45.227    45.685    46.145    46.376    47.073    47.307    47.542    47.777    48.013    48.249    48.487    48.725    48.963
 30    2.5    35.979    36.432    36.888    37.348    37.811    38.044    38.748    38.984    39.222    39.460    39.698    39.938    40.179    40.420    40.662
 36     3     30.422    30.877    31.336    31.800    32.267    32.502    33.214    33.454    33.694    33.935    34.178    34.421    34.665    34.911    35.157
 42    3.5    26.456    26.914    27.377    27.845    28.317    28.555    29.276    29.518    29.762    30.007    30.253    30.501    30.749    30.999    31.250
 48     4     23.485    23.946    24.413    24.885    25.363    25.603    26.334    26.580    26.827    27.076    27.326    27.578    27.831    28.085    28.340
 54    4.5    21.177    21.642    22.112    22.589    23.072    23.316    24.057    24.306    24.558    24.810    25.065    25.320    25.578    25.836    26.096
 60     5     19.333    19.801    20.276    20.758    21.247    21.494    22.244    22.498    22.753    23.010    23.268    23.528    23.790    24.053    24.318
 66    5.5    17.826    18.298    18.778    19.265    19.760    20.010    20.771    21.028    21.287    21.548    21.810    22.075    22.341    22.609    22.878
 72     6     16.573    17.049    17.533    18.026    18.526    18.779    19.550    19.811    20.074    20.339    20.606    20.874    21.145    21.417    21.692
 78    6.5    15.514    15.994    16.483    16.981    17.487    17.743    18.525    18.790    19.056    19.325    19.596    19.869    20.144    20.421    20.700
 84     7     14.609    15.093    15.586    16.089    16.601    16.861    17.653    17.921    18.192    18.465    18.740    19.017    19.297    19.578    19.862
 90    7.5    13.825    14.313    14.812    15.320    15.838    16.101    16.903    17.175    17.450    17.727    18.006    18.288    18.571    18.858    19.146
 96     8     13.141    13.634    14.137    14.650    15.174    15.440    16.253    16.529    16.807    17.088    17.372    17.657    17.945    18.236    18.529
102    8.5    12.539    13.036    13.544    14.062    14.592    14.861    15.684    15.964    16.246    16.531    16.819    17.109    17.401    17.696    17.993
108     9     12.006    12.506    13.019    13.543    14.079    14.351    15.184    15.468    15.754    16.042    16.334    16.628    16.924    17.224    17.525
114    9.5    11.529    12.034    12.551    13.081    13.622    13.898    14.741    15.028    15.318    15.611    15.906    16.204    16.505    16.808    17.114
120    10     11.102    11.611    12.133    12.668    13.215    13.493    14.347    14.638    14.931    15.227    15.527    15.829    16.133    16.441    16.751
126   10.5    10.716    11.229    11.756    12.296    12.849    13.131    13.995    14.289    14.586    14.886    15.189    15.495    15.804    16.115    16.430
132    11     10.367    10.884    11.415    11.961    12.520    12.804    13.678    13.975    14.276    14.580    14.887    15.196    15.509    15.825    16.143
138   11.5    10.049    10.570    11.106    11.657    12.222    12.509    13.392    13.693    13.998    14.305    14.615    14.929    15.246    15.565    15.887
144    12      9.759    10.284    10.825    11.380    11.951    12.241    13.134    13.439    13.746    14.057    14.371    14.688    15.009    15.332    15.658
150   12.5     9.492    10.022    10.567    11.128    11.704    11.998    12.900    13.208    13.519    13.833    14.151    14.472    14.795    15.122    15.452
156    13      9.247     9.781    10.331    10.897    11.478    11.775    12.687    12.998    13.312    13.630    13.951    14.275    14.603    14.933    15.267
162   13.5     9.021     9.559    10.113    10.685    11.272    11.571    12.492    12.806    13.124    13.445    13.770    14.098    14.429    14.763    15.100
168    14      8.812     9.354     9.913    10.489    11.082    11.384    12.314    12.632    12.953    13.277    13.605    13.936    14.270    14.608    14.948
174   14.5     8.619     9.164     9.728    10.309    10.907    11.212    12.151    12.472    12.796    13.124    13.455    13.789    14.127    14.468    14.811
180    15      8.439     8.988     9.557    10.143    10.746    11.054    12.002    12.325    12.652    12.983    13.317    13.655    13.996    14.340    14.687
186   15.5     8.271     8.825     9.397     9.988    10.597    10.908    11.864    12.191    12.521    12.855    13.192    13.533    13.877    14.224    14.574
192    16      8.114     8.672     9.249     9.845    10.459    10.772    11.737    12.067    12.400    12.737    13.077    13.421    13.768    14.118    14.471
198   16.5     7.968     8.530     9.111     9.712    10.331    10.647    11.620    11.953    12.289    12.628    12.972    13.318    13.668    14.021    14.377
204    17      7.831     8.397     8.983     9.588    10.212    10.531    11.512    11.847    12.186    12.529    12.875    13.224    13.577    13.933    14.292
210   17.5     7.702     8.272     8.862     9.472    10.101    10.423    11.412    11.750    12.092    12.437    12.786    13.138    13.494    13.852    14.214
216    18      7.582     8.155     8.750     9.364     9.998    10.322    11.320    11.660    12.004    12.352    12.704    13.059    13.417    13.778    14.142
222   18.5     7.468     8.045     8.644     9.263     9.902    10.229    11.234    11.577    11.924    12.274    12.628    12.986    13.347    13.710    14.077
228    19      7.361     7.942     8.545     9.169     9.813    10.141    11.154    11.500    11.849    12.202    12.559    12.919    13.282    13.648    14.017
234   19.5     7.260     7.845     8.452     9.080     9.729    10.060    11.080    11.428    11.780    12.135    12.495    12.857    13.223    13.591    13.963
240    20      7.164     7.753     8.364     8.997     9.650     9.984    11.011    11.361    11.716    12.074    12.435    12.800    13.168    13.539    13.913
246   20.5     7.074     7.666     8.282     8.919     9.577     9.913    10.947    11.300    11.656    12.017    12.380    12.747    13.118    13.491    13.867
252    21      6.989     7.585     8.204     8.846     9.508     9.846    10.887    11.242    11.601    11.964    12.330    12.699    13.071    13.446    13.824
258   21.5     6.908     7.507     8.131     8.777     9.443     9.784    10.831    11.189    11.550    11.915    12.283    12.654    13.028    13.406    13.786
264    22      6.831     7.434     8.062     8.712     9.382     9.725    10.779    11.139    11.502    11.869    12.239    12.613    12.989    13.368    13.750
270   22.5     6.758     7.365     7.996     8.650     9.325     9.670    10.731    11.093    11.458    11.827    12.199    12.574    12.953    13.334    13.717
276    23      6.688     7.299     7.935     8.593     9.272     9.619    10.686    11.049    11.417    11.788    12.162    12.539    12.919    13.302    13.687
282   23.5     6.623     7.237     7.876     8.538     9.221     9.570    10.643    11.009    11.378    11.751    12.127    12.506    12.888    13.272    13.659
288    24      6.560     7.178     7.821     8.487     9.174     9.525    10.604    10.971    11.343    11.717    12.095    12.476    12.859    13.245    13.634
294   24.5     6.500     7.121     7.768     8.438     9.129     9.482    10.567    10.936    11.309    11.686    12.065    12.448    12.833    13.220    13.610
300    25      6.443     7.068     7.718     8.392     9.087     9.442    10.532    10.904    11.278    11.656    12.038    12.422    12.808    13.197    13.589
306   25.5     6.389     7.017     7.671     8.348     9.047     9.404    10.500    10.873    11.249    11.629    12.012    12.397    12.786    13.176    13.569
312    26      6.337     6.968     7.626     8.307     9.010     9.368    10.470    10.844    11.222    11.604    11.988    12.375    12.765    13.157    13.551
318   26.5     6.287     6.922     7.583     8.268     8.974     9.335    10.441    10.818    11.197    11.580    11.966    12.354    12.745    13.139    13.534
324    27      6.240     6.878     7.543     8.231     8.941     9.303    10.414    10.792    11.174    11.558    11.945    12.335    12.727    13.122    13.518
330   27.5     6.195     6.836     7.504     8.196     8.909     9.273    10.390    10.769    11.152    11.538    11.926    12.317    12.711    13.106    13.504
336    28      6.151     6.796     7.468     8.163     8.880     9.245    10.366    10.747    11.131    11.518    11.908    12.301    12.695    13.092    13.491
342   28.5     6.110     6.758     7.433     8.131     8.851     9.218    10.344    10.727    11.112    11.501    11.892    12.285    12.681    13.079    13.479
348    29      6.070     6.721     7.399     8.102     8.825     9.193    10.324    10.707    11.094    11.484    11.876    12.271    12.668    13.067    13.467
354   29.5     6.032     6.686     7.368     8.073     8.800     9.170    10.304    10.689    11.078    11.469    11.862    12.258    12.656    13.056    13.457
360    30      5.996     6.653     7.338     8.046     8.776     9.147    10.286    10.673    11.062    11.454    11.849    12.246    12.644    13.045    13.448
R.R.BAWKAR & CO. [CHARTERED ACCOUNTANTS]
                    TABLE SHOWING E.M.I.FOR RS.1000/- FOR VARIOUS INTEREST RATES & MONTHS
mth Yrs.     16.5     17   17.5 18   18.5   19   19.5   20  20.5   21  21.5  22  22.5  23                                                                23.5      24
  6    0.5   174.779   175.027   175.276   175.525   175.774   176.024   176.273   176.523   176.773   177.023   177.273   177.523   177.773   178.024   178.275   178.526
 12     1     90.968    91.205    91.442    91.680    91.918    92.157    92.395    92.635    92.874    93.114    93.354    93.594    93.835    94.076    94.318    94.560
 18    1.5    63.093    63.330    63.568    63.806    64.044    64.283    64.523    64.763    65.004    65.245    65.487    65.729    65.971    66.214    66.458    66.702
 24     2     49.202    49.442    49.683    49.924    50.166    50.409    50.652    50.896    51.140    51.386    51.632    51.878    52.125    52.373    52.622    52.871
 30    2.5    40.905    41.149    41.394    41.639    41.886    42.133    42.381    42.630    42.879    43.130    43.381    43.633    43.886    44.140    44.395    44.650
 36     3     35.404    35.653    35.902    36.152    36.404    36.656    36.909    37.164    37.419    37.675    37.932    38.190    38.450    38.710    38.971    39.233
 42    3.5    31.501    31.755    32.009    32.264    32.521    32.778    33.037    33.297    33.558    33.821    34.084    34.348    34.614    34.881    35.148    35.417
 48     4     28.597    28.855    29.114    29.375    29.637    29.900    30.165    30.430    30.697    30.966    31.235    31.506    31.778    32.051    32.326    32.602
 54    4.5    26.358    26.621    26.885    27.151    27.419    27.687    27.958    28.229    28.502    28.777    29.053    29.330    29.608    29.888    30.170    30.452
 60     5     24.585    24.853    25.122    25.393    25.666    25.941    26.216    26.494    26.773    27.053    27.335    27.619    27.904    28.190    28.478    28.768
 66    5.5    23.149    23.423    23.697    23.974    24.252    24.532    24.813    25.097    25.382    25.668    25.956    26.246    26.537    26.830    27.125    27.421
 72     6     21.968    22.246    22.526    22.808    23.091    23.377    23.664    23.953    24.244    24.536    24.830    25.126    25.424    25.723    26.024    26.327
 78    6.5    20.982    21.265    21.550    21.836    22.125    22.416    22.709    23.003    23.300    23.598    23.898    24.200    24.504    24.809    25.117    25.426
 84     7     20.148    20.436    20.726    21.018    21.312    21.608    21.906    22.206    22.508    22.812    23.118    23.426    23.736    24.047    24.361    24.676
 90    7.5    19.436    19.729    20.024    20.321    20.620    20.922    21.225    21.531    21.838    22.148    22.459    22.773    23.088    23.406    23.725    24.046
 96     8     18.824    19.121    19.421    19.723    20.027    20.334    20.642    20.953    21.266    21.581    21.898    22.217    22.538    22.861    23.186    23.513
102    8.5    18.293    18.595    18.900    19.206    19.516    19.827    20.141    20.456    20.775    21.095    21.417    21.741    22.068    22.396    22.727    23.059
108     9     17.829    18.136    18.445    18.757    19.071    19.387    19.706    20.027    20.350    20.675    21.002    21.332    21.664    21.997    22.333    22.671
114    9.5    17.423    17.734    18.048    18.364    18.682    19.003    19.327    19.652    19.980    20.311    20.643    20.978    21.314    21.653    21.994    22.337
120    10     17.064    17.380    17.698    18.019    18.342    18.667    18.995    19.326    19.658    19.993    20.330    20.670    21.011    21.355    21.700    22.048
126   10.5    16.747    17.066    17.389    17.714    18.041    18.371    18.704    19.039    19.376    19.715    20.057    20.401    20.747    21.095    21.446    21.798
132    11     16.464    16.788    17.115    17.444    17.776    18.110    18.447    18.786    19.128    19.472    19.818    20.166    20.517    20.869    21.224    21.581
138   11.5    16.213    16.541    16.871    17.205    17.541    17.879    18.220    18.563    18.909    19.257    19.608    19.960    20.315    20.672    21.030    21.391
144    12     15.987    16.319    16.654    16.991    17.331    17.674    18.019    18.366    18.716    19.068    19.422    19.779    20.138    20.498    20.861    21.226
150   12.5    15.785    16.121    16.459    16.801    17.144    17.491    17.840    18.191    18.545    18.901    19.259    19.619    19.982    20.346    20.713    21.081
156    13     15.604    15.943    16.285    16.630    16.978    17.328    17.680    18.035    18.393    18.752    19.114    19.478    19.844    20.212    20.582    20.954
162   13.5    15.440    15.783    16.129    16.477    16.828    17.182    17.538    17.896    18.257    18.621    18.986    19.353    19.723    20.094    20.468    20.843
168    14     15.292    15.638    15.988    16.340    16.694    17.051    17.411    17.773    18.137    18.503    18.872    19.243    19.615    19.990    20.367    20.745
174   14.5    15.158    15.508    15.861    16.216    16.574    16.934    17.297    17.662    18.029    18.399    18.771    19.145    19.520    19.898    20.277    20.659
180    15     15.037    15.390    15.746    16.104    16.465    16.829    17.195    17.563    17.933    18.306    18.681    19.058    19.436    19.817    20.199    20.583
186   15.5    14.927    15.283    15.642    16.004    16.368    16.734    17.103    17.474    17.848    18.223    18.601    18.980    19.361    19.745    20.129    20.516
192    16     14.827    15.186    15.548    15.913    16.280    16.649    17.021    17.395    17.771    18.149    18.529    18.911    19.295    19.681    20.068    20.457
198   16.5    14.736    15.098    15.463    15.830    16.200    16.572    16.947    17.323    17.702    18.083    18.465    18.850    19.236    19.624    20.013    20.404
204    17     14.654    15.018    15.386    15.756    16.128    16.503    16.880    17.259    17.640    18.023    18.408    18.795    19.184    19.574    19.965    20.358
210   17.5    14.578    14.946    15.316    15.688    16.063    16.440    16.820    17.201    17.585    17.970    18.357    18.746    19.137    19.529    19.923    20.318
216    18     14.510    14.879    15.252    15.627    16.004    16.384    16.766    17.149    17.535    17.923    18.312    18.703    19.095    19.489    19.885    20.281
222   18.5    14.447    14.819    15.194    15.571    15.951    16.333    16.717    17.103    17.490    17.880    18.271    18.664    19.058    19.454    19.851    20.250
228    19     14.389    14.764    15.141    15.521    15.903    16.287    16.673    17.060    17.450    17.842    18.235    18.629    19.025    19.423    19.821    20.221
234   19.5    14.337    14.714    15.093    15.475    15.859    16.245    16.633    17.022    17.414    17.807    18.202    18.598    18.996    19.395    19.795    20.196
240    20     14.289    14.668    15.049    15.433    15.819    16.207    16.597    16.988    17.382    17.776    18.173    18.571    18.970    19.370    19.772    20.174
246   20.5    14.245    14.626    15.010    15.395    15.783    16.173    16.564    16.957    17.352    17.749    18.147    18.546    18.946    19.348    19.751    20.154
252    21     14.205    14.588    14.973    15.361    15.750    16.141    16.535    16.929    17.326    17.724    18.123    18.524    18.925    19.328    19.732    20.137
258   21.5    14.168    14.553    14.940    15.329    15.720    16.113    16.508    16.904    17.302    17.701    18.102    18.504    18.907    19.311    19.716    20.122
264    22     14.134    14.521    14.910    15.300    15.693    16.088    16.484    16.882    17.281    17.681    18.083    18.486    18.890    19.295    19.701    20.108
270   22.5    14.103    14.491    14.882    15.274    15.668    16.064    16.462    16.861    17.261    17.663    18.066    18.470    18.875    19.281    19.688    20.096
276    23     14.075    14.465    14.857    15.250    15.646    16.043    16.442    16.843    17.244    17.647    18.051    18.456    18.862    19.269    19.677    20.085
282   23.5    14.049    14.440    14.833    15.229    15.626    16.024    16.424    16.826    17.228    17.632    18.037    18.443    18.850    19.258    19.666    20.075
288    24     14.025    14.418    14.812    15.209    15.607    16.007    16.408    16.811    17.214    17.619    18.025    18.432    18.839    19.248    19.657    20.067
294   24.5    14.003    14.397    14.793    15.191    15.590    15.991    16.393    16.797    17.202    17.607    18.014    18.422    18.830    19.239    19.649    20.059
300    25     13.982    14.378    14.775    15.174    15.575    15.977    16.380    16.785    17.190    17.597    18.004    18.412    18.822    19.231    19.642    20.053
306   25.5    13.964    14.361    14.759    15.159    15.561    15.964    16.368    16.773    17.180    17.587    17.995    18.404    18.814    19.224    19.635    20.047
312    26     13.947    14.345    14.744    15.146    15.548    15.952    16.357    16.763    17.170    17.578    17.987    18.397    18.807    19.218    19.630    20.042
318   26.5    13.931    14.330    14.731    15.133    15.536    15.941    16.347    16.754    17.162    17.571    17.980    18.390    18.801    19.213    19.624    20.037
324    27     13.917    14.317    14.718    15.122    15.526    15.931    16.338    16.746    17.154    17.564    17.974    18.384    18.796    19.208    19.620    20.033
330   27.5    13.903    14.305    14.707    15.111    15.516    15.923    16.330    16.738    17.147    17.557    17.968    18.379    18.791    19.203    19.616    20.029
336    28     13.891    14.293    14.697    15.101    15.507    15.915    16.323    16.731    17.141    17.552    17.963    18.374    18.787    19.199    19.612    20.026
342   28.5    13.880    14.283    14.687    15.093    15.499    15.907    16.316    16.725    17.136    17.546    17.958    18.370    18.783    19.196    19.609    20.023
348    29     13.870    14.273    14.679    15.085    15.492    15.901    16.310    16.720    17.131    17.542    17.954    18.366    18.779    19.193    19.606    20.020
354   29.5    13.860    14.265    14.671    15.078    15.486    15.894    16.304    16.715    17.126    17.538    17.950    18.363    18.776    19.190    19.604    20.018
360    30     13.851    14.257    14.663    15.071    15.479    15.889    16.299    16.710    17.122    17.534    17.947    18.360    18.773    19.187    19.602    20.016
         LOAN      %              MTH
            300000           16           60

=+PMT(AL3%/12,$B$4,1000)*(-1)

INST      7295.4171
PRIN
INT      IPMT(rate,per,nper,pv,fv,type)
         IPMT(AP2%,AQ2,12)

            3956.06
            3339.36

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:2
posted:11/20/2012
language:Unknown
pages:3