Spreadsheet: 864141d1711447701-calculate-the-monthly-rent-income-test
Sheet: Amortization

REVENUE RECCOGNISION - MONTHLY
Contract Number |  | CON 0001 | CON 0002 | CON 0003 | CON 0004 | CON 0005 | CON 0006 | CON 0007 | CON 0008 | CON 0009 | CON 0010 | CON 0011 | CON 0012 | CON 0013 | CON 0014 | CON 0015 | CON 0016 | CON 0017 | CON 0018 | CON 0019 | CON 0020 | CON 0021 | CON 0022 | CON 0023 | CON 0024 | TOTAL
CONTRACT START |  | 2019-11-01 00:00:00 | 2019-11-20 00:00:00 | 2019-10-01 00:00:00 | 2019-12-01 00:00:00 | 2019-12-01 00:00:00 | 2019-08-18 00:00:00 | 2019-07-03 00:00:00 | 2019-07-01 00:00:00 | 2019-11-01 00:00:00 | 2019-07-03 00:00:00 | 2019-09-16 00:00:00 | 2019-09-01 00:00:00 | 2019-10-27 00:00:00 | 2019-08-20 00:00:00 | 2019-09-14 00:00:00 | 2019-12-01 00:00:00 | 2019-10-25 00:00:00 | 2019-07-01 00:00:00 | 2019-04-01 00:00:00 | 2019-04-01 00:00:00 | 2019-07-28 00:00:00 | 2019-08-17 00:00:00 | 2019-09-07 00:00:00 | 2019-11-20 00:00:00
CONTRACT END |  | 2020-10-31 00:00:00 | 2020-11-19 00:00:00 | 2020-03-31 00:00:00 | 2020-12-31 00:00:00 | 2020-03-31 00:00:00 | 2020-12-31 00:00:00 | 2020-12-31 00:00:00 | 2020-12-31 00:00:00 | 2020-12-31 00:00:00 | 2020-12-31 00:00:00 | 2020-03-15 00:00:00 | 2020-04-30 00:00:00 | 2020-10-26 00:00:00 | 2020-08-19 00:00:00 | 2020-03-13 00:00:00 | 2020-11-30 00:00:00 | 2020-10-24 00:00:00 | 2020-12-31 00:00:00 | 2020-03-31 00:00:00 | 2020-03-31 00:00:00 | 2020-12-31 00:00:00 | 2020-12-31 00:00:00 | 2020-12-31 00:00:00 | 2020-12-31 00:00:00
NO OF DAYS IN CONTRACT
CONTRACT VALUE |  | 528000 | 144000 | 96000 | 457600 | 96000 | 72388 | 118374 | 259200 | 123200 | 1183742 | 48000 | 64000 | 96000 | 48000 | 4368000 | 2332775 | 48126 | 115200 | 87450 | 274428 | 82232 | 26390 | 69957.48 | 176374
RENT PER DAY
NO. OF DAYS AMORTIZED FIRST MONTH
NO. OF DAYS AMORTIZED LAST MONTH
Difference
Total | NO OF DAYS IN THE MONTHS
2019-01-01 00:00:00 | 31
2019-02-01 00:00:00 | 28
2019-03-01 00:00:00 | 31
2019-04-01 00:00:00 | 30
2019-05-01 00:00:00 | 31
2019-06-01 00:00:00 | 30
2019-07-01 00:00:00 | 31
2019-08-01 00:00:00 | 31
2019-09-01 00:00:00 | 30
2019-10-01 00:00:00 | 31
2019-11-01 00:00:00 | 30
2019-12-01 00:00:00 | 31
2020-01-01 00:00:00 | 31
2020-02-01 00:00:00 | 29
2020-03-01 00:00:00 | 31
2020-04-01 00:00:00 | 30
2020-05-01 00:00:00 | 31
2020-06-01 00:00:00 | 30
2020-07-01 00:00:00 | 31
2020-08-01 00:00:00 | 31
2020-09-01 00:00:00 | 30
2020-10-01 00:00:00 | 31
2020-11-01 00:00:00 | 30
2020-12-01 00:00:00 | 31
2021-01-01 00:00:00 | 31
2021-02-01 00:00:00 | 28
2021-03-01 00:00:00 | 31
2021-04-01 00:00:00 | 30
2021-05-01 00:00:00 | 31
2021-06-01 00:00:00 | 30
2021-07-01 00:00:00 | 31
2021-08-01 00:00:00 | 31
2021-09-01 00:00:00 | 30
2021-10-01 00:00:00 | 31
2021-11-01 00:00:00 | 30
2021-12-01 00:00:00 | 31
2022-01-01 00:00:00 | 31
2022-02-01 00:00:00 | 28
2022-03-01 00:00:00 | 31
2022-04-01 00:00:00 | 30
2022-05-01 00:00:00 | 31
2022-06-01 00:00:00 | 30
2022-07-01 00:00:00 | 31
2022-08-01 00:00:00 | 31
2022-09-01 00:00:00 | 30
2022-10-01 00:00:00 | 31
2022-11-01 00:00:00 | 30
2022-12-01 00:00:00 | 31
2023-01-01 00:00:00 | 31
2023-02-01 00:00:00 | 28
2023-03-01 00:00:00 | 31
2023-04-01 00:00:00 | 30
2023-05-01 00:00:00 | 31
2023-06-01 00:00:00 | 30
2023-07-01 00:00:00 | 31
2023-08-01 00:00:00 | 31
2023-09-01 00:00:00 | 30
2023-10-01 00:00:00 | 31
2023-11-01 00:00:00 | 30
2023-12-01 00:00:00 | 31
2024-01-01 00:00:00 | 31
2024-02-01 00:00:00 | 29