jagomart
digital resources
picture1_Calc Spreadsheet 46556 | Land Disposals Sve Fd


 196x       Filetype XLSX       File size 0.03 MB       Source: www.ofwat.gov.uk


File: Calc Spreadsheet 46556 | Land Disposals Sve Fd
sheet 1 change log change log issue change sheet row feb19 1 calculation of the pv effect of 50 of proceeds from disposals of interest in land multiplies the impact ...

icon picture XLSX Filetype Excel XLSX | Posted on 18 Aug 2022 | 3 years ago
Partial file snippet.
Sheet 1: Change Log
Change log











# Issue Change Sheet Row






Feb-19 1 Calculation of the PV effect of 50% of proceeds from disposals of interest in land multiplies the impact of 50% of the proceeds by the discount factor. Formula corrected to divide the impact of 50% of the proceeds by the discount factor. This is consistent with the correction in the 31 January version of the business plan tables, table App9. Calc 11, 22 and 33

Sheet 2: F_Inputs


PR19PD003_IN







Acronym Reference Item description Unit Model 2014-15 2015-16 2016-17 2017-18 2018-19 2019-20
















Price Review 2019 Price Review 2019 Price Review 2019 Price Review 2019 Price Review 2019 Price Review 2019





PR19 Run 8: Final Determinations PR19 Run 8: Final Determinations PR19 Run 8: Final Determinations PR19 Run 8: Final Determinations PR19 Run 8: Final Determinations PR19 Run 8: Final Determinations





Latest Latest Latest Latest Latest Latest
SVE A7001W RCV midnight adjustment ~ land sales water - Forecast at previous review £m Price Review 2019 3.986




SVE BT39301PW Proceeds from disposals of protected land - Water £000 Price Review 2019 4,960 7,717 2,834 3,246 3,890 503
SVE A7004AW RCV midnight adjustment ~ land sales water - WACC - fully post tax on notional structure % Price Review 2019 3.60% 3.60% 3.60% 3.60% 3.60% 3.60%
SVE A7004BW RCV midnight adjustment ~ land sales water - RPI: Financial year average year on year % % Price Review 2019 2.54% 2.54% 2.54% 2.54% 2.54% 2.54%
SVE A7004W RCV midnight adjustment ~ land sales water - Discount rate (nominal) % Price Review 2019 6.14% 6.14% 6.14% 6.14% 6.14% 6.14%
SVE A7001WW RCV midnight adjustment ~ land sales wastewater - Forecast at previous review £m Price Review 2019 4.655




SVE BT39301PS Proceeds from disposals of protected land - Wastewater £000 Price Review 2019 4,698 4,864 9,136 1,576 7,425 6,746
SVE A7004AWW RCV midnight adjustment ~ land sales wastewater - WACC - fully post tax on notional structure % Price Review 2019 3.60% 3.60% 3.60% 3.60% 3.60% 3.60%
SVE A7004BWW RCV midnight adjustment ~ land sales wastewater - RPI: Financial year average year on year % % Price Review 2019 2.54% 2.54% 2.54% 2.54% 2.54% 2.54%
SVE A7004WW RCV midnight adjustment ~ land sales wastewater - Discount rate (nominal) % Price Review 2019 6.14% 6.14% 6.14% 6.14% 6.14% 6.14%
SVE A7001DMMY RCV midnight adjustment ~ land sales wastewater - Forecast at previous review £m Price Review 2019 0.000




SVE BT39301PTTT Land sales - Proceeds from disposals of protected land (TTT) £000 Price Review 2019 0.000 0.000 0.000 0.000
0.000
SVE A7004ADMMY RCV midnight adjustment ~ land sales wastewater - WACC - fully post tax on notional structure % Price Review 2019





SVE A7004BDMMY RCV midnight adjustment ~ land sales wastewater - RPI: Financial year average year on year % % Price Review 2019





SVE A7004DMMY RCV midnight adjustment ~ land sales wastewater - Discount rate (nominal) % Price Review 2019






Sheet 3: InpOverride
Acronym Reference Item description Unit Model 2014-15 2015-16 2016-17 2017-18 2018-19 2019-20

















Price Review 2019 Price Review 2019 Price Review 2019 Price Review 2019 Price Review 2019 Price Review 2019





PR19 RUN 1: early view of past delivery PR19 RUN 1: early view of past delivery PR19 RUN 1: early view of past delivery PR19 RUN 1: early view of past delivery PR19 RUN 1: early view of past delivery PR19 RUN 1: early view of past delivery





Latest Latest Latest Latest Latest Latest Action /
Intervention
reference
SVE A7001W RCV midnight adjustment ~ land sales water - Forecast at previous review £m Price Review 2019






SVE BT39301PW Proceeds from disposals of protected land - Water £000 Price Review 2019






SVE A7004AW RCV midnight adjustment ~ land sales water - WACC - fully post tax on notional structure % Price Review 2019






SVE A7004BW RCV midnight adjustment ~ land sales water - RPI: Financial year average year on year % % Price Review 2019






SVE A7004W RCV midnight adjustment ~ land sales water - Discount rate (nominal) % Price Review 2019






SVE A7001WW RCV midnight adjustment ~ land sales wastewater - Forecast at previous review £m Price Review 2019






SVE BT39301PS Proceeds from disposals of protected land - Wastewater £000 Price Review 2019






SVE A7004AWW RCV midnight adjustment ~ land sales wastewater - WACC - fully post tax on notional structure % Price Review 2019






SVE A7004BWW RCV midnight adjustment ~ land sales wastewater - RPI: Financial year average year on year % % Price Review 2019






SVE A7004WW RCV midnight adjustment ~ land sales wastewater - Discount rate (nominal) % Price Review 2019






SVE A7001DMMY RCV midnight adjustment ~ land sales wastewater - Forecast at previous review £m Price Review 2019






SVE BT39301PTTT Land sales - Proceeds from disposals of protected land (TTT) £000 Price Review 2019






SVE A7004ADMMY RCV midnight adjustment ~ land sales wastewater - WACC - fully post tax on notional structure % Price Review 2019






SVE A7004BDMMY RCV midnight adjustment ~ land sales wastewater - RPI: Financial year average year on year % % Price Review 2019






SVE A7004DMMY RCV midnight adjustment ~ land sales wastewater - Discount rate (nominal) % Price Review 2019







The words contained in this file might help you see if this file matches what you are looking for:

...Sheet change log issue row feb calculation of the pv effect proceeds from disposals interest in land multiplies impact by discount factor formula corrected to divide this is consistent with correction january version business plan tables table app calc and f inputs prpd acronym reference item description unit model price review pr run final determinations latest sve aw rcv midnight adjustment sales water forecast at previous pound m btpw protected aaw wacc fully post tax on notional structure abw rpi financial year average rate nominal aww wastewater btps aaww abww admmy btpttt ttt aadmmy abdmmy inpoverride early view past delivery action interventionreference...

no reviews yet
Please Login to review.