Development of financial model compliant with FAST modelling standard
key details
| Value | £35,650 |
|---|---|
| Status | complete |
| Category (CPV) | 72000000 |
| Region | West Midlands, London |
| Deadline | 28 Oct 2016 |
| Contract start | 22 Nov 2016 |
| Contract end | 24 Feb 2017 |
| SME suitable | Yes |
| OCID | ocds-b5fd17-c561a599-2b75-4629-a541-fcead1406e15 |
Award
| Supplier | Value | Date | Status |
|---|---|---|---|
| F1F9 UK Ltd | £35,650 | 21 Nov 2016 | active |
description
For PR14 Ofwat developed a financial model in partnership with PwC. The PR14 financial model had three purposes.
| • | To determine the wholesale price controls. |
| • | To calculate the revenues arising from the retail price controls. |
| • | To help assess financeability of the appointee, with the ability to refine the wholesale price control limits until target financeability indicators are satisfied. |
The model went through significant development during the price review process, with six versions of the financial model being published.
Ofwat has rebuilt the PR14 Financial Model in accordance with the FAST modelling standard.
The rebuilt model replicates the core calculations of the PR14 financial model in a simpler structure. This model replicates very closely the allowed revenue and financeability indicator results from PR14. The design approach for the redesigned model uses a reduced set of live financial statements with phases turned on and off with 'flags'.
The rebuilt model will provide a solid framework for implementing the modelling changes required to reflect Ofwat's developing Water 2020 methodology.
Objectives and scope of the work
The primary purpose of this work is to continue the development of the rebuilt, simplified, financial model in a way that is compliant with the FAST modelling standard. The work will cover the period November 2016 - 24 February 2017, the Project Manager will keep the timeframe under review and where necessary may opt to extend the timeframe.
The work will focus on six areas:
| • | RPI / CPI (H) - to enable the model to deal with two forms of indexation |
| • | Separate RCVs - Create multiple RCV accounts to track guaranteed balances and RPI and CPI(H) indexed balances |
| • | 4 x wholesale controls - Bifurcate water and wastewater controls. |
| • | Monte Carlo analysis - Establish architecture to implement @risk analysis of key variables. |
| • | Sensitivity analysis - Establish architecture for sensitivity analysis. |
| • | Improve notionalisation - PR14 used a lengthy process (detailed in the PR14 financial model user guide) to move from actual to notional capital structure. The aim of this work is to streamline this process. |
The model is expected to make minimal use of macros and to make minimal use of named ranges (in accordance with FAST standard "FAST 3.03-08").
notice history
1 notice published against this procurement.
| Published | Type | Regime | Notice |
|---|---|---|---|
| 20 Mar 2017 | Award update (awardUpdate) | · | 1478d546-a32b-47ca-a3e7-749bbaf2b881-136702 |
more from WATER SERVICES REGULATION AUTHORITY
- Independent Monitor · 28 Apr 2026
- Marketing · 3 Oct 2025
- WEC Customer Research · 3 Oct 2025
- Ofwat Consultancy Framework · 15 Dec 2020
- Board Effectiveness Review · £19,481 · 11 Feb 2020
- Call off for Special Financial Support · 11 Feb 2020
- C-MeX and D-MeX Shadow Year Research for Price Review 2019 · £359,945 · 15 Jan 2020
- Legal Advice to Ofwat · 31 Jan 2019
all contracts from this buyer →
similar contracts awarded
Other awarded contracts in the same category. Useful for seeing who normally wins this kind of work, and at what value.
- Digital Asset Management Solution · Metropolitan Police Service · £10,812,672
- Housing Digital Workstream Consultants · Sheffield City Council · £29,313
- Card Medic Licence Renewal · University Hospitals Sussex NHS Foundation Trust · £96,000
- Customer Feedback System · Kent County Council · £157,625
- WHTHT - Remote Clinical Coding Services · West Hertfordshire Teaching Hospitals NHS Trust · £260,000
- CST238 Engagement of an Implementation Partner for the Implementation of SAP SuccessFactors · Derbyshire County Council · £1,800,000
- SSL Certificates 2026 · Department for Work and Pensions · £670,000
- Support for Agile Technology Project Delivery · Financial Conduct Authority · £300,000
source
Published on Contracts Finder. Contact details for named individuals are not reproduced on this site.