Accounting Ratios – CA Foundation, CPT notes, PDF
This article is about Accounting Ratios for CA foundation CPT students. we also provide PDF file at the end.
What we will study in this chapter:
1 MEANING OF RATIO ANALYSIS
The quantitative analysis of the financial statements of a company is known as Ratio Analysis. It has a significant role in the process of decision making. It is used to assess the company’s operating and financial performance. The efficiency, liquidity, profitability and solvency of a company can be measured through ratio analysis.
These ratios are very helpful and effective to the internal management, prospective investors, outsiders and creditors etc.
26.2 IMPORTANCE OF RATIO ANALYSIS
- Effective instrument to measure efficiency:- The ratios are useful in measuring the ability of the company to manage its assets and liabilities in an effective manner.
Through the help of efficiency ratios we can compute the capability of the company in regard to the management of the assets and its operations.
- Helps to evaluate long term financial solvency:- The accounting ratios are used to know the liquidity position of the company to meet its short term and long term obligations. The outcomes through this analysis are useful to the outsiders in taking investment decisions.
- Assists management in decision making:- These accounting ratios throw light on the operational efficiency of the management and its utilization of assets. Thus, they turn out to be a useful tool for the purpose of decision making and while taking corrective action.
- Aids in forecasting:- It is possible to plan, forecast and control actions with the help of ratio analysis.
The information derived from the analysis is an invaluable aid to the management.
The ratios are used to formulate different policies, prepare budgets and so on.
- Useful tool to measure profitability:- The ability of the company to generate income (profit) during a specific period of time can be evaluated with the help of profitability ratios. These provide valuable information to the analysts and investors in regard to the company’s performance.
26.3 LIMITATIONS OF RATIO ANALYSIS
- Accounting policies:- Accounting transactions can be recorded in different manner by different companies following different accounting policies.
Thus, this difference makes the accounting data and ratios of any two firms incomparable.
- Historical costs:- The assets valuation in the balance sheet is done according to the historical costs convention. Due to this practice the ratios so calculated may give unrealistic facts.
- Ignorance of qualitative factors:- The calculation of ratios involves the inclusion of quantitative or monetary factors only. These completely ignore the qualitative factors while computing the ratios which may give distorted results.
- Window Dressing:- The presentation of financial statements in such a way that it shows a better financial position is called window dressing. Thus, if any firm resorts towards this practice, the ratios so computed from its balance sheet will never reveal the true position of the firm.
- No fixed standards:- It is not possible to lay down fixed standards for ideal ratios. Th us, the ratios so computed gain no significance as these cannot be compared with other ratios or standards. This turns out to be another limitation of accounting ratios.
26.4 TYPES OF RATIOS
There are two-ways in which financial ratios can be classified:-
- There is the classical approach or traditional approach.
- The other is the functional approach.
26.4.1 Traditional/Classical Approach
In this approach the ratios are classified on the basis of accounting statements to which they belong.
The approach has been further classified as follows:
- Statement of Profit & Loss Ratios:- When the two variables, from which the ratio has to be calculated, are extracted from the Statement of Profit and Loss, the ratio so obtained is known as Statement of Profit and Loss Ratio.
- Balance Sheet Ratios:- The ratio been calculated by obtaining both the variables from the balance sheet, is known as Balance Sheet ratio.
- Composite Ratios:- When a ratio is obtained by taking one variable from the Statement of Profit and Loss and another variable from the balance sheet, it is known as Composite ratio.
26.4.2 Functional Approach
In this approach the ratios are classified on the basis of the purpose of their computation.
It has been classified as follows
- Liquidity Ratios
- Solvency Ratios
- Activity (Turnover) Ratios
- Profitability Ratios
- Liquidity Ratios:- Liquidity means the ability of the business to meet its financial obligations of short term nature. Thus, the ability of the enterprise to pay the current liabilities is measured through liquidity ratios.
Liquidity Ratios include:- (a) Current Ratio
(b) Quick Ratio (Acid test Ratio)
(c) Cash Ratio (Absolute Liquidity Ratio)
(d) Net Working Capital Ratio.
- Solvency Ratios or Leverage Ratios:- Solvency of the business means its ability to meet the long-terms debts. The solvency position and long term obligations and stability of the business are measured through solvency ratios. These Ratios include:-
(1) Capital Structure Ratios:-
(a) Equity Ratio
(b) Debt Equity Ratio
(c) Debt to total assets Ratio
(d) Capital gearing Ratio
(e) Proprietary Ratio
(2) Coverage Ratios:-
(a) Debt service coverage Ratio
(b) Interest Coverage Ratio
(c) Preference dividend coverage Ratio ,
(d) Fixed charges coverage Ratio
- Activity Ratios (Turnover Ratios):- These ratios measure how effectively the resources of the business have been used by it. In other words these ratios are calculated to measure the efficiency of operations of an enterprise along with optimum and efficient utilization of resources by it. Thus these are also known as efficiency ratios or asset management ratios.
These include:-
(a) Total assets turnover ratio
(b) Fixed assets turnover ratio
(c) Capital turnover ratio
(d) Current assets turnover ratio
(e) Working capital turnover ratio:-
(i) Inventory turnover ratio
(ii) Debtors turnover ratio
(iii) Creditors turnover ratio
- Profitability Ratios:- The efficiency of the business can be measured through its profitability. Thus profitability ratios are calculated to determine the profitability of the business or enterprise.
These can be classified as follows:-
(a) Gross Profit Ratio
(b) Net Profit Ratio
(c) Operating Profit Ratio
(d) Expenses Ratio
The overall efficiency is measured with respect to sales.
Profitability Ratios related to Overall Return on Assets/Investments
(a) Return on Investments (ROI)
(b) Return on Assets (ROA)
(c) Return on Capital Employed (ROCE)
(d) Return on Equity (ROE)
Profitability Ratios required for Analysis from Owner’s Point of View
(a) Earnings per Share (EPS)
(b) Dividend per Share (DPS)
(c) Dividend Payout (DP) Ratio
Profitability Ratios related to Market/Valuation/Investors (n) Price Earnings (P/E) Ratio
(b) Dividend and Earning Yield
(c) Market Value/Book Value per Share (MV/BV)
26.4.2.1 Liquidity Ratios
(a) Current Ratio:-This ratio is computed to measure the short term liquidity of the business. It measures the financial position by evaluating whether current assets in the business are sufficient to meet the current liabilities.
The ratio is calculated as follows:-
Current Ratio =
where,
Current Assets = Cash & Bank balances + Inventories *+ Sundry Debtors⊥ Bills Receivables +Current Investments + Short-terms loans and advances + Other Current assets.
Current Liabilities = Short-term Borrowings + Creditors + Bills payables + Short terms Provisions +Bank Overdrafts Outstanding Expenses + Proposed Dividend + Unclaimed Dividend⊥ Other current liabilities.
‘These exclude loose tools and stores and spares.
Ideal current ratio is 2:1.
Illustration 26.1 : You are required to calculate Current Ratio from the following information:
Particulars | Rs. |
Inventories | 1,02,000 |
Trade receivables | 1,15,000 |
Advance Tax | 3,000 |
Cash and cash equivalents | 15,000 |
Trade payables | 1,90,000 |
Short-term borrowings (bank overdraft) | 13,000 |
Solution :
Current Ratio =
Current Assets = Inventories + Trade receivables + Advance Tax + Cash and cash equivalents = Rs. 1,02,000 +Rs. 1,15,000 +Rs. 3,000+Rs. 15,000 = Rs. 2,35,000
Current Liabilities = Trade payables + Short-term borrowings = Rs. 1,90,000+ Rs. 13,000 =Rs. 2,03,000
Current Ratio = = 1.16:1
(b) Quick Ratio: The ratio is computed to assess the short term solvency of the business. It evaluates whether liquid assets in the business are enough to meet the current liabilities.
Ideal quick ratio is 1:1.
The ratio is calculated as follows:-
Quick Ratio =
where,
Quick. Assets = Current assets – Inventories – Prepaid expenses
It considers those current assets that are either in the form of Cash & Bank or are easily and readily convertible into cash & bank balance.
Illustration 26.2 :
Rs. | Rs. | ||
Current Liabilities | 2,00,000 | Advance Tax | 20,000 |
Current Assets | 2,80,000 | Prepaid Expenses | 20,000 |
Inventories | 20,000 |
You are required to calculate “Liquidity Ratio” from the above information:
Solution ;
Liquidity Ratio =
Liquid Assets = Current assets-(Inventories + Prepaid expenses + Advance tax)
= Rs.2,80,000 – (Rs. 20,000 +Rs. 20,000+ Rs. 20,000)
= Rs. 2,00,000
Liquidity Ratio = = 1:1
(c) Cash Ratio or Absolute Liquidity Ratio: The ratio measures the ability of the firm to pay its current liabilities with the help of cash and cash equivalents available with the firm.
The ratio is calculated as follows:-
Cash Ratio =
Illustration 26.3 :
Particulars | Rs. |
Cash | 8,00,000 |
Cash Equivalents | 4,00,000 |
Accounts Payable | 4,00,000 |
Accounts Receivables | 20,00,000 |
Current Taxes Payable | 2,00,000 |
Long term liabilities | 10,00,000 |
You are required to calculate the Cash Ratio
Solution :
Cash Ratio =
Cash Ratio = = = 2:1
(d) Net Working Capital Ratio: Net working capital ratio is obtained by subtracting the amount of current liabiliti (excluding short-term bank borrowings) from the amount of current assets of the company. The ratio reveals wheth the business is capable to stay in operation in the short-run.
It is computed as follows:-
Net Working Capital Ratio = Current assets – Current liabilities (excluding short-term bank borrowings)
Illustration 26.4 ;
Current Ratio 3 : 2
Current Assets 2,13,000
You are required to calculate Net Working Capital Ratio.
Solution :
Net Working Capital Ratio = Current Assets – Current Liabilities
= Rs. 2,13,000 – Rs. 1,42,000 = Rs. 71,000
W.N.-
Current Ratio = = = 3:2
Current Liabilities = 2,13,000 × = 1,42,000
26.4.2.2 Long-Term Solvency Ratios
- Capital Structure Ratios:-
(a) Equity Ratio:- The ratio is computed to measure the portion of owner’s funds or capital over the total investment in the business.
It is calculated as follows:-
Equity Ratio =
where,
Shareholders’ Equity = Share capital + Reserve and surplus + Retained earnings
Capital Employed = Total assets -Current liabilities
or
Fixed assets + Working capital
A high equity ratio indicates lower degree of risk.
Illustration 26.5:
Rs. | |
Share Capital | 10,00,000 |
Reserves | 3,00,000 |
Surplus | (1,00,000) |
Current assets | 5,50,000 |
Non-current assets | 3,70,000 |
Trade payables | 20,000 |
You are required to compute Equity Ratio
Solution :
Equity Ratio = = = 1.33 : 1
W.N.-
Shareholders Funds =Share Capital + Reserve – Losses carried forward
= Rs. 10,00,000 + Rs. 3,00,000 – Rs. 1,00,000 = Rs. 12,00,000
Capital Employed = Current Assets + Non Current Assets – Trade Payables
= Rs. 5,50,000 + Rs. 3,70,000 – Rs. 20,000 = Rs. 9,00,000
(b) Debt to Equity Ratio:-This ratio indicates the relation of long-term debts with shareholder’s equity. Ideal debt to equity ratio is 2:1.
A high ratio indicates risk involved in the case of financial position and a low ratio indicates safer position. The ratio is considered useful while taking capital structure decisions.
It is calculated as follows:-
Debt to Equity Ratio =
Illustration 26.6:
Rs. | |
Share Capital | 1,50,000 |
Reserves and surplus | (25,000) |
Long term liabilities | 1,80,500 |
Current liabilities | 20,500 |
Fixed assets | 2,26,000 |
Non- current investments | 28,000 |
Current Assets | 1,76,000 |
You are required to compute Debt to Equity Ratio from the above information.
Solution :
Debt Equity Ratio =
Debt Equity Ratio = = 1.44 : 1
W.K.-
Total Debt = Long term liabilities
= Rs.1,80,500
Shareholder’s Equity = Share Capital + Reserves and Surplus
= Rs.1,50,000 – Rs.25,000
= Rs.1,25,000
(c) Debt to Total Assets Ratio:- This ratio measures the percentage of total assets that are financed by creditors, liabilities and debt.
This ratio is a measure of the financial leverage.
It is calculated by dividing the amount of debt by the total assets
Debt to Total Assets Ratio =
Total Debt here includes short-term and long-term borrowings (from banks and financial institutions) & provisions, debentures/bonds & public deposits etc.
Total assets include Non Current and Current Assets. Fictitious assets are not a part of total assets.
Higher ratio reflects risk in investment in the company.
Illustration 26.7: From illustration 6, compute Debt to Total Assets Ratio.
Solution:
Debt to Total Assets Ratio = = = 0.42:1
(d) Capital Gearing Ratio:- Capital gearing ratio is used to examine the capital structure of the company.
The ratio is calculated by dividing common stakeholders’ equity funds by funds provided by those who receive a fixed payment of interest or dividend.
It is computed as follows:-
Capital Gearing Ratio =
Illustration 26.8:
Rs. | |
Shareholders’ equity | 10,00,000 |
Preference shareholders | 6,00,000 |
10% debentures | 8,00,000 |
Loan from bank | 7,00,000 |
Reserves | 5,00,000 |
You are required to compute the Capital Gearing Ratio.
Solution :
Capital Gearing Ratio =
= = = = 7:5 (highly geared)
(e) Proprietary Ratio:- The ratio shows the portion of total assets financed by proprietor’s funds. It is calculated as follows:-
Proprietary Ratio =
where,
Proprietary fund includes, share capital (Equity or preference) and reserves and surplus of the company. It indicates the financial strength of the company by measuring the extent to which proprietors’ funds are invested in the total assets.
- Coverage Ratios:-
(a) Debt Service Coverage Ratio:- This ratio is a measure of the firm’s ability to pay off its current debt obligations. It is computed as follows:-
Debt Service Coverage Ratio =
Here, earnings available for debt services = Net Profit (after tax) + Non cash operating expenses like depreciation and amortization + Interest +Other adjustments.
(b) Interest Coverage Ratio:-This ratio is used to assess the firm’s ability to meet the interest obligations on outstanding debt.
The ratio is calculated as follows:-
Interest Coverage Ratio =
A high interest coverage ratio is considered good as it indicates a better financial position of the company in meeting its interest obligations. A low interest coverage ratio indicates inefficiency in operations. It is also called ‘times interest earned’.
Illustration 26.9 :
You are required to calculate:
- Interest coverage ratio and
- Debt Service Coverage Ratio with the help of following details:
Net Profit after tax = Rs.50,000
15% Long-term debt = Rs.20,00,000 (Principal amount is repayable in 20 equal instalments)
Tax rate = 60%
Solution :
(i) Interest Coverage Ratio = = = 1.42 times
(ii) Debt Service Coverage Ratio = =
= = 1.06 times
Working Notes :
- Net Profit before tax = × 100 = × 100 = Rs. 1,25,000
- Interest on Long-term Debt = 15% of Rs.20,00,000 = Rs.3,00,000
- Net profit before interest and tax = Net profit before tax + Interest
= Rs.1,25,000+Rs.3,00,000
= Rs.4,25,000
(c) Preference Dividend Coverage Ratio: This ratio measures the firm’s ability to pay off the required dividend on its preference shares.
It will be calculated as follows:-
Preference Dividend Coverage Ratio =
A low coverage ratio indicates poor financial health of the company meaning it has fewer funds to make the dividend payment and vice versa.
(d) Fixed Charges Coverage Ratio:- This ratio measures the firm’s ability to pay off its fixed charge obligations. It indicates how many times can a company pay the fixed expenses out of its earnings before interest and taxes.
It is calculated as follows :-
Fixed Charges Coverage Ratio =
(e) Equity dividend coverage Ratio:- This ratio measures the number of times a firm can pay off the required dividend on its equity shares.
It will be calculated as follows:-
Equity dividend coverage Ratio =
Illustration 26.10 :
Rs. | |
Earnings before interest and taxes | 90,000 |
Lease payments | 46,000 |
Interest | 26,000 |
Solution :
Fixed Charges Coverage Ratio =
= = = 1.889:1
(safe; as it is more than 1)
26.4.2.3 Activity Ratios
- Total Assets Turnover Ratio:- This ratio measures the value of a company’s sales or revenue in relation to the value of its assets. It is an indicator of the efficiency of the company as to how the company deploys its assets to earn revenue.
It is calculated as follows:-
Total Assets Turnover Ratio =
- Fixed Assets Turnover Ratio:- This ratio indicates the efficiency with which the company uses its fixed assets in generating revenue. A higher fixed asset turnover ratio is better as it reflects efficient utilization of fixed assets in generating sales.
It is calculated as follows :-
Fixed Assets Turnover Ratio =
- Capital Turnover Ratio:- The ratio is also known as Net Assets Turnover ratio. It measures the ability of the business to use its net asset to generate sales.
It is calculated as follows:-
Capital Turnover Ratio =
Net assets here means, Net Fixed Assets and Net Current Assets [Assets-Liabilities]
- Current Assets Turnover Ratio:
This activity ratio measures the ability of the business to generate revenue from operations/sales through the efficient use of its current assets.
It is calculated as follows:-
Current Assets Turnover Ratio =
- Working Capital Turnover Ratio:
The ratio is calculated to measure the efficiency of the business in using its working capital. It can be computed as follows:-
Working Capital Turnover Ratio —
It is further divided into:-
(i) Inventory Turnover Ratio
(ii) Debtors Turnover Ratio
(iii) Creditors Turnover Ratio
(i) Inventory Turnover Ratio or Stock Turnover Ratio:- This ratio shows the relationship between the cost of revenue from operations during the year and average inventory held during the year. The ratio indicates the number of times the inventory has been used and sold by the company. It measures how efficient is the company in managing the levels of inventory. A high ratio is considered favourable.
It is calculated as follows:-
Inventory Turnover Ratio or Stock Turnover Ratio =
Average inventory =
In case the stock of raw materials is given, the formula will be
=
(ii) Debtors Turnover Ratio or Trade Receivables Turnover Ratio:- The ratio establishes relationship between Net Credit Sales and Average accounts receivable of the company. Account receivables here refer to the total amount of the average debtors and average bills receivable of the company. The ratio measures how efficient is the company in managing the collection from the accounts receivable.
It is computed as follows:-
Debtors Turnover Ratio =Trade Receivables or Debtors velocity = or Average daily credit sales*
(iii) Creditors Turnover Ratio or Trade Payables Turnover Ratio This ratio shows the relationship between Net Credit purchases and average accounts payable. Average account payables here refer to the total amount of average creditors and average bills payable of the company. This ratio measures the efficiency of the company in managing and making payments to the account payable.
It is computed as follows:-
Creditors Turnover Ratio =Trade Payables or Creditors velocity =or Average daily credit purchase*
Illustration 26.11 :
Particulars | Amount (Rs.) | Particulars | Amount (Rs.) |
Preference share capital | 8,50,000 | Land & Building | 11,00,000 |
Equity share capital | 10,00,000 | Plant & Machinery | 15,00,000 |
General reserve | 2,65,000 | Furniture | 50,000 |
Statement of Profit and Loss (bal.) | 6,90,000 | Motor Car | 2,50,000 |
1596 debentures | 3,50,000 | Inventory | 3,75,000 |
1496 Loan | 5,50,000 | Debtors | 1,90,000 |
Creditors | 4,00,000 | Cash and Bank | 3,45,000 |
Outstanding expenses | 20,000 |
You are required to calculate :
(i) Net assets turnover ratio,
(ii) Fixed assets turnover ratio, and
(iii) Working capital turnover ratio,
(iv) Current Assets turnover ratio,
(v) Total Assets turnover ratio with the help of above information. Revenue from operations for the year were Rs.60,00,000.
Solution :
(i) Net Assets Turnover Ratio = 1.51 times
(ii) Fixed Assets Turnover Ratio = 1.93 times
(iii) Working Capital Turnover Ratio= 11.43 times
(iv) Current Assets Turnover Ratio = 6.15 times
(v) Total Assets Turnover Ratio = 1.47 times = 1.5 times
Working Notes :
Revenue from Operations — Rs. 56,00,000
(i) Capital Employed
(or Net Assets) = Share Capital + Reserves and Surplus + Long-term debts
= Rs. 10,00,000 + Rs. 8,50,000 + Rs. 2,65,000+ Rs. 6,90,000+ Rs. 3,50,000 + Rs. 5,50,000
= Rs. 37,05,000.
(ii) Fixed Assets = Rs.15,00,000 + Rs. 11,00,000 + Rs. 2,50,000 + Rs. 50,000 = Rs. 29,00,000
(iii) Working Capital = Current Assets – Current Liabilities
= (3,75,000 + 1,90,000 + 3,45,000) – (4,00,000 + 20,000)
= Rs. 9,10,000 – Rs. 4,20,000 = Rs. 4,90,000
Illustration 26.12: From the following information, calculate inventory turnover ratio:
Particulars | Rs. | Particulars | Rs. |
Inventory in the beginning | 58,000 | Inventory at the end | 70,000 |
Net purchases | 2,14,000 | Revenue from operations | 3,16,000 |
Wages | 39,000 | Carriage inwards | 15,000 |
Solution :
Inventory Turnover Ratio = 4 Times
Working Notes:
- Cost of Revenue from Operations = Inventory in the beginning + Net Purchases + Wages + Carriage inwards –
Inventory at the end
= Rs. 58,000 + Rs. 2,14,000 + Rs. 39,000 + Rs. 15,000 – Rs. 70,000
= Rs.2,56,000
- Average inventory = (Inventory in the beginning + inventory at the end)/2 = Rs.64,000
Illustration 26.13 : You are required to calculate inventory turnover ratio from the following information:
Rs. | ||
Revenue from operations | = | 9,00,000 |
Average inventory | = | 90,000 |
Gross Profit Ratio | = | 10% |
Solution : |
Inventory Turnover Ratio= 9 Times
Working note:-
- Gross Profit = 10% of Rs.9,00,000 = Rs.90,000
- Cost of Revenue from operations= Revenue from operations – Gross Profit
= Rs.9,00,000 – Rs.90,000 = Rs. 8,10,000
Illustration 26.14: Calculate the Trade receivables turnover ratio from the following information:
Rs. | |
Total Revenue from operations | 5,00,000 |
Cash Revenue from operations | 25% of Total Revenue from operations |
Trade receivables as at 1.4.2016 | 50,000 |
Trade receivables as at 31.3.2017 | 1,00,000 |
Solution :
Trade receivables Turnover Ratio = 5 times
Working notes :
- Credit Revenue from operations = Total revenue from operations – Cash revenue from operations
Cash revenue from operations = 25% of Rs.5,00,000 = 1,25,000
Credit Revenue from operations = Rs.5,00,000 – Rs.1,25,000 = Rs.3,75,000
- Average Trade Receivables = Rs.75,000
Illustration 26.15: From the data given in illustration no. 14, find out the average collection period.
Solution :
Average daily credit sales = Rs. 1041.67
Average Collection Period = 72 days
Therefore, on an average debtors take 72 days to pay.
Illustration 26.16: With the help of following figures you are required to calculate the Trade payables turnover ratio and average payment period:
Rs. | ||
Credit purchases during 2017-18 | = | 25,00,000 |
Creditors on 1.4.2017 | = | 4,50,000 |
Bills Payables on 1.4.2017 | = | 2,50,000 |
Creditors on 31.3.2018 | = | 2,00,000 |
Bills Payables on 31.3.2018 | = | 1,00,000 |
Solution :
Trade Payable Turnover Ratio = Average Trade Payables
= Rs.5,00,000
Trade Payable Turnover Ratio = = 5 times
Average payment period = =72 days
26.4.2.4 Profitability Ratios
- Profitability Ratios based on Sales:-
(a) Gross Profit Ratio:-This profitability ratio shows the relationship between gross profit and the revenue from the operations or Net Sales. It is an indicator of the operational efficiency of the business.
It is calculated as follows:-
Gross Profit Ratio = × 100
A high Gross Profit ratio is considered better.
Illustration 26.17: Following information is available for the year 2017-18, calculate gross profit ratio:
Particulars | Rs. | Particulars | Rs. |
Revenue from Operations: | Salaries | 32,000 | |
Cash | 43,000 | Decrease in inventory | 58,000 |
Credit | 1,67,000 | Return Outwards | 4,000 |
Purchases: | |||
Cash | 50,000 | Wages | 25,000 |
Credit | 2,00,000 | ||
Carriage Inwards | 11,000 |
Solution :
Gross Profit Ratio = × 100 = × 100 = 33.33%
Working notes:-
- Revenue from operations — Cash Revenue from Operations + Credit Revenue from Operation
= Rs.43,000 + Rs.1,67,000 = Rs.2,10,000
- Net Purchases = Cash Purchases + Credit Purchases – Return Outwards
= Rs.50,000 + Rs.2,00,000 – Rs.4,000 = Rs.2,46,000
- Cost of Revenue from Operation
= Purchases + (opening Inventory – Closing Inventory) +
Direct Expenses (Wages + Carriage Inwards)
= Rs.2,46,000 + Rs. 58,000 + (Rs. 25,000 + Rs. 11,000) = Rs.3,40,000
- Gross Profit = Revenue from Operations – Cost of Revenue from Operation
= Rs.4,10,000 – Rs.3,40,000 = Rs.70,000
(b) Net Profit Ratio:- This profitability ratio shows the relationship between net profit and the revenue from operations or Net Sales. It is an indicator of the profitability of the business.
It is calculated as follows:-
Net Profit Ratio = × 100
Or
= × 100
A high Net Profit ratio is considered favorable.
Illustration 26.18: Gross profit ratio of X Ltd. was 20%. Its credit revenue from operations was Rs.25,50,000 and its cash revenue from operations was 15% of the total revenue from operations.
You are required to calculate its net profit ratio if the indirect expenses of the X Ltd. were Rs.37,000.
Solution :
Cash Revenue from Operations = × 15 = Rs.4,50,000
Hence, total Revenue from Operations are = Rs. 30,00,000
Gross profit = 0.20 × 30,00,000 = Rs.6,00,000
Net profit = Rs. 6,00,000 – 37,000 = Rs.5,63,000
Net profit ratio = × 100
= × 100 = 18.77%
(c) Operating Profit Ratio:- This profitability ratio establishes relationship between the operating profit and the net sales. It measures the efficiency of the business as a controller of costs involved in the business operations.
It is calculated as follows:-
Operating Profit Ratio = × 100
where,
Operating Profit = Sales – Cost of Goods sold – Operating Expenses.
Illustration 26.19: You are required to calculate (i) Gross profit ratio (ii) Operating profit ratio with the help of following information.
Rs. | |
Revenue from Operations | 6,40,000 |
Cost of Revenue from Operations | 2,00,000 |
Selling Expenses | 98,000 |
Administrative Expenses | 75,000 |
Solution :
(i) Gross Profit Ratio = × 100 = × 100 = 68.75%
(ii) Operating profit ratio = × 100 = × 100 = 41.72%
Working notes :
- Gross profit = Revenue from Operations – Cost of Revenue from Operations
= Rs.6,40,000 – Rs. 2,00,000 = Rs.4,40,000
- Operating Cost = Cost of Revenue from Operations + Selling Expenses + Administrative Expenses
= Rs. 2,00,000 + Rs.98,000 + Rs.75,000= Rs. 3,73,000
- Operating profit = Sales – Operating cost
= Rs. 6,40,000 – Rs. 3,73,000 = Rs. 2,67,000
(d) Expenses Ratio:- Expenses ratio is based on different concepts of expenses. The different variants of the ratio are expressed below:-
(i) Cost of Goods Sold (COGS) Ratio = × 100
(ii) Operating Ratio = × 100
(iii) Financial Expenses Ratio = × 100
*It excludes taxes, loss due to theft, goods destroyed by fire etc.
Administration Expenses ratio, Selling & Distribution Expenses Ratio also can be calculated in similar manner.
Illustration 26.20: You are required to calculate (i) Cost of goods sold ratio (ii) Operating ratio with the help of following information.
Rs. | |
Revenue from Operations • | 32,00,000 |
Opening stock | 4,00,000 |
Closing stock | 5,20,000 |
Selling Expenses | 50,000 |
Purchases | 18,00,000 |
Wages | 3,80,000 |
Carriage inwards | 1,00,000 |
Administration Expenses | 92,000 |
Solution :
(i) Cost of goods sold ratio = – × 100 = × 100 = 67.5%
(ii) Operating ratio = -× 100 = × 100 = 72% (approx)
Working notes:
1, COGS = Opening stock + purchases + wages+ carriage inward – closing stock
= Rs. 4,00,000 + Rs. 18,00,000 + Rs. 3,80,000 + Rs. 1,00,000 – Rs. 5,20,000 = Rs. 21,60,000
- Operating Cost — Cost of goods sold + Operating exp. (Selling Expenses + Administrative Exp.)
= Rs. 21,60,000 + Rs. 50,000 +Rs. 92,000= Rs. 23,02,000
- Profitability Ratios based on Overall Return on Investments
(a) Return on Investment (ROI): This ratio calculates the percentage of return on owners’ funds being invested in the business. It measures the profitability of the owners’ efforts put into the business.
It indicates the profit or returns earned in relation to the investment of the company. It is calculated as follows:-
Return on investment = Profitability Ratio × Investment Turnover ratio
Or
= Profitability Ratio × 100
Here, Profitability Ratio = and
Investment Turnover ratio =
(b) Return on Assets (ROA): This ratio establishes the relationship between net profits & the assets utilized to earn that profit. Thus, this ratio measures the profitability of the business in relation to the assets employed by the business.
The ratio can be computed as follows
Return on Assets =
(c) Return on Capital Employed (ROCE): This profitability ratio measures the efficiency with which the company generates profits from its capital employed.
It takes into account earnings before interest and tax (EBIT) and capital employed, i,e„ the total assets less current liabilities, of the company.
Thus, the calculation can be done through the formula:-
Return on Capital Employed = × 100
(d) Return on Equity (ROE): This ratio reveals how well the shareholder’s funds have been utilized to generate profit. It establishes the relationship between net annual income and shareholder’s equity.
It indicates the profitability of the firm in relation to the equity funds invested in the firm.
It is computed as follows:-
Return on Equity = × 100
A high return on equity ratio is considered profitable.
Illustration 26.21:
Particulars | Rs. |
EBIT | 12,00,000 |
Interest | 3,00,000 |
Taxes paid | 2,25,000 |
Preference dividend | 60,000 |
Current assets | 6,50,000 |
Fixed assets | 13,50,000 |
Current liabilities | 1,50,000 |
You are required to calculate (i) Return on Assets and (ii) Return on capital Employed.
Solution :
Return on Assets =
= × 100 = 45%
ROCE (Post-tax) = × 100
= × 100 = 48.65%
Working Notes:
- Total Assets = Current Assets + Fixed Assets
= Rs.6,50,000 + Rs.13,50,000 = Rs.20,00,000
- Capital Employed = Total Assets – Current Liabilities
= Rs.20,00,000 – Rs. 1,50,000 = Rs. 18,50,000
- Computation of Tax rate:
EBT = EBIT – Interest
= Rs. 12,00,000 – Rs.3,00,000 = Rs. 9,00,000
So, Tax Rate = × 100 = Rs.2,25,000/9,00,000 × 100
t = 25%
Illustration 26.22: Following information is given to you:-
Particulars | Rs. |
Fixed Assets | 7,50,000 |
Current Assets | 4,00,000 |
Current Liabilities | 3,00,000 |
Revenue from Operations | 14,50,000 |
Tax Rate | 3596 |
Interest Expenses | 55,000 |
10% Preference Share Capital | 8,50,000 |
Equity shareholders’ Funds | 12,00,000 |
Total Assets in the beginning were Rs.13,00,000
(a) Calculate Return on Assets
(b) Calculate Return on Capital Employed
(c) Calculate Return on Equity
Solution :
(a) Return on Assets = × 100
Return on Assets = × 100 = 74.029
(b) Return on Capital Employed = × 100
= × 100 = 170.59%
(c) Return on Equity = × 100
= × 100 = 68.4896
Working Notes: –
Rs. | ||
1. | EBIT | 14,50,000 |
Less: Interest | (55,000) | |
EBT | 13,95,000 | |
Less: Tax (30%) | (4,88,250) | |
EAT | 9,06,750 |
- Average Total Assets = = = Rs.12,25,000
- Profitability Ratios from Owner’s Point of View:-
(n) Earnings per Share (EPS): Earnings per share refer to the part of profit that is distributed to each outstanding share of ordinary stock. It indicates the profitability of the company.
It is computed as follows:-
Earnings per Share =
(b) Dividend per Share (DPS): This ratio reflects how much is retained by the business and how much profit is distributed as dividend.
It indicates the profitability of the firm per share.
The ratio is computed as follows:-
Dividend per Share =
(c) Dividend Payout Ratio (DP): The dividend payout ratio establishes the relationship between the amount of dividend distributed to the stockholders and the total net income of the company.
It is calculated to know the amount of earnings (not paid as dividends) retained by the management for the growth of the business.
It is computed as follows:-
Dividend Payout Ratio =
- Profitability Ratios related to Investors/Valuation/Market:-
(a) Price-Earnings Ratio: The price earnings ratio establishes the relationship between earnings and company’s stock market price. The expectations of the investors regarding the earnings of the company are indicated through the ratio.
The ratio is used in the valuation of companies which gives investors a better sense.
It is computed as follows:-
Price-Earnings Ratio=
It is helpful in measuring the growth prospective of an investment, risk involved, level of liquidity and corporate image.
(b) Dividend and Earning Yield:- 1. Dividend Yield:-
It measures the amount a company pays out as dividends every year in relation to its share price.
Dividend yield ratio indicates the true return on investment in which the share capital of the company is considered at its market value [MV].
It is expressed as a percentage (%i) and is also known as dividend price ratio.
It is computed as follows:-
Dividend Yield = × 100
- Earning Yield:- It is the reciprocal of the price earnings ratio and is expressed as a percentage.
Earning Yield ratio or Earning Price Ratio establishes relationship between the earnings per share and the market price of each share. It measures the expected return of a company’s stock. It is calculated as follows:-
Earning Yield = × 100
(c) Market Value/Book Value per Share:- This ratio is used to assess the current share price of the company’s stock held by the public.
The ratio is employed by the current and the potential investors to evaluate the company’s performance and know whether it’s share are underpriced or over-priced.
It is computed as follows:-
Market Value / Book Value per Share =
Illustration 26.23:
Rs. | |
Operating Profit (EBIT) | 30,00,000 |
Tax rate | 50% |
Equity Share Capital (FV=Rs. 1O) | 40,00,000 |
10% Preference Share Capital | 25,00,000 |
15% Debentures | 15,00,000 |
PE Ratio | 15 |
Retained Earnings Ratio | 6096 |
Find Out: (a) Earnings per share (h) Market Price Per Share (c) Dividend Per Share (d) Dividend Payout Ratio (e) Earnings Yield |
Solution :
Rs. | ||
EBIT | 30,00,000 | |
Less: Interest (Deb.) | (2,25,000) | |
EBT | 27,75,000 | |
Less: Tax (50%) | (13,87,500) | |
EAT | 13,87,500 | |
Less: Pref. Dividend | (2,50,000) | |
Earnings for Equity Shareholders | 11,37,500 | |
Less : Retained Earnings(60%) | (6,82,500) | |
Dividend Paid | 4,55,000 |
(a) EPS = = = Rs. 2.84
(b) Market Price = PE Ratio × EPS = Rs.15 × 2.84 = Rs.42.6
(c) Dividend Per Share = = = 1.1375
(d) Dividend Payout Ratio = × 100 = × 100 = 40%
(e) Dividend Yield = × 100 = × 100 = 2.67%
(f) Earnings Yield = × 100 = × 100 = 6.67%
*This article contains all topics about Accounting Ratios.
For notes on all CA foundation topics, you can visit this article CA foundation note