Analysis of the balance sheet structure (vertical and horizontal analysis)


Formation of indicators for analyzing the organization’s balance sheet

The balance sheet is the main reporting document of any organization.
The composition of its indicators may vary from company to company, but the analysis is based on general principles and methods. ATTENTION! From 2021, financial statements will be submitted exclusively in electronic form. Paper forms will no longer be accepted. Read more about changes to the rules for presenting financial statements here. We also remind you that in 2021 the reporting forms have been updated.

Analysis of the balance sheet is of practical importance if it is based on reliable information. To avoid its distortions (accidental or intentional), the enterprise must have an internal control system (Article 19 of the Law “On Accounting” dated December 6, 2011 No. 402-FZ). And to externally confirm the reliability of the balance sheet, an audit is used (clause 3 of the Law “On Auditing” dated December 30, 2008 No. 307-FZ). In some cases this is mandatory (Article 5 of Law No. 307-FZ). The list of companies subject to mandatory reporting audit can be found on the website of the Russian Ministry of Finance.

All mandatory accounting reports must meet the requirements for them: comparability, consistency, etc.

Look at a sample balance sheet prepared by ConsultantPlus experts. Get trial access to the system and proceed to the material. It's free.

For more information about what requirements the balance sheet must meet, see the material “What requirements must accounting records satisfy?

Let's consider the main stages of the analysis of the balance sheet.

The number of hours spent does not equal success.

Co-founder and director of Strategic Nudge Christine Baker believes that spending time is not the same as achieving a goal:

“You work until you reach your goal—whether it's your first product launch, your first sale, your first year of $100,000 in sales, or anything like that. If it takes 20 or 70 hours a week, so be it. Of course, you will still have to factor in all your other responsibilities in the day - business, family, and perhaps part-time work in order to maintain income during the most difficult first months or years of your business, time for hobbies."

Maggie Patterson, founder of Small Business Boss, has experienced both 20-hour and 80-hour work weeks in her life:

“The essence of entrepreneurship is that you can control how many hours you need to work to grow your business.”

Analysis of the balance sheet using an example: preliminary stage

Let's consider an example of analyzing the balance sheet of an enterprise. The balance sheet of Sekunda LLC as of December 31, 2020 is as follows:

Indicator name Code As of 12/31/2020 As of 12/31/2019 As of 12/31/2018
ASSETS
Fixed assets 1150 320 250 200
Reserves 1210 205 160 115
Accounts receivable 1230 170 190 160
Financial investments (excluding cash equivalents) 1240 50 50
Cash and cash equivalents 1250 120 210 25
BALANCE 1600 865 860 500
PASSIVE
Authorized capital 1310 10 10 10
retained earnings 1370 385 210 85
Accounts payable 1520 470 640 405
BALANCE 1700 865 860 500

The first reading of this report can be called introductory: the balance sheet figures assess the general structure of property and liabilities, the availability of raised funds, etc.

In this case, we are dealing with a developing company: an annual increase in the balance sheet currency, the appearance of financial investments in the asset structure, an increase in the cost of fixed assets (which may indicate the company’s intentions to invest in the development of its production potential), a steady decrease in debts - and all this without attracting long-term borrowed funds.

Preliminary conclusions have been made and we can proceed to a more detailed analysis. To do this, we will conduct a horizontal and vertical analysis of the balance sheet.

Application in the analysis process

Very often, when conducting financial analysis and calculating ratios, important initial information is the state of the company’s current assets and their individual elements. During the research process, attention is paid specifically to the study of current assets: their dynamics and structure.

There are two options for conducting analytics: horizontal and vertical methods. When analyzing the financial condition of an enterprise, both of these methods are used equally often.

Horizontal analysis of the balance sheet

Using horizontal analysis, we compare the balance sheet indicators by reporting dates (to simplify the example, we use data at the beginning and end of the reporting period):

Balance sheet item As of 12/31/2020 As of 12/31/2019 Deviation (+/–)
sum %
Property dynamics
Including: non-current (OS) 320 250 +70 +28,00
negotiable 545 610 –65 –10,65
Reserves 205 160 +45 +28,13
Accounts receivable 170 190 -20 –10,53
Financial investments (excluding cash equivalents) 50 50
Cash and cash equivalents 120 210 -90 –42,86
Capital dynamics
Including: equity 395 220 +175 +79,55
Authorized capital 10 10
retained earnings 385 210 +175 83,33
borrowed capital 470 640 –170 –26,56
Sources of funds in calculations

(accounts payable)

470 640 –170 –26,56

A horizontal analysis of the balance sheet showed the following: during the reporting period, non-current assets increased by 28%, which may indicate the expansion of activities and growth of the company’s economic potential. At the same time, working capital decreased (by 10.65%) - mainly due to a decrease in cash balances (by 42.86%). There was an increase in working capital in inventories by 28.13%, which indicates a decrease in liquidity and may affect the solvency of the company. The presence of short-term financial investments in the current assets indicates a desire to invest funds in order to obtain additional profit. The growth of the balance sheet currency must also be compared with the rate of inflation and revenue growth.

If you have access to ConsultantPlus, find out how to assess the solvency of a counterparty based on the balance sheet. If you don't have access, get a free trial of online legal access.

The essence of balance sheet indicators

Financial indicators of the balance sheet are determined by analyzing the financial statements.
Analysis of financial statements consists of analysis of all its forms, including explanatory notes and the final part of the auditor’s report. When carrying out a preliminary analysis of financial statements, the dynamics of two types of sick reporting items are identified and assessed:

  1. which indicate the extremely unsatisfactory position of the enterprise in the reporting period. This is reflected in a poor financial position, represented by uncovered losses, overdue loans and borrowings and accounts payable.
  2. which indicate certain regularly recurring shortcomings in the company’s work, recorded in the financial statements for several adjacent periods. They include overdue accounts receivable, debt that is written off to financial results, collected fines, penalties and interest.

The balance sheet analysis is carried out in accordance with the balance sheet or aggregated analytical balance sheet. When analyzing, it is advisable to determine the growth rate of the most significant items or group of items by comparing the results obtained with the growth rate of sales revenue.

Too lazy to read?

Ask a question to the experts and get an answer within 15 minutes!

Ask a Question

Note 1

The most important area is the vertical analysis of the balance sheet, during which the share and structural dynamics of individual groups and items of assets and liabilities of the balance sheet are assessed.

Determination of the structure of articles (vertical analysis) and the share of indicators

Using this type of balance sheet analysis, we examine the structure of indicators over time:

Balance sheet item As of 12/31/2020 As of 12/31/2019 Shifts in structure, %
sum % to total sum % to total
Property structure
Including: non-current assets (OC) 320 36,99 250 29,07 +7,92
current assets 545 63,01 610 70,93 –7,92
Reserves 205 37,61 160 26,23 +11,38
Accounts receivable 170 31,20 190 31,15 +0,05
Financial investments (excluding cash equivalents) 50 9,17 50 9,17
Cash and cash equivalents 120 22,02 210 34,43 -12,41
Capital structure
Including: equity 395 45,66 220 25,58 +2,02
borrowed capital 470 54,36 640 74,42

A vertical analysis of the balance sheet showed that during the reporting period there were no significant changes in the overall structure of property and capital.

The growth of non-current assets amounted to 7.92%. In the structure of current assets, small structural changes are observed in the lines “Cash and cash equivalents” (12.41%) and inventories (11.38%). An increase in working capital in inventories reduces their turnover, which may negatively affect current liquidity. The share of equity in the balance sheet currency amounted to 45.66% at the end of the period, mainly due to the share of retained earnings in equity (97.47%). There are no uncovered losses on the balance sheet.

The company does without long-term loans and borrowings, that is, the volume and structure of equity capital allows it to organize the production process and develop without external borrowings.

Example of a balance sheet and its analysis

Let's consider the comparative analytical balance using the example of conditional trading. For clarity, we present it in the table below.

Example of reporting of Orion LLC for 2015-2017. All indicators are presented in rubles.

Assets/Balance Sheet 2015 2016 2017 Dynamics of indicators Indicator growth rate (%)
1. Non-current assets 140376 131383 204096 63720 145,4
2. Current assets 505047 991666 1221270 716223 241,8
2.1. Reserves 42801 50339 52420 9619 122,5
2.2. Accounts receivable 61984 743478 769202 707218 1241,0
2.3. Cash and financial investments 400093 197673 399422 -671 99,8
2.4. Others 169 176 226 57 133,7
TOTAL balance 645423 1123049 1425366 779943 220,8
LIABILITIES
3. Own capital 551026 718786 519694 -31332 94,3
4. Long-term liabilities 9028 308210 506842 497814 5614,1
5. Current liabilities 85369 96053 398830 313461 467,2
5.1. Loan obligations
5.2. Accounts payable 85369 96053 398830 313461 467,2
TOTAL balance 645423 1123049 1425366 779943 220,8

Data from a horizontal analysis of the balance sheet allow us to conclude that in 2021 there was an increase in the total amount of the company’s assets by 779,943 thousand rubles, mainly due to an increase in the value of non-current assets by 63,720 thousand rubles, as well as growth of current assets by 716,223 thousand rubles. The increase in the amount of working capital was ensured by an increase in the value of long-term liabilities by 497,814 thousand rubles, as well as short-term liabilities by 313,461 thousand rubles.

At the next stage, we will consider the application of the methodology for vertical analysis of the company’s analytical balance sheet in the table below.

Vertical methodology as applied to Orion LLC for 2015-2017. (%)

Balance sheet item 2015 2016 2017 Dynamics of indicators over a period of time
ASSETS
1. Non-current assets 21,7 11,7 14,3 -7,4
2. Current assets 78,3 88,3 85,7 7,4
2.1. Reserves 6,6 4,5 3,7 -3,0
2.2. Accounts receivable 9,6 66,2 54,0 44,4
2.3. Cash and financial investments 62,0 17,6 28,0 -34,0
2.4. Others
TOTAL balance 100,0 100,0 100,0 0,0
LIABILITIES
3. Own capital 85,4 64,0 36,5 -48,9
4. Long-term liabilities 1,4 27,4 35,6 34,2
5. Current liabilities 13,2 8,6 28,0 14,8
5.1. Loan obligations
5.2. Accounts payable 13,2 8,6 28,0 14,8
TOTAL balance 100,0 100,0 100,0

As can be seen from the table, in the structure of the analytical balance sheet the share of current assets is maximum. In addition, there is a noticeable upward trend in this share by 7.4% by 2021. Accordingly, the share of non-current assets by 2021 is reduced by 7.4%. The liability structure of the balance sheet contains the maximum share of equity capital. By 2021, it is sharply reduced by 48.9%, which negatively affects the structure of the balance sheet. The share of long-term liabilities by 2021 is growing by 34.2%, and short-term liabilities by 14.8%.

The positive results of the assessment of the consolidated analytical balance are the following trends:

  1. Growth in the value of the balance sheet currency in 2021.
  2. The growth rate of current assets (241.8%) exceeds the growth rate of non-current assets (145.4%).
  3. The organization’s own capital is more than 50%, but only in 2015 and 2016.

However, the presented form of analytical balance also has negative characteristics:

  • The organization's equity in 2021 is below 50%.
  • The growth rate of long-term liabilities (5614%) and short-term liabilities (467%) exceeds the growth rate of equity capital (94%).
  • The growth rates of accounts receivable (1241%) and accounts payable (467.2%) differ significantly.

However, the presented analytical balance sheet and its example do not provide complete information for the investor about the effectiveness when studying the financial situation. They only allow you to assess the current state and dynamics of the company's assets and liabilities.

Analyzing the Balance Sheet Using Financial Ratios

By calculating special coefficients, further analysis of the balance sheet is carried out:

Solvency analysis

Coefficient Calculation Recommended Range
Formula Sum
Financial dependency ratio.

Read more about the coefficient in the article “Financial dependence coefficient (balance sheet formula)”

Balance sheet currency / equity 865 / 395 = 2,2 ≤2,0
Financial independence ratio.

Read more about the coefficient in the article “Financial independence coefficient (formula)”

Own capital / balance sheet currency 395 / 865 = 0,46 ≥0,5
Total Solvency Ratio Balance sheet currency / borrowed capital 865 / 470 = 1,84 ≥1,0
Debt ratio Debt capital/equity 470 / 395 = 1,19 ≤1,0

Liquidity analysis

Coefficient Calculation Recommended Range
Formula Sum
Instant liquidity ratio (DS and DE)*/ KO*** 120 / 470 = 0,26 >0,8
Absolute liquidity ratio (DS and DE + KFV**) / KO (120+50) / 470 = 0,36 >0,2
Quick ratio (DS and DE + KFV + DZ) / KO (120 + 50 + 170) / 470 = 0,72 ≥1,0
Average liquidity ratio (DS and DE + KFV + DZ + Reserves) / KO (120 + 50 + 170 + 205) / 470 = 1,16 >2,0
Intermediate liquidity ratio (DS and DE + KFV + DZ + Inventories + VAT) / KO (120 + 50 + 170 + 205) / 470 = 1,16 ≥1,0
Current ratio Current assets / KO 545 / 470 = 1,16 1,5–2,0

* (DS and DE) - cash and cash equivalents.

** KFV - short-term financial. attachments.

*** KO - short-term liabilities.

For more information about liquidity ratios, read the article “Calculation of the liquidity ratio (balance sheet formula)” .

An analysis of the balance sheet using financial ratios showed that solvency indicators are close to the recommended ones. However, the instant, quick and current liquidity ratios show the insufficiency of working capital to repay short-term liabilities at the reporting date.

In addition, it is necessary to calculate financial stability coefficients (autonomy, agility, etc.).

Our articles will help you do this:

  • “What does the autonomy coefficient show - the balance formula?”;
  • “Agility coefficient (balance sheet formula)” and other materials in the “Analysis of Economic Activity (ABA)” .

Trend, factor and comparative analysis

In addition to the above stages of balance sheet analysis, trend, factor and comparative types of analysis can be carried out. They will complement and expand the volume of analytical data for making the necessary economic decisions.

Thanks to trend analysis, you can form an opinion about the main trend of changes in certain indicators (predictive analysis).

For example, a joint study of the dynamics of short-term debt and cash:

Balance indicator As of 12/31/2018 As of 12/31/2019 As of 12/31/2020
Accounts payable 405 640 470
Cash and cash equivalents 25 210 120

From the above figures it follows that, as of reporting dates, the nature of changes in the amount of short-term debts corresponds to changes in the volume of cash, but the company’s free cash is not enough to repay these debts.

Using factor analysis, the nature of the influence of the main factors on the change in the value of the indicator under study is determined. It is carried out according to a certain method of analyzing the balance sheet.

To carry out a comparative analysis, additional information is needed - the balance sheet data of one company is not enough. This is due to the fact that when carrying out this type of analysis, the balance sheet indicators of different companies are compared in order to determine their rating.

Specifics of analyzing the balance sheet of individual companies using the example of a bank balance sheet (Form 1)

Banks, although they are commercial companies and are created to make a profit, have specific features. They are subject to special legislation, maintain a special chart of accounts and build a different methodology for accounting processes.

At the same time, the main approaches to analyzing a bank’s balance sheet are in many ways similar to analyzing the balance sheet of an ordinary commercial company. For the bank balance sheet, the main stages of analysis also remain relevant:

  • preliminary (reading the balance sheet, structuring its items, etc.),
  • analytical (description of calculated indicators of structure, dynamics, relationship between balance sheet indicators);
  • final (evaluation of analysis results).

In the process of analyzing the bank’s balance sheet, special coefficients are also calculated, but their types differ from those discussed earlier:

  • bank reliability coefficient (capital adequacy ratio),
  • return on assets ratio (shows the efficiency of using assets and quality based on their profitability),
  • leverage ratio (interbank loans), etc.

To learn how banks analyze the creditworthiness of their clients, read the material “Methods for assessing the creditworthiness of commercial bank clients.”

What are the consequences of lack of rest?

An employee of the Microsoft venture fund, Makand Mohan, believes that a businessman should not have a balance between work and personal life:

“Almost every entrepreneur will tell you that they work a lot. This is par for the course. Those who are older (after 35 years, usually) will insist on their ability to manage time between work and personal life. In fact, this is impossible in a startup. If you have such a balance, then you are not taking your business seriously enough.”

Perhaps the fact is that successful entrepreneurs are people who love their business and really enjoy devoting all their time to it. However, lack of proper rest and too long working hours have a negative impact on concentration, attention and work performance, as well as on mood and family relationships.

Research shows that excessive workaholism can negatively impact productivity and health. While famous entrepreneurs motivate us to work 60 to 100 hours a week, science doesn't agree. There is no right answer to how many hours you should work. It is important to monitor your physical and mental state, and not try to copy other people's behavior patterns.

Lack of breaks and overwork threaten to reduce concentration. Even targeted short breaks from work, such as a 15-minute coffee break every two hours, can seriously help attention and concentration. Another way to work more concentratedly is the Pomodoro Method.

Online program to facilitate the analysis process

Modern information processing tools can significantly simplify the process of comprehensive analysis of the balance sheet. Calculations are carried out both using standard computer programs (for example, using Excel, where you can carry out calculations, create tables and charts), and using specialized programs that allow you to conduct financial analysis online - via the Internet.

The use of specialized software not only saves time, but also significantly expands the types of analysis. They allow you to analyze market stability, business activity, score assessment of financial stability, etc. In addition, developers of specialized programs provide the possibility of adapting and changing the program depending on the goals and objectives of the analysis, taking into account the specifics of a particular enterprise.

Results

Analysis of balance sheet indicators is a voluminous and multi-stage process. Its results make it possible to identify potential risks, develop the financial policy of the enterprise and contribute to effective management decisions. The analysis process can be facilitated by using specialized programs.

Sources:

  • Federal Law of December 6, 2011 No. 402-FZ
  • Federal Law of December 30, 2008 No. 307-FZ

You can find more complete information on the topic in ConsultantPlus. Free trial access to the system for 2 days.

Rating
( 1 rating, average 5 out of 5 )
Did you like the article? Share with friends:
For any suggestions regarding the site: [email protected]
Для любых предложений по сайту: [email protected]