I need help responding one question !!!!!!! must read attached power point and document to be able to answer .
COMMERCIAL BANKING ANALYSIS 1
FINANCIAL STATEMENT ANALYSIS 14
Commercial Banking Project
Commerce Bancshares
Group 9
Financial Statement Analysis
PART A: Commercial Bank Financial Analysis
Financial statement analysis is the process of evaluating the financial statements of a company such as the income statements, balance sheets and the profit and loss statements. By analyzing the statements of the business, it helps individuals in identifying the financial health of the firm and the profit it makes in a year (Subramanyam & Wild, 2009). Similarly, the statement analysis helps the owners of the company make better decisions concerning the activities of the firm to ensure it maximizes profit. The following ratio analysis is used to determine the financial statements of the company
· Equity multiplier
· Asset turnover
· Return on assets
· Profit margin
· Return on equity
Financial statement analysis of Commerce Bancshares.
Equity multiplier = total assets/ total equity capital
23881169/2069375 = 11.54%
The Commerce bank uses more debt to finance its assets; this implies that the firm as a higher solvency risk. The owners of the bank choose to have a higher risk that will give them high returns leading to a great profit and hence the firm would have the chance to achieve its objective of profit maximization.
Return on Equity = net income/total equity capital
Non-interest income = 440740
Net interest income= 615003
Less provision for loan losses = (29530)
Total operating income = 1026213
Less non-interest expense = (651629)
Tax = (118 094)
Net income 256490
Therefore, ROE= 256490/2069375 = 0.112%
Return on equity measures the amount of profit the company has made through the money the shareholders have invested in the firm. In the bank, it shows that the shareholders’ equity has not made much profit to the company (Subramanyam &Wild, 2009). This may be because the company offers fewer dividends as compared to other banks and hence individuals choose to invest in those banks that they will receive a greater dividend yield. And also, the bank may be selling its shares at a higher price which most shareholders are not able to raise. The high prices of its shares are because it is a larger bank and has access to the capital markets. Similarly, the bank may not be recognized, and people choose to invest in those banks that are publicly recognized. Also, the rates of the banks are too high for individuals to invest in it for the fear that consumers would not borrow loans from them and hence will have a lower dividend yield.
Asset turnover= total operating income/ total assets
1026213/ 23881169 = 0.04%
The assets of the bank have a lower ability to produce the net income in the year 2014. Therefore, the company does not solely depend on the assets to produce the net income of the firm (Penman, 2007). Commerce bank uses its revenues and expenditures to identify the net profit of the company since it cannot rely on the assets to determine the net profit.
Return on Assets = net income/ total assets
= 256490/23881169 = 0.011%
The management of commerce bank does not use its assets efficiently to generate a profit since it has a lower percentage of 0.011times in the year 2014 (Penman, 2007). This indicates that the bank is using other sources to produce profit such as interests earned from loans it gives to its debtors.
Profit margin= net income/ total operating income
= 256490/ 1026213 = 0.25%
The bank can control its expenses by paying its debts to avoid financial distress. Also, it can adjust its budget by including fewer expenses that are more imperative in running the activities of the bank.
From 2000-2001, ROE of the bank decrease this is due to the decrease in both the net income and the profit margin. The decrease in the net income may have been caused by the decrease in the value of the assets, and the markets may have been less liquid in the year 2001 resulting in a decrease in the return on equity of the bank. And as from 2003-2005, the ROE of the firm increased and maintained a constant value of 0.2% (Penman, 2007). This was due to an increase in the profit margins of those years and a healthy economic growth of the bank in the markets which lead to an increase in the net income.
From 2006-2014, ROE declined significantly leading to a major crisis which weakened the credit markets forcing the company to increase the provision of loans and leases.
The averages of the commerce Bancshares differ slightly with those of the industry. This is because in most cases such as in the equity multiplier, the bank prefers to use more debts to finance its assets as compared to the industry. Also, the company takes high risks with the hope of getting high returns which will generate more profits, unlike the industry which minimizes the use of debts to finance its assets. Similarly, on the return on equity, the industry gives a negative curve.
Fig. 1: Graph showing the Return on Equity
(Source: Gruenberg, et al., 2017)
Table 1 : showing data of Return on Equity
|
year |
Commerce |
Industry |
|
2000 |
0.21 |
13.44 |
|
2001 |
0.19 |
12.57 |
|
2002 |
0.19 |
13.46 |
|
2003 |
0.2 |
15.53 |
|
2004 |
0.22 |
12.8 |
|
2005 |
0.23 |
12.26 |
|
2006 |
0.19 |
12.18 |
|
2007 |
0.17 |
3.76 |
|
2008 |
0.12 |
-10.14 |
|
2009 |
0.11 |
-0.74 |
|
2010 |
0.12 |
5.78 |
|
2011 |
0.13 |
6.73 |
|
2012 |
0.13 |
8.6 |
|
2013 |
0.13 |
8.54 |
|
2014 |
0.11 |
8.44 |
The ROE of the bank remains constant through the years while that of the industry keeps changing. This shows that the industry is more profitable despite its negative ROE in the year 2008. It is possible that the average of the industry was boosted by the performance of various banks which managed to control their expenses hence reducing the financial crisis which would have led to a lower Return on equity of the bank (Gruenberg et al. 2017).Similarly, the ROE of the bank is smaller than that of the industry because the profit margins and the return on assets are smaller than those of the industry.
Fig. 2: Graph showing Return on Assets
(Source: Gruenberg, et al., 2017)
Table 2: showing data of Return on Assets
|
year |
commerce |
industry |
|
2000 |
0.02 |
1.15 |
|
2001 |
0.15 |
1.13 |
|
2002 |
0.015 |
1.24 |
|
2003 |
0.02 |
1.41 |
|
2004 |
0.016 |
1.28 |
|
2005 |
0.017 |
1.24 |
|
2006 |
0.015 |
1.25 |
|
2007 |
0.014 |
0.38 |
|
2008 |
0.001 |
-0.96 |
|
2009 |
0.01 |
-0.08 |
|
2010 |
0.012 |
0.64 |
|
2011 |
0.012 |
0.75 |
|
2012 |
0.012 |
0.96 |
|
2013 |
0.011 |
0.96 |
|
2014 |
0.011 |
0.94 |
The return on assets of the industry increases and decreases while that of the bank only increases from2000 and decreases from 2001 to 2002. As from 2002 to the ROA of the industry remains constant (Gruenberg et al. 2017). Therefore, the industry produced more net income per dollar of the total assets as compared to the bank. Also, as of the year 2007-2009, the ROA of the industry was negative indicating that the assets of the industry generated a negative income leading to losses that made the industry borrow money to finance its expenses.
Fig. 3: Graph showing Equity Multiplier for the bank
(Source: Gruenberg, et al., 2017)
Table 3: showing data of the Equity Multiplier
|
years |
commerce |
industry |
|
2000 |
12.51 |
10.93 |
|
2001 |
13.22 |
11.04 |
|
2002 |
12.62 |
11.78 |
|
2003 |
13.39 |
9.79 |
|
2004 |
13.57 |
9.9 |
|
2005 |
13.45 |
9.89 |
|
2006 |
12.65 |
10.99 |
|
2007 |
11.68 |
8.85 |
|
2008 |
12.09 |
9.04 |
|
2009 |
10.66 |
10.67 |
|
2010 |
10.19 |
9.78 |
|
2011 |
10.65 |
8.97 |
|
2012 |
11.09 |
8.94 |
|
2013 |
11.75 |
8.91 |
|
2014 |
11.54 |
8.89 |
A higher equity multiplier indicates that the bank uses more debt to finance its assets and hence as a higher solvency risk which may lead to higher returns. In 2014, the bank had a higher multiplier than that of the industry indicating the willingness of the company to take risks to ensure effective running of the business activities (Penman, 2007). Also, commerce bank has a tier 1 capital of $1713752. The industry does not use more debts to finance its assets. Therefore, it does not have a higher solvency risks as compared to the company.
Fig. 4: Graph showing the profit margin for the bank
(Source: Gruenberg, et al., 2017)
Table 4: Showing data on the Profit Margin
|
year |
Commerce |
Industry |
|
2000 |
0.26 |
87.8 |
|
2001 |
0.26 |
87.2 |
|
2002 |
0.26 |
90 |
|
2003 |
0.28 |
90.1 |
|
2004 |
0.28 |
90.1 |
|
2005 |
0.26 |
90.8 |
|
2006 |
0.25 |
88.1 |
|
2007 |
0.19 |
83.2 |
|
2008 |
0.2 |
65.6 |
|
2009 |
0.23 |
64.5 |
|
2010 |
0.25 |
72.6 |
|
2011 |
0.13 |
80.1 |
|
2012 |
0.26 |
88.6 |
|
2013 |
0.26 |
88.7 |
|
2014 |
0.25 |
91.2 |
Commerce has a lower profit margin than that of the industry; this shows that it was not able to control its expenses over the years since it has maintained its margin throughout the year. In the year 2007 and 2009, the profit margin of the industry constantly declines due to the financial crisis encountered by the banks. These include losses that rose from write-offs and a decrease in the net income of the firms (Gruenberg et al. 2017).Therefore, the firm with a lower profit margin may lead to bankruptcy since the expenses will be more than the revenues. If the situation continues for the next years, then commerce Bancshares will be forced to use reserves to pay its debts to avoid facing financial distress.
Fig. 5: Graph showing the asset turnover
(Source: Gruenberg, et al., 2017)
Table 5: Showing data on the Asset Turnover
|
years |
Commerce |
Industry |
|
2000 |
0.065 |
0.013 |
|
2001 |
0.06 |
0.013 |
|
2002 |
0.06 |
0.014 |
|
2003 |
0.06 |
0.016 |
|
2004 |
0.06 |
0.016 |
|
2005 |
0.06 |
0.014 |
|
2006 |
0.06 |
0.014 |
|
2007 |
0.057 |
0.005 |
|
2008 |
0.051 |
-0.015 |
|
2009 |
0.049 |
0.0012 |
|
2010 |
0.053 |
0.009 |
|
2011 |
0.05 |
0.009 |
|
2012 |
0.048 |
0.011 |
|
2013 |
0.044 |
0.01 |
|
2014 |
0.04 |
0.01 |
Asset turnover of the bank is higher than that of the industry. It is more likely that the bank can utilize its assets and earn an operating income from them as compared to the industry. The turnover of the bank decreases significantly due to the increase in its non-interest expenses without an increase in its profits throughout the years.
Financial Underpinnings
The final underpinnings of the company include the loan portfolios, service charges, and core deposits. Financial underpinnings help in a great performance of the business since they create a foundation for the firm and also contribute to the achievement of the firm’s objective. For instance, in the case of core deposits, the company does not depend on local markets to finance its operations. Therefore, it means that it will not have more debts since it only relies on the capital markets and manages its operations efficiently (Subramanyam & Wild, 2009). Similarly, the service charges contribute to increasing gains in the firm for trading its assets and liabilities. Or, example, when consumers borrow loans from the bank, they are charged for the services. Also, on borrowing loans, the interest rates set for each amount is added as again to the firm leading to an increase in the profit.
Loan portfolio contributes to the financial performance of the firm. It comprises of all the loans the bank holds. Also, it depends on the interest that is to be earned on loans given to the consumers. The Commerce Bancshares has a higher percentage of the unused loans which contributes to the positive performance of the firm. This is because it has the opportunity to lend money to consumers and expect an interest rate which gives high returns leading to an increase in the gains of the company. Therefore, loan portfolio contributes to the financial performance of Commerce Bancshares.
PART B: Business Strategy
Fig. 6: Net Interest Margin
(Source: Gruenberg, et al., 2017)
Commerce Bancshares has a lower net interest margin of 26% as compared to that of the industry which is 74% (Gruenberg et al. 2017) .Therefore, the earning assets of the firm remain stable through the years due to the stability of the total assets of the firm. A decline in the interest margin of commerce is caused by the high yield on the customer’s loans which leads to an increase in the earning assets of the company. Similarly, an increase in the interest margin of the firm is due to the low charges on the interest of the loans borrowed by the consumers and low costs of funding that were required in the firm.
Fig. 7: Chart showing loss allowances
(Source: Gruenberg, et al., 2017)
Allowances for loan losses are established in the company so that it can be in a position to control its operating income. The allowance of commerce are higher than those of the industry; this shows that the firm is expecting loan losses in the future and therefore have implemented a way to curb the crisis that may befall the company (Gruenberg et al. 2017). Also, it shows that the loan portfolio of the firm increased rapidly through the years. Similarly, the allowance of the industry is low due to healthy capital markets that have led to an increase in the total assets which is caused by the credit quality of the capital markets.
Fig. 8: Chart showing the distribution of loans
(Source: Gruenberg, et al., 2017)
Loans to core deposits increase rapidly in the industry and were extremely low in commerce. This shows that commerce Bancshares does not rely on the local markets to provide funds for them as in the case of most large banks (Gruenberg et al. 2017). The ratio decreases rapidly as the firm merged with one bank and therefore did not consider to depend on other markets to fund their activities. On the hand, the industry relies greatly on local markets to finance its assets leading to a rapid increase in the core deposits ratio.
Fig. 9: Chart showing the loans to asset ratio
(Source: Gruenberg, et al., 2017)
The loan to asset ratio shows the amount of money that is given to its consumers as loans. Commerce Bancshares maintains a lower ratio than that of the company (Gruenberg et al. 2017). But when Bank one merged with commerce, the ratio increased since the bank offered a lot of loans to the consumers.
Fig. 10: Non-interest income %
(Source: Gruenberg, et al., 2017)
Commerce maintains a higher noninterest income as a percentage of operating income; this indicates that its income comes from the charges on deposits and the profits it gains from trading its assets and liabilities (Gruenberg et al. 2017).This increase in the ratio can be as a result of a decrease in the total operating income which results from an increase in provision of loans and losses.
Fig. 11: Cost efficiency ratio
(Source: Gruenberg, et al., 2017)
Commerce Bancshares has a high-cost efficiency ratio indicating that it is inefficient and is not able to control its costs. But due to its merger with Bank One in the year 2014, there was an increase in its noninterest expenses which led to an increase in the cost efficiency ratio.
Fig. 12: Equity to Asset Ratio
(Source: Gruenberg, et al., 2017)
Commerce Bancshares has a lower equity to asset ratio. This is because it utilizes its Equity since it’s a large bank and can access the capital markets easier than other banks (Gruenberg et al. 2017). Therefore, the industry cannot access the capital markets easily since it’s composed of many smaller banks.
Operating income = non-interest income- provision for loan losses + net interest income
= 440740 – 29530 + 615003 = 1026213
Non-interest income = 440740
Fiduciary activities = 108326/ 440740 = 24.58%
Service charges = 77549/ 440740 = 17.60
Fig. 13: Commerce Non-interest income in 2014
(Source: Gruenberg, et al., 2017)
Fig. 14: Industry Non-interest income in 2014
(Source: Gruenberg, et al., 2017)
Commerce Bancshares does not rely on deposits as a source of funds in financing its assets as the industry. The service charges of commerce are lower as compared to those of the industry on the deposits.
Fig. 15: Commercial Loan portfolio
(Source: Gruenberg, et al., 2017)
Fig. 16: Industry Loan Portfolio
(Source: Gruenberg, et al., 2017)
Commercial and industrial loans made up the largest of the industry and in commerce, the unused loan covered the largest part (Penman, 2007). The loan portfolio of commerce resembles that of the industry. Typically, the composition of the loan portfolio in commerce is more diversified than that of the industry.
Fig. 17: Commerce Industry Funding
(Source: Gruenberg, et al., 2017)
Fig. 18: Industry Deposit Funding
(Source: Gruenberg, et al., 2017)
Commerce does not rely on local markets to fund its operation hence leading to lower non-core deposits. Therefore its business strategy focuses mainly on diversifying funding sources and the market liquidity. Core deposits comprise a smaller portion of the funding than that of the industry (Gruenberg et al. 2017). And since commerce is a large bank, it does not rely on the local markets for finance. Unlike, the industry which relies on local markets since it is comprised of the smaller banks which do not have access to the capital markets.
Reference
Gruenberg, M., Hoenig, T., Noreika, K., & Cordray, R. (2017). FDIC: Federal Deposit Insurance Corporation. Fdic.gov. Retrieved 25 October 2017, from https://www.fdic.gov/
Penman, S. H. (2007). Financial Statement Analysis and Security Valuation (p. 476). New York, NY: McGraw-Hill.
Subramanyam, K. R., & Wild, J. J. (2009). Financial Statement Analysis (10th Ed.). New York, NY: McGraw-Hill.
Equity Multiplier
commerce 200.0 2001.0 2002.0 2003.0 2004.0 2005.0 6.0 2007.0 2008.0 2009.0 2010.0 11.0 2012.0 2013.0 2014.0 12.51 13.22 12.62 13.39 13.57 13.45 12.65 11.68 12.09 10.66 10.19 10.65 11.098 11.75 11.54 industry 200.0 2001.0 2002.0 2003.0 2004.0 2005.0 6.0 2007.0 2008.0 2009.0 2010.0 11.0 2012.0 2013.0 2014.0 10.93 11.04 11.78 9.790000000000001 9.9 9.89 10.99 8.85 9.040000000000001 10.67 9.780000000000001 8.97 8.94 8.91 8.89
profit margin
commerce 2000.0 2001.0 2002.0 2003.0 2004.0 2005.0 2006.0 2007.0 2008.0 2009.0 2010.0 2011.0 2012.0 2013.0 2014.0 0.26 0.26 0.26 0.28 0.28 0.26 0.25 0.19 0.2 0.23 0.25 0.13 0.26 0.26 0.25 industry 2000.0 2001.0 2002.0 2003.0 2004.0 2005.0 2006.0 2007.0 2008.0 2009.0 2010.0 2011.0 2012.0 2013.0 2014.0 87.8 87.2 89.3 90.0 90.1 90.8 88.1 83.2 65.6 64.5 72.6 80.1 88.6 88.7 91.2
Asset turnover
commerce 2000.0 2001.0 2002.0 2003.0 2004.0 2005.0 2006.0 2007.0 2008.0 2009.0 2010.0 2011.0 2012.0 2013.0 2014.0 0.065 0.06 0.06 0.06 0.06 0.062 0.06 0.057 0.051 0.049 0.053 0.05 0.048 0.044 0.04 industry 2000.0 2001.0 2002.0 2003.0 2004.0 2005.0 2006.0 2007.0 2008.0 2009.0 2010.0 2011.0 2012.0 2013.0 2014.0 0.013 0.013 0.014 0.016 0.014 0.014 0.014 0.005 -0.015 0.0012 0.009 0.009 0.011 0.01 0.01
Net Interest Margin commerce industry 0.0107 0.0309
allowances for losses as a% of assets commerce industry 0.0066 0.0047
loans to core deposits commerce industr y 0.0254 0.7997
loans to asset ratio commerce industry 0.0207 0.5273
non-interest income as a % of operating income
non-interest income to % of operating income commerce industry 0.4295 0.5702
cost efficiency ratio commerce industry 0.6349 0.5494
Equity to asset ratio commerce industry 0.0717 0.1111
2014 commerce non-intrest income fidiciar activities service charges 24.58 17.6
2014 industry non-interest income fidiciary activities service charges 15.0 30.0
commerce Loan portofolio
commerce lLoan portofolio insider loans unused loan loans held for sale non-current loans 4.9 95.06 0.0 0.013 loan portofolio insider loans unused loan loans held for sale non-current loans
industry Loan portofolio commercial and industrial loans real estate loans loans to individuals non-current loans 3.44 0.49 0.88 1.95
commerce deposit funding non-core deposit core deposit 45.69000000000001 54.3
industry deposit funding core deposits non-core deposits 79.97 20.03
Return on Equity
commerce 2000.0 2001.0 2002.0 2003 .0 2004.0 2005.0 2006.0 2007.0 2008.0 2009.0 2010.0 2011.0 2012.0 2013.0 2014.0 0.21 0.196 0.192 0.2 0.22 0.23 0.189 0.17 0.12 0.109 0.122 0.129 0.133 0.13 0.11 industry 2000.0 2001.0 2002.0 2003.0 2004.0 2005.0 2006.0 2007.0 2008.0 2009.0 2010.0 2011.0 2012.0 2013.0 2014.0 13.44 12.57 13.46 15.53 12.8 12.26 12.18 3.76 -10.14 -0.74 5.78 6.73 8.6 8.540000000000001 8.44
Return on Assets
commerce 2000.0 2001.0 2002.0 2003.0 2004.0 2005.0 2006.0 2007.0 2008.0 2009.0 2010.0 2011.0 2012.0 2013.0 2014.0 0.02 0.15 0.015 0.015 0.016 0.017 0.015 0.014 0.001 0.01 0.012 0.012 0.012 0.011 0.011 industry 2000.0 2001.0 2002.0 2003.0 2004.0 2005.0 2006.0 2007.0 2008.0 2009.0 2010.0 2011.0 2012.0 2013.0 2014.0 1.15 1.13 1.24 1.41 1.28 1.24 1.25 0.38 -0.96 -0.08 0.64 0.75 0.96 0.96 0.94