On this page you can find the latest data table and models for our PR19 final methodology.
Feeder models
The following are spreadsheets (xlsx). If you have difficulties opening them directly, try choosing ‘save as’ and saving them to a suitable file location
RCV adjustments feeder model, updated June 2018
Revenue adjustments feeder model, updated January 2019
Balance sheet feeder model, updated January 2019
Cost assessment FM_WW1 with APR 2018-19 data, September 2019
Cost assessment FM_WWW1 with APR 2018-19 data, September 2019
Cost assessment FM_RR1 with APR 2018-19 data, September 2019
Other models
The following are spreadsheets (xlsx). If you have difficulties opening them directly, try choosing ‘save as’ and saving them to a suitable file location
RPI-CPIH wedge reconciliation model, updated March 2018
New cost of debt reconciliation model, updated April 2018
RCV indexation illustrative model, December 2017
Cost sharing rates spreadsheet, December 2017
Bioresources modified revenue model, March 2018
Bioresources forecasting accuracy incentive model, June 2018
Revenue forecasting incentive (network plus and water resources) model, June 2018
PR19 Water trading incentive model, June 2018
Developer services incentive model, June 2018
Retail reconciliation model, June 2018
Bioresources in-period revenue correction model: This model is currently being developed and is planned for publication in June 2018
Bill Waterfall model, updated January 2019
Business plan data tables
Business plan data tables – guidance, December 2017
The following are spreadsheets (xlsx). If you have difficulties opening them directly, try choosing ‘save as’ and saving them to a suitable file location
Business plan data tables, updated January 2019
Data tables issues log, December 2017
Initial assessment of business plans pro forma, updated August 2018
Business plan data table change log, April 2019
Financial model
The following are spreadsheets (xlsx). If you have difficulties opening them directly, try choosing ‘save as’ and saving them to a suitable file location
Financial model and rulebook, updated 18 July 2019
Business plan table – Financial model mapping tool, updated January 2019
Financial model change log, March 2018
Company specific data tables
Data tables for specific companies can be found here, June 2018