12. How to Combine Ratios to Analyse a Stock

Curated By
Santosh Pasi
Options Trader and Trainer, SEBI registered Research Analyst

Skill Sheet: What You Will Learn Here

  • Understanding various ratios used in fundamental analysis
  • Their importance and uses
  • Ratio analysis
  • How to use these ratios?

Ratio analysis is one of the most important tools for fundamental analysis as raw numbers do not reveal much.

Ratios analysis is a method to compare elements of the financial statements to understand their relationship. It is a diagnostic tool employed to understand the health and performance of a company. Ratio analysis helps in understanding the following:

  • Company’s growth
  • Meaning and quantity of sustainable profits 
  • Use of assets to efficiently generate revenue
  • Company’s liquidity position in the short and long terms
  • Company’s position to pay back debts and interests timely

Ratios have to be compared with previous years' ratios to understand the trends and also with peer companies to understand the status within a peer group. They can be broadly classified as:

  • Growth ratios
  • Profitability ratios
  • Liquidity ratios
  • Efficiency ratios
  • Solvency ratios


Growth ratios

These ratios compare various elements from the financial statements vis-à-vis the previous year or over time.

For example, comparing sales of the current year or past year to find out if sales or revenue has increased or decreased. This is measured in percentage. We can calculate growth for any item of the financial statements to understand its behaviour over the years.

Growth in sales in the below example is calculated as:

Formula: Current Year Sales/Previous Year Sale-1

i.e., ((17397-16350.2)/16350.2) =6.4%.

In the below table, you can see the trend for sales and profits for five years.

 

 

 
Consolidated Profit and Loss Account 0 1 2 3 4

(Rs Cr)

Mar 21

Mar 20

Mar 19

Mar 18

Mar 17

Net Sales

17397

16350.2

17548.84

14840.52

13180.04

Growth (%)

6.40%

-6.83%

18.25%

12.60%

11.24%

Gross Profit

5489.12

4792.41

4981

4288.37

4363.01

Growth (%)

14.54%

-3.79%

16.15%

-1.71%

0.93%

Operating profit (EBITDA)

2797.46

1938.72

1958.63

1651.26

1848.73

Growth (%)

44.29%

-1.02%

18.61%

-10.68%

-7.45%

EBIT

1482.51

800.6

1145.96

1058.71

1386.92

Growth (%)

85.17%

-30.14%

8.24%

-23.66%

-11.70%

PBT before extraordinary items

1168.93

543.45

1088.01

1012.33

1435.85

Growth (%)

115.09%

-50.05%

7.48%

-29.50%

-7.13%

PAT before extraordinary items

957.93

476.41

879.72

723.88

1099.3

Growth (%)

101.07%

-45.85%

21.53%

-34.15%

1.94%


A brief analysis:

The table above shows the company’s revenue or sales growing in double digits from March 2017 to March 2019. However, in March 2020, when the pandemic struck, the growth in sales fell by 6.83%. In March 2021, the company has again come back well, and revenue grew by 6.4%.

Similarly, on the profits front, the company has come back remarkably well post-pandemic, as can be seen from the above table.

Profitability or Margin Ratios

Profitability ratios measure the ability of a company to generate profits from its business activities. A company's profits can be seen at different levels like the gross profit level, operating level, profit before deducting depreciation interest and taxes (PBDIT), profit before interest and tax, profit before tax and profit after tax.

Profitability ratios compare profits at various levels with sales. It measures the percentage of profits the company generates after reducing the various costs at various stages.

Most of the profitability ratios are calculated from the profit and loss account statement. The denominator for calculating the profitability or margin ratios remains the same, that being sales or revenue.

Formula = Various profit/Sales

Profit levels and ratios

Gross margin ratio:

This measures the profit generated by a company after deducting from the sales the cost of goods sold. The cost of goods sold comprises all the direct costs attributable to bringing the goods to saleable form.

Formula: Gross profit/Sales

Consolidated Profit and Loss Account 0 1 2 3 4

(Rs Cr)

Mar 21

Mar 20

Mar 19

Mar 18

Mar 17

REVENUE

 

 

 

 

 

Net Sales

17397

16350.2

17548.84

14840.52

13180.04

EXPENSES:

 

 

 

 

 

Cost of Materials Consumed

7065.3

7049.83

8626.09

7390.65

6044.96

Purchases of Stock-in-Trade

2009.34

1834.11

1982.56

1152.3

1080.74

Changes in Inventories

319.87

191.65

-470.39

-147.45

-235.64

Employee Benefits Expenses

2513.37

2482.2

2429.58

2156.65

1926.97

Cost of goods sold

11907.88

11557.79

12567.84

10552.15

8817.03

Gross Profit

5489.12

4792.41

4981

4288.37

4363.01

Gross margin (%)

31.55%

29.31%

28.38%

28.90%

33.10%

A brief analysis:

The company has been maintaining a gross margin in the range of 28% to 33%. After stagnating at a range of 28% to 29%, the company, during March 2021, has improved its margin to a healthy 31.55%.

Operating margin (OPM):

It is one of the more crucial indicators in ratio analysis as it measures profits before finance costs, depreciation and amortisation and taxes are deducted. This ratio is referred to by many EBIDTA margins as depreciation and interest are not considered.

EBITDA is Earnings Before Interest, Taxes, Depreciation and Amortisation. OPM measures the operating profit to sales. Operating profit is calculated by deducting the cost of goods sold and other expenses related to selling and distribution and administration expenses from sales. One must note that other income is not part of the above-mentioned ratios.

Formula: Operating profit/Sales

Consolidated Profit and Loss Account 0 1 2 3 4 5

(Rs Cr)

Mar-21

Mar-20

Mar-19

Mar-18

Mar-17

Mar-16

REVENUE

 

 

 

 

 

 

Net Sales

17397

16350.2

17548.84

14840.52

13180.04

11848.56

Cost of goods sold

11907.88

11557.79

12567.84

10552.15

8817.03

7525.58

Gross Profit

5489.12

4792.41

4981

4288.37

4363.01

4322.98

Gross margin (%)

31.55%

29.31%

28.38%

28.90%

33.10%

36.49%

Other Expenses

2691.66

2853.69

3022.37

2637.11

2514.28

2325.52

Operating profit (EBIDTA)

2797.46

1938.72

1958.63

1651.26

1848.73

1997.46

Operating margin (%)

16.08%

11.86%

11.16%

11.13%

14.03%

16.86%

A brief analysis:

The company has been maintaining a healthy OPM. It has bounced back to over 16% after stagnating at over 11% from March 2018 to March 2020.

EBIT margin:

Earnings Before Interest and Taxes (EBIT) is similar to operating margin, but it is arrived at by deducting depreciation and amortisation.

Formula: EBIT/Sales

Consolidated Profit and Loss Account 0 1 2 3 4

(Rs Cr)

Mar 21

Mar 20

Mar 19

Mar 18

Mar 17

REVENUE

 

 

 

 

 

Net Sales

17397

16350.2

17548.84

14840.52

13180.04

Cost of goods sold

11907.88

11557.79

12567.84

10552.15

8817.03

Gross Profit

5489.12

4792.41

4981

4288.37

4363.01

Gross margin (%)

31.55%

29.31%

28.38%

28.90%

33.10%

Other Expenses

2691.66

2853.69

3022.37

2637.11

2514.28

Operating profit (EBITDA)

2797.46

1938.72

1958.63

1651.26

1848.73

Operating margin (%)

16.08%

11.86%

11.16%

11.13%

14.03%

Depreciation and Amortization Expenses

1314.95

1138.12

812.67

592.55

461.81

EBIT

1482.51

800.6

1145.96

1058.71

1386.92

EBIT margin (%)

8.52%

4.90%

6.53%

7.13%

10.52%

A brief analysis:

The company’s EBIT margin improved in March 2021 as compared to March 2020 from 4.9% to 8.52%. It has improved as compared to the past three years.

Net margin:

Net profit or profit after tax (PAT) is the final result of the company's operation. It is the net earnings after deducting all expenses from the total income. Net profit can vary from year to year due to many non-recurring expenses or non-recurring incomes. It is advisable to normalise the data for comparison over some time. Therefore, they should be excluded from all analytical calculations.

Formula: PAT/Sales

Consolidated Profit and Loss Account 0 1 2 3 4

(Rs Cr)

Mar 21

Mar 20

Mar 19

Mar 18

Mar 17

 REVENUE

 

 

 

 

 

Net Sales

17397

16350.2

17548.84

14840.52

13180.04

Cost of goods sold

11907.88

11557.79

12567.84

10552.15

8817.03

Gross Profit

5489.12

4792.41

4981

4288.37

4363.01

Gross margin (%)

31.55%

29.31%

28.38%

28.90%

33.10%

Other Expenses

2691.66

2853.69

3022.37

2637.11

2514.28

Operating profit (EBITDA)

2797.46

1938.72

1958.63

1651.26

1848.73

Operating margin (%)

16.08%

11.86%

11.16%

11.13%

14.03%

PBDIT

2797.46

1938.72

1958.63

1651.26

1848.73

PBDIT margin (%)

16.08%

11.86%

11.16%

11.13%

14.03%

Depreciation and Amortization Expenses

1314.95

1138.12

812.67

592.55

461.81

EBIT

1482.51

800.6

1145.96

1058.71

1386.92

EBIT margin (%)

8.52%

4.90%

6.53%

7.13%

10.52%

Finance Costs

442.96

280.83

181.07

162.92

102.88

Add: Other Income

129.38

23.68

123.12

116.54

151.81

PBT before extraordinary items

1168.93

543.45

1088.01

1012.33

1435.85

PBT margin (%)

6.72%

3.32%

6.20%

6.82%

10.89%

Tax Expenses

211

67.04

208.29

288.45

336.55

PAT before extraordinary items

957.93

476.41

879.72

723.88

1099.3

PAT margin (%)

5.51%

2.91%

5.01%

4.88%

8.34%

A brief analysis:

The PAT margins improved remarkably well in March 2021 as compared to March 2020. PAT margins bettered the pre-pandemic levels in March 2021.

Shareholder’s return ratios

Return ratios measure the profits attributable to the common shareholders, known as return on equity or return on net worth. It also measures the return attributable to the capital employed in the business. Meaning the return that a company generates on both equity and borrowings that have been applied to the business.

Return on Net Worth (RoE):

Net profit after tax and preference dividends/Average net worth (average total shareholder’s fund)

 

0 1 2 3 4

(Rs Cr)

Mar 21

Mar 20

Mar 19

Mar 18

Mar 17

PAT before extraordinary items

957.93

476.41

879.72

723.88

1099.3

Shareholder's Funds

 

 

 

 

 

Share Capital

63.51

57.21

57.21

57.21

50.9

Ordinary Capital

63.51

57.2

57.2

57.2

50.9

Reserves and Surplus

9409.05

7634.94

7583.96

7203.41

5280.29

Money received against Share Warrants

0

0

0

0

0

Total Shareholder's Fund

9472.56

7692.15

7641.16

7260.61

5331.19

Average of Shareholder's Fund

8582.36

7666.66

7450.89

6295.90

4994.51

Return on net worth (%)

11.16%

6.21%

11.81%

11.50%

22.01%

Average shareholder's fund= (Current year total SH fund + Previous year total SH)/2

A brief analysis:

The return on net worth has come back to pre-pandemic levels, but it is still far away from the March 2017 return of 22%. Further, the company has increased its equity, and there is an addition to the reserves due to the share premium resulting in lower returns.

Return on net capital employed (RoCE):

EBIT/Average Capital employed (average total assets minus average current liabilities).

Here we take EBIT as the profit since capital employed is used.


(Rs Cr)
Mar 21 Mar 20 Mar 19 Mar 18 Mar 17
EBIT 1482.51 800.6 1145.96 1058.71 1386.92

Total Assets

19163.45

16481.99

13648.94

13142.58

9876.01

Total Current Liabilities

4328.9

4092.48

2649.1

3071.67

2876.2

Capital employed

14834.55

12389.51

10999.84

10070.91

6999.81

Average capital employed

13612.03

11694.68

10535.38

8535.36

6220.27

Return on capital employed (RoCE)

10.89%

6.85%

10.88%

12.40%

22.30%

A brief analysis:

The return on capital employed improved in March 2021 as compared to March 2020. An increase in total assets has led to a decrease in RoCE. The RoCE is far away from the 22.3% seen in March 2017.

Dupont Analysis

Dupont analysis is nothing but RoE, i.e., return on equity calculated in an elaborate method. Dupont conveys the causes of an increase or decrease in RoE by analysing connected ratios.

There are three important areas of business - profitability, efficiency (use of assets to generate sales) and leverage (external funds to buy assets).

  • Profitability is measured by Net profit/Sales
  • Asset efficiency by Asset turnover ratio (sales)/Total assets
  • Leverage by Total assets/Shareholder’s fund
    The product of these three ratios will give the RoE.

Dupont RoE
= Net margin X asset turnover X financial leverage
= net profit/sales X sales/total assets X total assets/shareholder’s fund


Dupont RoE analysis

 

 

 

 

 

Net Sales

17397

16350.2

17548.84

14840.52

13180.04

PAT before extraordinary items

957.93

476.41

879.72

723.88

1099.3

Average total assets

17822.72

15065.47

13395.76

11509.3

8697.78

Average of Shareholder's Fund

8582.36

7666.66

7450.89

6295.90

4994.51

Net margin %

5.51%

2.91%

5.01%

4.88%

8.34%

Asset turnover

97.61%

108.53%

131.00%

128.94%

151.53%

Leverage (Average total assets/Average shareholder’s fund)

208%

197%

180%

183%

174%

Dupont RoE

11.16%

6.21%

11.81%

11.50%

22.01%

All Modules