II. SERVICES The Solution must be capable of fully processing all of the security types allowed by Minnesota State Statute 118A, according to GAAP and securities industry conventions for revenue, amortization and valuation conventions, for at least the following investment instruments, funds and accounts: • United States securities such as treasury bills, notes, and bonds • State and local securities such as general and revenue obligation taxable and tax-exempt municipal bonds • Commercial paper • Time deposits • Certificates of Deposit (CDs) • Mortgage-backed securities excluding high-risk mortgage-backed securities • Repurchase agreements and reverse repurchase agreements • Shares in a joint powers investment trust authorized under Minnesota law • Guaranteed Investment Contracts (GICs) • Options and future contracts • Indexed mutual funds • Money market funds • Common Stock • Cash More explicitly, the breadth of the City’s need consists of: • Accounting. Full monthly portfolio and security level accounting for securities income including realized and unrealized gains and losses. This will include amortization of book value on fixed income securities not purchased at par. • Aggregation. Automated aggregation of transaction data from multiple financial institutions. • Analytics. Able to generate total return before and after fees and versus benchmarks at the portfolio and sub-portfolio level as well as provide effective duration, various yields, weighted average maturity, etc., at those levels. • Reporting. Full reporting capabilities of holdings and transaction activity including the associated bond ratings and other portfolio data elements in PDF, Excel, and cloud-based format. The Solution must have the ability to handle user-created nested conditional custom fields or similar functionality for compliance monitoring activity, to automatically market price common securities on a daily basis, and to provide the ability to manually price illiquid investments.
