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¶
- P&L: revenue growth, gross margin, operating expenses, net profit.
- Balance Sheet: working capital (current assets − current liabilities), debt, equity.
- Cash flow (Alt+G → Cash Flow / Funds Flow): cash from operations vs profit — profitable businesses can still run out of cash.
- 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¶
- A quick ratio below 1 means the business depends on selling stock to pay short-term debts.
- 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.
- Compare with industry norms and the business's own history; ratios mean little in isolation.
- 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¶
- 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).
- Drill into any line to the underlying groups and ledgers.
- 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).