Chapter 12 Investments, basic knowledge of Excel, and XBRL. Goal of the project: Identify which banks...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
"Chapter 12 Investments", basic knowledge of Excel, and XBRL. Goal of the project: Identify which banks had the most decrease in available-for-sale securities and most increase in held-to-maturity securities using XBRL. Then, explain why these banks experienced an increase in such classifications of investment securities by searching financial statements, news articles, or other sources. Instructions: 1. The raw data comes from: https://www.sec.gov/dera/data/financial-statement-data- sets.html However, the dataset is too large to open in Excel. I have selected about 40 banks and constructed a sample of all their "SUB" and "NUM" datasets for 2015-2021. You can download from here: https://www.dropbox.com/s/8m0jvfavp9rcro2/xbrl_dataset.xlsx?dl=0 2. The fields included in the "SUB" and "NUM" datasets are described here: https://www.sec.gov/files/aqfs.pdf The "adsh" field is a unique identifier for each SEC filing. The "cik" field is a unique identifier for each SEC filer. Merge the "NUM" dataset with the "SUB" dataset using the "adsh" to obtain the CIK (central index key) and name of each bank. Use VLOOKUP (https://exceljet.net/functions/vlookup-function) The CIK can be used to search companies on SEC EDGAR. Select 10 banks. 3. The "ddate" field represents the date of the balance. Because it is not in a date format, use the (https://exceljet.net/excel-functions/excel-left-function LEFT ), ), MID (https://exceljet.net/excel-functions/excel-mid-function and RIGHT (https://exceljet.net/excel-functions/excel-right-function) functions to transform it into date format. "Chapter 12 Investments", basic knowledge of Excel, and XBRL. Goal of the project: Identify which banks had the most decrease in available-for-sale securities and most increase in held-to-maturity securities using XBRL. Then, explain why these banks experienced an increase in such classifications of investment securities by searching financial statements, news articles, or other sources. Instructions: 1. The raw data comes from: https://www.sec.gov/dera/data/financial-statement-data- sets.html However, the dataset is too large to open in Excel. I have selected about 40 banks and constructed a sample of all their "SUB" and "NUM" datasets for 2015-2021. You can download from here: https://www.dropbox.com/s/8m0jvfavp9rcro2/xbrl_dataset.xlsx?dl=0 2. The fields included in the "SUB" and "NUM" datasets are described here: https://www.sec.gov/files/aqfs.pdf The "adsh" field is a unique identifier for each SEC filing. The "cik" field is a unique identifier for each SEC filer. Merge the "NUM" dataset with the "SUB" dataset using the "adsh" to obtain the CIK (central index key) and name of each bank. Use VLOOKUP (https://exceljet.net/functions/vlookup-function) The CIK can be used to search companies on SEC EDGAR. Select 10 banks. 3. The "ddate" field represents the date of the balance. Because it is not in a date format, use the (https://exceljet.net/excel-functions/excel-left-function LEFT ), ), MID (https://exceljet.net/excel-functions/excel-mid-function and RIGHT (https://exceljet.net/excel-functions/excel-right-function) functions to transform it into date format.
Expert Answer:
Answer rating: 100% (QA)
To accomplish your project goal follow these steps Access XBRL Data Obtain XBRL data for the banks youre interested in analyzing XBRL eXtensible Busin... View the full answer
Related Book For
Introductory Financial Accounting for Business
ISBN: 978-1260299441
1st edition
Authors: Thomas Edmonds, Christopher Edmonds
Posted Date:
Students also viewed these accounting questions
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
The Crazy Eddie fraud may appear smaller and gentler than the massive billion-dollar frauds exposed in recent times, such as Bernie Madoffs Ponzi scheme, frauds in the subprime mortgage market, the...
-
Suppose the city of Metropolis is experiencing a movement of its population to the suburbs. Each year 25% of the people that live in the city move to the suburbs, while only 5% of the people that...
-
On November 28, 2015 a taxpayer purchased for $2,000,000 a rental building with commercial stores on the first floor (Total Monthly Rent $10,000) and apartments on the upper two floors (Total Monthly...
-
Compare the answers to the following two construction problems. a. A rectangular sheet of perimeter 36 cm and dimensions x cm by y cm is to be rolled into a cylinder as shown in part (a) of the...
-
What is meant by corporate governance and why is it important?
-
Eagle Carts, Inc., produces special-order golf carts, so Eagle Carts uses a job order costing system. Overhead is applied at the rate of 90 percent of direct labor cost. A list of transactions for...
-
Statement of cash flows-indirect method The comparative balance sheet of Merrick Equipment Co. for December 31, 20Y9 and 20Y8, is as follows: December 31, 20Y9 December 31, 20Y8 Assets Cash Accounts...
-
Karen Samuels (Social Security number 123-45-6789) makes the following purchases and sales of stock: Assuming that Karen is unable to identify the particular lots that are sold with the original...
-
Rita is in the process of negotiating to sell her caf that sells specialist coffee and light meals. Matiu is very interested in buying the caf and asks Rita how far away the nearest competition is....
-
(b) Describe what components a system dynamics model consists of. Figure Q1b shows the information feedback in a system. What should be the sign (+ or -), in terms of the relationship between 'human...
-
a) Write the output when the following code segments in program 1.1 (Figure 6), program 1.2 (Figure 7) and program 3 (Figure 8) are executed: //program 1.1. int a-1, b=2, c=3; printf("%d", (! (a>b)...
-
Adam Smith fue un escocs libre pensador propulsor de la llamada Teora Clsica, que expone en su principal publicacin "La riqueza de las naciones" su teora sobre: Seleccione una: a. Las Ventajas...
-
Write a summary of your understanding of the danielson framework and how you will prepare yourself for working with the framework.
-
For the circuit shown with following parameters, L-400 uH, R-2 92, Vin is within the range of 8 V to 16 V, Vout is desired to be 80 V constant Ts-200 us Primary winding self inductance: winding...
-
z+ iz Which of the following is true about f(z) = z2 %3D Select one: a. Neither Continuous nor differentiable O b. Differentiable but not continuous Oc Continuous but not differentiable d. Continuous...
-
In the circuit shown in Figure 4, a battery supplies a constant voltage of 40 V, the inductance is 2 H, the resistance is 10, and l(0) = 0. (a) Find l(t). (b) Find the current after 0.1s.
-
Dyer Department Store purchased goods with the terms 2/10, n/30. What do these terms mean?
-
Obtain the Target Corporations annual report at http://investors.target.com using the instructions in Appendix B, and use it to answer the following questions: a. What method of depreciation does...
-
When might an auditor issue a disclaimer on financial statements?
-
Meet local small business owners or representatives of as profit organizations. Find a company or organization that will host your team to produce a web site for them (nonmonetary, of course). Find...
-
More often than not, database environments in in organization reflect data structures that have been developed over a period of years, sometimes haphazardly, and that often reflect a variety of...
-
Although database systems have become the systems of choice for new and reengineered systems, are there any situations where a relational file-based system might be chosen instead? Explain your answer
Study smarter with the SolutionInn App