Spreadsheet: 838617d1691167854-create-projection-recovery-of-report-02082023-excel-forum-file
Sheet: Result

 |  |  |  |  |  |  | Report Date >>>> | 2023-06-30 00:00:00 | 6 | 7 | 14 | 3 | 3 | 6 | 24 | 24 | 300
DATA TABLE |  |  |  |  |  |  | RESULT TABLE |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-07-01 00:00:00 | 2023-07-07 00:00:00 | 2023-07-14 00:00:00 | 2023-07-28 00:00:00 | 2023-09-30 00:00:00 | 2023-12-30 00:00:00 | 2024-06-30 00:00:00 | 2026-06-30 00:00:00 | 2028-06-30 00:00:00 | 2053-06-30 00:00:00
Product Code | Account | Installement Start Date | [NAME] | InstalmentAmt | Outstanding |  | Date Day | NEXT DAY | 2-7 DAYS | 8-14 DAYS | 15-28 DAYS | 29 DAYS AND UPTO 3 MONTHS | OVER 3 MONTHS AND UPTO 6 MONTHS | OVER 6 MONTHS AND UPTO 1 YEAR | OVER 1 YEAR AND UPTO 3 YEAR | OVER 3 YEAR AND UPTO 5 YEAR | OVER 5 YEAR
764 | 1 | 2017-02-01 00:00:00 | 2024-02-01 00:00:00 | 1434600 | 23105110.2 |  |  | 1434600 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 2023-07-01 00:00:00
751 | 13 | 2012-11-18 00:00:00 | 2030-11-18 00:00:00 | 1004297 | 59234979 |  |  | 0 | 0 | 0 | 1004297 |  |  |  |  |  |  |  |  |  |  |  |  | 2023-07-07 00:00:00
751 | 16 | 2014-10-12 00:00:00 | 2027-10-12 00:00:00 | 889932 | 36049852 |  |  | 0 | 0 | 889932 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 2023-07-14 00:00:00
764 | 5 | 2022-10-20 00:00:00 | 2032-10-20 00:00:00 | 861376 | 57127327 |  |  | 0 | 0 | 0 | 861376 |  |  |  |  |  |  |  |  |  |  |  |  | 2023-07-28 00:00:00
750 | 4 | 2012-12-09 00:00:00 | 2022-12-09 00:00:00 | 826932 | 58890978 |  |  | 58890978 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  | 2023-09-30 00:00:00
751 | 19 | 2020-06-01 00:00:00 | 2028-06-01 00:00:00 | 789090 | 51498215 |  |  | 789090 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 2023-12-30 00:00:00
751 | 4 | 2018-02-28 00:00:00 | 2023-02-28 00:00:00 | 701666 | 30495011 |  |  | 30495011 | 0 | 0 | 701666 | 0 | 0 |  |  |  |  |  |  |  |  |  |  | 2024-06-30 00:00:00
764 | 3 | 2017-07-06 00:00:00 | 2023-07-06 00:00:00 | 621293 | 38470054 |  |  | 0 | 38470054 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  | 2026-06-30 00:00:00
753 | 1 | 2015-12-06 00:00:00 | 2018-12-06 00:00:00 | 577132 | 15123728 |  |  | 15123728 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  | 2028-06-30 00:00:00
751 | 21 | 2022-09-28 00:00:00 | 2032-09-28 00:00:00 | 563148 | 40337073 |  |  | 0 | 0 | 0 | 563148 |  |  |  |  |  |  |  |  |  |  |  |  | 2053-06-30 00:00:00
857 | 2 | 2020-11-02 00:00:00 | 2028-11-02 00:00:00 | 541604 | 24732479 |  |  | 0 | 541604 | 0 | 0
751 | 22 | 2019-10-20 00:00:00 | 2029-10-20 00:00:00 | 513841 | 28210662 |  |  | 0 | 0 | 0 | 513841
751 | 23 | 2019-10-07 00:00:00 | 2024-10-07 00:00:00 | 492797 | 7833 |  |  | 0 | 7833 | 0 | 0 | 0 | 0
751 | 24 | 2014-11-19 00:00:00 | 2029-11-19 00:00:00 | 492084 | 7094695 |  |  | 0 | 0 | 0 | 492084
751 | 25 | 2021-07-30 00:00:00 | 2027-07-30 00:00:00 | 485450 | 21464662.36 |  |  | 0 | 0 | 0 | 0
601 | 2 | 2011-07-29 00:00:00 | 2023-07-29 00:00:00 | 483257 | 27363037.2 |  |  | 0 | 0 | 0 | 0 | 27363037.2
751 | 38 | 2017-04-17 00:00:00 | 2030-04-17 00:00:00 | 479664 | 13721502.99 |  |  | 0 | 0 | 0 | 479664 | 0
764 | 9 | 2020-02-28 00:00:00 | 2034-02-28 00:00:00 | 465000 | 24599888.15 |  |  | 0 | 0 | 0 | 465000 | 0
751 | 32 | 2019-10-22 00:00:00 | 2025-10-22 00:00:00 | 460197 | 12147786.2 |  |  | 0 | 0 | 0 | 460197 | 0
751 | 43 | 2017-10-28 00:00:00 | 2027-10-28 00:00:00 | 441543 | 17021285 |  |  | 0 | 0 | 0 | 441543 | 0
750 | 11 | 2013-03-23 00:00:00 | 2033-03-23 00:00:00 | 421787 | 30109915 |  |  | 0 | 0 | 0 | 421787 | 0
751 | 106 | 2018-04-14 00:00:00 | 2024-04-14 00:00:00 | 421650 | 22541178 |  |  | 0 | 0 | 421650 | 0 | 0