Performance analysis through financial modeling

G. Naveen Kumar1, Podapala Siva Reddy1* and Mulupur Sai Rama Krishna2

*Correspondence:
Podapala Siva Reddy,
siva.podapala@gmail.com

Received: 28 February 2022; Accepted: 22 March 2022; Published: 02 April 2022.

Finance is the lifeblood and lifeline of any business entity, either commercial or non-commercial. The survival, stability, and sustainability of a firm are highly associated with its financial wellness. It can be observed through its ability to pay(re) short-term as well as long-term liabilities, meet the regular financial obligations, and increase the value of the firm and generate profit. Financial analysis, evaluation, and assessment help in determining the financial position and financial strength of a firm. Among the plenty of methods and tools available for financial performance, ratio analysis is more useful and meaningful. These ratios can be used to assess the evolution of a company’s financial status (trend analysis), as well as for cross-sectional and comparative studies.

Keywords: Financial modeling, Performance analysis, Financial performance, Financial ratios, Forecasting, Scenario analysis

Introduction

This study presents the market competitiveness of four retail giants in the UK, such as Tesco PLC, Sainsbury’s, ALDI, and Lidl with the help of ratios. This study analyses the different study concepts that are related to the establishment of financial stability. The financial position can be evaluated with the help of ratio analysis as well as Du-Point analysis. In addition, the study has also mentioned various financial condition analysis methods to have an understanding of financial ratios. Financial performance analysis holds a significant role in terms of understanding the financial health of the company. The financial records derived from the analysis help the investors to understand the economic conditions of the company, which leads to financial and reputational growth of the company.

Objectives of the study

The main research objectives are:

• To study the financial performance of selected companies by assessing their past performances, revenue, and projected future performance.

• To analyze the financial performance of the companies to determine the financial health of these companies.

• To evaluate the competitive advantages and economic viability of the companies with the help of the ratio analysis framework.

• To recommend appropriate strategies that can improve the financial performance of the selected company in this research.

Ratios: the theoretical framework

The organizing of information pertinent to a choice area has become the major duty of the decision maker in this digital and information era (1). The world is now more complex, uncertain, and dynamic, not because of a lack of information but because there is too much information. In real-life settings, the quality of a choice is frequently shown to be inversely proportional to the amount of information available (2). A business system continuously generates data. A successful management control system must generate relevant, understandable data and identify crucial management variables (3).

A correctly chosen ratio or combination of ratios can not only help with primary decision-making, but can also be used as a powerful monitoring tool (4). Among the many approaches used for data processing, data processing by ratio methods can extract the most information content if the factors that make up a proportion are appropriately chosen. The simplicity and directness of ratios attracted the minds of great analytical thinkers during not only modern times, but even in ancient times too (5).

A ratio is a numeric figure that reveals the association or relationship between two variables. Financial ratios are calculated to establish a meaningful link between two financial statements, and the results are then evaluated to draw significant conclusions. The numerator and denominator must be rationally connected, which is the most important component of the computation. Otherwise, the ratio will not give the information required for decision-making. As a result, financial statement analysis is given as a pro forma examination of the future, with anticipated ratios (6).

The ratios used in the study are listed below.

Current ratio

The current ratio expresses the relationship between a company’s current assets and current liabilities. The current ratio is a static measure of the resources available to satisfy current obligations at a given moment in time. The existing reservoir of financial resources has no logical or physical relationship to its future cash flows (7).

Quick ratio

A stringent test of liquidity can be expressed by quick ratio (acid test ratio). Inventories of the least liquid current assets are excluded, and our methodology must weigh the benefits of eliminating inventories when evaluating liquidity (8).

Gross margin ratio

It is calculated as revenue less cost of sales and directs special attention to the factors explaining variations in sales and cost of sales. The gross profit must be big enough to support necessary future-directed discretionary expenditures (9).

Net margin ratio

This ratio expresses the relationship between total revenue and its net profits. The net profit margin ratio is used to indicate a company’s potential to generate profit while taking into account various circumstances, such as an increase in costs that is judged ineffective. Net profit margin, which is commonly expressed as a percentage, is a powerful measure of a company’s overall success.

Literature review

Renáta et al made a study on “Comprehensive assessment of firm financial performance using financial ratios and linguistic analysis of annual reports.” According to the study’s findings, businesses with strong financial outcomes not only orally communicate the attained values of financial indicators, but also comment on the sources of the results in more depth. This appears to be true for both good and negative consequences (10). The primary goal of financial statement analysis (ratio analysis) is to use information about a company’s previous performance to forecast how it will perform in the future (11).

Barnes (12) explained the application and importance of ratios in brief. They measured the performance of a firm and use it as a tool to measure and predict financial position. The ratios are used for both credit and managerial analysis purposes and also for measuring the profitability of various business entities.

Warui (13) analyzed the credit risk management strategies and the performance of commercial banks in Kenya. He adopted the credit risk theory and found that credit risk is among the critical factors for any financial institution involved in any lending activity. The study added that financial institutions have to find themselves in making decision on giving credit to potential borrowers, despite effectively growing their balance sheets and effectively increasing their returns and cautions to any losses incurred.

Methodology

The study is based on pure secondary data, including financial statements of selected companies, i.e., Tesco PLC, Sainsbury’s, Aldi, and Lidl. As part of the analysis, the researcher focused on liquidity position (current ratio and quick ratio) and consistency (gross margin ratio and net margin ratio). The ratios of the selected four companies are presented and discussed as follows.

Analysis of the data

The performance of any business entity can be measured with money in a business tycoon. A firm will be considered strong if it has sufficient financial reserves, funds, and liquidity. At the same time, their performance also depends on some other variables like assets (both fixed and current), liabilities, sales revenue, expenses, and cost of goods sold. The researcher considers these variables for the study and presented here.

In this study, a total of four financial ratios are calculated: current ratio, quick ratio, gross margin ratio, and net margin ratio. According to the above ratio analysis spreadsheet (Table 1), it is observed that Tesco PLC faces fundamental business losses in the 2020 financial year due to the COVID-19 pandemic. As per the overview of this organization, Tesco PLC faces around a 4.9% reduction in operating profit (2021).1 Moreover, from the financial data of this organization, it is also identified that the organization experiences around 0.7% reduction in the annual sales volume.

TABLE 1
www.bohrpub.com

Table 1. Ratio analysis of Tesco PLC.

Sainsbury’s

According to the detailed ratio analysis of the mentioned organization, it is observed that Sainsbury’s also faces huge business losses in the 2020 financial year due to the pandemic.

The figure in Table 2 represents the financial overview of Sainsbury’s over the six financial years. As per the annual report of this organization, Sainsbury’s also experiences significant business losses in the 2021 financial year due to the business losses in 2020, and it reduces the overall sales volume of this enterprise by 0.3% (2021).2 However, while comparing those financial statements with Tesco PLC, it can be considered that Sainsbury’s faces minimal business losses from the financial perspective compared with Tesco PLC.

TABLE 2
www.bohrpub.com

Table 2. Ratio analysis of Sainsbury’s.

Aldi

For Aldi organization, we consider the financial data from the years 2016 to 2021.

According to Table 3, it is observed that Aldi faces huge losses after the 2018 financial year due to inappropriate operational processes. As per the current information, it is also identified that the organization faces a significant reduction in annual profit margin that is reduced by 11.28% in the gross profit margin of the 2018 financial year compared with the previous year (2021).3 In this regard, it can be considered that Sainsbury’s and Tesco PLC are in better financial conditions compared with this enterprise from the perspective of competitive advantages.

TABLE 3
www.bohrpub.com

Table 3. Ratio analysis of Aldi.

Lidl

According to this total ratio analysis of Lidl organization, it is seen that Lidl also got major losses from the year of 2020 years due to the COVID-19 outbreak and post-COVID-19 situation.

From Table 4, it is seen that Lidl was improving its businesses before the situation of the COVID-19 pandemic. After COVID-19, this organization is facing a huge loss in their business that may pose a huge challenge to continuing their business as their liabilities may be increased. In 2019, they get their maximum market share that is almost 10% in the UK; however, it has been reduced after the COVID-19 pandemic.

TABLE 4
www.bohrpub.com

Table 4. Ratio analysis of Lidl.

Results and discussion

It is observed that Tesco PLC faces fundamental business losses in the 2020 financial year due to the COVID-19 pandemic. Sainsbury’s also experiences significant business losses in the 2021 financial year due to the business losses in 2020, and it reduces the overall sales volume of this enterprise by 0.3% (see footnote text 2, 2021). Aldi faces huge losses after the 2018 financial year due to inappropriate operational processes, and even Lidl also performed along the same lines with huge losses.

Footnotes

  1. ^ http://www.tescoplc.com/
  2. ^ http://www.sainsburys.co.uk/
  3. ^ http://www.craft.co/

References

1. World Bank Development Report.Data for Better Lives. Washington DC: World Bank (2021).

Google Scholar

2. Financing India’s MSMEs.Estimation of Debt Requirement of MSMEs in India, IFC Report. Washington, DC: IFC (2018).

Google Scholar

3. SME Competitiveness Outlook.COVID 19: The Great Lockdown and its Impact on Small Business. Geneva: International Trade Centre (2020).

Google Scholar

4. Stein P, Goland T, Schiff R. Two Trillion and Counting: Assessing the Credit Gap for Micro, Small, and Medium-size Enterprises in the Developing World, McKinsey USA. Washington, DC: IFC (2010).

Google Scholar

5. Hrishikesh. (2015)

Google Scholar

6. Nissim D, Penman SH. Ratio analysis and equity valuation: from research to practice. Rev Account Stud. (2001) 6:109–54.

Google Scholar

7. Altman EI. Financial ratios, discriminant analysis and the prediction of corporate bankruptcy. J Finance. (1968) 23:589–609.

Google Scholar

8. Tracy JA. How to Read a Financial Report: Wringing Vital Signs Out of the Numbers. New York, NY: John Wiley and Sons (2004). 173 p.

Google Scholar

9. Farris PW, Bendle NT, Pfeifer PE, Reibstein DJ. Marketing Metrics: The Definitive Guide to Measuring Marketing Performance. Upper Saddle River, NJ: Pearson Education, Inc (2010). p. 88–96.

Google Scholar

10. Renata et al. (2017)

Google Scholar

11. Hasanaj P, Kuqi B. Analysis of financial statements: the importance of financial indicators in enterprise. Hum Soc Sci Res. (2019) 2:17–27.

Google Scholar

12. Barnes P. The analysis and use of ratios: a review article. J Bus Fin Account. (2006) 14:449–61.

Google Scholar

13. Warui. (2017)

Google Scholar

14. Altman EI, Iwanicz-Drozdowska M, Laitinen EK, Suvas A. Financial distress prediction in an international context: a review and empirical analysis of Altman’s Z-score model. J Int Finan Manage Account. (2017) 28:131–71.

Google Scholar

15. MacCarthy J. Using Altman Z-score and Beneish M-score models to detect financial fraud and corporate failure: a case study of Enron Corporation. Int J Fin Account. (2017) 6:159–66.

Google Scholar