EMI_calculator

Document Sample
EMI_calculator Powered By Docstoc
					Enter loan amount                  1000000
ROI (p.a.)                          9.50%
Term in years                           10

EMI (monthly rest)              12,939.76                                   1615

Amortization schedule

Months   Opening             Interest          Principal      Closing

    1              1000000              7917           5023        994977          62972
    2               994977              7877           5063        989914
    3               989914              7837           5103        984811
    4               984811              7796           5143        979668
    5               979668              7756           5184        974484
    6               974484              7715           5225        969259
    7               969259              7673           5266        963992
    8               963992              7632           5308        958684
    9               958684              7590           5350        953334
   10               953334              7547           5393        947941
   11               947941              7505           5435        942506
   12               942506              7462           5478        937028
   13               937028              7418           5522        931506
   14               931506              7374           5565        925941
   15               925941              7330           5609        920332
   16               920332              7286           5654        914678
   17               914678              7241           5699        908979
   18               908979              7196           5744        903235
   19               903235              7151           5789        897446
   20               897446              7105           5835        891611
   21               891611              7059           5881        885730
   22               885730              7012           5928        879802
   23               879802              6965           5975        873828
   24               873828              6918           6022        867806
   25               867806              6870           6070        861736
   26               861736              6822           6118        855619
   27               855619              6774           6166        849452
   28               849452              6725           6215        843238
   29               843238              6676           6264        836973
   30               836973              6626           6314        830660
   31               830660              6576           6364        824296
   32               824296              6526           6414        817882
   33               817882              6475           6465        811417
   34               811417              6424           6516        804901
35   804901   6372   6568   798333
36   798333   6320   6620   791714
37   791714   6268   6672   785042
38   785042   6215   6725   778317
39   778317   6162   6778   771539
40   771539   6108   6832   764707
41   764707   6054   6886   757821
42   757821   5999   6940   750881
43   750881   5944   6995   743886
44   743886   5889   7051   736835
45   736835   5833   7106   729729
46   729729   5777   7163   722566
47   722566   5720   7219   715346
48   715346   5663   7277   708070
49   708070   5606   7334   700736
50   700736   5547   7392   693343
51   693343   5489   7451   685892
52   685892   5430   7510   678383
53   678383   5371   7569   670813
54   670813   5311   7629   663184
55   663184   5250   7690   655495
56   655495   5189   7750   647744
57   647744   5128   7812   639933
58   639933   5066   7874   632059
59   632059   5004   7936   624123
60   624123   4941   7999   616124
61   616124   4878   8062   608062
62   608062   4814   8126   599936
63   599936   4749   8190   591746
64   591746   4685   8255   583491
65   583491   4619   8320   575170
66   575170   4553   8386   566784
67   566784   4487   8453   558331
68   558331   4420   8520   549812
69   549812   4353   8587   541225
70   541225   4285   8655   532570
71   532570   4216   8724   523846
72   523846   4147   8793   515053
73   515053   4078   8862   506191
74   506191   4007   8932   497259
75   497259   3937   9003   488256
76   488256   3865   9074   479181
77   479181   3794   9146   470035
78   470035   3721   9219   460816
79    460816   3648    9292   451525
80    451525   3575    9365   442159
81    442159   3500    9439   432720
82    432720   3426    9514   423206
83    423206   3350    9589   413617
84    413617   3274    9665   403951
85    403951   3198    9742   394210
86    394210   3121    9819   384391
87    384391   3043    9897   374494
88    374494   2965    9975   364519
89    364519   2886   10054   354465
90    354465   2806   10134   344331
91    344331   2726   10214   334118
92    334118   2645   10295   323823
93    323823   2564   10376   313447
94    313447   2481   10458   302989
95    302989   2399   10541   292447
96    292447   2315   10625   281823
97    281823   2231   10709   271114
98    271114   2146   10793   260321
99    260321   2061   10879   249442
100   249442   1975   10965   238477
101   238477   1888   11052   227425
102   227425   1800   11139   216286
103   216286   1712   11227   205058
104   205058   1623   11316   193742
105   193742   1534   11406   182336
106   182336   1443   11496   170840
107   170840   1352   11587   159252
108   159252   1261   11679   147573
109   147573   1168   11771   135802
110   135802   1075   11865   123937
111   123937    981   11959   111979
112   111979    886   12053    99925
113    99925    791   12149    87777
114    87777    695   12245    75532
115    75532    598   12342    63190
116    63190    500   12440    50751
117    50751    402   12538    38213
118    38213    303   12637    25575
119    25575    202   12737    12838
120    12838    102   12838        0
121        0      0       0        0
122        0      0       0        0
123   0   0   0   0
124   0   0   0   0
125   0   0   0   0
126   0   0   0   0
127   0   0   0   0
128   0   0   0   0
129   0   0   0   0
130   0   0   0   0
131   0   0   0   0
132   0   0   0   0
133   0   0   0   0
134   0   0   0   0
135   0   0   0   0
136   0   0   0   0
137   0   0   0   0
138   0   0   0   0
139   0   0   0   0
140   0   0   0   0
141   0   0   0   0
142   0   0   0   0
143   0   0   0   0
144   0   0   0   0
145   0   0   0   0
146   0   0   0   0
147   0   0   0   0
148   0   0   0   0
149   0   0   0   0
150   0   0   0   0
151   0   0   0   0
152   0   0   0   0
153   0   0   0   0
154   0   0   0   0
155   0   0   0   0
156   0   0   0   0
157   0   0   0   0
158   0   0   0   0
159   0   0   0   0
160   0   0   0   0
161   0   0   0   0
162   0   0   0   0
163   0   0   0   0
164   0   0   0   0
165   0   0   0   0
166   0   0   0   0
167   0   0   0   0
168   0   0   0   0
169   0   0   0   0
170   0   0   0   0
171   0   0   0   0
172   0   0   0   0
173   0   0   0   0
174   0   0   0   0
175   0   0   0   0
176   0   0   0   0
177   0   0   0   0
178   0   0   0   0
179   0   0   0   0
180   0   0   0   0
181   0   0   0   0
182   0   0   0   0
183   0   0   0   0
184   0   0   0   0
185   0   0   0   0
186   0   0   0   0
187   0   0   0   0
188   0   0   0   0
189   0   0   0   0
190   0   0   0   0
191   0   0   0   0
192   0   0   0   0
193   0   0   0   0
194   0   0   0   0
195   0   0   0   0
196   0   0   0   0
197   0   0   0   0
198   0   0   0   0
199   0   0   0   0
200   0   0   0   0
201   0   0   0   0
202   0   0   0   0
203   0   0   0   0
204   0   0   0   0
205   0   0   0   0
206   0   0   0   0
207   0   0   0   0
208   0   0   0   0
209   0   0   0   0
210   0   0   0   0
211   0   0   0   0
212   0   0   0   0
213   0   0   0   0
214   0   0   0   0
215   0   0   0   0
216   0   0   0   0
217   0   0   0   0
218   0   0   0   0
219   0   0   0   0
220   0   0   0   0
221   0   0   0   0
222   0   0   0   0
223   0   0   0   0
224   0   0   0   0
225   0   0   0   0
226   0   0   0   0
227   0   0   0   0
228   0   0   0   0
229   0   0   0   0
230   0   0   0   0
231   0   0   0   0
232   0   0   0   0
233   0   0   0   0
234   0   0   0   0
235   0   0   0   0
236   0   0   0   0
237   0   0   0   0
238   0   0   0   0
239   0   0   0   0
240   0   0   0   0

				
DOCUMENT INFO
Categories:
Tags:
Stats:
views:3
posted:12/9/2011
language:
pages:6