Get free samples written by our Top-Notch subject experts for taking online assignment help services in Australia.
Assets turnover ratio: Formula of this ratio is-
Assets Turnover Ratio = Turnover/ Total assets
Particulars |
2015 |
2014 |
2013 |
2012 |
Total assets |
1650791 |
2117328 |
2225397 |
1490321 |
Turnover |
43690 |
46893 |
56094 |
25609 |
Assets turnover ratio |
0.026 |
0.022 |
0.025 |
0.017 |
From the above calculations of Assets turnover ratio it is found that the ratio are calculated in times and in 2015 the ratio is maximum than 2013 and 2014 that is 0.026 times but the figure is very low, that Barclays financial manager should have to increase turnover by increasing operational efficiency.
Debtor's turnover ratio: It can be calculated as-
Debtors turnover ratio = Turnover / Debtors + Bills receivable
Particulars |
2015 |
2014 |
2013 |
2012 |
Turnover |
43690 |
46893 |
56094 |
25609 |
Debtors |
2102 |
2408 |
2486 |
4365 |
Debtors turnover ratio |
20.78 |
19.47 |
22.56 |
5.87 |
From the above measurement the debtors turnover ratio of 2013 is maximum than the other two years. In 2015 it is 20.78 times but in 2013 it was 22.56 times that the figure has been decreased as the amount of debtors is low than the other years.
Creditor's turnover ratio: Formula of this ratio-
Creditors Turnover ratio= Turnover/ Creditors
Particulars |
2015 |
2014 |
2013 |
2012 |
Turnover |
43690 |
46893 |
56094 |
25609 |
Creditors |
18462 |
21238 |
25399 |
3107 |
Creditors turnover ratio |
2.37 |
2.21 |
2.21 |
8.24 |
Creditor's turnover ratio from the above table has been computed in times and it has been found that it is maximum in 2015. This indicates that the company pays their suppliers in time that is good for the company that the ability of paying off the creditors is high of Barclays PLC in this regard that the ratio is 2.37 times in 2015.
3) Gearing Ratios for Evaluating Financial Performance
Shareholders equity and borrowed capital are the main components for calculating the gearing ratios such as capital gearing ratio and interest coverage ratio in order to measure the financial leverage and trading on equity capacity of a company.
Capital Gearing Ratio: Capital gearing ratio of a company help to analyse the organisational structure including the stockholders fund for fixed interest payment for a particular period of time. It can be calculated as-
Capital Gearing ratio= Common stock holders Equity/ Interest bearing bonds
Particulars |
2015 |
2014 |
2013 |
2012 |
Stock holders fund |
88154 |
92880 |
91732 |
59986 |
Fixed interest payments |
6625 |
6440 |
7962 |
N/A |
Capital gearing ratio |
13.31 |
14.42 |
11.52 |
N/A |
It has been found from the above table that the capital gearing ratio for 2014 is higher than 2014 and 2015 that is 14.42. Interpretation of the capital structure in order to measure the relationship between different sources of funds at a fixed interest rate is evaluated through this ratio. In this case the company is considered as the low geared that the larger portion of stock holders fund is composed by the equity capital.
Interest Coverage Ratio: In order to measure and evaluate a company's ability to make their payments for interest this ratio should have to be measured by the business analyst effectively and efficiently. It helps to understand the profitability and risk related to the company from which the creditors and investors can expect risk and return in future (Ivanov et al. 2015, p.153). Interest coverage ratio of Barclays plc should have to be calculated in order to identify financial position. Formula of this ratio-
Interest coverage ratio = Earnings before Interest and Taxes (EBIT)/ Interest expenses
Particulars |
2015 |
2014 |
2013 |
2012 |
EBIT |
9898 |
11756 |
15872 |
6570 |
Interest expenses |
6843 |
8238 |
11122 |
N/A |
Interest coverage ratio |
1.45 |
1.43 |
1.43 |
N/A |
From the above table it has been found that interest coverage ratio is maximum in 2015 that is 1.45 from the other financial years.
4) Evaluation of Profitability Ratios
Profitability ratios are the measurement of financial performance of a company for a particular financial period from which it can be understood the generations of earnings and profits and the ability of the company to meet the long and short term obligations appropriately. In this regard the selected company Barclays PLC's profitability ratios are mainly Gross profit ratio, Net profit ratio, Return on capital employed and Return on assets.
Gross profit ratio: Gross profit ratio can be calculated as- Gross profit/ Sales* 100
Particulars |
2015 |
2014 |
2013 |
2012 |
Sales |
43690 |
46893 |
56094 |
25609 |
Gross profit |
Nil |
Nil |
Nil |
Nil |
Gross profit ratio |
0 |
0 |
0 |
0 |
As in the income statement of Barclays plc, there is no gross profit; the gross profit ratio cannot be calculated.
Return on Capital employed: It can be calculated as-
ROCE = EBIT/ Capital employed* 100
Particulars |
2015 |
2014 |
2013 |
2012 |
EBIT |
9898 |
11756 |
15872 |
6570 |
Capital employed |
88154 |
80125 |
79004 |
59986 |
Return on Capital Employed |
11.23% |
14.67% |
20.09% |
10.95% |
In order to measure operational effectiveness and efficiency of business this ratio should have to be calculated. In 2013 it is higher that is 20.09% which indicates that performance level of the company has been decreased in 2015 that this ratio is 11.23% in 2015.
Net profit ratio: It can be calculated as-
Net profit ratio= Net profit/ Sales*100
Particulars |
2015 |
2014 |
2013 |
2012 |
Sales |
43690 |
46893 |
56094 |
25609 |
Net profit |
918 |
1318 |
2148 |
1810 |
Net profit ratio |
2.10% |
2.81% |
3.83% |
7.07% |
From the above calculation it can be concluded that net profit ratio in 2013 is higher than other two financial years as the company's net profit in 2015 has been decreased for which the net profit ratio is also decreased in this year to 2.10%. From this analysis it can be said that the company should have to improve profitability by improving their services effectively.
Return on Assets: Formula for this ratio is-
Return on Assets = Profit After tax/ Total assets *100
Particulars |
2015 |
2014 |
2013 |
2012 |
Profit After Tax |
988 |
1374 |
2055 |
1810 |
Total Assets |
1650791 |
2117328 |
2225397 |
1490321 |
Return on Assets |
0.06% |
0.06% |
0.09% |
0.12% |
Return on assets ratio is lower in these financial years which mean that the company Barclays plc is not so profitable and efficient relative to its total assets.
5) Ratios on Investors Analysis
Ratios relating to the investment analysis for Barclays plc can be calculated as follows-
EPS: Earnings available to Equity shareholders/ Number of shares
Particulars |
2015 |
2014 |
2013 |
2012 |
EAES |
918 |
1318 |
2148 |
1810 |
Number of shares |
169 |
169 |
169 |
169 |
Earnings per share |
5.43 |
7.8 |
12.71 |
10.71 |
From the above calculation it has been found that the organisation's Earnings per share has been decreased from 2013 to 2015 as earnings available to equity shareholders has also been deceased that lead to decline the earnings per share as to 5.43.
Dividend payout ratio: Dividend per share/ Earnings per share * 100
Particulars |
2015 |
2014 |
2013 |
2012 |
Dividend per share |
-13 |
-15.57 |
-16.38 |
6.50 |
Earnings per share |
5.43 |
7.8 |
12.71 |
-5.30 |
Dividend payout ratio |
-2.39 |
-1.99 |
-1.29 |
-1.22 |
Dividend payout ratio of the organisation is in negative figure as dividend per share to equity shareholders is in negative amount for which the organisation can face difficulties.
Dividend yield ratio: Dividend per share/ Market price per share *100
Particulars |
2015 |
2014 |
2013 |
2012 |
Dividend per share |
-13 |
-15.57 |
-16.38 |
6.50 |
Market price per share |
2.32 |
2.31 |
2.31 |
38.43 |
Dividend yield ratio |
-5.06 |
-6.7 |
-7.09 |
0.169 |
From the above table it is found that dividend yield ratio is in negative terms as dividend per share to equity and preference shareholders is so low that the company can face loss if the shareholders and investors unable to invest in the company.
Price earnings ratio: Market price per share/ Earnings per share
Particulars |
2015 |
2014 |
2013 |
2012 |
Market price per share |
2.32 |
2.31 |
2.31 |
38.43 |
Earnings per share |
5.43 |
7.8 |
12.71 |
-5.30 |
Price earnings ratio |
0.43 |
0.3 |
0.18 |
-7.25 |
Price earnings ratio is very low for this organisation compared to the other banking organisations in London. From the above table it has been found that the ratio has been increased to 0.43 in 2015 than the other two financial years.
Return on Equity: Profit after tax/ Equity shareholders fund* 100
Particulars |
2015 |
2014 |
2013 |
2012 |
Profit after tax |
988 |
1374 |
2055 |
1810 |
Equity shareholders fund |
88154 |
92880 |
91732 |
59986 |
Return on equity |
1.12% |
1.48% |
2.24% |
3.02% |
From the above table of analysis the profit after tax has been decreased to 988 in 2015 that lead to decrease the ratio of Return on equity effectively and efficiently. For this reason the financial preference of the company has also decreased.
Dividends coverage ratio: Profit after tax/ Dividend paid
Particulars |
2015 |
2014 |
2013 |
2012 |
Profit after tax |
988 |
1374 |
2055 |
1810 |
Dividend paid |
-2205 |
-2632 |
-2769 |
N/A |
Dividends coverage ratio |
-44.81% |
-52.20% |
-74.21% |
Nil |
Dividend coverage ratio is the ratio from which the company can understand the ability of the company to pay divided to shareholders out of the net income. From the above table it can be concluded that as the company failed to pay to the shareholders the ratio is in negative terms.
6) Analysis of Cash Flow Statement
Cash flow statement analysis of an organisation should have to be done in order to analyse the cash flow from investing activities, cash flow from operating activities and cash flow from the financing activities which will lead to evaluate the financial performance effectively and efficiently. From the cash flow statement analysis of Barclays plc, it can be understood by measuring the statement that in which segment the expenses have been made and from which activities the company can make profit appropriately. In this regard the analysis of the cash flow statement can be done by evaluating the statement.
Cash flow from operating activities has been increased in the financial year 2015 to $ 23771000 t as compared to 2013 and 2014. The company have improved their performance that reflecting in the Operating activities and it can be said the company's current assets has increased.
Total cash flow investing activities has been declined with high level and become negative in 2015 as $ 12431000 from which it can be concluded that Investment in assets such as fixed assets have been decreased as per the cash flow statement.
Cash flow from financing activities has also been declined in 2015 from 2013 and 2014 effectively but in 2015 the amount is higher than in 2014 from the cash flow financial statement that is -$ 650000. As a result the changes in cash and cash equivalent have been increased effectively with a very higher level to $ 11905000 that will lead to understand the company's high financial performance in this financial year.
Part C Findings and Recommendations
1) Financial Strengths and Weaknesses
Financial statement analysis of Barclays plc are evaluated by interpreting the Cash flow statement, Balance sheet and Income statement to measure the financial performance and financial position of the company for the financial years appropriately. From the above calculations and interpretation of financial statements strengths and weaknesses of the company are described as follows-
Strengths: In 2015 the company has enough current assets in order to meet their short term and long term obligations and it has been found that the company's current ratio is 2.92:1 that is above appropriate ratio which is considered as a strong point of the company. The quick ratio is also higher than its appropriate level mentioned in the accounting rules and legislations effectively. According to the efficiency ratio the level of assets turnover ratio is lower but it has been continued to increase year to year. From the measurement and interpretation of efficiency ratio it has been concluded that the company's assets and financial sources are utilised in proper manner in order to increase performance level and financial position in the economy.
Weakness: Weakness of the company can be analysed from the ratio analysis and by comparing them with other financial years effectively and efficiently. Profitability ratios of the financial years is so weak as net profit ratios are decreasing from the previous years as net profit is declining. Ratio of ROCE has also deceased that it will lead to lower performance level and profitability of the company.
2) Conclusion and Recommendations
Financial statement analysis is considered as a process and accounting technique of evaluating the performance level of an organisation by reviewing and interpreting accounting and annual reports effectively and appropriately by following accounting rules and regulations for evaluating projected performance of the company that can lead to help in order to make decisions. In this regard ratio analysis is the important technique for evaluating strengths and weakness of the company in a proper manner by efficiency, Profitability, investment, liquidity ratios and profitability positions of the companies in an appropriate manner. In this regard analysis of cash flow statement should have to be done in order to measure the investing, financing and operating activities to evaluate efficiency level of the company.
Recommendations can be concluded by evaluating the financial performance and position of the Barclays plc that the company should have to provide quality and standardised services including investment banking, corporate banking, wealth management and other financial services as per the customer requirements in order to increase the profitability positions of the company. The company's holding is so high as compared to the sales level. Therefore it is recommended to the financial manager and business analyst of the company to increase sales management team should have to find investors and shareholders for more financial services effectively. Barclay's directors should have to take financial decisions in order to pay proper amount of dividend to the investors and shareholders according to the expectations that they can sustain them for the next year.
Reference list
Barclays.co.uk. (2017). Barclays | Personal Banking. Available from: http://www.barclays.co.uk [Accessed 12 Jan. 2017].
Bekaert, G., Harvey, C.R., Lundblad, C.T. and Siegel, S., 2016. Political risk and international valuation. Journal of Corporate Finance, 37, pp.1-23.
Bies, R.J., Barclay, L.J., Tripp, T.M. and Aquino, K., 2016. A systems perspective on forgiveness in organizations. The Academy of Management Annals, 10(1), pp.245-318.
Camin, F., Bontempo, L., Perini, M. and Piasentier, E., 2016. Stable Isotope Ratio Analysis for Assessing the Authenticity of Food of Animal Origin. Comprehensive Reviews in Food Science and Food Safety, 15(5), pp.868-877.
Chikezie, P.C., Ibegbulem, C.O., Monago, O.S., Mbagwu, F.N. and Nwachukwu, C.U., 2016. Amino Acid Profiles, Total Nitrogen Contents, and Computed-Protein Efficiency Ratios of Manihotesculenta Root and Dioscorearotundata Tuber Peels. Journal of Food Processing, 2016.
Crook, M.W., 2014. An equity portfolio framework for combining active management and index-based implementation. The Journal of Index Investing, 5(1), pp.38-44.
Davies, H. and Green, D., 2013. Global Financial Regulation: The Essential Guide (Now with a Revised Introduction). John Wiley & Sons.
Epstein, M.J. and Buhovac, A.R., 2014. Making sustainability work: Best practices in managing and measuring corporate social, environmental, and economic impacts. Berrett-Koehler Publishers.
Foulds, D., Sowter, P.J., Bartlett, S., Goldstone, J., Dwyer, D.J., Sayers, I., O'brien, C. and Winters, J., Barclays Bank PLC, 2015. Registering a Mobile User. U.S. Patent 20,150,371,227.
Freund, A. and Mustaro, P.N., 2016. PHABRIKA: teaching financial techniques to sell through Serious game. In New Advances in Information Systems and Technologies (pp. 199-208). Springer International Publishing.
Goldmann, K., 2016. Financial Liquidity and Profitability Management in Practice of Polish Business. In Financial Environment and Business Development (pp. 103-112). Springer International Publishing.
Hirsa, A. and Neftci, S.N., 2013. An introduction to the mathematics of financial derivatives. Academic Press.
Ivanov, I.T., Santos, J.A. and Vo, T., 2016. The transformation of banking: Tying loan interest rates to borrowers' CDS spreads. Journal of Corporate Finance, 38, pp.150-165.
Roncalli, T. and Weisang, G., 2016. Risk parity portfolios with risk factors. Quantitative Finance, 16(3), pp.377-388.
Sahoo, D. and Vidyadhar Reddy, A., 2014. Selection of Credit Cards by Indian Consumers: An Empirical Study. Vilakshan: The XIMB Journal of Management, 11(1).
Sharma, S. and Crossler, R.E., 2014. Disclosing too much? Situational factors affecting information disclosure in social commerce environment. Electronic Commerce Research and Applications, 13(5), pp.305-319.
Tsai, J., Bertoni, D., Hernandez-Boussard, T., Telli, M.L. and Wapnir, I.L., 2016. Lymph node ratio analysis after neoadjuvant chemotherapy is prognostic in hormone receptor-positive and triple-negative breast cancer. Annals of Surgical Oncology, 23(10), pp.3310-3316.
Weil, R.L., Schipper, K. and Francis, J., 2013. Financial accounting: an introduction to concepts, methods and uses. Cengage Learning.
Appendices:
Appendix 1
Appendix 2
1) Calculation for current ratio = Current assets/ Current liabilities
2012 = 552393/ 1427364 = 0.39
2) Calculation for Quick ratio = Quick assets/ Quick liabilities
= Current assets- Stock - Prepaid expenses/ Current liabilities - Bank overdraft
2012 = 552393 / 1427364 = 0.39
3) Calculation for Working capital ratio = Current assets - Current liabilities
2012 = 552393 – 1427364 = -874971
4) Calculation for Assets Turnover Ratio = Turnover/ Total assets
2012 = 25609/ 1490321 = 0.017 times
5) Calculation for Debtor's turnover ratio = Turnover / Debtors + Bills receivable
2012 = 25609 / 4365 = 5.87 times
6) Calculation for Creditors Turnover ratio= Turnover/ Creditors
2012 = 25609/ 3107 = 8.24 times
7) Calculation for Capital Gearing ratio= Common stock holders Equity/ Interest bearing bonds
2012 = 59986/ N/A = N/A
8) Calculation for Interest coverage ratio = Earnings before Interest and Taxes (EBIT)/ Interest expenses
2012 = 6570 / N/A = N/A
9) Calculation for Gross profit ratio = Gross profit/ Sales* 100
2012 = Nil/25609 *100 = 0
10) Calculation for Return on Capital employed = EBIT/ Capital employed* 100
2012 = 6570/ 59986 *100 = 10.95%
11) Calculation for Net profit ratio= Net profit/ Sales*100
2012 = 1810/25609*100 =7.07%
12) Calculation for Return on Assets = Profit After tax/ Total assets *100
2012 = 1810/ 1490321 *100 = 0.12%
13) Calculation for EPS: Earnings available to Equity shareholders/ Number of shares
2012 = 1810/ 169 = $10.71
14) Calculation for Dividend payout ratio: Dividend per share/ Earnings per share * 100
2012 = 6.50/ -5.30 = -1.22
15) Calculation for Dividend yield ratio: Dividend per share/ Market price per share *100
2012 = 6.50/ 38.43 = 0.169
16) Calculation for Price earnings ratio: Market price per share/ Earnings per share
2012 = 38.43/ -5.30 = -7.25
17) Calculation for Return on Equity: Profit after tax/ Equity shareholders fund* 100
2012 = 1810/ 59986 *100 = 3.02%
18) Calculation for Dividends coverage ratio: Profit after tax/ Dividend paid
2012 = 1810/ N/A = Nil