Spreadsheet: 51fcb3d9-04d8-441a-af69-6172a9a97adb
Sheet: HAL - iBP 

 | Heathrow - Initial Business Plan - July 2012
 | July 2012 IBP Forecast | Q5 |  |  |  |  | Q5+1 | Q6 |  |  |  |  |  |  | July 2012 IBP Forecast - Summary |  |  |  |  | July 2012 IBP Forecast - Summary
 | £m nominal | 2008/09 | 2009/10 | 2010/11 | 2011/12 | 2012/13 | 2013/14 | 2014/15 | 2015/16 | 2016/17 | 2017/18 | 2018/19 |  |  | £m nominal | Total Q5+1 | % of Total | CAGR (Q5+1) |  | £m nominal | Total Q6 | % of Total | CAGR (Q6)
 | Security Costs |  |  |  |  |  |  |  |  |  |  |  |  |  | Security Costs |  |  |  |  | Security Costs
 | Staff Costs  - Other Operational |  |  |  |  |  |  |  |  |  |  |  |  |  | Staff Costs  - Other Operational |  |  |  |  | Staff Costs  - Other Operational
 | Facilities Management |  |  |  |  |  |  |  |  |  |  |  |  |  | Facilities Management |  |  |  |  | Facilities Management
 | Utilities |  |  |  |  |  |  |  |  |  |  |  |  |  | Utilities |  |  |  |  | Utilities
 | Rent and Rates |  |  |  |  |  |  |  |  |  |  |  |  |  | Rent and Rates |  |  |  |  | Rent and Rates
 | Central Support Services |  |  |  |  |  |  |  |  |  |  |  |  |  | Central Support Services |  |  |  |  | Central Support Services
 | Rail |  |  |  |  |  |  |  |  |  |  |  |  |  | Rail |  |  |  |  | Rail
 | Commercial Expenditure |  |  |  |  |  |  |  |  |  |  |  |  |  | Commercial Expenditure |  |  |  |  | Commercial Expenditure
 | Other |  |  |  |  |  |  |  |  |  |  |  |  |  | Other |  |  |  |  | Other
 | Pensions |  |  |  |  |  |  |  |  |  |  |  |  |  | Pensions |  |  |  |  | Pensions
 | Total |  |  |  |  |  |  |  |  |  |  |  |  |  | Total |  |  |  |  | Total
 | Impact of T1 Closure |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Impact of T1 Closure
 | SQR at 5 mins queuing in transfers |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SQR at 5 mins queuing in transfers
 | Increase opex saving by 0.2% |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Increase opex saving by 0.2%
 | Total Q6 after Adjustments |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Q6 after Adjustments
 | Passengers (m) | 65.9 | 66.1 | 66.1 | 70.1 | 69.2 | 69.1 |  |  |  |  |  |  |  | Passengers (m) |  |  |  |  | Passengers (m)
 | Total opex / passenger |  |  |  |  |  |  |  |  |  |  |  |  |  | Total opex / passenger |  |  |  |  | Total opex / passenger
 | Price Base Conversion 2012/13 to Nominal
 | July 2012 IBP Forecast | Q5 |  |  |  |  | Q5+1 | Q6 |  |  |  |  |  |  | July 2012 IBP Forecast - Summary |  |  |  |  | July 2012 IBP Forecast - Summary
 | £m 2012/13 prices | 2008/09 | 2009/10 | 2010/11 | 2011/12 | 2012/13 | 2013/14 | 2014/15 | 2015/16 | 2016/17 | 2017/18 | 2018/19 |  |  | £m 2012/13 prices | Total Q5+1 | % of Total | CAGR (Q5+1) |  | £m 2012/13 prices | Total Q6 | % of Total | CAGR (Q6)
 | Security Costs | 181 | 173 | 167 | 168 | 161 | 179 | 180 | 178 | 169 | 169 | 169 |  |  | Security Costs |  |  |  |  | Security Costs
 | Staff Costs  - Other Operational | 64 | 54 | 56 | 55 | 57 | 56 | 60 | 61 | 58 | 58 | 58 |  |  | Staff Costs  - Other Operational |  |  |  |  | Staff Costs  - Other Operational
 | Facilities Management | 178 | 183 | 166 | 169 | 175 | 192 | 221 | 215 | 210 | 208 | 206 |  |  | Facilities Management |  |  |  |  | Facilities Management
 | Utilities | 93 | 120 | 95 | 87 | 92 | 93 | 102 | 101 | 97 | 99 | 98 |  |  | Utilities |  |  |  |  | Utilities
 | Rent and Rates | 118 | 125 | 112 | 120 | 126 | 130 | 154 | 167 | 167 | 167 | 167 |  |  | Rent and Rates |  |  |  |  | Rent and Rates
 | Central Support Services | 123 | 110 | 125 | 123 | 143 | 111 | 112 | 111 | 108 | 107 | 106 |  |  | Central Support Services |  |  |  |  | Central Support Services
 | Rail | 73 | 77 | 75 | 66 | 66 | 67 | 60 | 59 | 59 | 60 | 60 |  |  | Rail |  |  |  |  | Rail
 | Commercial Expenditure | 42 | 56 | 45 | 44 | 46 | 48 | 51 | 52 | 50 | 51 | 51 |  |  | Commercial Expenditure |  |  |  |  | Commercial Expenditure
 | Other | 159 | 153 | 146 | 156 | 166 | 126 | 117 | 113 | 114 | 114 | 112 |  |  | Other |  |  |  |  | Other
 | Pensions | 35 | 26 | 33 | 36 | 32 | 34 | 78 | 76 | 74 | 73 | 72 |  |  | Pensions |  |  |  |  | Pensions
 | Total |  |  |  |  |  |  |  |  |  |  |  |  |  | Total |  |  |  |  | Total
 | Impact of T1 Closure |  |  |  |  |  |  |  |  | -31 | -32 | -32 |  |  |  |  |  |  |  | Impact of T1 Closure
 | SQR at 5 mins queuing in transfers |  |  |  |  |  |  | 5 | 5 | 5 | 5 | 5 |  |  |  |  |  |  |  | SQR at 5 mins queuing in transfers
 | Increase opex saving by 0.2% |  |  |  |  |  |  | -3 | -5 | -8 | -11 | -14 |  |  |  |  |  |  |  | Increase opex saving by 0.2%
 | Total Q6 after Adjustments |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Q6 after Adjustments
 | Passengers (m) | 65.9 | 66.1 | 66.1 | 70.1 | 69.2 | 69.1 | 69.2 | 70.1 | 71.1 | 71.8 | 72.6 |  |  | Passengers (m) |  |  |  |  | Passengers (m)
 | Total opex / passenger |  |  |  |  |  |  |  |  |  |  |  |  |  | Total opex / passenger |  |  |  |  | Total opex / passenger
 | Price Base Conversion 2012/13 to 2011/12
 | July 2012 IBP Forecast | Q5 |  |  |  |  | Q5+1 | Q6 |  |  |  |  |  |  | July 2012 IBP Forecast - Summary |  |  |  |  | July 2012 IBP Forecast - Summary
 | £m 2011/12 prices | 2008/09 | 2009/10 | 2010/11 | 2011/12 | 2012/13 | 2013/14 | 2014/15 | 2015/16 | 2016/17 | 2017/18 | 2018/19 |  |  | £m 2011/12 prices | Total Q5+1 | % of Total | CAGR (Q5+1) |  | £m 2011/12 prices | Total Q6 | % of Total | CAGR (Q6)
 | Security Costs |  |  |  |  |  |  |  |  |  |  |  |  |  | Security Costs |  |  |  |  | Security Costs
 | Staff Costs  - Other Operational |  |  |  |  |  |  |  |  |  |  |  |  |  | Staff Costs  - Other Operational |  |  |  |  | Staff Costs  - Other Operational
 | Facilities Management |  |  |  |  |  |  |  |  |  |  |  |  |  | Facilities Management |  |  |  |  | Facilities Management
 | Utilities |  |  |  |  |  |  |  |  |  |  |  |  |  | Utilities |  |  |  |  | Utilities
 | Rent and Rates |  |  |  |  |  |  |  |  |  |  |  |  |  | Rent and Rates |  |  |  |  | Rent and Rates
 | Central Support Services |  |  |  |  |  |  |  |  |  |  |  |  |  | Central Support Services |  |  |  |  | Central Support Services
 | Rail |  |  |  |  |  |  |  |  |  |  |  |  |  | Rail |  |  |  |  | Rail
 | Commercial Expenditure |  |  |  |  |  |  |  |  |  |  |  |  |  | Commercial Expenditure |  |  |  |  | Commercial Expenditure
 | Other |  |  |  |  |  |  |  |  |  |  |  |  |  | Other |  |  |  |  | Other
 | Pensions |  |  |  |  |  |  |  |  |  |  |  |  |  | Pensions |  |  |  |  | Pensions
 | Total |  |  |  |  |  |  |  |  |  |  |  |  |  | Total |  |  |  |  | Total
 | Impact of T1 Closure |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Impact of T1 Closure
 | SQR at 5 mins queuing in transfers |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SQR at 5 mins queuing in transfers
 | Increase opex saving by 0.2% |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Increase opex saving by 0.2%
 | Total Q6 after Adjustments |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Q6 after Adjustments
 | Passengers (m) |  |  |  |  |  |  |  |  |  |  |  |  |  | Passengers (m) |  |  |  |  | Passengers (m)
 | Total opex / passenger |  |  |  |  |  |  |  |  |  |  |  |  |  | Total opex / passenger |  |  |  |  | Total opex / passenger
 | End