Spreadsheet: 716656d1612302212-check-if-any-of-the-cell-values-returns-false-in-a-sheet-book2
Sheet: Expenditure P90_P50 (FED)

 |  |  |  |  |  |  |  |  |  |  |  |  |  | % |  | Location
 |  |  |  |  |  |  |  |  |  |  |  |  | Property Escalation Rate |  | Per Half Year | Urban
 |  |  |  |  |  | Manually input first month; months must correspond to table below - e.g. Dec/Mar/Jun/Sep for quarterly
 | Expenditure Profile Base Amount: |  |  |  |  | 2020-12-01 00:00:00
 |  |  |  |  | Current 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
 |  |  | 2016-06-27 00:00:00 | 2017-02-02 00:00:00
 |  |  | 2016-07-04 00:00:00 | 2021-03-26 00:00:00
 |  |  | 2020-11-27 00:00:00 | 2022-10-31 00:00:00
 | Investigation, Detail Design & Documentation
 | Property Acquisitions
 | Project Management
 |  |  | 2022-06-10 00:00:00 | 2023-10-17 00:00:00 | 0
 |  |  | 2023-10-17 00:00:00 | 2024-07-01 00:00:00 | 0
 | Total estimate Base Amount
 | Cash flow Base (Current $):
 |  |  |  |  |  | 2019/20 |  | 2020/21 |  | 2021/22 |  | 2022/23 |  | 2023/24 |  | 2024/25
 | Expenditure Profile P90:
 |  |  |  |  | Current 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
 |  |  |  | 2021-07-26 00:00:00
 |  |  | 2020-11-27 00:00:00 | 2023-01-29 00:00:00
 | Investigation, Detail Design & Documentation
 | Property Acquisitions
 | Project Management
 |  |  |  | 2024-03-21 00:00:00 | 0
 |  |  | 2024-03-21 00:00:00 | 2025-01-19 00:00:00 | 0
 | Total estimate P90
 | Total cost distribution
 | Adjustment factor excluding property: |  |  |  | 1
 | Total cost distribution excluding property
 | Adjustment factor for property: |  |  |  | 1
 | Property cost distribution
 | Cash flow P90: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Outturn cost
 |  |  |  |  |  | 2019/20 |  | 2020/21 |  | 2021/22 |  | 2022/23 |  | 2023/24 |  | 2024/25 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Escalation amount
 | 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
 |  |  |  |  |  |  |  |  |  | Property escalation |  |  | Distribution |  | Working Days
 |  |  |  | Month | Per Month | Quarter | Per Quarter | Half Year | Per Half Year | Location | PER ANNUM |  | Monthly | Per Month | 20
 |  |  |  | 2018-10-01 00:00:00 |  | 2018-12-01 00:00:00 |  | 2018-12-01 00:00:00 |  | Urban | 0.08 |  | Quarterly | Per Quarter
 |  |  |  | 2018-11-01 00:00:00 |  | 2019-03-01 00:00:00 |  | 2019-06-01 00:00:00 |  | Rural | 0.05 |  | Half Yearly | Per Half Year
 |  |  |  | 2018-12-01 00:00:00 |  | 2019-06-01 00:00:00 |  | 2019-12-01 00:00:00 |  |  |  |  | Yearly | Per Year
 |  |  |  | 2019-01-01 00:00:00 |  | 2019-09-01 00:00:00 |  | 2020-06-01 00:00:00
 |  |  |  | 2019-02-01 00:00:00 |  | 2019-12-01 00:00:00 |  | 2020-12-01 00:00:00
 |  |  |  | 2019-03-01 00:00:00 |  | 2020-03-01 00:00:00 |  | 2021-06-01 00:00:00
 | Annual Escalation Rate (excluding Property) | IF FEDERALLY FUNDED |  | 2019-04-01 00:00:00 |  | 2020-06-01 00:00:00 |  | 2021-12-01 00:00:00
 | Year | Year | Per Year | 2019-05-01 00:00:00 |  | 2020-09-01 00:00:00 |  | 2022-06-01 00:00:00
 | 16/17 | 2017-06-01 00:00:00 | -0.0033 | 2019-06-01 00:00:00 |  | 2020-12-01 00:00:00 |  | 2022-12-01 00:00:00
 | 17/18 | 2018-06-01 00:00:00 | 0.0058 | 2019-07-01 00:00:00 |  | 2021-03-01 00:00:00 |  | 2023-06-01 00:00:00
 | 18/19 | 2019-06-01 00:00:00 | 0.0306 | 2019-08-01 00:00:00 |  | 2021-06-01 00:00:00 |  | 2023-12-01 00:00:00
 | 19/20 | 2020-06-01 00:00:00 | 0.047 | 2019-09-01 00:00:00 |  | 2021-09-01 00:00:00 |  | 2024-06-01 00:00:00
 | 20/21 | 2021-06-01 00:00:00 | 0.0157 | 2019-10-01 00:00:00 |  | 2021-12-01 00:00:00 |  | 2024-12-01 00:00:00
 | 21/22 | 2022-06-01 00:00:00 | 0.0038 | 2019-11-01 00:00:00 |  | 2022-03-01 00:00:00 |  | 2025-06-01 00:00:00
 | 22/23 | 2023-06-01 00:00:00 | 0.0221 | 2019-12-01 00:00:00 |  | 2022-06-01 00:00:00 |  | 2025-12-01 00:00:00
 | 23/24 | 2024-06-01 00:00:00 | 0.0295 | 2020-01-01 00:00:00 |  | 2022-09-01 00:00:00 |  | 2026-06-01 00:00:00
 | 24/25 | 2025-06-01 00:00:00 | 0.0283 | 2020-02-01 00:00:00 |  | 2022-12-01 00:00:00 |  | 2026-12-01 00:00:00
 | 25/26 | 2026-06-01 00:00:00 | 0.0273 | 2020-03-01 00:00:00 |  | 2023-03-01 00:00:00 |  | 2027-06-01 00:00:00
 |  |  |  | 2020-04-01 00:00:00 |  | 2023-06-01 00:00:00 |  | 2027-12-01 00:00:00
 |  |  |  | 2020-05-01 00:00:00 |  | 2023-09-01 00:00:00 |  | 2028-06-01 00:00:00
 |  |  |  | 2020-06-01 00:00:00 |  | 2023-12-01 00:00:00
 |  |  |  | 2020-07-01 00:00:00 |  | 2024-03-01 00:00:00
 |  |  |  | 2020-08-01 00:00:00 |  | 2024-06-01 00:00:00
 |  |  |  | 2020-09-01 00:00:00 |  | 2024-09-01 00:00:00
 |  |  |  | 2020-10-01 00:00:00 |  | 2024-12-01 00:00:00
 |  |  |  | 2020-11-01 00:00:00 |  | 2025-03-01 00:00:00
 |  |  |  | 2020-12-01 00:00:00 |  | 2025-06-01 00:00:00
 |  |  |  | 2021-01-01 00:00:00 |  | 2025-09-01 00:00:00
 |  |  |  | 2021-02-01 00:00:00 |  | 2025-12-01 00:00:00
 |  |  |  | 2021-03-01 00:00:00 |  | 2026-03-01 00:00:00
 |  |  |  | 2021-04-01 00:00:00 |  | 2026-06-01 00:00:00
 |  |  |  | 2021-05-01 00:00:00 |  | 2026-09-01 00:00:00
 |  |  |  | 2021-06-01 00:00:00 |  | 2026-12-01 00:00:00
 |  |  |  | 2021-07-01 00:00:00 |  | 2027-03-01 00:00:00
 |  |  |  | 2021-08-01 00:00:00 |  | 2027-06-01 00:00:00
 |  |  |  | 2021-09-01 00:00:00 |  | 2027-09-01 00:00:00
 |  |  |  | 2021-10-01 00:00:00 |  | 2027-12-01 00:00:00
 |  |  |  | 2021-11-01 00:00:00 |  | 2028-03-01 00:00:00
 |  |  |  | 2021-12-01 00:00:00 |  | 2028-06-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
 |  |  |  | 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