{"indicators":{"grants":{"totals":{"2021":{"ACT":{"equitable_share":383409755.0,"national_conditional_grants":327795694.0},"ORGB":{"equitable_share":3081195000.0,"national_conditional_grants":3674430000.0},"SCHD":{"national_conditional_grants":896287000.0},"TRFR":{"national_conditional_grants":532728000.0}},"2022":{"ACT":{"national_conditional_grants":1509827810.0},"ORGB":{"equitable_share":3215174000.0,"national_conditional_grants":4062911000.0},"SCHD":{"national_conditional_grants":1871879000.0},"TRFR":{"national_conditional_grants":1784465000.0}},"2023":{"ACT":{"national_conditional_grants":2211085099.0},"ORGB":{"equitable_share":3656394000.0,"provincial_transfers":1702597000.0,"national_conditional_grants":3272799000.0},"SCHD":{"national_conditional_grants":2503832000.0},"TRFR":{"national_conditional_grants":2366471000.0}},"2024":{"ACT":{"national_conditional_grants":2787622210.0},"ORGB":{"equitable_share":4066769000.0,"national_conditional_grants":3825359000.0},"SCHD":{"national_conditional_grants":2844442000.0},"TRFR":{"national_conditional_grants":2772347000.0}}},"snapshot_date":{"year":2025,"quarter":"3"},"equitable_share":{"2021":[{"amount.sum":383409755.0,"grant.code":"ESG","grant.label":"Local Government Equitable Share","amount_type.code":"ACT","financial_year_end.year":2021},{"amount.sum":3081195000.0,"grant.code":"ESG","grant.label":"Local Government Equitable Share","amount_type.code":"ORGB","financial_year_end.year":2021}],"2022":[{"amount.sum":3215174000.0,"grant.code":"ESG","grant.label":"Local Government Equitable Share","amount_type.code":"ORGB","financial_year_end.year":2022}],"2023":[{"amount.sum":3656394000.0,"grant.code":"ESG","grant.label":"Local Government Equitable Share","amount_type.code":"ORGB","financial_year_end.year":2023}],"2024":[{"amount.sum":4066769000.0,"grant.code":"ESG","grant.label":"Local Government Equitable Share","amount_type.code":"ORGB","financial_year_end.year":2024}]},"provincial_transfers":{"2023":[{"amount.sum":685086000.0,"grant.code":"0002","grant.label":"Health","amount_type.code":"ORGB","financial_year_end.year":2023},{"amount.sum":524254000.0,"grant.code":"0004","grant.label":"Public Works, Roads and Transport","amount_type.code":"ORGB","financial_year_end.year":2023},{"amount.sum":63542000.0,"grant.code":"0006","grant.label":"Sport, Arts and Culture","amount_type.code":"ORGB","financial_year_end.year":2023},{"amount.sum":25863000.0,"grant.code":"0007","grant.label":"Housing and Local Government","amount_type.code":"ORGB","financial_year_end.year":2023},{"amount.sum":403852000.0,"grant.code":"0009","grant.label":"Other Departments","amount_type.code":"ORGB","financial_year_end.year":2023}]},"national_conditional_grants":{"2021":[{"amount.sum":9000000.0,"grant.code":"EEDG","grant.label":"Energy Efficiency and Demand Side Management (Municipal) Grant","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":3000000.0,"grant.code":"EEDG","grant.label":"Energy Efficiency and Demand Side Management (Municipal) Grant","amount_type.code":"TRFR","financial_year_end.year":2021},{"amount.sum":331839.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"ACT","financial_year_end.year":2021},{"amount.sum":1000000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":1000000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"TRFR","financial_year_end.year":2021},{"amount.sum":2925048.0,"grant.code":"ICDG","grant.label":"Integrated City Development Grant","amount_type.code":"ACT","financial_year_end.year":2021},{"amount.sum":-5299.0,"grant.code":"INEG","grant.label":"Integrated National Electrification Programme (Municipal) Grant","amount_type.code":"ACT","financial_year_end.year":2021},{"amount.sum":1794325.0,"grant.code":"ISDG","grant.label":"Infrastructure Skills Development Grant","amount_type.code":"ACT","financial_year_end.year":2021},{"amount.sum":11000000.0,"grant.code":"ISDG","grant.label":"Infrastructure Skills Development Grant","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":6000000.0,"grant.code":"ISDG","grant.label":"Infrastructure Skills Development Grant","amount_type.code":"TRFR","financial_year_end.year":2021},{"amount.sum":153100.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2021},{"amount.sum":13025611.0,"grant.code":"MISG","grant.label":"Municipal Systems Improvement Grant","amount_type.code":"ACT","financial_year_end.year":2021},{"amount.sum":3600000.0,"grant.code":"ND7G","grant.label":"Neighbourhood Development Partnership (Schedule 6B)","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":31936000.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":14042000.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"TRFR","financial_year_end.year":2021},{"amount.sum":89029289.0,"grant.code":"PTCG","grant.label":"Public Transport Network Grant","amount_type.code":"ACT","financial_year_end.year":2021},{"amount.sum":794979000.0,"grant.code":"PTCG","grant.label":"Public Transport Network Grant","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":497493000.0,"grant.code":"PTCG","grant.label":"Public Transport Network Grant","amount_type.code":"TRFR","financial_year_end.year":2021},{"amount.sum":4358025.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"ACT","financial_year_end.year":2021},{"amount.sum":44772000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"SCHD","financial_year_end.year":2021},{"amount.sum":11193000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"TRFR","financial_year_end.year":2021},{"amount.sum":216183756.0,"grant.code":"USDG","grant.label":"Urban Settlement Development Grant","amount_type.code":"ACT","financial_year_end.year":2021}],"2022":[{"amount.sum":7676981.0,"grant.code":"EEDG","grant.label":"Energy Efficiency and Demand Side Management (Municipal) Grant","amount_type.code":"ACT","financial_year_end.year":2022},{"amount.sum":10000000.0,"grant.code":"EEDG","grant.label":"Energy Efficiency and Demand Side Management (Municipal) Grant","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":10000000.0,"grant.code":"EEDG","grant.label":"Energy Efficiency and Demand Side Management (Municipal) Grant","amount_type.code":"TRFR","financial_year_end.year":2022},{"amount.sum":999986.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"ACT","financial_year_end.year":2022},{"amount.sum":1000000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":1000000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"TRFR","financial_year_end.year":2022},{"amount.sum":4012307.0,"grant.code":"ICDG","grant.label":"Integrated City Development Grant","amount_type.code":"ACT","financial_year_end.year":2022},{"amount.sum":85038000.0,"grant.code":"IN7G","grant.label":"Integrated National Electrification Programme (Allocation in-kind) Grant","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":9309930.0,"grant.code":"ISDG","grant.label":"Infrastructure Skills Development Grant","amount_type.code":"ACT","financial_year_end.year":2022},{"amount.sum":12000000.0,"grant.code":"ISDG","grant.label":"Infrastructure Skills Development Grant","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":12000000.0,"grant.code":"ISDG","grant.label":"Infrastructure Skills Development Grant","amount_type.code":"TRFR","financial_year_end.year":2022},{"amount.sum":65999580.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2022},{"amount.sum":250756533.0,"grant.code":"MISG","grant.label":"Municipal Systems Improvement Grant","amount_type.code":"ACT","financial_year_end.year":2022},{"amount.sum":518140000.0,"grant.code":"MISG","grant.label":"Municipal Systems Improvement Grant","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":518140000.0,"grant.code":"MISG","grant.label":"Municipal Systems Improvement Grant","amount_type.code":"TRFR","financial_year_end.year":2022},{"amount.sum":5000000.0,"grant.code":"ND7G","grant.label":"Neighbourhood Development Partnership (Schedule 6B)","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":2624000.0,"grant.code":"ND7G","grant.label":"Neighbourhood Development Partnership (Schedule 6B)","amount_type.code":"TRFR","financial_year_end.year":2022},{"amount.sum":17005308.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"ACT","financial_year_end.year":2022},{"amount.sum":171399000.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":171399000.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"TRFR","financial_year_end.year":2022},{"amount.sum":70890000.0,"grant.code":"PPPG","grant.label":"Programme and project preparation support grant","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":70890000.0,"grant.code":"PPPG","grant.label":"Programme and project preparation support grant","amount_type.code":"TRFR","financial_year_end.year":2022},{"amount.sum":483642592.0,"grant.code":"PTCG","grant.label":"Public Transport Network Grant","amount_type.code":"ACT","financial_year_end.year":2022},{"amount.sum":948640000.0,"grant.code":"PTCG","grant.label":"Public Transport Network Grant","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":948640000.0,"grant.code":"PTCG","grant.label":"Public Transport Network Grant","amount_type.code":"TRFR","financial_year_end.year":2022},{"amount.sum":29035819.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"ACT","financial_year_end.year":2022},{"amount.sum":49772000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"SCHD","financial_year_end.year":2022},{"amount.sum":49772000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"TRFR","financial_year_end.year":2022},{"amount.sum":641388774.0,"grant.code":"USDG","grant.label":"Urban Settlement Development Grant","amount_type.code":"ACT","financial_year_end.year":2022}],"2023":[{"amount.sum":8678475.0,"grant.code":"EEDG","grant.label":"Energy Efficiency and Demand Side Management (Municipal) Grant","amount_type.code":"ACT","financial_year_end.year":2023},{"amount.sum":9000000.0,"grant.code":"EEDG","grant.label":"Energy Efficiency and Demand Side Management (Municipal) Grant","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":9000000.0,"grant.code":"EEDG","grant.label":"Energy Efficiency and Demand Side Management (Municipal) Grant","amount_type.code":"TRFR","financial_year_end.year":2023},{"amount.sum":999999.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"ACT","financial_year_end.year":2023},{"amount.sum":1000000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":1000000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"TRFR","financial_year_end.year":2023},{"amount.sum":133461000.0,"grant.code":"IN7G","grant.label":"Integrated National Electrification Programme (Allocation in-kind) Grant","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":10165764.0,"grant.code":"ISDG","grant.label":"Infrastructure Skills Development Grant","amount_type.code":"ACT","financial_year_end.year":2023},{"amount.sum":11446000.0,"grant.code":"ISDG","grant.label":"Infrastructure Skills Development Grant","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":11446000.0,"grant.code":"ISDG","grant.label":"Infrastructure Skills Development Grant","amount_type.code":"TRFR","financial_year_end.year":2023},{"amount.sum":5004000.0,"grant.code":"MEHG","grant.label":"Municipal Emergency Housing Grant","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":5004000.0,"grant.code":"MEHG","grant.label":"Municipal Emergency Housing Grant","amount_type.code":"TRFR","financial_year_end.year":2023},{"amount.sum":1536822.0,"grant.code":"MIG","grant.label":"Municipal Infrastructure Grant","amount_type.code":"ACT","financial_year_end.year":2023},{"amount.sum":402345488.0,"grant.code":"MISG","grant.label":"Municipal Systems Improvement Grant","amount_type.code":"ACT","financial_year_end.year":2023},{"amount.sum":660012000.0,"grant.code":"MISG","grant.label":"Municipal Systems Improvement Grant","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":660012000.0,"grant.code":"MISG","grant.label":"Municipal Systems Improvement Grant","amount_type.code":"TRFR","financial_year_end.year":2023},{"amount.sum":3900000.0,"grant.code":"ND7G","grant.label":"Neighbourhood Development Partnership (Schedule 6B)","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":170424517.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"ACT","financial_year_end.year":2023},{"amount.sum":257372000.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":257372000.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"TRFR","financial_year_end.year":2023},{"amount.sum":41865423.0,"grant.code":"PPPG","grant.label":"Programme and project preparation support grant","amount_type.code":"ACT","financial_year_end.year":2023},{"amount.sum":65970000.0,"grant.code":"PPPG","grant.label":"Programme and project preparation support grant","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":65970000.0,"grant.code":"PPPG","grant.label":"Programme and project preparation support grant","amount_type.code":"TRFR","financial_year_end.year":2023},{"amount.sum":913922859.0,"grant.code":"PTCG","grant.label":"Public Transport Network Grant","amount_type.code":"ACT","financial_year_end.year":2023},{"amount.sum":1314261000.0,"grant.code":"PTCG","grant.label":"Public Transport Network Grant","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":1314261000.0,"grant.code":"PTCG","grant.label":"Public Transport Network Grant","amount_type.code":"TRFR","financial_year_end.year":2023},{"amount.sum":32718813.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"ACT","financial_year_end.year":2023},{"amount.sum":42406000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"SCHD","financial_year_end.year":2023},{"amount.sum":42406000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"TRFR","financial_year_end.year":2023},{"amount.sum":628426939.0,"grant.code":"USDG","grant.label":"Urban Settlement Development Grant","amount_type.code":"ACT","financial_year_end.year":2023}],"2024":[{"amount.sum":4450000.0,"grant.code":"DRG","grant.label":"Municipal Disaster Grant","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":4450000.0,"grant.code":"DRG","grant.label":"Municipal Disaster Grant","amount_type.code":"TRFR","financial_year_end.year":2024},{"amount.sum":6716301.0,"grant.code":"EEDG","grant.label":"Energy Efficiency and Demand Side Management (Municipal) Grant","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":9000000.0,"grant.code":"EEDG","grant.label":"Energy Efficiency and Demand Side Management (Municipal) Grant","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":9000000.0,"grant.code":"EEDG","grant.label":"Energy Efficiency and Demand Side Management (Municipal) Grant","amount_type.code":"TRFR","financial_year_end.year":2024},{"amount.sum":997187.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":1000000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":1000000.0,"grant.code":"FMG","grant.label":"Local Government Financial Management Grant","amount_type.code":"TRFR","financial_year_end.year":2024},{"amount.sum":71788000.0,"grant.code":"IN7G","grant.label":"Integrated National Electrification Programme (Allocation in-kind) Grant","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":9111446.0,"grant.code":"ISDG","grant.label":"Infrastructure Skills Development Grant","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":9920000.0,"grant.code":"ISDG","grant.label":"Infrastructure Skills Development Grant","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":9920000.0,"grant.code":"ISDG","grant.label":"Infrastructure Skills Development Grant","amount_type.code":"TRFR","financial_year_end.year":2024},{"amount.sum":500739826.0,"grant.code":"MISG","grant.label":"Municipal Systems Improvement Grant","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":606272000.0,"grant.code":"MISG","grant.label":"Municipal Systems Improvement Grant","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":606272000.0,"grant.code":"MISG","grant.label":"Municipal Systems Improvement Grant","amount_type.code":"TRFR","financial_year_end.year":2024},{"amount.sum":307000.0,"grant.code":"ND7G","grant.label":"Neighbourhood Development Partnership (Schedule 6B)","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":196610355.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":235890000.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":235890000.0,"grant.code":"NDPG","grant.label":"Neighbourhood Development Partnership (Schedule 5B)","amount_type.code":"TRFR","financial_year_end.year":2024},{"amount.sum":52005841.0,"grant.code":"PPPG","grant.label":"Programme and project preparation support grant","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":68877000.0,"grant.code":"PPPG","grant.label":"Programme and project preparation support grant","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":68877000.0,"grant.code":"PPPG","grant.label":"Programme and project preparation support grant","amount_type.code":"TRFR","financial_year_end.year":2024},{"amount.sum":1295174615.0,"grant.code":"PTCG","grant.label":"Public Transport Network Grant","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":1777845000.0,"grant.code":"PTCG","grant.label":"Public Transport Network Grant","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":1777845000.0,"grant.code":"PTCG","grant.label":"Public Transport Network Grant","amount_type.code":"TRFR","financial_year_end.year":2024},{"amount.sum":48085786.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"ACT","financial_year_end.year":2024},{"amount.sum":59093000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"SCHD","financial_year_end.year":2024},{"amount.sum":59093000.0,"grant.code":"PWPG","grant.label":"Expanded Public Works Programme Integrated Grant (Municipality)","amount_type.code":"TRFR","financial_year_end.year":2024},{"amount.sum":678180853.0,"grant.code":"USDG","grant.label":"Urban Settlement Development Grant","amount_type.code":"ACT","financial_year_end.year":2024}]}},"cash_balance":{"ref":{"url":"http://mfma.treasury.gov.za/Media_Releases/The%20state%20of%20local%20government%20finances/Pages/default.aspx","title":"State of Local Government Finances"},"values":[{"date":2024,"rating":"good","result":12624410780.0,"cube_version":"v2"},{"date":2023,"rating":"good","result":7737083379.0,"cube_version":"v2"},{"date":2022,"rating":"good","result":88837467582.0,"cube_version":"v2"},{"date":2021,"rating":"good","result":52782747132.0,"cube_version":"v2"}],"formula":{"text":"= Cash available at year end","actual":["=",{"cube":"cflow","item_codes":["4200"],"amount_type":"AUDA"}]},"last_year":2024,"formula_v2":{"text":"= Cash available at year end","actual":["=",{"cube":"cflow_v2","item_codes":["0430"],"amount_type":"AUDA"}]},"result_type":"R"},"cash_coverage":{"ref":{"url":"http://mfma.treasury.gov.za/Media_Releases/The%20state%20of%20local%20government%20finances/Pages/default.aspx","title":"State of Local Government Finances"},"values":[{"date":2024,"rating":"ave","result":2.6,"cube_version":"v2"},{"date":2023,"rating":"ave","result":1.8,"cube_version":"v2"},{"date":2022,"rating":"good","result":21.1,"cube_version":"v2"},{"date":2021,"rating":"good","result":14.6,"cube_version":"v2"}],"formula":{"text":"= Cash available at year end / Operating Expenditure per month","actual":["=",{"cube":"cflow","item_codes":["4200"],"amount_type":"AUDA"},"/","(",{"cube":"incexp","item_codes":["4600"],"amount_type":"AUDA"},"/","12",")"]},"last_year":2024,"formula_v2":{"text":"= Cash available at year end / Operating Expenditure per month","actual":["=",{"cube":"cflow_v2","item_codes":["0430"],"amount_type":"AUDA"},"/","(",{"cube":"incexp_v2","item_codes":["3000","3100","3200","3300","3400","3500","3600","3700","3800","3900","4000","4100","4200","4300"],"amount_type":"AUDA"},"/","12",")"]},"result_type":"months"},"current_ratio":{"ref":{"url":"http://mfma.treasury.gov.za/Circulars/Pages/Circular71.aspx","title":"Circular 71"},"values":[{"date":2024,"year":2024,"assets":22519616988.0,"rating":"ave","result":1.49,"amount_type":"AUDA","liabilities":15154137847.0,"cube_version":"v2"},{"date":2023,"year":2023,"assets":20402203327.0,"rating":"good","result":1.66,"amount_type":"AUDA","liabilities":12285145491.0,"cube_version":"v2"},{"date":2022,"year":2022,"assets":17317121341.0,"rating":"good","result":1.68,"amount_type":"AUDA","liabilities":10295757520.0,"cube_version":"v2"},{"date":2021,"year":2021,"assets":16338731332.0,"rating":"good","result":2.04,"amount_type":"AUDA","liabilities":8006705860.0,"cube_version":"v2"}],"formula":{"text":"= Current Assets / Current Liabilities","actual":["=",{"cube":"bsheet","item_codes":["2150"],"amount_type":"AUDA"},"/",{"cube":"bsheet","item_codes":["1600"],"amount_type":"AUDA"}]},"last_year":2024,"formula_v2":{"text":"= Current Assets / Current Liabilities","actual":["=",{"cube":"financial_position_v2","item_codes":["0120","0125","0130","0140","0150","0160","0170","0180"],"amount_type":"AUDA"},"/",{"cube":"financial_position_v2","item_codes":["0330","0340","0350","0360","0370","0380","0390","0400","0410","0420"],"amount_type":"AUDA"}]},"result_type":"ratio"},"liquidity_ratio":{"ref":{"url":"http://mfma.treasury.gov.za/RegulationsandGazettes/Municipal%20Budget%20and%20Reporting%20Regulations/Pages/default.aspx","title":"Municipal Budget and Reporting Regulations"},"values":[{"cash":12706886561.0,"date":"2024","year":2024,"rating":"bad","result":0.84,"amount_type":"ACT","liabilities":15154137847.0,"cube_version":"v2","call_investment_deposits":0},{"cash":12593287722.0,"date":"2023","year":2023,"rating":"good","result":1.03,"amount_type":"ACT","liabilities":12285145491.0,"cube_version":"v2","call_investment_deposits":0},{"cash":11123522486.0,"date":"2022","year":2022,"rating":"good","result":1.08,"amount_type":"ACT","liabilities":10295757520.0,"cube_version":"v2","call_investment_deposits":0},{"cash":10807633934.0,"date":"2021","year":2021,"rating":"good","result":1.35,"amount_type":"ACT","liabilities":8006705860.0,"cube_version":"v2","call_investment_deposits":0}],"formula":{"text":"= (Cash + Call Investment Deposits) / Current Liabilities","actual":["=",{"cube":"bsheet","item_codes":["1800","2200"],"amount_type":"AUDA"},"/",{"cube":"bsheet","item_codes":["1600"],"amount_type":"AUDA"}]},"last_year":2024,"formula_v2":{"text":"= (Cash + Call Investment Deposits) / Current Liabilities","actual":["=",{"cube":"financial_position_v2","item_codes":["0120","0125"],"amount_type":"AUDA"},"/",{"cube":"financial_position_v2","item_codes":["0330","0340","0350","0360","0370","0380","0390","0400","0410","0420"],"amount_type":"AUDA"}]},"result_type":"ratio"},"revenue_sources":{"ref":{"url":"http://mfma.treasury.gov.za/Media_Releases/LGESDiscussions/Pages/default.aspx","title":"Local Government Equitable Share"},"year":2024,"local":{"amount":55121708013.0,"percent":89.13},"total":61841487486.0,"rating":"good","formula":{"text":"= Total revenue","actual":["=",{"cube":"incexp","item_codes":["0200","0300","0400","0700","0800","1000","1100","1300","1400","1500","1700","1800","1600","1610"],"amount_type":"AUDA"}]},"formula_v2":{"text":"= Total revenue","actual":["=",{"cube":"incexp_v2","item_codes":["0200","0300","0400","0500","0600","0700","0800","0900","1000","1100","1200","1300","1400","1500","1550","1570","1590","1600","1700","1800","1900","2000","2100","2300","2400","2500","2600","2700","2800","2200"],"amount_type":"AUDA"}]},"government":{"amount":6719779473.0,"percent":10.87}},"uifw_expenditure":{"ref":{"url":"http://mfma.treasury.gov.za/Circulars/Pages/Circular71.aspx","title":"Circular 71"},"values":[{"date":2024,"rating":"bad","result":1.09,"cube_version":"v2"},{"date":2023,"rating":"bad","result":0.02,"cube_version":"v2"},{"date":2022,"rating":"bad","result":0.07,"cube_version":"v2"},{"date":2021,"rating":"bad","result":1.78,"cube_version":"v2"}],"formula":{"text":"= (Unauthorised, Irregular, Fruitless and Wasteful Expenditure / Actual Operating Expenditure) * 100","actual":["=","(",{"cube":"uifwexp","item_codes":["irregular","fruitless","unauthorised"]},"/",{"cube":"incexp","item_codes":["4600"],"amount_type":"AUDA"},")","*","100"]},"last_year":2024,"formula_v2":{"text":"= (Unauthorised, Irregular, Fruitless and Wasteful Expenditure / Actual Operating Expenditure) * 100","actual":["=","(",{"cube":"uifwexp","item_codes":["irregular","fruitless","unauthorised"]},"/",{"cube":"incexp_v2","item_codes":["3000","3100","3200","3300","3400","3500","3600","3700","3800","3900","4000","4100","4200","4300"],"amount_type":"AUDA"},")","*","100"]},"result_type":"%"},"income_adjustments":{"2021":[{"item":"Fines","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Fines","amount":561310746.0,"comparison":"Original budget to audited outcome","percent_changed":52.79},{"item":"Government Transfers","amount":550828326.0,"comparison":"Original to adjusted budget","percent_changed":9.82},{"item":"Government Transfers","amount":184472695.0,"comparison":"Original budget to audited outcome","percent_changed":3.29},{"item":"Interest and investments","amount":152002960.0,"comparison":"Original to adjusted budget","percent_changed":12.21},{"item":"Interest and investments","amount":110639295.0,"comparison":"Original budget to audited outcome","percent_changed":8.89},{"item":"Licenses and Permits","amount":-11783056.0,"comparison":"Original to adjusted budget","percent_changed":-15.33},{"item":"Licenses and Permits","amount":-32220174.0,"comparison":"Original budget to audited outcome","percent_changed":-41.91},{"item":"Other","amount":-114547910.0,"comparison":"Original to adjusted budget","percent_changed":-3.12},{"item":"Other","amount":78071235.0,"comparison":"Original budget to audited outcome","percent_changed":2.12},{"item":"Property rates","amount":13601870.0,"comparison":"Original to adjusted budget","percent_changed":0.13},{"item":"Property rates","amount":-236248198.0,"comparison":"Original budget to audited outcome","percent_changed":-2.25},{"item":"Rental income","amount":-116419959.0,"comparison":"Original to adjusted budget","percent_changed":-23.43},{"item":"Rental income","amount":-144081599.0,"comparison":"Original budget to audited outcome","percent_changed":-29.0},{"item":"Service Charges","amount":-12910894.0,"comparison":"Original to adjusted budget","percent_changed":-0.06},{"item":"Service Charges","amount":390250555.0,"comparison":"Original budget to audited outcome","percent_changed":1.96}],"2022":[{"item":"Fines","amount":3360921.0,"comparison":"Original to adjusted budget","percent_changed":0.27},{"item":"Fines","amount":679074982.0,"comparison":"Original budget to audited outcome","percent_changed":54.46},{"item":"Government Transfers","amount":419878425.0,"comparison":"Original to adjusted budget","percent_changed":7.43},{"item":"Government Transfers","amount":171218204.0,"comparison":"Original budget to audited outcome","percent_changed":3.03},{"item":"Interest and investments","amount":-46546436.0,"comparison":"Original to adjusted budget","percent_changed":-3.57},{"item":"Interest and investments","amount":43939828.0,"comparison":"Original budget to audited outcome","percent_changed":3.37},{"item":"Licenses and Permits","amount":2920074.0,"comparison":"Original to adjusted budget","percent_changed":4.35},{"item":"Licenses and Permits","amount":-21619717.0,"comparison":"Original budget to audited outcome","percent_changed":-32.22},{"item":"Other","amount":2701729480.0,"comparison":"Original to adjusted budget","percent_changed":48.16},{"item":"Other","amount":2970686827.0,"comparison":"Original budget to audited outcome","percent_changed":52.95},{"item":"Property rates","amount":-317046.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Property rates","amount":-332303686.0,"comparison":"Original budget to audited outcome","percent_changed":-3.03},{"item":"Rental income","amount":23865917.0,"comparison":"Original to adjusted budget","percent_changed":6.18},{"item":"Rental income","amount":68864329.0,"comparison":"Original budget to audited outcome","percent_changed":17.84},{"item":"Service Charges","amount":-53423894.0,"comparison":"Original to adjusted budget","percent_changed":-0.24},{"item":"Service Charges","amount":585006665.0,"comparison":"Original budget to audited outcome","percent_changed":2.61}],"2023":[{"item":"Fines","amount":96516638.0,"comparison":"Original to adjusted budget","percent_changed":7.65},{"item":"Fines","amount":722226158.0,"comparison":"Original budget to audited outcome","percent_changed":57.22},{"item":"Government Transfers","amount":49587092.0,"comparison":"Original to adjusted budget","percent_changed":0.79},{"item":"Government Transfers","amount":-6061860.0,"comparison":"Original budget to audited outcome","percent_changed":-0.1},{"item":"Interest and investments","amount":131765734.0,"comparison":"Original to adjusted budget","percent_changed":8.86},{"item":"Interest and investments","amount":379989476.0,"comparison":"Original budget to audited outcome","percent_changed":25.56},{"item":"Licenses and Permits","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Licenses and Permits","amount":-27265714.0,"comparison":"Original budget to audited outcome","percent_changed":-37.22},{"item":"Other","amount":246202255.0,"comparison":"Original to adjusted budget","percent_changed":3.17},{"item":"Other","amount":673321775.0,"comparison":"Original budget to audited outcome","percent_changed":8.67},{"item":"Property rates","amount":380800.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Property rates","amount":43409965.0,"comparison":"Original budget to audited outcome","percent_changed":0.38},{"item":"Rental income","amount":-3376852.0,"comparison":"Original to adjusted budget","percent_changed":-0.63},{"item":"Rental income","amount":37031905.0,"comparison":"Original budget to audited outcome","percent_changed":6.95},{"item":"Service Charges","amount":54454500.0,"comparison":"Original to adjusted budget","percent_changed":0.22},{"item":"Service Charges","amount":-842224119.0,"comparison":"Original budget to audited outcome","percent_changed":-3.43}],"2024":[{"item":"Fines","amount":651858969.0,"comparison":"Original to adjusted budget","percent_changed":52.08},{"item":"Fines","amount":658683203.0,"comparison":"Original budget to audited outcome","percent_changed":52.62},{"item":"Government Transfers","amount":-44417176.0,"comparison":"Original to adjusted budget","percent_changed":-0.65},{"item":"Government Transfers","amount":-89780670.0,"comparison":"Original budget to audited outcome","percent_changed":-1.32},{"item":"Interest and investments","amount":190207318.0,"comparison":"Original to adjusted budget","percent_changed":12.09},{"item":"Interest and investments","amount":481501018.0,"comparison":"Original budget to audited outcome","percent_changed":30.6},{"item":"Licenses and Permits","amount":-5362586.0,"comparison":"Original to adjusted budget","percent_changed":-6.98},{"item":"Licenses and Permits","amount":-26512395.0,"comparison":"Original budget to audited outcome","percent_changed":-34.5},{"item":"Other","amount":625197470.0,"comparison":"Original to adjusted budget","percent_changed":6.97},{"item":"Other","amount":976939504.0,"comparison":"Original budget to audited outcome","percent_changed":10.9},{"item":"Property rates","amount":-11715.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Property rates","amount":129342684.0,"comparison":"Original budget to audited outcome","percent_changed":1.09},{"item":"Rental income","amount":62967919.0,"comparison":"Original to adjusted budget","percent_changed":10.8},{"item":"Rental income","amount":90555625.0,"comparison":"Original budget to audited outcome","percent_changed":15.53},{"item":"Service Charges","amount":149989932.0,"comparison":"Original to adjusted budget","percent_changed":0.54},{"item":"Service Charges","amount":730426428.0,"comparison":"Original budget to audited outcome","percent_changed":2.63}]},"income_time_series":[{"amount":43025113817.0,"budget_phase":"Adjusted Budget","financial_year":2021,"amount_type.code":"ADJB"},{"amount":50697675431.0,"budget_phase":"Adjusted Budget","financial_year":2022,"amount_type.code":"ADJB"},{"amount":54009572802.0,"budget_phase":"Adjusted Budget","financial_year":2023,"amount_type.code":"ADJB"},{"amount":60520762220.0,"budget_phase":"Adjusted Budget","financial_year":2024,"amount_type.code":"ADJB"},{"amount":43476537035.0,"budget_phase":"Audited Actual","financial_year":2021,"amount_type.code":"AUDA"},{"amount":51811075422.0,"budget_phase":"Audited Actual","financial_year":2022,"amount_type.code":"AUDA"},{"amount":54414470221.0,"budget_phase":"Audited Actual","financial_year":2023,"amount_type.code":"AUDA"},{"amount":61841487486.0,"budget_phase":"Audited Actual","financial_year":2024,"amount_type.code":"AUDA"},{"amount":67471823761.0,"budget_phase":"Audited Actual","financial_year":2025,"amount_type.code":"AUDA"},{"amount":68163692333.0,"budget_phase":"Forecast 1 year ahead of budget year","financial_year":2026,"amount_type.code":"IBY1"},{"amount":73155466042.0,"budget_phase":"Forecast 2 years ahead of budget year","financial_year":2027,"amount_type.code":"IBY2"},{"amount":42564342480.0,"budget_phase":"Original Budget","financial_year":2021,"amount_type.code":"ORGB"},{"amount":47646207990.0,"budget_phase":"Original Budget","financial_year":2022,"amount_type.code":"ORGB"},{"amount":53434042635.0,"budget_phase":"Original Budget","financial_year":2023,"amount_type.code":"ORGB"},{"amount":58890332089.0,"budget_phase":"Original Budget","financial_year":2024,"amount_type.code":"ORGB"},{"amount":64280885957.0,"budget_phase":"Original Budget","financial_year":2025,"amount_type.code":"ORGB"}],"spending_adjustments":{"2021":[{"item":"Bulk purchases","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Bulk purchases","amount":133342750.0,"comparison":"Original budget to audited outcome","percent_changed":1.39},{"item":"Contracted services","amount":466884581.0,"comparison":"Original to adjusted budget","percent_changed":6.38},{"item":"Contracted services","amount":-68465382.0,"comparison":"Original budget to audited outcome","percent_changed":-0.94},{"item":"Employee related costs","amount":-341698280.0,"comparison":"Original to adjusted budget","percent_changed":-2.23},{"item":"Employee related costs","amount":-116826187.0,"comparison":"Original budget to audited outcome","percent_changed":-0.76},{"item":"Finance charges","amount":22990375.0,"comparison":"Original to adjusted budget","percent_changed":2.78},{"item":"Finance charges","amount":3018130.0,"comparison":"Original budget to audited outcome","percent_changed":0.36},{"item":"Other","amount":-617777962.0,"comparison":"Original to adjusted budget","percent_changed":-5.38},{"item":"Other","amount":-1592851476.0,"comparison":"Original budget to audited outcome","percent_changed":-13.86},{"item":"Remuneration of councillors","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Remuneration of councillors","amount":-23258039.0,"comparison":"Original budget to audited outcome","percent_changed":-12.26},{"item":"Transfers and subsidies","amount":56730631.0,"comparison":"Original to adjusted budget","percent_changed":13.12},{"item":"Transfers and subsidies","amount":-86313758.0,"comparison":"Original budget to audited outcome","percent_changed":-19.96}],"2022":[{"item":"Bulk purchases","amount":36500000.0,"comparison":"Original to adjusted budget","percent_changed":0.33},{"item":"Bulk purchases","amount":379208864.0,"comparison":"Original budget to audited outcome","percent_changed":3.39},{"item":"Contracted services","amount":178903740.0,"comparison":"Original to adjusted budget","percent_changed":2.22},{"item":"Contracted services","amount":-239430798.0,"comparison":"Original budget to audited outcome","percent_changed":-2.98},{"item":"Employee related costs","amount":236176390.0,"comparison":"Original to adjusted budget","percent_changed":1.51},{"item":"Employee related costs","amount":-357151398.0,"comparison":"Original budget to audited outcome","percent_changed":-2.28},{"item":"Finance charges","amount":-6043351.0,"comparison":"Original to adjusted budget","percent_changed":-0.76},{"item":"Finance charges","amount":-18124986.0,"comparison":"Original budget to audited outcome","percent_changed":-2.28},{"item":"Other","amount":2407200954.0,"comparison":"Original to adjusted budget","percent_changed":19.78},{"item":"Other","amount":2442575044.0,"comparison":"Original budget to audited outcome","percent_changed":20.07},{"item":"Remuneration of councillors","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Remuneration of councillors","amount":-14663316.0,"comparison":"Original budget to audited outcome","percent_changed":-8.15},{"item":"Transfers and subsidies","amount":96062301.0,"comparison":"Original to adjusted budget","percent_changed":23.67},{"item":"Transfers and subsidies","amount":-41728625.0,"comparison":"Original budget to audited outcome","percent_changed":-10.28}],"2023":[{"item":"Bulk purchases","amount":0.0,"comparison":"Original to adjusted budget","percent_changed":0.0},{"item":"Bulk purchases","amount":-538741555.0,"comparison":"Original budget to audited outcome","percent_changed":-4.36},{"item":"Contracted services","amount":256698229.0,"comparison":"Original to adjusted budget","percent_changed":2.96},{"item":"Contracted services","amount":323731512.0,"comparison":"Original budget to audited outcome","percent_changed":3.73},{"item":"Employee related costs","amount":-13822338.0,"comparison":"Original to adjusted budget","percent_changed":-0.08},{"item":"Employee related costs","amount":-2051446053.0,"comparison":"Original budget to audited outcome","percent_changed":-11.8},{"item":"Finance charges","amount":-111383618.0,"comparison":"Original to adjusted budget","percent_changed":-12.91},{"item":"Finance charges","amount":-90565038.0,"comparison":"Original budget to audited outcome","percent_changed":-10.49},{"item":"Other","amount":535573991.0,"comparison":"Original to adjusted budget","percent_changed":3.76},{"item":"Other","amount":779571190.0,"comparison":"Original budget to audited outcome","percent_changed":5.48},{"item":"Remuneration of councillors","amount":4987239.0,"comparison":"Original to adjusted budget","percent_changed":2.83},{"item":"Remuneration of councillors","amount":-69048.0,"comparison":"Original budget to audited outcome","percent_changed":-0.04},{"item":"Transfers and subsidies","amount":33846525.0,"comparison":"Original to adjusted budget","percent_changed":9.39},{"item":"Transfers and subsidies","amount":-16503523.0,"comparison":"Original budget to audited outcome","percent_changed":-4.58}],"2024":[{"item":"Bulk purchases","amount":-10955046.0,"comparison":"Original to adjusted budget","percent_changed":-0.08},{"item":"Bulk purchases","amount":-157714078.0,"comparison":"Original budget to audited outcome","percent_changed":-1.12},{"item":"Contracted services","amount":195125036.0,"comparison":"Original to adjusted budget","percent_changed":2.07},{"item":"Contracted services","amount":189177268.0,"comparison":"Original budget to audited outcome","percent_changed":2.01},{"item":"Employee related costs","amount":5806479.0,"comparison":"Original to adjusted budget","percent_changed":0.03},{"item":"Employee related costs","amount":-1283569701.0,"comparison":"Original budget to audited outcome","percent_changed":-6.94},{"item":"Finance charges","amount":-45165774.0,"comparison":"Original to adjusted budget","percent_changed":-4.78},{"item":"Finance charges","amount":-115394636.0,"comparison":"Original budget to audited outcome","percent_changed":-12.21},{"item":"Other","amount":1331885194.0,"comparison":"Original to adjusted budget","percent_changed":8.37},{"item":"Other","amount":319580039.0,"comparison":"Original budget to audited outcome","percent_changed":2.01},{"item":"Remuneration of councillors","amount":-116330.0,"comparison":"Original to adjusted budget","percent_changed":-0.06},{"item":"Remuneration of councillors","amount":-7871244.0,"comparison":"Original budget to audited outcome","percent_changed":-4.12},{"item":"Transfers and subsidies","amount":29079033.0,"comparison":"Original to adjusted budget","percent_changed":8.53},{"item":"Transfers and subsidies","amount":-14120734.0,"comparison":"Original budget to audited outcome","percent_changed":-4.14}]},"spending_time_series":[{"amount":44731633647.0,"budget_phase":"Adjusted Budget","financial_year":2021,"amount_type.code":"ADJB"},{"amount":51395762328.0,"budget_phase":"Adjusted Budget","financial_year":2022,"amount_type.code":"ADJB"},{"amount":54745399646.0,"budget_phase":"Adjusted Budget","financial_year":2023,"amount_type.code":"ADJB"},{"amount":60889495462.0,"budget_phase":"Adjusted Budget","financial_year":2024,"amount_type.code":"ADJB"},{"amount":43393150340.0,"budget_phase":"Audited Actual","financial_year":2021,"amount_type.code":"AUDA"},{"amount":50597647079.0,"budget_phase":"Audited Actual","financial_year":2022,"amount_type.code":"AUDA"},{"amount":52445477103.0,"budget_phase":"Audited Actual","financial_year":2023,"amount_type.code":"AUDA"},{"amount":58313923784.0,"budget_phase":"Audited Actual","financial_year":2024,"amount_type.code":"AUDA"},{"amount":63938772101.0,"budget_phase":"Audited Actual","financial_year":2025,"amount_type.code":"AUDA"},{"amount":68822841003.0,"budget_phase":"Forecast 1 year ahead of budget year","financial_year":2026,"amount_type.code":"IBY1"},{"amount":73168649532.0,"budget_phase":"Forecast 2 years ahead of budget year","financial_year":2027,"amount_type.code":"IBY2"},{"amount":45144504302.0,"budget_phase":"Original Budget","financial_year":2021,"amount_type.code":"ORGB"},{"amount":48446962294.0,"budget_phase":"Original Budget","financial_year":2022,"amount_type.code":"ORGB"},{"amount":54039499618.0,"budget_phase":"Original Budget","financial_year":2023,"amount_type.code":"ORGB"},{"amount":59383836870.0,"budget_phase":"Original Budget","financial_year":2024,"amount_type.code":"ORGB"},{"amount":64668176025.0,"budget_phase":"Original Budget","financial_year":2025,"amount_type.code":"ORGB"}],"capital_budget_spending":{"ref":{"url":"http://mfma.treasury.gov.za/Media_Releases/Reports%20to%20Parliament/Pages/default.aspx","title":"Over and under spending reports to parliament"},"values":[{"date":2024,"rating":"bad","result":-17.27,"overunder":"under","cube_version":"v2"},{"date":2023,"rating":"ave","result":-11.72,"overunder":"under","cube_version":"v2"},{"date":2022,"rating":"bad","result":-39.3,"overunder":"under","cube_version":"v2"},{"date":2021,"rating":"bad","result":-33.05,"overunder":"under","cube_version":"v2"}],"formula":{"text":"= ((Actual Capital Expenditure - Budgeted Capital Expenditure) / Budgeted Capital Expenditure) * 100","actual":["=","(","(",{"cube":"capital","item_codes":["4100"],"amount_type":"AUDA"},"-",{"cube":"capital","item_codes":["4100"],"amount_type":"ADJB"},")","/",{"cube":"capital","item_codes":["4100"],"amount_type":"ADJB"},")","*","100"]},"last_year":2024,"formula_v2":{"text":"= ((Actual Capital Expenditure - Budgeted Capital Expenditure) / Budgeted Capital Expenditure) * 100","actual":["=","(","(",{"cube":"capital_v2","amount_type":"AUDA","item_description":"capital type code NEW, RENEWAL, UPGRADING"},"-",{"cube":"capital_v2","amount_type":"ADJB","item_description":"capital type code NEW, RENEWAL, UPGRADING"},")","/",{"cube":"capital_v2","amount_type":"ADJB","item_description":"capital type code NEW, RENEWAL, UPGRADING"},")","*","100"]},"result_type":"%"},"local_revenue_breakdown":{"ref":{"url":"http://mfma.treasury.gov.za/Media_Releases/LGESDiscussions/Pages/default.aspx","title":"Local Government Equitable Share"},"values":[{"date":"2024","item":"Property rates","amount":11981350782.0,"amount_type":"AUDA"},{"date":"2024","item":"Service Charges","amount":28508183391.0,"amount_type":"AUDA"},{"date":"2024","item":"Rental income","amount":673605328.0,"amount_type":"AUDA"},{"date":"2024","item":"Interest and investments","amount":2055224024.0,"amount_type":"AUDA"},{"date":"2024","item":"Fines","amount":1910359037.0,"amount_type":"AUDA"},{"date":"2024","item":"Licenses and Permits","amount":50327881.0,"amount_type":"AUDA"},{"date":"2024","item":"Agency services","amount":278169611.0,"amount_type":"AUDA"},{"date":"2024","item":"Other","amount":9664487959.0,"amount_type":"AUDA"}],"formula":{"text":"= Breakdown of local income","actual":["=",{"cube":"incexp","item_codes":["0200","0300","0400","0700","0800","1000","1100","1300","1400","1500","1700","1800","1600","1610"],"amount_type":"AUDA"}]},"formula_v2":{"text":"= Breakdown of local income","actual":["=",{"cube":"incexp_v2","item_codes":["0200","0300","0400","0500","0600","0700","0800","0900","1000","1100","1200","1300","1400","1500","1550","1570","1590","1600","1700","1800","1900","2000","2100","2300","2400","2500","2600","2700","2800","2200"],"amount_type":"AUDA"}]}},"expenditure_trends_staff":{"ref":{"url":"http://mfma.treasury.gov.za/Media_Releases/LGESDiscussions/Pages/default.aspx","title":"Local Government Equitable Share"},"values":[{"date":2024,"rating":"","result":29.5},{"date":2023,"rating":"","result":29.24},{"date":2022,"rating":"","result":30.26},{"date":2021,"rating":"","result":34.98}],"formula":{"text":"= Total expenditure on salaries and wages","actual":["=",{"cube":"incexp","item_codes":["3000","3100"],"amount_type":"AUDA"}]},"formula_v2":{"text":"= Total expenditure on salaries and wages","actual":["=",{"cube":"incexp_v2","item_codes":["3100"],"amount_type":"AUDA"}]},"result_type":"%"},"operating_budget_spending":{"ref":{"url":"http://mfma.treasury.gov.za/Media_Releases/Reports%20to%20Parliament/Pages/default.aspx","title":"Over and under spending reports to parliament"},"values":[{"date":2024,"rating":"good","result":-4.2,"overunder":"under","cube_version":"v2"},{"date":2023,"rating":"good","result":-4.2,"overunder":"under","cube_version":"v2"},{"date":2022,"rating":"good","result":-1.6,"overunder":"under","cube_version":"v2"},{"date":2021,"rating":"good","result":-3.0,"overunder":"under","cube_version":"v2"}],"formula":{"text":"= ((Actual Operating Expenditure - Budget Operating Expenditure) / Budgeted Operating Expenditure) * 100","actual":["=","(","(",{"cube":"incexp","item_codes":["4600"],"amount_type":"AUDA"},"-",{"cube":"incexp","item_codes":["4600"],"amount_type":"ADJB"},")","/",{"cube":"incexp","item_codes":["4600"],"amount_type":"ADJB"},")","*","100"]},"last_year":2024,"formula_v2":{"text":"= ((Actual Operating Expenditure - Budget Operating Expenditure) / Budgeted Operating Expenditure) * 100","actual":["=","(","(",{"cube":"incexp_v2","item_codes":["3000","3100","3200","3300","3400","3500","3600","3700","3800","3900","4000","4100","4200","4300"],"amount_type":"AUDA"},"-",{"cube":"incexp_v2","item_codes":["3000","3100","3200","3300","3400","3500","3600","3700","3800","3900","4000","4100","4200","4300"],"amount_type":"ADJB"},")","/",{"cube":"incexp_v2","item_codes":["3000","3100","3200","3300","3400","3500","3600","3700","3800","3900","4000","4100","4200","4300"],"amount_type":"ADJB"},")","*","100"]},"result_type":"%"},"repairs_maintenance_spending":{"ref":{"url":"http://mfma.treasury.gov.za/Circulars/Pages/Circular71.aspx","title":"Circular 71"},"values":[{"date":2024,"rating":"bad","result":2.02,"cube_version":"v2"},{"date":2023,"rating":"bad","result":2.98,"cube_version":"v2"},{"date":2022,"rating":"bad","result":2.67,"cube_version":"v2"},{"date":2021,"rating":"bad","result":2.65,"cube_version":"v2"}],"formula":{"text":"= (Repairs and maintenance expenditure / (Property, Plant and Equipment + Investment Property)) * 100","actual":["=","(",{"cube":"capital","item_codes":["4100"],"amount_type":"AUDA"},"/","(",{"cube":"bsheet","item_codes":["1300"],"amount_type":"AUDA"},"+",{"cube":"bsheet","item_codes":["1401"],"amount_type":"AUDA"},")",")","*","100"]},"last_year":2024,"formula_v2":{"text":"= (Repairs and maintenance expenditure / (Property, Plant and Equipment + Investment Property)) * 100","actual":["=","(",{"cube":"capital_v2","amount_type":"AUDA","item_description":"capital type code REPAIR_MNT Total"},"/","(",{"cube":"financial_position_v2","item_codes":["0230","0220"],"amount_type":"AUDA"},")",")","*","100"]},"result_type":"%"},"expenditure_trends_contracting":{"ref":{"url":"http://mfma.treasury.gov.za/Media_Releases/LGESDiscussions/Pages/default.aspx","title":"Local Government Equitable Share"},"values":[{"date":2024,"rating":"","result":16.47},{"date":2023,"rating":"","result":17.16},{"date":2022,"rating":"","result":15.42},{"date":2021,"rating":"","result":16.72}],"formula":{"text":"= Expenditure for services rendered by a contractor","actual":["=",{"cube":"incexp","item_codes":["4200"],"amount_type":"AUDA"}]},"formula_v2":{"text":"= Expenditure for services rendered by a contractor","actual":["=",{"cube":"incexp_v2","item_codes":["3800"],"amount_type":"AUDA"}]},"result_type":"%"},"current_debtors_collection_rate":{"ref":{"url":"http://mfma.treasury.gov.za/RegulationsandGazettes/Municipal%20Budget%20and%20Reporting%20Regulations/Pages/default.aspx","title":"Municipal Budget and Reporting Regulations"},"values":[{"date":"2024","year":2024,"rating":"bad","result":91.87,"amount_type":"AUDA","cube_version":"v2"},{"date":"2023","year":2023,"rating":"good","result":94.62,"amount_type":"AUDA","cube_version":"v2"},{"date":"2022","year":2022,"rating":"good","result":95.9,"amount_type":"AUDA","cube_version":"v2"},{"date":"2021","year":2021,"rating":"good","result":95.15,"amount_type":"AUDA","cube_version":"v2"}],"formula":{"text":"= (Collected Revenue / Billed Revenue) * 100","actual":["=","(",{"cube":"cflow","item_codes":["3010","3030","3040","3050","3060","3070","3100"],"amount_type":"AUDA"},"/",{"cube":"incexp","item_codes":["0200","0400","1000","less item code","2000"],"amount_type":"AUDA"},")","*","100"]},"last_year":2024,"formula_v2":{"text":"= (Collected Revenue / Billed Revenue) * 100","actual":["=","(",{"cube":"cflow_v2","item_codes":["0120","0130","0280"],"amount_type":"AUDA"},"/",{"cube":"incexp_v2","item_codes":["1800","0300","0400","0500","0600","1400","1100","1000"],"amount_type":"AUDA"},")","*","100"]},"result_type":"%"},"expenditure_functional_breakdown":{"ref":{"url":"http://mfma.treasury.gov.za/Media_Releases/LGESDiscussions/Pages/default.aspx","title":"Local Government Equitable Share"},"values":[{"values":[{"year":2021,"value":4675337950.0},{"year":2022,"value":5624392136.0},{"year":2023,"value":5773041047.0},{"year":2024,"value":5676338798.0},{"year":2025,"value":5753587067.0}],"category":"Community & Social Services"},{"values":[{"year":2021,"value":11809460845.0},{"year":2022,"value":13873331284.0},{"year":2023,"value":14408989483.0},{"year":2024,"value":16619363540.0},{"year":2025,"value":19142836802.0}],"category":"Electricity "},{"values":[{"year":2021,"value":239356494.0},{"year":2022,"value":260382089.0},{"year":2023,"value":242287170.0},{"year":2024,"value":289375204.0},{"year":2025,"value":307095346.0}],"category":"Environmental Protection"},{"values":[{"year":2021,"value":10582903714.0},{"year":2022,"value":10062779667.0},{"year":2023,"value":10836172425.0},{"year":2024,"value":11819310397.0},{"year":2025,"value":13549193976.0}],"category":"Governance, Administration, Planning and Development"},{"values":[{"year":2021,"value":1505428167.0},{"year":2022,"value":1505692466.0},{"year":2023,"value":1510173707.0},{"year":2024,"value":1426655942.0},{"year":2025,"value":1551147397.0}],"category":"Health"},{"values":[{"year":2021,"value":1455630516.0},{"year":2022,"value":1453463343.0},{"year":2023,"value":1524245058.0},{"year":2024,"value":1583343084.0},{"year":2025,"value":1667130996.0}],"category":"Housing"},{"values":[{"year":2021,"value":347750221.0},{"year":2022,"value":261217688.0},{"year":2023,"value":329034133.0},{"year":2024,"value":395967691.0},{"year":2025,"value":413774541.0}],"category":"Other"},{"values":[{"year":2021,"value":3558160016.0},{"year":2022,"value":3582158016.0},{"year":2023,"value":3734207260.0},{"year":2024,"value":4178448867.0},{"year":2025,"value":4428281447.0}],"category":"Road Transport"},{"values":[{"year":2021,"value":1308247690.0},{"year":2022,"value":1251908423.0},{"year":2023,"value":1189243600.0},{"year":2024,"value":1301292647.0},{"year":2025,"value":1536984736.0}],"category":"Sport And Recreation"},{"values":[{"year":2021,"value":2349860844.0},{"year":2022,"value":2570537619.0},{"year":2023,"value":2662696175.0},{"year":2024,"value":2775275380.0},{"year":2025,"value":3048837074.0}],"category":"Waste Management"},{"values":[{"year":2021,"value":2342201755.0},{"year":2022,"value":2496046908.0},{"year":2023,"value":3112954437.0},{"year":2024,"value":3540401337.0},{"year":2025,"value":3518399162.0}],"category":"Waste Water Management"},{"values":[{"year":2021,"value":3218812128.0},{"year":2022,"value":7655737440.0},{"year":2023,"value":7122432608.0},{"year":2024,"value":8708150897.0},{"year":2025,"value":9021503557.0}],"category":"Water"}],"formula":{"text":"= All expenditure by function","actual":["=",{"cube":"incexp","item_codes":["4600"],"amount_type":"AUDA"}]},"formula_v2":{"text":"= All expenditure by function","actual":["=",{"cube":"incexp_v2","item_codes":["3000","3100","3200","3300","3400","3500","3600","3700","3800","3900","4000","4100","4200","4300"],"amount_type":"AUDA"}]}}},"demarcation":{"land_lost":[],"land_gained":[],"code":"CPT"},"muni_contact":{"url":"http://www.capetown.gov.za","phone_number":"021 400 1111","street_address_1":"Civic Centre","street_address_2":"12 Hertzog Boulevard","street_address_3":"Cape Town","street_address_4":"8001"},"mayoral_staff":{"officials":[{"name":"Geordin Hill-Lewis","role":"Mayor/Executive Mayor","email":"geordin.hilllewis@capetown.gov.za","title":"Mr","secretary":{"name":"Deirdre Borman","role":"Secretary of Mayor/Executive Mayor","email":"deirdre.borman@capetown.gov.za","title":"Ms","fax_number":"086 201 1851","office_phone":"021 400 9481"},"fax_number":"021 400 1313","office_phone":"021 400 1300"},{"name":"Lungelo Mbandazayo","role":"Municipal Manager","email":"lungelo.mbandazayo@capetown.gov.za","title":"Mr","secretary":{"name":"Amanda Naidoo","role":"Secretary of Municipal Manager","email":"amanda.naidoo@capetown.gov.za","title":"Ms","fax_number":"086 202 9098","office_phone":"021 400 1331"},"fax_number":"086 202 9098","office_phone":"021 400 1330"},{"name":"Edwin Andrews","role":"Deputy Mayor/Executive Mayor","email":"Edwin.Andrews@capetown.gov.za","title":"Mr","secretary":{"name":"Jolene Abrahams","role":"Secretary of Deputy Mayor/Executive Mayor","email":"jolene.abrahams@capetown.gov.za","title":"Ms","fax_number":"021 400 3368","office_phone":"021 400 4976"},"fax_number":"021 400 3368","office_phone":"021 444 3842"},{"name":"Kevin Jacoby","role":"Chief Financial Officer","email":"kevin.jacoby@capetown.gov.za","title":"Mr","secretary":{"name":"Tarryn Bell","role":"Secretary of Financial Manager","email":"tarryncindy.bell@capetown.gov.za","title":"Ms","fax_number":"021 400 5660","office_phone":"021 400 5021"},"fax_number":"021 400 5660","office_phone":"021 400 3265"}],"updated_date":"October 2026"},"audit_opinions":{"values":[{"date":2024,"rating":"unqualified","result":"Unqualified - No findings","report_url":"https://lg.treasury.gov.za/supportingdocs/CPT/CPT_Audit%20Report_2024_Y_20241212T111309Z_yolande_zeelie.pdf"},{"date":2023,"rating":"unqualified","result":"Unqualified - No findings","report_url":"https://lg.treasury.gov.za/supportingdocs/CPT/CPT_Audit%20Report_2023_Y_20240209T114722Z_yolande_zeelie.pdf"},{"date":2022,"rating":"unqualified","result":"Unqualified - No findings","report_url":"https://lg.treasury.gov.za/supportingdocs/CPT/CPT_Audit%20Report_2022_Y_20221201T123245Z_yolande_zeelie.pdf"},{"date":2021,"rating":"unqualified_emphasis_of_matter","result":"Unqualified - Emphasis of Matter items","report_url":"https://lg.treasury.gov.za/supportingdocs/CPT/CPT_Audit%20Report_2021_Y_20220221T084731Z_5039.pdf"}]}}