Objective of Project Report : The main objective of the Project Report is Find the Ratio Analysis of company. And sub objectives of this report is understand the Meaning of Ratio, Pure Ratio or Simple Ratio, Advantages of Ratio Analysis, Limitations of Ratio Analysis, classification of Ratio, Liquidity Ratio, Profitability Ratio or Income Ratio, Activity & Turnover Ratio, Return on Capital Employed

RATIO ANALYSIS

Meaning of Ratio:- A ratio is simple arithmetical expression of the relationship of one number to another. It may be defined as the indicated quotient of two mathematical expressions.

According to Accountant’s Handbook by Wixon, Kell and Bedford, “a ratio is an expression of the quantitative relationship between two numbers”.

 Ratio Analysis:- Ratio analysis is the process of determining and presenting the relationship of items and group of items in the statements. According to Batty J. Management Accounting “Ratio can assist management in its basic functions of forecasting, planning coordination, control and communication”.

 It is helpful to know about the liquidity, solvency, capital structure and profitability of an organization. It is helpful tool to aid in applying judgement, otherwise complex situations.

Ratio analysis can represent following three methods.

Ratio may be expressed in the following three ways :

1.     Pure Ratio or Simple Ratio :- It is expressed by the simple division of one number by another. For example , if the current assets of a business are Rs. 200000 and its current liabilities are Rs. 100000, the ratio of ‘Current assets to current liabilities’ will be 2:1.

2.     ‘Rate’ or ‘So Many Times :- In this type , it is calculated how many times a figure is, in comparison to another figure. For example , if a firm’s credit sales during the year are Rs. 200000 and its debtors at the end of the year are Rs. 40000 , its Debtors Turnover Ratio is 200000/40000 = 5 times. It shows that the credit sales are 5 times in comparison to debtors.

3.     Percentage :- In this type, the relation between two figures is expressed in hundredth. For example, if a firm’s capital is Rs.1000000 and its profit is Rs.200000 the ratio of profit capital, in term of percentage, is 200000/1000000*100 = 20%

ADVANTAGE OF RATIO ANALYSIS 

1. Helpful in analysis of Financial Statements.

2. Helpful in comparative Study.

3. Helpful in locating the weak spots of the business.

4. Helpful in Forecasting.

5. Estimate about the trend of the business.

6. Fixation of ideal Standards.

7. Effective Control.

8. Study of Financial Soundness.

LIMITATIONS OF RATIO ANALYSIS

1.     Comparison not possible if different firms adopt different accounting policies.

2.     Ratio analysis becomes less effective due to price level changes.

3.     Ratio may be misleading in the absence of absolute data.

4.     Limited use of a single data.

5.     Lack of proper standards.

6.     False accounting data gives false ratio.

7.     Ratios alone are not adequate for proper conclusions.

8.     Effect of personal ability and bias of the analyst. 

CLASSIFICATION OF RATIO 

Ratio may be classified into the four categories as follows:

A.    Liquidity Ratio

a.      Current Ratio

b.     Quick Ratio or Acid Test Ratio

B.    Leverage or Capital Structure Ratio

a.      Debt Equity Ratio

b.     Debt to Total Fund Ratio

c.     Proprietary Ratio

d.     Fixed Assets to Proprietor’s Fund Ratio

e.      Capital Gearing Ratio

f.       Interest Coverage Ratio

C.    Activity Ratio or Turnover Ratio

a.      Stock Turnover Ratio

b.     Debtors or Receivables Turnover Ratio

c.     Average Collection Period

d.     Creditors or Payables Turnover Ratio

e.      Average Payment Period

f.       Fixed Assets Turnover Ratio

g.     Working Capital Turnover Ratio

D.    Profitability Ratio or Income Ratio

 

 (A) Profitability Ratio based on Sales :

 a. Gross Profit Ratio

 b. Net Profit Ratio

 c. Operating Ratio

 d. Expenses Ratio

 

 (B) Profitability Ratio Based on Investment :

          I.       Return on Capital Employed

      II.      Return on Shareholder’s Funds :

a.      Return on Total Shareholder’s Funds

b.     Return on Equity Shareholder’s Funds

c.     Earning Per Share

d.     Dividend Per Share

e.      Dividend Payout Ratio

f.       Earning and Dividend Yield

g.     Price Earning Ratio

LIQUIDITY RATIO

 (A) Liquidity Ratio:- It refers to the ability of the firm to meet  its current liabilities. The liquidity ratio, therefore, are also called ‘Short-term Solvency Ratio’. These ratio are used to assess the short-term financial position of the concern. They indicate the firm’s ability to meet its current obligation out of current resources.

 In the words of Saloman J. Flink, “Liquidity is the ability of the firms to meet its current obligations as they fall due”.

 Liquidity ratio include two ratio :-

a.      Current Ratio

b.     Quick Ratio or Acid Test Ratio

a. Current Ratio:- This ratio explains the relationship between current assets and current liabilities of a business.

Formula:

 

 

 

Current Assets:-‘Current assets’ includes those assets which can be converted into cash with in a year’s time.

Current Assets = Cash in Hand + Cash at Bank + B/R + Short Term Investment + Debtors(Debtors – Provision) + Stock(Stock of Finished Goods + Stock of Raw Material + Work in Progress) + Prepaid Expenses.

Current Liabilities :- ‘Current liabilities’ include those liabilities which are repayable in a year’s time.

Current Liabilities = Bank Overdraft + B/P + Creditors + Provision for Taxation + Proposed Dividend + Unclaimed Dividends + Outstanding Expenses + Loans Payable with in a Year.

Significance :- According to accounting principles, a current ratio of 2:1 is supposed to be an ideal ratio.

It means that current assets of a business should, at least , be twice of its current liabilities. The higher ratio indicates the better liquidity position, the firm will be able to pay its current liabilities more easily. If the ratio is less than 2:1, it indicate lack of liquidity and shortage of working capital.

The biggest drawback of the current ratio is that it is susceptible to “window dressing”. This ratio can be improved by an equal decrease in both current assets and current liabilities.

b. Quick Ratio:- Quick ratio indicates whether the firm is in a position to pay its current liabilities with in a month or immediately.

 Formula:

 

 

‘Liquid Assets’ means those assets, which will yield cash very shortly.

 Liquid Assets = Current Assets – Stock – Prepaid Expenses

Significance :- An ideal quick ratio is said to be 1:1. If it is more, it is considered to be better. This ratio is a better test of short-term financial position of the company.

LEVERAGE OR CAPITAL STRUCTURE RATIO

(B) Leverage or Capital Structure Ratio :- This ratio disclose the firm’s ability to meet the interest costs regularly and Long term indebtedness at maturity.

These ratio include the following ratios :

a.      Debt Equity Ratio:- This ratio can be expressed in two ways:

First Approach : According to this approach, this ratio expresses the relationship between long term debts and shareholder’s fund.

 Formula:

 

 

Long Term Loans:- These refer to long term liabilities which mature after one year. These include Debentures, Mortgage Loan, Bank Loan, Loan from Financial institutions and Public Deposits etc.

Shareholder’s Funds :- These include Equity Share Capital, Preference Share Capital, Share Premium, General Reserve, Capital Reserve, Other Reserve and Credit Balance of Profit & Loss Account.

Second Approach : According to this approach the ratio is calculated as follows:-

 Formula:

 

 

 Debt equity ratio is calculated for using second approach.

Significance :- This Ratio is calculated to assess the ability of the firm to meet its long term liabilities. Generally, debt equity ratio of is considered safe.

If the debt equity ratio is more than that, it shows a rather risky financial position from the long-term point of view, as it indicates that more and more funds invested in the business are provided by long-term lenders.

The lower this ratio, the better it is for long-term lenders because they are more secure in that case. Lower than 2:1 debt equity ratio provides sufficient protection to long-term lenders.

b. Debt to Total Funds Ratio : This Ratio is a variation of the debt equity ratio and gives the same indication as the debt equity ratio. In the ratio, debt is expressed in relation to total funds, i.e., both equity and debt.

Formula:

 

 

Significance :- Generally, debt to total funds ratio of 0.67:1 (or

67%) is considered satisfactory. In other words, the proportion of long term loans should not be more than 67% of total funds.

A higher ratio indicates a burden of payment of large amount of interest charges periodically and the repayment of large amount of loans at maturity. Payment of interest may become difficult if profit is reduced. Hence, good concerns keep the debt to total funds ratio below 67%. The lower ratio is better from the long-term solvency point of view.

c. Proprietary Ratio:- This ratio indicates the proportion of total funds provide by owners or shareholders.

Formula:

 

 

Significance :- This ratio should be 33% or more than that. In other words, the proportion of shareholders funds to total funds should be 33% or more.

A higher proprietary ratio is generally treated an indicator of sound financial position from long-term point of view, because it means that the firm is less dependent on external sources of finance.

If the ratio is low it indicates that long-term loans are less secured and they face the risk of losing their money.

d. Fixed Assets to Proprietor’s Fund Ratio :- This ratio is also know as fixed assets to net worth ratio.

 Formula:

 

 

Significance :- The ratio indicates the extent to which proprietor’s (Shareholder’s) funds are sunk into fixed assets. Normally , the purchase of fixed assets should be financed by proprietor’s funds. If this ratio is less than 100%, it would mean that proprietor’s fund are more than fixed assets and a part of working capital is provided by the proprietors. This will indicate the long-term financial soundness of business.

e. Capital Gearing Ratio:- This ratio establishes a relationship between equity capital (including all reserves and undistributed profits) and fixed cost bearing capital.

 Formula:

 

 

Whereas, Fixed Cost Bearing Capital = Preference Share Capital  + Debentures + Long Term Loan

Significance:- If the amount of fixed cost bearing capital is more than the equity share capital including reserves an undistributed profits), it will be called high capital gearing and if it is less, it will be called low capital gearing.

The high gearing will be beneficial to equity shareholders when the rate of interest/dividend payable on fixed cost bearing capital is lower than the rate of return on investment in business.

Thus, the main objective of using fixed cost bearing capital is to maximize the profits available to equity shareholders.

f. Interest Coverage Ratio:- This ratio is also termed as ‘Debt Service Ratio’. This ratio is calculated as follows:

 Formula:

 

 

Significance :- This ratio indicates how many times the interest charges are covered by the profits available to pay interest charges.

This ratio measures the margin of safety for long-term lenders.

 This higher the ratio, more secure the lenders is in respect of payment of interest regularly. If profit just equals interest, it is an unsafe position for the lender as well as for the company also , as nothing will be left for shareholders.

 An interest coverage ratio of 6 or 7 times is considered appropriate.

ACTIVITY RATIO OR TURNOVER RATIO

 (C) Activity Ratio or Turnover Ratio :- These ratio are calculated on the bases of ‘cost of sales’ or sales, therefore, these ratio are also called as ‘Turnover Ratio’.  Turnover indicates the speed or number of times the  capital employed has been rotated in the process of doing business. Higher turnover ratio indicates the better use of capital or resources and in turn lead to higher profitability.

 It includes the following :

a.     Stock Turnover Ratio:- This ratio indicates the relationship between the cost of goods during the year and average stock kept during that year.

Formula:

 

 

 Here, Cost of goods sold = Net Sales – Gross Profit

 Average Stock = Opening Stock + Closing Stock/2

Significance:- This ratio indicates whether stock has been used or not. It shows the speed with which the stock is rotated into sales or the number of times the stock is turned into sales during the year.

The higher the ratio, the better it is, since it indicates that stock is selling quickly. In a business where stock turnover ratio is high, goods can be sold at a low margin of profit and even than the profitability may be quit high.

b.     Debtors Turnover Ratio :- This ratio indicates the relationship between credit sales and average debtors during the year :

Formula:

 

 

While calculating this ratio, provision for bad and doubtful debts is not deducted from the debtors, so that it may not give a false impression that debtors are collected quickly.

Significance :- This ratio indicates the speed with which the amount is collected from debtors. The higher the ratio, the better it is, since it indicates that amount from debtors is being collected more quickly. The more quickly the debtors pay, the less the risk from bad- debts, and so the lower the expenses of collection and increase in the liquidity of the firm.

By comparing the debtors turnover ratio of the current year with the previous year, it may be assessed whether the sales policy of the management is efficient or not.

c.      Average Collection Period :- This ratio indicates the time with in which the amount is collected from debtors and bills receivables.

 Formula:

 

 

Here, Credit Sales per day = Net Credit Sales of the year / 365

Second Formula :-

 

 

Average collection period can also be calculated on the bases of ‘Debtors Turnover Ratio’. The formula will be:

 

 

Significance :- This ratio shows the time in which the customers are paying for credit sales. A higher debt collection period is thus, an indicates of the inefficiency and negligency on the part of management. On the other hand, if there is decrease in debt collection period, it indicates prompt payment by debtors which reduces the chance of bad debts.

d. Creditors Turnover Ratio :- This ratio indicates the relationship between credit purchases and average creditors during the year .

Formula:-

 

 

Note :- If the amount of credit purchase is not given in the question, the ratio may be calculated on the bases of total purchase.

Significance :- This ratio indicates the speed with which the amount is being paid to creditors. The higher the ratio, the better it is, since it will indicate that the creditors are being paid more quickly which increases the credit worthiness of the firm.

d. Average Payment Period :- This ratio indicates the period which is normally taken by the firm to make payment to its creditors.

 Formula:-

 

 

This ratio may also be calculated as follows :

 

 

Significance :- The lower the ratio, the better it is, because a shorter payment period implies that the creditors are being paid rapidly.

d.     Fixed Assets Turnover Ratio :- This ratio reveals how efficiently the fixed assets are being utilized.

Formula:-

 

 

Here, Net Fixed Assets = Fixed Assets – Depreciation

Significance:- This ratio is particular importance in manufacturing concerns where the investment in fixed asset is quit high. Compared with the previous year, if there is increase in this ratio, it will indicate that there is better utilization of fixed assets. If there is a fall in this ratio, it will show that fixed assets have not been used as efficiently, as they had been used in the previous year.

e.      Working Capital Turnover Ratio :- This ratio reveals how efficiently working capital has been utilized in making sales.

Formula :-

 

 

Here, Cost of Goods Sold = Opening Stock + Purchases +  Carriage + Wages + Other Direct Expenses - Closing Stock

Working Capital = Current Assets – Current Liabilities

Significance :- This ratio is of particular importance in non-manufacturing concerns where current assets play a major role in generating sales. It shows the number of times working capital has been rotated in producing sales.

A high working capital turnover ratio shows efficient use of working capital and quick turnover of current assets like stock and debtors.

A low working capital turnover ratio indicates under-utilisation of working capital.

Profitability Ratios or Income Ratios

(D) Profitability Ratios or Income Ratios:- The main object of every business concern is to earn profits. A business must be able to earn adequate profits in relation to the risk and capital invested in it. The efficiency and the success of a business can be measured with the help of profitability ratio.

 Profitability ratios are calculated to provide answers to the following questions:

          i.            Is the firm earning adequate profits?

        ii.            What is the rate of gross profit and net profit on sales?

      iii.            What is the rate of return on capital employed in the firm?

      iv.            What is the rate of return on proprietor’s (shareholder’s) funds?

        v.            What is the earning per share?

 Profitability ratio can be determined on the basis of either sales or investment into business.

(A)      Profitability Ratio Based on Sales :

 a) Gross Profit Ratio : This ratio shows the relationship between gross profit and sales.

 Formula :

 

  

 Here, Net Sales = Sales – Sales Return

Significance:- This ratio measures the margin of profit available on sales. The higher the gross profit ratio, the better it is. No ideal standard is fixed for this ratio, but the gross profit ratio should be adequate enough not only to cover the operating expenses but also to provide for deprecation, interest on loans, dividends and creation of reserves.

b) Net Profit Ratio:- This ratio shows the relationship between net profit and sales. It may be calculated by two methods:

 Formula: