Quick business check: two periods
From basic figures of two periods calculates gross margin, operating profitability, turnover, days of inventory, receivables and payables, the cash cycle, the share of returns and old stock and shows which way each moved.
At a glance
- What question does it answer?
- How the main indicators of the business changed against the previous period and where to look for a problem.
- What data is needed?
- Revenue and cost of goods sold for the current period.
- How to read the result?
- There are no universal norms: look at the direction of change, not a comparison with a “norm”. Work through the worsened indicators by the platform’s topics; also compare them with competitors of your format. Example on the default values: Revenue of RUB 120m against RUB 108m (+11.1%), gross margin 53.3%, operating margin 19.2% and a cash cycle of 121.9 days. Eight indicators worsened, among them gross margin, stock turnover and returns to revenue. If stock and cash worsened, start with their topics: “Stock and turnover” and “Cash and working capital”. Next: “Cash conversion cycle and working capital” and “Stock age and price-reduction provision”.
Why and how to reason
The express diagnostic assembles about ten indicators that together describe the health of a business and compares two periods to see the direction. The idea: profitability (gross margin, operating margin), stock efficiency (turnover, days), cash (receivable days, payable days, conversion cycle), quality (returns, old stock), growth.
Each indicator is computed from basic figures, and none says enough alone. Revenue growth with falling margin can be worse than no growth. A lengthening cash cycle means growth “eats” cash.
Example. Revenue RUB 120 m against 108 last year (+11.1%). Gross margin 53.3% against 55.6%: down 2.2 points. Operating margin (120 - 56 - 41) / 120 = 19.2%. Days of inventory 137, receivables 27, payables 42, cycle 122 days. Growth here was bought with discounts and stock.
When to use it
Use it quarterly or yearly for a general review and for conversations with owners, a bank, an investor. It helps understand where to dig deeper. Assumption: data of the two periods are computed the same way. For seasonal businesses compare like periods. It does not replace detailed calculations: the diagnostic only points to problem areas. Compare periods of equal length. Also suitable for a conversation with a bank.
How to read the result
Go by groups. Profitability: has gross margin fallen and why (prices, discounts, buying). Stock: have days of inventory grown faster than sales. Cash: has the cycle lengthened. Quality: have returns and old stock grown. If several indicators worsened at once, the cause is common, for example excessive buying and discounts. Decision: for each worsened indicator open the corresponding calculation (GMROI, stock age, cash conversion cycle) and find the cause. For each indicator note the direction (better or worse) and one likely cause; then choose the two or three most important and assign their analysis to specific people. A diagnostic without owners of indicators remains a picture.
Common mistakes
Typical trap: comparing periods of different length; valuing stock differently; including one-off income in revenue; ignoring the direction of change when looking at absolute values. Also: judging health by one indicator. Also: comparing with others' norms without considering business model, scale and season.
What data is needed?
- Revenue and cost of goods sold for the current period.
- Optionally: operating costs, average stock, receivables, payables, returns, old stock.
- The same figures for the previous period for comparison.
- Where to take it: two periods of equal length from the profit and loss report and the balance sheet (1C, accounting): revenue, cost, expenses, average stock (an average over dates, not a balance), receivables, payables, returns and old stock by age. Fill the “current” column, then “previous”; leave optional rows blank, not zero.
Inputs
| Field | Unit | Value in the example | Meaning |
|---|---|---|---|
| Days in the period | days | 365 | How many days in the compared periods; the periods must be of equal length. |
| VAT included in receivables | % | 0 | Zero if receivables are net of VAT or you are not a VAT payer. If they include VAT, enter the rate so net revenue is compared with net receivables; otherwise receivable days are overstated. Optional. Empty: the field is ignored (counted as zero in sums). |
| Revenue | ₽ | 120,000,000 | Revenue of the current period excl. VAT from the profit and loss report. |
| Cost of goods sold | ₽ | 56,000,000 | Cost of goods sold of the current period excl. VAT. |
| Operating costs (optional) | ₽ | 41,000,000 | Operating costs of the current period: rent, staff, marketing, other. Optional. Empty: the field is ignored (counted as zero in sums). |
| Average stock at cost (optional) | ₽ | 21,000,000 | Average stock at cost for the current period: the mean over dates, not a balance on one date. Optional. Empty: the field is ignored (counted as zero in sums). |
| Receivables (optional) | ₽ | 9,000,000 | Average receivables for the current period. Optional. Empty: the field is ignored (counted as zero in sums). |
| Payables (optional) | ₽ | 6,500,000 | Average payables for the current period. Optional. Empty: the field is ignored (counted as zero in sums). |
| Returns in money (optional) | ₽ | 9,500,000 | The amount of returns in money for the current period. Optional. Empty: the field is ignored (counted as zero in sums). |
| Old stock at cost (optional) | ₽ | 4,800,000 | Stock older than the age you choose, at cost, at the end of the current period. Optional. Empty: the field is ignored (counted as zero in sums). |
| Revenue | ₽ | 108,000,000 | Revenue of the previous period excl. VAT; empty if no comparison is needed. |
| Cost of goods sold | ₽ | 48,000,000 | Cost of goods sold of the previous period excl. VAT. Optional. Empty: the field is ignored (counted as zero in sums). |
| Operating costs | ₽ | 35,000,000 | Operating costs of the previous period. Optional. Empty: the field is ignored (counted as zero in sums). |
| Average stock at cost | ₽ | 16,500,000 | Average stock at cost for the previous period. Optional. Empty: the field is ignored (counted as zero in sums). |
| Receivables | ₽ | 7,000,000 | Average receivables for the previous period. Optional. Empty: the field is ignored (counted as zero in sums). |
| Payables | ₽ | 6,000,000 | Average payables for the previous period. Optional. Empty: the field is ignored (counted as zero in sums). |
| Returns in money | ₽ | 7,000,000 | The amount of returns in money for the previous period. Optional. Empty: the field is ignored (counted as zero in sums). |
| Old stock at cost | ₽ | 2,600,000 | Old stock at cost at the end of the previous period. Optional. Empty: the field is ignored (counted as zero in sums). |
How it is calculated
| Step | Formula |
|---|---|
| Gross margin | (Revenue − cost) ÷ revenue |
| Turnover | Cost ÷ average stock |
| Days of stock, receivables, payables | Days ÷ turnover; receivables ÷ revenue × days; payables ÷ cost × days |
| Cash cycle | Days of stock + receivable days − payable days |
Worked numbers
Default values from the app; in the interactive version you enter your own.
- Gross margin
- 53.3 %
- Operating profitability
- 19.2 %
- Cash conversion cycle
- 122 days
- Revenue growth
- 11.1 %
Data as a table
| Measure | Now |
|---|---|
| Gross margin | 53.3 |
| Operating margin | 19.2 |
| Revenue growth | 11.1 |
Indicators: now, before, change
| Indicator | Now | Before | Change | Verdict |
|---|---|---|---|---|
| Gross margin | 53.3 % | 55.6 % | −2.2 pp | worse |
| Operating profitability | 19.2 % | 23.1 % | −4 pp | worse |
| Stock turnover | 2.7 | 2.9 | −0.2 | worse |
| Days of stock | 137 days | 125 days | +11 days | worse |
| Receivable days | 27 days | 24 days | +4 days | worse |
| Payable days | 42 days | 46 days | −3 days | — |
| Cash conversion cycle | 122 days | 104 days | +18 days | worse |
| Returns to revenue | 7.9 % | 6.5 % | +1.4 pp | worse |
| Share of old stock | 22.9 % | 15.8 % | +7.1 pp | worse |
Worsened: Gross margin, Operating profitability, Stock turnover, Days of stock, Receivable days, Cash conversion cycle, Returns to revenue, Share of old stock. Work through them by topic: stock — “Stock and turnover”, cash — “Cash and working capital”, margin — “Revenue, profit and costs”. There are no “norms” here: compare with yourself earlier and with your closest competitors.
Nuances and limits
- Use average stock, not a date balance, especially in a seasonal business.
- Periods must be comparable: one season with the same season of last year.