Development of financial model compliant with FAST modelling standard
The Water Services Regulation Authority · West Midlands
Key facts
- Contract value
- £35,650
- Awarded
- 21 Nov 2016
- Contract starts
- 22 Nov 2016
- Contract ends
- 24 Feb 2017
- Procedure
- Other -
- Buyer type
- Central government
Awarded to
| Supplier | Value |
|---|---|
| F1F9 UK Limited | £35,650 |
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").
Categories (CPV)
- 72000000 IT services: consulting, software development, Internet and support
Similar open tenders
Ireland West SDZ Designated Activity Company DAC is seeking consultancy services to support the development of an Aviation Circular Economy Hub at Ireland West Airport Knock.
Location: IrelandBuyer: Mayo County Council
Open tenderCloses 24 Nov, 202619 daysValue €125.00KSource TEDMCC are publishing this competition on behalf of Ireland West SDZ Designated Activity Company. The brief is to undertake the market validation, technical, commercial and operational planning development work necessary to establish the proposed Hub’s viability. The tenderer shall identify an appropriate operating model
EMMS Cyber Security SME Support Programme
Location: Yorkshire and the HumberBuyer: Lincolnshire County Council
Open tenderCloses 18 Nov, 202613 daysValue £65.00kSource Find a TenderIndustrial Cyber Security pilot programme aimed at improving cyber resilience readiness within SME manufacturing businesses. This exercise is being led by the LCC on behalf of Leicestershire, Nottinghamshire, Derbyshire, Northamptonshire, and Greater Lincolnshire.
Digital Connectivity Programme - 1gb Broadband Install and Service Delivery
Location: ScotlandBuyer: North Lanarkshire Council
Open tenderCloses 8 Dec, 202633 daysValue £85.45mSource Find a TenderNorth Lanarkshire Council (the “Council”) is undertaking a major digital transformation programme to deliver gigabit capable broadband connectivity to approximately 37,000 Council owned social housing properties across the authority area. The programme is a core component of the Council’s Digital Connectivity Masterpla
The Spencer Academy Trusts Microsoft Licensing & Support Services
Location: East MidlandsBuyer: THE SPENCER ACADEMIES TRUST
Open tenderCloses 23 Nov, 202618 daysValue £525.00kSource Find a TenderSpencer Academies Trust is seeking a suitably qualified supplier to provide Microsoft Licensing and Support Services. The contract will include the provision, management and support of the Trust's Microsoft licensing estate, including Microsoft 365 A3 and Microsoft 365 A5 licensing, licence administration, subscription
ICT Network Support Services for Tailte Éireann
Location: IrelandBuyer: Tailte Éireann
Open tenderCloses 8 Dec, 202633 daysValue €800.00KSource TEDThe provision of Network maintenance, software and related services to support Tailte Éireanns network infrastructure. The network equipment and services the subject of this tender consists of Cisco and Dell switches and routers and any attached equipment such as GBIC’s etc
Contract for Education and Outreach Programme Management Services
Location: IrelandBuyer: Department of Culture Communications Sport
Open tenderCloses 11 Dec, 202636 daysValue €320.00KSource TEDThe National Archives has been very successful in recent years in broadening the understanding of our role as the keeper of the records of the State amongst the general public. This enhanced public engagement has seen more people visit the National Archives online and in person(outside of the usual academics and resear