{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Sched 18","Sched 19","S20. Demand Forecast"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":2,"defined_names":713,"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":"Sched 18","index":0,"n_rows":312,"n_cols":29,"rows_kept":312,"cut":false,"hidden":false,"merged":[[40,8,40,15],[39,8,39,11],[1,12,1,15],[2,12,2,15],[5,5,5,6],[5,7,5,8],[5,9,5,10],[5,11,5,12],[5,13,5,14],[6,5,6,6],[6,7,6,8],[6,9,6,10],[6,11,6,12],[6,13,6,14],[41,8,41,15],[42,8,42,15],[45,2,47,15],[49,6,49,11],[50,6,50,15],[51,6,51,15],[52,6,52,15],[53,6,53,15],[55,2,55,15],[56,2,58,15],[188,11,188,14],[62,8,62,10],[63,8,63,10],[114,2,121,9],[125,7,125,9],[126,7,126,9],[151,2,153,9],[159,2,159,8],[181,2,183,9],[187,11,187,14],[106,2,108,11],[74,2,74,11],[77,2,84,11],[272,6,272,9],[273,6,273,9],[302,2,302,9],[303,2,310,9],[227,6,227,9],[228,6,228,9],[232,2,244,9],[245,2,245,9],[247,2,259,9],[260,2,260,9]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,"Regulated Airport","Wellington International Airport Limited"]
[null,null,null,null,null,null,null,null,null,null,null,"Pricing Period Starting Year Ended","2020-03-31"]
["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",null,null,"Calculation - Annual IRR "]
[{"$f":"ROW()","v":7},"18(i): Forecast Internal Rate of Return",null,null,null,"2020-03-31",null,{"$f":"+F7+365","v":"2021-03-31"},null,{"$f":"+H7+365","v":"2022-03-31"},null,{"$f":"+J7+365","v":"2023-03-31"},null,{"$f":"+L7+366","v":"2024-03-31"},null,null,null,null,null,{"$f":"G30","v":"2020-03-31"},null,{"$f":"H30","v":"2021-03-31"},null,{"$f":"I30","v":"2022-03-31"},null,{"$f":"J30","v":"2023-03-31"},null,{"$f":"K30","v":"2024-03-31"}]
[{"$f":"ROW()","v":8},null,"($000)","Cash flow date",{"$f":"+E70","v":"2019-04-01"},{"$f":"M3-IF(ISNUMBER(E73),E73,F73)","v":"2019-10-01"},{"$f":"$M$3-IF(ISNUMBER(E72),E72,F72)","v":"2019-11-04"},{"$f":"EOMONTH($M$3,12)-IF(ISNUMBER(E73),E73,F73)","v":"2020-09-30"},{"$f":"EOMONTH($M$3,12)-IF(ISNUMBER(E72),E72,F72)","v":"2020-11-03"},{"$f":"EOMONTH($M$3,24)-IF(ISNUMBER(E73),E73,F73)","v":"2021-09-30"},{"$f":"EOMONTH($M$3,24)-IF(ISNUMBER(E72),E72,F72)","v":"2021-11-03"},{"$f":"EOMONTH($M$3,36)-IF(ISNUMBER(D72),E73,F73)","v":"2022-09-30"},{"$f":"EOMONTH($M$3,36)-IF(ISNUMBER(E72),E72,F72)","v":"2022-11-03"},{"$f":"EOMONTH($M$3,48)-IF(ISNUMBER(K73),E73,F73)","v":"2023-10-01"},{"$f":"EOMONTH($M$3,48)-IF(ISNUMBER(E72),E72,F72)","v":"2023-11-04"},{"$f":"EOMONTH($M$3,48)","v":"2024-03-31"},null,null,null,"Date","Cash flow","Date","Cash flow","Date","Cash flow","Date","Cash flow","Date","Cash flow"]
[{"$f":"ROW()","v":9},null,"Opening RAB",null,{"$f":"E139","v":521871.22057623771},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$E$8","v":"2019-04-01"},{"$f":"$E$23","v":-512646.73937440471},{"$f":"$T$12+1","v":"2020-04-01"},{"$f":"-$U$12","v":-527991.14097489498},{"$f":"$V$12+1","v":"2021-04-01"},{"$f":"-$W$12","v":-542788.30600558221},{"$f":"$X$12+1","v":"2022-04-01"},{"$f":"-$Y$12","v":-571934.89611897198},{"$f":"$Z$12+1","v":"2023-04-01"},{"$f":"-$AA$12","v":-625966.2863803854}]
[{"$f":"ROW()","v":10},null,"Forecast opening carry forward adjustment",null,{"$f":"G44","v":9224.4812018329831},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$F$8","v":"2019-10-01"},{"$f":"$F$23","v":-65320.521621585431},{"$f":"$H$8","v":"2020-09-30"},{"$f":"$H$23","v":-48910.006033801845},{"$f":"$J$8","v":"2021-09-30"},{"$f":"$J$23","v":-73952.013739614733},{"$f":"$L$8","v":"2022-09-30"},{"$f":"$L$23","v":-109194.43241828965},{"$f":"$N$8","v":"2023-10-01"},{"$f":"$N$23","v":-215363.80342738537}]
[{"$f":"ROW()","v":11},null,"Opening investment value",null,{"$f":"E9-E10","v":512646.73937440471},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$G$8","v":"2019-11-04"},{"$f":"$G$23","v":86377.535769873939},{"$f":"$I$8","v":"2020-11-03"},{"$f":"$I$23","v":43845.474973768214},{"$f":"$K$8","v":"2021-11-03"},{"$f":"$K$23","v":70776.327255744007},{"$f":"$M$8","v":"2022-11-03"},{"$f":"$M$23","v":92174.808433709361},{"$f":"$O$8","v":"2023-11-04"},{"$f":"$O$23","v":110091.63524350495}]
[{"$f":"ROW()","v":12},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$T$7","v":"2020-03-31"},{"$f":"$G$34","v":527991.14097489498},{"$f":"$V$7","v":"2021-03-31"},{"$f":"$H$34","v":542788.30600558221},{"$f":"$X$7","v":"2022-03-31"},{"$f":"$I$34","v":571934.89611897198},{"$f":"$Z$7","v":"2023-03-31"},{"$f":"$J$34","v":625966.2863803854},{"$f":"$AB$7","v":"2024-03-31"},{"$f":"$K$34","v":794053.5336562983}]
[{"$f":"ROW()","v":13},"plus","Forecast total revenue requirement",null,null,null,{"$f":"H91","v":86377.535769873939},null,{"$f":"I91","v":43845.474973768214},null,{"$f":"J91","v":70776.327255744007},null,{"$f":"K91","v":92174.808433709361},null,{"$f":"L91","v":110091.63524350495}]
[{"$f":"ROW()","v":14},"less","Forecast assets commissioned",null,null,{"$f":"-F146","v":-25902.180063256816},null,{"$f":"-G146","v":-25673.666464357688},null,{"$f":"-H146","v":-40629.707393890581},null,{"$f":"-I146","v":-65572.572506034572},null,{"$f":"-J146","v":-165238.63358009284}]
[{"$f":"ROW()","v":15},"plus","Forecast cash flow from asset disposals",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Forecast post-tax IRR - annual",null,{"$f":"IFERROR(XIRR(U9:U12,T9:T12,7%),\"\")","v":7.1326878666877758E-2},null,{"$f":"IFERROR(XIRR(W9:W12,V9:V12,7%),\"\")","v":1.8255787491798403E-2},null,{"$f":"IFERROR(XIRR(Y9:Y12,X9:X12,7%),\"\")","v":4.7270570397377018E-2},null,{"$f":"IFERROR(XIRR(AA9:AA12,Z9:Z12,7%),\"\")","v":6.3027080893516538E-2},null,{"$f":"IFERROR(XIRR(AC9:AC12,AB9:AB12,7%),\"\")","v":9.1365137696266169E-2}]
[{"$f":"ROW()","v":16},"less","Forecast operational expenditure ",null,null,{"$f":"-H93","v":-25061.200713939357},null,{"$f":"-I93","v":-19501.37125685994},null,{"$f":"-J93","v":-23414.939753067396},null,{"$f":"-K93","v":-29205.487772716835},null,{"$f":"-L93","v":-32977.661876872691}]
[{"$f":"ROW()","v":17},"less","Forecast unlevered tax",null,null,{"$f":"-H95","v":-14357.140844389254},null,{"$f":"-I95","v":-3734.9683125842221},null,{"$f":"-J95","v":-9907.3665926567501},null,{"$f":"-K95","v":-14416.372139538245},null,{"$f":"-L95","v":-17147.507970419865}]
[{"$f":"ROW()","v":18}]
[{"$f":"ROW()","v":19},null,"Forecast closing asset base",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"J149","v":783565.77425721474},null,null,"Calculation -period to date"]
[{"$f":"ROW()","v":20},null,"Forecast closing carry forward adjustment",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"E55","v":-10487.759399083512},null,null,null,{"$f":"T7","v":"2020-03-31"},null,{"$f":"V7","v":"2021-03-31"},null,{"$f":"X7","v":"2022-03-31"},null,{"$f":"Z7","v":"2023-03-31"},null,{"$f":"AB7","v":"2024-03-31"}]
[{"$f":"ROW()","v":21},null,"Forecast closing investment value",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P19-P20","v":794053.5336562983},null,null,null,"Date","Cash flow","Date","Cash flow","Date","Cash flow","Date","Cash flow","Date","Cash flow"]
[{"$f":"ROW()","v":22},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$E$8","v":"2019-04-01"},{"$f":"$E$23","v":-512646.73937440471},{"$f":"T22","v":"2019-04-01"},-512646.73937440471,"2019-04-01",-512646.73937440471,"2019-04-01",-512646.73937440471,"2019-04-01",-512646.73937440471]
[{"$f":"ROW()","v":23},null,"Forecast net cash flows",null,{"$f":"-E11","v":-512646.73937440471},{"$f":"SUM(F13:F17)","v":-65320.521621585431},{"$f":"SUM(G13:G17)","v":86377.535769873939},-48910.006033801845,43845.474973768214,-73952.013739614733,70776.327255744007,-109194.43241828965,92174.808433709361,-215363.80342738537,110091.63524350495,{"$f":"P21","v":794053.5336562983},null,null,null,{"$f":"$F$8","v":"2019-10-01"},{"$f":"$F$23","v":-65320.521621585431},"2019-10-01",-65320.521621585431,"2019-10-01",-65320.521621585431,"2019-10-01",-65320.521621585431,"2019-10-01",-65320.521621585431]
[{"$f":"ROW()","v":24},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$G$8","v":"2019-11-04"},{"$f":"$G$23","v":86377.535769873939},"2019-11-04",86377.535769873939,"2019-11-04",86377.535769873939,"2019-11-04",86377.535769873939,"2019-11-04",86377.535769873939]
[{"$f":"ROW()","v":25},null,{"$f":"\"Forecast post-tax IRR as at \"&TEXT(E8,\"dd mmmm yyy\")","v":"Forecast post-tax IRR as at 01 April 2019"},null,{"$f":"IFERROR(XIRR(E23:P23,E8:P8),\"\")","v":5.8758202195167544E-2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$T$7","v":"2020-03-31"},{"$f":"$G$34","v":527991.14097489498},{"$f":"H8","v":"2020-09-30"},{"$f":"H23","v":-48910.006033801845},"2020-09-30",{"$f":"W25","v":-48910.006033801845},"2020-09-30",-48910.006033801845,"2020-09-30",-48910.006033801845]
[{"$f":"ROW()","v":26},null,"NPV check",null,{"$f":"IFERROR(XNPV(E25,E23:P23,E8:P8),0)","v":-7.0203823270276189E-3},{"$f":"IF(ABS(E26)<0.01,\"OK\",\"ERROR\")","v":"OK"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"I8","v":"2020-11-03"},{"$f":"I23","v":43845.474973768214},{"$f":"V26","v":"2020-11-03"},{"$f":"W26","v":43845.474973768214},{"$f":"X26","v":"2020-11-03"},{"$f":"Y26","v":43845.474973768214},"2020-11-03",43845.474973768214]
[{"$f":"ROW()","v":27},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"H30","v":"2021-03-31"},{"$f":"H34","v":542788.30600558221},{"$f":"J8","v":"2021-09-30"},{"$f":"J23","v":-73952.013739614733},{"$f":"X27","v":"2021-09-30"},-73952.013739614733,{"$f":"Z27","v":"2021-09-30"},{"$f":"AA27","v":-73952.013739614733}]
[{"$f":"ROW()","v":28},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"K8","v":"2021-11-03"},{"$f":"K23","v":70776.327255744007},"2021-11-03",70776.327255744007,"2021-11-03",70776.327255744007]
[{"$f":"ROW()","v":29},"18(ii): Forecast Internal Rate of Return - Annual and Period to Date",null,null,null,null,"Pricing Period Starting Year","Pricing Period Starting Year \n+ 1","Pricing Period Starting Year \n+ 2","Pricing Period Starting Year \n+ 3","Pricing Period Starting Year \n+ 4",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"I30","v":"2022-03-31"},{"$f":"I34","v":571934.89611897198},{"$f":"L8","v":"2022-09-30"},{"$f":"L23","v":-109194.43241828965},"2022-09-30",-109194.43241828965]
[{"$f":"ROW()","v":30},null,"($000)","Year ended",null,null,{"$f":"F7","v":"2020-03-31"},{"$f":"H7","v":"2021-03-31"},{"$f":"J7","v":"2022-03-31"},{"$f":"L7","v":"2023-03-31"},{"$f":"N7","v":"2024-03-31"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M8","v":"2022-11-03"},{"$f":"M23","v":92174.808433709361},"2022-11-03",92174.808433709361]
[{"$f":"ROW()","v":31},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"J30","v":"2023-03-31"},{"$f":"J34","v":625966.2863803854},{"$f":"N8","v":"2023-10-01"},{"$f":"N23","v":-215363.80342738537}]
[{"$f":"ROW()","v":32},null,"Forecast closing asset base",null,null,null,{"$f":"F149","v":536293.17405654467},{"$f":"G149","v":550167.89096704859},578392.03296025505,631500.97510148515,783565.77425721474,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O8","v":"2023-11-04"},{"$f":"O23","v":110091.63524350495}]
[{"$f":"ROW()","v":33},null,"Forecast closing carry forward adjustment",null,null,null,8302.0330816496789,7379.5849614663821,6457.1368412830843,5534.6887210997866,-10487.759399083512,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P8","v":"2024-03-31"},{"$f":"P23","v":794053.5336562983}]
[{"$f":"ROW()","v":34},null,"Forecast closing investment value",null,null,null,{"$f":"G32-G33","v":527991.14097489498},{"$f":"H32-H33","v":542788.30600558221},{"$f":"I32-I33","v":571934.89611897198},{"$f":"J32-J33","v":625966.2863803854},{"$f":"K32-K33","v":794053.5336562983}]
[{"$f":"ROW()","v":35}]
[{"$f":"ROW()","v":36},null,"Forecast post-tax IRR - annual ",null,null,null,{"$f":"U15","v":7.1326878666877758E-2},{"$f":"W15","v":1.8255787491798403E-2},{"$f":"Y15","v":4.7270570397377018E-2},{"$f":"AA15","v":6.3027080893516538E-2},{"$f":"AC15","v":9.1365137696266169E-2},null,null,null,null,null,null,null,"Forecast post-tax IRR - annual",null,{"$f":"IFERROR(XIRR(U22:U25,T22:T25,7%),\"\")","v":7.1326878666877758E-2},null,{"$f":"IFERROR(XIRR(W22:W27,V22:V27,7%),\"\")","v":4.4734689593315127E-2},null,{"$f":"IFERROR(XIRR(Y22:Y29,X22:X29,7%),\"\")","v":4.5536076426506054E-2},null,{"$f":"IFERROR(XIRR(AA22:AA31,Z22:Z31,7%),\"\")","v":4.9905535578727733E-2},null,{"$f":"IFERROR(XIRR(AC22:AC33,AB22:AB33,7%),\"\")","v":5.8758199810981751E-2}]
[{"$f":"ROW()","v":37},null,"Forecast post-tax IRR - period to date",null,null,null,{"$f":"U36","v":7.1326878666877758E-2},{"$f":"W36","v":4.4734689593315127E-2},{"$f":"Y36","v":4.5536076426506054E-2},{"$f":"AA36","v":4.9905535578727733E-2},{"$f":"AC36","v":5.8758199810981751E-2}]
[{"$f":"ROW()","v":38}]
[{"$f":"ROW()","v":39},"18(iii): Opening carry forward adjustment"]
[{"$f":"ROW()","v":40},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":41},null,"Default revaluation gain/loss adjustment",null,-33349.0813678298,42573.562569662783,{"$f":"E41+F41","v":9224.4812018329831},null,"Revaluation shortall incurred by WIAL during period of information dislcosure regulation until 2018, offset by MVAU revauation uplift in 2019.  "]
[{"$f":"ROW()","v":42},null,"Risk allocation adjustment",null,0,0,{"$f":"E42+F42","v":0}]
[{"$f":"ROW()","v":43},null,"Other carry forward adjustments",null,0,0,{"$f":"E43+F43","v":0}]
[{"$f":"ROW()","v":44},null,"Opening carry forward adjustment",null,{"$f":"SUM(E41:E43)","v":-33349.0813678298},42573.562569662783,{"$f":"SUM(G41:G43)","v":9224.4812018329831}]
[{"$f":"ROW()","v":45},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":46},null,"Revaluation methodology reviewed and agreed with substantial customers during consultation."]
[{"$f":"ROW()","v":47}]
[{"$f":"ROW()","v":48}]
[{"$f":"ROW()","v":49},"18(iv): Forecast closing carry forward adjustment"]
[null,null,null,null,"($000)",null,"Please explain each adjustment and how this has been calculated"]
[{"$f":"ROW()","v":51},null,"Remaining revaluation gains to be applied to PSE5",null,4612.2406009164888,null,"MVAU uplift and historic revaluation shortfall  allocated across PES4 and PSE5"]
[{"$f":"ROW()","v":52},null,"PSE4 revenue shortfall",null,-15100,null,"Price increase capped in PSE4 with shortfall in earnings to be recovered in PSE5"]
[{"$f":"ROW()","v":53},null,"[description of closing carry forward adjustment]"]
[{"$f":"ROW()","v":54},null,"[description of closing carry forward adjustment]"]
[{"$f":"ROW()","v":55},null,"Total forecast closing carry forward adjustment",null,{"$f":"SUM(E51:E54)","v":-10487.759399083512}]
[{"$f":"ROW()","v":56},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":57},null,"Revaluation methodology reviewed and agreed with substantial customers during consultation.  Shortfall in PSE4 earnings to be recovered in PSE5 following a risk sharing arrangement established to respond to the COVID19 pandemic during the PSE4 consultation."]
[{"$f":"ROW()","v":58}]
[{"$f":"ROW()","v":59}]
[{"$f":"ROW()","v":60},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":"+$M$2","v":"Wellington International Airport Limited"}]
[null,null,null,null,null,null,null,"Pricing Period Starting Year Ended",{"$f":"+$M$3","v":"2020-03-31"}]
["SCHEDULE 18: REPORT ON THE FORECAST TOTAL ASSET BASE REVENUE REQUIREMENTS (cont)"]
["ref","Version 3.0"]
[{"$f":"ROW()","v":67},"18(iv): Cash flow timing assumptions"]
[{"$f":"ROW()","v":68}]
[{"$f":"ROW()","v":69},null,"Year of most recent annual disclosure (year ended)",null,"2019-03-31"]
[{"$f":"ROW()","v":70},null,"First day of pricing period",null,"2019-04-01"]
[{"$f":"ROW()","v":71},null,null,null,"Airport assumption","Default assumption"]
[{"$f":"ROW()","v":72},null,"Cash flow timing - revenues  - days from year end",null,148,148]
[null,null,"Cash flow timing - expenditure  - days from year end",null,182,182]
[{"$f":"ROW()","v":74},null,"Explanation and evidence if airport assumption is different from default"]
[{"$f":"ROW()","v":75},null,"N/A"]
[{"$f":"ROW()","v":76},"18(v): Total Revenue Requirement"]
[{"$f":"ROW()","v":77},null,"Overview of the methodology used to determine the revenue requirement"]
[{"$f":"ROW()","v":78},null,"Refer to comments in Price Setting Disclosure comments on ID Determination clauses 2.5(10(a)(i) and (ii)."]
[{"$f":"ROW()","v":79}]
[{"$f":"ROW()","v":80}]
[{"$f":"ROW()","v":81}]
[{"$f":"ROW()","v":82}]
[{"$f":"ROW()","v":83}]
[{"$f":"ROW()","v":84}]
[{"$f":"ROW()","v":85}]
[{"$f":"ROW()","v":86},null,"($000)",null,null,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":87},null,null,null,null,null,null,{"$f":"+$F$7","v":"2020-03-31"},{"$f":"+H87+365","v":"2021-03-31"},{"$f":"+I87+365","v":"2022-03-31"},"2023-03-31","2024-03-30"]
[{"$f":"ROW()","v":88},null,"Forecast revenue for services applicable to the price setting event (excluding forecast assets held for future use revenue)",null,null,null,null,79736,38437.958802031972,64590.856151621549,85534.667974662123,99851.51999999999]
[{"$f":"ROW()","v":89},"plus","Forecast lease, rental and concession income (not applicable to the price setting event)",null,null,null,null,4606.6705198739382,4592.0812917362437,4907.2103041224564,4773.2863790472402,8109.9494835049572]
[{"$f":"ROW()","v":90},"plus","Forecast other operating revenue (not applicable to the price setting event)",null,null,null,null,2034.8652500000001,815.43488000000002,1278.2608,1866.8540800000001,2130.1657599999999]
[{"$f":"ROW()","v":91},null,"Forecast total revenue requirement (excluding assets held for future use revenue)",null,null,null,null,{"$f":"SUM(H88:H90)","v":86377.535769873939},{"$f":"SUM(I88:I90)","v":43845.474973768214},{"$f":"SUM(J88:J90)","v":70776.327255744007},{"$f":"SUM(K88:K90)","v":92174.808433709361},{"$f":"SUM(L88:L90)","v":110091.63524350495}]
[{"$f":"ROW()","v":92}]
[{"$f":"ROW()","v":93},"less","Forecast operational expenditure ",null,null,null,null,{"$f":"F268","v":25061.200713939357},{"$f":"G268","v":19501.37125685994},{"$f":"H268","v":23414.939753067396},{"$f":"I268","v":29205.487772716835},{"$f":"J268","v":32977.661876872691}]
[{"$f":"ROW()","v":94},"less","Forecast depreciation",null,null,null,null,{"$f":"F144","v":19308.29489159345},{"$f":"G144","v":19843.347164701889},{"$f":"H144","v":20658.083765189898},{"$f":"I144","v":21139.510859208156},{"$f":"J144","v":22646.349050885521}]
[{"$f":"ROW()","v":95},"less","Forecast unlevered tax",null,null,null,null,14357.140844389254,3734.9683125842221,9907.3665926567501,14416.372139538245,17147.507970419865]
[{"$f":"ROW()","v":96},"plus","Forecast revaluations",null,null,null,null,{"$f":"F145","v":7828.0683086435656},{"$f":"G145","v":8044.3976108481693},8252.5183645057277,8675.8804944038238,9472.5146265222793]
[{"$f":"ROW()","v":97}]
[{"$f":"ROW()","v":98},null,"Forecast regulatory profit / (loss)",null,null,null,null,{"$f":"H91-H93-H94-H95+H96","v":35478.967628595441},{"$f":"I91-I93-I94-I95+I96","v":8810.1858504703323},{"$f":"J91-J93-J94-J95+J96","v":25048.45550933569},{"$f":"K91-K93-K94-K95+K96","v":36089.318156649955},{"$f":"L91-L93-L94-L95+L96","v":46792.630971849154}]
[{"$f":"ROW()","v":99}]
[{"$f":"ROW()","v":100}]
[{"$f":"ROW()","v":101},null,"Forecast cost of capital",null,null,null,null,6.08E-2]
[{"$f":"ROW()","v":102},null,"Post-tax WACC at price setting event ",null,null,null,null,5.67E-2]
[{"$f":"ROW()","v":103},null,"WACC percentile equivalent for forecast cost of capital (optional)",null,null,null,null,0.61]
[{"$f":"ROW()","v":104},null,"WACC percentile equivalent for the post-tax IRR (optional)",null,null,null,null,0.56999999999999995]
[{"$f":"ROW()","v":105}]
[{"$f":"ROW()","v":106},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":107},null,"Refer to comments in Price Setting Disclosure on ID Determination clauses 2.5(1)(a)(i) and (ii), and 2.5(1)(c)(ii)."]
[{"$f":"ROW()","v":108}]
[{"$f":"ROW()","v":109}]
[{"$f":"ROW()","v":110},null,"Forecast total revenue requirement from airport charges (including assets held for future use revenue)"]
[{"$f":"ROW()","v":111},null,"Forecast total revenue requirement (excluding assets held for future use revenue)",null,null,null,null,{"$f":"H91","v":86377.535769873939},{"$f":"I91","v":43845.474973768214},{"$f":"J91","v":70776.327255744007},{"$f":"K91","v":92174.808433709361},{"$f":"L91","v":110091.63524350495}]
[{"$f":"ROW()","v":112},null,"Forecast assets held for future use revenue "]
[{"$f":"ROW()","v":113},null,"Forecast total revenue requirement (including forecast assets held for future use revenue)",null,null,null,null,{"$f":"H111+H112","v":86377.535769873939},{"$f":"I111+I112","v":43845.474973768214},{"$f":"J111+J112","v":70776.327255744007},{"$f":"K111+K112","v":92174.808433709361},{"$f":"L111+L112","v":110091.63524350495}]
[{"$f":"ROW()","v":114},null,"Description of any other factors that are considered in determining the forecast total revenue requirement"]
[{"$f":"ROW()","v":115},null,"There are no other factors."]
[{"$f":"ROW()","v":116}]
[{"$f":"ROW()","v":117}]
[{"$f":"ROW()","v":118}]
[{"$f":"ROW()","v":119}]
[{"$f":"ROW()","v":120}]
[{"$f":"ROW()","v":121}]
[{"$f":"ROW()","v":122}]
[{"$f":"ROW()","v":123},null,null,null,null,null,null,null,null,null,null,null,"Page 2"]
[]
[]
[null,null,null,null,null,null,"Regulated Airport",{"$f":"+$M$2","v":"Wellington International Airport Limited"}]
[null,null,null,null,null,null,"Pricing Period Starting Year Ended",{"$f":"+$M$3","v":"2020-03-31"}]
["SCHEDULE 18: REPORT ON THE FORECAST TOTAL ASSET BASE REVENUE REQUIREMENTS (cont 3)"]
["ref","Version 3.0"]
[null,null,"($000)"]
[{"$f":"ROW()","v":131},"18(vi): Opening Regulatory Asset Base"]
[{"$f":"ROW()","v":132},null,null,null,{"$f":"E70-1","v":"2019-03-31"}]
[{"$f":"ROW()","v":133},null,{"$f":"\"Regulatory asset base as at \"&TEXT(E69,\"dd mmmm yyy\")","v":"Regulatory asset base as at 31 March 2019"},null,476413.47017498029]
[{"$f":"ROW()","v":134},"less","Forecast depreciation",null,0]
[{"$f":"ROW()","v":135},"plus","Forecast revaluations",null,45457.750401257406]
[{"$f":"ROW()","v":136},"plus","Assets commissioned",null,0]
[{"$f":"ROW()","v":137},"less ","Asset disposals"]
[{"$f":"ROW()","v":138},"plus (less)","Forecast adjustment resulting from cost allocation"]
[{"$f":"ROW()","v":139},null,"Estimate of regulatory asset base at start of price setting event",null,{"$f":"E133-E134+E135+E136-E137+E138","v":521871.22057623771}]
[{"$f":"ROW()","v":140},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":141},null,"for year ended",null,{"$f":"EOMONTH(F141,-12)","v":"2019-03-31"},{"$f":"+$F$7","v":"2020-03-31"},{"$f":"EOMONTH(F141,12)","v":"2021-03-31"},{"$f":"EOMONTH(G141,12)","v":"2022-03-31"},"2023-03-31","2024-03-31"]
[{"$f":"ROW()","v":142},"18(vii): Forecast Asset Base"]
[{"$f":"ROW()","v":143},null,"Forecast asset base—previous year",null,476413.47017498029,{"$f":"E149","v":521871.22057623771},{"$f":"F149","v":536293.17405654467},{"$f":"G149","v":550167.89096704859},{"$f":"H149","v":578392.03296025505},{"$f":"I149","v":631500.97510148515}]
[{"$f":"ROW()","v":144},"less","Forecast depreciation",null,0,19308.29489159345,19843.347164701889,20658.083765189898,21139.510859208156,22646.349050885521]
[{"$f":"ROW()","v":145},"plus","Forecast revaluations",null,45457.750401257406,{"$f":"F299","v":7828.0683086435656},8044.3976108481693,8252.5183645057277,8675.8804944038238,9472.5146265222793]
[{"$f":"ROW()","v":146},"plus","Assets commissioned",null,0,25902.180063256816,25673.666464357688,40629.707393890581,65572.572506034572,165238.63358009284]
[{"$f":"ROW()","v":147},"less ","Asset disposals"]
[{"$f":"ROW()","v":148},"plus (less)","Forecast adjustment resulting from cost allocation"]
[{"$f":"ROW()","v":149},null,"Forecast asset base",null,{"$f":"E143-E144+E145+E146-E147+E148","v":521871.22057623771},536293.17405654467,550167.89096704859,578392.03296025505,631500.97510148515,783565.77425721474]
[{"$f":"ROW()","v":150}]
[{"$f":"ROW()","v":151},null,"Description and explanation of the depreciation methodology applied"]
[{"$f":"ROW()","v":152},null,"Refer to comments in Price Setting Disclosure on ID Determination clauses  2.5(1)(c)(iv), and 2.5(1)(p) and (q)."]
[{"$f":"ROW()","v":153}]
[{"$f":"ROW()","v":154}]
[{"$f":"ROW()","v":155},"18(viii): Forecast Works Under Construction"]
[{"$f":"ROW()","v":156},null,"Works under construction—previous year",null,39976,{"$f":"+E159","v":26192},{"$f":"+F159","v":29623.819936743184},{"$f":"+G159","v":32728.819936743188},43869.559936743186,97642.3768742432]
[{"$f":"ROW()","v":157},"plus","Capital expenditure",null,24124,29333.999999999996,28778.666464357688,51770.447393890572,119345.38944353457,101363.52783056159]
[{"$f":"ROW()","v":158},"less","Assets commissioned",null,37908,25902.180063256816,25673.666464357688,40629.707393890581,65572.572506034572,165238.63358009281]
[{"$f":"ROW()","v":159},null,"Works under construction",null,{"$f":"E156+E157-E158","v":26192},29623.819936743184,32728.819936743188,43869.559936743186,97642.3768742432,33767.271124711988]
[{"$f":"ROW()","v":160}]
[{"$f":"ROW()","v":161},"18(ix): Assets held for future use cost and base value"]
[{"$f":"ROW()","v":162},null,"Assets held for future use opening cost—previous year",null,12509,{"$f":"E168","v":15224},{"$f":"F168","v":37374.973871502691},{"$f":"G168","v":40497.254760937809},{"$f":"H168","v":42942.774511614036},{"$f":"I168","v":45615.042299184184}]
[{"$f":"ROW()","v":163},"plus","Forecast holding costs",null,647,1033.4803999999999,2371.6950158598906,2612.9380389973712,2834.4070463223593,2897.721148800912]
[{"$f":"ROW()","v":164},"less","Forecast assets held for future use net revenue",null,307,160.5065284973127,162.91412642477238,167.41828832114396,162.13925875221111,164.57134763349424]
[{"$f":"ROW()","v":165},"plus","Forecast assets held for future use additions",null,2821,21278,913.49999999999989,0,0,0]
[{"$f":"ROW()","v":166},"less","Forecast assets held for future use disposals",null,446,0,0,0,0,0]
[{"$f":"ROW()","v":167},"less","Forecast transfers to works under construction",null,0,0,0,0,0,-15270.434212462535]
[{"$f":"ROW()","v":168},null,"Assets held for future use closing cost",null,{"$f":"E162+E163-E164+E165-E166-E167","v":15224},{"$f":"F162+F163-F164+F165-F166-F167","v":37374.973871502691},40497.254760937809,42942.774511614036,45615.042299184184,63618.626312814136]
[{"$f":"ROW()","v":169}]
[{"$f":"ROW()","v":170},null,"Initial base value",null,7110]
[{"$f":"ROW()","v":171},"plus","Opening tracking revaluations",null,547]
[{"$f":"ROW()","v":172},null,"Opening base value",null,{"$f":"SUM(E170:E171)","v":7657},{"$f":"E177","v":9976},{"$f":"F177","v":31404.870000000003},{"$f":"G177","v":32787.57},33272.735549999998,33764.939099999996]
[{"$f":"ROW()","v":173},"plus","Forecast assets held for future use revaluations ",null,-56,150.87,469.2,485.16554999999994,492.20354999999995,499.48103324999994]
[{"$f":"ROW()","v":174},"plus","Forecast assets held for future use additions",null,{"$f":"E165","v":2821},{"$f":"F165","v":21278},913.49999999999989,0,0,0]
[{"$f":"ROW()","v":175},"less","Forecast assets held for future use disposals",null,{"$f":"E166","v":446},0,0,0,0,0]
[{"$f":"ROW()","v":176},"less","Forecast transfers to works under construction",null,0,0,0,0,0,-15270.434212462535]
[{"$f":"ROW()","v":177},null,"Closing base value",null,{"$f":"E172+E173+E174-E175-E176","v":9976},{"$f":"F172+F173+F174-F175-F176","v":31404.870000000003},32787.57,33272.735549999998,33764.939099999996,49534.854345712527]
[{"$f":"ROW()","v":178}]
[{"$f":"ROW()","v":179},null,"Tracking revaluations",null,{"$f":"E171+E173","v":491},{"$f":"E179+F173","v":641.87},{"$f":"F179+G173","v":1111.07},{"$f":"G179+H173","v":1596.2355499999999},2088.4390999999996,2587.9201332499997]
[{"$f":"ROW()","v":180}]
[{"$f":"ROW()","v":181},null,"Assumptions and explanations of any assets held for future use revenues"]
[{"$f":"ROW()","v":182},null,"Some interim proprerty rentals are received for land and buildings included in assets held for future use.  Rental levels are set on commerical terms.  There are no aviation or passenger related charges."]
[{"$f":"ROW()","v":183}]
[{"$f":"ROW()","v":184}]
[{"$f":"ROW()","v":185},null,null,null,null,null,null,null,null,null,"Page 3"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Regulated Airport",{"$f":"+$M$2","v":"Wellington International Airport Limited"}]
[null,null,null,null,null,null,null,null,null,null,"Pricing Period Starting Year Ended",{"$f":"+$M$3","v":"2020-03-31"}]
["SCHEDULE 18: REPORT ON THE FORECAST TOTAL ASSET BASE REVENUE REQUIREMENTS (cont 4)"]
["ref","Version 3.0"]
[{"$f":"ROW()","v":192},"18(x): Forecast Capital Expenditure"]
[{"$f":"ROW()","v":193},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":194},null,"for year ended",null,{"$f":"$F$7","v":"2020-03-31"},{"$f":"EOMONTH(E194,12)","v":"2021-03-31"},{"$f":"EOMONTH(F194,12)","v":"2022-03-31"},"2023-03-31","2024-03-31","2025-03-31","2026-03-31","2027-03-31","2028-03-31","2029-03-31"]
[{"$f":"ROW()","v":195},null,"Capital Expenditure by Category"]
[{"$f":"ROW()","v":196},null,"Capacity growth",null,26925.180063256816,26222.216464357687,27667.884893890576,62405.975725142336,45769.642815107451,16881.069313997432,41015.023320917884,31618.918544954904,171577.37243428067,21533.778181462523]
[{"$f":"ROW()","v":197},null,"Asset replacement and renewal",null,2408.8199367431807,2556.4499999999998,24102.562499999996,56939.413718392236,55593.885015454121,24884.614571280967,45622.800665655857,99434.164650508668,90464.311529990606,98684.771014718703]
[{"$f":"ROW()","v":198},null,"Total capital expenditure",null,{"$f":"SUM(E196:E197)","v":29333.999999999996},28778.666464357688,51770.447393890572,119345.38944353457,101363.52783056156,41765.683885278399,86637.823986573741,131053.08319546358,262041.68396427127,120218.54919618122]
[{"$f":"ROW()","v":199},null,"Capital Expenditure by Key Capital Expenditure Project"]
[{"$f":"ROW()","v":200},null,"AFS Relocation",null,1421,0,0,8647.9994249999982,20655.414011249995,0,0,0,0,0,null,{"$f":"SUM(E200,F200,G200,H200,I200,J200,K200,L200,M200,N200)","v":30724.413436249994}]
[{"$f":"ROW()","v":201},null,"Apron Development _Package 1",null,90,310.5,5034.7574999999997,13304.614499999998,4590.0920024999987,0,0,0,0,0,null,23329.964002499994]
[{"$f":"ROW()","v":202},null,"Apron Development _Package 2",null,null,null,null,null,null,9548.9978974008718,26896.10654041799,30140.295734940115,0,0,null,66585.400172758978]
[{"$f":"ROW()","v":203},null,"Apron Development _Package 3",null,null,null,null,null,null,null,null,null,28048.032487320481,14651.146547514059,null,42699.179034834538]
[{"$f":"ROW()","v":204},null,"Stage 3 - New EDS ECAC Std3 (capitalisation 1)",null,0,0,2356.6949999999997,5765.3329499999991,13770.276007499997,0,0,0,0,0,null,21892.303957499997]
[{"$f":"ROW()","v":205},null,"Stage 3 - New EDS ECAC Std3 (capitalisation 2)",null,0,0,0,0,0,12589.47483985687,12292.55326344515,0,0,0,null,24882.028103302022]
[{"$f":"ROW()","v":206},null,"Cargo Hub Stage 1",null,63,1035,5570.369999999999,26609.228999999992,8950.679404874998,0,0,0,0,0,null,42228.278404874989]
[{"$f":"ROW()","v":207},null,"New 8MPPA Terminal Build - Stage 1",null,1889.8199367431807,0,0,0,0,2746.1418340232281,2842.2567982140408,23533.886289212256,60893.93077333671,84033.624467204645,null,175939.66009873408]
[{"$f":"ROW()","v":208},null,"JUHI Relocation",null,0,0,0,0,0,0,0,0,0,8177.3841195427312,null,8177.3841195427312]
[{"$f":"ROW()","v":209},null,"Trunk Utilities Relocation",null,0,398.85065956957425,3715.2938938905841,13672.281529517348,3537.7028457626134,0,0,0,0,0,null,21324.12892874012]
[{"$f":"ROW()","v":210},null,"Miramar South School",null,0,0,0,0,16295.56333515567,0,0,0,0,0,null,16295.56333515567]
[{"$f":"ROW()","v":211},null,"Runway Overlay",null,7,14282.999999999998,0,0,0,0,0,0,0,0,null,14289.999999999998]
[{"$f":"ROW()","v":212},null,"TWY Bravo Reconstruction",null,366,1035,8569.7999999999993,9978.460874999997,0,0,0,0,0,0,null,19949.260874999996]
[{"$f":"ROW()","v":213},null,"Marine Protection - Southern Seawall replacement",null,58,2070,2142.4499999999998,332.61536249999995,0,0,2212.6595874201271,6361.3963138328645,75058.11510691396,0,null,88235.236370666942]
[{"$f":"ROW()","v":214},null,"Marine Protection - Western Seawall replacement",null,0,0,0,0,0,0,0,636.13963138328643,15143.303925079133,0,null,15779.44355646242]
[{"$f":"ROW()","v":215},null,"Marine Protection - Breakwater replacement",null,0,0,0,0,0,0,1229.255326344515,3180.6981569164323,63865.238292725044,0,null,68275.191775985993]
[{"$f":"ROW()","v":216},null,"Regional and Goods Screening",null,0,0,0,0,8032.6610043749979,0,0,0,0,0,null,8032.6610043749979]
[{"$f":"ROW()","v":217},null,"AFS Land Purchase",null,0,0,0,0,1227.6111531759918,0,0,0,0,0,null,1227.6111531759918]
[{"$f":"ROW()","v":218},null,"Flight Catering Relocation",null,0,0,1071.2249999999999,12195.896624999998,3442.5690018749992,0,0,0,0,0,null,16709.690626874995]
[{"$f":"ROW()","v":219},null,"Sprinkler Valve house relocation",null,0,0,0,0,0,0,1421.1283991070204,0,0,0,null,1421.1283991070204]
[{"$f":"ROW()","v":220},null,"Energy Centre",null,0,0,0,0,0,1144.2257641763451,15869.267123361727,0,0,0,null,17013.492887538072]
[{"$f":"ROW()","v":221},null,"Apron under AFS",null,0,0,0,221.74357499999994,860.64225046874981,4810.1295378698414,0,0,0,0,null,5892.5153633385908]
[{"$f":"ROW()","v":222},null,"Complete MGC purchase",null,0,0,0,0,0,0,0,45759.982626356301,0,0,null,45759.982626356301]
[{"$f":"ROW()","v":223},null,"Other capital expenditure",null,25439.180063256816,9646.3158047881152,23309.856,28617.215601517266,20000.316813623562,10926.714011951244,23874.596948263163,21440.684442822327,19033.063378895924,13356.394061919797,null,195644.33712703822]
[{"$f":"ROW()","v":224},null,"Total Capital Expenditure ",null,29333.999999999996,28778.666464357688,51770.447393890579,119345.38944353459,101363.52783056159,41765.683885278399,86637.823986573741,131053.08319546358,262041.68396427127,120218.54919618124,null,{"$f":"SUM(P200:P223)","v":972308.85536011262}]
[{"$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":"+$M$2","v":"Wellington International Airport Limited"}]
[null,null,null,null,null,"Pricing Period Starting Year Ended","2020-03-31"]
["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},null,"Refer to comments in Price Setting Disclosure on ID Determination clauses  2.5(1)(c)(iii)."]
[{"$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},null,"Refer to Price Setting Disclosure Appendix B."]
[{"$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":"$F$7","v":"2020-03-31"},{"$f":"EOMONTH(F264,12)","v":"2021-03-31"},{"$f":"EOMONTH(G264,12)","v":"2022-03-31"},"2023-03-31","2024-03-31"]
[{"$f":"ROW()","v":265},null,"Corporate overheads",null,null,6378.1947285007955,4909.3039350541248,5777.3103198202953,6496.8612222297616,7250.3197840442081]
[{"$f":"ROW()","v":266},null,"Asset management and airport operations",null,null,16733.985689498448,13013.503260090321,15877.032350782356,20730.516875837944,23617.62703474264]
[{"$f":"ROW()","v":267},null,"Asset maintenance",null,null,1949.0202959401131,1578.5640617154934,1760.5970824647452,1978.1096746491326,2109.715058085847]
[{"$f":"ROW()","v":268},null,"Forecast operational expenditure",null,null,{"$f":"SUM(F265:F267)","v":25061.200713939357},{"$f":"SUM(G265:G267)","v":19501.37125685994},{"$f":"SUM(H265:H267)","v":23414.939753067396},{"$f":"SUM(I265:I267)","v":29205.487772716835},{"$f":"SUM(J265:J267)","v":32977.661876872691}]
[]
[{"$f":"ROW()","v":270},null,null,null,null,null,null,null,null,null,"Page 5"]
[]
[]
[null,null,null,null,null,"Regulated Airport",{"$f":"+$M$2","v":"Wellington International Airport Limited"}]
[null,null,null,null,null,"Pricing Period Starting Year Ended","2020-03-31"]
["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":"$F$7","v":"2020-03-31"},{"$f":"EOMONTH(F279,12)","v":"2021-03-31"},{"$f":"EOMONTH(G279,12)","v":"2022-03-31"},"2023-03-31","2024-03-31"]
[{"$f":"ROW()","v":280},null,"Forecast pricing incentives",null,null,0,0,0,0,0]
[{"$f":"ROW()","v":281},null,"Forecast other incentives",null,null,0,0,0,0,0]
[{"$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":"2019-03-31"},{"$f":"$F$7","v":"2020-03-31"},{"$f":"EOMONTH(F286,12)","v":"2021-03-31"},{"$f":"EOMONTH(G286,12)","v":"2022-03-31"},"2023-03-31","2024-03-31"]
[{"$f":"ROW()","v":287},null,"Forecast CPI used to set prices"]
[{"$f":"ROW()","v":288},null,"Forecast pricing CPI (%)",null,1.4836800000000001E-2,1.4999999999999999E-2,1.4999999999999999E-2,1.4999999999999999E-2,1.4999999999999999E-2,1.4999999999999999E-2]
[{"$f":"ROW()","v":289},null,"Asset category revaluation rates (%)"]
[{"$f":"ROW()","v":290},null,"Land ",null,1.4836800000000001E-2,1.4999999999999999E-2,1.4999999999999999E-2,1.4999999999999999E-2,1.4999999999999999E-2,1.4999999999999999E-2]
[{"$f":"ROW()","v":291},null,"Sealed Surfaces",null,1.4836800000000001E-2,1.4999999999999999E-2,1.4999999999999999E-2,1.4999999999999999E-2,1.4999999999999999E-2,1.4999999999999999E-2]
[{"$f":"ROW()","v":292},null,"Infrastructure and buildings ",null,1.4836800000000001E-2,1.4999999999999999E-2,1.4999999999999999E-2,1.4999999999999999E-2,1.4999999999999999E-2,1.4999999999999999E-2]
[{"$f":"ROW()","v":293},null,"Vehicles, plant and equipment",null,1.4836800000000001E-2,1.4999999999999999E-2,1.4999999999999999E-2,1.4999999999999999E-2,1.4999999999999999E-2,1.4999999999999999E-2]
[{"$f":"ROW()","v":294},null,"Forecast revaluations  ($000s)"]
[{"$f":"ROW()","v":295},null,"Land ",null,43717.135879828696,2531.437881393726,2569.4094496146322,2607.8732291473352,2678.9721927283422,2738.1479522229065]
[{"$f":"ROW()","v":296},null,"Sealed Surfaces",null,0,2488.3616434507912,2478.4593110781093,2710.9917761436045,3012.958821870855,3637.0506897974019]
[{"$f":"ROW()","v":297},null,"Infrastructure and buildings ",null,1740.6145214287094,2586.1592495224368,2582.7787130463012,2535.7457374060468,2543.6383398665348,2608.3900256611828]
[{"$f":"ROW()","v":298},null,"Vehicles, plant and equipment",null,0,222.10953427661167,413.75013710912685,397.90762180874071,440.31113993809259,488.92595884078696]
[{"$f":"ROW()","v":299},null,"Total forecast revaluations",null,{"$f":"SUM(E295:E298)","v":45457.750401257406},7828.0683086435656,8044.3976108481693,8252.5183645057277,8675.8804944038238,9472.5146265222793]
[{"$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},null,"N/A"]
[{"$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":"Sched 19","index":1,"n_rows":140,"n_cols":17,"rows_kept":140,"cut":false,"hidden":false,"merged":[[27,8,27,15],[1,12,1,15],[2,12,2,15],[5,5,5,6],[5,7,5,8],[5,9,5,10],[5,11,5,12],[5,13,5,14],[6,5,6,6],[6,7,6,8],[6,9,6,10],[6,11,6,12],[6,13,6,14],[55,2,55,15],[28,8,28,15],[29,8,29,15],[30,8,30,15],[33,2,35,15],[37,6,37,8],[38,6,38,15],[39,6,39,15],[40,6,40,15],[41,6,41,15],[43,2,43,15],[44,2,46,15],[110,7,110,9],[135,2,137,9],[59,8,59,10],[60,8,60,10],[65,2,72,9],[90,2,92,9],[98,2,105,9],[109,7,109,9]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,"Regulated Airport","Wellington International Airport Limited"]
[null,null,null,null,null,null,null,null,null,null,null,"Pricing Period Starting Year Ended","2020-03-31"]
["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":7},"19(i): Forecast Internal Rate of Return",null,null,null,{"$f":"+$M$3","v":"2020-03-31"},null,{"$f":"+F7+365","v":"2021-03-31"},null,{"$f":"+H7+365","v":"2022-03-31"},null,{"$f":"+J7+365","v":"2023-03-31"},null,{"$f":"+L7+366","v":"2024-03-31"}]
[{"$f":"ROW()","v":8},null,"($000)","Cash flow date",{"$f":"E51","v":"2019-04-01"},{"$f":"M3-IF(ISNUMBER(E54),E54,F54)","v":"2019-10-01"},{"$f":"$M$3-IF(ISNUMBER(E53),E53,F53)","v":"2019-11-04"},{"$f":"EOMONTH($M$3,12)-IF(ISNUMBER(E54),E54,F54)","v":"2020-09-30"},{"$f":"EOMONTH($M$3,12)-IF(ISNUMBER(E53),E53,F53)","v":"2020-11-03"},{"$f":"EOMONTH($M$3,24)-IF(ISNUMBER(E54),E54,F54)","v":"2021-09-30"},{"$f":"EOMONTH($M$3,24)-IF(ISNUMBER(E53),E53,F53)","v":"2021-11-03"},{"$f":"EOMONTH($M$3,36)-IF(ISNUMBER(D53),E54,F54)","v":"2022-09-30"},{"$f":"EOMONTH($M$3,36)-IF(ISNUMBER(E53),E53,F53)","v":"2022-11-03"},{"$f":"EOMONTH($M$3,48)-IF(ISNUMBER(K54),E54,F54)","v":"2023-10-01"},{"$f":"EOMONTH($M$3,48)-IF(ISNUMBER(E53),E53,F53)","v":"2023-11-04"},{"$f":"EOMONTH($M$3,48)","v":"2024-03-31"}]
[{"$f":"ROW()","v":9},null,"Opening asset base (applicable to price setting)",null,{"$f":"F127","v":485104.4626359205}]
[{"$f":"ROW()","v":10},null,"Foreacst opening carry forward adjustment",null,{"$f":"G32","v":9224.4812018329831}]
[{"$f":"ROW()","v":11},null,"Opening investment value",null,{"$f":"E9-E10","v":475879.9814340875}]
[{"$f":"ROW()","v":12}]
[{"$f":"ROW()","v":13},"plus","Forecast revenue for services applicable to price setting event",null,null,null,{"$f":"F79","v":79736},null,{"$f":"G79","v":38437.958802031972},null,{"$f":"H79","v":64590.856151621549},null,{"$f":"I79","v":85534.667974662123},null,{"$f":"J79","v":99851.51999999999}]
[{"$f":"ROW()","v":14},"less","Forecast assets commissioned",null,null,{"$f":"-F130","v":-25902.180063256816},null,{"$f":"-G130","v":-25673.666464357688},null,{"$f":"-H130","v":-40629.707393890581},null,{"$f":"-I130","v":-65572.572506034572},null,{"$f":"-J130","v":-106300.66454834283}]
[{"$f":"ROW()","v":15},"plus","Forecast cash flow from asset disposals"]
[{"$f":"ROW()","v":16},"less","Forecast operational expenditure ",null,null,{"$f":"-F81","v":-21742.771359970517},null,{"$f":"-G81","v":-18048.904832296044},null,{"$f":"-H81","v":-21508.725444620897},null,{"$f":"-I81","v":-25296.096933795754},null,{"$f":"-J81","v":-29411.777383041364}]
[{"$f":"ROW()","v":17},"less","Forecast unlevered tax",null,null,{"$f":"-F83","v":-13212.898464831778},null,{"$f":"-G83","v":-2695.3340994019127},null,{"$f":"-H83","v":-8803.7026504773639},null,{"$f":"-I83","v":-13035.807512883057},null,{"$f":"-J83","v":-15044.826400294791}]
[{"$f":"ROW()","v":18}]
[{"$f":"ROW()","v":19},null,"Forecast closing asset base",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"J133","v":691573.67225343734}]
[{"$f":"ROW()","v":20},null,"Forecast closing carry forward adjustment",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"E43","v":-10487.759399083512}]
[{"$f":"ROW()","v":21},null,"Forecast closing investment value",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P19-P20","v":702061.4316525209}]
[{"$f":"ROW()","v":22}]
[{"$f":"ROW()","v":23},null,"Forecast net cash flows",null,{"$f":"-E11","v":-475879.9814340875},{"$f":"SUM(F13:F17)","v":-60857.849888059114},{"$f":"SUM(G13:G17)","v":79736},-46417.905396055648,38437.958802031972,-70942.135488988846,64590.856151621549,-103904.47695271338,85534.667974662123,-150757.26833167899,99851.51999999999,{"$f":"P21","v":702061.4316525209}]
[{"$f":"ROW()","v":24}]
[{"$f":"ROW()","v":25},null,{"$f":"\"Forcast post-tax IRR as at \"&TEXT(E8,\"dd mmmm yyy\")","v":"Forcast post-tax IRR as at 01 April 2019"},null,{"$f":"IFERROR(XIRR(E23:P23,E8:P8),\"\")","v":5.9274503588676447E-2}]
[{"$f":"ROW()","v":26},null,"NPV check",null,{"$f":"IFERROR(XNPV(E25,E23:P23,E8:P8),0)","v":1.7921449616551399E-3},{"$f":"IF(ABS(E26)<0.01,\"OK\",\"ERROR\")","v":"OK"}]
[{"$f":"ROW()","v":27},"19(ii): Opening carry forward adjustment"]
[{"$f":"ROW()","v":28},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":29},null,"Default revaluation gain/loss adjustment",null,-33349.0813678298,42573.562569662783,{"$f":"E29+F29","v":9224.4812018329831},null,"Revaluation shortall incurred by WIAL during period of information dislcosure regulation until 2018, offset by MVAU revauation uplift in 2019.  "]
[{"$f":"ROW()","v":30},null,"Risk allocation adjustment",null,0,0,{"$f":"E30+F30","v":0}]
[{"$f":"ROW()","v":31},null,"Other carry forward adjustments",null,0,0,0]
[{"$f":"ROW()","v":32},null,"Opening carry forward adjustment",null,{"$f":"SUM(E29:E31)","v":-33349.0813678298},42573.562569662783,{"$f":"SUM(G29:G31)","v":9224.4812018329831}]
[{"$f":"ROW()","v":33},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":34},null,"Revaluation methodology reviewed and agreed with substantial customers during consultation."]
[{"$f":"ROW()","v":35}]
[{"$f":"ROW()","v":36}]
[{"$f":"ROW()","v":37},"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":39},null,"Remaining revaluation gains to be applied to PSE5",null,4612.2406009164888,null,"MVAU uplift and historic revaluation shortfall  allocated across PES4 and PSE5"]
[{"$f":"ROW()","v":40},null,"PSE4 revenue shortfall",null,-15100,null,"Price increase capped in PSE4 with shortfall in earnings to be recovered in PSE5"]
[{"$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,"Total forecast closing carry forward adjustment",null,{"$f":"SUM(E39:E42)","v":-10487.759399083512}]
[{"$f":"ROW()","v":44},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":45},null,"Revaluation methodology reviewed and agreed with substantial customers during consultation.  Shortfall in PSE4 earnings to be recovered in PSE5 following a risk sharing arrangement established to respond to the COVID19 pandemic during the PSE4"]
[{"$f":"ROW()","v":46}]
[{"$f":"ROW()","v":47}]
[{"$f":"ROW()","v":48},"19(iv): Cash flow timing assumptions"]
[{"$f":"ROW()","v":49}]
[{"$f":"ROW()","v":50},null,"Year of most recent annual disclosure (year ended)",null,"2019-03-31"]
[{"$f":"ROW()","v":51},null,"First day of pricing period",null,"2019-04-01"]
[{"$f":"ROW()","v":52},null,null,null,"Airport assumption","Default assumption"]
[null,null,"Cash flow timing - revenues  - days from year end",null,148,148]
[{"$f":"ROW()","v":54},null,"Cash flow timing - expenditure  - days from year end",null,182,182]
[{"$f":"ROW()","v":55},null,"Explanation and evidence if airport assumption is different from default"]
[{"$f":"ROW()","v":56},null,"N/A"]
[{"$f":"ROW()","v":57},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":"+$M$2","v":"Wellington International Airport Limited"}]
[null,null,null,null,null,null,null,"Pricing Period Starting Year Ended",{"$f":"+$M$3","v":"2020-03-31"}]
["SCHEDULE 19: REPORT ON THE FORECAST PRICING ASSET BASE REVENUE REQUIREMENTS (cont 2)"]
["ref","Version 3.0"]
[{"$f":"ROW()","v":64},"19(v): Total Revenue Requirement for Pricing Assets"]
[{"$f":"ROW()","v":65},null,"Overview of the methodology used to determine the revenue requirement for pricing assets"]
[{"$f":"ROW()","v":66},null,"Refer to comments in Price Setting Disclosure including sections 6 and 7, and comments on ID Determination clauses 2.5(1)(a)(i) and (ii)."]
[{"$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},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":75},null,null,null,null,{"$f":"+F7","v":"2020-03-31"},{"$f":"+F75+365","v":"2021-03-31"},{"$f":"+G75+365","v":"2022-03-31"},"2023-03-31",{"$f":"+I75+366","v":"2024-03-31"}]
[{"$f":"ROW()","v":76},null,"Forecast revenue from airport activity charges applicable to the price setting event",null,null,79736,38437.958802031972,64590.856151621549,85534.667974662123,99851.51999999999]
[null,null,"Forecast lease, rental and concession income (applicable to the price setting event)",null,null,0,0,0,0,0]
[{"$f":"ROW()","v":78},"plus","Forecast other operating revenue (applicable to the price setting event)"]
[{"$f":"ROW()","v":79},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(F76:F78)","v":79736},{"$f":"SUM(G76:G78)","v":38437.958802031972},{"$f":"SUM(H76:H78)","v":64590.856151621549},{"$f":"SUM(I76:I78)","v":85534.667974662123},{"$f":"SUM(J76:J78)","v":99851.51999999999}]
[{"$f":"ROW()","v":80}]
[{"$f":"ROW()","v":81},"less","Forecast operational expenditure ",null,null,21742.771359970517,18048.904832296044,21508.725444620897,25296.096933795754,29411.777383041364]
[{"$f":"ROW()","v":82},"less","Forecast depreciation",null,null,{"$f":"-F128","v":17858.946857709874},{"$f":"-G128","v":18632.799962558922},19439.225256314017,19909.38840912858,21400.642819789711]
[{"$f":"ROW()","v":83},"less","Forecast unlevered tax",null,null,13212.898464831778,2695.3340994019127,8803.7026504773639,13035.807512883057,15044.826400294791]
[{"$f":"ROW()","v":84},"plus","Forecast revaluations",null,null,{"$f":"F129","v":7276.5669395388086},{"$f":"G129","v":7506.3639417150935},7724.5723983678017,8158.2982164069672,8965.6204511066608]
[{"$f":"ROW()","v":85}]
[{"$f":"ROW()","v":86},null,"Forecast regulatory profit / (loss)",null,null,{"$f":"F79-F81-F82-F83+F84","v":34197.950257026641},{"$f":"G79-G81-G82-G83+G84","v":6567.2838494901862},{"$f":"H79-H81-H82-H83+H84","v":22563.775198577074},{"$f":"I79-I81-I82-I83+I84","v":35451.673335261701},{"$f":"J79-J81-J82-J83+J84","v":42959.893847980784}]
[{"$f":"ROW()","v":87}]
[{"$f":"ROW()","v":88},null,"Forecast cost of capital",null,null,6.08E-2]
[{"$f":"ROW()","v":89}]
[{"$f":"ROW()","v":90},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":91},null,"Refer to comments in Price Setting Disclosure on ID Determination clauses 2.5(10(a)(i) and (ii), and 2.5(1)(c)(ii)."]
[{"$f":"ROW()","v":92}]
[{"$f":"ROW()","v":93}]
[{"$f":"ROW()","v":94},null,"Forecast pricing revenue requirement from airport charges (including assets held for future use charges)"]
[{"$f":"ROW()","v":95},null,"Forecast pricing revenue requirement (excluding forecast revenue from assets held for future use revenues)",null,null,{"$f":"F76","v":79736},{"$f":"G76","v":38437.958802031972},{"$f":"H76","v":64590.856151621549},{"$f":"I76","v":85534.667974662123},{"$f":"J76","v":99851.51999999999}]
[{"$f":"ROW()","v":96},null,"Forecast revenues from assets held for future use charges "]
[{"$f":"ROW()","v":97},null,"Forecast pricing revenue requirement from airport charges (including forecast revenue from assets held for future use charges)",null,null,{"$f":"F95+F96","v":79736},{"$f":"G95+G96","v":38437.958802031972},{"$f":"H95+H96","v":64590.856151621549},{"$f":"I95+I96","v":85534.667974662123},{"$f":"J95+J96","v":99851.51999999999}]
[{"$f":"ROW()","v":98},null,"Description of any other factors that are considered in determining the forecast total revenue requirement"]
[{"$f":"ROW()","v":99},null,"There are no other factors."]
[{"$f":"ROW()","v":100}]
[{"$f":"ROW()","v":101}]
[{"$f":"ROW()","v":102}]
[{"$f":"ROW()","v":103}]
[{"$f":"ROW()","v":104}]
[{"$f":"ROW()","v":105}]
[{"$f":"ROW()","v":106}]
[{"$f":"ROW()","v":107},null,null,null,null,null,null,null,null,null,null,"Page 8"]
[]
[]
[null,null,null,null,null,null,"Regulated Airport",{"$f":"+$M$2","v":"Wellington International Airport Limited"}]
[null,null,null,null,null,null,"Pricing Period Starting Year Ended",{"$f":"+$M$3","v":"2020-03-31"}]
["SCHEDULE 19: REPORT ON THE FORECAST PRICING ASSET BASE REVENUE REQUIREMENTS (cont 3)"]
["ref","Version 3.0"]
[null,null,"($000)"]
[{"$f":"ROW()","v":115},"19(vi): Opening Regulated Asset Base (applicable to price setting)"]
[{"$f":"ROW()","v":116},null,null,null,{"$f":"E51-1","v":"2019-03-31"}]
[{"$f":"ROW()","v":117},null,{"$f":"\"Regulated asset base (applicable to price setting) as at \"&TEXT(E50,\"dd mmmm yyy\")","v":"Regulated asset base (applicable to price setting) as at 31 March 2019"},null,443235.90876625769]
[{"$f":"ROW()","v":118},"less","Forecast depreciation",null,0]
[{"$f":"ROW()","v":119},"plus","Forecast revaluations",null,41868.553869662785]
[{"$f":"ROW()","v":120},"plus","Assets commissioned",null,0]
[{"$f":"ROW()","v":121},"less ","Asset disposals"]
[{"$f":"ROW()","v":122},"plus (less)","Forecast adjustment resulting from cost allocation"]
[{"$f":"ROW()","v":123},null,"Estimate of regulated asset base (applicable to price setting) at start of price setting event",null,{"$f":"E117+E118+E119+E120-E121+E122","v":485104.4626359205}]
[{"$f":"ROW()","v":124},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":125},null,"for year ended",null,{"$f":"EOMONTH(F125,-12)","v":"2019-03-31"},{"$f":"+$M$3","v":"2020-03-31"},{"$f":"+F125+365","v":"2021-03-31"},{"$f":"+G125+365","v":"2022-03-31"},"2023-03-31",{"$f":"+I125+366","v":"2024-03-31"}]
[{"$f":"ROW()","v":126},"19(vii): Forecast Asset Base (applicable to price setting)"]
[{"$f":"ROW()","v":127},null,"Forecast pricing asset base—previous year",null,443235.90876625769,{"$f":"E133","v":485104.4626359205},{"$f":"F133","v":500424.26278100623},{"$f":"G133","v":514971.49322452012},{"$f":"H133","v":543886.54776046448},{"$f":"I133","v":597708.03007377754}]
[{"$f":"ROW()","v":128},"less","Forecast depreciation",null,0,-17858.946857709874,-18632.799962558922,-19439.225256314017,-19909.38840912858,-21400.642819789711]
[{"$f":"ROW()","v":129},"plus","Forecast revaluations",null,41868.553869662785,7276.5669395388086,7506.3639417150935,7724.5723983678017,8158.2982164069672,8965.6204511066608]
[{"$f":"ROW()","v":130},"plus","Assets commissioned",null,0,25902.180063256816,25673.666464357688,40629.707393890581,65572.572506034572,106300.66454834283]
[{"$f":"ROW()","v":131},"less ","Asset disposals"]
[{"$f":"ROW()","v":132},"plus (less)","Forecast adjustment resulting from cost allocation"]
[{"$f":"ROW()","v":133},null,"Forecast pricing asset base",null,{"$f":"E127+E128+E129+E130-E131+E132","v":485104.4626359205},{"$f":"F127+F128+F129+F130-F131+F132","v":500424.26278100623},514971.49322452012,543886.54776046448,597708.03007377754,691573.67225343734]
[{"$f":"ROW()","v":134}]
[{"$f":"ROW()","v":135},null,"Description of and explanation for the depreciation methodology applied"]
[{"$f":"ROW()","v":136},null,"Refer to comments in Price Setting Disclosure on ID Determination clauses  2.5(1)(c)(iv), and 2.5(1)(p) and (q)."]
[{"$f":"ROW()","v":137}]
[{"$f":"ROW()","v":138}]
[{"$f":"ROW()","v":139}]
[null,null,null,null,null,null,null,null,null,null,"Page 9"]

{"sheet":"S20. Demand Forecast","index":2,"n_rows":72,"n_cols":25,"rows_kept":72,"cut":false,"hidden":false,"merged":[[49,2,51,2],[53,2,55,2],[57,2,70,23],[23,2,24,2],[29,17,29,23],[30,17,30,23],[36,2,38,2],[39,2,42,2],[44,2,47,2],[16,2,22,2],[16,3,18,3],[20,3,22,3],[1,17,1,23],[2,17,2,23],[8,2,14,2],[8,3,10,3],[12,3,14,3]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Regulated Airport","Wellington International Airport Limited"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pricing Period Starting Year Ended","2019-04-01"]
["SCHEDULE 20: REPORT ON DEMAND FORECASTS"]
["ref","Version 4.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(#REF!),\"for year ended\",\"\")","v":""},"2019-04-01",null,"2020-04-01",null,"2021-04-01",null,"2022-04-01",null,"2023-04-01",null,"2024-04-01",null,"2025-04-01",null,"2026-04-01",null,"2027-04-01",null,"2028-04-01"]
[{"$f":"ROW()","v":9},null,"Busy hour passenger numbers","Inbound passengers","Domestic",1256,null,1021,null,1041.3442312059265,null,1222.2071054889609,null,1330.8789330512541,null,1353.9433491363473,null,1378.1995004842734,null,1405.1359926689586,null,1433.7587882479991,null,1465.3649006464323]
[{"$f":"ROW()","v":10},null,null,null,"International",594,null,0,null,365.58406482885709,null,477.4393791803364,null,617.41281355557874,null,638.5913836111946,null,687.69183573013481,null,710.33980161717795,null,734.2269169156865,null,763.64129886731178]
[{"$f":"ROW()","v":11},null,null,null,"Combined *",1260,null,1021,null,1041.3442312059265,null,1222.2071054889609,null,1330.8789330512541,null,1354.9939079497158,null,1391.1949056703963,null,1421.3011044768907,null,1453.2354559613934,null,1489.4602020450639]
[{"$f":"ROW()","v":12}]
[{"$f":"ROW()","v":13},null,null,"Outbound passengers","Domestic",1217,null,996,null,1009.0094979121117,null,1184.2564071497336,null,1289.5538706396308,null,1311.9021145692154,null,1335.4050892431214,null,1361.5051776099701,null,1389.2392080396614,null,1419.8639204512006]
[{"$f":"ROW()","v":14},null,null,null,"International",580,null,0,null,356.96760538844632,null,466.18659919965506,null,602.86099640107011,null,623.54040823988703,null,671.48361064558617,null,693.59778609084708,null,716.92190540588922,null,745.6430190960283]
[{"$f":"ROW()","v":15},null,null,null,"Combined *",1264,null,996,null,1009.0094979121117,null,1195.5821954721087,null,1332.8677098775283,null,1359.2954759114609,null,1395.6113974344294,null,1425.8131714752301,null,1457.8489018533344,null,1494.1886471309213]
[{"$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":"5226449/2","v":2613224.5},null,1481224.1066099999,null,2221049.5749999997,null,2606806.1749999998,null,2838588.8163098688,null,2887782.1666048965,null,2939517.3306630468,null,2996969.307373479,null,3058017.9462875482,null,3125429.6055701361]
[{"$f":"ROW()","v":18},null,null,null,"International",459811,null,99.82,null,145009.32820649294,null,378753.72749999998,null,489794.96610000002,null,506595.97309999989,null,545547.47160000005,null,563514.15359999985,null,582463.85559999989,null,605798.35060000012]
[{"$f":"ROW()","v":19},null,null,null,"Total",{"$f":"SUM(F17:F18)","v":3073035.5},null,{"$f":"SUM(H17:H18)","v":1481323.92661},null,{"$f":"SUM(J17:J18)","v":2366058.9032064928},null,{"$f":"SUM(L17:L18)","v":2985559.9024999999},null,{"$f":"SUM(N17:N18)","v":3328383.7824098687},null,{"$f":"SUM(P17:P18)","v":3394378.1397048966},null,{"$f":"SUM(R17:R18)","v":3485064.8022630466},null,{"$f":"SUM(T17:T18)","v":3560483.4609734789},null,{"$f":"SUM(V17:V18)","v":3640481.8018875481},null,{"$f":"SUM(X17:X18)","v":3731227.9561701361}]
[{"$f":"ROW()","v":20}]
[{"$f":"ROW()","v":21},null,null,"Outbound passengers","Domestic",{"$f":"F17","v":2613224.5},null,{"$f":"H17","v":1481224.1066099999},null,{"$f":"J17","v":2221049.5749999997},null,{"$f":"L17","v":2606806.1749999998},null,{"$f":"N17","v":2838588.8163098688},null,{"$f":"P17","v":2887782.1666048965},null,{"$f":"R17","v":2939517.3306630468},null,{"$f":"T17","v":2996969.307373479},null,{"$f":"V17","v":3058017.9462875482},null,{"$f":"X17","v":3125429.6055701361}]
[{"$f":"ROW()","v":22},null,null,null,"International",{"$f":"F18","v":459811},null,{"$f":"H18","v":99.82},null,{"$f":"J18","v":145009.32820649294},null,{"$f":"L18","v":378753.72749999998},null,{"$f":"N18","v":489794.96610000002},null,{"$f":"P18","v":506595.97309999989},null,{"$f":"R18","v":545547.47160000005},null,{"$f":"T18","v":563514.15359999985},null,{"$f":"V18","v":582463.85559999989},null,{"$f":"X18","v":605798.35060000012}]
[{"$f":"ROW()","v":23},null,null,null,"Total",{"$f":"SUM(F21:F22)","v":3073035.5},null,{"$f":"SUM(H21:H22)","v":1481323.92661},null,{"$f":"SUM(J21:J22)","v":2366058.9032064928},null,{"$f":"SUM(L21:L22)","v":2985559.9024999999},null,{"$f":"SUM(N21:N22)","v":3328383.7824098687},null,{"$f":"SUM(P21:P22)","v":3394378.1397048966},null,{"$f":"SUM(R21:R22)","v":3485064.8022630466},null,{"$f":"SUM(T21:T22)","v":3560483.4609734789},null,{"$f":"SUM(V21:V22)","v":3640481.8018875481},null,{"$f":"SUM(X21:X22)","v":3731227.9561701361}]
[{"$f":"ROW()","v":24}]
[{"$f":"ROW()","v":25},null,null,"International transit and transfer passengers†",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[{"$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","Wellington International Airport Limited"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pricing Period Starting Year Ended",{"$f":"+R3","v":"2019-04-01"}]
["SCHEDULE 20: REPORT ON DEMAND FORECASTS (cont)"]
["ref","Version 4.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(#REF!),\"for year ended\",\"\")","v":""},"2019-04-01",null,"2020-04-01",null,"2021-04-01",null,"2022-04-01",null,"2023-04-01",null,"2024-04-01",null,"2025-04-01",null,"2026-04-01",null,"2027-04-01",null,"2028-04-01"]
[{"$f":"ROW()","v":37},null,"Movements during\nbusy period (total\nnumber of aircraft)","During the runway busy hour",null,32,null,30,null,30,null,31.224825745055682,null,33.105208389264014,null,32.962160085247802,null,33.314085924619505,null,32.890198190316163,null,33.093917248389452,null,33.108565840917173]
[{"$f":"ROW()","v":38},null,null,"During the runway busy day",null,328,null,276,null,288.58772153391379,null,321.94557630060501,null,341.3333826249098,null,339.85847387597579,null,343.48702790207909,null,339.11650612491093,null,341.21696458992596,null,341.36799984635417]
[{"$f":"ROW()","v":39}]
[{"$f":"ROW()","v":40},null,"Landings during year (total number of\naircraft)","Aircraft 30 tonnes MCTOW or more",null,14918.5,null,6272.454545454545,null,10865.136363636364,null,14271.818181818182,null,15886.5,null,15867.75,null,16598,null,17069.25,null,17549.75,null,17582.75]
[{"$f":"ROW()","v":41},null,null,"Aircraft 3 tonnes or more but less than 30 tonnes MCTOW",null,29226,null,21357,null,26624.500000000004,null,29291,null,30642,null,30452,null,30257.5,null,29178.5,null,29009,null,29010.5]
[{"$f":"ROW()","v":42},null,null,"Aircraft less than 3 tonnes MCTOW",null,3199.5,null,3134.818181818182,null,2909.378787878788,null,2738.939393939394,null,2596,null,2596,null,2596,null,2596,null,2596,null,2596]
[{"$f":"ROW()","v":43},null,null,"Total",null,{"$f":"SUM(F40:F42)","v":47344},null,{"$f":"SUM(H40:H42)","v":30764.272727272728},null,{"$f":"SUM(J40:J42)","v":40399.015151515152},null,{"$f":"SUM(L40:L42)","v":46301.757575757576},null,{"$f":"SUM(N40:N42)","v":49124.5},null,{"$f":"SUM(P40:P42)","v":48915.75},null,{"$f":"SUM(R40:R42)","v":49451.5},null,{"$f":"SUM(T40:T42)","v":48843.75},null,{"$f":"SUM(V40:V42)","v":49154.75},null,{"$f":"SUM(X40:X42)","v":49189.25}]
[{"$f":"ROW()","v":44}]
[{"$f":"ROW()","v":45},null,"Landings during year (total MCTOW in tonnes)","Aircraft 30 tonnes MCTOW or more",null,1148563.4599839668,null,465796.45744998479,null,817019.13256189448,null,1079329.9219595185,null,1203283.9685,null,1277875.7934999999,null,1357864.3684999999,null,1417697.0935,null,1477518.9934999999,null,1544444.0935]
[{"$f":"ROW()","v":46},null,null,"Aircraft 3 tonnes or more but less than 30 tonnes MCTOW",null,463142.83663661568,null,339476.26403680054,null,421924.31409596227,null,463594.44986940967,null,484530.62849999999,null,484898.0785,null,485292.50349999999,null,472473.67849999998,null,475303.55349999998,null,478086.42849999998]
[{"$f":"ROW()","v":47},null,null,"Aircraft less than 3 tonnes MCTOW",null,3363.7033794176482,null,3356.2225483642833,null,3069.3190322428554,null,2870.415516121428,null,2715.5120000000002,null,2715.5120000000002,null,2715.5120000000002,null,2715.5120000000002,null,2715.5120000000002,null,2715.5120000000002]
[{"$f":"ROW()","v":48},null,null,"Total",null,{"$f":"SUM(F45:F47)","v":1615070},null,{"$f":"SUM(H45:H47)","v":808628.94403514965},null,{"$f":"SUM(J45:J47)","v":1242012.7656900994},null,{"$f":"SUM(L45:L47)","v":1545794.7873450494},null,{"$f":"SUM(N45:N47)","v":1690530.1090000002},null,{"$f":"SUM(P45:P47)","v":1765489.3840000001},null,{"$f":"SUM(R45:R47)","v":1845872.3840000001},null,{"$f":"SUM(T45:T47)","v":1892886.284},null,{"$f":"SUM(V45:V47)","v":1955538.0589999999},null,{"$f":"SUM(X45:X47)","v":2025246.034}]
[{"$f":"ROW()","v":49}]
[{"$f":"ROW()","v":50},null,"Landings during year (total number of\naircraft)","Air passenger services—international",null,3319,null,1.5,null,1118,null,2756,null,3484,null,3490.25,null,3691.5,null,3815.75,null,3940.75,null,4068.25]
[{"$f":"ROW()","v":51},null,null,"Air passenger services—domestic",null,37988,null,25082.5,null,33676,null,38016,null,40186,null,39971,null,40305.5,null,39573.5,null,39759.5,null,39666.5]
[{"$f":"ROW()","v":52},null,null,"Other aircraft",null,6037,null,5680.2727272727279,null,5605.015151515152,null,5529.757575757576,null,5454.5,null,5454.5,null,5454.5,null,5454.5,null,5454.5,null,5454.5]
[{"$f":"ROW()","v":53}]
[{"$f":"ROW()","v":54},null,"Landings during year (total MCTOW in tonnes)","Air passenger services—international",null,299468,null,118.5,null,87206.6,null,215035.59999999998,null,271804,null,327479.32500000001,null,349772.4,null,364906.625,null,380094.27500000002,null,395476.125]
[{"$f":"ROW()","v":55},null,null,"Air passenger services—domestic",null,1276393,null,768823.75,null,1115138.6499999999,null,1291110.8499999999,null,1379096.95,null,1398380.9,null,1456470.825,null,1488350.5,null,1535814.625,null,1590140.75]
[{"$f":"ROW()","v":56},null,null,"Other aircraft",null,39209,null,39686.694035149616,null,39667.515690099746,null,39648.337345049869,null,39629.159,null,39629.159,null,39629.159,null,39629.159,null,39629.159,null,39629.159]
[{"$f":"ROW()","v":57},null,"Description of the basis for forecasts, and/or assumptions made in forecasting "]
[{"$f":"ROW()","v":58},null,"Passenger and Air Traffic Movements (ATM) forecasts were prepared for the period FY2020 to FY2029 based on:\n• Actual passenger numbers up to and including the period between April 2019 and February 2021; and\n• Actual ATMs up to and including the period between April 2019 and February 2021; and\n• An estimate of March 2021 based on schedule information for that month to complete FY2021 estimates.\n• There were no scheduled International services in FY21 and so International busy hour numbers are not available.\n\nPassenger forecasts capture traditional macro-economic growth drivers as well as airline driven market growth initiatives. Air Traffic Movement (ATM) forecasts were developed by applying passenger seat load factor assumptions and forecast fleet composition changes to passenger forecasts.  Assumptions relating to the recovery from Covid-19 were also overlayed. \n\nStakeholder consultations were undertaken with WIAL’s management team to understand their strategic growth plans and those of their key customers, and desk based research of publically available information was used to inform route development opportunities and fleet deployment changes. Runway extension was not included in the developed scenario. Anticipated driven market changes include:\n• Recovery post-Covid to FY2020 levels in FY2023-FY2024, with a 3-4 year lag on MP2040 growth projections\n• New trans-Tasman destinations served;\n• Future upgauging of aircraft such as the introduction of more A321 flying, phasing out of Q300 replacing with ATR flying, the return of widebody Tasman services from FY2025, and the introduction of a widebody domestic service at the end of the forecast period"]
[{"$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"]