Spreadsheet: 734974d1622628402-rental-projection-for-a-list-of-shops-rental-sheet-question
Sheet: Rent Roll B2

Rent Roll (Draft)
 |  | 餐飲 | [NAME] | 教育培訓 | 娛樂 | 服務 |  | 超市/便利店 | 百貨
 |  |  |  |  |  |  |  |  |  |  |  | 租金 - 毋須手动更新 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
[NAME] |  |  |  |  |  |  |  |  |  | Rent Free |  | Year 2021 |  |  |  |  |  |  |  |  |  |  |  | Year 2022 |  |  |  |  |  |  |  |  |  |  |  | Year 2023 |  |  |  |  |  |  |  |  |  |  |  |  | Year 2021 |  |  |  |  |  |  |  |  |  |  |  | Year 2022 |  |  |  |  |  |  |  |  |  |  |  | Year 2023
Floor | Shop no | Tenant | Trade | Area | Commecement | End | Assumptions | Rental | psm | Start | End | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | 2021-06-01 00:00:00 | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 2021-09-01 00:00:00 | 2021-10-01 00:00:00 | 2021-11-01 00:00:00 | 2021-12-01 00:00:00 | 2022-01-01 00:00:00 | 2022-02-01 00:00:00 | 2022-03-01 00:00:00 | 2022-04-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00 | 2022-07-01 00:00:00 | 2022-08-01 00:00:00 | 2022-09-01 00:00:00 | 2022-10-01 00:00:00 | 2022-11-01 00:00:00 | 2022-12-01 00:00:00 | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 | 2023-03-01 00:00:00 | 2023-04-01 00:00:00 | 2023-05-01 00:00:00 | 2023-06-01 00:00:00 | 2023-07-01 00:00:00 | 2023-08-01 00:00:00 | 2023-09-01 00:00:00 | 2023-10-01 00:00:00 | 2023-11-01 00:00:00 | 2023-12-01 00:00:00 |  | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | 2021-06-01 00:00:00 | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 2021-09-01 00:00:00 | 2021-10-01 00:00:00 | 2021-11-01 00:00:00 | 2021-12-01 00:00:00 | 2022-01-01 00:00:00 | 2022-02-01 00:00:00 | 2022-03-01 00:00:00 | 2022-04-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00 | 2022-07-01 00:00:00 | 2022-08-01 00:00:00 | 2022-09-01 00:00:00 | 2022-10-01 00:00:00 | 2022-11-01 00:00:00 | 2022-12-01 00:00:00 | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 | 2023-03-01 00:00:00 | 2023-04-01 00:00:00 | 2023-05-01 00:00:00 | 2023-06-01 00:00:00 | 2023-07-01 00:00:00 | 2023-08-01 00:00:00 | 2023-09-01 00:00:00 | 2023-10-01 00:00:00 | 2023-11-01 00:00:00 | 2023-12-01 00:00:00
B2 | 1 | EF |  | 1216 | 2020-12-16 00:00:00 | 2021-12-15 00:00:00 | Cont | 275193
 |  |  |  | 1216 | 2021-12-16 00:00:00 | 2022-12-15 00:00:00 | Renew_A | 289561
B2 | 2 | ABC |  | 450 | 2018-07-31 00:00:00 | 2019-07-30 00:00:00 | Cont | 148500 |  | 2018-07-31 00:00:00 | 2018-09-28 00:00:00
 |  |  |  | 450 | 2019-07-31 00:00:00 | 2020-04-24 00:00:00 | Cont | 155925
 |  |  |  | 450 | 2020-04-25 00:00:00 | 2020-07-30 00:00:00 | Cont | 93555
 |  |  |  | 450 | 2020-07-31 00:00:00 | 2021-07-30 00:00:00 | Renew_B | 98233
B2 | 3 | HOT |  | 226 | 2020-12-07 00:00:00 | 2021-06-06 00:00:00 | New Let_C | 0
B2 | 04b/05a | Salon |  | 118 | 2020-12-20 00:00:00 | 2022-12-19 00:00:00 | Cont | 82600 |  | 2020-12-20 00:00:00 | 2021-02-07 00:00:00
B2 |  |  |  | 118 | 2022-12-20 00:00:00 | 2024-12-19 00:00:00 | Cont | 85078
B2 |  |  |  | 118 | 2024-12-20 00:00:00 | 2025-12-19 00:00:00 | Renew_A | 87630
B2 | 6 | [NAME] |  | 406 | 2016-11-24 00:00:00 | 2017-11-23 00:00:00 | Cont | 107387
B2 |  |  |  | 406 | 2017-11-24 00:00:00 | 2018-11-23 00:00:00 | Cont | 110609
B2 |  |  |  | 406 | 2018-11-24 00:00:00 | 2019-11-23 00:00:00 | Cont | 113927
B2 |  |  |  | 406 | 2019-11-24 00:00:00 | 2020-11-23 00:00:00 | Cont | 119623
B2 |  |  |  | 406 | 2020-11-24 00:00:00 | 2021-11-23 00:00:00 | Renew_A | 125604
B2 | 8 | KK |  | 230 | 2018-08-20 00:00:00 | 2019-08-19 00:00:00 | Cont | 80500 |  | 2018-08-20 00:00:00 | 2018-10-18 00:00:00
B2 |  |  |  | 230 | 2019-08-20 00:00:00 | 2020-08-19 00:00:00 | Cont | 84525
B2 |  |  |  | 230 | 2020-08-20 00:00:00 | 2021-08-19 00:00:00 | Renew_B | 88751
B2 | 09a | COCO |  | 22.5 | 2019-04-15 00:00:00 | 2020-04-14 00:00:00 | Cont | 40275
B2 |  |  |  | 22.5 | 2020-04-15 00:00:00 | 2021-04-14 00:00:00 | Cont | 42692
B2 |  |  |  | 22.5 | 2021-04-15 00:00:00 | 2022-04-14 00:00:00 | Renew_C | 45254
B2 | 09b | [NAME] |  | 25 | 2020-10-15 00:00:00 | 2021-10-14 00:00:00 | New Let_A | 33752
 |  | Total Lettable area of B2
Vacant assumptions
Renewal assumptions |  |  |  |  |  |  |  |  |  |  | Unit Rate
 |  |  |  |  |  |  |  |  |  |  | Occupancy