Question

In: Finance

The 2019 list of the 15 largest banks in the world by assets: Asset Rank Bank...

The 2019 list of the 15 largest banks in the world by assets:

Asset Rank	Bank (Group) (NYSE Index)	Country	Total Assets, US $B	Balance Sheet
1	Industrial & Commercial Bank of China (ICBC)	China	3,912.56	6/30/2019
2	China Construction Bank Corp. (CICHY)	China	3,382.42	6/30/2019
3	Agricultural Bank of China (ACGBY)	China	3,293.10	6/30/2019
4	Bank of China	China	3,241.97	6/30/2019
5	Mitsubishi UFJ Financial Group (MUFG)	Japan	2,846.07	6/30/2019
6	JP Morgan Chase & Co (JPM)	USA	2,727.38	9/30/2019
7	HSBC Holdings (HSBC)	UK	2,658.98	6/30/2019
8	Bank of America (BAC)	USA	2,395.89	9/30/2019
9	China Development Bank (CDB)	China	2,356.62	6/30/2019
10	BNP Paribas	France	2,332.68	6/30/2019
11	Credit Agricole	France	2,221.13	6/30/2019
12	Citigroup (C)	USA	1,988.23	9/30/2019
13	Wells Fargo & Co (WFC)	USA	1,923.39	9/30/2019
14	Sumitomo Mitsui Financial Group (SMFG)	Japan	1,861.61	6/30/2019
15	Mizuho Financial Group (MFG)	Japan	1,845.18	6/30/2019

A. Compute the median and the mean assets from this group.

B. Which of these two measures do you think is most appropriate for summarizing these data and why?

C. What is the value of Q2 and Q3?

D. Determine the 63rd percentile for the data.

E. Determine the 29th percentile for the data

F. Build a box plot for 2019 and compare with 2018.

For Part F: The 2018 list of the 15 largest banks in the world by assets:

Asset Rank	Bank (Group) (NYSE Index)	Country	Total Assets, US $B	Balance Sheet
1	Industrial & Commercial Bank of China (ICBC)	China	4,043.73	12/31/2018
2	China Construction Bank Corp. (CICHY)	China	3,390.17	12/31/2018
3	Agricultural Bank of China (ACGBY)	China	3,300.65	12/31/2018
4	Bank of China	China	3,104.71	12/31/2018
5	Mitsubishi UFJ Financial Group (MUFG)	Japan	2,805.07	3/31/2019
6	JP Morgan Chase & Co (JPM)	USA	2,622.53	12/31/2018
7	HSBC Holdings (HSBC)	UK	2,558.12	12/31/2018
8	Bank of America (BAC)	USA	2,354.98	12/31/2018
9	China Development Bank (CDB)	China	2,352.47	12/31/2018
10	BNP Paribas	France	2,345.79	12/31/2018
11	Credit Agricole	France	2,131.91	12/31/2018
12	Citigroup (C)	USA	1,917.38	12/31/2018
13	Wells Fargo & Co (WFC)	USA	1,895.88	12/31/2018
14	Sumitomo Mitsui Financial Group (SMFG)	Japan	1,836.09	3/31/2019
15	Mizuho Financial Group (MFG)	Japan	1,810.24	3/31/2019

Expert Solution

B.

The median is better measure her because the mean is manipulated due to the outliners or say extreme values this disadvantage of mean is compensate by the median so median is better here. So when data have some extreme values the Median is better measure than Mean.

Formulas used :-

Mean =AVERAGE(I203:I217)

Median =MEDIAN(I203:I217)

Q2 =QUARTILE(I203:I217,2)

Q3 =QUARTILE(I203:I217,3)

63rd Percentile =PERCENTILE(I203:I217,0.63)

29th Percentile =PERCENTILE(I203:I217,0.29)

F.

Blue = 2019 orange= 2018

jeff jeffy answered 2 years ago

On the 26th July 2019, National Australia Bank (NAB) which is the 4th largest bank in...

On the 26th July 2019, National Australia Bank (NAB) which is the 4th largest bank in Australia, contacted approximately 13,000 customers to advise that some personal information provided when their account was set up was uploaded, without authorisation, to the servers of two data service companies. NAB’s security teams have contacted the companies, who advise that all information provided to them is deleted within two hours. NAB Chief Data Officer, Glenda Crisp, said the compromised data included customer name, date...

Projected Return Year Asset A Asset B Asset C 2018 13% 15% 11% 2019 ...

Projected Return Year Asset A Asset B Asset C 2018 13% 15% 11% 2019 15% 13% 13% 2020 17% 11% 15% You have been asked for your advice in selecting a portfolio of assets and have been supplied with the following data: LOADING.... You have been told that you can create two portfolioslong dashone consisting of assets A and B and the other consisting of assets A and Clong dashby investing equal proportions (50 %) in each of...

How can fixed assets benefit bank growth and capital adequacy of banks

The balance sheet for Bank A is as follows: Assets/Liabilities and Asset/Liability Rates Included Assets Floating...

The balance sheet for Bank A is as follows: *Assets/Liabilities and Asset/Liability Rates Included* Assets Floating Rate: $700 @ 7% Fixed Rate: $350 @ 10% Non-Earning: $150 Liabilities Floating Rate: $600 @ 5% Fixed Rate: $420 @ 6% Equity $180 A) What is the repricing gap? B) Calculate the net interest income. C) Calculate the net interest margin. D) If rates go up by 50 basis points, was the bank hedged accurately in anticipation of the rate change? Why or...

Below is the useful life list of some fixed assets (tangible assets). Asset Class Description of...

Below is the useful life list of some fixed assets (tangible assets). Asset Class Description of Asset Useful Life (years) 01.01 Office furniture 5 02.04 Information systems (computers & printers) 3 03.02 Vehicles (automobiles) 4 04.01 Buildings 40 05.03 Machineries (plastic fabrication) 7 05.04 Machineries (metal fabrication) 10 ABC Corporation sold its old plastic injection machinery by the end of its 5th year (May 2019). Sales price of this transaction is 75 000USD. The purchase price of the machinery was ...

Central Bank Balance Sheet Assets Liabilities Foreign assets $1,000 Deposits held by private banks $500 Domestic...

Central Bank Balance Sheet Assets Liabilities Foreign assets $1,000 Deposits held by private banks $500 Domestic assets $1,500 Currency in circulation $2,000 Please write the new balance sheet if 1. The bank sells $100 worth of foreign bonds for domestic currency. 2. The bank carries out a sterilized transaction by selling $100 of foreign assets 3. What should the bank do if its intent were to acquire more foreign assets but keep the money supply constant? How would the...

You are considering investing in three assets. Asset A has an expected return of 15% and...

You are considering investing in three assets. Asset A has an expected return of 15% and standard deviation of 32%. Asset B has an expected return of 9% and standard deviation of 23%. Asset C is risk-free with an expected return of 5.5%. The correlation between A and B is 0.25. a) What is the expected return and standard deviation of the optimal risky portfolio? (2) b) Suppose your portfolio must yield an expected return of 12% and be efficient....

Consider a world with risk assets and one riskfree asset: (a) What are "global minimum variance...

Consider a world with risk assets and one riskfree asset: (a) What are "global minimum variance portfolio" and "optimal portfolio"? The question is asking about definitions/differences between two portfolios.

A bank has the following asset and liability portfolios. Assets Liabilities and Capital Firm (in billion...

A bank has the following asset and liability portfolios. Assets Liabilities and Capital Firm (in billion $) Industry Firm (in billion $) Industry Required reserves 3 4% Demand deposits 25 15% Commercial loans NOW accounts 8 10% Floating-rate 30 20% MMDAs 17 20% Fixed-rate 20 11% CDs Total 50 31% Short-term 5 35% Consumer loans 10 20% From 1 to 5 years 30 10% Mortgages Total 35 45% Floating-rate 10 7% Long-term bonds 5 3% Fixed-rate 5 3% Capital 10...

List five functions of following financial institutions? • IMF • World Bank • SBP