USA + 1-760-3923232 | UK +44-203-3181775
Faculty of Social Sciences – Formative Assessment Brief for Students
Diet |
Semester 1 |
Assessment type
|
Report |
Assessment limits
|
Maximum 2,000 words (excluding reference list & appendixes). Word count must not exceed the limit by more than 10%. In cases where this +10% limit is exceeded, only the first 2,200 words will be marked.
|
Assessment weighting
|
0% This is an optional formative assessment and does not form part of your final grade. It is your chance to get tutor FEEDBACK. A grade will not be given, but feedback will indicate how your work matches against our expectations and where you can make improvements before your final submission.
|
Assessment brief (if appropriate, please refer to module assessment briefing document)
|
You are required to produce an individual report based on your own independent work. Your work will automatically be based through Turnitin text matching software. Your work must be supported by academic evidence from textbooks and journal articles and be fully referenced in the Harvard referencing style. Answer the two first questions from your final assessment brief. Part 1 Produce a financial analysis of the profitability of a UK FTSE 100 company of your choice. You should use ratio analysis, prior year comparisons and peer company comparisons to reach a balanced conclusion. Part 2 Critically discuss the benefits and drawbacks of using annual budgets and variance analysis to manage an organisation. |
MANAGING FINANCIAL PERFORMANCE
Executive summary
A detailed analysis of the monetary performance of Barclays Plc and HSBC has been done in this report. It focuses on some relevant financial ratios to evaluate the profitability and financial efficiency of the business. It is necessary for the financial management of Barclays Plc to initiate trade finance solutions and payment security for enhancing the working capital of the bank. Benefits and drawbacks of annual budgets and variance analysis are also discussed in this aspect. Main focus of this context is to determine the financial performance of the organization based on the annual budgets. Profitability analysis of the companies is also done in this aspect. A brief evaluation of variance analysis has been done in this aspect.
This report focuses on evaluation of strengths and weaknesses of balanced scorecard model to measure the organizational performance. Balanced scorecard has a great role in fulfilling the organizational goal significantly. A detailed evaluation of the investment appraisal technique is also done in this report. A brief discussion on risk analysis and time dimension is also done in this aspect. The appraisal techniques indicated in this report are internal rate of return, payback period, net present value, accounting rate of return and profitability index. Determination of the appropriate form of investment technique is also done in this aspect. It also determines the financial performance of a project. A detailed evaluation of balanced scorecard and DCF technique has been done in this context.
Table of Contents
Ratio analysis for Barclays Plc. 4
Comparison of profitability. 6
Benefits of annual budgets and variance analysis 8
Drawbacks of annual budgets and variance analysis 10
Strengths and weaknesses of using balanced scorecard. 13
Appropriate forms of investment appraisal 17
Discounted cash flow technique. 19
Main purpose of this report is to identify the financial performance of Barclays Plc, a reputed investment bank in the UK. Comparison of the profitability with the peer company HSBC will be done in this context. Purpose of the annual budget will be analyzed in this aspect.
The profitability ratios of Barclays Plc are used to assess the ability of the company to earn a huge profit from financial operations. It is also used as a financial metric to generate value for the shareholders.
Return on capital employed
A detailed evaluation of EBIT and “capital employed” has been done for calculating ROCE (Jain, Parewa and Ratnoo, 2019). Based on the financial analysis, it is detected that the EBIT and “capital employed” in the financial year 2020 are £3065000 and £66882000 respectively. It can determine the ability to generate profit by the financial management of Barclays Plc. The “return on capital employed” in the last 3 financial years are 5.5%, 7.7% and 4.6% respectively.
Return on equity
A brief analysis of “net income” and “stockholder’s equity” has been done for identifying “return on equity” for the organization. The ROE of the last 3 consecutive years are 0.03, 0.04 and 0.03 respectively. It signifies downfall in the market in the financial year 2020. Utilisation of equity on earning profit has been decreased in 2020. COVI 19 and financial problems in several countries have an impact on profitability.
Operating profit margin
Operating profit margin of a company evaluates earnings of the company from operation after payment of all operation costs (Zaleski and Chawla, 2020).. High operating cost indicates that the company effectively handles their operation cost. Data suggest that operating margin was 17% in 2018, 20% in 2019 and 10% in 2020. It implies that the ratio is decreasing rapidly and it implies that companies have lost their ability to manage operating costs.
Gross profit margin
Gross profit margin refer amount of profit earn after subtract manufacturing cost from tidal sales. Data suggest that gross profit margin decreasing last three years and it implied company lost theory biology earn profit and manage manufacturing cost.
Net profit margin
Net profit margin refers to the amount of profit a company earns from their sale in a period. Low ratio implies that the company lost their profitability position. Ratio data help to identify that net profit margin decreased in the last three year and it implied management failed to move the company into fraction of profitability (home.barclays, 2021).
Debt to assets ratio
The “debt-to-assets ratio” in the last 3 years are 16.76, 16.36 and 19.17 respectively. This ratio implies that debt has been increased in 2020 due to lack availability of liquid cash for run operations. This debt can create trouble for company bi increase burden.
Interest cover ratio
As mentioned by Yükselet al. (2018), the “overall earnings” of the investment bank has been determined by “interest cover ratio”. Based on the analysis of EBIT and “interest expense”, the “interest cover ratio” in the year 2019 and 2020 are 21.07 and 19.97 respectively. .Financial data suggest that company will be able to repay their interest by using EBIT though the ability of the company has been decreased in 2020.
In this scenario, the profitability ratios determine the efficiency of the financial management of HSBC to earn profit from the selling operations.
Return on capital employed
Based on the financial analysis, it is detected that the EBIT of HSBC in the year 2019 and 2020 are £13347000 and £8777000 respectively. It results in decrease in profitability in 2020 compared to the previous year. The “return on capital employed” in the last 2 years are 6.9% and 4.3% respectively.
Return on equity
Return on equity refers to utilization of equity for earning profit. High return on equity refers to the use of equity efficiently for earning profit. Return of equity in 2018 was 7%, 4% in 2019 and 3% in 2020. This data implies that return on equity decrease in last three years rs. It helps to identify that the company failed to utilize equity.
Operating profit margin
Operating profit margin refers to the relation between operating profits with sales. High ratios mean that companies manage their operating activities effectively to earn profit whereas low profit margins refer to the inefficiency of managers to earn profit. Operating profit margin was 37% in 2018, 24% in 2019 and 17% in 2020. This data implies that the company lost the abilities to manage their operation, which made an impact in their operation and operating profit margin decreased.
Gross profit margin
Gross profit margin ratio refers to the relation between gross profit and sales. Gross profit margin helps to identify abilities to manage cost of sales. Gross profit margin was 37% in 2018, 16.5% in 2019 and 16.7% in 2020. This data implies that profit margin has been decreasing and decreasing profit margin refers to that company being futile toi manage cost of sales.
Net profit margin
Net profit margin helps investors identify the relation between net profit and sales. It evaluates how much profit earned from sles. Net profit margin was 25% in 2018, 13% in 2019 and 10% in 2020. This data implies that companies lost their abilities to earn profit for this reason gross, operating and net profit has decreased in 2020.
Debt to assets ratio
Debt to asset ratio identifies the amount of assets purchased by using debt (Husain and Sunardi, 2020). High debt asset ratio is bad for organizations because companies may need to pay their maximum asset to repay debt. Asset debt ratio decreased in 2019 and increased in a small amount in 2020. Low debt to asset ratio pimples that companies effectively manage their debt and assets. In addition, they need a low amount of assets to repay debt. (Husain and Sunardi, 2020).
Interest cover ratio
Interest coverage ratio refers to the amount of profit that needs to be paid for interest. Interest coverage ratio was 12% in 2018, 8% in 2019 and 6% in 2020. Companies have the ability to repay their loan by using profit. Data suggest that companies gradually lose their ability to pay their interest by using profit. It is a bad sign for companies because they can face several problems in the near future based on this interest rate.
Based on the comparison of Barclays Plc and HSBC, it has been detected that HSBC operates more profitable business than its peer company. As the “operating profit margin” of the two companies in the financial year 2019 are 0.20 and 0.23 respectively. It is necessary for the financial management of Barclays Plc to initiate “trade finance solutions” and “payment security” for enhancing the “working capital” of the bank. It can also play a significant role in enhancing profitability. Debt to equity coverage ratio of HSBC is better than Barclays whereas interest coverage ratio of Barclays better than HSBC. This data indicated HSBC is good for investment because they have better profitability and debt to equity ratio.
[Refer to Appendix 1]
This report sheds light on the performance analysis of Barclays Plc and HSBC to determine the profitability. It also analyzes the “financial ratio” of the two organizations. The role of “annual budget” and “variance analysis” has been identified in this context. Main focus of this report is to determine the “financial sustainability” of the organization. The “trade finance solutions” and “payment security” have been evaluated in this aspect. Based on the “operating profit margin”, it has been identified that HSBC operates a more profitable business than Barclays Plc.
Budget of an organization refers to forecasting expenses and income for a certain period. This budget can be different in the practical field and the difference between actual and standard is called variance. This report will discuss the benefits and drawbacks of the budget along with variance analysis. In the current scenario, brief evaluation of annual budget will be done to determine the financial efficiency of the organization. It is also necessary to conduct variance analysis to identify the “favorable variance” as an indicator of organizational performance. A detailed organizational planning can be conducted in this aspect. The organizational policies can be evaluated in this process.
There are some advantages of using “annual budgets” for managing an organization. The benefits of “annual budget” are mentioned below:
There are also some benefits of variance analysis that can be considered for evaluating the monetary performance. The benefits are mentioned below:
There are some drawbacks of using “annual budgets” for managing an organization. The drawbacks are:
In spite of the benefits, there are also some disadvantages of “variance analysis”. The disadvantages are:
Report has been discussed about budget variance in this report. Reports suggest that it can help to evaluate financial condition and performance of management. On the other hand, the benefit of voting has been evaluated, which is it helps to allocate funds, raise funds on necessity time and so on. Drawbacks have been highlighted in this report. Main focus of this report is to identify the overall performance of the organization based on “annual budget” and “variance analysis”. Based on the analysis, it is detected that there are some merits and demerits of both the process. Some relevant “financial standards” are associated with evaluating “variance analysis”. This report sheds light on determining the “shareholder value” in an organization. A detailed evaluation of monetary advantages from the budgetary approach has been done in this aspect. It can play a crucial role in financial analysis.
In this report, the merits and demerits of “balanced scorecard” will be discussed. It sheds light on efficient performance measurement of an organization using a “balanced scorecard”. Main purpose of this report is to determine the approach taken by the management to manage an organization. Identification of the forms of “investment appraisal” will be done in this aspect. It is necessary to determine a relevant “investment appraisal” for initiating “long-term large-scale investment”. It is a performance measurement metric used to identify the outcomes of the internal operations of an organization. It was invented by David Norton and Robert Kaplan. The effectiveness of BSC will be analyzed in this aspect.
Strengths
The strengths of “balanced scorecard” for measure the performance are discussed below:
Weaknesses
In spite of having some relevant strengths, there are some weaknesses detected in the “balanced scorecard” for performance measurement. The weaknesses are:
This context sheds light on the merits and demerits of “balanced scorecard”. Whether the organization is unable to detect the risk, it is not possible to make an effective strategy to improve the performance. It is a huge initiative taken by the business management to prepare a “strategic diagram” in this aspect. Proper implementation of the “balanced scorecard” helps the organization determine “customer satisfaction”. However, the system is dependent upon the data collected by the organizational management. The “complicated framework” restricts the business to evaluate the business sustainability effectively. It is a huge responsibility for the leaders to implement an effective system in this aspect.
A detailed analysis of investment appraisal techniques will be done in this aspect. The “appraisal techniques” are “internal rate of return”, “payback period”, “net present value”, “and accounting rate of return” and “profitability index”. The investors can initiate “long-term investment” whether the IRR is higher. In the present scenario, “discounted cash flow technique” is determined as most beneficial for making investment decisions.
There are some relevant forms of “investment appraisal” to be considered by the stakeholders of a business. The investors can make investment decisions for a “long-term” based on the “appraisal techniques”. The 5 techniques are the most relevant forms of “investment appraisal” for “large-scale investments”. The “appraisal techniques” are discussed below:
IRR provides information about the “annual growth rate” of the business. It also analyzes the “capital budgeting projects” to evaluate the “annual rate of return”. It also plays an effective role in determining “long-term profitability” of the business. Thus, higher “internal rate of return” is considered as desirable for the investors and the financial management of the business.
Based on the analysis, it is indicated that the “payback period” plays a major role in attracting “large-scale investments”. The fund managers use this “appraisal technique” to evaluate whether the business can be initiated with an investment. It is also necessary to determine the “time value of money”. The investors can also identify the “break-even point” of the business by using this “appraisal technique”. It provides relevant information regarding “annual cash flows” of the business.
It is necessary to estimate “future cash flows” to evaluate the “discount rate” associated with the “appraisal technique”. Main focus of the investors is to determine whether the “net present value” is positive before “long-term investment”. Based on the “financial analysis”, the financial management indicates that “negative NPV” results in poor financial condition of the project (Andriosopoulos et al. 2019). It restricts the project or the business to attract “large-scale investment”. The potential investors can also evaluate the “discount rate” in this aspect.
Whether the ARR is high, it is beneficial for the investors to invest in the business efficiently. It can allow them to generate a huge return from the business. Highest IRR also allows the business to get rid of the “financial crisis”. Thus, “long-term large-scale investment” is ensured in this process. After evaluating the “capital budgeting”, the potential investors can consider the “financial ratio” to make decisions for “long-term investment”.
The investors have to determine whether the “profitability index” is more than 1.0 or not. Whether it is more than 1.0, it is regarded as a “good investment” for the investors. It is also beneficial for all the stakeholders of the project. This “investment appraisal technique” identifies the values generated in “each investment unit”. In this scenario, whether the “profitability index” is desirable for the project, it is effective for the potential investors to maintain “large-scale investment”.
It is the most effective technique in investment appraisal. The strengths and weaknesses of this technique are discussed below:
Strengths
Weaknesses
It focuses on determining the strengths of drawbacks of the measurement technique. It makes a positive impact on customers and “internal processes” of the business. A brief discussion on “risk analysis” and “time dimension” is also done in this aspect. The “appraisal techniques” indicated in this report are “internal rate of return”, “payback period”, “net present value”, “accounting rate of return” and “profitability index”. It is necessary to evaluate relevant “accounting theories” to determine the appropriate “investment appraisal” for “long-term investments”. It also plays an important role in making “investment decisions”. NPV and IRR are considered as the most appropriate “investment appraisal” in this aspect. A detailed evaluation of DCF technique has been done in this aspect.
Aerts, G., Dooms, M. and Haezendonck, E., 2017. Knowledge transfers and project-based learning in large scale infrastructure development projects: an exploratory and comparative ex-post analysis. International Journal of Project Management, 35(3), pp.224-240. Available at https://www.sciencedirect.com/science/article/pii/S0263786316302770 [Accessed on 9 November 2021]
Andriosopoulos, D., Doumpos, M., Pardalos, P.M. and Zopounidis, C., 2019. Computational approaches and data analytics in financial services: A literature review. Journal of the Operational Research Society, 70(10), pp.1581-1599. Available at https://www.tandfonline.com/doi/abs/10.1080/01605682.2019.1595193 [Accessed on 12 November 2021]
Aprayuda, R., Misra, F. and Kartika, R., 2021. Does the Order of Information Affect Investors’ Investment Decisions? Experimental Investigation. Journal of Accounting and Investment, 22(1), pp.150-172. Available at https://scholar.archive.org/work/s7jdcexo5bcvzm4tljbg4xg55m/access/wayback/https://journal.umy.ac.id/index.php/ai/article/download/9965/pdf [Accessed on 10 November 2021]
Bottazzi, P., Crespo, D., Bangura, L.O. and Rist, S., 2018. Evaluating the livelihood impacts of a large-scale agricultural investment: Lessons from the case of a biofuel production company in northern Sierra Leone. Land use policy, 73, pp.128-137. Available at https://www.sciencedirect.com/science/article/pii/S0264837717303125 [Accessed on 8 November 2021]
Camilleri, M.A., 2021. Using the balanced scorecard as a performance management tool in higher education. Management in Education, 35(1), pp.10-21. Available at https://journals.sagepub.com/doi/abs/10.1177/0892020620921412 [Accessed on 25 October 2021]
D'Odorico, P., Rulli, M.C., Dell'Angelo, J. and Davis, K.F., 2017. New frontiers of land and water commodification: Socio‐environmental controversies of large‐scale land acquisitions. Land Degradation & Development, 28(7), pp.2234-2244. Available at https://onlinelibrary.wiley.com/doi/abs/10.1002/ldr.2750 [Accessed on 2 November 2021]
Hasan, R.U. and Chyi, T.M., 2017. Practical application of Balanced Scorecard-A literature review. Journal of Strategy and Performance Management, 5(3), p.87. Available at https://www.academia.edu/download/57004607/5-3-87-103.pdf [Accessed on 28 October 2021]
Hatefi, S.M. and Haeri, A., 2019. Evaluating hospital performance using an integrated balanced scorecard and fuzzy data envelopment analysis. Journal of Health Management & Informatics, 6(2), pp.66-76. Available at http://jhmi.sums.ac.ir/index.php/JHMI/article/view/522 [Accessed on 27 October 2021]
home.barclays (2021), Financial data, Available at https://home.barclays/ [Accessed on 27 October 2021]
hsbc.com (2021), Financial data, Available at https://www.hsbc.com/ [Accessed on 26 October 2021]
Husain, T. and Sunardi, N., 2020. Firm's Value Prediction Based on Profitability Ratios and Dividend Policy. Finance & Economics Review, 2(2), pp.13-26. Available at https://papers.ssrn.com/sol3/papers.cfm?abstract_id=3895231 [Accessed on 30 October 2021]
Jain, L.K., Parewa, H.P. and Ratnoo, S., 2019. Impact of frontline demonstration on productivity and profitability analysis of cluster bean in Barmer district of Rajasthan. Forage Research, 44(4), pp.283-286. Available at http://forageresearch.in/wp-content/uploads/2019/03/282-285.pdf [Accessed on 1 November 2021]
Jiang, H., Sohn, L.L., Huang, H. and Chen, L., 2018. Single cell clustering based on cell-pair differentiability correlation and variance analysis. Bioinformatics, 34(21), pp.3684-3694. Available at https://academic.oup.com/bioinformatics/article-abstract/34/21/3684/4996592 [Accessed on 3 November 2021]
Kallner, A. and Theodorsson, E., 2020. An experimental study of methods for the analysis of variance components in the inference of laboratory information. Scandinavian journal of clinical and laboratory investigation, 80(1), pp.73-80.
Karimi, S. and Mansouri, S., 2018. A comparative profitability study of geothermal electricity production in developed and developing countries: Exergoeconomic analysis and optimization of different ORC configurations. Renewable Energy, 115, pp.600-619. Available at https://www.researchgate.net/profile/Asif-Bin-Karim/publication/330114996_PROSPECT_OF_GEOTHERMAL_ENERGY_RESOURCES_IN_BANGLADESH/links/5c2e3e71299bf12be3ab2482/PROSPECT-OF-GEOTHERMAL-ENERGY-RESOURCES-IN-BANGLADESH.pdf [Accessed on 28 October 2021]
Kline, P., Saggio, R. and Sølvsten, M., 2020. Leave‐out estimation of variance components. Econometrica, 88(5), pp.1859-1898.
Malkamäki, A., D’Amato, D., Hogarth, N.J., Kanninen, M., Pirard, R., Toppinen, A. and Zhou, W., 2018. A systematic review of the socio-economic impacts of large-scale tree plantations, worldwide. Global Environmental Change, 53, pp.90-103. Available at https://www.sciencedirect.com/science/article/pii/S0959378017311937 [Accessed on 3 November 2021]
Marimin, M., Wibisono, A. and Darmawan, M.A., 2017. Decision support system for natural rubber supply chain management performance measurement: A sustainable balanced scorecard approach. International Journal of Supply Chain Management, 6(2), pp.60-74. Available at http://ijis-scm.bsne.ch/ojs.excelingtech.co.uk/index.php/IJSCM/article/download/1455/1455-5666-1-PB.pdf [Accessed on 26 October 2021]
Pantaleo, A.M., Camporeale, S.M., Miliozzi, A., Russo, V., Shah, N. and Markides, C.N., 2017. Novel hybrid CSP-biomass CHP for flexible generation: Thermo-economic analysis and profitability assessment. Applied Energy, 204, pp.994-1006. Available at https://www.sciencedirect.com/science/article/pii/S0306261917305287 [Accessed on 25 October 2021]
Prol, J.L. and Steininger, K.W., 2017. Photovoltaic self-consumption regulation in Spain: Profitability analysis and alternative regulation schemes. Energy Policy, 108, pp.742-754. Available at https://www.sciencedirect.com/science/article/pii/S0301421517303750 [Accessed on 2 November 2021]
Rafiq, M., Zhang, X., Yuan, J., Naz, S. and Maqbool, S., 2020. Impact of a balanced scorecard as a strategic management system tool to improve sustainable development: measuring the mediation of organizational performance through PLS-smart. Sustainability, 12(4), p.1365. Available at https://www.mdpi.com/640118 [Accessed on 29 October 2021]
Taghizadeh-Hesary, F. and Yoshino, N., 2020. Sustainable solutions for green financing and investment in renewable energy projects. Energies, 13(4), p.788. Available at https://www.mdpi.com/638352 [Accessed on 4 November 2021]
van Huijstee, A.N. and Kessels, H.W., 2020. Variance analysis as a tool to predict the mechanism underlying synaptic plasticity. Journal of neuroscience methods, 331, p.108526. Available at https://www.sciencedirect.com/science/article/pii/S0165027019303838 [Accessed on 5 November 2021]
Yüksel, S., Mukhtarov, S., Mammadov, E. and Özsarı, M., 2018. Determinants of profitability in the banking sector: an analysis of post-soviet countries. Economies, 6(3), p.41. Available at https://www.emerald.com/insight/content/doi/10.1108/JEFAS-05-2018-0043/full/html [Accessed on 29 October 2021]
Zaleski, P. and Chawla, Y., 2020. Circular economy in Poland: Profitability analysis for two methods of waste processing in small municipalities. Energies, 13(19), p.5166. Available at https://www.sciencedirect.com/science/article/pii/S030438942102183X [Accessed on 28 October 2021]
Calculating Return on equity |
|||
Years |
Return on equity |
Amount |
Ratio |
2018 |
Net income |
£ 2,146,000.00 |
0.033647 |
Stockholders' equity |
£ 63,779,000.00 |
||
2019 |
Net income |
£ 3,274,000.00 |
0.049863 |
Stockholders' equity |
£ 65,660,000.00 |
||
2020 |
Net income |
£ 2,383,000.00 |
0.03563 |
Stockholders' equity |
£ 66,882,000.00 |
Calculating Operating Profit Margin |
|||
Years |
Operating Profit Margin |
Amount |
Ratio |
2018 |
Operating profit |
£ 34,940,00.00 |
0.1653417 |
Net sales |
£ 21,132,000.00 |
||
2019 |
Operating profit |
£ 43,570,00.00 |
0.2014798 |
Net sales |
£ 21,625,000.00 |
||
2020 |
Operating profit |
£ 3,065,000.00 |
0.096948 |
Net sales |
£ 31,615,000.00 |
Calculating Gross profit margin |
|||
Years |
Gross profit margin |
Amount |
Ratio |
2018 |
Gross profit |
£ 34,94,000.00 |
0.165342 |
Revenue |
£ 2,11,32,000.00 |
||
2019 |
Gross profit |
£ 13,41,100.00 |
0.062016 |
Revenue |
£ 2,16,25,000.00 |
||
2020 |
Gross profit |
£ 13,41,100.00 |
0.04242 |
Revenue |
£ 3,16,15,000.00 |
Calculating net profit margin |
|||
Years |
Net profit margin |
Amount |
Ratio |
2018 |
Net profit |
£ 21,46,000.00 |
0.101552 |
Revenue |
£ 2,11,32,000.00 |
||
2019 |
Net profit |
£ 32,74,00.00 |
0.01514 |
Revenue |
£ 2,16,25,000.00 |
||
2020 |
Net profit |
£ 23,83,00.00 |
0.007538 |
Revenue |
£ 3,16,15,000.00 |
Calculating Debt to assets ratio |
|||
Years |
Debt to assets ratio |
Amount |
Ratio |
2018 |
Total liabilities |
£ 1,069,504,000.00 |
16.76891 |
Shareholders' equity |
£ 63,779,000.00 |
||
2019 |
Total liabilities |
£ 1,074,569,000.00 |
16.36566 |
Shareholders' equity |
£ 65,660,000.00 |
||
2020 |
Total liabilities |
£ 1,282,632,000.00 |
19.17754 |
Shareholders' equity |
£ 66,882,000.00 |
Calculating Interest cover ratio |
|||
Years |
Interest cover ratio |
Amount |
Ratio |
2018 |
Earnings before interest and taxes |
£ 2,146,000.00 |
14.66648 |
Total amount of interest expense |
£ 146,320.00 |
||
2019 |
Earnings before interest and taxes |
£ 3,274,000.00 |
21.07906 |
Total amount of interest expense |
£ 155,320.00 |
||
2020 |
Earnings before interest and taxes |
£ 2,383,000.00 |
19.97653 |
Total amount of interest expense |
£ 119,290.00 |
Calculating Return on equity |
|||
Years |
Return on equity |
Amount |
Ratio |
2018 |
Net income |
£ 13,727,000.00 |
0.070674 |
Shareholders' equity |
£ 194,229,000.00 |
||
2019 |
Net income |
£ 7,383,000.00 |
0.03832 |
Shareholders' equity |
£ 192,668,000.00 |
||
2020 |
Net income |
£ 5,229,000.00 |
0.025508 |
Shareholders' equity |
£ 204,995,000.00 |
Calculating Operating Profit Margin |
|||
Years |
Operating Profit Margin |
Amount |
Ratio |
2018 |
Operating profit |
£ 19,890,000.00 |
0.369181 |
Net sales |
£ 53,876,000.00 |
||
2019 |
Operating profit |
£ 13,347,000.00 |
0.235384 |
Net sales |
£ 56,703,000.00 |
||
2020 |
Operating profit |
£ 8,777,000.00 |
0.174743 |
Net sales |
£ 50,228,000.00 |
Calculating Gross profit margin |
|||
Years |
Gross profit margin |
Amount |
Ratio |
2018 |
Gross profit |
£ 19256000 |
0.3574 |
Revenue |
£ 5,38,76,000.00 |
||
2019 |
Gross profit |
£ 93,68,000.00 |
0.165212 |
Revenue |
£ 5,67,03,000.00 |
||
2020 |
Gross profit |
£ 83,72,000.00 |
0.16668 |
Revenue |
£ 5,02,28,000.00 |
Calculating net profit margin |
|||
Years |
Net profit margin |
Amount |
Ratio |
2018 |
Net profit |
£ 1,37,27,000.00 |
0.254789 |
Revenue |
£ 5,38,76,000.00 |
||
2019 |
Net profit |
£ 73,83,000.00 |
0.130205 |
Revenue |
£ 5,67,03,000.00 |
||
2020 |
Net profit |
£ 52,29,000.00 |
0.104105 |
Revenue |
£ 5,02,28,000.00 |
Calculating Debt to assets ratio |
|||
Years |
Debt to assets ratio |
Amount |
Ratio |
2018 |
Total liabilities |
£ 2,363,875,000.00 |
12.17056 |
Shareholders' equity |
£ 194,229,000.00 |
||
2019 |
Total liabilities |
£ 2,522,484,000.00 |
13.09239 |
Shareholders' equity |
£ 192,668,000.00 |
||
2020 |
Total liabilities |
£ 2,729,169,000.00 |
13.31334 |
Shareholders' equity |
£ 204,995,000.00 |
Calculating Interest cover ratio |
|||
Years |
Interest cover ratio |
Amount |
Ratio |
2018 |
Earnings before interest and taxes |
£ 19,890,000.00 |
12.67686 |
Total amount of interest expense |
£ 1,569,000.00 |
||
2019 |
Earnings before interest and taxes |
£ 13,347,000.00 |
8.39434 |
Total amount of interest expense |
£ 1,590,000.00 |
||
2020 |
Earnings before interest and taxes |
£ 8,777,000.00 |
6.921924 |
Total amount of interest expense |
£ 1,268,000.00 |