All about Combined Ratios
Financial ratio analysis is one of the most important tools for fundamental analysis as raw numbers do not reveal much.
Financial ratios help compare elements of the financial statements to understand their relationship. They are 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
Financial 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 financial 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% |
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 financial 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% |
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% |
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% |
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% |
Points to remember:
- Growth ratios can help in comparing various financial aspects from different periods of time to measure growth.
- Profitability ratios help in measuring the company’s ability to generate profits.
- An investor’s return on equity can be measured through Dupont analysis.