Spreadsheet: 679269d1590304142-emi-calculation-with-floating-rate-of-interest-and-part-payment-hdfc-amrt-workcopy
Sheet: Sheet1

[NAME] | From Date | To Date | Opening Prin. Bal. | Prep/Adj /Disb | ROI | EMI | Months | EMI Rcble | Int. Comp. | [NAME]. | Closing Prin | No Rest Ind. | Opening Prin. Bal. | Prep/Adj /Disb | ROI | EMI | Months | EMI Rcble | Int. Comp. | [NAME]. | Closing Prin
Amrt | 2017-08-01 00:00:00 | 2017-08-31 00:00:00 | 1500000 |  | 8.5 | 14772 | 1 | 14772 | 10625 | 4147 | 1495853
Amrt | 2017-09-01 00:00:00 | 2017-09-30 00:00:00 | 1495853 |  | 8.5 | 14772 | 1 | 14772 | 10596 | 4176 | 1491677
Amrt | 2017-10-01 00:00:00 | 2017-10-31 00:00:00 | 1491677 |  | 8.5 | 14772 | 1 | 14772 | 10566 | 4206 | 1487471
 | 2017-11-01 00:00:00 | 2017-11-01 00:00:00 | 1487471 | 1900000 | 0 | 0 | 0 | 0 | 0 | 0 | 3387471
Amrt | 2017-11-01 00:00:00 | 2017-11-30 00:00:00 | 3387471 |  | 8.5 | 33358 | 1 | 33358 | 23995 | 9363 | 3378108
 | 2017-12-01 00:00:00 | 2017-12-01 00:00:00 | 3378108 | 1571892 | 0 | 0 | 0 | 0 | 0 | 0 | 4950000
Amrt | 2017-12-01 00:00:00 | 2017-12-31 00:00:00 | 4950000 |  | 8.5 | 50991 | 1 | 50991 | 35063 | 15928 | 4934072
Amrt | 2018-01-01 00:00:00 | 2018-01-31 00:00:00 | 4934072 |  | 8.4 | 50684 | 1 | 50684 | 34539 | 16145 | 4917927
Amrt | 2018-02-01 00:00:00 | 2018-02-28 00:00:00 | 4917927 |  | 8.4 | 50684 | 1 | 50684 | 34425 | 16259 | 4901668
Amrt | 2018-03-01 00:00:00 | 2018-03-31 00:00:00 | 4901668 |  | 8.4 | 50684 | 1 | 50684 | 34312 | 16372 | 4885296
Amrt | 2018-04-01 00:00:00 | 2018-04-30 00:00:00 | 4885296 |  | 8.6 | 50684 | 1 | 50684 | 35011 | 15673 | 4869623
Amrt | 2018-05-01 00:00:00 | 2018-05-31 00:00:00 | 4869623 |  | 8.6 | 50684 | 1 | 50684 | 34899 | 15785 | 4853838
Amrt | 2018-06-01 00:00:00 | 2018-06-30 00:00:00 | 4853838 |  | 8.6 | 50684 | 1 | 50684 | 34786 | 15898 | 4837940
Amrt | 2018-07-01 00:00:00 | 2018-07-31 00:00:00 | 4837940 |  | 8.7 | 50684 | 1 | 50684 | 35075 | 15609 | 4822331
Amrt | 2018-08-01 00:00:00 | 2018-08-31 00:00:00 | 4822331 |  | 8.7 | 50684 | 1 | 50684 | 34962 | 15722 | 4806609
Amrt | 2018-09-01 00:00:00 | 2018-09-30 00:00:00 | 4806609 |  | 8.7 | 50684 | 1 | 50684 | 34848 | 15836 | 4790773
Amrt | 2018-10-01 00:00:00 | 2018-10-31 00:00:00 | 4790773 |  | 9 | 50684 | 1 | 50684 | 35931 | 14753 | 4776020
Amrt | 2018-11-01 00:00:00 | 2018-11-30 00:00:00 | 4776020 |  | 9 | 50684 | 1 | 50684 | 35820 | 14864 | 4761156
Amrt | 2018-12-01 00:00:00 | 2018-12-31 00:00:00 | 4761156 |  | 9 | 50684 | 1 | 50684 | 35709 | 14975 | 4746181
Amrt | 2019-01-01 00:00:00 | 2019-01-31 00:00:00 | 4746181 |  | 9.1 | 50684 | 1 | 50684 | 35992 | 14692 | 4731489
Amrt | 2019-02-01 00:00:00 | 2019-02-28 00:00:00 | 4731489 |  | 9.1 | 50684 | 1 | 50684 | 35880 | 14804 | 4716685
Amrt | 2019-03-01 00:00:00 | 2019-03-31 00:00:00 | 4716685 |  | 9.1 | 50684 | 1 | 50684 | 35768 | 14916 | 4701769
Amrt | 2019-04-01 00:00:00 | 2019-04-30 00:00:00 | 4701769 |  | 9.1 | 50684 | 1 | 50684 | 35655 | 15029 | 4686740
Amrt | 2019-05-01 00:00:00 | 2019-05-31 00:00:00 | 4686740 |  | 9.1 | 50684 | 1 | 50684 | 35541 | 15143 | 4671597
Amrt | 2019-06-01 00:00:00 | 2019-06-30 00:00:00 | 4671597 |  | 9.1 | 50684 | 1 | 50684 | 35426 | 15258 | 4656339
Amrt | 2019-07-01 00:00:00 | 2019-07-31 00:00:00 | 4656339 |  | 9.1 | 50684 | 1 | 50684 | 35311 | 15373 | 4640966
Amrt | 2019-08-01 00:00:00 | 2019-08-31 00:00:00 | 4640966 |  | 9.1 | 50684 | 1 | 50684 | 35194 | 15490 | 4625476
Amrt | 2019-09-01 00:00:00 | 2019-09-30 00:00:00 | 4625476 |  | 9.1 | 50684 | 1 | 50684 | 35077 | 15607 | 4609869
Amrt | 2019-10-01 00:00:00 | 2019-10-31 00:00:00 | 4609869 |  | 9 | 50684 | 1 | 50684 | 34574 | 16110 | 4593759
Amrt | 2019-11-01 00:00:00 | 2019-11-30 00:00:00 | 4593759 |  | 9 | 50684 | 1 | 50684 | 34453 | 16231 | 4577528
Amrt | 2019-12-01 00:00:00 | 2019-12-31 00:00:00 | 4577528 |  | 8.7 | 49796 | 1 | 49796 | 33187 | 16609 | 4560919
Amrt | 2020-01-01 00:00:00 | 2020-01-31 00:00:00 | 4560919 |  | 8.7 | 49796 | 1 | 49796 | 33067 | 16729 | 4544190
Amrt | 2020-02-01 00:00:00 | 2020-02-29 00:00:00 | 4544190 |  | 8.7 | 49796 | 1 | 49796 | 32945 | 16851 | 4527339
Amrt | 2020-03-01 00:00:00 | 2020-03-31 00:00:00 | 4527339 |  | 8.65 | 49796 | 1 | 49796 | 32635 | 17161 | 4510178
Amrt | 2020-04-01 00:00:00 | 2020-04-30 00:00:00 | 4510178 |  | 8.65 | 49796 | 1 | 49796 | 32511 | 17285 | 4492893
Proj | 2020-05-01 00:00:00 | 2020-05-31 00:00:00 | 4492893 |  | 8.65 | 49796 | 1 | 49796 | 32386 | 17410 | 4475483
Proj | 2020-06-01 00:00:00 | 2020-06-30 00:00:00 | 4475483 |  | 8.65 | 49796 | 1 | 49796 | 32261 | 17535 | 4457948
Proj | 2020-07-01 00:00:00 | 2020-07-31 00:00:00 | 4457948 |  | 8.65 | 49796 | 1 | 49796 | 32134 | 17662 | 4440286
Proj | 2020-08-01 00:00:00 | 2020-08-31 00:00:00 | 4440286 |  | 8.65 | 49796 | 1 | 49796 | 32007 | 17789 | 4422497
Proj | 2020-09-01 00:00:00 | 2020-09-30 00:00:00 | 4422497 |  | 8.65 | 49796 | 1 | 49796 | 31879 | 17917 | 4404580
Proj | 2020-10-01 00:00:00 | 2020-10-31 00:00:00 | 4404580 |  | 8.65 | 49796 | 1 | 49796 | 31750 | 18046 | 4386534
Proj | 2020-11-01 00:00:00 | 2020-11-30 00:00:00 | 4386534 |  | 8.65 | 49796 | 1 | 49796 | 31620 | 18176 | 4368358
Proj | 2020-12-01 00:00:00 | 2020-12-31 00:00:00 | 4368358 |  | 8.65 | 49796 | 1 | 49796 | 31489 | 18307 | 4350051
Proj | 2021-01-01 00:00:00 | 2021-01-31 00:00:00 | 4350051 |  | 8.65 | 49796 | 1 | 49796 | 31357 | 18439 | 4331612
Proj | 2021-02-01 00:00:00 | 2021-02-28 00:00:00 | 4331612 |  | 8.65 | 49796 | 1 | 49796 | 31224 | 18572 | 4313040
Proj | 2021-03-01 00:00:00 | 2021-03-31 00:00:00 | 4313040 |  | 8.65 | 49796 | 1 | 49796 | 31090 | 18706 | 4294334
Proj | 2021-04-01 00:00:00 | 2021-04-30 00:00:00 | 4294334 |  | 8.65 | 49796 | 1 | 49796 | 30955 | 18841 | 4275493
Proj | 2021-05-01 00:00:00 | 2021-05-31 00:00:00 | 4275493 |  | 8.65 | 49796 | 1 | 49796 | 30819 | 18977 | 4256516
Proj | 2021-06-01 00:00:00 | 2021-06-30 00:00:00 | 4256516 |  | 8.65 | 49796 | 1 | 49796 | 30682 | 19114 | 4237402
Proj | 2021-07-01 00:00:00 | 2021-07-31 00:00:00 | 4237402 |  | 8.65 | 49796 | 1 | 49796 | 30545 | 19251 | 4218151
Proj | 2021-08-01 00:00:00 | 2021-08-31 00:00:00 | 4218151 |  | 8.65 | 49796 | 1 | 49796 | 30406 | 19390 | 4198761
Proj | 2021-09-01 00:00:00 | 2021-09-30 00:00:00 | 4198761 |  | 8.65 | 49796 | 1 | 49796 | 30266 | 19530 | 4179231
Proj | 2021-10-01 00:00:00 | 2021-10-31 00:00:00 | 4179231 |  | 8.65 | 49796 | 1 | 49796 | 30125 | 19671 | 4159560
Proj | 2021-11-01 00:00:00 | 2021-11-30 00:00:00 | 4159560 |  | 8.65 | 49796 | 1 | 49796 | 29983 | 19813 | 4139747
Proj | 2021-12-01 00:00:00 | 2021-12-31 00:00:00 | 4139747 |  | 8.65 | 49796 | 1 | 49796 | 29841 | 19955 | 4119792
Proj | 2022-01-01 00:00:00 | 2022-01-31 00:00:00 | 4119792 |  | 8.65 | 49796 | 1 | 49796 | 29697 | 20099 | 4099693
Proj | 2022-02-01 00:00:00 | 2022-02-28 00:00:00 | 4099693 |  | 8.65 | 49796 | 1 | 49796 | 29552 | 20244 | 4079449
Proj | 2022-03-01 00:00:00 | 2022-03-31 00:00:00 | 4079449 |  | 8.65 | 49796 | 1 | 49796 | 29406 | 20390 | 4059059
Proj | 2022-04-01 00:00:00 | 2022-04-30 00:00:00 |  |  | 8.65
Proj | 2022-05-01 00:00:00 | 2022-05-31 00:00:00
Proj | 2022-06-01 00:00:00 | 2022-06-30 00:00:00
Proj | 2022-07-01 00:00:00 | 2022-07-31 00:00:00
Proj | 2022-08-01 00:00:00 | 2022-08-31 00:00:00
Proj | 2022-09-01 00:00:00 | 2022-09-30 00:00:00
Proj | 2022-10-01 00:00:00 | 2022-10-31 00:00:00
Proj | 2022-11-01 00:00:00 | 2022-11-30 00:00:00
Proj | 2022-12-01 00:00:00 | 2022-12-31 00:00:00
Proj | 2023-01-01 00:00:00 | 2023-01-31 00:00:00
Proj | 2023-02-01 00:00:00 | 2023-02-28 00:00:00
Proj | 2023-03-01 00:00:00 | 2023-03-31 00:00:00
Proj | 2023-04-01 00:00:00 | 2023-04-30 00:00:00
Proj | 2023-05-01 00:00:00 | 2023-05-31 00:00:00
Proj | 2023-06-01 00:00:00 | 2023-06-30 00:00:00
Proj | 2023-07-01 00:00:00 | 2023-07-31 00:00:00
Proj | 2023-08-01 00:00:00 | 2023-08-31 00:00:00
Proj | 2023-09-01 00:00:00 | 2023-09-30 00:00:00
Proj | 2023-10-01 00:00:00 | 2023-10-31 00:00:00
Proj | 2023-11-01 00:00:00 | 2023-11-30 00:00:00
Proj | 2023-12-01 00:00:00 | 2023-12-31 00:00:00
Proj | 2024-01-01 00:00:00 | 2024-01-31 00:00:00
Proj | 2024-02-01 00:00:00 | 2024-02-29 00:00:00
Proj | 2024-03-01 00:00:00 | 2024-03-31 00:00:00
Proj | 2024-04-01 00:00:00 | 2024-04-30 00:00:00
Proj | 2024-05-01 00:00:00 | 2024-05-31 00:00:00
Proj | 2024-06-01 00:00:00 | 2024-06-30 00:00:00
Proj | 2024-07-01 00:00:00 | 2024-07-31 00:00:00
Proj | 2024-08-01 00:00:00 | 2024-08-31 00:00:00
Proj | 2024-09-01 00:00:00 | 2024-09-30 00:00:00
Proj | 2024-10-01 00:00:00 | 2024-10-31 00:00:00
Proj | 2024-11-01 00:00:00 | 2024-11-30 00:00:00
Proj | 2024-12-01 00:00:00 | 2024-12-31 00:00:00
Proj | 2025-01-01 00:00:00 | 2025-01-31 00:00:00
Proj | 2025-02-01 00:00:00 | 2025-02-28 00:00:00
Proj | 2025-03-01 00:00:00 | 2025-03-31 00:00:00
Proj | 2025-04-01 00:00:00 | 2025-04-30 00:00:00
Proj | 2025-05-01 00:00:00 | 2025-05-31 00:00:00
Proj | 2025-06-01 00:00:00 | 2025-06-30 00:00:00
Proj | 2025-07-01 00:00:00 | 2025-07-31 00:00:00
Proj | 2025-08-01 00:00:00 | 2025-08-31 00:00:00
Proj | 2025-09-01 00:00:00 | 2025-09-30 00:00:00
Proj | 2025-10-01 00:00:00 | 2025-10-31 00:00:00
Proj | 2025-11-01 00:00:00 | 2025-11-30 00:00:00
Proj | 2025-12-01 00:00:00 | 2025-12-31 00:00:00
Proj | 2026-01-01 00:00:00 | 2026-01-31 00:00:00
Proj | 2026-02-01 00:00:00 | 2026-02-28 00:00:00
Proj | 2026-03-01 00:00:00 | 2026-03-31 00:00:00
Proj | 2026-04-01 00:00:00 | 2026-04-30 00:00:00
Proj | 2026-05-01 00:00:00 | 2026-05-31 00:00:00
Proj | 2026-06-01 00:00:00 | 2026-06-30 00:00:00
Proj | 2026-07-01 00:00:00 | 2026-07-31 00:00:00
Proj | 2026-08-01 00:00:00 | 2026-08-31 00:00:00
Proj | 2026-09-01 00:00:00 | 2026-09-30 00:00:00
Proj | 2026-10-01 00:00:00 | 2026-10-31 00:00:00
Proj | 2026-11-01 00:00:00 | 2026-11-30 00:00:00
Proj | 2026-12-01 00:00:00 | 2026-12-31 00:00:00
Proj | 2027-01-01 00:00:00 | 2027-01-31 00:00:00
Proj | 2027-02-01 00:00:00 | 2027-02-28 00:00:00
Proj | 2027-03-01 00:00:00 | 2027-03-31 00:00:00
Proj | 2027-04-01 00:00:00 | 2027-04-30 00:00:00
Proj | 2027-05-01 00:00:00 | 2027-05-31 00:00:00
Proj | 2027-06-01 00:00:00 | 2027-06-30 00:00:00
Proj | 2027-07-01 00:00:00 | 2027-07-31 00:00:00
Proj | 2027-08-01 00:00:00 | 2027-08-31 00:00:00
Proj | 2027-09-01 00:00:00 | 2027-09-30 00:00:00
Proj | 2027-10-01 00:00:00 | 2027-10-31 00:00:00
Proj | 2027-11-01 00:00:00 | 2027-11-30 00:00:00
Proj | 2027-12-01 00:00:00 | 2027-12-31 00:00:00
Proj | 2028-01-01 00:00:00 | 2028-01-31 00:00:00
Proj | 2028-02-01 00:00:00 | 2028-02-29 00:00:00
Proj | 2028-03-01 00:00:00 | 2028-03-31 00:00:00
Proj | 2028-04-01 00:00:00 | 2028-04-30 00:00:00
Proj | 2028-05-01 00:00:00 | 2028-05-31 00:00:00
Proj | 2028-06-01 00:00:00 | 2028-06-30 00:00:00
Proj | 2028-07-01 00:00:00 | 2028-07-31 00:00:00
Proj | 2028-08-01 00:00:00 | 2028-08-31 00:00:00
Proj | 2028-09-01 00:00:00 | 2028-09-30 00:00:00
Proj | 2028-10-01 00:00:00 | 2028-10-31 00:00:00
Proj | 2028-11-01 00:00:00 | 2028-11-30 00:00:00
Proj | 2028-12-01 00:00:00 | 2028-12-31 00:00:00
Proj | 2029-01-01 00:00:00 | 2029-01-31 00:00:00
Proj | 2029-02-01 00:00:00 | 2029-02-28 00:00:00
Proj | 2029-03-01 00:00:00 | 2029-03-31 00:00:00
Proj | 2029-04-01 00:00:00 | 2029-04-30 00:00:00
Proj | 2029-05-01 00:00:00 | 2029-05-31 00:00:00
Proj | 2029-06-01 00:00:00 | 2029-06-30 00:00:00
Proj | 2029-07-01 00:00:00 | 2029-07-31 00:00:00
Proj | 2029-08-01 00:00:00 | 2029-08-31 00:00:00
Proj | 2029-09-01 00:00:00 | 2029-09-30 00:00:00
Proj | 2029-10-01 00:00:00 | 2029-10-31 00:00:00
Proj | 2029-11-01 00:00:00 | 2029-11-30 00:00:00
Proj | 2029-12-01 00:00:00 | 2029-12-31 00:00:00
Proj | 2030-01-01 00:00:00 | 2030-01-31 00:00:00
Proj | 2030-02-01 00:00:00 | 2030-02-28 00:00:00
Proj | 2030-03-01 00:00:00 | 2030-03-31 00:00:00
Proj | 2030-04-01 00:00:00 | 2030-04-30 00:00:00
Proj | 2030-05-01 00:00:00 | 2030-05-31 00:00:00
Proj | 2030-06-01 00:00:00 | 2030-06-30 00:00:00
Proj | 2030-07-01 00:00:00 | 2030-07-31 00:00:00
Proj | 2030-08-01 00:00:00 | 2030-08-31 00:00:00
Proj | 2030-09-01 00:00:00 | 2030-09-30 00:00:00
Proj | 2030-10-01 00:00:00 | 2030-10-31 00:00:00
Proj | 2030-11-01 00:00:00 | 2030-11-30 00:00:00
Proj | 2030-12-01 00:00:00 | 2030-12-31 00:00:00
Proj | 2031-01-01 00:00:00 | 2031-01-31 00:00:00
Proj | 2031-02-01 00:00:00 | 2031-02-28 00:00:00
Proj | 2031-03-01 00:00:00 | 2031-03-31 00:00:00
Proj | 2031-04-01 00:00:00 | 2031-04-30 00:00:00
Proj | 2031-05-01 00:00:00 | 2031-05-31 00:00:00
Proj | 2031-06-01 00:00:00 | 2031-06-30 00:00:00
Proj | 2031-07-01 00:00:00 | 2031-07-31 00:00:00
Proj | 2031-08-01 00:00:00 | 2031-08-31 00:00:00
Proj | 2031-09-01 00:00:00 | 2031-09-30 00:00:00
Proj | 2031-10-01 00:00:00 | 2031-10-31 00:00:00
Proj | 2031-11-01 00:00:00 | 2031-11-30 00:00:00
Proj | 2031-12-01 00:00:00 | 2031-12-31 00:00:00
Proj | 2032-01-01 00:00:00 | 2032-01-31 00:00:00
Proj | 2032-02-01 00:00:00 | 2032-02-29 00:00:00
Proj | 2032-03-01 00:00:00 | 2032-03-31 00:00:00
Proj | 2032-04-01 00:00:00 | 2032-04-30 00:00:00
Proj | 2032-05-01 00:00:00 | 2032-05-31 00:00:00
Proj | 2032-06-01 00:00:00 | 2032-06-30 00:00:00
Proj | 2032-07-01 00:00:00 | 2032-07-31 00:00:00