Debt Manager Analytics System

The vendor is required to provide debt manager analytics system software as a service, after all transaction has occurred as stated in the cloud special provisions, all data will be permanently destroyed as according to state administrative manual 5300.
- Debt management tool (DMT) to warehouse and store current and historical debt data including commercial paper (CP) issuances, generate debt service or debt and CP related reports, provide market intelligence, allow innovative scenario analysis, and provide workflow tools to automate journal entries, accounting calculations, and end-of-year financial statement note disclosures. 
- The DMT shall at a minimum meet the following requirements:
•    Be a cloud-based debt management software with unlimited licenses for both internal and external professionals.
•    Must support single sign on using microsoft azure-based security assertion markup language (SAML) provider
•    A central database to store all bond-related documentation. 
•    Must be a commercial off-the-shelf (cots) software
•    Provide a thorough document repository for all current and historic bond obligations searchable in the application (documents can include pdf, excel, or word documents). 
•    ability for outside professions, such as bond counsel and municipal advisers, to upload documents and associate them with specific issues on division behalf. 
•    Provide customizable alerts at the user level, that includes email notifications for specific requirements regarding continuing disclosure dates, call dates, and any additional dates division would like to track. 
•    Capable of tracking all outstanding debt by the committee. 
•    Capable of tracking all CP issuances by series, issuance number, and project. 
•    Capable of automated report detailing outstanding and discharged debt on a maturity-by-maturity basis, including cu committee sip numbers, call provisions, and pricing information. 
•    Capable of automated report detailing outstanding CP by series, issuance number, and project. 
•    Capable of tracking bond refunding by partial committee. 
•    Produce debt service schedules for the portfolio for defined periods of time – one year or multiple years by year (calendar or fiscal). 
•    Comprehensive payment workflow tool to verify invoices, track variance, and record actual payment activity in real time. 
•    Automated allocations and tracking for debt payments across multiple dimensions, including type, fund, purpose, and project. 
•    Provide a report of all debt payments broken down by type, fund and the corresponding general ledger (GL) codes. 
•    Have the ability to facilitate and store any type of GL string in association with each obligation. 
•    Have the ability to breakout and report on the current and long-term portion of debt.
•    Have the ability to calculate accrued interest and interest expense calculations as of specified dates. 
•    Have the ability to calculate and book journal entries on a monthly, quarterly, semiannual and annual frequency. 
•    Provide a collaboration workflow that captures debt invoice payment processing, approval, and provides audit trail and journal entry. 
•    Have the ability to calculate accreted interest for capital appreciation bonds as of specified dates. 
•    Have the ability to track the lineage of each bond issue and store all historical schedules pre-refunding’s in the application
•    Provide the tracking of historic debt service payments, including any refunding’s that occur. 
•    Have the ability to see their debt as of any date, both historical and forward looking.
•    Have the ability to calculate premium or discount amortization including the current and long-term portions by effective and straight-line method. 
•    Have the ability to calculate reduction in outstanding premium and discount when a refunding occurs. 
•    Have the ability to create summary of outstanding debt and debt service tables for financial reports including note disclosures. 
•    have the ability to track all parties involved in each bond sale transaction. 
•    Have the ability to generate amortization schedules, payment schedules, and outstanding debt schedules exportable to excel. 
•    Have the ability to provide technical support to ensure each debt issuance is accurately entered and updated in the DMT. 
•    Allow the generation of all maturity level detail for each outstanding issue, including committee, call date when callable, coupon, yield, original issue price, and yield to maturity. 
•    Provide functionality that assists in forecasting of future payments for multiple uses – budget, capital replacement, disclosure, annual reports. 
•    Provide the ability to track multiple project allocations across a single issue. 
•    Provide the ability to share real-time data among internal members at department and outside consultants through separate, role-based logins. 
•    Be maintained in a secured platform with password-protected user access. 
•    Provide the ability to run queries based on any date range. 
•    Allow for the export of queried data and tables into excel.

- Contract Period/Term: 3 years
- Questions/Inquires Deadline: September 30, 2025