Filetype Excel XLSX | Posted on 15 Aug 2022 | 3 years ago
Authentication
digital resources
176x Filetype XLSX File size 0.36 MB Source: www.ofwat.gov.uk
Sheet 1: Cover
| Cover | ||
| Model name: | Inflation Model | |
| Version number: | 1c | |
| Filename: | ||
| Date: | Thursday, July 18, 2019 | |
| Author: | Kleem Malik & Thomas Jones | |
| Author contact information: | kleem.malik@ofwat.gov.uk | |
| thomas.jones@ofwat.gov.uk | ||
| Sponsor: | Robert Thorp | |
| robert.thorp@ofwat.gov.uk | ||
| Summary | ||
| This model is to give a definitive view of inflation for the PR19 modelling process. Users can use company data, ONS inflation statistics | ||
| or override for their own view of inflation. | ||
| Checks | ||
| - | checks | |
| Known issues | ||
| na |
| Adjustments log | |||
| Run | 7 | ||
| Type | Notional | ||
| Stage | Ofwat (DD) | ||
| # | Description | Location | Link |
| 1 | Dataset to use - Override | ||
| The Ofwat view of inflation has been populated using the override sheet on InpOverride. The forecast values highlighted in green have been populated using ONS forecasts, values highlighted in blue have been popluated using OBR forecasts. | InpOverride | 3 | |
| InpOverride | 279.7 | ||
| InpOverride | 105.5 |
| Userguide | |||||||||||||||||||||||||||
| ToC | |||||||||||||||||||||||||||
| Inputs | Calculations | Outputs | |||||||||||||||||||||||||
| Cover | Time | Outputs | |||||||||||||||||||||||||
| Model documentation sheet | Flags, part period factors (PPFs) and dates | Summary of outputs | |||||||||||||||||||||||||
| Userguide | Inflation | F_Outputs | |||||||||||||||||||||||||
| Explanation of different formatting types | Using the inputs, controls and flags to | Summary of outputs ready to be exported to fountain | |||||||||||||||||||||||||
| select the approriate inflation rates | |||||||||||||||||||||||||||
| F_Inputs | Check | ||||||||||||||||||||||||||
| Company inputs from Fountain | Checks | ||||||||||||||||||||||||||
| ONS RPI Inputs | |||||||||||||||||||||||||||
| ONS RPI data | |||||||||||||||||||||||||||
| ONS CPIH Inputs | |||||||||||||||||||||||||||
| ONS CPIH data | |||||||||||||||||||||||||||
| InpOverride | |||||||||||||||||||||||||||
| Override inputs and controls | |||||||||||||||||||||||||||
| Userguide | |||||||||||||||||||||||||||
| The inflation model is designed to allow users the select an approriate measure of inflation. | |||||||||||||||||||||||||||
| Data can come from a number of sources and the mdoel has a number of input sheets as follows; | |||||||||||||||||||||||||||
| 1) F_inputs - company data (via business plan tables and fountain). This sheet would pull in the companies actual and forecast inflation as submitted in their business plan tables. | |||||||||||||||||||||||||||
| 2) ONS RPI Inputs and ONS CPIH inputs - these sheets are used to provide actual inflation data as measured by the ONS. A link is available on each of these sheets to the respective data sets | |||||||||||||||||||||||||||
| 3) InpOverride - this sheet allows users to override the inflation rates with their own view of inflation, or, if data is not available apply generic growth assumptions to show appropriate indexes | |||||||||||||||||||||||||||
| The user can select which data sets to use using the controls on InpOverride for 'data set to use' in cell F34. | |||||||||||||||||||||||||||
| Data set to use | 3 | ||||||||||||||||||||||||||
| If for some reason the data set selected in not a complete set the model will use generic assuptions as input by the user to fill in any missing data using 'Growth Rate to use if no data available' on InpOverride cells F81 and F82 | |||||||||||||||||||||||||||
| CPIH rate to use if data unavailable | 2.00% | ||||||||||||||||||||||||||
| RPI rate to use if data unavailable | 3.00% | ||||||||||||||||||||||||||
| The selected inflation rates are then calculated in the 'Inflation' before being copied to the 'Outputs' sheet. | |||||||||||||||||||||||||||
| The model also uses a fountain ready 'F_Outputs' sheet to export the selected inflation rates to fountain ready to be used in other models. | |||||||||||||||||||||||||||
| End of sheet |
no reviews yet
Please Login to review.
