This data analytics project requires your understanding of the material covered in “Chapter 12...

Question

This data analytics project requires your understanding of the material covered in “Chapter 12 Investments”, basic knowledge of Excel, and XBRL.

The goal of the project:
Identify which banks had the most decrease in available-for-sale securities and the 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.

Answer the questions 1 paragraph each and attach the excel with all the work. The attached file has all the instructions and questions.

This link provides a guide for the Data Analytics project:https://www.dropbox.com/s/iozxs127vf8qq45/Data%20Analytics.mp4?dl=0

data-analytics-project-1-wq5xlm4x.pdf

Vasudha · Accepted Answer

ACC 3100 Spring 2021
Data Analytics Project
1. Ten Banks Selected for Data Analysis:
2.
If we consider total Available for Securities, JPMC has the most falls in its securities.
3. JPMC is basically investment banker. The Financial crisis in the global economy has brought many banks and financial institution to the grim position.  Over the years from recession and depression in the economy, there was a crisis of debt.  In the aftermath of this great crisis, banks solvency position is no better, considering all these points, JPMC’s available for sale securities were declined over the past decade.
( Sources: https://www.jpmorganchase.com/content/dam/jpmc/jpmorgan-chase-and-co/investor-relations/documents/annualreport-2019.pdf , https://www.investopedia.com/articles/markets/082515/how-morgan-stanley-makes-its-money-ms.asp )
4. 
5. American Express has adopted the strategic investment and risk factors associated with its business and are conducive for taking such decisions. The main intent of investing in these securities is for sale before the maturity date. One reason for the increase in available for sale securities is that, the total fair value might have increased over the last reporting period.     https://s26.q4cdn.com/747928648/files/doc_financials/2019/ar/c2f76864-a0b7-64e4-cdfb-4903ae939d5c.pdf
	
6. XBRL is the standard reporting language with the intention of providing ease for data analytics.
XBRL is useful in the following way:
a) Comparison and analysis of the large data is made simple and easy. Various stakeholders both internal and external can benefit from the large organized data.
b) Much of the manual data entry and formatting as per the need is reduced by XBRL. Most of the time consuming processes like downloading, formatting and data collection tasks are eliminated this language. By doing so,

This data analytics project requires your understanding of the material covered in “Chapter 12 Investments”, basic knowledge of Excel, and XBRL. The goal of the project: Identify which banks had the...

Solution

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment