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)
Lets break down the steps to tackle this project Data Acquisition Download the provided dataset from ... 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
-
Current Attempt in Progress Sheffield Company's overhead rate was based on estimates of $864,000 for overhead costs and 72,000 direct labor hours. Sheffield's standards allow 4 hours of direct labor...
-
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 1 January 2003, SPJ had an opening balance of $5000 on its tax account, which represented the balance on the account after settling its tax liability for the previous year. This balance arose from...
-
Complete the following contingency table. If it cant be done, explain why. 12 20 26 24
-
Scrap materials A machine shop manufactures a stainless steel part that is used in an assembled product. Materials charged to a particular job amounted to $600. At the point of final inspection, it...
-
1. The SEC is often called the watchdog of corporate America. How does it assist in preventing fraud? 2. According to the summary, why did the Waste Management executives commit the fraud? On March...
-
Given the functions: f (x) =x - 2x g (x) = 2x h (x) = 3x+5 Evaluate the function h (f (x) ) for x=5. Write your answer in exact simplified form. Select "Undefined" if applicable. h (f (5) ) is...
-
Based on Exhibits 1 and 2, the effective duration for the AI bond is closest to: A. 1.98. B. 2.15. C. 2.73. Jules Bianchi is a bond analyst for Maneval Investments, Inc. Bianchi gathers data on three...
-
When transforming a research question into a study design, which components are created first? a. Sample population and variables of interest b. Statistical analysis and sample size c. Hypothesis and...
-
b) A 400 V/50 Hz three-phase system is loaded with an ideal three-phase diode rectifier having a completely smooth output current of 50 A. An ideal three-phase thyristor converter is connected in...
-
Is Dawson subject to the provisions of the Hong Kong Prevention of Bribery Ordinance (POBO) in any business dealings outside of Hong Kong? Provide a brief explanation of your decision. If Dawson...
-
Identify and discuss the seven (7) key dimensions of organizational culture Describe what ZenDesk's organizational culture looks like Discuss how ZenDesk uses its corporate culture to attain...
-
There are two stocks in your portfolio, stocks A and B. You have invested $2,800 and $2,200 in A and B, respectively. And in the past three months, Stock A's average return was 6% while stock B's...
-
Virtual-Utility Ltd. Is involved in the business of making high quality furniture. It is considering the purchase of a new manufacturing machine for $430,000. The company believes that this new...
-
Nixon Company issued a 95-day note payable on March 11, 2021. On what date will this note payable mature?
-
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?
-
(Efficient frontier) This question relates to the data in the previous question. Calculate and graph the efficient frontier of the stock portfolios composed of stocks X and Y.
-
(Minimum variance portfolio) What will be the weights, the expected return, the variance, and the standard deviation of the minimum variance portfolio combining the stocks below? A B C 234567 X Y 3...
-
(Efficient frontier) This question relates to the data in the previous question. Calculate and graph the efficient frontier of the stock portfolios composed of stocks X and Y. A B C 1 RETURN...
Study smarter with the SolutionInn App