Spreadsheet: 745851d1630322457-get-the-escalation-amount-for-different-escalation-rates-book3
Sheet: Expenditure P90_P50

 |  |  |  |  |  |  |  |  |  |  | 0.04 |  |  |  | Property Escalation Rate
 |  |  |  |  |  | 2021-12-01 00:00:00 | 2022-06-30 00:00:00 | 2022-12-31 00:00:00 | 2023-06-30 00:00:00 | 2023-12-31 00:00:00 | 2024-06-30 00:00:00 | 2024-12-31 00:00:00 | 2025-06-30 00:00:00 | 2025-12-31 00:00:00 | 2026-06-30 00:00:00 | 2026-12-31 00:00:00 | 2027-06-30 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 | Total
 | Item | Total | Start Date | Complete Date | 0 | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11
 | Initiation | 0 | Complete | Complete | 0
 | Strategic Assessment | 1130002 | Complete | Complete | 1130002
 | Concept |  | 2019-09-01 00:00:00 | 2021-10-30 00:00:00
 | Concept Development excl property | 4250756.738887744 |  |  | 1873330 | 2377426.738887744
 | Property Acquisitions concept stage | 87128.56924020726 |  |  | 78546 | 8582.56924020726
 | Delivery Readiness |  | 2021-10-30 00:00:00 | 2024-05-30 00:00:00
 | Delivery readiness cost excl property | 9499649.81868434 |  |  | 0 | 617477.2382144821 | 2184919.458297398 | 2184919.458297398 | 2184919.458297398 | 1709936.967363181 | 617477.2382144821
 | Property Acquisitions delivery readiness stage | 106969193.7400146 |  |  | 0 | 6952997.59310095 | 24602914.56020336 | 24602914.56020336 | 24602914.56020336 | 19254454.87320263 | 6952997.59310095
 | Delivery | 176053649.8575068 | 2024-05-30 00:00:00 | 2026-12-30 00:00:00 | 0 |  |  |  |  |  | 29929120.47577617 | 31689656.97435123 | 33450193.4729263 | 33450193.4729263 | 33450193.4729263 | 14084291.98860055
 | Finalisation |  | 2026-12-30 00:00:00 | 2027-03-01 00:00:00
 | Finalisation excl credited cost | 1583274.969780723 |  |  | 0 |  |  |  |  |  |  |  |  |  |  | 1108292.478846506 | 474982.4909342168
 | Cost Amount Credited to Project ( '-ve value - should schedule end of the project cash-flow) | 0 |  |  | 0
 | Total estimate P50
 | Total cost distribution
 | Adjustment factor excluding property: |  |  |  | 1
 | Total cost distribution excluding property
 | Adjustment factor for property: |  |  |  | 1
 | Cash flow P50:
 |  |  | Rate | 0.035 | 0.04 | 0.045
 |  |  | Escalation | 28892944.32188416 | 33222373.20593596
 | TOTAL OUTTURN P50: |  |  |  |  | [NAME] for calculating escalation rates |  |  |  | Percentage | Example for
 |  |  |  |  |  | Monthly rate = (1 + annual rate)(1/12) – 1 |  |  |  |  | 0.05
 | TOTAL OUTTURN P90: |  |  |  |  | Quarterly rate = (1 + annual rate )(1/4) – 1
 |  |  |  |  |  | Semi-annual rate = (1 + annual rate)(1/2) – 1
 | TfNSW Recommended Escalation rate
 |  |  |  |  |  |  | Property escalation |  |  | Period
 | Escalation rate including Property | 0.035 |  | 0.035 | per annum | Yes | Location | PER ANNUM |  | Month | 12
 |  |  |  |  |  |  | Sydney | 0.05 |  | Quarter | 4
 | Escalation Rate excluding property | 0.03 |  | 0.03 | per annum | No | Regional NSW | 0.02 |  | Half Yearly | 2
 |  |  |  |  |  |  |  |  |  | Year | 1
 | Refer: Road and Rail Construction Cost Escalation Indices - 2018 Update - July 2018/Version 1.3