Spreadsheet: 851068d1701327949-number-of-calendar-months-date-test
Sheet: Sheet1

 |  |  |  |  |  |  |  | Date | 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 | 2024-01-01 00:00:00 | 2024-02-01 00:00:00 | 2024-03-01 00:00:00 | 2024-04-01 00:00:00 | 2024-05-01 00:00:00 | 2024-06-01 00:00:00 | 2024-07-01 00:00:00 | 2024-08-01 00:00:00 | 2024-09-01 00:00:00 | 2024-10-01 00:00:00 | 2024-11-01 00:00:00 | 2024-12-01 00:00:00 | 2025-01-01 00:00:00 | 2025-02-01 00:00:00 | 2025-03-01 00:00:00 | 2025-04-01 00:00:00 | 2025-05-01 00:00:00 | 2025-06-01 00:00:00 | 2025-07-01 00:00:00 | 2025-08-01 00:00:00 | 2025-09-01 00:00:00 | 2025-10-01 00:00:00 | 2025-11-01 00:00:00 | 2025-12-01 00:00:00 | 2026-01-01 00:00:00 | 2026-02-01 00:00:00 | 2026-03-01 00:00:00 | 2026-04-01 00:00:00 | 2026-05-01 00:00:00 | 2026-06-01 00:00:00 | 2026-07-01 00:00:00 | 2026-08-01 00:00:00 | 2026-09-01 00:00:00 | 2026-10-01 00:00:00 | 2026-11-01 00:00:00 | 2026-12-01 00:00:00 | 2027-01-01 00:00:00 | 2027-02-01 00:00:00 | 2027-03-01 00:00:00 | 2027-04-01 00:00:00 | 2027-05-01 00:00:00 | 2027-06-01 00:00:00 | 2027-07-01 00:00:00 | 2027-08-01 00:00:00 | 2027-09-01 00:00:00 | 2027-10-01 00:00:00 | 2027-11-01 00:00:00 | 2027-12-01 00:00:00 | 2028-01-01 00:00:00 | 2028-02-01 00:00:00 | 2028-03-01 00:00:00 | 2028-04-01 00:00:00 | 2028-05-01 00:00:00 | 2028-06-01 00:00:00 | 2028-07-01 00:00:00 | 2028-08-01 00:00:00 | 2028-09-01 00:00:00 | 2028-10-01 00:00:00 | 2028-11-01 00:00:00 | 2028-12-01 00:00:00 | 2029-01-01 00:00:00 | 2029-02-01 00:00:00 | 2029-03-01 00:00:00 | 2029-04-01 00:00:00 | 2029-05-01 00:00:00 | 2029-06-01 00:00:00 | 2029-07-01 00:00:00 | 2029-08-01 00:00:00 | 2029-09-01 00:00:00 | 2029-10-01 00:00:00 | 2029-11-01 00:00:00 | 2029-12-01 00:00:00 | 2030-01-01 00:00:00 | 2030-02-01 00:00:00 | 2030-03-01 00:00:00 | 2030-04-01 00:00:00 | 2030-05-01 00:00:00 | 2030-06-01 00:00:00
 |  |  |  |  |  |  |  | EOM | 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 | 2025-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 | 2027-01-31 00:00:00 | 2027-02-28 00:00:00 | 2027-03-31 00:00:00 | 2027-04-30 00:00:00 | 2027-05-31 00:00:00 | 2027-06-30 00:00:00 | 2027-07-31 00:00:00 | 2027-08-31 00:00:00 | 2027-09-30 00:00:00 | 2027-10-31 00:00:00 | 2027-11-30 00:00:00 | 2027-12-31 00:00:00 | 2028-01-31 00:00:00 | 2028-02-29 00:00:00 | 2028-03-31 00:00:00 | 2028-04-30 00:00:00 | 2028-05-31 00:00:00 | 2028-06-30 00:00:00 | 2028-07-31 00:00:00 | 2028-08-31 00:00:00 | 2028-09-30 00:00:00 | 2028-10-31 00:00:00 | 2028-11-30 00:00:00 | 2028-12-31 00:00:00 | 2029-01-31 00:00:00 | 2029-02-28 00:00:00 | 2029-03-31 00:00:00 | 2029-04-30 00:00:00 | 2029-05-31 00:00:00 | 2029-06-30 00:00:00 | 2029-07-31 00:00:00 | 2029-08-31 00:00:00 | 2029-09-30 00:00:00 | 2029-10-31 00:00:00 | 2029-11-30 00:00:00 | 2029-12-31 00:00:00 | 2030-01-31 00:00:00 | 2030-02-28 00:00:00 | 2030-03-31 00:00:00 | 2030-04-30 00:00:00 | 2030-05-31 00:00:00 | 2030-06-30 00:00:00
 |  |  |  |  |  |  |  | Rate
 |  |  |  |  |  |  | One off Fee | 0.03
 |  |  |  |  |  |  | Sale Price |  | 3300000 |  | 3600000 |  | 3450000
 |  |  |  |  |  |  | Scenario |  | 1 |  | 2 |  | 3
 | Project Length
 | Start | Complete | Days | Months | count months |  | Project Management Fees
 | 2023-10-16 00:00:00 | 2025-07-07 00:00:00 |  |  |  | 1 | Package 1
 | 2024-01-01 00:00:00 | 2025-09-22 00:00:00 |  |  |  | 2 | Package 2
 | 2024-07-15 00:00:00 | 2026-04-06 00:00:00 |  |  |  | 3 | Package 3
 | 2024-12-23 00:00:00 | 2026-09-14 00:00:00 |  |  |  | 1 | Package 4
 | 2025-04-09 00:00:00 | 2026-12-30 00:00:00 |  |  |  | 2 | Package 5
 | 2025-08-13 00:00:00 | 2027-05-05 00:00:00 |  |  |  | 3 | Package 6
 | 2026-02-19 00:00:00 | 2027-11-11 00:00:00 |  |  |  | 1 | Package 7
 | 2026-03-12 00:00:00 | 2027-12-02 00:00:00 |  |  |  | 2 | Package 8
 | 2026-05-28 00:00:00 | 2028-02-17 00:00:00 |  |  |  | 3 | Package 9
 | 2027-09-03 00:00:00 | 2029-05-25 00:00:00 |  |  |  | 1 | Package 10
 |  |  |  |  |  |  | Project Management Fees
 |  |  |  |  |  |  | Package 1
 |  |  |  |  |  |  | Package 2
 |  |  |  |  |  |  | Package 3
 |  |  |  |  |  |  | Package 4
 |  |  |  |  |  |  | Package 5
 |  |  |  |  |  |  | Package 6
 |  |  |  |  |  |  | Package 7
 |  |  |  |  |  |  | Package 8
 |  |  |  |  |  |  | Package 9
 |  |  |  |  |  |  | Package 10