Syntha Lab RU

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.

Revenue, profit and costs For whom: Owners and managers of a brand or retailer: a quick look at the business before deeper work by topic.

Calculate on your data →

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

FieldUnitValue in the exampleMeaning
Days in the perioddays365How many days in the compared periods; the periods must be of equal length.
VAT included in receivables%0Zero 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,000Revenue of the current period excl. VAT from the profit and loss report.
Cost of goods sold₽56,000,000Cost of goods sold of the current period excl. VAT.
Operating costs (optional)₽41,000,000Operating 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,000Average 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,000Average receivables for the current period. Optional. Empty: the field is ignored (counted as zero in sums).
Payables (optional)₽6,500,000Average payables for the current period. Optional. Empty: the field is ignored (counted as zero in sums).
Returns in money (optional)₽9,500,000The 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,000Stock 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,000Revenue of the previous period excl. VAT; empty if no comparison is needed.
Cost of goods sold₽48,000,000Cost of goods sold of the previous period excl. VAT. Optional. Empty: the field is ignored (counted as zero in sums).
Operating costs₽35,000,000Operating costs of the previous period. Optional. Empty: the field is ignored (counted as zero in sums).
Average stock at cost₽16,500,000Average stock at cost for the previous period. Optional. Empty: the field is ignored (counted as zero in sums).
Receivables₽7,000,000Average receivables for the previous period. Optional. Empty: the field is ignored (counted as zero in sums).
Payables₽6,000,000Average payables for the previous period. Optional. Empty: the field is ignored (counted as zero in sums).
Returns in money₽7,000,000The 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,000Old 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

StepFormula
Gross margin(Revenue − cost) ÷ revenue
TurnoverCost ÷ average stock
Days of stock, receivables, payablesDays ÷ turnover; receivables ÷ revenue × days; payables ÷ cost × days
Cash cycleDays 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 %
Diagnostics: margin, profitability and growth
Bar chart: Gross margin 53.3, Operating margin 19.2, Revenue growth 11.10102030405060Gross marginGross marginNow: 53.353.3Operating marginOperating marginNow: 19.219.2Revenue growthRevenue growthNow: 11.111.1%
Data as a table
MeasureNow
Gross margin53.3
Operating margin19.2
Revenue growth11.1

Indicators: now, before, change

IndicatorNowBeforeChangeVerdict
Gross margin53.3 %55.6 %−2.2 ppworse
Operating profitability19.2 %23.1 %−4 ppworse
Stock turnover2.72.9−0.2worse
Days of stock137 days125 days+11 daysworse
Receivable days27 days24 days+4 daysworse
Payable days42 days46 days−3 days—
Cash conversion cycle122 days104 days+18 daysworse
Returns to revenue7.9 %6.5 %+1.4 ppworse
Share of old stock22.9 %15.8 %+7.1 ppworse

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.

Terms used

Calculate on your data →