Spreadsheet: 747587d1631605379-monthly-rental-revenue-calculation-with-rcd-and-red-date-and-different-escalation-rates-excel-formula-rent-calculation
Sheet: IF Formula

 |  |  |  |  |  |  |  |  |  |  | 2019-01-01 00:00:00
 | REVENUE WORKING
 |  |  |  |  | No of Units |  |  |  |  |  |  | Year 1 FOC and Year 2 TOR |  |  |  |  |  |  |  |  | No of Units
 |  |  |  |  | Area |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Area
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Occupancy
 |  |  |  |  | Rate |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rate
 |  |  | TOTAL |  | Amount |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Amount
 |  |  | SUBTOTAL
 |  |  |  |  |  |  |  |  |  |  |  | 2019 | 2020 | 2021 | 2022 | 2023 | 2024 | 2025 | 2026 | 2027 |  | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2022 | 2022 | 2022 | 2022 | 2022 | 2022 | 2022 | 2022 | 2022 | 2022 | 2022 | 2022 | 2023 | 2023 | 2023 | 2023 | 2023 | 2023 | 2023 | 2023 | 2023 | 2023 | 2023 | 2023 | 2024 | 2024 | 2024 | 2024 | 2024 | 2024 | 2024 | 2024 | 2024 | 2024 | 2024 | 2024 | 2025 | 2025 | 2025 | 2025 | 2025 | 2025 | 2025 | 2025 | 2025 | 2025 | 2025 | 2025 | 2026 | 2026 | 2026 | 2026 | 2026 | 2026 | 2026 | 2026 | 2026 | 2026 | 2026 | 2026
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
 |  |  |  |  |  |  |  |  |  |  |  | BR | BR | BR | BR | BR | BR | BR | BR | BR |  | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR | BR
 | S NO. | UNIT NO | T-CODE | REGISTERED NAME | BRAND NAME | LEASING STATUS | REVENUE CATEGORY | SUB CATEGORY | Area | RCD | RED | 2019-20 | 2020-21 | 2021-22 | 2022-23 | 2023-24 | 2024-25 | 2025-26 | 2026-27 | 2027-28 |  | 2021-01-31 00:00:00 | 2021-02-28 00:00:00 | 2021-03-31 00:00:00 | 2021-04-30 00:00:00 | 2021-05-31 00:00:00 | 2021-06-30 00:00:00 | 2021-07-31 00:00:00 | 2021-08-31 00:00:00 | 2021-09-30 00:00:00 | 2021-10-31 00:00:00 | 2021-11-30 00:00:00 | 2021-12-31 00:00:00 | 2022-01-31 00:00:00 | 2022-02-28 00:00:00 | 2022-03-31 00:00:00 | 2022-04-30 00:00:00 | 2022-05-31 00:00:00 | 2022-06-30 00:00:00 | 2022-07-31 00:00:00 | 2022-08-31 00:00:00 | 2022-09-30 00:00:00 | 2022-10-31 00:00:00 | 2022-11-30 00:00:00 | 2022-12-31 00:00:00 | 2023-01-31 00:00:00 | 2023-02-28 00:00:00 | 2023-03-31 00:00:00 | 2023-04-30 00:00:00 | 2023-05-31 00:00:00 | 2023-06-30 00:00:00 | 2023-07-31 00:00:00 | 2023-08-31 00:00:00 | 2023-09-30 00:00:00 | 2023-10-31 00:00:00 | 2023-11-30 00:00:00 | 2023-12-31 00:00:00 | 2024-01-31 00:00:00 | 2024-02-29 00:00:00 | 2024-03-31 00:00:00 | 2024-04-30 00:00:00 | 2024-05-31 00:00:00 | 2024-06-30 00:00:00 | 2024-07-31 00:00:00 | 2024-08-31 00:00:00 | 2024-09-30 00:00:00 | 2024-10-31 00:00:00 | 2024-11-30 00:00:00 | 2024-12-31 00:00:00 | 2025-01-31 00:00:00 | 2025-02-28 00:00:00 | 2023-03-31 00:00:00 | 2025-04-30 00:00:00 | 2025-05-31 00:00:00 | 2025-06-30 00:00:00 | 2025-07-31 00:00:00 | 2025-08-31 00:00:00 | 2025-09-30 00:00:00 | 2025-10-31 00:00:00 | 2025-11-30 00:00:00 | 2025-12-31 00:00:00 | 2026-01-31 00:00:00 | 2026-02-28 00:00:00 | 2026-03-31 00:00:00 | 2026-04-30 00:00:00 | 2026-05-31 00:00:00 | 2026-06-30 00:00:00 | 2026-07-31 00:00:00 | 2026-08-31 00:00:00 | 2026-09-30 00:00:00 | 2026-10-31 00:00:00 | 2026-11-30 00:00:00 | 2026-12-31 00:00:00
 | 1 | 1 |  |  |  | Vacant |  |  | 2241 | 2021-03-11 00:00:00 | 2027-03-10 00:00:00 |  |  |  | 100 | 110
 | 2 | 1 |  |  |  | Vacant |  |  | 3103 | 2022-05-01 00:00:00 | 2027-04-30 00:00:00 |  |  |  | 50