The commercial banking industry is undergoing rapid changes due to advances in technology and competitive pressures in the financial services sector. The data file BANKS contains selected information tabulated by Fortune concerning the revenues, profitability, and number of employees for the 51 largest US Commercial Banks in terms of revenues. Use the information in this file to complete the following:
a. Compute the mean, median and standard deviation for the three variables: revenues, profits and number of employees. Assume the data is defined as a population. (So since it's a population, would we use STDEV or STDEV.P ???)
b. Convert the data for each variable to z value. (Step-by-step explanation of finding z values). Consider Mellon Bank Corporation headquarters in Pittsburgh. How does it compare to the average bank in the study on the three variables? Discuss.
c. As you can see by examining the data and by looking at statistics computed in part (a), not all banks had the same revenue, same profit or the same number of employees. Which variable had the greatest relative variation among the banks in the study?
d. Calculate a new variable: profits per employee. Develop a frequency distribution and histogram for this new variable. Also compute the mean, median and standard deviation for the new variable. Write a short report that describes the profits per employee for the banks.
e. Referring to part (d), how many banks had a profit-per-employee ratio that exceeded 2 standard deviations from the mean?
Name | Revenues | Profits | Employees |
CITICORP | 34697 | 3591 | 93700 |
CHASE MANHATTAN CORP. | 30381 | 3708 | 69033 |
BANKAMERICA CORP. | 23585 | 3210 | 77000 |
NATIONSBANK CORP. | 21734 | 3077 | 80360 |
J.P.MORGAN & CO. | 17701 | 1465 | 16943 |
FIRST UNION CORP. | 14329 | 1896 | 43933 |
BANC ONE CORP. | 13219 | 1306 | 56600 |
BANKERS TRUST N.Y. CORP. | 12176 | 866 | 18286 |
FIRST CHICAGO NBD CORP. | 10098 | 1525 | 33962 |
aMSOUTH BANCORP. | 9660 | 1351 | 55729 |
WELLS FARGO & CO. | 9608 | 1155 | 33100 |
FLEET FINANCIAL GROUP | 8095 | 1303 | 32317 |
U.S. BANCORP | 6909 | 839 | 25858 |
PNC BANK | 6859 | 1052 | 24814 |
BANKBOSTON CORP. | 6727 | 879 | 21500 |
KEYCORP | 6568 | 919 | 24595 |
BANK OF NEW YORK CO. | 5697 | 1104 | 16494 |
WACHOVIA CORP. | 5270 | 593 | 21652 |
NATIONAL CITY CORP. | 5152 | 807 | 29841 |
MELLON BANK CORP. | 5134 | 771 | 27500 |
SUNTRUST BANKS | 4585 | 667 | 21227 |
MBNA | 4524 | 623 | 17398 |
CORESTATES FINAN. CORP. | 4379 | 813 | 18847 |
BARNETT BANKS | 4102 | 255 | 21487 |
REPUBLIC NEW YORK CORP. | 3738 | 449 | 5900 |
STATE ST. CORP. | 3428 | 380 | 14199 |
COMERICA | 3175 | 530 | 11000 |
BB&T CORP. | 2598 | 360 | 9803 |
SOUTHTRUST CORP. | 2503 | 307 | 10311 |
SUMMIT BANCORP | 2367 | 371 | 8566 |
HUNTINGTON BANCSHARES | 2324 | 293 | 9485 |
NORTHERN TRUST CORP. | 2267 | 309 | 7553 |
MERCANTILE BANCORP. | 2257 | 205 | 9510 |
FIRST OF AMER. BANK CORP. | 2078 | 315 | 10622 |
CRESTAR FINANCIAL CORP. | 1997 | 310 | 8215 |
FIFTH THIRD BANCORP | 1924 | 401 | 6787 |
REGIONS FINANCIAL | 1912 | 300 | 9227 |
FIRSTAR CORP. | 1893 | 295 | 7755 |
UNION PLANTERS CORP. | 1778 | 209 | 7711 |
MARSHALL & ILSLEY CORP. | 1743 | 245 | 10227 |
POPULAR | 1739 | 210 | 8854 |
AMSOUTH BANCORP. | 1644 | 226 | 6400 |
FIRST TENN. NATL. CORP. | 1609 | 197 | 8207 |
FIRST SECURITY CORP. | 1503 | 206 | 7673 |
OLD KENT FINANCIAL CORP. | 1306 | 180 | 6328 |
FIRST EMPIRE STATE CORP. | 1258 | 176 | 4781 |
PACIFIC CENTURY FINANCIAL | 1250 | 139 | 5114 |
PROVIDIAN FINANCIAL | 1217 | 191 | 3884 |
SYNOVUS FINANCIAL CORP. | 1215 | 165 | 7496 |
COMPASS BANCSHARES | 1131 | 156 | 5060 |
FIRST NATL. OF NEBRASKA | 1047 | 75 | 5200 |
The commercial banking industry is undergoing rapid changes due to advances in technology and competitive pressures...
arclays is a London based multinational banking company that employs 140,000 employees. The company’s revenue drastically decreased in 2012 ($53 billion) with a yearend deficit of $1.7 million. Later in 2012, Anthony Jenkins was appointed the new CEO in order to turn things around for Barclays so as to regain the trust of their investors and therein increase the profitability of the firm. In 2013, Barclays did achieve a positive net income of $890 million with sales growth of over...
What are the differentiating features of banks that target ethnic communities? (Bullet point answers please). United Commercial Bank and El Banco17CASE 2.1 This telling of the story of two special banks originally was prepared by students in 2007 who were engaged by the notion of two banks that had developed separate strategies for serving two niche markets. As you first read the students’ story, ask yourself, what could have gone wrong with each bank? Also, as you read, keep a...
The opening case, ‘Hackers Attack the SWIFT Global Banking Network’, discusses breaches in the system of several banks that are a part of the SWIFT network. The case is an example of the importance of information system controls. Explain some of the security risks associated with information systems as well as some security and control measures that can be implemented to protect against these security risks. Hackers Attack the SWIFT Global Banking Network SWIFT, which stands for Society for Worldwide...
Read the attached article. Do you feel one style of banking control is more stable than the other? Why? Does one banking method minimize market volatility and risk better or is it just packaged differently? Do you feel the US (Western) Banking system can better control the patterns of behavior going forward that have caused economic damage in the past? Should the Fed continue its stimulus policy, reduce it or abandon it entirely (Google some recent articles to research this)? (Please...
Trans-Pacific Industry & Technology Company Trans-Pacific Industry & Technology (TPIT), Inc. is a diversified industrial company. The Company owns businesses providing products & services to the energy, transportation, chemical, and construction sectors. The energy segment operates as an oil and natural gas contract drilling company the United States. The energy segment acquires, explores, develops, and produces oil and natural gas properties primarily located in Oklahoma and Texas, as well as in Arkansas, Colorado, Kansas, Louisiana, Mississippi, Montana, New Mexico, North...
Please list 5 inherent risk related items the assignment requires to list 5 inherent risks from the description of the company that an auditor may take when deciding to accept this new client. Emphasis Heading 1 Heading 2 Heading 3 Heading 4 Description of Southwest Appliance, Inc. History and Corporate Structure Southwest Appliances, Inc. specializes in supplying a relatively small line of high-quality household appliances to residential construction contractors in a large and growing metropolitan area. Southwest has a large...
1. Calculate the mean and standard deviation for each variable using formulas or functions. 2. Calculate descriptive statistics for each variable using the Analysis Toolpak. 3. Calculate the coefficient of variation for each variable. What general interpretation can you make from these values? 4. Calculate the correlation between Revenue and Employees using a formula. Calculate the coefficient of determination. 5. Create a correlation matrix for the eight numerical variables. Note any relationship of interest Rank COMPANY NAME City State Revenue...
LO 10-6, 10 10-36 Based on an assessment of audit risk, the auditors are concerned with the following two risks: 1. The risk that that the client might be making duplicate payments to vendors. 2. The risk that the client's accounting clerk might be making unauthorized payments to himself. a. Assuming that the client has a manual accounting system, describe how the auditors can design a test to identify the duplicate payments and unauthorized payments. b. Assuming that the client...
And there was a buy-sell arrangement which laid out the conditions under which either shareholder could buy out the other. Paul knew that this offer would strengthen his financial picture…but did he really want a partner?It was going to be a long night. read the case study above and answer this question what would you do if you were Paul with regards to financing, and why? ntroductloh Paul McTaggart sat at his desk. Behind him, the computer screen flickered with...
CASE 20 Enron: Not Accounting for the Future* INTRODUCTION Once upon a time, there was a gleaming office tower in Houston, Texas. In front of that gleaming tower was a giant "E" slowly revolving, flashing in the hot Texas sun. But in 2001, the Enron Corporation, which once ranked among the top Fortune 500 companies, would collapse under a mountain of debt that had been concealed through a complex scheme of off-balance-sheet partnerships. Forced to declare bankruptcy, the energy firm...