A. Municipal bond debt management software that can be utilized to assist the Authority with maintaining its debt portfolio. The Authority intends to utilize the software to: • Maintain all debt payment schedules for issued and refunded debt • Track the lineage of each bond issue and store all historical schedules (pre-refunding) in the application • Track and report on all projects and campus data for each bond issue, lease and subscription • Schedule all debt payments by due date, principal and interest and fees, total due, department, fund, and accounting line-item information • Calculate and book journal entries on a monthly, quarterly, semiannual and annual frequency • Calculate 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 • Prepare automated end-of-year financial statement note disclosures for debt • Calculate accrued interest, interest expense calculations and amortization of premium and discount as of any specified dates • Track bonds by CUSIP within each bond issue for continuing disclosure purposes • Track actual payments made by bond and loan (e.g., by campus and project), principal and interest, and date • Generate reports that, at a minimum, provide detailed amortization schedules, debt service payment schedules, and outstanding debt schedules defined periods of time – one year or multiple years by year (calendar or fiscal). For example, debt service reports on 5/1 & 11/1 at each level, authority, campus, owner, and project • Export reports via Excel and PDF • Provide customizable reminders and notifications, and alerts to be distributed to a list of specified recipients for bond reporting • Model potential new money and refunding bond issuances, and observe and analyze the impact of modeled scenarios on the Authority’s existing debt portfolio B. Software that will assist the Authority with maintaining and reporting all lease and/or debt related information required for reporting lease information under GASB 87. The GASB 87 software, at a minimum, should include functionality that will: • House leases and related data and information in accordance with GASB 87 • House debt agreements or other supporting documentation required for reporting GASB 87 information • Prepare all monthly, quarterly, and annual journal entries required for reporting compliance with GASB standards related to leases and debt agreements • Prepare all footnote disclosure data items required for compliance with GASB 87 and GASB 89 C. Software that will assist the Authority with meeting the post issuance compliance requirements of municipal bonds, and specifically, with conducting private activity analysis associated with issued debt. The post issuance compliance software, at a minimum, should include functionality that will: • Track the Authority’s recorded allocation and expenditure of bond proceeds • Catalog responses to the Authority’s private activity surveys • Calculate ratio covenants in accordance with Authority’s trust agreement
