ABCDEFGHIJKLMNOPQRSTUVWXY
1
CMG Overall Ageing as on 30 June 2020
2
3
No.First NameDate Of BirthCMG Due on 25 YearsToday's DateCurrent AgeDays until CMG is Due
CMG as on 30 June 2020 (Rs.)
Project3 Mths3M - 6M6M - 1 Y1Y - 2 Y2Y - 3Y3Y - 5Y5Y- 10Y10Y - 20Y20Y - 30Y> 30Y
Total Overdue CMG
4
503550922
PHPExcel Test Document
7/23/19957/23/202010/3/202530 Years 2 Months 10Days#NUM!16,158SFC Alibaug16,158---------16,158
5
503564363First Name6/9/20016/9/202610/3/202524 Years 3 Months 24Days0 Years, 8 Months and 6 Days30,884SFC Alibaug----30,884-----30,884
6
503336932Lydia4/1/19964/1/202110/3/202529 Years 6 Months 2Days#NUM!8,088SFC Alwaye-Cochin----8,088-----8,088
7
500011783Jasmine3/11/19963/11/202110/3/202529 Years 6 Months 22Days#NUM!437,809SFC Alwaye-Cochin---437,809------437,809
8
503309696Albert5/27/19965/27/202110/3/202529 Years 4 Months 6Days#NUM!122,459SFC Alwaye-Cochin---122,459------122,459
9
500011792Eric7/21/19967/21/202110/3/202529 Years 2 Months 12Days#NUM!303,912SFC Alwaye-Cochin---303,912------303,912
10
503378502Alen10/17/199610/17/202110/3/2025
28 Years 11 Months 16Days
#NUM!37,171SFC Alwaye-Cochin--37,171-------37,171
11
500011801Justin12/26/199612/26/202110/3/202528 Years 9 Months 7Days#NUM!984,621SFC Alwaye-Cochin--984,621-------984,621
12
500011800Kimberly12/28/199612/28/202110/3/202528 Years 9 Months 5Days#NUM!1,036,272SFC Alwaye-Cochin--1,036,272-------1,036,272
13
503359327Antony7/23/19957/23/202010/3/202530 Years 2 Months 10Days#NUM!56,099SFC Alwaye-Cochin-------56,099--56,099
14
503309760Amber7/23/19957/23/202010/3/202530 Years 2 Months 10Days#NUM!16,571SFC Alwaye-Cochin------16,571---16,571
15
503384689Lucas10/10/19977/27/202010/3/2025
27 Years 11 Months 23Days
#NUM!164,533SFC Alwaye-Cochin-----164,533----164,533
16
503337518Roland7/23/19957/23/202010/3/202530 Years 2 Months 10Days#NUM!351,363SFC Alwaye-Cochin------351,363---351,363
17
503461470Alan7/23/19957/23/202010/3/202530 Years 2 Months 10Days#NUM!46,230SFC Alwaye-Cochin-----46,230----46,230
18
500011814Rosie7/23/19957/23/202010/3/202530 Years 2 Months 10Days#NUM!288,947SFC Alwaye-Cochin---288,947------288,947
19
503359340Lilianna10/4/199910/4/202410/3/2025
25 Years 11 Months 29Days
#NUM!46,654SFC Alwaye-Cochin-------46,654--46,654
20
503336948Alina7/23/19957/23/202010/3/202530 Years 2 Months 10Days#NUM!6,561SFC Alwaye-Cochin-------6,561--6,561
21
502068513Julian7/23/19957/23/202010/3/202530 Years 2 Months 10Days#NUM!86,083SFC Alwaye-Cochin-------86,083--86,083
22
503336935George7/23/19957/23/202010/3/202530 Years 2 Months 10Days#NUM!21,543SFC Alwaye-Cochin-------21,543--21,543
23
503378474Camila9/17/20019/17/202610/3/202524 Years 0 Months 16Days0 Years, 11 Months and 14 Days25,593SFC Alwaye-Cochin-------25,593--25,593
24
503378531Ashton11/10/200111/10/202610/3/2025
23 Years 10 Months 23Days
1 Years, 1 Months and 7 Days20,723SFC Alwaye-Cochin------20,723---20,723
25
503581311Reid3/15/20013/15/202610/3/202524 Years 6 Months 18Days0 Years, 5 Months and 12 Days32,180SFC Alwaye-Cochin------32,180---32,180
26
503480757
PHPExcel Test Document
7/23/19957/23/202010/3/202530 Years 2 Months 10Days#NUM!148,282SFC Alwaye-Cochin--148,282-------148,282
27
503378544Wells3/8/20043/8/202910/3/202521 Years 6 Months 25Days3 Years, 5 Months and 5 Days22,013SFC Alwaye-Cochin------22,013---22,013
28
503478467Farrell7/23/19957/23/202010/3/202530 Years 2 Months 10Days#NUM!4,124SFC Alwaye-Cochin------4,124---4,124
29
503513232Gray7/20/20057/20/203010/3/202520 Years 2 Months 13Days4 Years, 9 Months and 17 Days2,411SFC Alwaye-Cochin------2,411---2,411
30
503530786Myers7/23/19957/23/202010/3/202530 Years 2 Months 10Days#NUM!3,194SFC Alwaye-Cochin------3,194---3,194
31
503336961Clark1/4/20071/4/203210/3/202518 Years 8 Months 29Days6 Years, 3 Months and 1 Days42,256SFC Alwaye-Cochin---42,256------42,256
32
503518160Grant3/12/20083/12/203310/3/202517 Years 6 Months 21Days7 Years, 5 Months and 9 Days145,090SFC Alwaye-Cochin------145,090---145,090
33
503617413
PHPExcel Test Document
5/22/20085/22/203310/3/202517 Years 4 Months 11Days7 Years, 7 Months and 19 Days27,486SFC Alwaye-Cochin--27,486-------27,486
34
503672385Hawkins2/5/20102/5/203510/3/202515 Years 7 Months 28Days9 Years, 4 Months and 2 Days33,327SFC Alwaye-Cochin---33,327------33,327
35
503535544West6/28/20116/28/203610/3/202514 Years 3 Months 5Days10 Years, 8 Months and 25 Days152,569SFC Alwaye-Cochin-----152,569----152,569
36
 4,721,206
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
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