Key Ratios

Liquidity Ratios

S NoRatio NameFormula
1Current RatioCurrent Assets / Current Liabilities
Note : Stores and spares and Loose tools are to be excluded from inventories
Note : Prov for bad Debts will be deducted from Sundry Debtors
2Quick RatioQuick Assets / Current Liabilities
where
Quick AssetsCurrent Assets - Inventories - Prepaid expenses
Note : Prov for bad Debts will be deducted from Sundry Debtors
Note : Quick ratio is also known as Liquid ratio or acid test ratio
Note : Quick assets are also known as Liquid assets
3Working CapitalCurrent Assets - Current Liabilities

Solvency Ratios

S NoRatio NameFormula
4Debt Equity RatioDebt / Equity
where
DebtNon Current Liabilities or Long Term Debts
EquityShareholders Funds (Share Capital + Reserves and Surplus)
5Total assets to Debt RatioTotal Assets / Debt
where
Total AssetsTotal of all the assets on the assets side of Balance Sheet
or
Non Current Assets + Current Assets
DebtSame as in Debt Equity Ratio
6Proprietary Ratio(Equity or Proprietary Funds)/ Total Assets
where
EquitySame as in Debt Equity Ratio
Total AssetsSame as in Total Assets to Debt ratio
7Interest Coverage RatioNet profit before interest and tax / Interest on Long Term Debts
where
NP before interest and taxIf Net profit after tax is given then 
- NP after Tax + Tax + Interest on Long term loans

Activity Ratio of Turnover Ratios

S NoRatio NameFormula
8Inventory Turnover RatioCost of Goods Sold / Average Inventory
where
Cost of Goods SoldSame as in Gross profit ratio explained below
Average Inventory(Opening Inventory + Closing Inventory) /2
Note : Inventory and Stock are same thing
Note : If Cost of Goods Sold is not given then use Revenue from Operations
Note : If Opening and closing inventory are not given separately then consider          inventory given in question as average inventory
9Trade Receivables Turnover RatioCredit Revenue from Operations / Average Trade receivables
Note : Credit Revenue from Operations is also known as Credit Net Sales
where
Average Trade  Receivables(Opening Trade Receivables + Closing Trade receivables) / 2
Trade ReceivablesBills Receivables + Sundry Debtors
Note : Provision for Bad Debts not to be deducted from debtors
10Debt Collection PeriodIn Months : 12/Trade Receivable Turnover Ratio
In Days : 365 / Trade Receivables Turnover Ratio
Sometimes question says to assume year to be of 360 days In that case formula will be
In Days : 360 / Trade Receivables Turnover Ratio
Note : Debt Collection Period is also known as average collection period
11Trade Payables Turvover RatioNet Credit Purchases / Average Trade Payables
where
Average Trade Payables(Opening Trade Payables + Closing Trade Payables) / 2
where
Trade PayablesBills Payable + Sundry Creditors
12Average Payment PeriodIn Months : 12/Trade Payables Turnover Ratio
In Days : 365 / Trade Payables Turnover Ratio
Sometimes question says to assume year to be of 360 days In that case formula will be
In Days : 360 / Trade Receivables Turnover Ratio
Note : Average Payment Period is also known as 'Average age of Payables'
13Working Capital Turnover RatioRevenue from Operations / Working Capital
where
Working CapitalCurrent Assets - Current Liabilities
Note : If Revenue from Operations is not given then use Cost of Goods Sold

Profitability Ratios

S NoRatio NameFormula
14Gross Profit RatioGross Profit / Net Sales X 100
where
Gross ProfitNet Sales - Cost of Goods Sold
Net SalesGross Sales - (Sales Return or Returns Inward)
Note : Net Sales and Revenue from Operations are same
Note : If GP ratio is given then it is always on Net Sales unless otherwise stated
15Cost of Goods Sold(Op Stock - Closing Stock)  + Net Purchases  + Direct Expenses
or
Change in Stock + Net Purchases + Direct Expenses
or
Excess of Opening Stock over Closing Stock + Net Purchases + Direct Expenses
or
Decrease in inventory + Net Purchases + Direct Expenses
or
- Excess of Closing Stock over Opening Stock + Net Purchases + Direct Expenses
or
- Increase in inventory + Net Purchases + Direct Expenses
Note : Cost of Goods Sold is same as Cost of Revenue from Operations
Note : Inventory can be of Raw Materials, Work in Process, Finished Goods,
             Stock in Trade
Note : Stores and spares and Loose tools are to be excluded from inventories
where
Net PurchasesGross Purchases - (Purchases Return or return outwards)
Direct ExpensesWages + Carriage Inwards
16Operating RatioOperating Cost / Revenue from Operations X 100
where
Operating CostCost of Goods Sold + Operating Expenses
Note : Revenue from Operations is same as Net Sales
Operating expensesOffice Expenses + Administrative expenses + Selling & Distribution Expenses +  Employee Benefit Expenses + Depreciation and amortization expenses
17Operating Profit  RatioOperating Profit / Revenue from Operations X 100
where
Operating ProfitRevenue from Operations - Operating Cost
or
Gross Profit - Operating Expenses
18100Operating Ratio + Operating Profit Ratio
19Net Profit RatioNet Profit / Revenue from Operations X 100
where
Net ProfitOperating Profit - Non Operating Expenses + Non Operating Income
or
Gross Profit - Operating expenses - Non Operating Expenses + Non Operating income
or
Net Sales - Operating Cost - Non Operating Expenses + Non Operating income
Note : Net Profit here is the Net Profit after tax
where
Non Operating Expensesa) Interest on loans b) Interest on Debentures c) loss on sale of fixed assets d) Any other Interest e) Loss by fire
Non Operating Incomea) interest received b) dividend received c) gain on sale of fixed assets d) Income from investment e) Rent received
20Return on InvestmentNet Profit before interest, tax and dividend / Capital Employed X 100
Note : any income from non trade investments is to be excluded from Net Profit
where
Capital EmployedLiabilities side approach
Shareholders Funds + Non Current Liabilities - Goodwill - Non Trade Investments -  Fictitious Assets
Assets Side Approach
Non Current Assets + Current Assets - Current Liabilities
Note : In assets exclude Goodwill, Non Trade Investments and Fictitious Assets
Note : Non Current Investments are assumed to be trade investments unless 
            otherwise specified
Note : Capital Employed and Investment is same so this ratio is also known as 'Return on Capital Employed'
21100Cost of Goods Sold % + Gross Profit Ratio
Key Formula for Ratio Analysis

Leave a Comment

Your email address will not be published. Required fields are marked *