Assignment 2

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 20

T1

Tenure
Sno LoanID Loan Amount (in Years)
1 L00-D000002005082011 2,500,000.00 3
2 L00-D000002005082012 1,990,000.00 5
3 L00-P000020050820133 1,390,000.00 2
4 L00-M000000200508204 1,800,000.00 5
5 L00-D000002005082015 1,200,000.00 5
6 L00-P000020050820136 2,100,000.00 5
7 L00-C000000020050827 1,200,000.00 5
8 L00-C000000020050828 950,000.00 5
9 L00-C000000020050829 575,000.00 5
10 L00-D000002005082010 910,000.00 3
11 L00-D000002005082011 2,500,000.00 5
12 L00-P000020050820112 1,500,000.00 3
13 L00-C000000020050813 1,800,000.00 3
14 L00-P000020050820114 2,500,000.00 4
15 L00-P000020050820115 1,390,000.00 2
16 L00-M000000200508216 1,800,000.00 4
17 L00-M000000200508217 1,390,000.00 5
18 L00-D000002005082018 1,990,000.00 5
19 L00-D000002005082019 575,000.00 3
20 L00-P000020050820120 1,500,000.00 3
21 L00-C000000020050821 1,200,000.00 2
22 L00-C000000020050822 575,000.00 1
23 L00-C000000020050823 1,800,000.00 3
24 L00-P000020050820124 575,000.00 2
25 L00-P000020050820125 2,500,000.00 1
26 L00-D000002005082026 2,100,000.00 5
27 L00-C000000020050827 1,800,000.00 2
28 L00-C000000020050828 1,200,000.00 4
29 L00-M000000200508229 950,000.00 5
30 L00-M000000200508230 2,500,000.00 3
31 L00-C000000020050831 950,000.00 3
32 L00-M000000200508232 2,500,000.00 2
33 L00-M000000200508233 1,500,000.00 3
34 L00-M000000200508234 2,100,000.00 3
35 L00-C000000020050835 1,500,000.00 2
36 L00-D000002005082036 575,000.00 4
37 L00-C000000020050837 1,800,000.00 1
38 L00-C000000020050838 2,100,000.00 5
39 L00-P000020050820139 575,000.00 4
40 L00-D000002005082040 575,000.00 5
41 L00-P000020050820141 910,000.00 2
42 L00-M000000200508242 1,500,000.00 2
43 L00-P000020050820143 910,000.00 5
44 L00-P000020050820144 950,000.00 1
45 L00-D000002005082045 1,800,000.00 5
46 L00-D000002005082046 1,390,000.00 1
47 L00-C000000020050847 910,000.00 5
48 L00-D000002005082048 1,390,000.00 4
49 L00-C000000020050849 1,500,000.00 5
50 L00-C000000020050850 1,500,000.00 1
51 L00-M000000200508251 1,390,000.00 4
52 L00-D000002005082052 2,500,000.00 1
53 L00-C000000020050853 1,500,000.00 2
54 L00-P000020050820154 910,000.00 5
55 L00-M000000200508255 910,000.00 3
56 L00-P000020050820156 1,990,000.00 4
57 L00-D000002005082057 2,500,000.00 1
58 L00-D000002005082058 2,500,000.00 3
59 L00-D000002005082059 1,990,000.00 1
60 L00-P000020050820160 2,100,000.00 2
61 L00-D000002005082061 1,800,000.00 2
62 L00-P000020050820162 575,000.00 4
63 L00-D000002005082063 2,100,000.00 2
64 L00-D000002005082064 2,500,000.00 5
65 L00-P000020050820165 1,390,000.00 5
66 L00-M000000200508266 1,800,000.00 1
67 L00-M000000200508267 950,000.00 3
68 L00-P000020050820168 575,000.00 3
69 L00-M000000200508269 950,000.00 3
70 L00-M000000200508270 2,100,000.00 3
71 L00-C000000020050871 575,000.00 5
72 L00-M000000200508272 950,000.00 2
73 L00-M000000200508273 950,000.00 1
74 L00-P000020050820174 950,000.00 4
75 L00-M000000200508275 1,800,000.00 1
76 L00-M000000200508276 2,500,000.00 2
77 L00-M000000200508277 950,000.00 1
78 L00-C000000020050878 2,100,000.00 5
79 L00-C000000020050879 1,390,000.00 3
80 L00-D000002005082080 950,000.00 5
81 L00-P000020050820181 1,200,000.00 1
82 L00-M000000200508282 1,500,000.00 5
83 L00-D000002005082083 1,990,000.00 2
84 L00-M000000200508284 910,000.00 5
85 L00-P000020050820185 1,800,000.00 4
86 L00-D000002005082086 950,000.00 3
87 L00-P000020050820187 1,200,000.00 5
88 L00-P000020050820188 950,000.00 2
89 L00-C000000020050889 2,500,000.00 5
90 L00-P000020050820190 1,390,000.00 2
91 L00-M000000200508291 1,800,000.00 3
92 L00-M000000200508292 1,200,000.00 2
93 L00-C000000020050893 1,800,000.00 3
94 L00-D000002005082094 1,390,000.00 3
95 L00-P000020050820195 575,000.00 4
96 L00-C000000020050896 2,500,000.00 2
97 L00-M000000200508297 1,500,000.00 4
98 L00-P000020050820198 1,500,000.00 3
99 L00-M000000200508299 910,000.00 4
100 L00-D000002005082100 950,000.00 3
101 L00-D000002005082101 1,990,000.00 1
102 L00-P000020050820102 1,500,000.00 4
103 L00-C000000020050103 1,800,000.00 1
104 L00-D000002005082104 575,000.00 4
105 L00-M000000200508105 1,990,000.00 4
106 L00-D000002005082106 1,390,000.00 3
107 L00-M000000200508107 910,000.00 3
108 L00-P000020050820108 1,990,000.00 4
109 L00-P000020050820109 1,390,000.00 4
110 L00-D000002005082110 2,500,000.00 2
111 L00-P000020050820111 910,000.00 1
112 L00-P000020050820112 2,500,000.00 4
113 L00-D000002005082113 1,200,000.00 3
114 L00-P000020050820114 575,000.00 2
115 L00-D000002005082115 1,800,000.00 4
116 L00-P000020050820116 910,000.00 2
117 L00-M000000200508117 2,500,000.00 2
118 L00-M000000200508118 575,000.00 4
119 L00-P000020050820119 1,390,000.00 1
120 L00-M000000200508120 2,100,000.00 1
121 L00-C000000020050121 910,000.00 4
122 L00-D000002005082122 910,000.00 1
123 L00-M000000200508123 910,000.00 3
124 L00-C000000020050124 1,800,000.00 1
125 L00-D000002005082125 2,100,000.00 5
126 L00-M000000200508126 2,500,000.00 4
127 L00-P000020050820127 1,200,000.00 5
128 L00-C000000020050128 1,990,000.00 1
129 L00-C000000020050129 910,000.00 1
130 L00-M000000200508130 2,100,000.00 3
131 L00-M000000200508131 2,500,000.00 5
132 L00-P000020050820132 2,500,000.00 4
133 L00-C000000020050133 1,500,000.00 2
134 L00-P000020050820134 2,100,000.00 1
135 L00-M000000200508135 1,390,000.00 5
136 L00-P000020050820136 1,990,000.00 2
137 L00-D000002005082137 2,500,000.00 3
138 L00-P000020050820138 950,000.00 4
139 L00-P000020050820139 1,800,000.00 1
140 L00-C000000020050140 910,000.00 5
141 L00-C000000020050141 1,390,000.00 1
142 L00-D000002005082142 1,990,000.00 1
143 L00-M000000200508143 1,500,000.00 4
144 L00-D000002005082144 2,500,000.00 4
145 L00-D000002005082145 910,000.00 4
146 L00-D000002005082146 950,000.00 4
147 L00-D000002005082147 950,000.00 5
148 L00-P000020050820148 2,100,000.00 5
149 L00-C000000020050149 575,000.00 3
150 L00-C000000020050150 1,990,000.00 5
151 L00-C000000020050151 1,800,000.00 3
152 L00-M000000200508152 575,000.00 5
153 L00-P000020050820153 575,000.00 2
154 L00-M000000200508154 1,390,000.00 5
155 L00-P000020050820155 2,500,000.00 1
156 L00-P000020050820156 1,500,000.00 2
157 L00-D000002005082157 1,200,000.00 5
158 L00-P000020050820158 1,200,000.00 5
159 L00-C000000020050159 1,200,000.00 5
160 L00-M000000200508160 910,000.00 3
161 L00-P000020050820161 1,390,000.00 2
162 L00-C000000020050162 950,000.00 2
163 L00-C000000020050163 1,500,000.00 4
164 L00-D000002005082164 1,990,000.00 4
165 L00-C000000020050165 2,100,000.00 3
166 L00-D000002005082166 950,000.00 2
167 L00-D000002005082167 1,200,000.00 2
168 L00-D000002005082168 1,200,000.00 1
169 L00-C000000020050169 950,000.00 5
170 L00-P000020050820170 1,200,000.00 5
171 L00-M000000200508171 575,000.00 4
172 L00-D000002005082172 910,000.00 3
173 L00-M000000200508173 1,390,000.00 2
174 L00-D000002005082174 1,390,000.00 5
175 L00-M000000200508175 1,200,000.00 1
176 L00-P000020050820176 575,000.00 2
177 L00-P000020050820177 910,000.00 4
178 L00-P000020050820178 1,990,000.00 5
179 L00-M000000200508179 1,800,000.00 5
180 L00-M000000200508180 1,500,000.00 5
181 L00-M000000200508181 1,800,000.00 5
182 L00-M000000200508182 1,500,000.00 3
183 L00-C000000020050183 2,100,000.00 4
184 L00-C000000020050184 1,500,000.00 3
185 L00-D000002005082185 1,800,000.00 4
186 L00-P000020050820186 575,000.00 2
187 L00-M000000200508187 950,000.00 1
188 L00-D000002005082188 1,500,000.00 3
189 L00-D000002005082189 1,200,000.00 1
190 L00-M000000200508190 2,100,000.00 3
191 L00-M000000200508191 950,000.00 1
192 L00-P000020050820192 2,100,000.00 5
193 L00-M000000200508193 1,990,000.00 1
194 L00-C000000020050194 575,000.00 1
195 L00-P000020050820195 910,000.00 4
196 L00-M000000200508196 1,500,000.00 5
197 L00-M000000200508197 1,500,000.00 5
198 L00-P000020050820198 910,000.00 2
199 L00-D000002005082199 910,000.00 4
200 L00-M000000200508200 1,990,000.00 5
201 L00-D000002005082201 2,100,000.00 2
202 L00-D000002005082202 2,100,000.00 2
203 L00-M000000200508203 575,000.00 3
204 L00-P000020050820204 950,000.00 4
205 L00-M000000200508205 1,800,000.00 4
206 L00-M000000200508206 910,000.00 5
207 L00-D000002005082207 1,500,000.00 1
208 L00-C000000020050208 1,500,000.00 2
209 L00-D000002005082209 2,100,000.00 1
210 L00-D000002005082210 2,100,000.00 1
211 L00-P000020050820211 910,000.00 3
212 L00-P000020050820212 575,000.00 2
213 L00-D000002005082213 950,000.00 1
214 L00-P000020050820214 1,990,000.00 5
215 L00-P000020050820215 1,200,000.00 2
216 L00-D000002005082216 1,990,000.00 2
217 L00-M000000200508217 1,500,000.00 4
218 L00-M000000200508218 2,500,000.00 5
219 L00-D000002005082219 950,000.00 5
220 L00-M000000200508220 910,000.00 3
221 L00-C000000020050221 2,500,000.00 1
222 L00-C000000020050222 1,990,000.00 4
223 L00-C000000020050223 2,100,000.00 4
224 L00-M000000200508224 2,100,000.00 5
225 L00-P000020050820225 1,990,000.00 1
226 L00-M000000200508226 1,990,000.00 1
227 L00-D000002005082227 1,500,000.00 4
228 L00-D000002005082228 2,500,000.00 5
229 L00-D000002005082229 1,500,000.00 3
230 L00-M000000200508230 1,390,000.00 4
231 L00-C000000020050231 1,390,000.00 1
232 L00-M000000200508232 1,990,000.00 1
233 L00-D000002005082233 950,000.00 1
234 L00-P000020050820234 1,990,000.00 4
235 L00-C000000020050235 1,990,000.00 5
236 L00-M000000200508236 950,000.00 1
237 L00-D000002005082237 1,200,000.00 4
238 L00-P000020050820238 910,000.00 4
239 L00-M000000200508239 950,000.00 4
240 L00-C000000020050240 1,800,000.00 4
241 L00-C000000020050241 2,500,000.00 1
242 L00-C000000020050242 1,390,000.00 5
243 L00-P000020050820243 575,000.00 3
244 L00-M000000200508244 910,000.00 3
245 L00-D000002005082245 1,200,000.00 3
246 L00-M000000200508246 1,800,000.00 3
247 L00-C000000020050247 950,000.00 5
248 L00-D000002005082248 2,500,000.00 2
249 L00-C000000020050249 2,100,000.00 1
250 L00-M000000200508250 2,500,000.00 3
251 L00-P000020050820251 950,000.00 1
252 L00-M000000200508252 1,390,000.00 4
253 L00-D000002005082253 910,000.00 4
254 L00-P000020050820254 1,800,000.00 5
255 L00-C000000020050255 910,000.00 5
256 L00-P000020050820256 2,500,000.00 5
257 L00-D000002005082257 1,800,000.00 3
258 L00-C000000020050258 950,000.00 1
259 L00-D000002005082259 1,200,000.00 3
260 L00-C000000020050260 575,000.00 2
261 L00-D000002005082261 1,800,000.00 1
262 L00-D000002005082262 2,100,000.00 1
263 L00-P000020050820263 1,390,000.00 2
264 L00-M000000200508264 910,000.00 4
265 L00-M000000200508265 1,500,000.00 5
266 L00-M000000200508266 2,100,000.00 5
267 L00-M000000200508267 1,990,000.00 2
268 L00-C000000020050268 1,800,000.00 3
269 L00-C000000020050269 1,200,000.00 5
270 L00-D000002005082270 1,390,000.00 3
271 L00-P000020050820271 1,800,000.00 2
272 L00-C000000020050272 1,390,000.00 5
273 L00-D000002005082273 1,200,000.00 1
274 L00-D000002005082274 1,200,000.00 5
275 L00-M000000200508275 1,500,000.00 4
276 L00-M000000200508276 2,100,000.00 1
277 L00-P000020050820277 950,000.00 5
278 L00-C000000020050278 910,000.00 2
279 L00-C000000020050279 2,500,000.00 2
280 L00-P000020050820280 575,000.00 1
281 L00-D000002005082281 1,390,000.00 4
282 L00-M000000200508282 1,800,000.00 1
283 L00-D000002005082283 2,100,000.00 1
284 L00-C000000020050284 1,200,000.00 3
285 L00-D000002005082285 1,200,000.00 4
286 L00-M000000200508286 1,990,000.00 1
287 L00-C000000020050287 1,500,000.00 3
288 L00-P000020050820288 1,990,000.00 1
289 L00-D000002005082289 575,000.00 4
290 L00-D000002005082290 1,200,000.00 5
291 L00-P000020050820291 1,500,000.00 2
292 L00-P000020050820292 950,000.00 5
293 L00-P000020050820293 2,500,000.00 1
294 L00-D000002005082294 575,000.00 3
295 L00-C000000020050295 910,000.00 2
296 L00-C000000020050296 1,800,000.00 5
297 L00-P000020050820297 2,100,000.00 4
298 L00-C000000020050298 1,500,000.00 2
299 L00-C000000020050299 950,000.00 4
300 L00-P000020050820300 1,500,000.00 4
301 L00-M000000200508301 2,100,000.00 2
302 L00-C000000020050302 1,200,000.00 3
303 L00-D000002005082303 1,200,000.00 3
304 L00-D000002005082304 1,800,000.00 2
305 L00-D000002005082305 575,000.00 3
306 L00-C000000020050306 2,500,000.00 1
307 L00-C000000020050307 1,990,000.00 3
308 L00-C000000020050308 575,000.00 1
309 L00-M000000200508309 2,100,000.00 4
310 L00-D000002005082310 575,000.00 4
311 L00-C000000020050311 1,800,000.00 1
312 L00-C000000020050312 575,000.00 4
313 L00-P000020050820313 1,500,000.00 3
314 L00-D000002005082314 1,800,000.00 1
315 L00-M000000200508315 950,000.00 1
316 L00-D000002005082316 1,990,000.00 1
317 L00-P000020050820317 1,390,000.00 1
318 L00-M000000200508318 2,500,000.00 1
319 L00-C000000020050319 1,500,000.00 5
320 L00-D000002005082320 1,990,000.00 4
321 L00-C000000020050321 1,200,000.00 5
322 L00-C000000020050322 2,500,000.00 5
323 L00-C000000020050323 950,000.00 2
324 L00-D000002005082324 1,200,000.00 5
325 L00-P000020050820325 1,200,000.00 1
326 L00-M000000200508326 1,390,000.00 4
327 L00-D000002005082327 1,800,000.00 4
328 L00-M000000200508328 910,000.00 5
329 L00-C000000020050329 575,000.00 4
330 L00-P000020050820330 1,800,000.00 3
331 L00-P000020050820331 1,500,000.00 5
332 L00-P000020050820332 1,990,000.00 4
333 L00-C000000020050333 2,100,000.00 4
334 L00-M000000200508334 1,800,000.00 5
335 L00-D000002005082335 1,200,000.00 3
336 L00-D000002005082336 575,000.00 4
337 L00-C000000020050337 950,000.00 3
338 L00-M000000200508338 950,000.00 3
339 L00-M000000200508339 2,500,000.00 2
340 L00-D000002005082340 950,000.00 4
341 L00-C000000020050341 2,100,000.00 3
342 L00-D000002005082342 2,500,000.00 1
343 L00-C000000020050343 1,990,000.00 4
344 L00-D000002005082344 910,000.00 1
345 L00-M000000200508345 2,500,000.00 2
346 L00-P000020050820346 1,390,000.00 2
347 L00-P000020050820347 1,800,000.00 4
348 L00-C000000020050348 2,500,000.00 5
349 L00-D000002005082349 1,200,000.00 1
350 L00-D000002005082350 1,990,000.00 5
351 L00-M000000200508351 1,500,000.00 2
352 L00-C000000020050352 2,500,000.00 3
353 L00-C000000020050353 910,000.00 2
354 L00-D000002005082354 575,000.00 1
355 L00-M000000200508355 1,800,000.00 3
356 L00-M000000200508356 1,500,000.00 4
357 L00-P000020050820357 910,000.00 1
358 L00-P000020050820358 950,000.00 4
359 L00-M000000200508359 1,990,000.00 2
360 L00-C000000020050360 950,000.00 2
Interest Rate Defaulters Pending
% (p.a.) EMI State Status Installments
8.80% ₹ -79,266.83 Delhi
8.25% ₹ -40,588.54 Delhi
9.10% ₹ -63,565.59 Pune
8.50% ₹ -36,929.76 Mumbai yes 49
9.10% ₹ -24,968.31 Delhi
9.25% ₹ -43,847.79 Pune
8.80% ₹ -24,793.71 Chennai yes 24
8.00% ₹ -19,262.57 Chennai
9.10% ₹ -11,963.98 Chennai
9.25% ₹ -29,043.75 Delhi
9.25% ₹ -52,199.75 Delhi yes 32
8.90% ₹ -47,629.82 Pune
8.00% ₹ -56,405.46 Chennai
8.60% ₹ -61,738.86 Pune
9.20% ₹ -63,629.42 Pune yes 18
9.10% ₹ -44,878.60 Mumbai
8.90% ₹ -28,786.70 Mumbai
9.25% ₹ -41,551.00 Delhi
8.80% ₹ -18,231.37 Delhi
9.25% ₹ -47,874.32 Pune
8.00% ₹ -54,272.75 Chennai
8.75% ₹ -50,217.96 Chennai
8.80% ₹ -57,072.12 Chennai
8.80% ₹ -26,215.99 Pune yes 7
8.90% ₹ -218,512.78 Pune
9.25% ₹ -43,847.79 Delhi yes 19
8.60% ₹ -81,902.58 Chennai
8.60% ₹ -29,634.65 Chennai
8.75% ₹ -19,605.37 Mumbai yes 48
8.90% ₹ -79,383.03 Mumbai
8.80% ₹ -30,121.40 Chennai yes 31
8.80% ₹ -113,982.58 Mumbai
8.25% ₹ -47,177.74 Mumbai
8.25% ₹ -66,048.83 Mumbai yes 15
8.00% ₹ -67,840.94 Chennai
9.25% ₹ -14,377.25 Delhi
8.00% ₹ -156,579.17 Chennai
8.80% ₹ -43,388.99 Chennai
8.60% ₹ -14,199.94 Pune yes 2
9.20% ₹ -11,991.94 Delhi
8.50% ₹ -41,364.66 Pune yes 10
9.20% ₹ -68,664.84 Mumbai yes 3
8.80% ₹ -18,801.90 Pune
8.60% ₹ -82,902.79 Pune
9.25% ₹ -37,583.82 Delhi
8.80% ₹ -121,428.67 Delhi yes 6
8.80% ₹ -18,801.90 Chennai
8.60% ₹ -34,326.80 Delhi yes 3
8.60% ₹ -30,847.14 Chennai
8.80% ₹ -131,038.14 Chennai
8.25% ₹ -34,097.32 Mumbai
9.10% ₹ -218,744.64 Delhi
8.60% ₹ -68,252.15 Chennai
8.80% ₹ -18,801.90 Pune
8.25% ₹ -28,621.16 Mumbai
8.00% ₹ -48,581.72 Pune
9.20% ₹ -218,860.62 Delhi
9.10% ₹ -79,615.74 Delhi
8.25% ₹ -173,337.09 Delhi
8.75% ₹ -95,697.26 Pune
8.75% ₹ -82,026.22 Delhi
8.60% ₹ -14,199.94 Pune
8.80% ₹ -95,745.37 Delhi
9.25% ₹ -52,199.75 Delhi yes 33
8.25% ₹ -28,350.79 Pune yes 14
9.25% ₹ -157,621.41 Mumbai
8.60% ₹ -30,033.20 Mumbai
9.25% ₹ -18,351.82 Pune
9.25% ₹ -30,320.40 Mumbai
9.10% ₹ -66,877.22 Mumbai
8.75% ₹ -11,866.41 Chennai yes 51
9.20% ₹ -43,487.73 Mumbai
8.25% ₹ -82,748.86 Mumbai
8.25% ₹ -23,303.92 Pune
9.20% ₹ -157,579.65 Mumbai
9.20% ₹ -114,441.40 Mumbai yes 4
8.25% ₹ -82,748.86 Mumbai
8.60% ₹ -43,186.00 Chennai
9.10% ₹ -44,266.35 Chennai
9.10% ₹ -19,766.58 Delhi
9.25% ₹ -105,080.94 Pune
8.00% ₹ -30,414.59 Mumbai
8.80% ₹ -90,730.14 Delhi
8.50% ₹ -18,670.04 Mumbai
8.00% ₹ -43,943.26 Pune
8.90% ₹ -30,165.55 Delhi
8.50% ₹ -24,619.84 Pune
9.20% ₹ -43,487.73 Pune
8.90% ₹ -51,774.64 Chennai
8.80% ₹ -63,374.32 Pune
8.60% ₹ -56,905.01 Mumbai
8.50% ₹ -54,546.81 Mumbai yes 16
8.60% ₹ -56,905.01 Chennai
8.90% ₹ -44,136.96 Delhi
8.25% ₹ -14,105.00 Pune
9.25% ₹ -114,498.83 Chennai
8.50% ₹ -36,972.46 Mumbai
8.00% ₹ -47,004.55 Pune
9.10% ₹ -22,688.62 Mumbai
8.75% ₹ -30,099.33 Delhi
8.50% ₹ -173,567.37 Delhi
8.90% ₹ -37,256.38 Pune
8.75% ₹ -157,204.06 Chennai
9.10% ₹ -14,336.22 Delhi
8.00% ₹ -48,581.72 Mumbai
8.80% ₹ -44,072.36 Delhi
8.00% ₹ -28,516.09 Mumbai
9.25% ₹ -49,757.80 Pune
8.50% ₹ -34,261.14 Pune
9.20% ₹ -114,441.40 Delhi
8.80% ₹ -79,496.47 Pune yes 10
8.50% ₹ -61,620.76 Pune
8.75% ₹ -38,020.21 Delhi
8.60% ₹ -26,163.32 Pune
8.00% ₹ -43,943.26 Delhi
8.00% ₹ -41,156.84 Pune
9.25% ₹ -114,498.83 Mumbai
8.00% ₹ -14,037.43 Mumbai
8.60% ₹ -121,299.87 Pune
8.60% ₹ -183,258.80 Mumbai yes 3
9.25% ₹ -22,753.57 Chennai
8.25% ₹ -79,264.70 Delhi
8.80% ₹ -28,853.13 Mumbai
8.00% ₹ -156,579.17 Chennai
8.80% ₹ -43,388.99 Delhi
8.00% ₹ -61,032.31 Mumbai
8.75% ₹ -24,764.68 Pune
8.90% ₹ -173,936.17 Chennai
9.10% ₹ -79,623.05 Chennai
8.50% ₹ -66,291.83 Mumbai
9.20% ₹ -52,138.89 Mumbai
8.80% ₹ -61,975.46 Pune
8.80% ₹ -68,389.55 Chennai
8.00% ₹ -182,675.70 Pune
9.10% ₹ -28,921.62 Mumbai
8.60% ₹ -90,547.85 Pune
9.25% ₹ -79,790.53 Delhi
8.50% ₹ -23,415.89 Pune
8.75% ₹ -157,204.06 Pune
8.80% ₹ -18,801.90 Chennai
8.90% ₹ -121,493.10 Chennai
8.60% ₹ -173,659.53 Delhi
8.00% ₹ -36,619.38 Mumbai
8.25% ₹ -61,326.11 Delhi
8.00% ₹ -22,215.76 Delhi
8.50% ₹ -23,415.89 Delhi
9.25% ₹ -19,835.90 Delhi
8.25% ₹ -42,832.13 Pune
8.00% ₹ -18,018.41 Chennai
9.20% ₹ -41,502.56 Chennai yes 42
9.20% ₹ -57,407.21 Chennai
8.50% ₹ -11,797.01 Mumbai
8.80% ₹ -26,215.99 Pune
8.60% ₹ -28,585.02 Mumbai
8.80% ₹ -218,396.90 Pune
8.80% ₹ -68,389.55 Pune
8.00% ₹ -24,331.67 Delhi
9.20% ₹ -25,026.67 Pune
9.10% ₹ -24,968.31 Chennai
8.80% ₹ -28,853.13 Mumbai
9.20% ₹ -63,629.42 Pune
8.80% ₹ -43,313.38 Chennai yes 2
8.80% ₹ -37,185.28 Chennai
8.00% ₹ -48,581.72 Delhi
8.80% ₹ -66,584.14 Chennai
8.75% ₹ -43,291.62 Delhi
8.50% ₹ -54,546.81 Delhi
9.25% ₹ -105,080.94 Delhi yes 10
8.60% ₹ -19,536.52 Chennai yes 47
8.25% ₹ -24,475.50 Pune
8.60% ₹ -14,199.94 Mumbai
8.75% ₹ -28,831.99 Delhi
9.20% ₹ -63,629.42 Mumbai
8.00% ₹ -28,184.19 Delhi
8.90% ₹ -104,886.13 Mumbai
8.25% ₹ -26,071.30 Pune
8.00% ₹ -22,215.76 Pune
9.20% ₹ -41,502.56 Pune
9.10% ₹ -37,452.46 Mumbai
9.20% ₹ -31,283.33 Mumbai
9.25% ₹ -37,583.82 Mumbai
8.75% ₹ -47,525.26 Mumbai
8.90% ₹ -52,158.93 Chennai
8.60% ₹ -47,420.84 Chennai
8.75% ₹ -44,579.71 Delhi
8.00% ₹ -26,005.69 Pune yes 10
9.10% ₹ -83,122.96 Mumbai
8.80% ₹ -47,560.10 Delhi
9.25% ₹ -105,080.94 Delhi
8.75% ₹ -66,535.37 Mumbai
8.25% ₹ -82,748.86 Mumbai
8.00% ₹ -42,580.43 Pune
8.00% ₹ -173,106.97 Mumbai
8.80% ₹ -50,231.29 Chennai yes 6
9.10% ₹ -22,688.62 Pune
9.25% ₹ -31,319.85 Mumbai
8.75% ₹ -30,955.85 Mumbai
8.25% ₹ -41,260.67 Pune
9.20% ₹ -22,731.91 Delhi
9.10% ₹ -41,405.77 Mumbai
8.75% ₹ -95,697.26 Delhi
9.20% ₹ -96,130.78 Delhi
8.90% ₹ -18,258.10 Mumbai
8.50% ₹ -23,415.89 Pune
9.25% ₹ -45,007.06 Mumbai
9.10% ₹ -18,934.30 Mumbai
9.25% ₹ -131,351.18 Delhi yes 1
8.60% ₹ -68,252.15 Chennai yes 22
8.00% ₹ -182,675.70 Delhi
9.10% ₹ -183,745.50 Delhi
8.25% ₹ -28,621.16 Pune yes 31
9.10% ₹ -26,295.12 Pune
9.25% ₹ -83,189.08 Delhi
8.60% ₹ -40,923.87 Pune yes 53
8.75% ₹ -54,684.15 Pune
8.50% ₹ -90,456.79 Delhi
9.25% ₹ -37,505.88 Mumbai
9.20% ₹ -52,138.89 Mumbai
9.25% ₹ -19,835.90 Delhi yes 52
8.80% ₹ -28,853.13 Mumbai
8.50% ₹ -218,049.46 Chennai yes 3
8.80% ₹ -49,332.47 Chennai
8.60% ₹ -51,860.64 Chennai
8.90% ₹ -43,490.70 Mumbai
8.60% ₹ -173,659.53 Pune
9.25% ₹ -174,259.23 Mumbai
9.10% ₹ -37,398.83 Delhi
8.50% ₹ -51,291.33 Delhi
8.75% ₹ -47,525.26 Delhi
8.50% ₹ -34,261.14 Mumbai
8.25% ₹ -121,074.65 Chennai
9.25% ₹ -174,259.23 Mumbai
8.50% ₹ -82,858.79 Delhi
8.60% ₹ -49,144.13 Pune
8.60% ₹ -40,923.87 Chennai
8.90% ₹ -83,034.86 Mumbai
9.25% ₹ -30,004.70 Delhi
8.90% ₹ -22,602.20 Pune yes 22
8.60% ₹ -23,460.77 Mumbai
8.25% ₹ -44,154.80 Chennai
8.60% ₹ -218,165.24 Chennai
8.60% ₹ -28,585.02 Chennai
9.10% ₹ -18,311.62 Pune
8.60% ₹ -28,768.64 Mumbai yes 9
9.25% ₹ -38,299.46 Delhi
8.00% ₹ -56,405.46 Mumbai
8.25% ₹ -19,376.44 Chennai
8.00% ₹ -113,068.23 Delhi
9.10% ₹ -183,745.50 Chennai
8.60% ₹ -79,034.74 Mumbai
8.60% ₹ -82,902.79 Pune
8.25% ₹ -34,097.32 Mumbai
8.50% ₹ -22,429.96 Delhi
8.25% ₹ -36,713.25 Pune
8.25% ₹ -18,560.59 Chennai
8.75% ₹ -51,593.08 Pune
8.50% ₹ -56,821.57 Delhi
9.10% ₹ -83,122.96 Chennai
9.10% ₹ -38,215.55 Delhi
8.75% ₹ -26,202.82 Chennai
9.20% ₹ -157,579.65 Delhi
8.60% ₹ -183,258.80 Delhi
8.90% ₹ -63,438.04 Pune
8.60% ₹ -22,472.94 Mumbai
9.10% ₹ -31,210.38 Mumbai
8.60% ₹ -43,186.00 Mumbai
8.25% ₹ -90,229.38 Mumbai
8.25% ₹ -56,613.28 Chennai yes 27
8.90% ₹ -24,851.83 Chennai
8.80% ₹ -44,072.36 Delhi
9.25% ₹ -82,439.16 Pune
8.90% ₹ -28,786.70 Chennai
9.20% ₹ -105,053.10 Delhi
8.25% ₹ -24,475.50 Delhi
8.80% ₹ -37,185.28 Mumbai yes 42
8.60% ₹ -183,258.80 Mumbai
9.10% ₹ -19,766.58 Pune yes 19
8.50% ₹ -41,364.66 Chennai
8.60% ₹ -113,753.58 Chennai
8.50% ₹ -50,151.37 Pune
8.50% ₹ -34,261.14 Delhi
9.20% ₹ -157,579.65 Mumbai
9.20% ₹ -183,842.92 Delhi
8.25% ₹ -37,742.19 Chennai
8.25% ₹ -29,436.53 Delhi
8.80% ₹ -173,843.93 Mumbai
8.80% ₹ -47,560.10 Chennai
8.75% ₹ -173,797.82 Pune
9.10% ₹ -14,336.22 Delhi
9.25% ₹ -25,055.88 Delhi
8.50% ₹ -68,183.51 Pune
8.80% ₹ -19,628.35 Pune
8.25% ₹ -217,760.16 Pune yes 10
8.60% ₹ -18,177.99 Delhi
8.75% ₹ -41,468.81 Chennai
9.25% ₹ -37,583.82 Chennai
8.75% ₹ -52,009.66 Pune
8.75% ₹ -68,355.18 Chennai
8.90% ₹ -23,595.71 Chennai
9.10% ₹ -37,398.83 Pune
8.50% ₹ -95,456.92 Mumbai
8.80% ₹ -38,048.08 Chennai yes 16
8.90% ₹ -38,103.85 Delhi
8.25% ₹ -81,614.52 Delhi
9.10% ₹ -18,311.62 Delhi
8.50% ₹ -218,049.46 Chennai
8.90% ₹ -63,188.89 Chennai
9.25% ₹ -50,351.28 Chennai
8.90% ₹ -52,158.93 Mumbai yes 7
8.75% ₹ -14,240.74 Delhi yes 8
8.75% ₹ -157,204.06 Chennai
8.00% ₹ -14,037.43 Chennai yes 1
8.00% ₹ -47,004.55 Pune
8.50% ₹ -156,995.61 Delhi
9.20% ₹ -83,167.04 Mumbai
9.20% ₹ -174,213.06 Delhi
8.60% ₹ -121,299.87 Pune
8.90% ₹ -218,512.78 Mumbai
8.25% ₹ -30,594.38 Chennai
8.80% ₹ -49,332.47 Delhi
8.80% ₹ -24,793.71 Chennai
8.00% ₹ -50,690.99 Chennai
8.00% ₹ -42,965.93 Chennai yes 23
9.20% ₹ -25,026.67 Delhi
8.80% ₹ -104,830.51 Pune
9.20% ₹ -34,722.36 Mumbai
8.90% ₹ -44,707.65 Delhi
9.25% ₹ -19,000.71 Mumbai
9.25% ₹ -14,377.25 Chennai
8.00% ₹ -56,405.46 Pune
9.20% ₹ -31,283.33 Pune
9.25% ₹ -49,757.80 Pune
8.50% ₹ -51,761.44 Chennai
8.90% ₹ -37,277.74 Mumbai
8.50% ₹ -37,881.04 Delhi
8.90% ₹ -14,281.61 Delhi
8.00% ₹ -29,769.55 Chennai
9.20% ₹ -30,298.25 Mumbai
9.20% ₹ -114,441.40 Mumbai
9.10% ₹ -23,685.93 Delhi
8.00% ₹ -65,806.37 Chennai
8.25% ₹ -217,760.16 Delhi
8.25% ₹ -48,815.58 Chennai yes 9
8.50% ₹ -79,370.00 Delhi
8.25% ₹ -113,353.49 Mumbai
9.10% ₹ -63,565.59 Pune yes 8
8.90% ₹ -44,707.65 Pune
8.60% ₹ -51,411.90 Chennai
8.50% ₹ -104,663.74 Delhi
8.80% ₹ -41,116.23 Delhi yes 7
9.10% ₹ -68,595.96 Mumbai
8.60% ₹ -79,034.74 Chennai
8.50% ₹ -41,364.66 Chennai
9.25% ₹ -50,351.28 Delhi yes 8
9.20% ₹ -57,407.21 Mumbai
8.75% ₹ -37,149.75 Mumbai
8.75% ₹ -79,475.38 Pune yes 8
9.10% ₹ -23,685.93 Pune
8.60% ₹ -90,547.85 Mumbai
9.20% ₹ -43,487.73 Chennai
T2
No of Loan
Sno State cases. Total Loan allocated
1 Delhi 96 ₹ 144,740,000
2 Mumbai 92 ₹ 144,250,000
3 Pune 86 ₹ 120,070,000
4 Chennai 86 ₹ 127,845,000

T3
Sno Summary Answers
1 Total No. of defaulters 49
2 Higest interest rate charged 9.25%
3 lowest interest Rate charged 8%
Mean Loan No. of
Allocated defaulters
₹ 1,507,708.33 11
₹ 1,567,934.78 10
₹ 1,396,162.79 14
₹ 1,486,569.77 14
Assignment 2 Spreadsheet for Business (SFB)

- Refer to 'Loan Data Summary' data-sheet for data and answer the following:
- Witout using any helper cell or extra cell for calculation answer using excel formulae / functions

- Find out the EMI for every Loan-ID in respective G column


- Fill the columns in Table T1, T2 & T3 marked with 'X' with appropriate answer using Excel functions
- Values should not be hard coded and must calculated using excel functions / formulae(s).
ormulae / functions

wer using Excel functions


formulae(s).

You might also like