Data tables and models

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 June 2018

Balance sheet feeder model, updated August 2018

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, July 2018

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, June 2018

 Data tables issues log, December 2017

Initial assessment of business plans pro forma, updated August 2018

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, July 2018

Business plan table – Financial model mapping tool, July 2018

Financial model change log, March 2018

Company specific data tables

Data tables for specific companies can be found here, June 2018