Build the dashboard around decisions
Use the dashboard to answer four questions: what cash is available, can the business meet its debt service, what drives returns, and what could break the plan? Tie each metric to a reporting date, a source, an owner and an action. Use trends and forecast ranges rather than treating the current bank balance as a liquidity forecast.
| View | Metrics | Decision |
|---|---|---|
| Liquidity | Current and quick ratios, ageing, cash conversion cycle and rolling cash forecast | Prioritise collections, purchases and near-term payments. |
| Debt service | Debt service coverage ratio (DSCR), facility headroom, repayment dates and covenant definitions | Identify refinancing or lender discussion needs early. |
| Profitability | Margins, asset turnover, leverage and return on equity (ROE) | Separate operating performance from financing effects. |
| Stress | Cash conversion, scenario tests and optional distress models | Track early warning indicators and validate them against actual evidence. |
Dashboard targets are internal choices or agreed covenant levels, not universal thresholds. Keep statutory Schedule III ratio disclosures separate, using the applicable division and documented numerator and denominator. The relevant 2021 amendment requires disclosure of specified ratios and explanations for movements of more than 25% compared with the preceding year where applicable.
Use consistent definitions
Current ratio is current assets divided by current liabilities. Define quick assets explicitly, for example unrestricted cash, readily marketable investments and eligible short-term receivables, excluding inventories, prepayments and other amounts that cannot readily be used to settle liabilities. Check overdue and disputed balances even if included in the accounting ratio. Do not confuse a cash-conversion cycle with a cash forecast: DSO plus DIO less DPO uses period averages and compatible revenue, cost and purchase measures.
The five-step DuPont identity is PAT ÷ EBT × EBT ÷ EBIT × EBIT ÷ sales × sales ÷ average assets × average assets ÷ average equity. The intermediate amounts cancel to PAT ÷ average equity when definitions and periods match and the denominators are non-zero. Use consistent ownership attribution and investigate distortions from negative or small denominators. EBT ÷ EBIT reflects the effect of the bridge from EBIT to EBT, which can include items other than interest.
Seven worked dashboard cases
1. Profitable manufacturer with a near-term cash gap
Sales of ₹48 crore and PAT of ₹3.20 crore imply a 6.67% net margin. With ₹22 crore current liabilities, assume ₹31.90 crore current assets and ₹12.76 crore quick assets; the ratios are 1.45x and 0.58x. The ₹8.40 crore slow inventory is only one part of the non-quick balances. Two vendor cheques of ₹45 lakh in total need a separate cash forecast. If average receivables are ₹12.36 crore and all ₹48 crore sales are credit sales on a 365-day convention, DSO is about 94 days. With independently calculated DIO of 118 days and DPO of 42, the cash conversion cycle is 170 days. DPO does not establish compliance with supplier-specific deadlines. For a qualifying micro or small supplier, MSMED Act section 15 requires payment by the agreed written date, subject to a maximum of 45 days from acceptance or deemed acceptance; if there is no written agreement, payment is due before the appointed day. Monitor this invoice by invoice and assess any tax consequence separately.
If ₹4.50 crore of eligible invoices settle within seven days at a 1.5% cash discount, the discount is ₹6.75 lakh and cash received ₹4.4325 crore. Converting receivables already counted as quick assets does not by itself improve the quick ratio, although it can make cash available for payroll and suppliers. Model inventory sales, liability repayments and refinancing separately before forecasting a ratio change.
2. Distributor growth and the DuPont bridge
Sales rise from ₹30 crore to ₹75 crore. The five supplied inputs produce the following returns; displayed figures are rounded.
| Factor | FY 2022 | FY 2024 |
|---|---|---|
| EBIT margin | 8.50% | 4.20% |
| Sales / average assets | 2.10x | 2.35x |
| EBT / EBIT | 88.0% | 68.0% |
| PAT / EBT | 74.8% | 74.8% |
| Average assets / average equity | 1.38x | 4.22x |
| ROE | 16.21% | 21.19% |
Return rises even though the EBIT margin and interest-burden factor weaken. Higher asset turnover helps and greater leverage is the larger offset. Do not assert that a 2% sales decline or one percentage point of higher interest wipes out profit without modelling margins, debt amounts and repricing.
3. Solar contractor: DSCR under a stated agreement
Assume ₹18 crore term facilities and ₹12 crore bank guarantee facilities. A hypothetical agreement defines cash available for debt service as ₹7.80 crore EBITDA less ₹1.10 crore tax, or ₹6.70 crore. Scheduled principal of ₹3.60 crore and forecast interest of ₹1.65 crore on term debt and ₹0.85 crore on working capital give ₹6.10 crore service. DSCR is 1.10x, below the assumed 1.40x requirement. The forecasts reflect expected drawn balances; facility limits are not the interest base and guarantees are not automatically drawn loans.
If a lender-approved reprofiling changes forecast service to ₹2.40 crore principal plus ₹1.55 crore term and ₹0.50 crore working capital interest, total service is ₹4.45 crore. At unchanged cash available, DSCR is 1.51x. Confirm the covenant definition, remedy and actual approval. Do not infer automatic supervisory classification or penalty from this projection.
4. A private manufacturer’s Altman Z′ screen
The private-manufacturer version is Z′ = 0.717 × working capital / assets + 0.847 × retained earnings / assets + 3.107 × EBIT / assets + 0.420 × book equity / total liabilities + 0.998 × sales / assets. It is different from the original public-company model and the variants for other sectors or emerging markets.
Using assets ₹26 crore, current assets ₹11 crore, current liabilities ₹12.80 crore, retained earnings ₹2.10 crore, EBIT ₹1.55 crore, book equity ₹4.80 crore, liabilities ₹21.20 crore and sales ₹42 crore gives Z′ of 1.91. Against the commonly cited 1.23 and 2.90 boundaries for this version, it is in the intermediate band. This is a statistical screening score, not a calibrated probability of default or a legal insolvency test. If ₹3 crore fresh cash equity is added and ₹4 crore of current debt can actually be reclassified as long term, holding all other inputs constant, assets become ₹29 crore, current assets ₹14 crore, current liabilities ₹8.80 crore and equity ₹7.80 crore. The resulting score is 1.96, still in the intermediate band.
5. Hospital cash conversion
On ₹55 crore sales and ₹11 crore EBITDA, the EBITDA margin is 20%. At ₹3.135 crore cash from operations, cash conversion is 28.5%. If insurance claim files fall from ₹8.20 crore to ₹2.10 crore, the queue falls by ₹6.10 crore; establish how much reflects collections rather than rejected or adjusted claims. At unchanged EBITDA, 84% conversion would require ₹9.24 crore operating cash. Reconcile reported cash from operations to working capital, taxes and other cash-flow adjustments; EBITDA and cash from operations are different measures.
6. Fleet break-even distance
For 75 trucks, annual fixed cash costs of ₹12.50 crore average ₹1,04,16,666.67 per month. At ₹52 per vehicle kilometre revenue and ₹34.50 variable cost, contribution is ₹17.50 or 33.65% of revenue. Monthly break-even is approximately 5,95,238.10 fleet kilometres; at least 5,95,239 whole fleet kilometres, or about 7,937 per truck if equally allocated and rounded up. Keep cash and accounting break-even separate if the fixed amount includes debt principal. A target of 8,000 km per truck is not a universal threshold. If 6,500 km have already been driven by day 20 in a 30-day month, a simple linear projection is 9,750 km; adjust for dispatch plans and the actual pattern instead of issuing an automatic alert.
7. Industrial valve margin bridge
Per ₹100 net sales, subtract materials and machine power ₹58, outbound freight and damage ₹6.50, rework and warranty ₹4.80, commissions and rebates ₹5.20, factory overhead and depreciation ₹11.50, administration ₹4.20, and financing ₹4.80. For this management illustration the ₹42 after materials and power is a contribution subtotal, not necessarily statutory gross profit. Use ₹5.20 only for costs or commercial deductions not already reflected in the ₹100 base. The subtotal before income tax is ₹5. At an assumed effective rate of 25.168% and no other adjustments, tax is approximately ₹1.26 and PAT ₹3.74. Freight/damage, rework/warranty and financing total ₹16.10. If validated warranty and freight savings are ₹9.50 and extra costs are ₹1.20, the net improvement before tax is ₹8.30. At the same tax rate, ₹13.30 pre-tax becomes approximately ₹9.95 PAT per ₹100, before other changes.
Keep the dashboard auditable
Reconcile ratios to approved ledgers, ageing reports, facility terms and forecasts. Show period and definition on each card. Do not set one healthy cash-conversion or leverage range across industries. Review large movements, near-term obligations and assumptions alongside each ratio. Where data is available in assureFinancials, use it to organise the calculations and reconcile any imports to source records before reporting.
Sources
- MCA: Schedule III ratio disclosures, G.S.R. 207(E)
- MCA: Ind AS 7, Statement of Cash Flows
- India Code: MSMED Act, 2006, sections 2 and 15
- NYU Stern: reference for private manufacturer Z′ coefficients and boundaries
- Altman and Hotchkiss: Corporate Financial Distress, Restructuring, and Bankruptcy, private manufacturer Z′ model