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/2/202530 Years 2 Months 9Days#NUM!16,158SFC Alibaug16,158---------16,158
5
503564363First Name6/9/20016/9/202610/2/202524 Years 3 Months 23Days0 Years, 8 Months and 7 Days30,884SFC Alibaug----30,884-----30,884
6
503336932Lydia4/1/19964/1/202110/2/202529 Years 6 Months 1Days#NUM!8,088SFC Alwaye-Cochin----8,088-----8,088
7
500011783Jasmine3/11/19963/11/202110/2/202529 Years 6 Months 21Days#NUM!437,809SFC Alwaye-Cochin---437,809------437,809
8
503309696Albert5/27/19965/27/202110/2/202529 Years 4 Months 5Days#NUM!122,459SFC Alwaye-Cochin---122,459------122,459
9
500011792Eric7/21/19967/21/202110/2/202529 Years 2 Months 11Days#NUM!303,912SFC Alwaye-Cochin---303,912------303,912
10
503378502Alen10/17/199610/17/202110/2/2025
28 Years 11 Months 15Days
#NUM!37,171SFC Alwaye-Cochin--37,171-------37,171
11
500011801Justin12/26/199612/26/202110/2/202528 Years 9 Months 6Days#NUM!984,621SFC Alwaye-Cochin--984,621-------984,621
12
500011800Kimberly12/28/199612/28/202110/2/202528 Years 9 Months 4Days#NUM!1,036,272SFC Alwaye-Cochin--1,036,272-------1,036,272
13
503359327Antony7/23/19957/23/202010/2/202530 Years 2 Months 9Days#NUM!56,099SFC Alwaye-Cochin-------56,099--56,099
14
503309760Amber7/23/19957/23/202010/2/202530 Years 2 Months 9Days#NUM!16,571SFC Alwaye-Cochin------16,571---16,571
15
503384689Lucas10/10/19977/27/202010/2/2025
27 Years 11 Months 22Days
#NUM!164,533SFC Alwaye-Cochin-----164,533----164,533
16
503337518Roland7/23/19957/23/202010/2/202530 Years 2 Months 9Days#NUM!351,363SFC Alwaye-Cochin------351,363---351,363
17
503461470Alan7/23/19957/23/202010/2/202530 Years 2 Months 9Days#NUM!46,230SFC Alwaye-Cochin-----46,230----46,230
18
500011814Rosie7/23/19957/23/202010/2/202530 Years 2 Months 9Days#NUM!288,947SFC Alwaye-Cochin---288,947------288,947
19
503359340Lilianna10/4/199910/4/202410/2/2025
25 Years 11 Months 28Days
#NUM!46,654SFC Alwaye-Cochin-------46,654--46,654
20
503336948Alina7/23/19957/23/202010/2/202530 Years 2 Months 9Days#NUM!6,561SFC Alwaye-Cochin-------6,561--6,561
21
502068513Julian7/23/19957/23/202010/2/202530 Years 2 Months 9Days#NUM!86,083SFC Alwaye-Cochin-------86,083--86,083
22
503336935George7/23/19957/23/202010/2/202530 Years 2 Months 9Days#NUM!21,543SFC Alwaye-Cochin-------21,543--21,543
23
503378474Camila9/17/20019/17/202610/2/202524 Years 0 Months 15Days0 Years, 11 Months and 15 Days25,593SFC Alwaye-Cochin-------25,593--25,593
24
503378531Ashton11/10/200111/10/202610/2/2025
23 Years 10 Months 22Days
1 Years, 1 Months and 8 Days20,723SFC Alwaye-Cochin------20,723---20,723
25
503581311Reid3/15/20013/15/202610/2/202524 Years 6 Months 17Days0 Years, 5 Months and 13 Days32,180SFC Alwaye-Cochin------32,180---32,180
26
503480757
PHPExcel Test Document
7/23/19957/23/202010/2/202530 Years 2 Months 9Days#NUM!148,282SFC Alwaye-Cochin--148,282-------148,282
27
503378544Wells3/8/20043/8/202910/2/202521 Years 6 Months 24Days3 Years, 5 Months and 6 Days22,013SFC Alwaye-Cochin------22,013---22,013
28
503478467Farrell7/23/19957/23/202010/2/202530 Years 2 Months 9Days#NUM!4,124SFC Alwaye-Cochin------4,124---4,124
29
503513232Gray7/20/20057/20/203010/2/202520 Years 2 Months 12Days4 Years, 9 Months and 18 Days2,411SFC Alwaye-Cochin------2,411---2,411
30
503530786Myers7/23/19957/23/202010/2/202530 Years 2 Months 9Days#NUM!3,194SFC Alwaye-Cochin------3,194---3,194
31
503336961Clark1/4/20071/4/203210/2/202518 Years 8 Months 28Days6 Years, 3 Months and 2 Days42,256SFC Alwaye-Cochin---42,256------42,256
32
503518160Grant3/12/20083/12/203310/2/202517 Years 6 Months 20Days7 Years, 5 Months and 10 Days145,090SFC Alwaye-Cochin------145,090---145,090
33
503617413
PHPExcel Test Document
5/22/20085/22/203310/2/202517 Years 4 Months 10Days7 Years, 7 Months and 20 Days27,486SFC Alwaye-Cochin--27,486-------27,486
34
503672385Hawkins2/5/20102/5/203510/2/202515 Years 7 Months 27Days9 Years, 4 Months and 3 Days33,327SFC Alwaye-Cochin---33,327------33,327
35
503535544West6/28/20116/28/203610/2/202514 Years 3 Months 4Days10 Years, 8 Months and 26 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