Case Studies and Management Resources
 Asia's Most Popular Collection of Management Case Studies

Case Studies | Case Study in Business, Management, Operations, Strategy, Case Studies

Quick Search


www ICMR


Search

 

A NOTE ON FINANCIAL RATIO ANALYSIS

            

ICMR India ICMR India ICMR India ICMR India RSS Feed

 

<<Previous

Calculation of Gross Margin for HLL:

 1997

 1998

 1999

 2000

 2001

Gross profit/Net Sales * 100

 928.8 / 7736.75

 1229.4/ 9426.13

 1543.1/ 10116.45

 1826.8/ 10588.18

 2195.13/ 10941.11

Gross margin

 12

 13.04

 15.25

 17.25

 20.06


The gross margin has been increasing steadily since 1997. The reasons for this increase can be:

  • Higher sales prices but cost of goods sold remaining constant.

  • Lower cost of goods sold, sales prices remaining constant.

  • A combination of changes in sales prices and costs, widening the margin between them.

The high gross margin reported by HLL reflects the company's ability to maintain a low cost of production.

Net Profit Margin

Calculation of net profit margin for HLL:

 1997

 1998

 1999

 2000

 2001

Net Profit/Net Sales ´ 100

 567.1 / 7736.75

 806.2 / 9426.13

 1074.1/ 10116.45

 1327.8/ 10588.18

 1640.31/ 10941.11

Net Margin

 7.32

 8.55

 10.61

 12.54

 14.99

The net profit margin of HLL has increased significantly. The high net profit margin implies higher returns to shareholders in the form of dividends and stock price appreciation.

Investment Turnover Ratio

Calculation of investment turnover for HLL:  

 1997

 1998

 1999

 2000

 2001

Value of production/ Average total assets

 7783.15/ 3208.9

 9418.23/ 3965.85

 10244.97/ 476382

 10504.23/ 5465.9

 10936.48/ 6280.78

Investment Turnover

 2.425

 2.375

 2.15

 1.921

 1.741

The investment turnover ratio measures the relationship between the value of production and average total assets. This ratio measures the asset utilization efficiency of a firm. In the case of HLL, the investment turnover shows a downward trend. This trend can be attributed to the increasing underutilization of the firm's available production capacity.

Debt-Equity Ratio

Calculation of debt-equity ratio for HLL:

 1997

 1998

 1999

 2000

 2001

Debt/Networth

 186.4/1261.2

 264.31/1713.03

 177.2/2102.5

 111.5/2488

 83.73/3043.69

Debt-equity Ratio

 0.148

 0.154

 0.084

 0.045

 0.028

The debt-equity ratio of HLL shows a downward trend. This implies that the company is relying more on its owner's equity to finance its assets rather than on borrowed funds. Though the firm is using relatively less proportion of debt, the returns on equity investments have been profitable. This can be explained by calculating the average rate of return earned on the capital employed in assets and comparing that rate with the average interest rate paid for borrowed funds.

Calculation of rate of return on capital employed:
 

 

 1997

 1998

 1999

 2000

 2001

Borrowed funds

 186.4

 264.31

 177.2

 111.5

 83.73

Owner's equity

 1261.2

 1713.03

 2102.5

 2488

 3043.69

Total (a)

 1447.6

 1977.34

 2279.7

 2599.35

 3127.42

PBDIT (b)

 928.8

 1229.4

 1543.1

 1826.8

 2195.13

Rate of return (b/a)

 64%

 62.20%

 67.60%

 70.20%

 70.10%

Interest charges

 30.55%

 11.07%

 12.60%

 11.73%

 9.24%

For each rupee of capital invested in assets, HLL realized an average return of 66.82%, whereas it paid only 15.04% on an average as interests.
 

More>> Page6


2010, ICMR (IBS Center for Management Research).All rights reserved. No part of this publication may be reproduced, stored in a retrieval system, used in a spreadsheet, or transmitted in any form or by any means - electronic or mechanical, without permission.

To order copies, call +91- 8417- 236667 or write to ICMR,
Survey No. 156/157, Dontanapalli Village, Shankerpalli Mandal,
Ranga Reddy District,
Hyderabad-501504. Andhra Pradesh, INDIA. Mob: +91- 9640901313, Ph: +91- 8417- 236667,
Fax: +91- 8417- 236668
E-mail: info@icmrindia.org
Website: www.icmrindia.org.


ICMRINDIA © 2010 ICMR (IBS Center for Management Research).
All rights reserved.
Terms of Use | Privacy Policy | FAQ