Times Series of financial Ratios

Besides looking at the ratios for one year, one would like to look at the ratios for several years. This will help in the detection of secular changes and avoidance of the bias introduced by transitory forces. Below is presented certain ratios for Horizon Limited for a period of five years (year 5 corresponds to 20X1) Looking at this we find that:

1) The debt equity ratio improved for three years in succession but deteriorated in the last year.
2) The total assets turnover ratio remained more or less the same.
3) The net profit margin ratio improved impressively in the second year but subsequently declined somewhat steeply over the remaining three years.
4) The return on equity followed the pattern of the net profit margin ratio.
5) The price earnings ratio deteriorated steadily over time except in the last year.

Comparison of ratios of Horizon Limited with Industry Average


Current ratio = Current assets / Current liabilities

Acid test ratio = Quick assets / Current liabilities


Debt equity ratio = Debt / Equity

Debt ratio = Debt / Assets

Interest coverage ratio = PBIT / Interest


Inventory = Net sales / Average inventory

Accounts receivable turnover = Net credit sales / Average accounts receivables

Fixed assets turnover = Net sales / Average net fixed assets

Total assets turnover = Net sales / Average total assets


Gross profit margin ratio = Gross profit / net sales

Net profit margin ratio = Net profit / Net sales

Return on assets = Net profit / Average total assets

Earning power = PBIT / Average total assets

Return on capital employed = PBIT (1 – T) / Average total assets

Return on equity = Equity earnings / Average net worth


Price earnings ratio = Market price per share / Earnings per share

Yield = dividend+ Price change / Initial price

Market value to book value ratio = Market price per share / Book value per share

Du Pont Analysis:

The Du Pont Company of the US pioneered a system of financial analysis which has received widespread recognition and acceptance. A useful system of analysis, which considers important interrelationships based on information found in financial statements, it has adopted by many firms in some form or the other.

At the apex of the Du Pont chart is the return on assets (ROA), defined as the product of the net profit margin (NPM) and the total assets turnover ratio (TATR):

Net profit / Average total assets = net profit / net sales x

Net sales / average total assets eq (1)

Such decomposition helps in understanding how the return on total assets is influenced by the net profit margin and the total assets turnover ratio.

The upper side of the Du Pont chart shows the details underlying the net profit margin ratio. An examination of this side may indicate areas where cost reductions may be effected to improve the net profit margin. If this is supplemented by comparative common size analysis, it becomes relatively easier to understand where cost control efforts should be directed.

The lower side of the Du Pont chart throws light on the determinants of the total assets turnover ratio. If this is supplemented by a study of component turnover ratios (inventory turnover, debtors’ turnover, and fixed assets turnover), a deeper insight can be gained into efficiencies / inefficiencies of asset utilization.

The basic Du Pont analysis may be extended to explore the determinants of the return on equity (ROE).

Net profit / Equity = Net profit / sales x Sales / Total assets x


Average total assets / Equity

1 ( 1 – DAR) ——————————–eq (2)

The third component on the right hand side of Eq (2) needs a little explanation. Average total assets dividend by average equity to 1 divided (1 – DAR). DAR stands for debt to assets ratio.

Confusion Although related to the problems of bureaucratization the diseconomies that fall into this category
Financial policies and strategies of an organization are concerned with the raising and utilization of
To the military strategists position is a crucial element in any campaign plan.  The general
You have set a financial goal and your adviser has told you how much you
The goal of the consumer price Index is to measure changes in the cost of