{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Pricing CoverSheet","TOC","Guidelines","S18.Total revenue requirement","S19 Pricing Asset Revenue","S20.Demand Forecast","S24.Transitional RAB"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":7,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Pricing CoverSheet","index":0,"n_rows":18,"n_cols":3,"rows_kept":18,"cut":false,"hidden":false,"merged":[[13,1,14,1]]}
[]
[]
["Specified Airport Services Information Disclosure Requirements"]
["Information Templates"]
["for"]
["Schedules 18–24"]
[]
[null,"Company Name","Airport Company"]
[]
[null,"Disclosure Date","2017-02-28"]
[]
[null,"Pricing Period Starting Year (year ended)","2018-06-30"]
[]
[null,"Disclosure year of most recent annual disclosure (year ended) ¹","2016-06-30"]
[]
[null,"¹ applies only to schedule 18"]
["Templates for Schedules 18–24 (Disclosure Following a Price Setting Event)"]
["Version 3.0.  Prepared 20 December 2016"]

{"sheet":"TOC","index":1,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Table of Contents"]
[]
[null,"Schedule","Description"]
[null,"18","REPORT ON THE FORECAST TOTAL ASSET BASE REVENUE REQUIREMENTS"]
[null,"19","REPORT ON THE FORECAST PRICING ASSET BASE REVENUE REQUIREMENTS"]
[null,"20","REPORT ON DEMAND FORECASTS"]
[null,"24","TRANSITIONAL REPORT ON REGULATORY ASSET BASE VALUE"]

{"sheet":"Guidelines","index":2,"n_rows":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":false,"merged":[[10,1,10,3],[0,1,0,4],[5,1,5,3],[6,1,6,3],[7,1,7,3],[8,1,8,3],[9,1,9,3]]}
[null,"Disclosure Template Guidelines for Information Entry "]
[]
[]
[]
[]
[null,"Templates\nThe templates contained in this workbook are intended to reflect the specified airport disclosure requirements set out in Schedules 18–19 of  Commerce Commission decision 715  (Commerce Act (Specified Airport Services Information Disclosure) Determination 2010). "]
[null,"Data entry cells and calculated cells\nData entered into this workbook may be entered only into the data entry cells.  Data entry cells are the bordered, unshaded areas in each template.  Under no circumstances should data be entered into the workbook outside a data entry cell.\nIn some cases, where the information for disclosure is able to be ascertained from disclosures elsewhere in the workbook, such information is disclosed in a calculated cell.  Under no circumstances should the formulas in a calculated cell be overwritten.    All cells that are not data entry cells may be locked using worksheet protection to ensure they are not overwritten."]
[null,"Validation settings on data entry cells\nTo maintain a consistency of format and to guard against errors in data entry, some data entry cells test entries for validity and accept only a limited range of values.  For example, entries may be limited to a list of category names or to values between 0% and 100%."]
[null,"Data entry cells for text entries\nData input cells that display the data validation input message \"Short text entry cell\" have a maximum text length of 253 characters.  Because of page layout constraints, this text length is unlikely to be approached .  The amount of text that may be entered in the comment boxes is restricted only by the capacity of the spreadsheet program and page layout constraints.  Should a comment box within a template be inadequate to fully present the disclosed comments, comments may be continued outside the template.  The comment box  must then contain a reference to identify where in the disclosure the comment is continued.\nRow widths can be adjusted to increase the viewable size of text entries. \nA paragraph feed may be inserted in an entry cell by holding down both the {alt} and the {shift} keys."]
[null,"Data entry cells that contain conditional formatting\nA limited number of data entry cells may change colour or disappear from view in response to data entries (including date entries) made in the workbook.  This feature has been implemented to highlight data being entered that is not internally consistent with other data currently entered, and to hide data entry cells for conditionally disclosed information when the determination does not require the data be disclosed. \na) Internal consistency checks\nTo assist with data entry, the shading of the following data entry cells will change if the cell content becomes inconsistent with data elsewhere in the template:\n   Internal consistency checking is not applied in Schedules 18–24.\n"]

{"sheet":"S18.Total revenue requirement","index":3,"n_rows":312,"n_cols":16,"rows_kept":312,"cut":false,"hidden":false,"merged":[[1,12,1,15],[2,12,2,15],[29,8,29,15],[30,8,30,15],[303,2,310,9],[66,2,73,9],[107,2,114,9],[245,2,245,9],[273,6,273,9],[60,8,60,10],[61,8,61,10],[247,2,259,9],[260,2,260,9],[227,6,227,9],[228,6,228,9],[232,2,244,9],[272,6,272,9],[181,11,181,14],[152,2,152,8],[118,7,118,9],[119,7,119,9],[174,2,176,9],[180,11,180,14],[144,2,146,9],[38,6,38,11],[31,8,31,15],[34,2,36,15],[45,2,47,15],[39,6,39,15],[40,6,40,15],[41,6,41,15],[302,2,302,9],[6,11,6,12],[7,11,7,12],[6,13,6,14],[7,13,7,14],[7,5,7,6],[6,5,6,6],[6,7,6,8],[7,7,7,8],[6,9,6,10],[7,9,7,10],[28,8,28,11],[99,2,101,9],[42,6,42,15],[56,2,56,15],[44,2,44,15]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(NOT(ISBLANK('Pricing CoverSheet'!$C$8)),'Pricing CoverSheet'!$C$8,\"\")","v":"Airport Company"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER('Pricing CoverSheet'!$C$12),'Pricing CoverSheet'!$C$12,\"\")","v":"2018-06-30"}]
["SCHEDULE 18: REPORT ON THE FORECAST TOTAL ASSET BASE REVENUE REQUIREMENTS"]
["ref","Version 3.0"]
[]
[null,null,null,null,"First Day of Pricing Period","Pricing Period Starting Year",null,"Pricing Period Starting Year + 1",null,"Pricing Period Starting Year + 2",null,"Pricing Period Starting Year + 3",null,"Pricing Period Starting Year + 4",null,"Last Day of Pricing Period"]
[{"$f":"ROW()","v":8},"18(i): Forecast Internal Rate of Return",null,null,null,{"$f":"IF(ISNUMBER('Pricing CoverSheet'!$C$12),DATE(YEAR('Pricing CoverSheet'!$C$12),MONTH('Pricing CoverSheet'!$C$12),DAY('Pricing CoverSheet'!$C$12)),\"\")","v":"2018-06-30"},null,"2019-06-30",null,"2020-06-30",null,"2021-06-30",null,"2022-06-30"]
[{"$f":"ROW()","v":9},null,"($000)","Cash flow date",{"$f":"E52","v":"2017-07-01"},{"$f":"M3-IF(ISNUMBER(E55),E55,F55)","v":"2017-12-30"},{"$f":"$M$3-IF(ISNUMBER(E54),E54,F54)","v":"2018-02-02"},{"$f":"EOMONTH($M$3,12)-IF(ISNUMBER(E55),E55,F55)","v":"2018-12-30"},{"$f":"EOMONTH($M$3,12)-IF(ISNUMBER(E54),E54,F54)","v":"2019-02-02"},{"$f":"EOMONTH($M$3,24)-IF(ISNUMBER(E55),E55,F55)","v":"2019-12-31"},{"$f":"EOMONTH($M$3,24)-IF(ISNUMBER(E54),E54,F54)","v":"2020-02-03"},{"$f":"EOMONTH($M$3,36)-IF(ISNUMBER(D54),E55,F55)","v":"2020-12-30"},{"$f":"EOMONTH($M$3,36)-IF(ISNUMBER(E54),E54,F54)","v":"2021-02-02"},{"$f":"EOMONTH($M$3,48)-IF(ISNUMBER(K55),E55,F55)","v":"2021-12-30"},{"$f":"EOMONTH($M$3,48)-IF(ISNUMBER(E54),E54,F54)","v":"2022-02-02"},{"$f":"EOMONTH($M$3,48)","v":"2022-06-30"}]
[{"$f":"ROW()","v":10},null,"Opening RAB",null,{"$f":"E132","v":0}]
[{"$f":"ROW()","v":11},null,"Opening carry forward adjustment",null,{"$f":"G33","v":0}]
[{"$f":"ROW()","v":12},null,"Opening investment value",null,{"$f":"E10-E11","v":0}]
[{"$f":"ROW()","v":13}]
[{"$f":"ROW()","v":14},"plus","Forecast total revenue requirement",null,null,null,{"$f":"F80","v":0},null,{"$f":"G80","v":0},null,{"$f":"H80","v":0},null,{"$f":"I80","v":0},null,{"$f":"J80","v":0}]
[{"$f":"ROW()","v":15},"less","Forecast assets commissioned",null,null,{"$f":"-F139","v":0},null,{"$f":"-G139","v":0},null,{"$f":"-H139","v":0},null,{"$f":"-I139","v":0},null,{"$f":"-J139","v":0}]
[{"$f":"ROW()","v":16},"plus","Forecast cash flow from asset disposals"]
[{"$f":"ROW()","v":17},"less","Forecast operational expenditure ",null,null,{"$f":"-F82","v":0},null,{"$f":"-G82","v":0},null,{"$f":"-H82","v":0},null,{"$f":"-I82","v":0},null,{"$f":"-J82","v":0}]
[{"$f":"ROW()","v":18},"less","Forecast unlevered tax",null,null,{"$f":"-F84","v":0},null,{"$f":"-G84","v":0},null,{"$f":"-H84","v":0},null,{"$f":"-I84","v":0},null,{"$f":"-J84","v":0}]
[{"$f":"ROW()","v":19}]
[{"$f":"ROW()","v":20},null,"Forecast closing asset base",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"J142","v":0}]
[{"$f":"ROW()","v":21},null,"Forecast closing carry forward adjustment",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"E44","v":0}]
[{"$f":"ROW()","v":22},null,"Forecast closing investment value",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P20-P21","v":0}]
[{"$f":"ROW()","v":23}]
[{"$f":"ROW()","v":24},null,"Forecast net cash flows",null,{"$f":"-E12","v":0},{"$f":"SUM(F14:F18)","v":0},{"$f":"SUM(G14:G18)","v":0},0,0,0,0,0,0,0,0,{"$f":"P22","v":0}]
[{"$f":"ROW()","v":25}]
[{"$f":"ROW()","v":26},null,{"$f":"\"Forecast post-tax IRR as at \"&TEXT(E9,\"dd mmmm yyy\")","v":"Forecast post-tax IRR as at 01 July 2017"},null,{"$f":"IFERROR(XIRR(E24:P24,E9:P9),\"\")","v":""}]
[{"$f":"ROW()","v":27},null,"NPV check",null,{"$f":"IFERROR(XNPV(E26,E24:P24,E9:P9),0)","v":0},{"$f":"IF(ABS(E27)<0.01,\"OK\",\"ERROR\")","v":"OK"}]
[{"$f":"ROW()","v":28},"18(ii): Opening carry forward adjustment"]
[{"$f":"ROW()","v":29},null,"($000)",null,"Forecast closing carry forward from previous price setting event","Opening carry forward adjustments from current price setting event","Total opening carry forward adjustments",null,"Please explain each adjustment and how this has been calculated"]
[{"$f":"ROW()","v":30},null,"Default revaluation gain/loss adjustment",null,null,null,{"$f":"E30+F30","v":0}]
[{"$f":"ROW()","v":31},null,"Risk allocation adjustment",null,null,null,{"$f":"E31+F31","v":0}]
[{"$f":"ROW()","v":32},null,"Other carry forward adjustments",null,null,null,{"$f":"E32+F32","v":0}]
[{"$f":"ROW()","v":33},null,"Opening carry forward adjustment",null,{"$f":"SUM(E30:E32)","v":0},0,{"$f":"SUM(G30:G32)","v":0}]
[{"$f":"ROW()","v":34},null,"Provide a summary of any views expressed by substantial customers about the pricing approaches reflected in the opening carry forward adjustment "]
[{"$f":"ROW()","v":35}]
[{"$f":"ROW()","v":36}]
[{"$f":"ROW()","v":37}]
[{"$f":"ROW()","v":38},"18(iii): Forecast closing carry forward adjustment"]
[null,null,null,null,"($000)",null,"Please explain each adjustment and how this has been calculated"]
[{"$f":"ROW()","v":40},null,"[description of closing carry forward adjustment]"]
[{"$f":"ROW()","v":41},null,"[description of closing carry forward adjustment]"]
[{"$f":"ROW()","v":42},null,"[description of closing carry forward adjustment]"]
[{"$f":"ROW()","v":43},null,"[description of closing carry forward adjustment]"]
[{"$f":"ROW()","v":44},null,"Total forecast closing carry forward adjustment",null,{"$f":"SUM(E40:E43)","v":0}]
[{"$f":"ROW()","v":45},null,"Explain how the closing investment value provides a good indication of the remaining capital expected to be recovered by the airport in future pricing periods and provide a summary of substantial customer views on any closing carry forward adjustments"]
[{"$f":"ROW()","v":46}]
[{"$f":"ROW()","v":47}]
[{"$f":"ROW()","v":48}]
[{"$f":"ROW()","v":49},"18(iv): Cash flow timing assumptions"]
[{"$f":"ROW()","v":50}]
[{"$f":"ROW()","v":51},null,"Year of most recent annual disclosure (year ended)",null,{"$f":"IF(ISNUMBER('Pricing CoverSheet'!$C$14),'Pricing CoverSheet'!$C$14,\"\")","v":"2016-06-30"}]
[{"$f":"ROW()","v":52},null,"First day of pricing period",null,"2017-07-01"]
[{"$f":"ROW()","v":53},null,null,null,"Airport assumption","Default assumption"]
[{"$f":"ROW()","v":54},null,"Cash flow timing - revenues  - days from year end",null,null,148]
[null,null,"Cash flow timing - expenditure  - days from year end",null,null,182]
[{"$f":"ROW()","v":56},null,"Explanation and evidence if airport assumption is different from default"]
[{"$f":"ROW()","v":57}]
[{"$f":"ROW()","v":58},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Page 1"]
[]
[]
[null,null,null,null,null,null,null,"Regulated Airport",{"$f":"IF(NOT(ISBLANK('Pricing CoverSheet'!$C$8)),'Pricing CoverSheet'!$C$8,\"\")","v":"Airport Company"}]
[null,null,null,null,null,null,null,"Pricing Period Starting Year Ended",{"$f":"IF(ISNUMBER('Pricing CoverSheet'!$C$12),'Pricing CoverSheet'!$C$12,\"\")","v":"2018-06-30"}]
["SCHEDULE 18: REPORT ON THE FORECAST TOTAL ASSET BASE REVENUE REQUIREMENTS (cont)"]
["ref","Version 3.0"]
[{"$f":"ROW()","v":65},"18(v): Total Revenue Requirement"]
[{"$f":"ROW()","v":66},null,"Overview of the methodology used to determine the revenue requirement"]
[{"$f":"ROW()","v":67}]
[{"$f":"ROW()","v":68}]
[{"$f":"ROW()","v":69}]
[{"$f":"ROW()","v":70}]
[{"$f":"ROW()","v":71}]
[{"$f":"ROW()","v":72}]
[{"$f":"ROW()","v":73}]
[{"$f":"ROW()","v":74}]
[{"$f":"ROW()","v":75},null,"($000)",null,null,"Pricing Period Starting Year","Pricing Period Starting Year + 1","Pricing Period Starting Year + 2","Pricing Period Starting Year + 3","Pricing Period Starting Year + 4"]
[{"$f":"ROW()","v":76},null,null,null,null,{"$f":"IF(ISNUMBER('Pricing CoverSheet'!$C$12),DATE(YEAR('Pricing CoverSheet'!$C$12),MONTH('Pricing CoverSheet'!$C$12),DAY('Pricing CoverSheet'!$C$12)),\"\")","v":"2018-06-30"},{"$f":"IF(ISNUMBER('Pricing CoverSheet'!$C$12),DATE(YEAR('Pricing CoverSheet'!$C$12)+1,MONTH('Pricing CoverSheet'!$C$12),DAY('Pricing CoverSheet'!$C$12)),\"\")","v":"2019-06-30"},{"$f":"IF(ISNUMBER('Pricing CoverSheet'!$C$12),DATE(YEAR('Pricing CoverSheet'!$C$12)+2,MONTH('Pricing CoverSheet'!$C$12),DAY('Pricing CoverSheet'!$C$12)),\"\")","v":"2020-06-30"},{"$f":"IF(ISNUMBER('Pricing CoverSheet'!$C$12),DATE(YEAR('Pricing CoverSheet'!$C$12)+3,MONTH('Pricing CoverSheet'!$C$12),DAY('Pricing CoverSheet'!$C$12)),\"\")","v":"2021-06-30"},{"$f":"IF(ISNUMBER('Pricing CoverSheet'!$C$12),DATE(YEAR('Pricing CoverSheet'!$C$12)+4,MONTH('Pricing CoverSheet'!$C$12),DAY('Pricing CoverSheet'!$C$12)),\"\")","v":"2022-06-30"}]
[{"$f":"ROW()","v":77},null,"Forecast revenue for services applicable to the price setting event (excluding forecast assets held for future use revenue)"]
[{"$f":"ROW()","v":78},"plus","Forecast lease, rental and concession income (not applicable to the price setting event)"]
[{"$f":"ROW()","v":79},"plus","Forecast other operating revenue (not applicable to the price setting event)"]
[{"$f":"ROW()","v":80},null,"Forecast total revenue requirement (excluding assets held for future use revenue)",null,null,{"$f":"SUM(F77:F79)","v":0},{"$f":"SUM(G77:G79)","v":0},{"$f":"SUM(H77:H79)","v":0},{"$f":"SUM(I77:I79)","v":0},{"$f":"SUM(J77:J79)","v":0}]
[{"$f":"ROW()","v":81}]
[{"$f":"ROW()","v":82},"less","Forecast operational expenditure ",null,null,{"$f":"F268","v":0},{"$f":"G268","v":0},{"$f":"H268","v":0},{"$f":"I268","v":0},{"$f":"J268","v":0}]
[{"$f":"ROW()","v":83},"less","Forecast depreciation",null,null,{"$f":"F137","v":0},{"$f":"G137","v":0},{"$f":"H137","v":0},{"$f":"I137","v":0},{"$f":"J137","v":0}]
[{"$f":"ROW()","v":84},"less","Forecast unlevered tax"]
[{"$f":"ROW()","v":85},"plus","Forecast revaluations",null,null,{"$f":"F138","v":0},{"$f":"G138","v":0},0,0,0]
[{"$f":"ROW()","v":86}]
[{"$f":"ROW()","v":87},null,"Forecast regulatory profit / (loss)",null,null,{"$f":"F80-F82-F83-F84+F85","v":0},{"$f":"G80-G82-G83-G84+G85","v":0},{"$f":"H80-H82-H83-H84+H85","v":0},{"$f":"I80-I82-I83-I84+I85","v":0},{"$f":"J80-J82-J83-J84+J85","v":0}]
[{"$f":"ROW()","v":88}]
[{"$f":"ROW()","v":89}]
[{"$f":"ROW()","v":90},null,"Forecast regulatory investment value",null,null,{"$f":"F136+0.5*(F139-F140)","v":0},{"$f":"G136+0.5*(G139-G140)","v":0},{"$f":"H136+0.5*(H139-H140)","v":0},{"$f":"I136+0.5*(I139-I140)","v":0},{"$f":"J136+0.5*(J139-J140)","v":0}]
[{"$f":"ROW()","v":91}]
[{"$f":"ROW()","v":92},null,"ROI - comparable to a post tax WACC",null,null,{"$f":"IFERROR(F87/F90,\"\")","v":""},{"$f":"IFERROR(G87/G90,\"\")","v":""},"","",""]
[{"$f":"ROW()","v":93}]
[{"$f":"ROW()","v":94},null,"Forecast cost of capital"]
[{"$f":"ROW()","v":95},null,"Post-tax WACC at price setting event "]
[{"$f":"ROW()","v":96},null,"WACC percentile equivalent for forecast cost of capital (optional)"]
[{"$f":"ROW()","v":97},null,"WACC percentile equivalent for the post-tax IRR (optional)"]
[{"$f":"ROW()","v":98}]
[{"$f":"ROW()","v":99},null,"Explain the differences between the post-tax IRR and the forecast cost of capital, and the post-tax WACC at price setting event  and the forecast cost of capital (including reasons)"]
[{"$f":"ROW()","v":100}]
[{"$f":"ROW()","v":101}]
[{"$f":"ROW()","v":102}]
[{"$f":"ROW()","v":103},null,"Forecast total revenue requirement from airport charges (including assets held for future use revenue)"]
[{"$f":"ROW()","v":104},null,"Forecast total revenue requirement (excluding assets held for future use revenue)",null,null,{"$f":"F80","v":0},{"$f":"G80","v":0},0,0,0]
[{"$f":"ROW()","v":105},null,"Forecast assets held for future use revenue "]
[{"$f":"ROW()","v":106},null,"Forecast total revenue requirement (including forecast assets held for future use revenue)",null,null,{"$f":"F104+F105","v":0},{"$f":"G104+G105","v":0},{"$f":"H104+H105","v":0},{"$f":"I104+I105","v":0},{"$f":"J104+J105","v":0}]
[{"$f":"ROW()","v":107},null,"Description of any other factors that are considered in determining the forecast total revenue requirement"]
[{"$f":"ROW()","v":108}]
[{"$f":"ROW()","v":109}]
[{"$f":"ROW()","v":110}]
[{"$f":"ROW()","v":111}]
[{"$f":"ROW()","v":112}]
[{"$f":"ROW()","v":113}]
[{"$f":"ROW()","v":114}]
[{"$f":"ROW()","v":115}]
[{"$f":"ROW()","v":116},null,null,null,null,null,null,null,null,null,null,"Page 2"]
[]
[]
[null,null,null,null,null,null,"Regulated Airport",{"$f":"IF(NOT(ISBLANK('Pricing CoverSheet'!$C$8)),'Pricing CoverSheet'!$C$8,\"\")","v":"Airport Company"}]
[null,null,null,null,null,null,"Pricing Period Starting Year Ended",{"$f":"IF(ISNUMBER('Pricing CoverSheet'!$C$12),'Pricing CoverSheet'!$C$12,\"\")","v":"2018-06-30"}]
["SCHEDULE 18: REPORT ON THE FORECAST TOTAL ASSET BASE REVENUE REQUIREMENTS (cont 3)"]
["ref","Version 3.0"]
[null,null,"($000)"]
[{"$f":"ROW()","v":124},"18(vi): Opening Regulatory Asset Base"]
[{"$f":"ROW()","v":125},null,null,null,{"$f":"E52-1","v":"2017-06-30"}]
[{"$f":"ROW()","v":126},null,{"$f":"\"Regulatory asset base as at \"&TEXT(E51,\"dd mmmm yyy\")","v":"Regulatory asset base as at 30 June 2016"}]
[{"$f":"ROW()","v":127},"less","Forecast depreciation"]
[{"$f":"ROW()","v":128},"plus","Forecast revaluations"]
[{"$f":"ROW()","v":129},"plus","Assets commissioned"]
[{"$f":"ROW()","v":130},"less ","Asset disposals"]
[{"$f":"ROW()","v":131},"plus (less)","Forecast adjustment resulting from cost allocation"]
[{"$f":"ROW()","v":132},null,"Estimate of regulatory asset base at start of price setting event",null,{"$f":"E126-E127+E128+E129-E130+E131","v":0}]
[{"$f":"ROW()","v":133},null,null,null,"Pricing Period Starting Year - 1","Pricing Period Starting Year","Pricing Period Starting Year + 1","Pricing Period Starting Year + 2","Pricing Period Starting Year + 3","Pricing Period Starting Year + 4"]
[{"$f":"ROW()","v":134},null,{"$f":"IF(ISNUMBER('Pricing CoverSheet'!$C$12),\"for year ended\",\"\")","v":"for year ended"},null,{"$f":"EOMONTH(F134,-12)","v":"2017-06-30"},{"$f":"IF(ISNUMBER('Pricing CoverSheet'!$C$12),DATE(YEAR('Pricing CoverSheet'!$C$12),MONTH('Pricing CoverSheet'!$C$12),DAY('Pricing CoverSheet'!$C$12)),\"\")","v":"2018-06-30"},{"$f":"IF(ISNUMBER('Pricing CoverSheet'!$C$12),DATE(YEAR('Pricing CoverSheet'!$C$12)+1,MONTH('Pricing CoverSheet'!$C$12),DAY('Pricing CoverSheet'!$C$12)),\"\")","v":"2019-06-30"},{"$f":"IF(ISNUMBER('Pricing CoverSheet'!$C$12),DATE(YEAR('Pricing CoverSheet'!$C$12)+2,MONTH('Pricing CoverSheet'!$C$12),DAY('Pricing CoverSheet'!$C$12)),\"\")","v":"2020-06-30"},{"$f":"IF(ISNUMBER('Pricing CoverSheet'!$C$12),DATE(YEAR('Pricing CoverSheet'!$C$12)+3,MONTH('Pricing CoverSheet'!$C$12),DAY('Pricing CoverSheet'!$C$12)),\"\")","v":"2021-06-30"},{"$f":"IF(ISNUMBER('Pricing CoverSheet'!$C$12),DATE(YEAR('Pricing CoverSheet'!$C$12)+4,MONTH('Pricing CoverSheet'!$C$12),DAY('Pricing CoverSheet'!$C$12)),\"\")","v":"2022-06-30"}]
[{"$f":"ROW()","v":135},"18(vii): Forecast Asset Base"]
[{"$f":"ROW()","v":136},null,"Forecast asset base—previous year",null,null,{"$f":"E142","v":0},{"$f":"F142","v":0},{"$f":"G142","v":0},{"$f":"H142","v":0},{"$f":"I142","v":0}]
[{"$f":"ROW()","v":137},"less","Forecast depreciation"]
[{"$f":"ROW()","v":138},"plus","Forecast revaluations",null,{"$f":"E299","v":0},0,0,0,0,0]
[{"$f":"ROW()","v":139},"plus","Assets commissioned"]
[{"$f":"ROW()","v":140},"less ","Asset disposals"]
[{"$f":"ROW()","v":141},"plus (less)","Forecast adjustment resulting from cost allocation"]
[{"$f":"ROW()","v":142},null,"Forecast asset base",null,{"$f":"E136-E137+E138+E139-E140+E141","v":0},0,0,0,0,0]
[{"$f":"ROW()","v":143}]
[{"$f":"ROW()","v":144},null,"Description and explanation of the depreciation methodology applied"]
[{"$f":"ROW()","v":145}]
[{"$f":"ROW()","v":146}]
[{"$f":"ROW()","v":147}]
[{"$f":"ROW()","v":148},"18(viii): Forecast Works Under Construction"]
[{"$f":"ROW()","v":149},null,"Works under construction—previous year"]
[{"$f":"ROW()","v":150},"plus","Capital expenditure"]
[{"$f":"ROW()","v":151},"less","Assets commissioned"]
[{"$f":"ROW()","v":152},null,"Works under construction",null,{"$f":"E149+E150-E151","v":0},0,0,0,0,0]
[{"$f":"ROW()","v":153}]
[{"$f":"ROW()","v":154},"18(ix): Assets held for future use cost and base value"]
[{"$f":"ROW()","v":155},null,"Assets held for future use opening cost—previous year",null,null,{"$f":"E161","v":0},{"$f":"F161","v":0},{"$f":"G161","v":0},{"$f":"H161","v":0},{"$f":"I161","v":0}]
[{"$f":"ROW()","v":156},"plus","Forecast holding costs"]
[{"$f":"ROW()","v":157},"less","Forecast assets held for future use net revenue"]
[{"$f":"ROW()","v":158},"plus","Forecast assets held for future use additions"]
[{"$f":"ROW()","v":159},"less","Forecast assets held for future use disposals"]
[{"$f":"ROW()","v":160},"less","Forecast transfers to works under construction"]
[{"$f":"ROW()","v":161},null,"Assets held for future use closing cost",null,{"$f":"E155+E156-E157+E158-E159-E160","v":0},{"$f":"F155+F156-F157+F158-F159-F160","v":0},0,0,0,0]
[{"$f":"ROW()","v":162}]
[{"$f":"ROW()","v":163},null,"Initial base value"]
[{"$f":"ROW()","v":164},"plus","Opening tracking revaluations"]
[{"$f":"ROW()","v":165},null,"Opening base value",null,{"$f":"SUM(E163:E164)","v":0},{"$f":"E170","v":0},{"$f":"F170","v":0},{"$f":"G170","v":0},0,0]
[{"$f":"ROW()","v":166},"plus","Forecast assets held for future use revaluations "]
[{"$f":"ROW()","v":167},"plus","Forecast assets held for future use additions",null,{"$f":"E158","v":0},{"$f":"F158","v":0},0,0,0,0]
[{"$f":"ROW()","v":168},"less","Forecast assets held for future use disposals",null,{"$f":"E159","v":0},0,0,0,0,0]
[{"$f":"ROW()","v":169},"less","Forecast transfers to works under construction",null,0,0,0,0,0,0]
[{"$f":"ROW()","v":170},null,"Closing base value",null,{"$f":"E165+E166+E167-E168-E169","v":0},{"$f":"F165+F166+F167-F168-F169","v":0},0,0,0,0]
[{"$f":"ROW()","v":171}]
[{"$f":"ROW()","v":172},null,"Tracking revaluations",null,{"$f":"E164+E166","v":0},{"$f":"E172+F166","v":0},{"$f":"F172+G166","v":0},{"$f":"G172+H166","v":0},0,0]
[{"$f":"ROW()","v":173}]
[{"$f":"ROW()","v":174},null,"Assumptions and explanations of any assets held for future use revenues"]
[{"$f":"ROW()","v":175}]
[{"$f":"ROW()","v":176}]
[{"$f":"ROW()","v":177}]
[{"$f":"ROW()","v":178},null,null,null,null,null,null,null,null,null,"Page 3"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Regulated Airport",{"$f":"IF(NOT(ISBLANK('Pricing CoverSheet'!$C$8)),'Pricing CoverSheet'!$C$8,\"\")","v":"Airport Company"}]
[null,null,null,null,null,null,null,null,null,null,"Pricing Period Starting Year Ended",{"$f":"IF(ISNUMBER('Pricing CoverSheet'!$C$12),'Pricing CoverSheet'!$C$12,\"\")","v":"2018-06-30"}]
["SCHEDULE 18: REPORT ON THE FORECAST TOTAL ASSET BASE REVENUE REQUIREMENTS (cont 4)"]
["ref","Version 3.0"]
[{"$f":"ROW()","v":185},"18(x): Forecast Capital Expenditure"]
[{"$f":"ROW()","v":186},null,"($000)",null,"Pricing Period Starting Year","Pricing Period Starting Year + 1","Pricing Period Starting Year + 2","Pricing Period Starting Year + 3","Pricing Period Starting Year + 4","Pricing Period Starting Year + 5","Pricing Period Starting Year + 6","Pricing Period Starting Year + 7","Pricing Period Starting Year + 8","Pricing Period Starting Year + 9",null,"Total"]
[{"$f":"ROW()","v":187},null,{"$f":"IF(ISNUMBER('Pricing CoverSheet'!$C$12),\"for year ended\",\"\")","v":"for year ended"},null,{"$f":"IF(ISNUMBER('Pricing CoverSheet'!$C$12),DATE(YEAR('Pricing CoverSheet'!$C$12),MONTH('Pricing CoverSheet'!$C$12),DAY('Pricing CoverSheet'!$C$12)),\"\")","v":"2018-06-30"},{"$f":"IF(ISNUMBER('Pricing CoverSheet'!$C$12),DATE(YEAR('Pricing CoverSheet'!$C$12)+1,MONTH('Pricing CoverSheet'!$C$12),DAY('Pricing CoverSheet'!$C$12)),\"\")","v":"2019-06-30"},{"$f":"IF(ISNUMBER('Pricing CoverSheet'!$C$12),DATE(YEAR('Pricing CoverSheet'!$C$12)+2,MONTH('Pricing CoverSheet'!$C$12),DAY('Pricing CoverSheet'!$C$12)),\"\")","v":"2020-06-30"},{"$f":"IF(ISNUMBER('Pricing CoverSheet'!$C$12),DATE(YEAR('Pricing CoverSheet'!$C$12)+3,MONTH('Pricing CoverSheet'!$C$12),DAY('Pricing CoverSheet'!$C$12)),\"\")","v":"2021-06-30"},{"$f":"IF(ISNUMBER('Pricing CoverSheet'!$C$12),DATE(YEAR('Pricing CoverSheet'!$C$12)+4,MONTH('Pricing CoverSheet'!$C$12),DAY('Pricing CoverSheet'!$C$12)),\"\")","v":"2022-06-30"},{"$f":"IF(ISNUMBER('Pricing CoverSheet'!$C$12),DATE(YEAR('Pricing CoverSheet'!$C$12)+5,MONTH('Pricing CoverSheet'!$C$12),DAY('Pricing CoverSheet'!$C$12)),\"\")","v":"2023-06-30"},{"$f":"IF(ISNUMBER('Pricing CoverSheet'!$C$12),DATE(YEAR('Pricing CoverSheet'!$C$12)+6,MONTH('Pricing CoverSheet'!$C$12),DAY('Pricing CoverSheet'!$C$12)),\"\")","v":"2024-06-30"},{"$f":"IF(ISNUMBER('Pricing CoverSheet'!$C$12),DATE(YEAR('Pricing CoverSheet'!$C$12)+7,MONTH('Pricing CoverSheet'!$C$12),DAY('Pricing CoverSheet'!$C$12)),\"\")","v":"2025-06-30"},{"$f":"IF(ISNUMBER('Pricing CoverSheet'!$C$12),DATE(YEAR('Pricing CoverSheet'!$C$12)+8,MONTH('Pricing CoverSheet'!$C$12),DAY('Pricing CoverSheet'!$C$12)),\"\")","v":"2026-06-30"},{"$f":"IF(ISNUMBER('Pricing CoverSheet'!$C$12),DATE(YEAR('Pricing CoverSheet'!$C$12)+9,MONTH('Pricing CoverSheet'!$C$12),DAY('Pricing CoverSheet'!$C$12)),\"\")","v":"2027-06-30"}]
[{"$f":"ROW()","v":188},null,"Capital Expenditure by Category"]
[{"$f":"ROW()","v":189},null,"Capacity growth"]
[{"$f":"ROW()","v":190},null,"Asset replacement and renewal"]
[{"$f":"ROW()","v":191},null,"Total capital expenditure",null,{"$f":"SUM(E189:E190)","v":0},0,0,0,0,0,0,0,0,0]
[{"$f":"ROW()","v":192},null,"Capital Expenditure by Key Capital Expenditure Project"]
[{"$f":"ROW()","v":193},null,"[Project 1]",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E193,F193,G193,H193,I193,J193,K193,L193,M193,N193)","v":0}]
[{"$f":"ROW()","v":194},null,"[Project 2]",null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"ROW()","v":195},null,"[Project 3]",null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"ROW()","v":196},null,"[Project 4]",null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"ROW()","v":197},null,"[Project 5]",null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"ROW()","v":198},null,"[Project 6]",null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"ROW()","v":199},null,"[Project 7]",null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"ROW()","v":200},null,"[Project 8]",null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"ROW()","v":201},null,"[Project 9]",null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"ROW()","v":202},null,"[Project 10]",null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"ROW()","v":203},null,"[Project 11]",null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"ROW()","v":204},null,"[Project 12]",null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"ROW()","v":205},null,"[Project 13]",null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"ROW()","v":206},null,"[Project 14]",null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"ROW()","v":207},null,"[Project 15]",null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"ROW()","v":208},null,"[Project 16]",null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"ROW()","v":209},null,"[Project 17]",null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"ROW()","v":210},null,"[Project 18]",null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"ROW()","v":211},null,"[Project 19]",null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"ROW()","v":212},null,"[Project 20]",null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"ROW()","v":213},null,"[Project 21]",null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"ROW()","v":214},null,"[Project 22]",null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"ROW()","v":215},null,"[Project 23]",null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"ROW()","v":216},null,"[Project 24]",null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"ROW()","v":217},null,"[Project 25]",null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"ROW()","v":218},null,"[Project 26]",null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"ROW()","v":219},null,"[Project 27]",null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"ROW()","v":220},null,"[Project 28]",null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"ROW()","v":221},null,"[Project 29]",null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"ROW()","v":222},null,"[Project 30]",null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"ROW()","v":223},null,"Other capital expenditure",null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"ROW()","v":224},null,"Total Capital Expenditure ",null,{"$f":"SUM(E193:E223)","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(P193:P223)","v":0}]
[{"$f":"ROW()","v":225},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Page 4"]
[]
[]
[null,null,null,null,null,"Regulated Airport",{"$f":"IF(NOT(ISBLANK('Pricing CoverSheet'!$C$8)),'Pricing CoverSheet'!$C$8,\"\")","v":"Airport Company"}]
[null,null,null,null,null,"Pricing Period Starting Year Ended",{"$f":"IF(ISNUMBER('Pricing CoverSheet'!$C$12),'Pricing CoverSheet'!$C$12,\"\")","v":"2018-06-30"}]
["SCHEDULE 18: REPORT ON THE FORECAST TOTAL ASSET BASE REVENUE REQUIREMENTS (cont 5)"]
["ref","Version 3.0"]
[{"$f":"ROW()","v":232},null,"Basis for Cost Allocation"]
[{"$f":"ROW()","v":233}]
[{"$f":"ROW()","v":234}]
[{"$f":"ROW()","v":235}]
[{"$f":"ROW()","v":236}]
[{"$f":"ROW()","v":237}]
[{"$f":"ROW()","v":238}]
[{"$f":"ROW()","v":239}]
[{"$f":"ROW()","v":240}]
[{"$f":"ROW()","v":241}]
[{"$f":"ROW()","v":242}]
[{"$f":"ROW()","v":243}]
[{"$f":"ROW()","v":244}]
[{"$f":"ROW()","v":245}]
[{"$f":"ROW()","v":246},null,"An explanation of where and why disclosures differ from the cost-allocation Input Methodology and/or, where costs are shared between regulated and non-regulated assets, an explanation of the basis for that allocation."]
[{"$f":"ROW()","v":247},null,"Key Capital Expenditure Projects—Consumer Demands Assessment"]
[{"$f":"ROW()","v":248}]
[{"$f":"ROW()","v":249}]
[{"$f":"ROW()","v":250}]
[{"$f":"ROW()","v":251}]
[{"$f":"ROW()","v":252}]
[{"$f":"ROW()","v":253}]
[{"$f":"ROW()","v":254}]
[{"$f":"ROW()","v":255}]
[{"$f":"ROW()","v":256}]
[{"$f":"ROW()","v":257}]
[{"$f":"ROW()","v":258}]
[{"$f":"ROW()","v":259}]
[{"$f":"ROW()","v":260}]
[{"$f":"ROW()","v":261},null,"An explanation of how consumer demands have been assessed and incorporated for each reported project and the degree to which consumers agree with project scope, timing and cost. "]
[{"$f":"ROW()","v":262},"18(xi) Forecast operational expenditure"]
[{"$f":"ROW()","v":263},null,"($000)",null,null,"Pricing Period Starting Year","Pricing Period Starting Year + 1","Pricing Period Starting Year + 2","Pricing Period Starting Year + 3","Pricing Period Starting Year + 4"]
[{"$f":"ROW()","v":264},null,null,null,null,{"$f":"IF(ISNUMBER('Pricing CoverSheet'!$C$12),DATE(YEAR('Pricing CoverSheet'!$C$12),MONTH('Pricing CoverSheet'!$C$12),DAY('Pricing CoverSheet'!$C$12)),\"\")","v":"2018-06-30"},{"$f":"IF(ISNUMBER('Pricing CoverSheet'!$C$12),DATE(YEAR('Pricing CoverSheet'!$C$12)+1,MONTH('Pricing CoverSheet'!$C$12),DAY('Pricing CoverSheet'!$C$12)),\"\")","v":"2019-06-30"},{"$f":"IF(ISNUMBER('Pricing CoverSheet'!$C$12),DATE(YEAR('Pricing CoverSheet'!$C$12)+2,MONTH('Pricing CoverSheet'!$C$12),DAY('Pricing CoverSheet'!$C$12)),\"\")","v":"2020-06-30"},{"$f":"IF(ISNUMBER('Pricing CoverSheet'!$C$12),DATE(YEAR('Pricing CoverSheet'!$C$12)+3,MONTH('Pricing CoverSheet'!$C$12),DAY('Pricing CoverSheet'!$C$12)),\"\")","v":"2021-06-30"},{"$f":"IF(ISNUMBER('Pricing CoverSheet'!$C$12),DATE(YEAR('Pricing CoverSheet'!$C$12)+4,MONTH('Pricing CoverSheet'!$C$12),DAY('Pricing CoverSheet'!$C$12)),\"\")","v":"2022-06-30"}]
[{"$f":"ROW()","v":265},null,"Corporate overheads"]
[{"$f":"ROW()","v":266},null,"Asset management and airport operations"]
[{"$f":"ROW()","v":267},null,"Asset maintenance"]
[{"$f":"ROW()","v":268},null,"Forecast operational expenditure",null,null,{"$f":"SUM(F265:F267)","v":0},{"$f":"SUM(G265:G267)","v":0},{"$f":"SUM(H265:H267)","v":0},{"$f":"SUM(I265:I267)","v":0},{"$f":"SUM(J265:J267)","v":0}]
[]
[{"$f":"ROW()","v":270},null,null,null,null,null,null,null,null,null,"Page 5"]
[]
[]
[null,null,null,null,null,"Regulated Airport",{"$f":"IF(NOT(ISBLANK('Pricing CoverSheet'!$C$8)),'Pricing CoverSheet'!$C$8,\"\")","v":"Airport Company"}]
[null,null,null,null,null,"Pricing Period Starting Year Ended",{"$f":"IF(ISNUMBER('Pricing CoverSheet'!$C$12),'Pricing CoverSheet'!$C$12,\"\")","v":"2018-06-30"}]
["SCHEDULE 18: REPORT ON THE FORECAST TOTAL ASSET BASE REVENUE REQUIREMENTS (cont 6)"]
["ref","Version 3.0"]
[{"$f":"ROW()","v":277},"18(xii) Forecast financial incentives"]
[{"$f":"ROW()","v":278},null,"($000)",null,null,"Pricing Period Starting Year","Pricing Period Starting Year + 1","Pricing Period Starting Year + 2","Pricing Period Starting Year + 3","Pricing Period Starting Year + 4"]
[{"$f":"ROW()","v":279},null,null,null,null,{"$f":"IF(ISNUMBER('Pricing CoverSheet'!$C$12),DATE(YEAR('Pricing CoverSheet'!$C$12),MONTH('Pricing CoverSheet'!$C$12),DAY('Pricing CoverSheet'!$C$12)),\"\")","v":"2018-06-30"},{"$f":"IF(ISNUMBER('Pricing CoverSheet'!$C$12),DATE(YEAR('Pricing CoverSheet'!$C$12)+1,MONTH('Pricing CoverSheet'!$C$12),DAY('Pricing CoverSheet'!$C$12)),\"\")","v":"2019-06-30"},{"$f":"IF(ISNUMBER('Pricing CoverSheet'!$C$12),DATE(YEAR('Pricing CoverSheet'!$C$12)+2,MONTH('Pricing CoverSheet'!$C$12),DAY('Pricing CoverSheet'!$C$12)),\"\")","v":"2020-06-30"},{"$f":"IF(ISNUMBER('Pricing CoverSheet'!$C$12),DATE(YEAR('Pricing CoverSheet'!$C$12)+3,MONTH('Pricing CoverSheet'!$C$12),DAY('Pricing CoverSheet'!$C$12)),\"\")","v":"2021-06-30"},{"$f":"IF(ISNUMBER('Pricing CoverSheet'!$C$12),DATE(YEAR('Pricing CoverSheet'!$C$12)+4,MONTH('Pricing CoverSheet'!$C$12),DAY('Pricing CoverSheet'!$C$12)),\"\")","v":"2022-06-30"}]
[{"$f":"ROW()","v":280},null,"Forecast pricing incentives"]
[{"$f":"ROW()","v":281},null,"Forecast other incentives"]
[{"$f":"ROW()","v":282},null,"Forecast total financial incentives",null,null,{"$f":"SUM(F280:F281)","v":0},{"$f":"SUM(G280:G281)","v":0},{"$f":"SUM(H280:H281)","v":0},{"$f":"SUM(I280:I281)","v":0},{"$f":"SUM(J280:J281)","v":0}]
[{"$f":"ROW()","v":283}]
[{"$f":"ROW()","v":284},"18(xiii) Forecast revaluations"]
[{"$f":"ROW()","v":285},null,null,null,"Pricing Period Starting Year - 1","Pricing Period Starting Year","Pricing Period Starting Year + 1","Pricing Period Starting Year + 2","Pricing Period Starting Year + 3","Pricing Period Starting Year + 4"]
[{"$f":"ROW()","v":286},null,null,null,{"$f":"EOMONTH(F286,-12)","v":"2017-06-30"},{"$f":"IF(ISNUMBER('Pricing CoverSheet'!$C$12),DATE(YEAR('Pricing CoverSheet'!$C$12),MONTH('Pricing CoverSheet'!$C$12),DAY('Pricing CoverSheet'!$C$12)),\"\")","v":"2018-06-30"},{"$f":"IF(ISNUMBER('Pricing CoverSheet'!$C$12),DATE(YEAR('Pricing CoverSheet'!$C$12)+1,MONTH('Pricing CoverSheet'!$C$12),DAY('Pricing CoverSheet'!$C$12)),\"\")","v":"2019-06-30"},{"$f":"IF(ISNUMBER('Pricing CoverSheet'!$C$12),DATE(YEAR('Pricing CoverSheet'!$C$12)+2,MONTH('Pricing CoverSheet'!$C$12),DAY('Pricing CoverSheet'!$C$12)),\"\")","v":"2020-06-30"},{"$f":"IF(ISNUMBER('Pricing CoverSheet'!$C$12),DATE(YEAR('Pricing CoverSheet'!$C$12)+3,MONTH('Pricing CoverSheet'!$C$12),DAY('Pricing CoverSheet'!$C$12)),\"\")","v":"2021-06-30"},{"$f":"IF(ISNUMBER('Pricing CoverSheet'!$C$12),DATE(YEAR('Pricing CoverSheet'!$C$12)+4,MONTH('Pricing CoverSheet'!$C$12),DAY('Pricing CoverSheet'!$C$12)),\"\")","v":"2022-06-30"}]
[{"$f":"ROW()","v":287},null,"Forecast CPI used to set prices"]
[{"$f":"ROW()","v":288},null,"Forecast pricing CPI (%)"]
[{"$f":"ROW()","v":289},null,"Asset category revaluation rates (%)"]
[{"$f":"ROW()","v":290},null,"Land "]
[{"$f":"ROW()","v":291},null,"Sealed Surfaces"]
[{"$f":"ROW()","v":292},null,"Infrastructure and buildings "]
[{"$f":"ROW()","v":293},null,"Vehicles, plant and equipment"]
[{"$f":"ROW()","v":294},null,"Forecast revaluations  ($000s)"]
[{"$f":"ROW()","v":295},null,"Land "]
[{"$f":"ROW()","v":296},null,"Sealed Surfaces"]
[{"$f":"ROW()","v":297},null,"Infrastructure and buildings "]
[{"$f":"ROW()","v":298},null,"Vehicles, plant and equipment"]
[{"$f":"ROW()","v":299},null,"Total forecast revaluations",null,{"$f":"SUM(E295:E298)","v":0},0,0,0,0,0]
[{"$f":"ROW()","v":300}]
[{"$f":"ROW()","v":301},null,"Value of any forecast revaluations not consistent with IMs"]
[{"$f":"ROW()","v":302},"18(xiv) Alternative methodologies with equivalent effect"]
[{"$f":"ROW()","v":303},null,"Description of and explanation for any alternative methodologies with equivalent effect that have been applied and which components they have been applied to (including evidence to support that it is likely to have equivalent effect)"]
[{"$f":"ROW()","v":304}]
[{"$f":"ROW()","v":305}]
[{"$f":"ROW()","v":306}]
[{"$f":"ROW()","v":307}]
[{"$f":"ROW()","v":308}]
[{"$f":"ROW()","v":309}]
[{"$f":"ROW()","v":310}]
[{"$f":"ROW()","v":311}]
[null,null,null,null,null,null,null,null,null,null,"Page 6"]

{"sheet":"S19 Pricing Asset Revenue","index":4,"n_rows":145,"n_cols":17,"rows_kept":145,"cut":false,"hidden":false,"merged":[[140,2,142,9],[61,8,61,10],[66,2,73,9],[103,2,110,9],[114,7,114,9],[115,7,115,9],[39,6,39,15],[6,5,6,6],[6,7,6,8],[6,9,6,10],[6,11,6,12],[6,13,6,14],[7,5,7,6],[7,7,7,8],[7,9,7,10],[7,11,7,12],[7,13,7,14],[1,12,1,15],[2,12,2,15],[95,2,97,9],[60,8,60,10],[38,6,38,8],[29,8,29,15],[30,8,30,15],[31,8,31,15],[40,6,40,15],[41,6,41,15],[42,6,42,15],[45,2,47,15],[56,2,56,15],[44,2,44,15],[28,8,28,15],[34,2,36,15]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(NOT(ISBLANK('Pricing CoverSheet'!$C$8)),'Pricing CoverSheet'!$C$8,\"\")","v":"Airport Company"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER('Pricing CoverSheet'!$C$12),'Pricing CoverSheet'!$C$12,\"\")","v":"2018-06-30"}]
["SCHEDULE 19: REPORT ON THE FORECAST PRICING ASSET BASE REVENUE REQUIREMENTS"]
["ref","Version 3.0"]
[]
[null,null,null,null,"First Day of Pricing Period","Pricing Period Starting Year",null,"Pricing Period Starting Year + 1",null,"Pricing Period Starting Year + 2",null,"Pricing Period Starting Year + 3",null,"Pricing Period Starting Year + 4",null,"Last Day of Pricing Period"]
[{"$f":"ROW()","v":8},"19(i): Forecast Internal Rate of Return",null,null,null,{"$f":"IF(ISNUMBER('Pricing CoverSheet'!$C$12),DATE(YEAR('Pricing CoverSheet'!$C$12),MONTH('Pricing CoverSheet'!$C$12),DAY('Pricing CoverSheet'!$C$12)),\"\")","v":"2018-06-30"},null,"2019-06-30",null,"2020-06-30",null,"2021-06-30",null,"2022-06-30"]
[{"$f":"ROW()","v":9},null,"($000)","Cash flow date",{"$f":"E52","v":"2017-07-01"},{"$f":"M3-IF(ISNUMBER(E55),E55,F55)","v":"2017-12-30"},{"$f":"$M$3-IF(ISNUMBER(E54),E54,F54)","v":"2018-02-02"},{"$f":"EOMONTH($M$3,12)-IF(ISNUMBER(E55),E55,F55)","v":"2018-12-30"},{"$f":"EOMONTH($M$3,12)-IF(ISNUMBER(E54),E54,F54)","v":"2019-02-02"},{"$f":"EOMONTH($M$3,24)-IF(ISNUMBER(E55),E55,F55)","v":"2019-12-31"},{"$f":"EOMONTH($M$3,24)-IF(ISNUMBER(E54),E54,F54)","v":"2020-02-03"},{"$f":"EOMONTH($M$3,36)-IF(ISNUMBER(D54),E55,F55)","v":"2020-12-30"},{"$f":"EOMONTH($M$3,36)-IF(ISNUMBER(E54),E54,F54)","v":"2021-02-02"},{"$f":"EOMONTH($M$3,48)-IF(ISNUMBER(K55),E55,F55)","v":"2021-12-30"},{"$f":"EOMONTH($M$3,48)-IF(ISNUMBER(E54),E54,F54)","v":"2022-02-02"},{"$f":"EOMONTH($M$3,48)","v":"2022-06-30"}]
[{"$f":"ROW()","v":10},null,"Opening asset base (applicable to price setting)",null,{"$f":"F132","v":0}]
[{"$f":"ROW()","v":11},null,"Opening carry forward adjustment",null,{"$f":"G33","v":0}]
[{"$f":"ROW()","v":12},null,"Opening investment value",null,{"$f":"E10-E11","v":0}]
[{"$f":"ROW()","v":13}]
[{"$f":"ROW()","v":14},"plus","Forecast revenue for services applicable to price setting event",null,null,null,{"$f":"F81","v":0},null,{"$f":"G81","v":0},null,{"$f":"H81","v":0},null,{"$f":"I81","v":0},null,{"$f":"J81","v":0}]
[{"$f":"ROW()","v":15},"less","Forecast assets commissioned",null,null,{"$f":"-F143","v":0},null,{"$f":"-G143","v":0},null,{"$f":"-H143","v":0},null,{"$f":"-I143","v":0},null,{"$f":"-J143","v":0}]
[{"$f":"ROW()","v":16},"plus","Forecast cash flow from asset disposals"]
[{"$f":"ROW()","v":17},"less","Forecast operational expenditure ",null,null,{"$f":"-F83","v":0},null,{"$f":"-G83","v":0},null,{"$f":"-H83","v":0},null,{"$f":"-I83","v":0},null,{"$f":"-J83","v":0}]
[{"$f":"ROW()","v":18},"less","Forecast unlevered tax",null,null,{"$f":"-F85","v":0},null,{"$f":"-G85","v":0},null,{"$f":"-H85","v":0},null,{"$f":"-I85","v":0},null,{"$f":"-J85","v":0}]
[{"$f":"ROW()","v":19}]
[{"$f":"ROW()","v":20},null,"Forecast closing asset base",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"J138","v":0}]
[{"$f":"ROW()","v":21},null,"Forecast closing carry forward adjustment",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"E44","v":0}]
[{"$f":"ROW()","v":22},null,"Forecast closing investment value",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P20-P21","v":0}]
[{"$f":"ROW()","v":23}]
[{"$f":"ROW()","v":24},null,"Forecast net cash flows",null,{"$f":"-E12","v":0},{"$f":"SUM(F14:F18)","v":0},{"$f":"SUM(G14:G18)","v":0},0,0,0,0,0,0,0,0,{"$f":"P22","v":0}]
[{"$f":"ROW()","v":25}]
[{"$f":"ROW()","v":26},null,{"$f":"\"Forcast post-tax IRR as at \"&TEXT(E9,\"dd mmmm yyy\")","v":"Forcast post-tax IRR as at 01 July 2017"},null,{"$f":"IFERROR(XIRR(E24:P24,E9:P9),\"\")","v":""}]
[{"$f":"ROW()","v":27},null,"NPV check",null,{"$f":"IFERROR(XNPV(E26,E24:P24,E9:P9),0)","v":0},{"$f":"IF(ABS(E27)<0.01,\"OK\",\"ERROR\")","v":"OK"}]
[{"$f":"ROW()","v":28},"19(ii): Opening carry forward adjustment"]
[{"$f":"ROW()","v":29},null,"($000)",null,"Forecast closing carry forward from previous price setting event","Opening carry forward adjustments from current price setting event","Total opening carry forward adjustments",null,"Please explain each adjustment and how this has been calculated"]
[{"$f":"ROW()","v":30},null,"Default revaluation gain/loss adjustment",null,null,null,{"$f":"E30+F30","v":0}]
[{"$f":"ROW()","v":31},null,"Risk allocation adjustment",null,null,null,{"$f":"E31+F31","v":0}]
[{"$f":"ROW()","v":32},null,"Other carry forward adjustments",null,null,null,0]
[{"$f":"ROW()","v":33},null,"Opening carry forward adjustment",null,{"$f":"SUM(E30:E32)","v":0},0,{"$f":"SUM(G30:G32)","v":0}]
[{"$f":"ROW()","v":34},null,"Provide a summary of any views expressed by substantial customers about the pricing approaches reflected in the opening carry forward adjustment "]
[{"$f":"ROW()","v":35}]
[{"$f":"ROW()","v":36}]
[{"$f":"ROW()","v":37}]
[{"$f":"ROW()","v":38},"19(iii): Forecast closing carry forward adjustment"]
[null,null,null,null,"($000)",null,"Please explain each adjustment and how this has been calculated"]
[{"$f":"ROW()","v":40},null,"[description of closing carry forward adjustment]"]
[{"$f":"ROW()","v":41},null,"[description of closing carry forward adjustment]"]
[{"$f":"ROW()","v":42},null,"[description of closing carry forward adjustment]"]
[{"$f":"ROW()","v":43},null,"[description of closing carry forward adjustment]"]
[{"$f":"ROW()","v":44},null,"Total forecast closing carry forward adjustment",null,{"$f":"SUM(E40:E43)","v":0}]
[{"$f":"ROW()","v":45},null,"Explain how the closing investment value provides a good indication of the remaining capital expected to be recovered by the airport in future pricing periods and provide a summary of substantial customer views on any closing carry forward adjustments"]
[{"$f":"ROW()","v":46}]
[{"$f":"ROW()","v":47}]
[{"$f":"ROW()","v":48}]
[{"$f":"ROW()","v":49},"19(iv): Cash flow timing assumptions"]
[{"$f":"ROW()","v":50}]
[{"$f":"ROW()","v":51},null,"Year of most recent annual disclosure (year ended)",null,{"$f":"IF(ISNUMBER('Pricing CoverSheet'!$C$14),'Pricing CoverSheet'!$C$14,\"\")","v":"2016-06-30"}]
[{"$f":"ROW()","v":52},null,"First day of pricing period",null,{"$f":"'S18.Total revenue requirement'!E52","v":"2017-07-01"}]
[{"$f":"ROW()","v":53},null,null,null,"Airport assumption","Default assumption"]
[null,null,"Cash flow timing - revenues  - days from year end",null,null,148]
[{"$f":"ROW()","v":55},null,"Cash flow timing - expenditure  - days from year end",null,null,182]
[{"$f":"ROW()","v":56},null,"Explanation and evidence if airport assumption is different from default"]
[{"$f":"ROW()","v":57}]
[{"$f":"ROW()","v":58},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Page 7"]
[]
[]
[null,null,null,null,null,null,null,"Regulated Airport",{"$f":"IF(NOT(ISBLANK('Pricing CoverSheet'!$C$8)),'Pricing CoverSheet'!$C$8,\"\")","v":"Airport Company"}]
[null,null,null,null,null,null,null,"Pricing Period Starting Year Ended",{"$f":"IF(ISNUMBER('Pricing CoverSheet'!$C$12),'Pricing CoverSheet'!$C$12,\"\")","v":"2018-06-30"}]
["SCHEDULE 19: REPORT ON THE FORECAST PRICING ASSET BASE REVENUE REQUIREMENTS (cont 2)"]
["ref","Version 3.0"]
[{"$f":"ROW()","v":65},"19(v): Total Revenue Requirement for Pricing Assets"]
[{"$f":"ROW()","v":66},null,"Overview of the methodology used to determine the revenue requirement for pricing assets"]
[{"$f":"ROW()","v":67}]
[{"$f":"ROW()","v":68}]
[{"$f":"ROW()","v":69}]
[{"$f":"ROW()","v":70}]
[{"$f":"ROW()","v":71}]
[{"$f":"ROW()","v":72}]
[{"$f":"ROW()","v":73}]
[{"$f":"ROW()","v":74}]
[{"$f":"ROW()","v":75},null,"($000)",null,null,"Pricing Period Starting Year","Pricing Period Starting Year + 1","Pricing Period Starting Year + 2","Pricing Period Starting Year + 3","Pricing Period Starting Year + 4"]
[{"$f":"ROW()","v":76},null,null,null,null,{"$f":"IF(ISNUMBER('Pricing CoverSheet'!$C$12),DATE(YEAR('Pricing CoverSheet'!$C$12),MONTH('Pricing CoverSheet'!$C$12),DAY('Pricing CoverSheet'!$C$12)),\"\")","v":"2018-06-30"},{"$f":"IF(ISNUMBER('Pricing CoverSheet'!$C$12),DATE(YEAR('Pricing CoverSheet'!$C$12)+1,MONTH('Pricing CoverSheet'!$C$12),DAY('Pricing CoverSheet'!$C$12)),\"\")","v":"2019-06-30"},{"$f":"IF(ISNUMBER('Pricing CoverSheet'!$C$12),DATE(YEAR('Pricing CoverSheet'!$C$12)+2,MONTH('Pricing CoverSheet'!$C$12),DAY('Pricing CoverSheet'!$C$12)),\"\")","v":"2020-06-30"},{"$f":"IF(ISNUMBER('Pricing CoverSheet'!$C$12),DATE(YEAR('Pricing CoverSheet'!$C$12)+3,MONTH('Pricing CoverSheet'!$C$12),DAY('Pricing CoverSheet'!$C$12)),\"\")","v":"2021-06-30"},{"$f":"IF(ISNUMBER('Pricing CoverSheet'!$C$12),DATE(YEAR('Pricing CoverSheet'!$C$12)+4,MONTH('Pricing CoverSheet'!$C$12),DAY('Pricing CoverSheet'!$C$12)),\"\")","v":"2022-06-30"}]
[{"$f":"ROW()","v":77},null,"Forecast revenue from airport activity charges applicable to the price setting event"]
[null,null,"Forecast lease, rental and concession income (applicable to the price setting event)"]
[{"$f":"ROW()","v":79},"plus","Forecast other operating revenue (applicable to the price setting event)"]
[{"$f":"ROW()","v":80},null,"Forecast pricing revenue for services applicable to the price setting event pricing revenue requirement (excluding assets held for future use revenue)",null,null,{"$f":"SUM(F77:F79)","v":0},{"$f":"SUM(G77:G79)","v":0},{"$f":"SUM(H77:H79)","v":0},{"$f":"SUM(I77:I79)","v":0},{"$f":"SUM(J77:J79)","v":0}]
[{"$f":"ROW()","v":81}]
[{"$f":"ROW()","v":82},"less","Forecast operational expenditure "]
[{"$f":"ROW()","v":83},"less","Forecast depreciation",null,null,{"$f":"F133","v":0},{"$f":"G133","v":0},{"$f":"H133","v":0},{"$f":"I133","v":0},{"$f":"J133","v":0}]
[{"$f":"ROW()","v":84},"less","Forecast unlevered tax"]
[{"$f":"ROW()","v":85},"plus","Forecast revaluations",null,null,{"$f":"-F134","v":0},{"$f":"-G134","v":0},{"$f":"-H134","v":0},{"$f":"-I134","v":0},{"$f":"-J134","v":0}]
[{"$f":"ROW()","v":86}]
[{"$f":"ROW()","v":87},null,"Forecast regulatory profit / (loss)",null,null,{"$f":"F80-F82-F83-F84+F85","v":0},{"$f":"G80-G82-G83-G84+G85","v":0},{"$f":"H80-H82-H83-H84+H85","v":0},{"$f":"I80-I82-I83-I84+I85","v":0},{"$f":"J80-J82-J83-J84+J85","v":0}]
[{"$f":"ROW()","v":88}]
[{"$f":"ROW()","v":89},null,"Forecast regulatory investment value",null,null,{"$f":"F132+0.5*(F135-F136)","v":0},{"$f":"G132+0.5*(G135-G136)","v":0},{"$f":"H132+0.5*(H135-H136)","v":0},{"$f":"I132+0.5*(I135-I136)","v":0},{"$f":"J132+0.5*(J135-J136)","v":0}]
[{"$f":"ROW()","v":90}]
[{"$f":"ROW()","v":91},null,"ROI - comparable to a post tax WACC",null,null,{"$f":"IFERROR(\"\",F87/F89)","v":""},{"$f":"IFERROR(\"\",G87/G89)","v":""},"","",""]
[{"$f":"ROW()","v":92}]
[{"$f":"ROW()","v":93},null,"Forecast cost of capital"]
[{"$f":"ROW()","v":94}]
[{"$f":"ROW()","v":95},null,"Explain any difference between the post-tax IRR on the pricing asset base and the post-tax IRR on the regulated asset base"]
[{"$f":"ROW()","v":96}]
[{"$f":"ROW()","v":97}]
[{"$f":"ROW()","v":98}]
[{"$f":"ROW()","v":99},null,"Forecast pricing revenue requirement from airport charges (including assets held for future use charges)"]
[{"$f":"ROW()","v":100},null,"Forecast pricing revenue requirement (excluding forecast revenue from assets held for future use revenues)",null,null,{"$f":"F77","v":0},{"$f":"G77","v":0},{"$f":"H77","v":0},{"$f":"I77","v":0},{"$f":"J77","v":0}]
[{"$f":"ROW()","v":101},null,"Forecast revenues from assets held for future use charges "]
[{"$f":"ROW()","v":102},null,"Forecast pricing revenue requirement from airport charges (including forecast revenue from assets held for future use charges)",null,null,{"$f":"F100+F101","v":0},{"$f":"G100+G101","v":0},{"$f":"H100+H101","v":0},{"$f":"I100+I101","v":0},{"$f":"J100+J101","v":0}]
[{"$f":"ROW()","v":103},null,"Description of any other factors that are considered in determining the forecast total revenue requirement"]
[{"$f":"ROW()","v":104}]
[{"$f":"ROW()","v":105}]
[{"$f":"ROW()","v":106}]
[{"$f":"ROW()","v":107}]
[{"$f":"ROW()","v":108}]
[{"$f":"ROW()","v":109}]
[{"$f":"ROW()","v":110}]
[{"$f":"ROW()","v":111}]
[{"$f":"ROW()","v":112},null,null,null,null,null,null,null,null,null,null,"Page 8"]
[]
[]
[null,null,null,null,null,null,"Regulated Airport",{"$f":"IF(NOT(ISBLANK('Pricing CoverSheet'!$C$8)),'Pricing CoverSheet'!$C$8,\"\")","v":"Airport Company"}]
[null,null,null,null,null,null,"Pricing Period Starting Year Ended",{"$f":"IF(ISNUMBER('Pricing CoverSheet'!$C$12),'Pricing CoverSheet'!$C$12,\"\")","v":"2018-06-30"}]
["SCHEDULE 19: REPORT ON THE FORECAST PRICING ASSET BASE REVENUE REQUIREMENTS (cont 3)"]
["ref","Version 3.0"]
[null,null,"($000)"]
[{"$f":"ROW()","v":120},"19(vi): Opening Regulated Asset Base (applicable to price setting)"]
[{"$f":"ROW()","v":121},null,null,null,{"$f":"E52-1","v":"2017-06-30"}]
[{"$f":"ROW()","v":122},null,{"$f":"\"Regulated asset base (applicable to price setting) as at \"&TEXT(E51,\"dd mmmm yyy\")","v":"Regulated asset base (applicable to price setting) as at 30 June 2016"}]
[{"$f":"ROW()","v":123},"less","Forecast depreciation"]
[{"$f":"ROW()","v":124},"plus","Forecast revaluations"]
[{"$f":"ROW()","v":125},"plus","Assets commissioned"]
[{"$f":"ROW()","v":126},"less ","Asset disposals"]
[{"$f":"ROW()","v":127},"plus (less)","Forecast adjustment resulting from cost allocation"]
[{"$f":"ROW()","v":128},null,"Estimate of regulated asset base (applicable to price setting) at start of price setting event",null,{"$f":"E122-E123+E124+E125-E126+E127","v":0}]
[{"$f":"ROW()","v":129},null,null,null,"Pricing Period Starting Year - 1","Pricing Period Starting Year","Pricing Period Starting Year + 1","Pricing Period Starting Year + 2","Pricing Period Starting Year + 3","Pricing Period Starting Year + 4"]
[{"$f":"ROW()","v":130},null,{"$f":"IF(ISNUMBER('Pricing CoverSheet'!$C$12),\"for year ended\",\"\")","v":"for year ended"},null,{"$f":"EOMONTH(F130,-12)","v":"2017-06-30"},{"$f":"IF(ISNUMBER('Pricing CoverSheet'!$C$12),DATE(YEAR('Pricing CoverSheet'!$C$12),MONTH('Pricing CoverSheet'!$C$12),DAY('Pricing CoverSheet'!$C$12)),\"\")","v":"2018-06-30"},{"$f":"IF(ISNUMBER('Pricing CoverSheet'!$C$12),DATE(YEAR('Pricing CoverSheet'!$C$12)+1,MONTH('Pricing CoverSheet'!$C$12),DAY('Pricing CoverSheet'!$C$12)),\"\")","v":"2019-06-30"},{"$f":"IF(ISNUMBER('Pricing CoverSheet'!$C$12),DATE(YEAR('Pricing CoverSheet'!$C$12)+2,MONTH('Pricing CoverSheet'!$C$12),DAY('Pricing CoverSheet'!$C$12)),\"\")","v":"2020-06-30"},{"$f":"IF(ISNUMBER('Pricing CoverSheet'!$C$12),DATE(YEAR('Pricing CoverSheet'!$C$12)+3,MONTH('Pricing CoverSheet'!$C$12),DAY('Pricing CoverSheet'!$C$12)),\"\")","v":"2021-06-30"},{"$f":"IF(ISNUMBER('Pricing CoverSheet'!$C$12),DATE(YEAR('Pricing CoverSheet'!$C$12)+4,MONTH('Pricing CoverSheet'!$C$12),DAY('Pricing CoverSheet'!$C$12)),\"\")","v":"2022-06-30"}]
[{"$f":"ROW()","v":131},"19(vii): Forecast Asset Base (applicable to price setting)"]
[{"$f":"ROW()","v":132},null,"Forecast pricing asset base—previous year",null,null,{"$f":"E138","v":0},{"$f":"F138","v":0},{"$f":"G138","v":0},{"$f":"H138","v":0},{"$f":"I138","v":0}]
[{"$f":"ROW()","v":133},"less","Forecast depreciation"]
[{"$f":"ROW()","v":134},"plus","Forecast revaluations"]
[{"$f":"ROW()","v":135},"plus","Assets commissioned"]
[{"$f":"ROW()","v":136},"less ","Asset disposals"]
[{"$f":"ROW()","v":137},"plus (less)","Forecast adjustment resulting from cost allocation"]
[{"$f":"ROW()","v":138},null,"Forecast pricing asset base",null,{"$f":"E132-E133+E134+E135-E136+E137","v":0},0,0,0,0,0]
[{"$f":"ROW()","v":139}]
[{"$f":"ROW()","v":140},null,"Description of and explanation for the depreciation methodology applied"]
[{"$f":"ROW()","v":141}]
[{"$f":"ROW()","v":142}]
[{"$f":"ROW()","v":143}]
[{"$f":"ROW()","v":144}]
[null,null,null,null,null,null,null,null,null,null,"Page 9"]

{"sheet":"S20.Demand Forecast","index":5,"n_rows":72,"n_cols":25,"rows_kept":72,"cut":false,"hidden":false,"merged":[[29,17,29,23],[16,3,18,3],[20,3,22,3],[16,2,22,2],[23,2,24,2],[1,17,1,23],[2,17,2,23],[8,2,14,2],[8,3,10,3],[12,3,14,3],[49,2,51,2],[44,2,47,2],[39,2,42,2],[57,2,70,23],[30,17,30,23],[36,2,38,2],[53,2,55,2]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Regulated Airport",{"$f":"IF(NOT(ISBLANK('Pricing CoverSheet'!$C$8)),'Pricing CoverSheet'!$C$8,\"\")","v":"Airport Company"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pricing Period Starting Year Ended",{"$f":"IF(ISNUMBER('Pricing CoverSheet'!$C$12),'Pricing CoverSheet'!$C$12,\"\")","v":"2018-06-30"}]
["SCHEDULE 20: REPORT ON DEMAND FORECASTS"]
["ref","Version 3.0"]
[{"$f":"ROW()","v":6},"20a: Passenger terminal demand"]
[{"$f":"ROW()","v":7},null,null,"(000)",null,"Pricing Period Starting Year",null,"Pricing Period Starting Year + 1",null,"Pricing Period Starting Year + 2",null,"Pricing Period Starting Year + 3",null,"Pricing Period Starting Year + 4",null,"Pricing Period Starting Year + 5",null,"Pricing Period Starting Year + 6",null,"Pricing Period Starting Year + 7",null,"Pricing Period Starting Year + 8",null,"Pricing Period Starting Year + 9"]
[{"$f":"ROW()","v":8},null,null,null,{"$f":"IF(ISNUMBER('Pricing CoverSheet'!$C$12),\"for year ended\",\"\")","v":"for year ended"},{"$f":"IF(ISNUMBER('Pricing CoverSheet'!$C$12),DATE(YEAR('Pricing CoverSheet'!$C$12),MONTH('Pricing CoverSheet'!$C$12),DAY('Pricing CoverSheet'!$C$12)),\"\")","v":"2018-06-30"},null,{"$f":"IF(ISNUMBER('Pricing CoverSheet'!$C$12),DATE(YEAR('Pricing CoverSheet'!$C$12)+1,MONTH('Pricing CoverSheet'!$C$12),DAY('Pricing CoverSheet'!$C$12)),\"\")","v":"2019-06-30"},null,{"$f":"IF(ISNUMBER('Pricing CoverSheet'!$C$12),DATE(YEAR('Pricing CoverSheet'!$C$12)+2,MONTH('Pricing CoverSheet'!$C$12),DAY('Pricing CoverSheet'!$C$12)),\"\")","v":"2020-06-30"},null,{"$f":"IF(ISNUMBER('Pricing CoverSheet'!$C$12),DATE(YEAR('Pricing CoverSheet'!$C$12)+3,MONTH('Pricing CoverSheet'!$C$12),DAY('Pricing CoverSheet'!$C$12)),\"\")","v":"2021-06-30"},null,{"$f":"IF(ISNUMBER('Pricing CoverSheet'!$C$12),DATE(YEAR('Pricing CoverSheet'!$C$12)+4,MONTH('Pricing CoverSheet'!$C$12),DAY('Pricing CoverSheet'!$C$12)),\"\")","v":"2022-06-30"},null,{"$f":"IF(ISNUMBER('Pricing CoverSheet'!$C$12),DATE(YEAR('Pricing CoverSheet'!$C$12)+5,MONTH('Pricing CoverSheet'!$C$12),DAY('Pricing CoverSheet'!$C$12)),\"\")","v":"2023-06-30"},null,{"$f":"IF(ISNUMBER('Pricing CoverSheet'!$C$12),DATE(YEAR('Pricing CoverSheet'!$C$12)+6,MONTH('Pricing CoverSheet'!$C$12),DAY('Pricing CoverSheet'!$C$12)),\"\")","v":"2024-06-30"},null,{"$f":"IF(ISNUMBER('Pricing CoverSheet'!$C$12),DATE(YEAR('Pricing CoverSheet'!$C$12)+7,MONTH('Pricing CoverSheet'!$C$12),DAY('Pricing CoverSheet'!$C$12)),\"\")","v":"2025-06-30"},null,{"$f":"IF(ISNUMBER('Pricing CoverSheet'!$C$12),DATE(YEAR('Pricing CoverSheet'!$C$12)+8,MONTH('Pricing CoverSheet'!$C$12),DAY('Pricing CoverSheet'!$C$12)),\"\")","v":"2026-06-30"},null,{"$f":"IF(ISNUMBER('Pricing CoverSheet'!$C$12),DATE(YEAR('Pricing CoverSheet'!$C$12)+9,MONTH('Pricing CoverSheet'!$C$12),DAY('Pricing CoverSheet'!$C$12)),\"\")","v":"2027-06-30"}]
[{"$f":"ROW()","v":9},null,"Busy hour passenger numbers","Inbound passengers","Domestic"]
[{"$f":"ROW()","v":10},null,null,null,"International"]
[{"$f":"ROW()","v":11},null,null,null,"Combined *"]
[{"$f":"ROW()","v":12}]
[{"$f":"ROW()","v":13},null,null,"Outbound passengers","Domestic"]
[{"$f":"ROW()","v":14},null,null,null,"International"]
[{"$f":"ROW()","v":15},null,null,null,"Combined *"]
[{"$f":"ROW()","v":16},null,null,null,null,"* No disclosure of combined terminal forecasts is required for airports with no shared passenger terminal functional components."]
[{"$f":"ROW()","v":17},null,"Number of passengers during year","Inbound passengers","Domestic"]
[{"$f":"ROW()","v":18},null,null,null,"International"]
[{"$f":"ROW()","v":19},null,null,null,"Total",{"$f":"SUM(F17:F18)","v":0},null,{"$f":"SUM(H17:H18)","v":0},null,{"$f":"SUM(J17:J18)","v":0},null,{"$f":"SUM(L17:L18)","v":0},null,{"$f":"SUM(N17:N18)","v":0},null,{"$f":"SUM(P17:P18)","v":0},null,{"$f":"SUM(R17:R18)","v":0},null,{"$f":"SUM(T17:T18)","v":0},null,{"$f":"SUM(V17:V18)","v":0},null,{"$f":"SUM(X17:X18)","v":0}]
[{"$f":"ROW()","v":20}]
[{"$f":"ROW()","v":21},null,null,"Outbound passengers","Domestic"]
[{"$f":"ROW()","v":22},null,null,null,"International"]
[{"$f":"ROW()","v":23},null,null,null,"Total",{"$f":"SUM(F21:F22)","v":0},null,{"$f":"SUM(H21:H22)","v":0},null,{"$f":"SUM(J21:J22)","v":0},null,{"$f":"SUM(L21:L22)","v":0},null,{"$f":"SUM(N21:N22)","v":0},null,{"$f":"SUM(P21:P22)","v":0},null,{"$f":"SUM(R21:R22)","v":0},null,{"$f":"SUM(T21:T22)","v":0},null,{"$f":"SUM(V21:V22)","v":0},null,{"$f":"SUM(X21:X22)","v":0}]
[{"$f":"ROW()","v":24}]
[{"$f":"ROW()","v":25},null,null,"International transit and transfer passengers†"]
[{"$f":"ROW()","v":26},null,null,null,null,"† NB. Forecasts of international transit and transfer passenger numbers relate only to airports with extant or planned international transit and transfer facilities"]
[{"$f":"ROW()","v":27},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Page 10"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Regulated Airport",{"$f":"IF(NOT(ISBLANK('Pricing CoverSheet'!$C$8)),'Pricing CoverSheet'!$C$8,\"\")","v":"Airport Company"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pricing Period Starting Year Ended",{"$f":"IF(ISNUMBER('Pricing CoverSheet'!$C$12),'Pricing CoverSheet'!$C$12,\"\")","v":"2018-06-30"}]
["SCHEDULE 20: REPORT ON DEMAND FORECASTS (cont)"]
["ref","Version 3.0"]
[{"$f":"ROW()","v":34},"20b: Aircraft Runway Movements"]
[{"$f":"ROW()","v":35},null,null,"(000)",null,"Pricing Period Starting Year",null,"Pricing Period Starting Year + 1",null,"Pricing Period Starting Year + 2",null,"Pricing Period Starting Year + 3",null,"Pricing Period Starting Year + 4",null,"Pricing Period Starting Year + 5",null,"Pricing Period Starting Year + 6",null,"Pricing Period Starting Year + 7",null,"Pricing Period Starting Year + 8",null,"Pricing Period Starting Year + 9"]
[{"$f":"ROW()","v":36},null,null,null,{"$f":"IF(ISNUMBER('Pricing CoverSheet'!$C$12),\"for year ended\",\"\")","v":"for year ended"},{"$f":"IF(ISNUMBER('Pricing CoverSheet'!$C$12),DATE(YEAR('Pricing CoverSheet'!$C$12),MONTH('Pricing CoverSheet'!$C$12),DAY('Pricing CoverSheet'!$C$12)),\"\")","v":"2018-06-30"},null,{"$f":"IF(ISNUMBER('Pricing CoverSheet'!$C$12),DATE(YEAR('Pricing CoverSheet'!$C$12)+1,MONTH('Pricing CoverSheet'!$C$12),DAY('Pricing CoverSheet'!$C$12)),\"\")","v":"2019-06-30"},null,{"$f":"IF(ISNUMBER('Pricing CoverSheet'!$C$12),DATE(YEAR('Pricing CoverSheet'!$C$12)+2,MONTH('Pricing CoverSheet'!$C$12),DAY('Pricing CoverSheet'!$C$12)),\"\")","v":"2020-06-30"},null,{"$f":"IF(ISNUMBER('Pricing CoverSheet'!$C$12),DATE(YEAR('Pricing CoverSheet'!$C$12)+3,MONTH('Pricing CoverSheet'!$C$12),DAY('Pricing CoverSheet'!$C$12)),\"\")","v":"2021-06-30"},null,{"$f":"IF(ISNUMBER('Pricing CoverSheet'!$C$12),DATE(YEAR('Pricing CoverSheet'!$C$12)+4,MONTH('Pricing CoverSheet'!$C$12),DAY('Pricing CoverSheet'!$C$12)),\"\")","v":"2022-06-30"},null,{"$f":"IF(ISNUMBER('Pricing CoverSheet'!$C$12),DATE(YEAR('Pricing CoverSheet'!$C$12)+5,MONTH('Pricing CoverSheet'!$C$12),DAY('Pricing CoverSheet'!$C$12)),\"\")","v":"2023-06-30"},null,{"$f":"IF(ISNUMBER('Pricing CoverSheet'!$C$12),DATE(YEAR('Pricing CoverSheet'!$C$12)+6,MONTH('Pricing CoverSheet'!$C$12),DAY('Pricing CoverSheet'!$C$12)),\"\")","v":"2024-06-30"},null,{"$f":"IF(ISNUMBER('Pricing CoverSheet'!$C$12),DATE(YEAR('Pricing CoverSheet'!$C$12)+7,MONTH('Pricing CoverSheet'!$C$12),DAY('Pricing CoverSheet'!$C$12)),\"\")","v":"2025-06-30"},null,{"$f":"IF(ISNUMBER('Pricing CoverSheet'!$C$12),DATE(YEAR('Pricing CoverSheet'!$C$12)+8,MONTH('Pricing CoverSheet'!$C$12),DAY('Pricing CoverSheet'!$C$12)),\"\")","v":"2026-06-30"},null,{"$f":"IF(ISNUMBER('Pricing CoverSheet'!$C$12),DATE(YEAR('Pricing CoverSheet'!$C$12)+9,MONTH('Pricing CoverSheet'!$C$12),DAY('Pricing CoverSheet'!$C$12)),\"\")","v":"2027-06-30"}]
[{"$f":"ROW()","v":37},null,"Movements during\nbusy period (total\nnumber of aircraft)","During the runway busy hour"]
[{"$f":"ROW()","v":38},null,null,"During the runway busy day"]
[{"$f":"ROW()","v":39}]
[{"$f":"ROW()","v":40},null,"Landings during year (total number of\naircraft)","Aircraft 30 tonnes MCTOW or more"]
[{"$f":"ROW()","v":41},null,null,"Aircraft 3 tonnes or more but less than 30 tonnes MCTOW"]
[{"$f":"ROW()","v":42},null,null,"Aircraft less than 3 tonnes MCTOW"]
[{"$f":"ROW()","v":43},null,null,"Total",null,{"$f":"SUM(F40:F42)","v":0},null,{"$f":"SUM(H40:H42)","v":0},null,{"$f":"SUM(J40:J42)","v":0},null,{"$f":"SUM(L40:L42)","v":0},null,{"$f":"SUM(N40:N42)","v":0},null,{"$f":"SUM(P40:P42)","v":0},null,{"$f":"SUM(R40:R42)","v":0},null,{"$f":"SUM(T40:T42)","v":0},null,{"$f":"SUM(V40:V42)","v":0},null,{"$f":"SUM(X40:X42)","v":0}]
[{"$f":"ROW()","v":44}]
[{"$f":"ROW()","v":45},null,"Landings during year (total MCTOW in tonnes)","Aircraft 30 tonnes MCTOW or more"]
[{"$f":"ROW()","v":46},null,null,"Aircraft 3 tonnes or more but less than 30 tonnes MCTOW"]
[{"$f":"ROW()","v":47},null,null,"Aircraft less than 3 tonnes MCTOW"]
[{"$f":"ROW()","v":48},null,null,"Total",null,{"$f":"SUM(F45:F47)","v":0},null,{"$f":"SUM(H45:H47)","v":0},null,{"$f":"SUM(J45:J47)","v":0},null,{"$f":"SUM(L45:L47)","v":0},null,{"$f":"SUM(N45:N47)","v":0},null,{"$f":"SUM(P45:P47)","v":0},null,{"$f":"SUM(R45:R47)","v":0},null,{"$f":"SUM(T45:T47)","v":0},null,{"$f":"SUM(V45:V47)","v":0},null,{"$f":"SUM(X45:X47)","v":0}]
[{"$f":"ROW()","v":49}]
[{"$f":"ROW()","v":50},null,"Landings during year (total number of\naircraft)","Air passenger services—international"]
[{"$f":"ROW()","v":51},null,null,"Air passenger services—domestic"]
[{"$f":"ROW()","v":52},null,null,"Other aircraft"]
[{"$f":"ROW()","v":53}]
[{"$f":"ROW()","v":54},null,"Landings during year (total MCTOW in tonnes)","Air passenger services—international"]
[{"$f":"ROW()","v":55},null,null,"Air passenger services—domestic"]
[{"$f":"ROW()","v":56},null,null,"Other aircraft"]
[{"$f":"ROW()","v":57},null,"Description of the basis for forecasts, and/or assumptions made in forecasting "]
[{"$f":"ROW()","v":58}]
[{"$f":"ROW()","v":59}]
[{"$f":"ROW()","v":60}]
[{"$f":"ROW()","v":61}]
[{"$f":"ROW()","v":62}]
[{"$f":"ROW()","v":63}]
[{"$f":"ROW()","v":64}]
[{"$f":"ROW()","v":65}]
[{"$f":"ROW()","v":66}]
[{"$f":"ROW()","v":67}]
[{"$f":"ROW()","v":68}]
[{"$f":"ROW()","v":69}]
[{"$f":"ROW()","v":70}]
[{"$f":"ROW()","v":71}]
[{"$f":"ROW()","v":72},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Page 11"]

{"sheet":"S24.Transitional RAB","index":6,"n_rows":50,"n_cols":14,"rows_kept":50,"cut":false,"hidden":false,"merged":[[49,5,49,13],[48,3,48,13],[47,3,47,13],[1,9,1,13],[2,9,2,13],[45,5,45,13]]}
[]
[null,null,null,null,null,null,null,null,"Regulated Airport",{"$f":"IF(NOT(ISBLANK('Pricing CoverSheet'!C8)),'Pricing CoverSheet'!C8,\"\")","v":"Airport Company"}]
[null,null,null,null,null,null,null,null,"For Year Ended",{"$f":"IF(ISNUMBER('Pricing CoverSheet'!C12),'Pricing CoverSheet'!C12,\"\")","v":"2018-06-30"}]
["SCHEDULE 24: TRANSITIONAL REPORT ON REGULATORY ASSET BASE VALUE"]
["ref","Version 3.0"]
[{"$f":"ROW()","v":6}]
[{"$f":"ROW()","v":7},null,"24(i): Regulatory Asset Base Value (Rolled Forward)",null,null,null,null,null,null,"RAB","RAB","RAB","RAB","RAB"]
[{"$f":"ROW()","v":8},null,null,null,null,null,null,"For year ended",null,{"$f":"IF(ISNUMBER('Pricing CoverSheet'!C12),DATE(YEAR('Pricing CoverSheet'!C12)-5,MONTH('Pricing CoverSheet'!C12),DAY('Pricing CoverSheet'!C12)),\"CY-4\")","v":"2013-06-30"},{"$f":"IF(ISNUMBER('Pricing CoverSheet'!C12),DATE(YEAR('Pricing CoverSheet'!C12)-4,MONTH('Pricing CoverSheet'!C12),DAY('Pricing CoverSheet'!C12)),\"CY-3\")","v":"2014-06-30"},{"$f":"IF(ISNUMBER('Pricing CoverSheet'!C12),DATE(YEAR('Pricing CoverSheet'!C12)-3,MONTH('Pricing CoverSheet'!C12),DAY('Pricing CoverSheet'!C12)),\"CY-2\")","v":"2015-06-30"},{"$f":"IF(ISNUMBER('Pricing CoverSheet'!C12),DATE(YEAR('Pricing CoverSheet'!C12)-2,MONTH('Pricing CoverSheet'!C12),DAY('Pricing CoverSheet'!C12)),\"CY-1\")","v":"2016-06-30"},{"$f":"IF(ISNUMBER('Pricing CoverSheet'!C12),DATE(YEAR('Pricing CoverSheet'!C12)-1,MONTH('Pricing CoverSheet'!C12),DAY('Pricing CoverSheet'!C12)),\"CY\")","v":"2017-06-30"}]
[{"$f":"ROW()","v":9},null,null,null,null,null,null,null,null,"($000)","($000)","($000)","($000)","($000)"]
[{"$f":"ROW()","v":10},null,null,null,"Total opening RAB value"]
[{"$f":"ROW()","v":11}]
[{"$f":"ROW()","v":12},null,null,"less","Total depreciation"]
[{"$f":"ROW()","v":13}]
[{"$f":"ROW()","v":14},null,null,"plus","Total revaluations"]
[{"$f":"ROW()","v":15}]
[{"$f":"ROW()","v":16},null,null,"plus","Assets commissioned  "]
[{"$f":"ROW()","v":17}]
[{"$f":"ROW()","v":18},null,null,"less","Asset disposals"]
[{"$f":"ROW()","v":19}]
[{"$f":"ROW()","v":20},null,null,"plus","Lost and found assets adjustment"]
[{"$f":"ROW()","v":21}]
[{"$f":"ROW()","v":22},null,null,"plus","Adjustment resulting from asset allocation"]
[{"$f":"ROW()","v":23}]
[{"$f":"ROW()","v":24},null,null,null,"Total closing RAB value ",null,null,null,null,{"$f":"J10-J12+J14+J16-J18+J20+J22","v":0},{"$f":"K10-K12+K14+K16-K18+K20+K22","v":0},{"$f":"L10-L12+L14+L16-L18+L20+L22","v":0},{"$f":"M10-M12+M14+M16-M18+M20+M22","v":0},{"$f":"N10-N12+N14+N16-N18+N20+N22","v":0}]
[{"$f":"ROW()","v":25}]
[{"$f":"ROW()","v":26}]
[{"$f":"ROW()","v":27},null,"24(ii): Asset Classes"]
[{"$f":"ROW()","v":28},null,null,null,null,null,null,null,null,"Land","Sealed Surfaces","Infrastructure & Buildings","Vehicles, Plant & Equipment","Total *"]
[{"$f":"ROW()","v":29},null,null,null,"RAB value—previous disclosure year",null,null,null,null,null,null,null,null,{"$f":"SUM(J29:M29)","v":0}]
[{"$f":"ROW()","v":30},null,null,"less",null,"Regulatory depreciation",null,null,null,null,null,null,null,0]
[{"$f":"ROW()","v":31},null,null,"plus",null,"Indexed revaluations",null,null,null,null,null,null,null,0]
[{"$f":"ROW()","v":32},null,null,"plus",null,"Periodic land revaluations",null,null,null,null,null,null,null,0]
[{"$f":"ROW()","v":33},null,null,"plus",null,"Assets commissioned",null,null,null,null,null,null,null,0]
[{"$f":"ROW()","v":34},null,null,"less",null,"Asset disposals",null,null,null,null,null,null,null,0]
[{"$f":"ROW()","v":35},null,null,"plus",null,"Lost and found assets adjustment",null,null,null,null,null,null,null,0]
[{"$f":"ROW()","v":36},null,null,"plus",null,"Adjustment resulting from cost allocation",null,null,null,null,null,null,null,0]
[{"$f":"ROW()","v":37},null,null,null,"RAB value",null,null,null,null,{"$f":"J29-J30+J31+J32+J33-J34+J35+J36","v":0},{"$f":"K29-K30+K31+K33-K34+K35+K36","v":0},{"$f":"L29-L30+L31+L33-L34+L35+L36","v":0},{"$f":"M29-M30+M31+M33-M34+M35+M36","v":0},{"$f":"N29-N30+N31+N32+N33-N34+N35+N36","v":0}]
[{"$f":"ROW()","v":38},null,null,null,null,null,null,null,null,"* Corresponds to values in RAB roll forward calculation."]
[{"$f":"ROW()","v":39},null,"24(iii): Assets Held for Future Use"]
[{"$f":"ROW()","v":40},null,null,null,null,null,null,null,null,"Base Value","Holding Costs","Net Revenues","Tracking Revaluations","Total"]
[{"$f":"ROW()","v":41},null,null,null,null,"Assets held for future use—previous disclosure year",null,null,null,null,null,null,null,{"$f":"J41+K41-L41+M41","v":0}]
[{"$f":"ROW()","v":42},null,null,"plus",null,"Assets held for future use—additions¹",null,null,null,null,null,null,null,{"$f":"J42+K42-L42+M42","v":0}]
[{"$f":"ROW()","v":43},null,null,"less",null,"Transfer to works under construction",null,null,null,null,null,null,null,{"$f":"J43+K43-L43+M43","v":0}]
[{"$f":"ROW()","v":44},null,null,"less",null,"Assets held for future use—disposals",null,null,null,null,null,null,null,{"$f":"J44+K44-L44+M44","v":0}]
[{"$f":"ROW()","v":45},null,null,null,null,"Assets held for future use²",null,null,null,{"$f":"J41+J42-J43-J44","v":0},{"$f":"K41+K42-K43-K44","v":0},{"$f":"L41+L42-L43-L44","v":0},{"$f":"M41+M42-M43-M44","v":0},{"$f":"N41+N42-N43-N44","v":0}]
[{"$f":"ROW()","v":46},null,null,null,null,"1  Each category value shown in the 'Assets held for future use' line (Base Value, Holding Costs, Net Revenues, and Tracking Revaluations) is carried forward into the following year's disclosure as 'Assets held for future use—previous disclosure year' ."]
[{"$f":"ROW()","v":47},null,"24(iv) Alternative methodologies with equivalent effect"]
[{"$f":"ROW()","v":48},null,null,"Description of and explanation for any alternative methodologies with equivalent effect that have been applied and which components they have been applied to (including evidence to support that it is likely to have equivalent effect)"]
[{"$f":"ROW()","v":49}]
[{"$f":"ROW()","v":50}]