The overall findings are as follows:
â¢ Non-Standard Broker Data â as with every business process, data capture and standardization is a critically important prerequisite for process effectiveness. Non-standard file and data formats, as well as lack of robust delivery methods, hamper the ability to achieve a high level of process automation
â¢ Adoption of Specialized Software â larger firms utilize specialized applications software, while small to medium sized firms use Excel to varying degrees. End to end automation is rare for all firms
â¢ Use Highly Skilled Staff/Achieve Acceptable Control Levels â given the process complexity and the potential financial consequences associated with errors, highly skilled knowledgeable workers tend to be used to overcome the inherent data and systems limitations
Current State of Technology
The survey revealed that 76% of the total firms have some type of a central repository that hold some or all of their collateral and margin data. Of these, 44% utilize 3rd party software; 38% have a propriety database, and the remaining 18% store their data in Excel. Just over half of the firms which use Excel have AUM of $5 billion and under (evenly split between firms of under $1 billion and $1 to $5 billion AUM).
With respect to investment into technology, overall spending anticipated for 2010 versus that spent in 2009 will be the same for 73% of the firms, with 18% increasing and 9% decreasing their investments. However, of the smaller firms (AUM of $5 billion or less) with 2009 and 2010 technology budgets, spending for those firms will increase for 20% and remain the same for 80%.
Major Pain Points in the Collateral Management Process
Despite the fact that a large number of firms have a system in place (as indicated earlier), 50% of the total number of respondents stated that they still restrict trading in derivatives to a limited number of brokers due to data and technology limitations. In fact, 73% of the respondents who restrict their trading do have a system in place â and these included an almost equal proportion of firms from each AUM category. It is important to note that 93% of the firms who restrict trading rate their ability to complete their collateral management process as either timely or very timely. However, the majority of those respondents do not consistently redeploy excess collateral at their brokers.
The top pain points identified were as follows:
â¢ Broker files not leverageable for automated data extraction (56%)
â¢ Non-standard broker file formats/layouts (52%)
â¢ Lack of industry standard financial instrument IDâs for matching (64%)
Functionality Most Desired
In view of the challenges, greater recognition is anticipated to be given to an automated approach to collateral management putting specific functionalities of the available systems in the spotlight. According to the survey, the following three functionalities were ranked as the most vital when choosing a system:
â¢ Central repository for all collateral & margin related data (80%)
â¢ Position holdings matching and margin reconciliation (75%)
â¢ File collection and data transformation/normalization (61%)
Reporting and Risk Management
Considering the importance of risk management, surprisingly less than 50% of the firms indicated providing daily exposure reports to management. Yet, just over 60% of the respondents stated they have either very strong or a strong level of internal controls; another 20% considered their internal controls average. In both instances, responses were almost equally shared between firms across all AUM categories. The remaining 20% of the responses, indicating fair or weak level of internal controls, all belonged to firms with under $1 billion AUM.
Best Practices Achieved
According to the survey, despite the challenges and technology limitations, a significant number of firms perform daily execution of the operational risk management exercises. The results were as follows:
â¢ Reconcile Collateral (63%)
â¢ Verify Broker Margin (63%)
â¢ Match/Reconcile Holdings (60%)
It is important to note that the high results are almost equally shared between firms from all the AUM groups.