Question
In this project, you will analyze two bank holding companies: Bank of America (BAC) and CVB Financial (CVBF). BAC is one of the largest bank
In this project, you will analyze two bank holding companies: Bank of America (BAC) and CVB Financial (CVBF). BAC is one of the largest bank holding companies in the world, while CVBF is a considerably smaller, regional financial institution.
Go to the website of the National Information Center (http://www.ffiec.gov/nicpubweb/nicweb/nichome.aspx). Then go to "Institution Search" and enter "1073757" for institution's RSSD ID. Click on "Search". Choose "Bank of America Corporation" (ID 1073757). Then choose "Consolidated Financial Statements for BHCs (FR Y- 9C)". Download and save the PDF file for 2023-12-31. Then repeat the same procedure to download reports for 2022-12-31, 2021-12-31, 2020-12-31, and 2019-12-31. Save all the files on your computer. Then repeat the above procedure for the "CVB Financial" (ID 1029222). Now you have 5-year financial statements for two companies. Alternatively, instead of using PDF files, you can download CSV (spreadsheet) files. The CSV files are easier to work with in terms of extracting the relevant data. However, the CSV files are not well organized. They just list the variables in no particular order. One option is to use PDF files to identify the variables of interest, and then find those variables in the CSV file, using its unique identifier. For example, you can use the PDF file to find the total consolidated assets of a BHC, shown in the BHC's Balance Sheet. You will notice that the total consolidated assets have the identifier, BHCK2170. Now you can use that identifier to find the value of the total consolidated assets in the CSV file.