NCERT Class 12 Accountancy Accounting Ratios
NCERT Class 12 Accountancy Accounting Ratios
NCERT Class 12 Accountancy Accounting Ratios
com
Accounting Ratios 5
2020-21
2020-21
2020-21
2020-21
Now let us talk about the limitations of the ratios. The various limitations
are:
1. Means and not the End: Ratios are means to an end rather than the
end by itself.
2. Lack of ability to resolve problems: Their role is essentially indicative
and of whistle blowing and not providing a solution to the problem.
3. Lack of standardised definitions: There is a lack of standardised
definitions of various concepts used in ratio analysis. For example,
there is no standard definition of liquid liabilities. Normally, it includes
all current liabilities, but sometimes it refers to current liabilities less
bank overdraft.
4. Lack of universally accepted standard levels: There is no universal
yardstick which specifies the level of ideal ratios. There is no standard
list of the levels universally acceptable, and, in India, the industry
averages are also not available.
5. Ratios based on unrelated figures: A ratio calculated for unrelated
figures would essentially be a meaningless exercise. For example,
creditors of Rs. 1,00,000 and furniture of Rs. 1,00,000 represent a
ratio of 1:1. But it has no relevance to assess efficiency or solvency.
Hence, ratios should be used with due consciousness of their limitations
while evaluating the performance of an organisation and planning the future
strategies for its improvement.
2020-21
1. ‘Statement of Profit and Loss Ratios: A ratio of two variables from the
statement of profit and loss is known as statement of profit and loss
ratio. For example, ratio of gross profit to revenue from operations is
known as gross profit ratio. It is calculated using both figures from
the statement of profit and loss.
2. Balance Sheet Ratios: In case both variables are from the balance
sheet, it is classified as balance sheet ratios. For example, ratio of
current assets to current liabilities known as current ratio. It is
calculated using both figures from balance sheet.
3. Composite Ratios: If a ratio is computed with one variable from the
statement of profit and loss and another variable from the balance
sheet, it is called composite ratio. For example, ratio of credit revenue
from operations to trade receivables (known as trade receivables
turnover ratio) is calculated using one figure from the statement of
profit and loss (credit revenue from operations) and another figure
(trade receivables) from the balance sheet.
Although accounting ratios are calculated by taking data from financial
statements but classification of ratios on the basis of financial statements is
rarely used in practice. It must be recalled that basic purpose of accounting is
to throw light on the financial performance (profitability) and financial position
(its capacity to raise money and invest them wisely) as well as changes occurring
in financial position (possible explanation of changes in the activity level). As
such, the alternative classification (functional classification) based on the
purpose for which a ratio is computed, is the most commonly used classification
which is as follows:
1. Liquidity Ratios: To meet its commitments, business needs liquid
funds. The ability of the business to pay the amount due to
stakeholders as and when it is due is known as liquidity, and the
ratios calculated to measure it are known as ‘Liquidity Ratios’. These
are essentially short-term in nature.
2. Solvency Ratios: Solvency of business is determined by its ability to
meet its contractual obligations towards stakeholders, particularly
towards external stakeholders, and the ratios calculated to measure
solvency position are known as ‘Solvency Ratios’. These are essentially
long-term in nature.
3. Activity (or Turnover) Ratios: This refers to the ratios that are
calculated for measuring the efficiency of operations of business based
on effective utilisation of resources. Hence, these are also known as
‘Efficiency Ratios’.
4. Profitability Ratios: It refers to the analysis of profits in relation to
revenue from operations or funds (or assets) employed in the business
and the ratios calculated to meet this objective are known as
‘Profitability Ratios’.
2020-21
Current Assets
Current Ratio = Current Assets : Current Liabilities or
Current Liabilities
Current assets include current investments, inventories, trade receivables
(debtors and bills receivables), cash and cash equivalents, short-term loans and
advances and other current assets such as prepaid expenses, advance tax and
accrued income, etc.
Current liabilities include short-term borrowings, trade payables (creditors
and bills payables), other current liabilities and short-term provisions.
Illustration 1
Calulate Current Ratio from the following information:
Particulars (Rs.)
Inventories 50,000
Trade receivables 50,000
Advance tax 4,000
Cash and cash equivalents 30,000
Trade payables 1,00,000
Short-term borrowings (bank overdraft) 4,000
Solution:
Current Assets
Current Ratio =
Current Liabilities
Current Assets = Inventories + Trade receivables + Advance tax +
Cash and cash equivalents
= Rs. 50,000 + Rs. 50,000 + Rs. 4,000 + Rs. 30,000
= Rs. 1,34,000
Current Liabilities = Trade payables + Short-term borrowings
= Rs. 1,00,000 + Rs. 4,000
= Rs. 1,04,000
Rs.1,34,000
Current Ratio = = 1.29 :1
Rs.1,04,000
2020-21
Illustration 2
Calculate quick ratio from the information given in illustration 1.
Solution:
Quick Assets
Quick Ratio =
Current Liabilities
Quick Assets = Current assets – (Inventories + Advance tax)
= Rs. 1,34,000 – (Rs. 50,000 + Rs. 4,000)
= Rs. 80,000
Current Liabilities = Rs. 1,04,000
Rs. 80,000
Quick Ratio = = 0.77 :1
Rs. 1,04,000
Significance: The ratio provides a measure of the capacity of the business to
meet its short-term obligations without any flaw. Normally, it is advocated to be
2020-21
safe to have a ratio of 1:1 as unnecessarily low ratio will be very risky and a
high ratio suggests unnecessarily deployment of resources in otherwise less
profitable short-term investments.
Illustration 3
Calculate ‘Liquid Ratio’ from the following information:
Current liabilities = Rs. 50,000
Current assets = Rs. 80,000
Inventories = Rs. 20,000
Advance tax = Rs. 5,000
Prepaid expenses = Rs. 5,000
Solution
Liquid Assets
Liquid Ratio =
Current Liabilities
Liquid Assets = Current assets – (Inventories + Prepaid expenses +
Advance tax)
= Rs. 80,000 – (Rs. 20,000 + Rs. 5,000 + Rs. 5,000)
= Rs. 50,000
Rs. 50,000
Liquid Ratio = = 1 :1
Rs. 50,000
Illustration 4
X Ltd., has a current ratio of 3.5:1 and quick ratio of 2:1. If excess of current
assets over quick assets represented by inventories is Rs. 24,000, calculate
current assets and current liabilities.
Solution:
Current Ratio = 3.5:1
Quick Ratio = 2:1
Let Current liabilities = x
Current assets = 3.5x
and Quick assets = 2x
Inventories = Current assets – Quick assets
24,000 = 3.5x – 2x
24,000 = 1.5x
x = Rs.16,000
Current Liabilities = Rs.16,000
Current Assets = 3.5x = 3.5 × Rs. 16,000 = Rs. 56,000.
2020-21
Verification :
Current Ratio = Current assets : Current liabilities
= Rs. 56,000 : Rs. 16,000
= 3.5 : 1
Quick Ratio = Quick assets : Current liabilities
= Rs. 32,000 : Rs. 16,000
= 2:1
Illustration 5
Calculate the current ratio from the following information:
Total assets = Rs. 3,00,000
Non-current liabilities = Rs. 80,000
Shareholders’ Funds = Rs. 2,00,000
Non-Current Assets:
Fixed assets = Rs. 1,60,000
Non-current Investments = Rs. 1,00,000
Solution:
Total assets = Non-current assets + Current assets
Rs. 3,00,000 = Rs. 2,60,000 + Current assets
Current assets = Rs. 3,00,000 – Rs. 2,60,000 = Rs. 40,000
Total assets = Equity and Liabilities
= Shareholders’ Funds + Non-current liabilities +
Current liabilities
Rs. 3,00,000 = Rs. 2,00,000 + Rs. 80,000 + Current Liabilities
Current liabilities = Rs. 3,00,000 – Rs. 2,80,000
= Rs. 20,000
Current Assets
Current Ratio =
Current Liabilities
Rs. 40,000
= = 2 :1
Rs. 20,000
Do it Yourself
1. Current liabilities of a company are Rs. 5,60,000, current ratio is 2.5:1 and
quick ratio is 2:1. Find the value of the Inventories.
2. Current ratio = 4.5:1, quick ratio = 3:1.Inventory is Rs. 36,000. Calculate the
current assets and current liabilities.
3. Current assets of a company are Rs. 5,00,000. Current ratio is 2.5:1
and Liquid ratio is 1:1. Calculate the value of current liabilities, liquid
assets and inventories.
2020-21
Illustration 6
The current ratio is 2 : 1. State giving reasons which of the following transactions
would improve, reduce and not change the current ratio:
(a) Payment of current liability;
(b) Purchased goods on credit;
(c) Sale of a Computer (Book value: Rs. 4,000) for Rs. 3,000 only;
(d) Sale of merchandise (goods) costing Rs. 10,000 for Rs. 11,000;
(e) Payment of unclaimed dividend.
Solution:
The given current ratio is 2 : 1. Let us assume that current assets are Rs.
50,000 and current liabilities are Rs. 25,000; Thus, the current ratio is 2 : 1.
Now we will analyse the effect of given transactions on current ratio.
(a) Assume that Rs. 10,000 of creditors is paid by cheque. This will reduce
the current assets to Rs. 40,000 and current liabilities to Rs. 15,000.
The new ratio will be 2.67 : 1 (Rs. 40,000/Rs.15,000). Hence, it has
improved.
(b) Assume that goods of Rs. 10,000 are purchased on credit. This will
increase the current assets to Rs. 60,000 and current liabilities to
Rs. 35,000. The new ratio will be 1.7:1 (Rs. 60,000/Rs. 35,000). Hence,
it has reduced.
(c) Due to sale of a computer (a fixed asset) the current assets will
increase to Rs. 53,000 without any change in the current liabilities.
The new ratio will be 2.12 : 1 (Rs. 53,000/Rs. 25,000). Hence, it has
improved.
(d) This transaction will decrease the inventories by Rs. 10,000 and
increase the cash by Rs. 11,000 thereby increasing the current
assets by Rs. 1,000 without any change in the current liabilities.
The new ratio will be 2.04 : 1 (Rs. 51,000/Rs. 25,000). Hence, it has
improved.
(e) Assume that5,000 is given by way of unclaimed dividend. It will
reduce the current assets to 45,000 and unclaimed current liabilities
by 5,000. The new ratio will be 2:25:1 (45,000/20,000). Hence,
it has improved.
2020-21
repayment of principal amount at the end of the loan period. Solvency ratios
are calculated to determine the ability of the business to service its debt in
the long run. The following ratios are normally computed for evaluating
solvency of the business.
1. Debt-Equity Ratio;
2. Debt to Capital Employed Ratio;
3. Proprietary Ratio;
4. Total Assets to Debt Ratio;
5. Interest Coverage Ratio.
2020-21
Illustration 7
From the following balance sheet of ABC Co. Ltd. as on March 31, 2015. Calculate
debt equity ratio:
ABC Co. Ltd.
Balance Sheet as at 31 March, 2017
Particulars Note Amount
No. (Rs.)
I. Equity and Liabilities
1. Shareholders’ funds
a) Share capital 12,00,000
b) Reserves and surplus 2,00,000
c) Money received against share warrants 1,00,000
2. Non-current Liabilities
a) Long-term borrowings 4,00,000
b) Other long-term liabilities 40,000
c) Long-term provisions 60,000
3. Current Liabilities
a) Short-term borrowings 2,00,000
b) Trade payables 1,00,000
c) Other current liabilities 50,000
d) Short-term provisions 1,50,000
25,00,000
II. Assets
1. Non-Current Assets
a) Fixed assets 15,00,000
b) Non-current investments 2,00,000
c) Long-term loans and advances 1,00,000
2. Current Assets
a) Current investments 1,50,000
b) Inventories 1,50,000
c) Trade receivables 1,00,000
d) Cash and cash equivalents 2,50,000
e) Short-term loans and advances 50,000
25,00,000
Solution:
Debts
Debt-Equity Ratio =
Equity
Debt = Long-term borrowings + Other long-term liabilities +
Long-term provisions
= Rs. 4,00,000 + Rs. 40,000 + Rs. 60,000
= Rs. 5,00,000
Equity = Share capital + Reserves and surplus + Money received
against share warrants
2020-21
50, 0000
Debt Equity Ratio = = 0.33 : 1
1,50, 0000
Illustration 8
From the following balance sheet of a company, calculate Debt-Equity Ratio:
Balance Sheet
Particulars Note (Rs.)
No.
I. Equity and Liabilities
1. Shareholders’ funds
(a) Share capital 8,00,000
(b) Reserves and Surplus 1 1,00,000
2. Share application money pending allotment 2,00,000
3. Non-Current Liabilities
Long-term borrowings 1,50,000
Current liabilities 1,50,000
14,00,000
II. Assets
1. Non-Current Assets
a) Fixed assets
- Tangible assets 2 11,00,000
2. Current Assets
a) Inventories 1,00,000
b) Trade receivables 90,000
c) Cash and cash equivalents 1,10,000
14,00,000
Notes to Accounts
(Rs.)
1. Share Capital
Equity Share Capital 6,00,000
Preference Share Capital 2,00,000
8,00,000
2020-21
Fixed Assets
(Rs.)
2. Tangible Assets:
Plant and Machinery 5,00,000
Land and Building 4,00,000
Motor Car 1,50,000
Furniture 50,000
11,00,000
Solution:
Long - term Debts
Debt-Equity Ratio =
Equity (Shareholders’ Funds)
Long-term Debts = Long-term Borrowings
= Rs. 1,50,000
1, 50, 000
Debt Equity Ratio = = 0.136 : 1
11, 00, 000
5.7.2 Debt to Capital Employed Ratio
The Debt to capital employed ratio refers to the ratio of long-term debt to the
total of external and internal funds (capital employed or net assets). It is
computed as follows:
Debt to Capital Employed Ratio = Long-term Debt/Capital Employed (or Net Assets)
Capital employed is equal to the long-term debt + shareholders’ funds.
Alternatively, it may be taken as net assets which are equal to the total assets
– current liabilities taking the data of Illustration 7, capital employed shall
work out to Rs. 5,00,000 + Rs. 15,00,000 = Rs. 20,00,000. Similarly, Net
Assets as Rs. 25,00,000 – Rs. 5,00,000 = Rs. 20,00,000 and the Debt to
capital employed ratio as Rs. 5,00,000/Rs. 20,00,000 = 0.25:1.
Significance: Like debt-equity ratio, it shows proportion of long-term debts in
capital employed. Low ratio provides security to lenders and high ratio helps
management in trading on equity. In the above case, the debt to Capital Employed
ratio is less than half which indicates reasonable funding by debt and adequate
security of debt.
It may be noted that Debt to Capital Employed Ratio can also be computed
in relation to total assets. In that case, it usually refers to the ratio of total
2020-21
debts (long-term debts + current liabilities) to total assets, i.e., total of non-
current and current assets (or shareholders’, funds + long-term debts + current
liabilities), and is expressed as
Total Debts
Debt to Capital Employed Ratio =
Total Assets
2020-21
Illustration 9
From the following information, calculate Debt Equity Ratio, Total Assets to
Debt Ratio, Proprietory Ratio, and Debt to Capital Employed Ratio:
Solution:
Debts
i) Debt-Equity Ratio =
Equity
Debt = Long-term borrowings = Rs. 1,50,000
Equity = Share capital + Reserves and surplus
= Rs. 4,00,000 + Rs. 1,00,000 = Rs. 5,00,000
Rs. 1,50,000
Debt-Equity Ratio = = 0.3 : 1
Rs. 5, 00, 000
Total assets
ii) Total Assets to Debt Ratio =
Long-term debts
Total Assets = Fixed assets + Non-current investments + Current assets
= Rs. 4,00,000 + Rs. 1,00,000 + Rs. 2,00,000 = Rs. 7,00,000
Long-term Debt = Rs. 1,50,000
2020-21
Shareholders’ Funds
iii) Proprietary Ratio = or
Total Assets
Long-term
Long debts
- term debts
iv) Debt to Capital Employed Ratio =
Capital Employed
Capital Employed = Shareholders’ Funds + Long-term borrowings
= Rs. 5,00,000 + Rs. 1,50,000
= Rs. 6,50,000
Long-term
Long - term debts
Debt to Capital Employed Ratio=
Capital Employed
Rs. 1,50,000
= = 0.23 : 1
Rs. 6,50, 000
Illustration 10
The debt equity ratio of X Ltd. is 0.5 : 1. Which of the following would
increase/decrease or not change the debt equity ratio?
(i) Further issue of equity shares
(ii) Cash received from debtors
(iii) Sale of goods on cash basis
(iv) Redemption of debentures
(v) Purchase of goods on credit.
Solution:
The change in the ratio depends upon the original ratio. Let us assume that
external funds are Rs. 5,00,000 and internal funds are Rs. 10,00,000.
Now we will analyse the effect of given transactions on debt equity ratio.
(i) Assume that Rs. 1,00,000 worth of equity shares are issued. This
will increase the internal funds to Rs. 11,00,000. The new ratio will
be 0.45 : 1 (5,00,000/11,00,000). Thus, it is clear that further
issue of equity shares decreases the debt-equity ratio.
(ii) Cash received from debtors will leave the internal and external funds
unchanged as this will only affect the composition of current assets.
Hence, the debt-equity ratio will remain unchanged.
2020-21
(iii) This will also leave the ratio unchanged as sale of goods on cash basis
neither affect Debt nor equity.
(iv) Assume that Rs. 1,00,000 debentures are redeemed. This will decrease
the long-term debt to Rs. 4,00,000. The new ratio will be 0.4 : 1
(4,00,000/10,00,000). Redemption of debentures will decrease the
debit-equity ratio.
(v) This will also leave the ratio unchanged as purchase of goods on credit
neither affect Debt nor equity.
Illustration 11
From the following details, calculate interest coverage ratio:
Net Profit after tax Rs. 60,000; 15% Long-term debt 10,00,000; and Tax rate
40%.
Solution:
Net Profit after Tax =Rs. 60,000
Tax Rate =40%
Net Profit before tax =Net profit after tax × 100/(100 – Tax rate)
=Rs. 60,000 × 100/(100 – 40)
=Rs. 1,00,000
Interest on Long-term Debt =15% of Rs. 10,00,000 = Rs. 1,50,000
Net profit before interest and tax =Net profit before tax + Interest
=Rs. 1,00,000 + Rs. 1,50,000 = Rs. 2,50,000
Interest Coverage Ratio =Net Profit before Interest and
Tax/Interest on long-term debt
= Rs. 2,50,000/Rs. 1,50,000
= 1.67 times.
2020-21
2020-21
2020-21
Illustration 12
From the following information, calculate inventory turnover ratio :
Rs.
Inventory in the beginning = 18,000
Inventory at the end = 22,000
Net purchases = 46,000
Wages = 14,000
Revenue from operations = 80,000
Carriage inwards = 4,000
Solution:
Rs.
Revenue from operations = 4,00,000
Average Inventory = 55,000
Gross Profit Ratio = 10%
Solution:
Revenue from operations = Rs. 4,00,000
Gross Profit = 10% of Rs. 4,00,000 = Rs. 40,000
Cost of Revenue from operations = Revenue from operations – Gross Profit
= Rs. 4,00,000 – Rs. 40,000 = Rs. 3,60,000
2020-21
Illustration 14
A trader carries an average inventory of Rs. 40,000. His inventory turnover ratio
is 8 times. If he sells goods at a profit of 20% on Revenue from operations, find
out the gross profit.
Solution:
100
Revenue from operations = Cost of Revenue from operations ×
80
100
= Rs. 3,20,000 × = Rs. 4,00,000
80
Gross Profit = Revenue from operations – Cost of Revenue from operations
= Rs. 4,00,000 – Rs. 3,20,000 = Rs. 80,000
Do it Yourself
1. Calculate the amount of gross profit:
Average inventory = Rs. 80,000
Inventory turnover ratio = 6 times
Selling price = 25% above cost
2. Calculate Inventory Turnover Ratio:
Annual Revenue from operations = Rs. 2,00,000
Gross Profit = 20% on cost of Revenue from
operations
Inventory in the beginning = Rs. 38,500
Inventory at the end = Rs. 41,500
2020-21
Illustration 15
Calculate the Trade receivables turnover ratio from the following information:
Rs.
Total Revenue from operations 4,00,000
Cash Revenue from operations 20% of Total Revenue from operations
Trade receivables as at 1.4.2016 40,000
Trade receivables as at 31.3.2017 1,20,000
Solution:
20
= Rs. 4,00,000 × = Rs. 80,000
100
Credit Revenue from operations = Rs. 4,00,000 – Rs. 80,000 = Rs. 3,20,000
2020-21
Trade Receivables
Average Trade Receivables =
2
Rs. 3, 20,000
Trade Receivables Turnover Ratio = = 4 times.
Rs. 80,000
Solution:
2020-21
Rs. 3, 00, 000 + Rs. 1, 00, 000 + Rs. 1, 30, 000 + Rs. 70, 000
=
2
= Rs. 3,00,000
Given :
Rs.
Revenue from Operations 8,75,000
Creditors 90,000
Bills receivable 48,000
Bills payable 52,000
Purchases 4,20,000
Trade debtors 59,000
Solution:
= 8.18 times
* This figure has not been divided by 2, in order to calculate average Trade Receivables
as the figures of debtors and bills receivables in the beginning of the year are not available.
So when only year-end figures are available use the same as it is.
2020-21
365
(ii) Average Collection Period =
Trade Receivables Turnover Ratio
365
=
8.18
= 45 days
Purchases *
(iii) Trade Payable Turnover Ratio =
Average Trade Payables
Purchases
= Creditors + Bills payable
4,20,000
= 90,000 + 52,000
4,20,000
= 1,42,000
= 2.96 times
365
(iv) Average Payment Period =
Trade Payables Turnover Ratio
365
=
2.96
= 123 days
*Since no information regarding credit purchase is given, hence it will be related as net
purchases.
5.8.4 Net Assets or Capital Employed Turnover Ratio
It reflects relationship between revenue from operations and net assets (capital
employed) in the business. Higher turnover means better activity and
profitability. It is calculated as follows :
2020-21
Significance : High turnover of capital employed, working capital and fixed assets
is a good sign and implies efficient utilisation of resources. Utilisation of capital
employed or, for that matter, any of its components is revealed by the turnover
ratios. Higher turnover reflects efficient utilisation resulting in higher liquidity
and profitability in the business.
Illustration 18
From the following information, calculate (i) Net assets turnover, (ii) Fixed assets
turnover, and (iii) Working capital turnover ratios :
Amount Amount
(Rs.) (Rs.)
Revenue from operations for the year 2016-17 were Rs. 30,00,000
Solution:
Revenue from Operations = Rs. 30,00,000
Capital Employed = Share Capital + Reserves and
Surplus + Long-term Debts
(or Net Assets)
= (Rs.4,00,000 + Rs.6,00,000)
+ (Rs.1,00,000 + Rs.3,00,000)
+ (Rs.2,00,000 + Rs.2,00,000)
= Rs. 18,00,000
Fixed Assets = Rs.8,00,000 + Rs.5,00,000 + Rs.2,00,000
+ Rs.1,00,000 = Rs. 16,00,000
Working Capital = Current Assets – Current Liabilities
= Rs.4,00,000 – Rs.2,00,000 = Rs. 2,00,000
2020-21
2020-21
Illustration 19
Following information is available for the year 2016-17, calculate gross profit
ratio:
Rs.
Revenue from Operations: Cash 25,000
: Credit 75,000
Purchases : Cash 15,000
: Credit 60,000
Carriage Inwards 2,000
2020-21
Salaries 25,000
Decrease in Inventory 10,000
Return Outwards 2,000
Wages 5,000
Solution:
Revenue from Operations = Cash Revenue from Operations + Credit Revenue from
Opration
= Rs.25,000 + Rs.75,000 = Rs. 1,00,000
Net Purchases = Cash Purchases + Credit Purchases – Return Outwards
= Rs.15,000 + Rs.60,000 – Rs.2,000 = Rs. 73,000
Cost of Revenue from = Purchases + (Opening Inventory – Closing Inventory) +
operations Direct Expenses
= Purchases + Decrease in inventory + Direct Expenses
= Rs.73,000 + Rs.10,000 + (Rs.2,000 + Rs.5,000)
= Rs.90,000
Gross Profit = Revenue from Operations – Cost of Revenue from
Operation
= Rs.1,00,000 – Rs.90,000
= Rs. 10,000
Gross Profit Ratio = Gross Profit/Net Revenue from Operations ×100
= Rs.10,000/Rs.1,00,000 × 100
= 10%.
2020-21
Illustration 20
Given the following information:
Rs.
Revenue from Operations 3,40,000
Cost of Revenue from Operations 1,20,000
Selling expenses 80,000
Administrative Expenses 40,000
Calculate Gross profit ratio and Operating ratio.
Solution:
Gross Profit = Revenue from Operations – Cost of Revenue from
Operations
= Rs. 3,40,000 – Rs. 1,20,000
= Rs. 2,20,000
Gross Profit
Gross Profit Ratio = × 100
Revenue from operation
Rs. 2,20,000
= × 100
Rs. 3,40,000
= 64.71%
Operating Cost = Cost of Revenue from Operations + Selling Expenses
+ Administrative Expenses
= Rs. 1,20,000 + 80,000 + 40,000
= Rs. 2,40,000
Operating Cost
Operating Ratio = × 100
Net Revenue from Operations
Rs. 2,40,000
= × 100
Rs. 3,40,000
= 70.59%
2020-21
Illustration 21
Gross profit ratio of a company was 25%. Its credit revenue from operations
was Rs. 20,00,000 and its cash revenue from operations was 10% of the total
revenue from operations. If the indirect expenses of the company were Rs.
50,000, calculate its net profit ratio.
Solution:
Cash Revenue from Operations = Rs.20,00,000 × 10/90
= Rs.2,22,222
Hence, total Revenue from Operations are = Rs.22,22,222
Gross profit = 0.25 × 22,22,222 = Rs. 5,55,555
Net profit = Rs.5,55,555 – 50,000
= Rs.5,05,555
Net profit ratio = Net profit/Revenue from Operations
× 100
= Rs.5,05,555/Rs.22,22,222 × 100
= 22.75%.
2020-21
helps in assessing whether the firm is earning a higher return on capital employed
as compared to the interest rate paid.
2020-21
Illustration 22
From the following details, calculate Return on Investment:
Share Capital : Equity (Rs.10) Rs. 4,00,000 Current Liabilities Rs. 1,00,000
12% Preference Rs. 1,00,000 Fixed Assets Rs. 9,50,000
General Reserve Rs. 1,84,000 Current Assets Rs. 2,34,000
10% Debentures Rs. 4,00,000
Also calculate Return on Shareholders’ Funds, EPS, Book value per share
and P/E ratio if the market price of the share is Rs. 34 and the net profit after tax
was Rs. 1,50,000, and the tax had amounted to Rs. 50,000.
Solution:
Profit before interest and tax = Rs. 1,50,000 + Debenture interest + Tax
= Rs. 1,50,000 + Rs. 40,000 + Rs. 50,000
= Rs.2,40,000
Capital Employed = Equity Share Capital + Preference Share
Capital + Reserves + Debentures
= Rs. 4,00,000 + Rs. 1,00,000 + Rs. 1,84,000
+ Rs. 4,00,000 = Rs. 10,84,000
Return on Investment = Profit before Interest and Tax/
Capital Employed × 100
= Rs. 2,40,000/Rs. 10,84,000 × 100
= 22.14%
Shareholders’ Fund = Equity Share Capital + Preference Share Capital
+ General Reserve
= Rs. 4,00,000 + Rs. 1,00,000 + Rs. 1,84,000
= Rs. 6,84,000
Return on Shareholders’ Funds = Profit after tax/shareholders’ Funds × 100
= Rs. 1,50,000/Rs. 6,84,000 × 100
= 21.93%
EPS = Profit available for Equity Shareholders/
Number of Equity Shares
= Rs. 1,38,000/ 40,000 = Rs. 3.45
2020-21
It may be noted that various ratios are related with each other. Sometimes,
the combined information regarding two or more ratios is given and missing
figures may need to be calculated. In such a situation, the formula of the ratio
will help in working out the missing figures (See Illsuatration 23 and 24).
Illustration 23
Calculate current assets of a company from the following information:
Inventory turnover ratio = 4 times
Inventory at the end is Rs. 20,000 more than the inventory in the beginning.
Revenue from Operations Rs. 3,00,000 and gross profit ratio is 20% of revenue from
operations.
Current liabilities = Rs. 40,000
Quick ratio = 0.75 : 1
Solution:
Cost of Revenue from Operations = Revenue from Operations – Gross Profit
= Rs. 3,00,000 – (Rs. 3,00,000 × 20%)
= Rs. 3,00,000 – Rs. 60,000
= Rs. 2,40,000
Inventory Turnover Ratio = Cost of Revenue from Operations/ Average Inventory
2020-21
Illustration 24
The current ratio is 2.5 : 1. Current assets are Rs. 50,000 and current liabilities
are Rs. 20,000. How much must be the decline in the current assets to bring the
ratio to 2 : 1
Solution:
Current liabilities = Rs. 20,000
For a ratio of 2 : 1, the current assets must be 2 × 20,000 = Rs. 40,000
Present level of current assets = Rs. 50,000
Necessary decline = Rs. 50,000 – Rs. 40,000
= Rs. 10,000
Illustration 25
Following information is given by a company from its books of accounts as on
March 31, 2017:
Particulars (Rs.)
Inventory 1,00,000
Total Current Assets 1,60,000
Shareholders’ funds 4,00,000
13% Debentures 3,00,000
Current liabilities 1,00,000
Net Profit Before Tax 3,51,000
Cost of revenue from operations 5,00,000
Calculate:
i) Current Ratio
ii) Liquid Ratio
iii) Debt Equity Ratio
iv) Interest Coverage Ratio
v) Inventory Turnover Ratio
2020-21
Solution:
Current Assets
i) Current Ratio =
Current Liabilities
Liquid Assets
Liquid Ratio =
Current Liabilities
Long-term Debts
iii) Debt-Equity Ratio =
Shareholders’ Funds
Rs. 5, 00,000
= = 5 times
Rs. 1, 00, 000
Note: In absence of information regarding ‘Inventory in the beginning’ and ‘Inventory
at the end’, the ‘Inventory’ is treated as Average Inventory.
2020-21
Illustration 26
From the following information calculate (i) Earning per share (ii) Book value
per share (iii) Dividend payout ratio (iv) Price earning ratio
Particulars (Rs.)
70,000 equity shares of Rs. 10 each 7,00,000
Net Profit after tax but before dividend 1,75,000
Market price of a share 13
Dividend declared @ 15%
Solution:
Rs. 8, 75,000
= = Rs. 12.50
Rs. 70, 000
1.50
= = 0.6
2.50
13
= = 5.20
2.50
2020-21
Summary
Ratio Analysis: An important tool of financial statement analysis is ratio
analysis. Accounting ratios represent relationship between two accounting
numbers.
Objective of Ratio Analysis: The objective of ratio analysis is to provide a
deeper analysis of the profitability, liquidity, solvency and activity levels in
the business. It is also to identify the problem areas as well as the strong
areas of the business.
Advantages of Ratio Analysis: Ratio analysis offers many advantages
including enabling financial statement analysis, helping understand efficacy
of decisions, simplifying complex figures and establish relationships, being
helpful in comparative analysis, identification of problem areas, enables
SWOT analysis, and allows various comparisons.
Limitations of Ratio Analysis: There are many limitations of ratio analysis.
Few are based because of the basic limitations of the accounting data on
which it is based. In the first set are included factors like Historical Analysis,
Ignores Price-level Changes, Ignore Qualitative or Non-monetary Aspects,
Limitations of Accounting Data, Variations in Accounting Practices, and
Forecasting. In the second set are included factor like means and not the
end, lack of ability to resolve problems, lack of standardised definitions,
lack of universally accepted standard levels, and ratios based on unrelated
figures.
Types of Ratios: There are many types of ratios, viz., liquidity, solvency,
activity and profitability ratios. The liquidity ratios include current ratio
and acid test ratio. Solvency ratios are calculated to determine the ability
of the business to service its debt in the long run instead of in the short
run. They include debt equity ratio, total assets to debt ratio, proprietary
2020-21
ratio and interest coverage ratio. The turnover ratios basically exhibit the
activity levels characterised by the capacity of the business to make more
sales or turnover and include Inventory Turnover, Trade Receivables
Turnover, Trade Payables Turnover, Working Capital Turnover, Fixed Assets
Turnover and Current assets Turnover. Profitability ratios are calculated
to analyse the earning capacity of the business which is the outcome of
utilisation of resources employed in the business. The ratios include Gross
Profit ratio, Operating ratio, Net Profit Ratio, Return on investment (Capital
employed), Earnings per Share, Book Value per Share, Dividend per Share
and Price/Earning ratio.
Numerical Questions
1. Following is the Balance Sheet of Raj Oil Mills Limited as at March 31, 2017.
Calculate current ratio.
2020-21
Particulars (Rs.)
I. Equity and Liabilities:
1. Shareholders’ funds
a) Share capital 7,90,000
b) Reserves and surplus 35,000
2. Current Liabilities
Trade Payables 72,000
Total 8,97,000
II. Assets
1. Non-current Assets
Fixed assets
– Tangible assets 7,53,000
2. Current Assets
a) Inventories 55,800
b) Trade Receivables 28,800
c) Cash and cash equivalents 59,400
Total 8,97,000
2020-21
3. Current Ratio is 3.5 : 1. Working Capital is Rs. 90,000. Calculate the amount of
Current Assets and Current Liabilities.
(Ans: Current Assets Rs. 1,26,000 and Current Liabilities Rs. 36,000)
4. Shine Limited has a current ratio 4.5 : 1 and quick ratio 3 : 1; if the inventory
is 36,000, calculate Current Liabilities and Current Assets.
(Ans: Current Assets Rs. 1,08,000, Current Liabilities Rs. 24,000)
5. Current Liabilities of a company are Rs. 75,000. If current ratio is 4:1 and Liquid
Ratio is 1 : 1, calculate value of Current Assets, Liquid Assets and Inventory.
(Ans: Current Assets Rs. 3,00,000, Liquid Assets Rs. 75,000 and Inventory
Rs. 2,25,000)
6. Handa Ltd. has inventory of Rs. 20,000. Total liquid assets are Rs. 1,00,000
and quick ratio is 2 : 1. Calculate current ratio.
(Ans: Current Ratio 2.4 : 1)
7. Calculate debt-equity ratio from the following information:
Total Assets Rs. 15,00,000
Current Liabilities Rs. 6,00,000
Total Debts Rs. 12,00,000
(Ans: Debt-Equity Ratio 2 : 1.)
8. Calculate Current Ratio if:
Inventory is Rs. 6,00,000; Liquid Assets Rs. 24,00,000; Quick Ratio 2 : 1.
(Ans: Current Ratio 2.5 : 1)
9. Compute Inventory Turnover Ratio from the following information:
Revenue from Operations Rs. 2,00,000
Gross Profit Rs. 50,000
Inventory at the end Rs. 60,000
Excess of inventory at the end over
inventory in the beginning Rs. 20,000
(Ans: Inventory Turnover Ratio 3 times)
10. Calculate following ratios from the following information:
(i) Current ratio (ii) Liquid ratio (iii) Operating Ratio (iv) Gross profit ratio
Current Assets Rs. 35,000
Current Liabilities Rs. 17,500
Inventory Rs. 15,000
Operating Expenses Rs. 20,000
Revenue from Operations Rs. 60,000
Cost of Revenue from operation Rs. 30,000
(Ans: Current Ratio 2 : 1; Liquid Ratio 1.14 : 1; Operating Ratio 83.3%; Gross
Profit Ratio 50%)
11. From the following information calculate:
(i) Gross Profit Ratio (ii) Inventory Turnover Ratio (iii) Current Ratio (iv) Liquid
Ratio (v) Net Profit Ratio (vi) Working Capital Ratio:
2020-21
(Ans: Working Capital Ratio 8.33 times; Debt–Equity Ratio 0.4 : 1; Proprietary
Ratio 0.71 : 1)
13. Calculate Inventory Turnover Ratio if:
Inventory in the beginning is Rs. 76,250, Inventory at the end is Rs. 98,500,
Sales is Rs. 5,20,000, Sales Return is Rs. 20,000, Purchases is Rs. 3,22,250.
(Ans: Inventory Turnover Ratio 3.43 times)
14. Calculate Inventory Turnover Ratio from the data given below:
Inventory in the beginning of the year Rs. 10,000
Inventory at the end of the year Rs. 5,000
Carriage Rs. 2,500
Revenue from Operations Rs. 50,000
Purchases Rs. 25,000
(Ans: Inventory Turnover Ratio 4.33 times)
15. A trading firm’s average inventory is Rs. 20,000 (cost). If the inventory turnover
ratio is 8 times and the firm sells goods at a gross profit of 20% on sales,
ascertain the gross profit of the firm.
(Ans: Gross Profit Rs. 40,000)
2020-21
16. You are able to collect the following information about a company for two years:
2015-16 2016-17
Trade receivables on Apr. 01 Rs. 4,00,000 Rs. 5,00,000
Trade receivables on Mar. 31 Rs. 5,60,000
Stock in trade on Mar. 31 Rs. 6,00,000 Rs. 9,00,000
Revenue from operations Rs. 3,00,000 Rs. 24,00,000
(gross profit is 25% on cost of
Revenue from operations)
Calculate Inventory Turnover Ratio and Trade Receivables Turnover Ratio
(Ans: 2015-16: Inventory Turnover Ratio 2.67 times, Trade Receivables Turnover
Ratio 4.41 times), 2016-17: Inventory Turnover Ratio 2.13 times Trade Receivable
Turn over Ratio 4.53 times.
17. From the following Balance Sheet and other information, calculate following
ratios:
(i) Debt-Equity Ratio (ii) Working Capital Turnover Ratio (iii) Trade Receivables
Turnover Ratio
Balance Sheet as at March 31, 2017
Particulars Note (Rs.)
No.
I. Equity and Liabilities:
1. Shareholders’ funds
a) Share capital 10,00,000
b) Reserves and surplus 7,00,000
c) Money received against share warrants 2,00,000
2. Non-current Liabilities
Long-term borrowings 12,00,000
3. Current Liabilities
Trade payables 5,00,000
Total 36,00,000
II. Assets
1. Non-current Assets
Fixed assets
– Tangible assets 18,00,000
2. Current Assets
a) Inventories 4,00,000
b) Trade Receivables 9,00,000
c) Cash and cash equivalents 5,00,000
Total 36,00,000
(Ans: Debt-Equity Ratio 0.63 : 1; Working Capital Turnover Ratio 1.38 times; Trade
Receivables Turnover Ratio 2 times)
2020-21
2020-21
Rs.
Gross Profit 50,000
Revenue from Operations 1,00,000
Inventory 15,000
Trade Receivables 27,500
Cash and Cash Equivalents 17,500
Current Liablilites 40,000
Land & Building 50,000
Plant & Machinery 30,000
Furniture 20,000
(Ans: (i) Gross Profit Ratio 50%; (ii) Current Ratio 1.5:1; (iii) Liquid Ratio 1.125 : 1,
Inventory Turnover Ratio 3.33 times; (iv) Fixed Assets Turnover Ratio 1 : 1)
22. From the following information calculate Gross Profit Ratio, Inventory Turnover
Ratio and Trade Receivable Turnover Ratio.
Revenue from Operations Rs. 3,00,000
Cost of Revenue from Operations Rs. 2,40,000
Inventory at the end Rs. 62,000
Gross Profit Rs. 60,000
Inventory in the beginning Rs. 58,000
Trade Receivables Rs. 32,000
(Ans: Gross Profit Ratio 20%; Inventory Turnover Ratio 4 times; Trade
Receivables Turnover Ratio 9.375 times)
2020-21