Debt Management Software

The Vendor is required to provide a debt management software solution to manage all of the city’s debt portfolio.
- The City currently uses an Excel workbook and various Excel tools for debt tracking and forecasting and would like to move to an all-inclusive software solution.
- The software package should also be SaaS/cloud based, have the capacity to integrate with the City’s ERP system, and will provide maintenance and support. 
- Services may consist of planning, organizing, installing, configuring, and testing for acceptance and compatibility with City systems and user training on the Software.
- The workbook is used to bill city departments for their portion of debt service; pull information on outstanding debt; debt payment dates; information about each issue (e.g. legal authority, ordinance number, authorization issue amount, amount issued, refunding information, repayment source, taxable vs. tax-exempt, departmental billing codes; etc.).
- A series of data sorts is required to retrieve needed information. For department debt bills, a tab was created using a billing template with formulas that extract needed data (e.g. billing codes, debt service due, etc.) from the debt portfolio tab.
- Debt Issuance, Structure and Sizing:
•    Performing projections and preliminary sizing of fixed rate, variable rate, current refunding, advance refunding, cash defeasance, temporary financing, short-term debt instruments, etc. including, but not limited to, proposed sources and uses, cost of issuance and projected interest rates by maturity.
- Debt Management - ability to provide information specific to a bond issue, such as sources and uses of funds, and provide for the following:
•    Maintenance of all debt payment schedules, including but not limited to payment source;
•    Scheduling of all debt payments by due date, principal, interest and fees, total due by department, by fund and accounting line item(s);
•    Calculation of all year-end accounting adjustments by bond issue and loan, fund and accounting entry, including accrued interest, reversal of prior year accrued interest, amortization of premium and discount and deferred charges;
•    Tracking of bond spending;
•    Tracking of actual bonds by CUSIP within each bond issue for continuing disclosure purposes;
•    Tracking of actual debt payments made by bond and loan, principal and interest, and date;
•    Produce an invoice template for each department’s debt service payment due;
•    Ability to transfer the City’s Excel-based debt database (including multiple identification layers) to the proposed new system;
- Debt Analysis - allowing calculation of pro-forma amortization schedules at the bond level to determine effect on other debt outstanding, and provide for the following:
•    Debt forecasting, including multi-year funding of capital improvement budgets;
•    Debt capacity and cash flow analysis by repayment source (e.g. Property Tax, Income Tax, etc.);
•    Debt burden analysis (in line with rating agency metrics);
•    Refunding analysis.

- Contract Period/Term: 5 years
- Questions/Inquires Deadline: December 10, 2025