Sample Data-Car Owners 678300.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V
1	Name	Mobile No	Address	Pin Code	City	Submodel	Model	Assettype	Misstatus	Tenor	Roi	Irr	Noadvemi	Emiamt	Netltv	Mfrsubded	Mfrsubnded	Dlrsubded	Dlrsubnded	Dsasubded	Promotiondesc	Product
2	Munnu Kumar	9871689335	H No-D-57 Jai Vihar Sunday Market 110043 Delhi	110043	Delhi	DLS	INDICA	New Asset	Disbursed	24	5.85	12.79482	2	7500	40.0690077	0	0	0	0	0	NORMAL	A
3	Mahesh Kumar	9873360566	S/O Mr Laxman Hno 582 Block-B Sangam Vihar Nr Opp Ganpati Properties 110062 Delhi	110062	Delhi	LXi	WAGON R	New Asset	Disbursed	36	5.09	11.6193001	1	8108	67.8418075	0	0	0	0	0	NORMAL	A
4	Subhash .	9873378503	313 Rishi Nagar Rani Bagh Near Shiv Mandir Gali 110034 Delhi	110034	Delhi	LXi	ALTO	New Asset	Disbursed	60	7.3	13.7931	1	6222	89.9228974	0	0	0	0	0	NORMAL	A
5	Om Prakash Kunwar	9971479851	H No WZ 24 Dasghara Toda Pur Delhi 110012 Delhi	110012	Delhi	AC	M 800	New Asset	Disbursed	48	6.89	12.9045488	1	5378	88.8372428	0	0	0	0	0	NORMAL	A
6	Mamta Rani	9999036055	239 FF Rishi Nagar Rani Bagh Near Canara Bank 110034 Delhi	110034	Delhi	V	INNOVA	New Asset	Disbursed	60	5.91	12.39054	1	21840	93.112869	0	0	0	0	0	NORMAL	A
7	Akash Ahuja	9910950599	H No 45/2 Ashok Nagar Tilak Nagar Metro Station 110018 Delhi	110018	Delhi	VXI	ESTEEM	New Asset	Disbursed	60	6.82	13.03662	2	10170	82.3302176	0	0	0	0	0	REPAYMENT PRODUCT	A
8	Sunil Gujral	9873957494	GG 2/55 C Durgyana Appts Vikas Puri Near Durgyana Mandir 110018 Delhi	110018	Delhi	ZX 1.5 GXI	CITY	New Asset	Disbursed	59	5.94	12.29034	1	15283	91.549118	0	0	0	0	0	WOLOAN-ALL LOANS IN NAME OF WOMAN	A
9	Hemant Kumar	9999695051	H No-G-60 Block-G Kunwar Singh Nagar Ranholla , 110015 Delhi	110015	Delhi	SLX	BOLERO	New Asset	Disbursed	47	6.35	12.14274	1	13445	82.3274112	0	0	0	0	0	NORMAL	A
10	Raj Kumar	9999636520	7/22A Tilak Nagar , 110018 Delhi	110018	Delhi	XO M	SANTRO	New Asset	Disbursed	60	7.59	13.80174	1	8136	85.8219465	0	0	0	0	0	NORMAL	A
11	Chetan Mehla	9990000304	H No-266/B Ward No-2 Mehrauli Prince Public School 110030 Delhi	110030	Delhi	LX	ALTO	New Asset	Disbursed	48	7.05	13.17366	1	6485	84.8694875	0	0	0	0	0	NORMAL	A
12	Gagandeep Kaur	9899980373	H No 116A Gali No 5 South Anarkali Krishna Nagar Nr Brijwasi Sweet 110051 Delhi	110051	Delhi	XL - AT	SANTRO XL - AT	New Asset	Disbursed	84	6.5	12.96054	1	3500	54.0747305	0	0	0	0	0	NORMAL	A
13	Geetanjli Gupta	9711410516	151, Chaudhary Mohalla, Dhool Siras Village, Nr. Bus Stand 110010 Delhi	110010	Delhi	DIESEL DLE1.5 dci	LOGAN	New Asset	Disbursed	36	6.45	13.12434	1	14770	77.5708112	0	0	0	0	0	NORMAL	A
14	Harish Joshi	9999276463	H No-53 Police Apartment A 3 Pashim Vihar Delhi 110063 Delhi	110063	Delhi	ESTILO LX	ZEN	New Asset	Disbursed	32	7.01	13.5800364	1	10329	74.7700435	0	0	0	0	0	NORMAL	A
15	Sumit Bhandari	9953007166	Pkt 14/79 Pocket-14 Rohini Sector-24 Delhi Near-Delhi Public School 110081 Delhi	110081	Delhi	B3	TAVERA	New Asset	Disbursed	35	7.57	13.73226	0	17545	67.3591184	0	0	0	0	0	NORMAL	A
16	Lalit Kumar Saini	9711209817	H No 122/27 Block CPJ New Seelam Pur Near Naveen Public School 110053 Delhi	110053	Delhi	VXI	ESTEEM	New Asset	Disbursed	60	7.16	13.0701	1	8695	74.3913605	0	0	0	0	0	NORMAL	A
17	Mohit .	9971292567	H No A315 Block A Pandav Nagar , 110092 Delhi	110092	Delhi	E	OMNI	New Asset	Disbursed	60	7.54	13.70658	1	5150	92.7046149	0	0	0	0	0	NORMAL	A
18	Mohit Kumar Garg	9873229908	C/O Shri Chand,H.No-C-53, Sreet No-7, West Jyoti Nagar,Behind Gopal Nusring Hm Near Durga Puri Chowk,Shahdara, 110032 Delhi	110032	Delhi	2.6	SCORPIO	New Asset	Disbursed	31	6.93	12.90054	0	22966	85.032929	0	0	0	0	0	NORMAL	A
19	Pankaj Kumar Maurya	9811635414	Plot No-12B Gali No-1 Deep Enclave Part-1 Vikas Nagar Uttam Nagar Nr Verma Road and Tapan Cable 110059 Delhi	110059	Delhi	XL	SANTRO	New Asset	Disbursed	60	6.27	11.5603801	1	6642	83.0050195	0	0	0	0	0	NORMAL	A
20	Pawan Bajaj	9873917216	S/O Mr Raj Kumar H No 170 B/11 4Th Flor East Of Kailash Gali No 11 Top Floor Nr Durga Store 110065 Delhi	110065	Delhi	LXi	WAGON R	New Asset	Disbursed	84	7.29	12.52278	0	5420	83.8940251	0	0	0	0	0	LOANS FOR I BANK EMPLOYEES	A
21	Neeraj Kumar Suji	9873541115	H No A-62 Basement Haus Khas , 110016 Delhi	110016	Delhi	VXI	SWIFT	New Asset	Disbursed	36	6	12.46854	0	9235	65.5309528	0	0	0	0	0	NORMAL	A
22	Asim	9999138699	25-A Ganesh Park Rasheed Market Krishna Nagar nr by narang kite houseDelhi 110051 Delhi	110051	Delhi	VXI	ZEN	New Asset	Disbursed	60	6.6	12.7969744	1	7667	87.9673214	0	0	0	0	0	NORMAL	A
23	Riya Sharma	9999206642	H No-227 Chandan Park Gali-5-6 Libas Pur Near Tom Jerry Convent School 110042 Delhi	110042	Delhi	LXI	WAGON R	New Asset	Disbursed	60	7.15	13.0646707	1	7367	87.8514667	0	0	0	0	0	INXS-CROSS SELL	A
24	Pawan .	9873656207	H No 117/11 SBM Qtrs Tulsi Ram Bhawan Najaf Garh Road Shivaji Marg Moti Nagar Near Blue Dart Courier 110015 Delhi	110015	Delhi	LXI	WAGON R	New Asset	Disbursed	48	5.77	12.1381761	1	7785	81.1870707	0	0	0	0	0	NORMAL	A
25	Harish Chand Sharma	9868026224	26 Kasturba Polytechnic Staff Quater Nr-Kastura Politecnic 110085 Delhi	110085	Delhi	XL	SANTRO	New Asset	Disbursed	31	5.67	12.2117998	1	5620	40.8042144	0	0	0	0	0	NORMAL	A
26	Rajesh Saraswat	9810032046	B - 148 Ashoka Enclave Peera Garhi Metro Station 110087 Delhi	110087	Delhi	DLS	INDICA	New Asset	Disbursed	24	6.13	12.21714	1	11850	66.0353815	0	0	0	0	0	NORMAL	A
27	Seema Shukla	9953895828	H No-18/899, Flats Baba Kharak Singh Marg, Near-R,M,L,Hospital, 110001 Delhi	110001	Delhi	1.4 ZXI	FIESTA	New Asset	Disbursed	42	6.93	13.04106	0	16368	86.9977855	0	0	0	0	0	NORMAL	A
28	Sulochana .	9953709491	E-32A 3rd Floor Left Side Portion Vishwakarma Colony M B Road Nr Suraj Kund Crossing 110044 Delhi	110044	Delhi	VDI	SWIFT	New Asset	Disbursed	36	5.09	11.6190601	1	9732	54.3267827	0	0	0	0	0	NORMAL	A
29	Sumit Kumar Vashney	9899884577	H No-A-1/15 Sanjay Enclave Uttam Nagar Nr-Sahil Chatbhandar 110059 Delhi	110059	Delhi	LXI	SWIFT	New Asset	Disbursed	36	6.47	13.12626	1	11620	77.2550632	0	0	0	0	0	NORMAL	A
30	Vikram Vij	9711601377	S/o Vikram Raj Vij House No-S-2/219 Tilak Nagar Old Mahavir Nagar Near-Om Dairy 110018 Delhi	110018	Delhi	XL	SANTRO	New Asset	Disbursed	60	7	12.91674	1	7394	87.6962498	0	0	0	0	0	NORMAL	A
31	Yameen Khan	9717780054	House No-F-191/S-3 Top Floor Dilshad Colony Seemapuri me hosptal 110095 Delhi	110095	Delhi	CRDI	VERNA	New Asset	Disbursed	60	6.55	11.6859001	0	13460	78.4475426	0	0	60	0	0	NORMAL	A
32	Yogesh Kumar	9711195527	H No-138-A A-Block Vikash Vihar Kakrola Delhi Near NSIT 110043 Delhi	110043	Delhi	AC	M 800	New Asset	Disbursed	36	5.6	12.86898	1	6080	85.9485711	0	0	0	0	0	NORMAL	A
33	Lalit Kumar	9891552325	R1/21 Phase-1 Budh Vihar Delhi near Sai Dham Mandir 110086 Delhi	110086	Delhi	ZXI	SX4	New Asset	Disbursed	60	7.16	13.06566	1	14414	87.9408571	0	0	0	0	0	NORMAL	A
34	Jayant Kumar Sharma	9716308664	Hno 82 Crossing 1 Blk-A Gl-5 Uttrakhand Enclave Burari Behind Joshp Merry School 110084 Delhi	110084	Delhi	1.9 RIDER	SKODA	New Asset	Disbursed	36	5.35	13.09818	1	35200	86.9916312	0	0	0	0	0	NORMAL	A
35	Kuldeep Singh Tariyal	9811964233	A/2-140G, Pocket A-2, LIG Mayur Vihar Phase 3 .. 110096 Delhi	110096	Delhi	4X2	ENDEAVOUR	New Asset	Disbursed	56	5.8	12.4671	2	29160	80.5370555	0	0	0	0	0	NORMAL	A
36	Yashpal Singh	9818245505	Kh No-17/13, Gali No-10 Amrit Vihar, Burari Near Paradise Public School 110084 Delhi	110084	Delhi	LXi	ALTO	New Asset	Disbursed	60	6.57	12.0765	1	5598	84.5427155	0	0	0	0	0	NORMAL	A
37	Ruchika Khurana	9999239317	36-B PocketA-2 Mayur Vihar Ph-3 Opp Super Dry Cleaner 110096 Delhi	110096	Delhi	1.4 ZXI TDCI	FIESTA	New Asset	Disbursed	72	7.69	13.7169	0	14421	94.9758195	0	0	0	0	0	NORMAL	A
38	Gaurav Arora	9873340774	H. No- B-223 Ashok Vihar-1 Near D Cinema 110052 Delhi	110052	Delhi	AC	M 800	New Asset	Disbursed	60	6.47	12.56202	1	4461	88.3050976	0	0	0	0	0	NORMAL	A
39	Davinder Singh	9999232922	7 Staff Qtr Gurudwara Nanak Piao GTK Road Model Town 110009 Delhi	110009	Delhi	XL	SANTRO	New Asset	Disbursed	12	0.46	14.5036699	1	22771	70.8079175	0	0	13280	0	0	NORMAL	A
40	Mukesh Kumar	9899354939	D-302 D-Blk Part-2 Qutab Vihar Vihar Goyla Dairy OPG World Sc 110071 Delhi	110071	Delhi	XO M	SANTRO	New Asset	Disbursed	84	7.08	13.73562	0	7015	93.0848853	0	0	0	0	0	NORMAL	A
41	R K Mathur	9873518895	S/O B P Mathur37 Block B Vishwarkrma Colony Lal Kuan Nr Vishkarma Mandir 110044 Delhi	110044	Delhi	LXi	ALTO	New Asset	Disbursed	60	6.55	11.6895001	0	5830	94.7541636	0	0	0	0	0	NORMAL	A
42	Riya Sikka	9953863330	h 271 delhi vikaspuri nr brain international school 110018 Delhi	110018	Delhi	DLE	INDICA	New Asset	Disbursed	36	7.73	13.99278	0	9020	74.9835437	0	0	0	0	0	NORMAL	A
43	Ruchika Sabhrwal	9711264293	House Nno C-3/309 Janakpuri Near Desu Colony 110058 Delhi	110058	Delhi	SPARK 1.0 LT	SPARK	New Asset	Disbursed	60	6.7	13.54362	1	7875	86.5992351	0	0	0	0	0	NORMAL	A
44	Ashok Kumar	9711260838	D-96 MCD Flats Azad Pur Azad pur Metro Station 110033 Delhi	110033	Delhi	XL	SANTRO	New Asset	Disbursed	36	5.53	12.12846	1	3936	35.3479703	0	0	0	0	0	NORMAL	A
45	Chandramani Mani	9811973216	945 Sector-3 R K Puram Near LBS 110022 Delhi	110022	Delhi	GXI	CITY	New Asset	Disbursed	36	5.6	12.1227266	1	23000	92.6480933	0	0	0	0	0	NORMAL	A
46	Holisol Logisitics Private Limited Robbin Kumar	9873927260	A1 Carriappa Marg, Sainik Farms Nr Saket road 110062 Delhi	110062	Delhi	LXi	ALTO	New Asset	Disbursed	36	6.99	13.40874	1	8777	86.8630082	0	0	0	0	0	NORMAL	A
47	Naveen .	9899206378	S/o Jogender Singh, H No-B-35 Vijay Nagar, Bawana Delhi Nr White Leat Public School Narela Road 110039 Delhi	110039	Delhi	LXi	ALTO	New Asset	Disbursed	48	6.39	13.1401064	1	5824	74.1455174	0	0	4400	0	0	NORMAL	A
48	Akash .	9711811524	C-80 Gali No-19 Khajoori Khas Karawal Nagar Nr Corporationbank Atm 110094 Delhi	110094	Delhi	XO M	SANTRO	New Asset	Disbursed	36	6.57	12.64638	1	10775	82.0181953	0	0	0	0	0	NORMAL	A
49	Sunil Kumar Zunglan	9711774828	H No G-1857 Block G Tigri Colony , 110062 Delhi	110062	Delhi	BOLERO	BOLERO	New Asset	Disbursed	35	7.55	13.70406	0	15400	84.9785424	0	0	0	0	0	NORMAL	A
50	Kapil Sharma	9899416225	H No 25 D Block Gali No 10 11 Jagat Puri Nr Aman Public School 110093 Delhi	110093	Delhi	AC	M 800	New Asset	Disbursed	60	7.3	13.30866	1	3220	61.3220236	0	0	0	0	0	NORMAL	A
51	Kapil Sharma	9899649114	D-25 Blk-D Gali No-10 Jagat Puri Extn Aman Public School 110093 Delhi	110093	Delhi	DLS	INDICA	New Asset	Disbursed	60	6.18	12.32538	1	6886	87.8632725	0	0	0	0	0	NORMAL	A
52	Chandra ..	9654990301	D-239 Phase 4 New Colony Street No 8 Aya Nagar Nr Shiv Mandir 110047 Delhi	110047	Delhi	LXI	WAGON R	New Asset	Disbursed	36	6.17	12.1449	1	10833	82.8062731	0	0	0	0	0	NORMAL	A
53	Brijesh Kumar Singh	9716360435	H No-25 Gali No- 1 Moralband Extn. Badarpur Nr Ram Rasoi 110044 Delhi	110044	Delhi	1.6 SXI	FIESTA	New Asset	Disbursed	60	6.94	13.1163	1	14528	87.0888332	0	0	0	0	0	NORMAL	A
54	Ashish Kumar	9718021670	H No-C-3/7 Block-C R P Bagh Nr Nanak Piyau Gurudwara 110007 Delhi	110007	Delhi	XL	SANTRO	New Asset	Disbursed	60	6.8	12.5636104	1	6504	79.655228	0	0	0	0	0	NORMAL	A
55	Prashant Thakur	9999553343	Vijay Thakur B-150,Gali No-2,Kh No-39/4, Burari Near By Pd Joshi Kothi 110084 Delhi	110084	Delhi	LPG	OMNI	New Asset	Disbursed	36	7.29	13.23906	0	5109	60.5859877	0	0	0	0	0	NORMAL	A
56	Ashutosh Gunjan	9910519144	H No 510/18 Deoli Village Nr Sent Merry Pub School 110062 Delhi	110062	Delhi	XO	SANTRO	New Asset	Disbursed	60	6.79	13.0503	1	7675	87.9313219	0	0	0	0	0	NORMAL	A
57	Rahul .	9811793537	S/o Saroj H No-B-139 Gautam Puri Ph-2 Near-Kali Mandir and NTPC 110044 Delhi	110044	Delhi	DLX	INDICA	New Asset	Disbursed	36	5.78	12.6159669	1	8417	61.213886	0	0	0	0	0	NORMAL	A
58	Aayush Yadav	9811515904	S/O Leela Singh H No-8/87 Jain Mandir Gali Chhota Bazar Shahadara Nr-Sahadara Metro Station 110032 Delhi	110032	Delhi	LXi	ALTO	New Asset	Disbursed	48	6.05	11.4131401	1	6927	87.6441846	0	0	0	0	0	NORMAL	A
59	Anshu Chauhan	9999309404	76,New Chaupal Dhakka Village Nr Kingsway Camp 110009 Delhi	110009	Delhi	XO M	SANTRO	New Asset	Disbursed	60	8.24	14.42022	0	6625	74.2666172	0	0	0	0	0	NORMAL	A
60	Manmeet S Malhotra	9899992609	H No-208 Block-B 1st Floor Karampura Nr-Moti Nagar Metro 110015 Delhi	110015	Delhi	1.8 V MT	CIVIC	New Asset	Disbursed	36	5.23	11.8099801	2	22785	56.5626621	0	0	0	0	0	NORMAL	A
61	Abhishek Singh	9711770975	A-88 , 1St F Floor Bhagwan Nagar Ashram 110014 Delhi	110014	Delhi	8 SEATER	OMNI	New Asset	Disbursed	59	8.22	14.40054	0	4785	85.4927374	0	0	0	0	0	NORMAL	A
62	Gulshan Verma	9873156653	62 Pol No - 69 V P O Issapur New Delhi Jaggu Ganral Store 110061 Delhi	110061	Delhi	XO M	SANTRO	New Asset	Disbursed	36	5.9	13.36014	1	12482	96.6839955	0	0	0	0	0	NORMAL	A
63	Neeraj Dagar	9899181483	S/o Mahinder Singh Dagar VPO Issa Pur Near Jaggu Genral Near Store Wali Gali 110073 Delhi	110073	Delhi	LXi	ALTO	New Asset	Disbursed	60	6.61	12.91218	0	6020	89.0298712	0	0	0	0	0	INXS-CROSS SELL	A
64	Mahima Chawla	9999017278	B-55, Derawal Nagar,Opp-Model Town-2nd Near By Opp-Model Town-2nd 110009 Delhi	110009	Delhi	XO	SANTRO	New Asset	Disbursed	36	5.72	12.31734	1	6578	51.2414166	0	0	0	0	0	NORMAL	A
65	Sushma Kumari Sawhney	9899207831	Flat No-52 F/F Back Side Block-A gulab Bagh Uttam Nagar 110059 Delhi	110059	Delhi	XL AT	SANTRO	New Asset	Disbursed	36	6.44	12.40002	1	6712	45.8538043	0	0	0	0	0	NORMAL	A
66	R C Rohit	9811505357	200 F, Pkt-1, Mayur Vihar Ph-1, - 110091 Delhi	110091	Delhi	G4	INNOVA	New Asset	Disbursed	36	5.2	11.8653001	1	16265	54.906245	0	0	0	0	0	NORMAL	A
67	Ajay Kumar	9953970563	139 ,D -Block Dcm Colony Nathu Pura Burari Dcm Colony 110084 Delhi	110084	Delhi	XO	SANTRO	New Asset	Disbursed	60	6.71	12.80322	1	6190	70.9901811	0	0	0	0	0	NORMAL	A
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100