City of Tshwane
The City of Tshwane faces a challenge in accurately assessing and reporting debt impairment for consumer debtors in its annual financial statements. Compliance with GRAP 104.61 requires determining impairment loss as the difference between the carrying amount of debtors and the present value of estimated future cash flows. The complexity is amplified by the high volume of data involved, making the process highly time-consuming, prone to errors, and inefficient without an automated approach.
To address the challenge, we implemented a structured approach to evaluate long-outstanding debt. This included developing an impairment methodology based on the incurred loss model aligned with the City's financial policies and GRAP 104 requirements. We developed an automated valuation tool that significantly simplified the impairment calculation by automating complex financial assessments, reducing reliance on manual processes, and improving accuracy. We also conducted sensitivity analysis assessing the impact of changes in key inputs such as collection rates, discount rates, and economic conditions on impairment calculations.
The valuation model ensures that impairment calculations are consistent, transparent, and data-driven, improving financial planning and forecasting. Financial managers and stakeholders can make better-informed decisions regarding debt recovery strategies and provisioning. The adoption of the incurred loss model ensures the City's financial reporting remains accurate and credible. Automation significantly reduces processing time, allowing financial teams to focus on analysis and decision-making.
The project also integrated a critical risk management framework for debtor management and produced a comprehensive impairment report for submission to the Audit Committee. Looking ahead, the revised GRAP 104 standard introduces expected credit losses which will require ongoing adaptation.
Client
City of Tshwane
Industry
Government
Service
Actuarial Consulting
Let's discuss how The Shard can help your organization overcome challenges and achieve measurable success.