Tender Option Bond System- MuniManager

Description

MuniManager is a comprehensive software system designed for BrokerDealers, Trustees and Institutional Investors. The system combines Trust Creation and Management with credit analytics and monitoring tools designed to save time collecting and fielding data, identifying trading opportunities, assessing credit risk, and organizing historical credit reviews and ratings specifically with Tender Option Bonds in mind.


Challenge

A number of user groups within the Bank are currently involved in the maintenance of the TOB program. These groups use a combination of spreadsheets, standard and ad-hoc reports and other trading systems to track the TOB program from trust creation to termination. Thus, there is no single system which could enable the Tender Option Bonds desk to enter new trades, maintain these trades and allow them to generate adequate client reports. For a few programs, multiple spreadsheets are used to calculate components of the new trusts; then the trusts are managed out of finalized database spreadsheets. Various groups maintain their own calculations for the trusts to generate operational reports, risk reports, position reports and accruals reports. These reports are then circulated to the various clients according to their requirements. Event data, calls and redemptions are manually entered in to the system and frequent monitoring of other Bank systems have to be performed to be aware of any upcoming events. Without a centralized system to create, track and view all trusts, compilation of aggregate statistics is a difficult and time-consuming process. Since various groups work with their own set of data in the database spreadsheets, the same aggregations are repeated by different groups. The generation of payment date reports in various formats represents another challenge. Such difficulties not only limit the Tender Option Bonds desk to be continuously involved in the required report generation but also limit the scalability of the operations. In addition, the frequency of such reports is also limited. Since its inception, the TOB program has continuously evolved; many practices, conventions and rules have been changed. Due to an absence of a centralized tracking system, a number of fields and values that may be required are being left to be tracked in hard copies or through multiple internal systems. This arrangement presents several problems. Firstly, different individuals maintain different sets of data in their own spreadsheets, and therefore advances to one program cannot be leveraged for other programs. Secondly, due to the inherent nature of shared files, the spreadsheets do not allow concurrent users. This isolation becomes specially taxing on payment dates where a number of trusts may need to be modified. Current processes of updating the spreadsheets with position changes and weekly rates and then DTC with the changes in Floater positions and amounts require duplicate manual updates. This is not an ideal scenario. Firstly, manual entry of the same changes in the positions and amounts is very inefficient. This task is especially taxing considering the large number of trusts being managed by the Tender Option Bonds desk at Bank. The clients have repeatedly requested more frequent reporting as well as automated feeds to synchronize the data with Bank. Some of these requests have to be manually serviced daily and others can only be performed infrequently. Certain types of information cannot be stored historically in the spreadsheets due to the immense amount of data this would generate. Consequently, both performance and capacity are constraints affecting the current process of managing the trust program. There is also some risk associated with the location of data on spreadsheets. Since local copies of the database are spread amongst various users, and are updated separately by them, the loss through hardware failure or by an inadvertent mistake by the user may result in substantial delays in recreating the lost information.


Solution

Functionalities- A centralized database and system for trust programs Historical data, comparison to prior periods. All major trust types supported Customized reports. Support for events and activities for regular maintenance of active trusts along with regeneration of amortization and accretion schedules as necessary. Trust-Structuring Editor- multiple underlying assets lot entry allocation methods for matching multiple floater and residual certificates with underlying assets upfront and ongoing fees specifications audit tracking of changes amortization and accretion schedule generation ticketing of settlement costs automated links to third party sources for bond reference data. Cash-Flow Generator- various asset classes; VRDN, Fixed Rate, Zero Coupons, Step Up coupons, etc. daily flows aggregated by period or a range of dates floater and residual interest computations events. A centralized database and a system for the various TOB programs will produce a number of benefits. Innovations to the trust programs will be much easier by the implementation in a single, centralized system. Every user will have access to different parts of the same system. The cashflow generator will be the same for all types of reports and data generation for export to other systems. This will eliminate the possibility of errors introduced through the use of multiple spreadsheets managed by different users. The system will reside on the firm’s centrally supported data servers, ensuring robust and rapid access. The issue of delays due to errors or losses due to hardware or software errors is addressed through a database system that has duplication of data, failsafe recovery mode, and traceable, recorded audit logs of all changes to the data. Processing by the different user groups will be much more streamlined, saving time, effort and resources. The system will have sufficient capacity to house all trust programs in one system. Historical data will be stored allowing for comparison to prior periods. Specialized code will generate data values required by internal systems or user reports and these reports will be more user-friendly. The need for duplicate entry of various values will be eliminated and single consistent value will be maintained for each field. It will be much easier to generate aggregate statistics. The functionality for detecting upcoming events, track and renew expirations of various fee parameters, tracking of interest rate changes, redemption notices etc. would help serve the clients of Bank better. Better tracking of these fields will aid in more accurate and frequent reporting to the clients. Automated position reports and payment data reports will reduce errors incurred in manual entry of events details. Uniform rules implemented, tested, and checked in a single system eliminates the duplication of calculations required in a separate spreadsheet-based process.


Image Gallery