Texas Public Finance Authority Home



Texas Public Finance AuthoritySelected Forms Related to Appendices A, B C and EAddendum No. 1RFO No. 347-15-0054Debt Finance and Management Software and ServicesAddendum Release Date: April 10, 2015Due Date: June 1, 2015 - 2 p.m., CZT, at: Texas Public Finance AuthorityWilliam P. Clements Building300 West 15th Street, Suite 411Austin, Texas 78701APPENDIX A - GENERAL INFORMATION AND OVERVIEW OF COMPANYNo.ItemTo Be Completed by Offeror1Company Name:2Address:3City:4State:5Zip:6Texas Identification Number:7City/State Headquarters Location:8Closest Office to TPFA’s Austin Address:9Website Address:10Date Company Founded:11Number Years in Business Under Current Company Name:12Form of Company Ownership (e.g., LLC, Corporation):13Total Number of Employees:14Total Number Active Clients:15Total Number of State/Local Government Clients:16Total Number of Public Users in Texas:17Lead Account Contact Name:18Contact Telephone Number:19Contact Email Address:20Industry (NAICS) (North American Industry Classification System):APPENDIX B - PRICING SHEETVendor Name:APPLICATION AND SERVICES BASED ON A TOTAL DOLLAR COSTITEM NO.APPLICATION SOFTWARE (BY MODULE)SOFTWARE LICENSE COST1INITIAL INSTALLATION AND SETUP COSTINITIAL TRAINING COSTANNUAL COST OF MAINTENANCE/TECH SUPPORT1?????2?????3?????4?????5?????6?????7?????8?????9?????10?????11?????12?????13?????14?????15?????16?????Note 1 - Software license cost should be priced for four (4) concurrent usersOTHER SERVICES BASED ON AN HOURLY RATE2 ITEM NO.TYPE SERVICEHOURLY RATECOMMENT17Software modification??18Data conversion services??Note 2 - (Indicate the hourly rate for each of the services identified under "Other Services," and include any comments that will aid TPFA's understanding the full scope of each service)APPENDIX C - REFERENCE LISTName of Client:City:State:Concurrent Users:Name of Modules Installed:Go Live Date:Contact Person:Telephone Number:Email Address:Name of Client:City:State:Concurrent Users:Name of Modules Installed:Go Live Date:Contact Person:Telephone Number:Email Address:Name of Client:City:State:Concurrent Users:Name of Modules Installed:Go Live Date:Contact Person:Telephone Number:Email Address:Name of Client:City:State:Concurrent Users:Name of Modules Installed:Go Live Date:Contact Person:Telephone Number:Email Address:APPENDIX E - REQUIREMENTSNo.DescriptionRatingHow is requirement accomplished?General RequirementsSoftware and Operations1Commercial off-the-shelf software/database application proven and tested2Modules that comprise a particular system are integrated and seamless3Multi-user client-based/server4Holds complete history of all debt obligations and other data 5Information/data is available for displaying, printing and exporting6Ability for up to 4 users to concurrently and simultaneously, to work in application in the same module at the same time, as well as generate reports against the same data at the same time7Real-time processing in every module8Multiple year history to be maintained separately, by year or in the aggregate9Ability to access user defined fields via queries and reportsStandard and Flexible Reporting10Report writer (proprietary or licensed for a program such as Crystal Reports)11Ability to save custom reports from queries or system-generated data12Customizable templates for standard reports13Report criteria selection via drop downs, queries, or pick lists14All reports can be electronically displayed or printed in hard copy, PDF, Excel and Word formats, and exported to other systems.Flexible Interfaces15Ability to drill-down from screens, fields or reports from summary to transactional detail16Provides drop-down menus containing both standard and user defined choices17Ability to import and export data for user controlled manipulation in ASCII delimited and also in formats compatible with Microsoft Office (e.g., Excel)18Interfaces efficiently with TPFA’s existing client/server and workstation platforms (MS SQL or ODBC compliant database)19Operate in 32-bit and 64-bit compatible environment20Ability to directly link to external documents such as spreadsheets and word processing documentsInternet Capability21A web interface with the capability of transmitting information and reports such as debt service schedules, combined indebtedness, and other reports and statements on TPFA’s website for access by client agencies and other stakeholdersProduct Training and Support22Complete on-line help function for each module23 Online (e.g., email, chat, Q&A) or phone support to all TPFA usersSecurity24Database encryption of data both in transit and at rest25Complete chronological audit trail of who has accessed, created, or modified each data entry item26Use of single/multi-level passwords27Role based security where users can be assigned to multiple roles or functions28Modify, view or restrict access controls for users29A web-based library of training courses and articlesAPPENDIX E - REQUIREMENTS(continued)No.DescriptionRatingHow is requirement accomplished?Debt Sizing/Structuring1Supports a broad range of debt obligations such as bonds, notes and commercial paper2Accommodates different structuring options such as credit enhancement, debt service reserve, fixed and variable rate debt, maturity schedule, (i.e., level debt service, level principal service, ascending debt service payments, or modeled after a user defined revenue stream), serial and term bonds, zero coupon and capital appreciation bonds (CABs), premiums/discounts, and redemption provisions3Ability to handle debt obligations based on tax status, maturity date, coupon type, distinct interest payment, maturity frequency, overlapping and bifurcated maturities, and redemption provisions4Ability to track CUSIP level data 5Supports all bond types such as serial bonds, term bonds, callable bonds, credit enhancements, original issue premium, original issue discount, par, capital appreciation bonds (CABs), zero coupon bonds, and variable rate securities6Sizes project funds to cover multiple separate draw schedules, yields, either gross or net-funded7Provide robust summaries and detailed reports and charts based on multiple criteria including issue date and project, as well as a package of reports that includes a cover page and table of contents for the report package8Handles all elements in sizing bonds, including construction draw schedule, issuance costs (e.g., underwriters discount, bond counsel, financial advisor) original issue discount/premium, accrued interest, capitalized interest, contingency fund, debt service reserve fund, and credit enhancement fees9Calculates expenses based on a formula or fixed dollar amount, and able to compare actual versus budget10Handles formulas used in sizing new and refunding bond issues, including items such as defeasance escrow costs, underwriter discount, outstanding debt service or revenues, SLGs, reserve funds, capitalized interest, and insurance premiums 11Price bonds to yield to maturity, yield to call, worst call date12Link, download, and integrate Bloomberg or other service(s) into the sizing module13Sizes investments based on future revenues14Adhere/comply with federal income tax code and regulations and related computations15Performs insurance breakeven analysis16Calculates TIC, NIC, arbitrage yield and other bond cost summary statistics17Export and import data to and from Excel, Text, or PDF18Ability to record bond agent and responsibilities (e.g., disclosure counsel), calculations of total and average takedown based on the amount of bonds allotted, and to produce reports including user defined fieldsAPPENDIX E – REQUIREMENTS(continued)No.DescriptionRatingHow is requirement accomplished?Bond Program Maintenance, Monitoring, Refunding and Reporting1Stores and tracks a complete history of outstanding debt (i.e., original issue, refunding, and commercial paper), from issuance through maturity2Ability to record original budgets, amendments to budgets, and actual expenditures of bond proceeds3Performs analyses of potential bond refundings based on certain market conditions that meet savings criteria for all types of refundings4Ability to attach or link crucial documents prepared by bond counsel and others to the system, including disclosure filings5Ability to record original, amendments and actual expenditures of bond proceeds 6Ability to handle multiple calendars to track bond events, including tickler files containing to-do-lists, document processing, meeting schedules, call-back notes, follow-up reminders, or any other information requiring organized arrangement that a person may require to access or take future action 7Ability to track bond authorizations and remaining authorized but unissued8Ability to track each issue’s profile (e.g., credit ratings, enhancements, tax status, etc.)9Ability to forecast debt service for any period basis using “as of” start and ending dates10Ability to allocate expenditures to bond proceeds, including reimbursement of pre-issuance expenditures, consistent with those used for arbitrage purposes11Robust set of industry standard reports that meet requirements for payment reconciliation, budget forecasting, accounting, and compliance reporting, including calculation, tracking and reporting the amortization of cost of issuance and original issue premium/discount expenses12Ability to track all bond issuance expenses, both estimated and actual, and by issue, firm, and for any type of service 13Ability to allocate debt service to different capital projects by agencies by percentage or dollar amountRefundings14Ability to evaluate refunding candidates from entire history of transactions15Handles and performs analyses for Ability to evaluate current, advance, crossover and forward delivery refunding transactions16Models partial and full defeasances17Ability to measure savings in terms of true dollars as well as in future or present value dollars based on different interest rates18Ability to run and save multiple what-if analyses19Manages and sizes multiple escrows, bifurcated escrows, transferred proceeds and funds on hand for proper allocation to escrow accounts20Ability to incorporate multiple portfolios including State and Local Government Series Securities (SLGS), Open Market Securities (OMS) or a combined escrow portfolios using one or more sources of funds, each with its own investment parameters21Ability to record the name of an organization, date, and dollar amount for approvals rendered by entities such as the Legislative Budget Board (LBB), Bond Review Board (BRB), and the TPFA board APPENDIX E – REQUIREMENTS(continued)No.DescriptionRatingHow is requirement accomplished?Bond Allocations Function1Ability to allocate bonds by legislative authority, agency, fund, facility and/or site, project, and original project amount 2Ability to record in a separate field amendments to original project budget amount3Ability to record in a separate field actual project expenditures against original or amended budget amounts4Ability to report bond allocations based on a user defined sort order, comparing original project amount, amendments, and actual project expenditures 5Ability to track or allocate projects by agency and project, across all fundings, fixouts, and refundings, including commercial paper and bond transactions6Ability to report debt service by project across all fundings and refundingsAPPENDIX E – REQUIREMENTS(continued)No.DescriptionRatingHow is requirement accomplished?Commercial Paper Program Software11Ability to set the parameters for eligibility ($10,000 minimum; $100 individual item cost; useful life => 3 years)2Ability to add user defined data fields to the lease application input screen3Ability for client agency to apply through a web interface4Ability to custom design format and data elements that make-up the customer data5Ability to track individual assets, for example, by category, description, serial number or VIN, quantity, dollar amount, useful life 6Ability to customize/incorporate certain required data into appropriate input screens (see Exhibit A-1, Master Lease Purchase Agreement for specific data/information needed). 7Ability to create a user defined checklists integrated within a workflow process to facilitate lease application processing to final approval/disposition8Ability to print review before printing documents or reports9Ability to maintain a library of user specified lease documents10Ability to prepare user defined documents (from a library of lease documents) during the application process, track the disposition of documents and provide reporting on all documents either provided by or sent to the applicant. The system should be able to track acceptances, rejections, and requests for additional information.11Ability to create user letter templates with text, mail-merge, and graphics12Ability to track all communications with client agencies including emails, phone calls, and advance schedules, reminders or notifications (and ticklers) for further action or processing13Ability to enter and track leases and documents, from entering and funding the lease to closing the lease14Ability to print user defined invoices and/or statements15Ability to handle payment delinquencies and assess user-defined penalties16Ability to handle all types of leases17Ability for the user to define the type of program (e.g., MLPP, Charter), lease class (e.g., vehicles) and specific information typically required for a class18Ability to handle a variety of different payments according to user defined rules, including early, partial, or full payoff19Ability to set a rate that is fixed, variable, variable tiered, blended, or pegged to another rate; simple or compounded20Ability to handle installment leases and generate payment schedules based on variety of different payment plans (e.g., level debt)21Ability to handle leases for a fixed amount or drawn up to a specific credit limit or threshold22Ability to establish payments based upon a projected loan schedule, or calculated and pro-rated at the time of payment without a fixed loan schedule23Permit draws during the term of the lease up to the established limit for each client agency as determined at the origination of the lease24Incorporate methods for handling underpayments/overpayments (e.g., reduce payment amount, reduce term, apply to final balance, apply to next scheduled payment)25Ability to setup user defined fees (e.g., origination fee or administrative fee), manually or automatically, by dollar, percentage or a combination of both26Ability to select from a number of standard or custom calendars used for interest rate calculations, both 365 and/or 366 days27Record a budgeted interest rate for each loan by client agency across all planned payments, and later change to an actual rate for each interest payment due over the life of the borrowing28Ability to handle lease restructuring, merges and splits29Ability to user define and set and track fees due and payable30Ability to export reports through email, Excel or PDF, or text exports for mail merges 31Ability to report information such as the client payment schedule, outstanding leases, projected interest accrual, payment due based on an “as of” date, lease detail (and limits), transactions, collateral reportsCommercial Paper Issuance232A system to record all commercial paper transactions for the different types of commercial paper programs, including those certificates originally issued, cancelled, outstanding, rolled over, retired (paid off), or refinanced33Ability to issue a certificate and allocate the total dollars by client agency, contract ID, class, program/project, dollar amount, and percentage, or any combination of changes to any of these factors, when CP tranche is split or partially rolled over34Ability to adjust/track any changes made to the underlying detail (e.g., a change in a client agency’s project or dollar allocation) of a certificate from the original allocation for any of the factors identified in Item 32 above 35Ability to set interest rates that are fixed, variable, variable tiered, or pegged to some other schema36Ability of the system to perform calculations for both interest bearing and discounted paper37Ability to display or print individual certificates, for example, by date range (or all) for outstanding CP, interest due, interest paid, maturities due, new clients added, new issues added, cancellations, client agency allocated portion of each certificate, accrued interest, or selectively by client agency 38Ability to choose standard or user custom designed calendars39Ability to generate reports, for example, on outstanding certificates, cancelled or matured certificates, daily transactions, roll overs, refinanced certificates, and audit reporting detailing all transactions40Ability to display, print or export reports/data to Excel, Word, PDF, Text41Ability to custom query/report ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download