Skip to content

01 · Financial Statement Analysis & Ratios

Recording transactions is half the job; interpreting them is where accountants add real value. This module uses ratios to judge a business's profitability, liquidity, efficiency and solvency, with TallyPrime's Ratio Analysis report.

1. Read the statements first

  1. P&L: revenue growth, gross margin, operating expenses, net profit.
  2. Balance Sheet: working capital (current assets − current liabilities), debt, equity.
  3. Cash flow (Alt+G → Cash Flow / Funds Flow): cash from operations vs profit — profitable businesses can still run out of cash.
  4. Compare periods (add columns with Alt+C) and against budget.

2. Key ratios (worked example)

Sample figures for a trading company (₹ lakh): Sales 600, COGS 450, Operating expenses 96, Net profit 36, Current assets 180 (stock 90, debtors 75, cash 15), Current liabilities 110, Creditors 60, Equity 150, Debt 80, Purchases 470.

Ratio Formula Result
Gross profit margin (Sales − COGS) ÷ Sales 150 ÷ 600 = 25%
Net profit margin Net profit ÷ Sales 36 ÷ 600 = 6%
Current ratio Current assets ÷ Current liabilities 180 ÷ 110 = 1.64
Quick ratio (Current assets − Stock) ÷ CL 90 ÷ 110 = 0.82
Debtor days (DSO) Debtors ÷ Sales × 365 75 ÷ 600 × 365 ≈ 46 days
Inventory days Stock ÷ COGS × 365 90 ÷ 450 × 365 = 73 days
Creditor days Creditors ÷ Purchases × 365 60 ÷ 470 × 365 ≈ 47 days
Cash conversion cycle DSO + Inventory days − Creditor days 46 + 73 − 47 = 72 days
Debt-to-equity Debt ÷ Equity 80 ÷ 150 = 0.53
Return on equity Net profit ÷ Equity 36 ÷ 150 = 24%

3. Interpret, don't just calculate

  1. A quick ratio below 1 means the business depends on selling stock to pay short-term debts.
  2. A 72-day cash conversion cycle means each rupee of sales is tied up for over two months — reducing inventory days by 20 would free significant cash.
  3. Compare with industry norms and the business's own history; ratios mean little in isolation.
  4. Look for causes behind changes: falling gross margin could be price pressure, a product mix shift or purchase cost increases.

4. TallyPrime's Ratio Analysis

  1. Alt+G → Ratio Analysis shows principal groups (working capital, cash, debtors, creditors, stock, sales, gross and net profit) and ratios (current ratio, quick ratio, debt/equity, gross and net profit %, return on investment, receivables turnover in days, inventory turnover).
  2. Drill into any line to the underlying groups and ledgers.
  3. Accuracy depends on classification — misgrouped ledgers distort ratios (e.g. loans recorded as current liabilities).

Cheat sheet

Category Ratios
Profitability Gross margin, net margin, ROE
Liquidity Current ratio, quick ratio
Efficiency Debtor, inventory, creditor days; cash conversion cycle
Solvency Debt-to-equity, interest coverage
Tool Alt+G → Ratio Analysis

How It Actually Works

Ratios normalise financial statements so businesses of different sizes and periods can be compared. Efficiency ratios link the P&L to the Balance Sheet — revenue and cost flows against the stock, debtors and creditors needed to support them — which is where cash problems usually hide. Because every ratio is computed from grouped balances, sound grouping (Level 1) is the foundation of meaningful analysis.

Exercise

Using a company from earlier levels (or the sample figures), compute all ratios in the table, open TallyPrime's Ratio Analysis to compare, and write a one-page analysis: three strengths, three concerns and three specific actions (e.g. reduce inventory days by 15).