Open the file Banking a, sheet named Assets list the total assets of 30 largest U.S....
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Open the file Banking a, sheet named Assets list the total assets of 30 largest U.S. banks for 2007 and 2013. The Excel Data Analysis summary statistics of the dataset are provided below. Five years after the peak of the financial crisis, has Washington solved the problem of banks "too big to fail"? Are the large U.S. banks larger than pre-recession level? Justify your answer using the descriptive statistics provided below. Write one or two paragraphs. Year 2007 2013 Mean 328.6792 463.44159 Standard Error 94.96804 117.886028 Median 126.6565 176.636 Mode #N/A #N/A Standard 520.1614 645.6883675 Deviation Sample Variance 270567.9 416913.4679 Year 2007 2013 Mean 328.6792 463.44159 Standard Error 94.96804 117.886028 Median 126.6565 176.636 Mode #N/A #N/A Standard 520.1614 645.6883675 Deviation Sample Variance 270567.9 416913.4679 Kurtosis 6.325766 3.393940597 Skewness 2.560469 2.112468198 Range 2173.881 2306,6154 Minimum 46.985 82.7336 Maximum 2220.866 2389,349 Sum 9860.375 13903.2477 Count 30 30 A6 A B D. Largest Banks in the United States by Assets for 2007 List of the 30 largest banks in the Thited States ranked by total assets in billions of dollars: 3. 4. 6. 2007 Assets, $b 2220.9 7. Name (city, state) 1 Citigroup (New York, N.Y.) 2 Bank of America Corp. (Charlotte, N.C.) 3J. P. Morgan Chase& Company (Columbus, Ohio) 4 Wachovia Corp. (Charlotte, N.C.) 5 Taunus Corp. (New York, N.Y.) 6 Wells Fargo & Company (San Fransisco, Calif.) 7 HSBC North America Inc. (Prospect Heights, IlII.) 8 U.S. Bancorp (Minneapolis, Minn.) 9 Suntrust Banks, Inc. (Atlanta, Ga.) 10 ABN Amro North America (Chicago, IlII.) 11 Citizens Financial Group, Inc. (Providence, R.I.) 12 Capital One Financial Corp. (McLean, Va.) 13 National City Bank (Cleveland, Ohio) 14 Regions Financial Corp. (Birmingham, Ala.) 15 BB&T Corp. (Winston-Salem, N.C.) 16 PNC Financial Services Group, Inc. (Pittsburg, Pa.) 17 State Street Corp. (Boston, Mass.) 18 Fifth Third Bancorp (Cincinnati, Ohio) 19 Keycorp (Cleveland, Ohio) 20 Bancwest Corp. (Honolulu, Hawaii) 21 Harris Financial Corp. (Wilmington, Del.) 22 Northern Trust Corp. (Chicago, I.) 23 Comerica Incorporated (Dallas, Tex.) 24 Marshall & llsley Corp. (Milwaukee, Wis.) 25 M&T Bank Corp. (Buffalo, N.Y.) 26 Union Bank of Calif. (San Francisco, Calif.) 27 Charles Schwab Corp. (San Francisco, Calif.) 28 Zions Bancorporation (Salt Lake City, Utah) 29 Commerce Bancorp, Inc. (Cherry Hill, N.J.) 30 Popular, Inc. (San Juan, Puerto Rico) 8 Rank 9. 10 1535.7 11 1458.0 12 719.9 13 579.1 14 539.9 15 483.6 16 222.5 180.3 160.3 17 18 19 159.4 145.9 140.6 20 21 22 137.6 23 127.6 24 125.7 25 112.3 26 101.4 27 93.5 28 70.7 29 64.5 30 59.6 31 58.9 32 58.3 33 57.9 34 53.2 35 49.0 36 48.7 37 48.2 38 47.0 39 40 41 42 43 44 Largest Banks in the United States by Assets for 2013 List of the 30 largest banks in the United States ranked by total assets in billions of dollars: Rank Company 2013 Assets, $b 2389.3 1 J.P.Morgan Chase & Co 2 Bank of America 3 Citigroup 4 Wells Fargo & Company 5 Goldman Sachs Group 6 Morgan Stanley 7 Bank of New York Mellon 2174.6 1881.7 1436.6 959.0 801.0 355.9 8 U.S. Bancorp 355.4 9 HSBC North America Holdings 305.3 10 PNC Financial Services Group 300.8 11 Capital One 12 TD Bank US Holding Company 13 State Street Corporation 14 Principal Financial Group 15 BB&T Corporation 16 Suntrust Banks 17 Ally Financial 18 American Express Company 19 Ameriprise Financial 20 Charles Schwab Corporation 300.2 222.7 218.2 200.8 180.8 172.4 166.2 157.0 137.3 133.2 21 RBS Citizens Financial Group 22 BMO Financial Corp 23 Fifth Third Bancor 126.3 122.4 121.4 24 United Services Automobile Association 119.9 25 Regions Financial Corporation 26 UnionBanCal Corporation 119.7 97.0 27 Northern Trust Corporation 93.2 28 KeyCorp 29 M&TBank Corporation 89.2 82.8 30 Santander Holdings USA 82.7 Open the file Banking a, sheet named Assets list the total assets of 30 largest U.S. banks for 2007 and 2013. The Excel Data Analysis summary statistics of the dataset are provided below. Five years after the peak of the financial crisis, has Washington solved the problem of banks "too big to fail"? Are the large U.S. banks larger than pre-recession level? Justify your answer using the descriptive statistics provided below. Write one or two paragraphs. Year 2007 2013 Mean 328.6792 463.44159 Standard Error 94.96804 117.886028 Median 126.6565 176.636 Mode #N/A #N/A Standard 520.1614 645.6883675 Deviation Sample Variance 270567.9 416913.4679 Year 2007 2013 Mean 328.6792 463.44159 Standard Error 94.96804 117.886028 Median 126.6565 176.636 Mode #N/A #N/A Standard 520.1614 645.6883675 Deviation Sample Variance 270567.9 416913.4679 Kurtosis 6.325766 3.393940597 Skewness 2.560469 2.112468198 Range 2173.881 2306,6154 Minimum 46.985 82.7336 Maximum 2220.866 2389,349 Sum 9860.375 13903.2477 Count 30 30 A6 A B D. Largest Banks in the United States by Assets for 2007 List of the 30 largest banks in the Thited States ranked by total assets in billions of dollars: 3. 4. 6. 2007 Assets, $b 2220.9 7. Name (city, state) 1 Citigroup (New York, N.Y.) 2 Bank of America Corp. (Charlotte, N.C.) 3J. P. Morgan Chase& Company (Columbus, Ohio) 4 Wachovia Corp. (Charlotte, N.C.) 5 Taunus Corp. (New York, N.Y.) 6 Wells Fargo & Company (San Fransisco, Calif.) 7 HSBC North America Inc. (Prospect Heights, IlII.) 8 U.S. Bancorp (Minneapolis, Minn.) 9 Suntrust Banks, Inc. (Atlanta, Ga.) 10 ABN Amro North America (Chicago, IlII.) 11 Citizens Financial Group, Inc. (Providence, R.I.) 12 Capital One Financial Corp. (McLean, Va.) 13 National City Bank (Cleveland, Ohio) 14 Regions Financial Corp. (Birmingham, Ala.) 15 BB&T Corp. (Winston-Salem, N.C.) 16 PNC Financial Services Group, Inc. (Pittsburg, Pa.) 17 State Street Corp. (Boston, Mass.) 18 Fifth Third Bancorp (Cincinnati, Ohio) 19 Keycorp (Cleveland, Ohio) 20 Bancwest Corp. (Honolulu, Hawaii) 21 Harris Financial Corp. (Wilmington, Del.) 22 Northern Trust Corp. (Chicago, I.) 23 Comerica Incorporated (Dallas, Tex.) 24 Marshall & llsley Corp. (Milwaukee, Wis.) 25 M&T Bank Corp. (Buffalo, N.Y.) 26 Union Bank of Calif. (San Francisco, Calif.) 27 Charles Schwab Corp. (San Francisco, Calif.) 28 Zions Bancorporation (Salt Lake City, Utah) 29 Commerce Bancorp, Inc. (Cherry Hill, N.J.) 30 Popular, Inc. (San Juan, Puerto Rico) 8 Rank 9. 10 1535.7 11 1458.0 12 719.9 13 579.1 14 539.9 15 483.6 16 222.5 180.3 160.3 17 18 19 159.4 145.9 140.6 20 21 22 137.6 23 127.6 24 125.7 25 112.3 26 101.4 27 93.5 28 70.7 29 64.5 30 59.6 31 58.9 32 58.3 33 57.9 34 53.2 35 49.0 36 48.7 37 48.2 38 47.0 39 40 41 42 43 44 Largest Banks in the United States by Assets for 2013 List of the 30 largest banks in the United States ranked by total assets in billions of dollars: Rank Company 2013 Assets, $b 2389.3 1 J.P.Morgan Chase & Co 2 Bank of America 3 Citigroup 4 Wells Fargo & Company 5 Goldman Sachs Group 6 Morgan Stanley 7 Bank of New York Mellon 2174.6 1881.7 1436.6 959.0 801.0 355.9 8 U.S. Bancorp 355.4 9 HSBC North America Holdings 305.3 10 PNC Financial Services Group 300.8 11 Capital One 12 TD Bank US Holding Company 13 State Street Corporation 14 Principal Financial Group 15 BB&T Corporation 16 Suntrust Banks 17 Ally Financial 18 American Express Company 19 Ameriprise Financial 20 Charles Schwab Corporation 300.2 222.7 218.2 200.8 180.8 172.4 166.2 157.0 137.3 133.2 21 RBS Citizens Financial Group 22 BMO Financial Corp 23 Fifth Third Bancor 126.3 122.4 121.4 24 United Services Automobile Association 119.9 25 Regions Financial Corporation 26 UnionBanCal Corporation 119.7 97.0 27 Northern Trust Corporation 93.2 28 KeyCorp 29 M&TBank Corporation 89.2 82.8 30 Santander Holdings USA 82.7
Expert Answer:
Answer rating: 100% (QA)
Y ES large US banks are lar ger than the pre recession levels as clear due to the fact that i the ... View the full answer
Related Book For
Posted Date:
Students also viewed these banking questions
-
How can being too big to fail create a moral hazard problem?
-
This assignment task requires consideration and application of accounting theories and concepts with critical analysis based on General Purpose Financial Reporting by corporations. Students are...
-
This assignment is designed to consolidate your learning of the key skills and knowledge needed when facing a financial report audit of a company, and how to analyse, research and pinpoint facets of...
-
Format only cells with values greater than maxim 4 tab and select Red color from the pallet (bottom ro Format only cells with values less than minimum and select Yellow color from the pallet (bottom...
-
Designs Unlimited plans to produce a one-component vertical file by bending the long side of an 8-in. by 14-in. sheet of plastic along two lines to form a U shape. (a) Express the volume of the file...
-
A company manufactures five sizes of screwdrivers. Ordering costs and carrying costs are not known, but it is known that they are the same for each size. At present, each size is produced four times...
-
Show that the force acting on a control surface of any arbitrary control volume is equal to the force on a larger regularly shaped control volume enclosing the given body. In order to do this you...
-
Havingn read the BusinessTech article titled "IBM forecast beats estimates for n quarterly sales and earning". Consider the type of research that may n have led to this headline. Do you think it is...
-
a. Determine equations for P=f(Q), MR-f(Q), ATC=f(Q, Q), AVC=f(Q, Q), MC=f(Q, Q). Recall that your marginal equations should be derivatives of your totals! b. Determine the profit-maximizing price...
-
One way to see whether this procedure will be successful is to split the original data set into two subsets: one subset for estimation and one subset for validation. A regression equation is...
-
On December 31 of the current year, Plunkett Company reported an ending inventory balance of $218,000. The following additional Information is also avallable: Plunkett sold and shipped goods costing...
-
Demonstrate excellent thinking by applying a precision-oriented style to reports.
-
Describe and demonstrate effective questions for enhancing listening and learning.
-
Explain how extroversion-introversion impacts interpersonal communication.
-
Explain the major cultural dimensions and related communication practices.
-
Explain and evaluate the process of active listening.
-
A calorimeter contains 90.0 g of 18.00C water. A 35.0 g brass coin is initially in a beaker of 96.00C water. The coin is quickly moved into the calorimeter and the water warms to 19.25C. a. For which...
-
Imagine you are the HR manager at a company, and a female employee came to you upset because she felt a male coworker was creating a hostile work environment by repeatedly asking her out on dates...
-
Diagram the following budget constraints: a. Income = $4,000; PX = $50; PY = $100 b. Income = $3,000; PX = $25; PY = $200 c. Income = $2,000; PX = $40; PY = $150
-
1. Describe how a price support works. 2. List the three methods that government has used to restrict supply. 3. Describe the relationship between a target price and a deficiency payment. 4. Explain...
-
Denise will receive $1,000 in two years. If the interest rate is 5 percent, what is the present value of this dollar amount?
-
Which of the following provides evidence for evolution? (a) changes in the coloration of peppered moth populations over time (b) the presence of vestigial eyes in cave salamanders (c) the fact that...
-
Which of these adaptations is the result of sexual selection? (a) the spines on cactus plants (b) parental care in male poison dart frogs (c) the songs of male birds (d) dark wings in peppered moths
-
If you put a heavy load in a wheelbarrow, the force you apply to the handles is much less than the weight of the load and the wheelbarrow. To lift with the least force, you put the load toward the...
Study smarter with the SolutionInn App