Download Financial model user guide

Setting price controls for 2015-20: PR14 financial model user guide
September 2014
_________________________________________________________________________________
Input sheets
2.27
There are four input sheets for the model.
•
•
•
•
F_Inputs – inputs for the wholesale and retail sections.
Adjustments – adjustments to the F_Inputs data, which can be used by
Ofwat to adjust data submitted by companies. This is used primarily to
adjust for inconsistent input data. Companies wishing to override their
non-household default tariffs with total non-household cost to serve and
margin should enter this information on the adjustment sheet. If the nonhousehold default tariffs are overridden the blended debtor days should
also be entered.
Inputs Real – linked directly to the F_Inputs sheet and used to drive real
calculations.
Inputs Nominal – inflated from the Inputs Real sheet and used to drive
nominal calculations.
Navigating the ‘Inputs Real’ sheet
Overview of input sheet – ‘collapsed’ level
2.28
The ‘Inputs Real’ sheet is divided into several sections according to the
source of the data and the calculations that use it. These are:
•
•
•
•
•
•
•
•
•
•
•
•
regulated capital value (RCV);
fixed assets;
working capital;
other income and cash flow items;
tax;
debt;
equity;
adjustment inputs;
post-financeability adjustments;
reprofiled Allowed Revenue, grants and contributions;
customer projections (to be used on Executive Summary sheet); and
model parameters.
2.29 Note that there is also a separate input sheet, ‘F_Inputs’. The ‘F_Inputs’ sheet
is where the base data should be populated. Manual user inputs, and inputs
_________________________________________________________________________________
14