Spreadsheet: 862490d1710206640-highlight-cells-based-on-the-dates-book1-99-ans2
Sheet: Expenditure P90_P50 (2)

 |  |  |  |  |  |  |  | Period | Per Month
 |  |  |  |  |  | Manually input first month; months must correspond to table below - e.g. Dec/Mar/Jun/Sep for quarterly
 | Expenditure Profile Base Amount: |  |  |  |  | 2022-12-01 00:00:00 | 2023-06-01 00:00:00 | 2023-12-01 00:00:00 | 2024-06-01 00:00:00 | 2024-12-01 00:00:00 | 2025-06-01 00:00:00 | 2025-12-01 00:00:00 | 2026-06-01 00:00:00 | 2026-12-01 00:00:00 | 2027-06-01 00:00:00 | 2027-12-01 00:00:00 | 2028-06-01 00:00:00 | 2028-12-01 00:00:00 | 2029-06-01 00:00:00 | 2029-12-01 00:00:00 | 2030-06-01 00:00:00 | 2030-12-01 00:00:00 | 2031-06-01 00:00:00 | 2031-12-01 00:00:00 | 2032-06-01 00:00:00 | 2032-12-01 00:00:00 | 2033-06-01 00:00:00 | 2033-12-01 00:00:00 | 2034-06-01 00:00:00 | 2034-12-01 00:00:00 | 2035-06-01 00:00:00 | 2035-12-01 00:00:00 | 2036-06-01 00:00:00
 |  |  |  |  | Actual Expenditure | period 0* | period 1* | period 2 | period 3 | period 4 | period 5 | period 6 | period 7 | period 8 | period 9 | period 10 | period 11 | period 12 | period 13 | period 14 | period 15 | period 16 | period 17 | period 18 | period 19 | period 20 | period 21 | period 22 | period 23 | period 24 | period 25 | period 26 | period 27
 | Item | Total | Start Date | Complete Date | 0 | 0
 | Delivery Readiness |  | 2021-12-01 00:00:00 | 2026-03-25 00:00:00
 | Delivery |  | 2024-12-01 00:00:00 | 2025-11-28 00:00:00
 | Finalisation |  |  | 2027-09-16 00:00:00
 | Finalisation excl credited cost
 |  |  |  |  |  |  | formula | =AND($D7<>"",$E7<>"",MEDIAN(EOMONTH(G$4,-6)+1,EOMONTH(G$4,0),$E7)>MEDIAN(EOMONTH(G$4,-6)+1,EOMONTH(G$4,0),$D7))
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Escalation amount
 |  |  |  |  |  | Use if Property %< or =11% |  |  |  |  |  |  |  |  | Property escalation |  |  |  | Distribution
 | TOTAL OUTTURN P50: |  |  |  |  | [NAME] for calculating escalation rates |  |  |  | Percentage | Example for |  |  |  | Location |  | PER ANNUM |  | Monthly | Per Month
 |  |  |  |  |  | Monthly rate = (1 + annual rate)(1/12) – 1 |  |  |  |  | 0.05 |  |  |  | Sydney - Urban |  | 0.05 |  | Quarterly | Per Quarter
 | TOTAL OUTTURN P90: |  |  |  |  | Quarterly rate = (1 + annual rate )(1/4) – 1 |  |  |  |  |  |  |  |  | Regional NSW - Outer Metropolitan |  | 0.06 |  | Half Yearly | Per Half Year
 |  |  |  |  |  | Semi-annual rate = (1 + annual rate)(1/2) – 1 |  |  |  |  |  |  |  |  | Regional NSW - Rural |  | 0.045 |  | Year | Per Year
 |  |  |  |  |  |  | Property escalation |  |  | Period
 | Annual Escalation Rate
 | Year | Year | Per Year* (Refer below guide) |  |  |  | Month | Per Month | Quarter | Per Quarter | Half Year | Per Half Year | Year | Per Year
 | 21/22 | 2022-06-01 00:00:00 |  |  |  |  | 2021-07-01 00:00:00 |  | 2021-09-01 00:00:00 |  | 2021-12-01 00:00:00 |  | 2021-12-01 00:00:00
 | 22/23 | 2023-06-01 00:00:00 |  |  |  |  | 2021-08-01 00:00:00 |  | 2021-12-01 00:00:00 |  | 2022-06-01 00:00:00 |  | 2022-06-01 00:00:00
 | 23/24 | 2024-06-01 00:00:00 |  |  |  |  | 2021-09-01 00:00:00 |  | 2022-03-01 00:00:00 |  | 2022-12-01 00:00:00 |  | 2022-12-01 00:00:00
 | 24/25 | 2025-06-01 00:00:00 |  |  |  |  | 2021-10-01 00:00:00 |  | 2022-06-01 00:00:00 |  | 2023-06-01 00:00:00 |  | 2023-06-01 00:00:00
 | 25/26 | 2026-06-01 00:00:00 |  |  |  |  | 2021-11-01 00:00:00 |  | 2022-09-01 00:00:00 |  | 2023-12-01 00:00:00 |  | 2023-12-01 00:00:00
 | 26/27 | 2027-06-01 00:00:00 |  |  |  |  | 2021-12-01 00:00:00 |  | 2022-12-01 00:00:00 |  | 2024-06-01 00:00:00 |  | 2024-06-01 00:00:00
 | 27/28 | 2028-06-01 00:00:00 |  |  |  |  | 2022-01-01 00:00:00 |  | 2023-03-01 00:00:00 |  | 2024-12-01 00:00:00 |  | 2024-12-01 00:00:00
 | 28/29 | 2029-06-01 00:00:00 |  |  |  |  | 2022-02-01 00:00:00 |  | 2023-06-01 00:00:00 |  | 2025-06-01 00:00:00 |  | 2025-06-01 00:00:00
 | 29/30 | 2030-06-01 00:00:00 |  |  |  |  | 2022-03-01 00:00:00 |  | 2023-09-01 00:00:00 |  | 2025-12-01 00:00:00 |  | 2025-12-01 00:00:00
 | 30/31 | 2031-06-01 00:00:00 |  |  |  |  | 2022-04-01 00:00:00 |  | 2023-12-01 00:00:00 |  | 2026-06-01 00:00:00 |  | 2026-06-01 00:00:00
 | 31/32 | 2032-06-01 00:00:00 |  |  |  |  | 2022-05-01 00:00:00 |  | 2024-03-01 00:00:00 |  | 2026-12-01 00:00:00 |  | 2026-12-01 00:00:00
 | 32/33 | 2033-06-01 00:00:00 |  |  |  |  | 2022-06-01 00:00:00 |  | 2024-06-01 00:00:00 |  | 2027-06-01 00:00:00 |  | 2027-06-01 00:00:00
 |  |  |  |  |  |  | 2022-07-01 00:00:00 |  | 2024-09-01 00:00:00 |  | 2027-12-01 00:00:00 |  | 2027-12-01 00:00:00
 |  |  |  |  |  |  | 2022-08-01 00:00:00 |  | 2024-12-01 00:00:00 |  | 2028-06-01 00:00:00 |  | 2028-06-01 00:00:00
 | * Enter below annual escalation rate for state funding |  |  |  |  |  | 2022-09-01 00:00:00 |  | 2025-03-01 00:00:00 |  | 2028-12-01 00:00:00 |  | 2028-12-01 00:00:00
 |  |  |  |  |  |  | 2022-10-01 00:00:00 |  | 2025-06-01 00:00:00 |  | 2029-06-01 00:00:00 |  | 2029-06-01 00:00:00
 |  | State (Rural) | State (Urban) | State (Rural) | State (Urban) |  | 2022-11-01 00:00:00 |  | 2025-09-01 00:00:00 |  | 2029-12-01 00:00:00 |  | 2029-12-01 00:00:00
 | Year | Excluding property | Excluding property | Including property | Including property |  | 2022-12-01 00:00:00 |  | 2025-12-01 00:00:00 |  | 2030-06-01 00:00:00 |  | 2030-06-01 00:00:00
 | 21/22 | 0.045 | 0.045 | 0.088 | 0.064 |  | 2023-01-01 00:00:00 |  | 2026-03-01 00:00:00 |  | 2030-12-01 00:00:00 |  | 2030-12-01 00:00:00
 | 22/23 | 0.043 | 0.043 | 0.044 | 0.045 |  | 2023-02-01 00:00:00 |  | 2026-06-01 00:00:00 |  | 2031-06-01 00:00:00 |  | 2031-06-01 00:00:00
 | 23/24 | 0.039 | 0.039 | 0.041 | 0.043 |  | 2023-03-01 00:00:00 |  | 2026-09-01 00:00:00 |  | 2031-12-01 00:00:00 |  | 2031-12-01 00:00:00
 | 24/25 | 0.038 | 0.038 | 0.039 | 0.041 |  | 2023-04-01 00:00:00 |  | 2026-12-01 00:00:00 |  | 2032-06-01 00:00:00 |  | 2032-06-01 00:00:00
 | 25/26 | 0.03 | 0.03 | 0.034 | 0.036 |  | 2023-05-01 00:00:00 |  | 2027-03-01 00:00:00 |  | 2032-12-01 00:00:00 |  | 2032-12-01 00:00:00
 | 26/27 | 0.025 | 0.025 | 0.025 | 0.025 |  | 2023-06-01 00:00:00 |  | 2027-06-01 00:00:00 |  | 2033-06-01 00:00:00 |  | 2033-06-01 00:00:00
 | 27/28 | 0.025 | 0.025 | 0.025 | 0.025 |  | 2023-07-01 00:00:00 |  | 2027-09-01 00:00:00
 | 28/29 | 0.025 | 0.025 | 0.025 | 0.025 |  | 2023-08-01 00:00:00 |  | 2027-12-01 00:00:00
 | 29/30 | 0.025 | 0.025 | 0.025 | 0.025 |  | 2023-09-01 00:00:00 |  | 2028-03-01 00:00:00
 | 30/31 | 0.025 | 0.025 | 0.025 | 0.025 |  | 2023-10-01 00:00:00 |  | 2028-06-01 00:00:00
 | 31/32 | 0.025 | 0.025 | 0.025 | 0.025 |  | 2023-11-01 00:00:00 |  | 2028-09-01 00:00:00
 | 32/33 | 0.025 | 0.025 | 0.025 | 0.025 |  | 2023-12-01 00:00:00 |  | 2028-12-01 00:00:00
 |  |  |  |  |  |  | 2024-01-01 00:00:00 |  | 2029-03-01 00:00:00
 |  |  |  |  |  |  | 2024-02-01 00:00:00 |  | 2029-06-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