RFI-0001- Request for Information- Domestic and Global Financial Institution Data Source- Updated Jan 17.pdf

REQUEST FOR INFORMATION (RFI)

Domestic & Global Financial Institution Data Source

Vendor, Industry, & Market Research Platform

Applied Research & Methods Department

A. Description

THIS IS A REQUEST FOR INFORMATION (RFI) ONLY. This RFI is issued solely for information and planning purposes – it does not constitute a Request for Quote (RFQ) or a promise to issue an RFQ in the future. This request for information does not commit the Government to contract for any supply or service whatsoever. Further, the Government is not at this time seeking quotes and will not accept unsolicited quotes. Respondents are advised that the U.S. Government will not pay for any information or administrative costs incurred in response to this RFI; all costs associated with responding to this RFI will be solely at the interested party’s expense. Not responding to this RFI does not preclude participation in any future RFQ, if any is issued.

Statement of Work (Sections B-D)

B. Background

At the behest of the US Congress, the Government Accountability Office monitors a wide variety of banking regulators’ efforts to identify and respond to emerging threats to the safety and soundness of U.S.

depository institutions and the stability of the financial system. Addressing these congressional interests requires GAO engagement teams to have access to data services that compile financial and regulatory filing

(call report) data and market information for financial institutions. The Government Accountability Office

(GAO) intends to purchase access to a comprehensive information source that maintains and updates domestic and select foreign banking, insurance, and financial institution data to support GAO’s congressionally mandated and requested studies. Specifically, the resource GAO intends to purchase will provide Consolidated Reports of Condition and Income, also known as Call Reports, for every national bank, state member bank, insured state nonmember bank, and savings association. Call Reports and other financial data support efforts that allow the agency to fulfill its work for the US Congress in the areas of banking and finance. GAO’s banking and finance analyses are available to the public at the agency’s web site: http://www.gao.gov

C. Scope

GAO’s objective is to procure a compatible product, with the offerings as described below, in the commercial market place.

GAO’s Financial Markets and Community Investment team responds to requests and mandates from

Congress to evaluate a variety of issues facing U.S. and foreign financial institutions. As part of its research and analysis process, GAO uses commercial databases to provide information from experts and third party sources so that the agency’s reports to Congress are as accurate and complete as possible. The database requirements described in this document will assist GAO in completing the analyses requested by Congress http://www.gao.gov/ in the areas of domestic banking trends and conditions of financial institutions, and conducting ongoing efforts to monitor and report on emerging risks within the financial markets.

D. Requirements

Minimum Access and Usage Requirements

The resource for which GAO intends to purchase access must have at a minimum:

Be accessible via an Internet URL, a desk-top application, or an application added-on to

Microsoft Excel, or a combination of the three methods.

Access must be via IP recognition or user accounts.

For user account access, we intend to purchase licenses providing concurrent access for up to 250 staff.

Products (or combinations of products) which require multiple interfaces are not acceptable nor are products/services that require specialists to build specialized spreadsheets or data sets.

The product must be commercially available. Any product requiring custom builds is not acceptable.

GAO analysts will rely on these data to support GAO engagements.

The resource must have ample documentation to support the reliability of the data housed in the database. As such, the resource will need to have data dictionaries, white papers, and or other supporting documentation to show the origin of any data and or analyses cataloged in the database.

The data will be used with proper citation in GAO audit documentation.

Any data found in the system will be made accessible to any GAO team on an as needed basis.

All data used to support GAO engagements will be saved in GAO’s records repository and managed in accordance with GAO’s records retention schedule.

Specific Product Requirements

GAO Dashboard for Monitoring of Emerging Risks

The database GAO intends to purchase will provide support for the Emerging Risks Monitoring Program dashboard. The dashboard is a GAO-designed series of charts and spreadsheets. The dashboard allows

GAO to monitor the banking industry and the industry’s associated regulatory agencies.

Excel Add-On

The product purchased will need to provide an interface/add-on to Excel that can be programmed to connect to the product and pull Call Report data based on GAO determined search criteria. The pulled data must automatically update a series of charts and graphs within an Excel workbook that are used by GAO analysts to analyze the financial performance and condition of U.S. banks.

Data Requirement

The following data classifications and named elements must be in the product. Any lack of the named elements in the stated formats will render the product unacceptable.

Bank Size Classifications

For ease of analysis and peer comparison, the solution should provide ways to categorize banks and their data by various balance sheet measures such as total assets. The data elements listed below should be provided quarterly and annual coverage on an aggregate basis, with a minimum 15-year history with the option to view the data on a quarterly or an annual format.

NOTE: Data should also be displayed on an individual institutional basis in addition to an aggregate basis.

1. Capital

Capital Adequacy

Common Equity

Tier 1 (%)

Tier 1 Risk-based

Capital (%)

Total Risk-based

Capital (%)

Leverage ratios (%)

2. Assets

Asset

Quality

Nonperforming

Loans (NPL)-to-Loans (%)

Adjusted

NPLs-to-Loans

Nonperforming

Assets (NPA)-to-Loans (%)

Adjusted

NPA-to-

Loans

Total

Noncurrent

Loans/Loans

Reserves/NPLs

Net Charge-offs

(NCO)/Average

Loans (%)

Other

Real

Estate

Owned

(OREO)

to Total

Loans

Texas ratios

3. Earnings

Earnings strength and profitability

Cost of

Funds

Yield on

Loans and

Leases

Yield on

Earning

Assets

Efficiency ratio (%)

Noninterest

Income to

Operating

Revenue

Net interest

Income to

Operating

Revenue

Return on

Average

Assets

(ROAA)

Return on

Average

Equity

(ROAE)

Net

Interest

Margin

(NIM)

Yield on

Debt and

Equity

Cost of

Interest

Bearing

Deposits

4. Liquidity

Liquidity

Indicators

Liquidity

Ratio (%)

Liquid

Assets-to-

Assets (%)

Loans to

Deposits

On-hand

Liquidity to

Liabilities (%)

Net NonCore

Funding

Dependence

Reliance on

Wholesale

Funding (%)

Deposits to

Assets (%)

5. Sensitivity to Market Risk

Market

Risk

Long-term

Assets to

Assets (%)

Non-maturing

Deposits to-

Long-term

Assets (%)

Residential

Real Estate to Total

Assets (%)

Rate Sensitive

Assets to Assets

Rate Sensitive

Liabilities to

Assets (%)

One Year Gap to Assets (%)

One Year

Cumulative

Repricing

Gap (%)

6. Credit Risk Monitoring

Market

Risk

Loan

Growth

Rates (%)

Debt to

Equity

Ratios (%)

Equity to

Asset Ratios

Gross Loans to

Assets (%)

Loans and

Lease

Allowance to

Total Loans and Leases (%)

Deposit

Growth (%)

7. Liabilities & Equity

Funding

Mix

Demand and

Foreign

Deposits to Total

Deposits

MMDS

and other

Savings

Accounts to Total

Deposits

Subordinated

Debt to Total

Debt (%)

Commercial

Paper

($000)

Short-term

Borrowings

($000)

Total

Fed

Funds and

Repos

($000)

Trading

Liabilities

($000)

Preferred

Stock and

Surplus

Total

Equity

Capital

($000)

8. Asset Mix

Asset

Mix

Treasury

Securities

($000)

Cash and

Balances

Dues

($000)

Fed

Funds

Sold and

Reverse

Repo

($000)

Mortgage-

Backed

Securities

(MBS)

($000)

Asset-

Backed

Securities

(ABS)

($000)

Trade

Account

Assets

($000)

Net

Loans and

Leases

Residential

Real Estate

Loans to

Total

Loans (%)

Commercial

Real Estate

Loans to

Total Loans

C&I

Loans to

Total

Loans

Auto

Loans to

Total

Loans

Credit

Card

Loans to

Total

Loans

9. Information about underlying data should be provided for support and documentation purposes. For example, by right clicking on a ratio, it should provide how it is defined, and bring a link to the call report or SEC filing.

Deliverable for Overall Banking and Financial Research Needs

The vendor must describe how its data service meets the following requirements:

Provide access to, and product support for, current and at least a 15-year historical regulatory and financial filing data, for: 1) U.S. and foreign-owned financial institutions, including systemically important financial institutions; 2) bank holding companies; 3) banks; 4) credit unions; 5) thrifts and savings institutions; 6) broker dealers; 7) asset managers; and 8) other financial services providers.

Provide access to current and historical data for insurance companies and groups in the U.S. and abroad. In addition to regulatory and financial filings, the vendor must provide access to current and at least 15-year historical market data for these financial institutions, including, but not limited to, equity prices, capital offerings, deposit and loan market shares, and mergers and acquisitions.

Provide wide and comprehensive coverage of various types of financial institutions as described above; and 2) disclose any limitations in the coverage of these institutions, including reliability and accuracy for documentation purposes. The vendor must ensure reliability of the data and information.

Provide information on its ability to capture the financial, market, and regulatory data described above and must also describe the years/quarters for which the data are available.

Specifically, the vendor will provide the following data elements with a minimum 15-year history:

Quarterly SEC filings, including income statement and balance sheet financials and derived ratios

(i.e., total assets, leverage, return on equity, and analytical measures of risk derived from balance sheet data)

Quarterly FDIC and Federal Reserve call report data for banks, bank holding companies and national banks, state member banks, insured state nonmember banks, and savings associations

Quarterly NCUA call report data on credit unions

Mergers and acquisitions within the financial services industry, such as banks, credit unions or insurance companies.

Data on checking and savings account interest rates and terms

Updates to the above data elements must be available on the database within 72 hours, during the work week, of the filing arriving at the agency of governance

Additional database functionality includes, but is not limited to:

Ability to identify the primary financial regulator for financial institutions within database

News and data analysis from domestic, foreign, and major international financial periodicals as well as proprietary analysis of the international banking/insurance environment

Analytical tools to create standard or custom peer groups of financial institutions and other companies

Deliverable for Overall Vendor, Industry, and Market Research Needs

GAO requires access to commercial off the shelf (COTS) data that has been cleaned and standardized. GAO also requires access to high quality and reliable analysis, intelligence, and research to meet cross-sector vendor, industry, and market research needs.

The data, intelligence, and tools could include but are not limited to:

US and foreign vendor financials, business descriptions, corporate trees, regulatory filings, and other vendor information across industries

Comprehensive vendor profiles in an exportable format for public and private entities

Sector-specific data across a range of industries such as energy, financial services, real estate, transportation, etc.

The ability to build lists of companies according to various criteria including industrial classification codes, and parameters related to factors including size, geography, and publicly traded status

Corporate transaction data including mergers and acquisitions, capital offerings, deal analysis, and investments

Information about investors (institutional, private equity, etc.)

Data and analysis related to corporate, consumer, and/or public finance credit risk and ratings

Commodities pricing data

Data and intelligence on emerging issues and sectors, such as:

Data and disclosures related to environmental, social and, governance (ESG) information

Disaster and climate risk

Private equity and venture capital

Use of technologies for financial services such as distributed ledger technology

Requirements for All Deliverables

The vendor’s data will be used, with proper acknowledgment, in multiple GAO products. The data must be made available to other GAO engagement teams on an as needed basis. The data will also be stored in

GAO’s record repository in compliance with federal records retention schedules and regulations. Balance sheet and income statement data may be used to analyze the impact of regulations, including the Dodd-

Frank Act, on covered nonbank financial institutions.

For GAO trace and verification purposes, the product must have documentation showing source information and other metadata for the indexed data sets. In addition, a description of any originating databases for the data services must be provided to GAO.

Additional database functionality includes, but is not limited to:

There must be no limits on the number of searches performed in the database

There must be no limits on downloads of data sets.

Data sets must be easily downloadable for statistical analysis.

The database must allow the user to download historical economic, country, regional, vendor and market data in a format suitable for analysis in Excel and other statistical software packages (e.g., SAS, Stata, etc.)

The database must allow data downloads from within the Microsoft Excel interface, via an Excel

Add-In tool and/or through user-written VBA code

Any software or Excel add-on will be compatible with GAO Networks.

The database must allow for the creation of panel datasets using historical data across countries, regions and institutions

The database must have an inventory of standard and customizable reports for individual corporations or groups of corporations

Timely updating of data to reflect recent regulatory and financial filings

If the product is not accessible via IP recognition, the database user accounts must be:

Not tethered to any single workstation and available to up to 250 GAO staff to use product simultaneously

Concurrent for up to 250 GAO staff. If pricing based on IP recognition or user accounts is not available then, the vendor must describe, in detail: 1) its pricing and concurrent use model, and 2) flexibility of access.

User accounts must be easily transferable to another GAO staff member.

Other vendor services must include:

Customer usage statistics on a monthly basis for the purpose of product usage analysis

Product trouble-shooting and technical support in-person or via telephone as needed throughout the period of performance

Any and all upgrades, updates, patches, bug fixes, new releases, or enhancements to the product, which the vendor does not elect to separately price or market and which are made available to licensor’s general client base

User training, in person or via webinar when requested

Access to user manuals, definitions of data fields and value codes, and documentation of assumptions and information sources underlying products

Materials to assist users and other documentation supplied within 30 days of contract award and throughout the period of performance as needed

Customer support services for product, data and technical issues, including access to knowledgeable support staff, to GAO staff during normal business hours, upon request.

Technical assistance to (1) respond to follow-up questions regarding the product and underlying data (2) assist GAO account users in conducting custom searches; and (3) answer questions regarding research methods.

E. Responses

Point of Contact for Inquiries and Submissions

RFI responses must include:

Name of Vendor

Point of Contact for the response with title/email/phone.

Vendor size, as defined by the Small Business Administration (SBA) under NAICS code 519130.

PSC Code: DH10

Specific responses about how your solution meets with reference to the requirements stated above.

Estimated price for providing this solution.

If your solution is available open market and/or via a Government-wide Acquisition Contract

(GWAC) such as GSA, NASA SEWP, NITAAC, FEDLINK, etc.

Information about how prices are determined, such as by usage, fixed price, add-ons, and bundled products/services.

Whether your pricing includes add-ons or bundled products/services, details about what is included in these add-ons or bundles.

A description of any training and/or technical support you offer in conjunction with your products/services.

Other relevant or related performance objectives/tasks recommended beyond those listed in the

Statement of Work.

Response Submission Deadline

Vendor responses to this RFI are due no later than January 24, 2023 by 1:00 P.M. Eastern Standard

Time (EST). Please submit all responses via email to Traenesha L. Jones, Contract Specialist, at jonest3@gao.gov and Cedric Mitchener, at mitchenerc@gao.gov, with “RFI-0001- Request for

Information- Domestic and Global Financial Institution Data Source” in the subject line.

Point of Contact for Inquiries and Submissions:

All questions regarding this RFI must be directed via email to Traenesha L. Jones, Contract Specialist, at jonest3@gao.gov and Cedric Mitchener, at mitchenerc@gao.gov, with “Domestic & Global Financial

Institution Data Source RFI” in the subject line. Questions must be received no later than January 9, 2023 at 1:00 P.M. EST. Responses to all questions received by this deadline will be posted electronically and made publicly available at www.sam.gov.

Disclaimer: This information is for GAO internal planning purposes only. All interested organizations are invited to respond. Please provide responses to the following statements and/or questions and organize your responses accordingly.

mailto:jonest3@gao.gov mailto:mitchenerc@gao.gov