Financial Ratios and Cash Flow for Shopkeepers: Current Ratio, Stock Turnover, Margin vs Markup and Working Capital

By BillAmico Tax & Compliance Desk | | 12 min read

Profit on paper does not always mean money in the drawer. Financial ratios and a simple cash flow statement help a shopkeeper see whether the shop can pay its bills, whether stock is moving fast enough, and whether the pricing really earns what the owner thinks it earns. This guide uses the retail shop from the trading and profit and loss account guide to calculate each ratio step by step, including the often-confused difference between margin and markup.

1. Why financial ratios matter for a shopkeeper

A ratio compares two numbers from the books to answer one practical question. Is there enough cash and near-cash to pay suppliers? How many times a year does stock sell out? How long do customers take to pay? Ratios turn the final accounts into answers.

The figures below come from the earlier guide on trading and profit and loss accounts: net sales ₹8,20,000, cost of goods sold ₹5,70,000, gross profit ₹2,50,000, net profit ₹70,000, opening stock ₹40,000, closing stock ₹60,000, debtors ₹90,000, creditors ₹80,000, outstanding salaries ₹10,000, prepaid insurance ₹10,000, cash ₹30,000 and bank ₹1,10,000.

2. Liquidity: current ratio, quick ratio and working capital

Liquidity asks whether the shop can meet short-term obligations. Current assets are cash, bank, debtors, stock and prepaid items. Current liabilities are creditors, outstanding expenses and any loan repayable within a year. Here the bank loan is assumed to be long-term.

Current assets = 60,000 + 90,000 + 10,000 + 30,000 + 1,10,000 = ₹3,00,000. Current liabilities = 80,000 + 10,000 = ₹90,000.

MeasureFormulaResult
Current ratioCurrent assets / Current liabilities3,00,000 / 90,000 = 3.33 : 1
Quick ratio(Current assets - Stock - Prepaid) / Current liabilities2,30,000 / 90,000 = 2.56 : 1
Working capitalCurrent assets - Current liabilities₹2,10,000

A common textbook yardstick is a current ratio near 2:1 and a quick ratio near 1:1, but suitable levels differ by trade. A grocery shop that sells for cash may run safely on a lower ratio than a wholesaler that gives credit. Treat the yardstick as a starting point, not a rule.

3. Stock turnover and days in stock

Stock turnover shows how many times the average stock is sold and replaced in the year. Higher usually means faster-moving goods and less cash locked up.

Average stock = (Opening stock + Closing stock) / 2 = (40,000 + 60,000) / 2 = ₹50,000. Stock turnover = Cost of goods sold / Average stock = 5,70,000 / 50,000 = 11.4 times a year. Days in stock = 365 / 11.4 = about 32 days.

In plain words, the average item sits on the shelf for about a month before being sold. Compare that figure across product lines. A slow line may be tying up cash and risking expiry or obsolescence.

4. Debtor days and creditor days

Debtor days = Debtors / Credit sales x 365. Assume ₹4,00,000 of the year's sales were on credit. Debtor days = 90,000 / 4,00,000 x 365 = about 82 days. Customers take nearly three months to pay on average, which is slow and ties up the shop's cash.

Creditor days = Creditors / Credit purchases x 365. Assume credit purchases of ₹5,00,000. Creditor days = 80,000 / 5,00,000 x 365 = about 58 days. The shop pays suppliers in about two months.

The gap matters. The shop collects in about 82 days but pays in about 58, so it finances its customers out of its own pocket for roughly 24 days. A tighter credit policy, reminders and part-payment discounts can close this gap.

warning: Payments to micro and small enterprise suppliers have a legal time limit under Section 43B(h) of the Income-tax Act, 1961 (for deduction purposes). Check the current provision, since the new Income-tax Act, 2025 re-numbers sections. See the guide on TDS and the 45-day MSME rule in this knowledge hub.

5. Gross margin vs markup: the most common confusion

Both measure profit on a sale, but against different bases. Markup is profit as a percentage of cost. Margin is profit as a percentage of the selling price. A 25% markup is not a 25% margin.

Example: an item costs ₹100. With a 25% markup the price is ₹125 and the profit is ₹25. Margin = 25 / 125 = 20%.

From the shop's numbers: margin = gross profit / net sales = 2,50,000 / 8,20,000 = 30.5%. Markup = gross profit / cost of goods sold = 2,50,000 / 5,70,000 = 43.9%.

Conversion: Margin = Markup / (1 + Markup). Markup = Margin / (1 - Margin).

Markup on costMargin on selling price
10%9.09%
20%16.67%
25%20%
33.33%25%
50%33.33%
100%50%

If you want a 20% margin and you add 20% to cost, you will earn less than you planned. To earn a 20% margin you need a 25% markup.

6. Profitability ratios

RatioFormulaResult for the shop
Gross profit ratioGross profit / Net sales x 1002,50,000 / 8,20,000 = 30.5%
Net profit ratioNet profit / Net sales x 10070,000 / 8,20,000 = 8.5%
Return on capitalNet profit / Closing capital x 10070,000 / 3,10,000 = 22.6%

The gap between gross and net profit ratios (30.5% versus 8.5%) shows that operating costs take about 22 percentage points of every rupee of sales (including interest and bad debts, partly offset by other incomes). To improve net profit, look at rent, salaries, wastage and bad debts, not only at selling price.

7. A simple cash flow statement for a shop

A cash flow statement lists the actual movement of cash and bank balances. It groups the movement into operating (day-to-day trading), investing (buying or selling assets) and financing (loans and owner's money). Here is a simple one-month internal version.

ItemAmount (₹)
Opening cash and bank1,00,000
Cash sales3,00,000
Collections from debtors1,20,000
Total inflows4,20,000
Payments to suppliers(2,50,000)
Salaries(30,000)
Rent(15,000)
Electricity(5,000)
Net cash from operating activities1,20,000
Purchase of equipment (investing)(40,000)
Loan EMI (financing)(12,000)
Owner's drawings (financing)(20,000)
Net increase in cash48,000
Closing cash and bank1,48,000

Operating cash of ₹1,20,000 less ₹40,000 investing less ₹32,000 financing gives a net increase of ₹48,000.

Cash flow statements prepared under accounting standards classify items such as interest paid in specific ways, and the rule differs between standards. For a formal statement, follow the standard that applies to you (AS 3 or Ind AS 7). Under the Companies Act, the definition of financial statement includes a cash flow statement, but one person companies, small companies and dormant companies may leave it out.

8. Profit versus cash, and a revision sheet

A shop can be profitable and still short of cash. Profit is recorded when sales are made, while cash arrives only when customers pay. Stock bought, equipment purchased, loan repaid and drawings taken use up cash without being expenses in the profit and loss account. That is why the cash flow statement exists.

  • Current ratio = Current assets / Current liabilities.
  • Quick ratio excludes stock and prepaid items.
  • Working capital = Current assets - Current liabilities.
  • Stock turnover = COGS / Average stock. Days in stock = 365 / turnover.
  • Debtor days = Debtors / Credit sales x 365. Creditor days = Creditors / Credit purchases x 365.
  • Margin = Profit / Selling price. Markup = Profit / Cost.
  • Cash flow has three parts: operating, investing, financing.

Frequently asked questions

What is a good current ratio for a retail shop?

A common textbook yardstick is about 2 to 1, but there is no single right number. A cash-selling grocery can operate safely with a lower ratio, while a business that gives long credit usually needs a higher one. Compare against your own past years and similar shops.

What is the difference between margin and markup?

Markup is profit as a percentage of cost price. Margin is profit as a percentage of selling price. A 25% markup gives a 20% margin. To get a 20% margin, add a 25% markup to cost.

How do I calculate stock turnover?

Divide the cost of goods sold by the average stock, where average stock is the opening stock plus the closing stock divided by two. Divide 365 by the result to get the average days an item stays in stock.

Why is my profit high but my bank balance low?

Profit is measured when sales are made, not when cash is received. Money may be stuck in debtors and stock, or spent on equipment, loan repayment and drawings, none of which reduce profit as expenses.

Is a cash flow statement compulsory for small businesses?

For companies, the Companies Act includes the cash flow statement within the financial statements, with an exemption for one person companies, small companies and dormant companies. A proprietor or partnership is not bound by that Act, but a cash flow view is still useful for managing the shop and for loan applications.

Official sources

Related guides