Financial condition: ratios, the Altman model with caveats and counterparty scoring
How to judge from the balance sheet and the income statement how liquid, stable and indebted a company is, what in the Altman model can be trusted and how to check a counterparty before a prepayment. The document answers: what limit of prepayment or deferral to give a factory, a distributor or a chain and which metrics to show the bank so as not to be refused over one weak ratio.
Why this document
A bank, an investor and a partner look at your ratios quickly and against a threshold: one metric below the threshold can end the conversation. At the same time you lose money on prepayments to factories and deferrals to chains without checking that the counterparty can pay. The finance director, a credit manager and the owner read this document before negotiations and before a large contract. It brings the ratios into one picture, explains how to read the Altman model value and why for Russia and for retail it cannot be taken as a verdict and gives a scoring card that turns risk signs into a limit.
At a glance
- What is this document and why is it needed?
- How to judge from the balance sheet and the income statement how liquid, stable and indebted a company is, what in the Altman model can be trusted and how to check a counterparty before a prepayment. The document answers: what limit of prepayment or deferral to give a factory, a distributor or a chain and which metrics to show the bank so as not to be refused over one weak ratio.
- Who owns the document and how often is it rebuilt?
- The finance director computes ratios quarterly and before talks with a bank; a credit manager and buying keep counterparty scoring before a contract and every six months; the owner sees the result.
- What mistakes are the most common?
- Reading the Altman value as a probability of bankruptcy → false panic or false calm → compute the trend over several dates and explain one-off causes. Taking “standard” thresholds → a bank refusal on a metric defined differently in the agreement → take definitions and thresholds from the agreement. Checking a counterparty once at signing → a year later it is a different company → review scoring every six months and on signals.
For whom
- Brand
- Brand: looks at its own liquidity and debt before a bank and an investor and applies scoring to factories (prepayment), fabric suppliers and wholesale buyers (deferral); the main danger is losing a prepayment to a factory and bad wholesale receivables.
- Retail
- Retailer: looks at liquidity taking stock and rent into account, at bank covenants and uses scoring for suppliers with prepayment and for franchisees; the main danger is dependence on a few brands and late rent.
What it consists of
Ratios: what to compute and how to read them
- Liquidity: current (current assets ÷ current liabilities), quick ((cash + receivables) ÷ current liabilities), cash (cash ÷ current liabilities); for a goods business the quick ratio matters more because stock sells slowly.
- Stability: equity to assets (autonomy), liabilities to equity; low autonomy means the company lives on other people’s money and is vulnerable to rate rises.
- Debt load: debt to EBITDA and interest cover (EBITDA to interest); in loan agreements these are often covenants so compute them by the bank’s definition.
- Turnover: turnover of stock, receivables and payables in days and the cash conversion cycle; stock growing faster than sales worsens liquidity before profit falls.
- Profitability: return on sales, assets and equity (the DuPont decomposition); falling profitability with growing assets points to an overloaded balance sheet.
- Thresholds are not statutory: Russia has no single mandatory values of liquidity and debt for a commercial company; thresholds come from bank agreements, company policy and comparable data.
- Brand: for a brand with production current assets include work in progress and materials, so the current ratio looks higher and the quick ratio shows the real cushion.
- Retailer: after FSBU 25 rent increases liabilities; look at debt with and without lease and bring the bank’s thresholds to one basis.
The Altman model: what you can and cannot do
- The model adds up five ratios (working capital, retained earnings, EBIT, equity to liabilities, revenue to assets) with weights and places the value in a safe, gray or distress zone.
- Variants: Z for public manufacturers, Z′ for private manufacturers, Z″ for non-manufacturers and trade (without the revenue to assets ratio), a separate Z″ version for emerging markets with a constant; each has its own zone bounds.
- Limits for Russia: the weights and bounds come from foreign samples, Russian retail and sewing have a different balance sheet structure, lease and seasonality; so the value is read as a signal and compared with your own trend.
- Traps: seasonal stock inflates working capital, a one-off loss lowers retained earnings and a change in lease accounting moves assets and liabilities; before concluding explain each cause.
- Brand: for a brand with its own workshop use Z′ and for a brand without production Z″; compute on three or four dates in a row and not on one.
- Retailer: for retail use Z″ and especially watch the trend of retained earnings and EBIT to assets: for chains they collapse first when rent rises and traffic falls.
Counterparty scoring and actions
- Signs of trouble: tax and contribution arrears, blocked accounts, mass lawsuits, a change of director and founders, a mass registration address, delayed replies and deliveries, a sharp rise in receivables and stock.
- The scoring card: ten questions with weights adding to 100 points; answers by documents and open information; the zone is green (from 80), yellow (60–79) and red (below 60), the bounds are yours and not statutory.
- The prepayment limit: the base limit is multiplied by the zone share (100% in green, 50% in yellow, 0% and payment on delivery or a bank guarantee in red); the limit is revised every six months and on a signal.
- Security: a bank guarantee, an owner’s surety, a pledge, a letter of credit, receivables insurance (see the insurance document); the weaker the counterparty the less trust and the more security.
- Brand: before a prepayment to a factory check capacity and loading by a visit, the share of your order in its output and whether an alternative factory exists; split the prepayment by stages.
- Retailer: before prepaying a supplier and before a franchise check payment discipline, dependence on one customer and court cases; for a brand supplier check the right to the trademark.
Brand and retailer: what the bank and the partner look at
- Brand: the bank looks at stock and wholesale receivables: receivables growing faster than revenue and a longer payment period at chains read as a hidden sales problem.
- Brand: when assessing a wholesale buyer look not only at the balance sheet but also at the payment history with you and other suppliers; statements lag and payment history does not.
- Brand: for a factory look at loading and dependence on one customer: a factory where you are 60% of output depends on you and you on it.
- Brand: compute metrics before and after the season: before the season stock is at its maximum and after it receivables are high; one date misleads.
- Retailer: the bank looks at the share of rent in revenue, lease liabilities and like-for-like sales; a chain with falling LFL and rising rent loses in scoring faster than the rest.
- Retailer: when checking a brand supplier look at dependence on one chain and the share of your store in its wholesale sales; your status for it affects price and terms.
- Retailer: for franchisees check payment discipline on royalties and purchases and the state of the point; they give the early signals of network problems.
- Retailer: a chain’s liquidity rests on daily revenue so interruptions in acquiring or the cash register matter more than quarterly ratios; include them in the risks.
Where the data comes from
| Data source | Fields |
|---|---|
| Balance sheet and income statement for 3-4 dates | cash, receivables, inventory, liabilities, equity, revenue, EBIT, EBITDA, interest |
| Loan agreements | definitions of debt and EBITDA, covenant thresholds |
| Open information on the counterparty and court databases | cases, tax debts, changes of management, age |
| Your history of settlements with the counterparty | delays, disputes, returns, meeting deadlines |
How to build it step by step
- Step 1: Collect the balance sheet and income statement for three or four dates in a row and bring them to one accounting basis (with lease under the standard or without).
- Step 2: Compute liquidity, stability, debt to EBITDA and interest cover and compare with your thresholds and the bank’s.
- Step 3: Choose the Altman variant by the type of company and compute on all dates; look at the direction and not at one number.
- Step 4: Explain each sharp change (season, one-off loss, change of accounting) in a note to the numbers so that the bank does not guess.
- Step 5: For a counterparty fill in the ten-question card from documents and not from words and compute the score and the zone.
- Step 6: Set the limit by zone and choose security; record the decision and the review date.
- Step 7: Set early-warning signals (late payment, new lawsuits, a change of director) and an action for each: a pause in shipping, a limit cut, a demand for security.
- Step 8: At the first signs of trouble at a counterparty collect evidence (correspondence, acts, delivery notes), cut the limit and consult a lawyer about measures (see the bankruptcy document).
Formulas
| Measure | Formulas | Note |
|---|---|---|
| Z″ for trade and non-manufacturing companies | Z″ = 6.56·X1 + 3.26·X2 + 6.72·X3 + 1.05·X4 | X1 = (current assets − current liabilities) ÷ assets; X2 = retained earnings ÷ assets; X3 = EBIT ÷ assets; X4 = equity ÷ liabilities; zones: above 2.6, 1.1 to 2.6, below 1.1. |
| Quick ratio | Quick = (Cash + Receivables) ÷ Current liabilities | Take receivables without bad ones. |
| Debt to EBITDA | Debt ÷ EBITDA = Loans and borrowings ÷ EBITDA for 12 months | Take the definitions of debt and EBITDA from the agreement. |
| Prepayment limit | Limit = Base limit × Zone share | The zone shares are yours: 100%, 50%, 0%. |
Formulas in notation
- Altman Z″
Z = 6.56·X1 + 3.26·X2 + 6.72·X3 + 1.05·X4
X1: working capital to assets; X2: retained earnings to assets; X3: EBIT to assets; X4: equity to liabilities. Zones: above 2.6 safe, 1.1 to 2.6 gray, below 1.1 distress.- Limit by score
L = B · s(S), s = 1 if S ≥ 80; 0.5 if 60 ≤ S < 80; 0 otherwise
B: the base limit; S: the sum of points; the zone shares are illustrative.
Worked example
A brand and a retailer: ratios and Z″ on illustrative data, counterparty scoring
| Metric | Brand | Retailer |
|---|---|---|
| Current ratio | 1.78 | 1.53 |
| Quick ratio | 0.65 | 0.48 |
| Equity to assets, % | 41.1 | 35.7 |
| Debt to EBITDA | 1.36 | 1.33 |
| Interest cover | 7.00 | 6.67 |
| Z″ (Altman) | 4.80 | 3.60 |
| Counterparty scoring: points of 100 | 73 | |
| Base prepayment limit, RUB | 2,000,000 | |
| Limit by zone, RUB | 1,000,000 |
The inputs are illustrative (brand: assets 112 m RUB, retailer 140 m RUB); the thresholds and scoring zones are yours. The example scoring: the counterparty scored on seven of ten questions and fell in the yellow zone: the prepayment is half of the base limit.
Figures
- Brand
- Retailer
Data as a table
| Measure | Brand | Retailer |
|---|---|---|
| Working capital | 2.11 | 1.55 |
| Retained earnings | 0.7 | 0.7 |
| EBIT to assets | 1.26 | 0.77 |
| Equity to liabilities | 0.73 | 0.58 |
Contribution of factors to Z″: brand and retailer. It shows which factor drives the value: for the retailer the contributions of working capital and EBIT to assets are weaker, retained earnings to assets are the same for both companies.
- Quick ratio, ×
- Equity to assets, share
Data as a table
| Quarter | Quick ratio, × | Equity to assets, share |
|---|---|---|
| I | 1.4 | 0.45 |
| II | 1.2 | 0.42 |
| III | 1 | 0.38 |
| IV | 0.8 | 0.33 |
| V | 0.6 | 0.28 |
A counterparty’s trend over five dates: quick ratio and autonomy. An illustrative counterparty: the metrics fall for five periods in a row and that matters more than the value on one date. The quick ratio threshold in the example is 1.
- positive
- negative
- total
Data as a table
| Step | Change | Level |
|---|---|---|
| Maximum | +100 | 100 |
| Current ratio above your threshold | −10 | 90 |
| Payments to you run with no delays of ov… | −10 | 80 |
| One customer gives less than half of rev… | −7 | 73 |
| Total | — | 73 |
The scoring card: from 100 points to a counterparty’s total. Each criterion not met subtracts its weight; the total determines the zone and the prepayment limit.
Specifics by category
- Apparel
- Apparel: two seasons give jumps of stock and receivables within the year; compare metrics at the same seasonal date of the year otherwise liquidity will look random.
- Footwear
- Footwear: stock is longer and costlier and the share of dead stock higher; the current ratio is overstated, the quick ratio shows reality and the reserve for stock write-down must be considered before the calculation.
- Accessories
- Accessories: stock turns faster and liabilities are smaller; the metrics are more stable but for an importer counterparty look at foreign-currency liabilities and exchange differences.
- Kids
- Kids: a peak in late summer and before New Year and a high share of returns; check supplier scoring for certification compliance otherwise goods can be lost at customs or in the store.
- Men
- Men: a stable base and long contracts; bankruptcy models catch deterioration well when crises are slow but one-off losses are better explained in advance.
- Women
- Women: a short cycle and a high share of sales; for counterparties with a lot of stock clearance look at whether the share of price-cut sales is growing and gross margin falling.
Common mistakes
- Reading the Altman value as a probability of bankruptcy → false panic or false calm → compute the trend over several dates and explain one-off causes.
- Taking “standard” thresholds → a bank refusal on a metric defined differently in the agreement → take definitions and thresholds from the agreement.
- Checking a counterparty once at signing → a year later it is a different company → review scoring every six months and on signals.
- Prepaying a factory without a visit and without stages → the whole amount is lost on a failure → split the prepayment and check capacity.
- Not comparing on one basis of lease accounting → liquidity and debt look worse or better than competitors’ → bring periods to one basis.
Russian specifics
- There are no single mandatory liquidity and debt load standards for commercial organizations in Russia: thresholds are set by banks in agreements and by the company itself.
- The Altman model was built on foreign samples; the zone bounds for Russian companies are not checked and are a reference: use it as a signal next to your own metrics.
- Brand: use counterparty data from open databases (tax debts, cases, managers) in line with the personal data law 152-FZ and in good faith; take the prepayment decision on the whole. Rule: Law 152-FZ of 27.07.2006: Federal Law of 27.07.2006 No. 152-FZ on personal data.
- Retailer: when checking suppliers and franchisees record the result and the date; it is the basis for the limit and for evidence if a dispute goes to court.
- Mandatory audit and disclosure of statements for various organizations are set by law; check whether your company must undergo an audit before relying on a counterparty’s confirmed statements.