The Msunduzi (KZN225)

Municipal Performance Review - 2021 Q4

Brought to you by:

Powered by:

Key Financial Ratios

Description Norm Municipality Provincial Average National Average
Collection Ratio > 95% 39.3 23.8 53.0
Capital Expenditure to Total Expenditure 10-20% 11.1 13.7 12.5
Remuneration to Total Operating Expenditure 25-40% 23.3 30.1 31.1
Budget Implementation: Capital Expenditure 95-100% 293.3 95.8 80.3

Municipality achieved a collection ratio below the norm. This has a negative impact on liquidity and all efforts should be directed to improve collections as this has a direct negative impact on liquidity and sustainability. The Capital Expenditure to Total Expenditure ratio is within the norm.
The Budget Implementation for Capital Expenditure is above the acceptable norm. This is an indication of possible inefficiencies in the budgeting process, capital project management and budget control.

Financial Performance

The municipality achieved an operating deficit (excluding Capital Transfers) which increases the dependency on subsidies and grants in order to remain sustainable.

Description Planned Actual YTD Variance Variance %
Operating Revenue R6,069.6M R17,462.0M R11,392.4M 187.7%
Operating Expenditure R5,669.2M R17,490.0M R11,820.8M 208.5%
Net Surplus / Deficit R400.4M R-28.0M R-428.4M -107.0%
Capital Transfers R526.5M R1,485.3M R958.8M 182.1%
Net Surplus / Deficit - After Capital Transfers R926.9M R1,457.3M R530.4M 57.2%

Capital Expenditure

The municipality implemented 293.3 % of the planned capital expenditure as at the end of the 4th Quarter. The Net Margin of 8.3% as well as the funding sources influenced the municipality’s ability to spend the planned capital.

The highest capital expenditure occurred in the 1st quarter and represents 66.0% of the total capital expenditure YTD.

Description Planned Actual YTD Variance Variance %
Capital Expenditure R747.2M R2,191.7M R1,444.5M 193.3%

Source of Funding

National Government made the highest contribution to capital expenditure for the YTD and accounted for 98.5%

Cash Flow

Description Planned YTD Actual Variance Variance %
Cash Flow from Operating Activities R133.3M R10,506.4M R-10,373.1M 7 782.0%
Cash Flow from Investing Activities R-3.0M R-48.7M R45.8M 1 541.5%
Cash Flow from Financing Activities R0.0M R-9.0M R9.0M -Inf
Net Cash Flow R130.3M R10,448.7M R-10,318.3M 7 917.4%

Debtors Ageing

The municipality has a total outstanding debtors balance of R4,777.1M with total bad debt written off of R23,509.2M and impairment of debt amounts to R0.0M.

Debtors Ageing by Customer Group

Description Current 30 Days 60 Days Over 90 Days Total Bad Debt Impairment
Organs of State R37.0M R8.3M R8.1M R185.2M R238.5M R789.5M R0.0M
Commercial R234.3M R42.4M R20.2M R456.7M R753.6M R2,237.6M R0.0M
Households R218.9M R82.9M R70.5M R3,195.9M R3,568.2M R19,051.6M R0.0M
Other R5.7M R5.3M R4.0M R201.8M R216.8M R1,430.5M R0.0M

Debtors Ageing by Income Source

Description Current 30 Days 60 Days Over 90 Days Total Bad Debt Impairment
Water R124.4M R40.6M R36.4M R1,606.8M R1,808.2M R9,860.7M R0.0M
Electricity R126.2M R39.3M R11.9M R227.8M R405.2M R875.9M R0.0M
Property Rates R159.3M R30.5M R27.9M R806.2M R1,024.0M R4,055.2M R0.0M
Waste Water Management R25.5M R6.2M R6.0M R263.4M R301.2M R1,865.5M R0.0M
Waste Management R13.6M R3.6M R3.1M R147.2M R167.5M R1,038.9M R0.0M
Property Rental Debtors R3.0M R0.5M R1.0M R47.1M R51.7M R326.2M R0.0M
Interest on Arrear Debtor Accounts R34.6M R18.2M R16.2M R730.3M R799.2M R2,421.9M R0.0M
Other R9.3M R0.0M R0.2M R210.6M R220.2M R3,064.9M R0.0M

Creditors Ageing

The municipality has a total outstanding creditors balance of R1,656.5M with total outstanding more than 90 days of R0.0M(0.0%).

Description Current 30 Days 60 Days Over 90 Days Total
Bulk Electricity R297.7M R0.0M R0.0M R0.0M R297.7M
Bulk Water R199.6M R93.7M R58.6M R0.0M R351.9M
VAT (output less input) R213.0M R0.0M R0.0M R0.0M R213.0M
Trade Creditors R147.2M R25.6M R10.2M R0.0M R183.0M
Auditor-General R0.2M R0.0M R0.0M R0.0M R0.2M
Other R610.8M R0.0M R0.0M R0.0M R610.8M


Disclaimer: The analyis was caried out on the Quarter 4 Reports obtained from National Treasury and they are publically available. We do not provide any assurance on the accuracy of the data, reporting or analysis.