Excel Probably you have ...

Published October 22, 2014 08:01 by Jarit van de Visch, Royal HaskoningDHV - Financial Expert / Water Stewardship expert

Excel

Probably you have already done this yourself, but I always calculate tariffs in Excel for which I develop a financial model. This financial model is based on a standard model that I created in the past (based on the FAST standard).

I adapt this standard to local needs, i.e. local tariff regulations, the tariff methodology that we choose to use, available data at the utility, etc. The model is "dummy-proof", so that the utility is able to use the model in the future and continue calculating tariffs.

This means that the utility only needs to adapt the data in 1 or max. 2 input sheets, while the results (tariff and graphs regarding cashflow and profit) are presented in a dashboard. The dashboard also allows for scenarios to be analysed. The complex part, the calculations, are separated. The utility can have a look at the calculations, but does not need to adapt anything in these sheets.