The model can assist municipalities in analysing the impact of proposed SSEG tariffs on revenue and attractiveness for solar PV customers. The model generates the impact of SSEG tariffs for different uptake rates on municipal revenue and value of solar (avoided costs) for a given set of SSEG tariffs and determines if a business case exists for the PV customer (Felet, Knight, & Mahlalela, 2017)

This is an excel-based tool that calculates how municipal revenue is impacted by customers installing solar PV, as well as the business case for customers that install solar PV. The spreadsheet has 2017 Tshwane data included as an illustration, but should be updated for the particular municipality in question before use (Genesis, SALGA & GIZ, 2017).

This spreadsheet tool allows for the comparison of capital and operating costs of a solar water heater and conventional geyser for either a cash purchase or financed case; allowing for the adjustment of variables such as electricity price and price increases, discount rate, finance rate and period, system size and cost, water usage, etc. (Sustainable Energy Africa, 2017)