Syntha Lab RU

Loss map: where a brand loses money and how much of it can be recovered

From a list of loss lines (base, loss rate, the share that can really be recovered) calculates the loss of each line in money, its share in total losses and in revenue, compares losses with EBITDA, shows the concentration (the three main lines), the recoverable part and the EBITDA after recovery and, with a target margin, whether recovery closes the gap to the target. Ranks the lines by size so you start with the main one.

Revenue, profit and costs For whom: Owners and finance directors who want to see where money is lost and where to start recovering.

Calculate on your data →

At a glance

What question does it answer?
How much the brand loses by line, what part is recoverable, how it changes EBITDA and whether recovery is enough to reach the target.
What data is needed?
Revenue and EBITDA for the period from the management report.
How to read the result?
Example on the default values (revenue RUB 120 million, EBITDA 3.6m, 8 lines): losses RUB 20.4 million (17% of revenue, 5.7× EBITDA); the three main lines give 54%; RUB 8.02 million can be recovered and EBITDA rises to RUB 11.6 million (9.7%); at an 8% target recovery closes 134% of the gap. Example on the default values: Total losses: RUB 20.4 million; Losses in revenue: 17%; Losses to EBITDA: 5.7×; Main line: Price reductions deeper than planned · 21%. The figures are illustrative: enter your own to see your result.

Why and how to reason

The profit report shows the result but does not say where money goes past profit. The loss map collects such places in a list: each line has a base (the amount the loss refers to), a loss rate and a share that can really be recovered. The loss is the base times the rate: price reductions deeper than planned, RUB 36,000,000 of revenue with a discount and 12% losses give RUB 4,320,000. Lost sales are counted at gross margin: RUB 7,200,000 of lost revenue at 48% gives RUB 3,456,000. All eight lines give RUB 20,382,000, that is 17.0% of revenue and 5.7 times EBITDA. It is not a loss by the report but an order of magnitude of the money that goes past profit. Sorting in descending order shows concentration: the three main lines give 53.6% of the losses and that is where to start.

When to use it

Use it before a conversation about strategy and in a brand audit when you need to choose where to start improving and before a crisis plan. Do not use it as an accounting document: lines overlap because a deep discount and lost revenue can describe one situation and the sum gives an order, not an exact value. Assumption: recovery is estimated by an action plan, not by wish. For footwear and accessories stock and defects are usually larger, for children’s sizes and returns after the school season; change the set of lines for yourself.

How to read the result

Look at three things. First, losses to EBITDA: here 5.7 times, so each percent of recovery weighs a lot. Second, the main line and concentration: 53.6% in three lines means it is enough to focus on them. Third, the recoverable part: RUB 8,021,400 lift EBITDA from 3,600,000 to RUB 11,621,400, that is from 3.0% to 9.7%. At an 8% target the gap is RUB 6,000,000 and recovery closes it at 133.7%. If the coverage is below 100% recovery alone does not reach the target: price, assortment or cost structure are needed. Next turn each large line into a hypothesis in the register and calculate the return per hour.

Common mistakes

Typical errors: adding overlapping lines as independent and getting an overstated sum; setting the recoverable share at 80-100% “so it looks good”; taking a base other than the one the loss refers to (counting the discount on all revenue and not on revenue with a discount); starting with small lines because they are easier. An empty recoverable share is counted as zero.

What data is needed?

  • Revenue and EBITDA for the period from the management report.
  • For each line: the base, the loss rate and the recoverable share.
  • The target EBITDA margin.

Inputs

FieldUnitValue in the exampleMeaning
Revenue for the period excluding VAT₽120,000,000Revenue after returns for the period the losses belong to (usually the last 12 months). The example value is illustrative.
EBITDA for the period₽3,600,000Operating profit before depreciation from the management report for the same period; may be negative. The example value is illustrative.
Target EBITDA margin%8The margin you aim for. Empty: the comparison with the target is not calculated. The example value is illustrative.

How it is calculated

StepFormula
Loss of a lineloss = base × loss rate
Recoverable partrecovery = loss × recoverable share
Concentrationsort losses in descending order and count the cumulative share: Pareto
EBITDA afterEBITDA now + the sum of the recoverable parts
Comparison with the targetgap = target × revenue − EBITDA now; coverage = recovery ÷ gap

Worked numbers

Default values from the app; in the interactive version you enter your own.

Total losses
20.4 m ₽The sum of “base × loss rate” over all lines: not a loss by the report but money that goes past profit.
Losses in revenue
17 %
Losses to EBITDA
5.7×How many times the losses exceed profit: the larger, the dearer each percent of recovery.
Main line
Price reductions deeper than planned · 21 %
Share of the three main lines
53.6 %The higher it is, the more it is enough to focus on three lines.
Recoverable within a year
8.02 m ₽
Recoverable share of losses
39.4 %
EBITDA after recovery
11.6 m ₽
EBITDA margin now
3 %
EBITDA margin after recovery
9.7 %
Gap to the target EBITDA
6 m ₽Target margin × revenue − EBITDA now.
Recovery covers the gap
133.7 %
Losses and the recoverable part by line
Bar chart: Price reductions deeper than planned 4.32m, Sales lost to empty sizes (at gross margin) 3.46m, Dead stock: storage and cost of money 3.15m, Returns that did not go back to sale 3m, Advertising above the target share 2.88m, Platform deductions and fines beyond the contract 1.44m01m2m3m4m5mPrice reductions deeper than plannedPrice reductionsdeeper than plannedLoss: 4.32m4.32mRecoverable: 1.73m1.73mSales lost to empty sizes (at gross margin)Sales lost to emptysizes (at gross…Loss: 3.46m3.46mRecoverable: 1.21m1.21mDead stock: storage and cost of moneyDead stock: storageand cost of moneyLoss: 3.15m3.15mRecoverable: 1.58m1.58mReturns that did not go back to saleReturns that did notgo back to saleLoss: 3m3mRecoverable: 900k900kAdvertising above the target shareAdvertising abovethe target shareLoss: 2.88m2.88mRecoverable: 1.73m1.73mPlatform deductions and fines beyond the contractPlatform deductionsand fines beyond th…Loss: 1.44m1.44mRecoverable: 360k360kUnfavourable purchase rateUnfavourablepurchase rateLoss: 1.2m1.2mRecoverable: 240k240kDefects and claimsDefects and claimsLoss: 936k936kRecoverable: 281k281k₽
  • Loss
  • Recoverable
Data as a table
MeasureLossRecoverable
Price reductions deeper than planned4.32m1.73m
Sales lost to empty sizes (at gross margin)3.46m1.21m
Dead stock: storage and cost of money3.15m1.58m
Returns that did not go back to sale3m900k
Advertising above the target share2.88m1.73m
Platform deductions and fines beyond the contract1.44m360k
Unfavourable purchase rate1.2m240k
Defects and claims936k281k
From EBITDA now to EBITDA after recovery
Waterfall: EBITDA now 3.6m, Price reductions deeper than planned +1.73m, Sales lost to empty sizes (at gross margin) +1.21m, Dead stock: storage and cost of money +1.58m, Returns that did not go back to sale +900k, Advertising above the target share +1.73m, Platform deductions and fines beyond the contract +360k, Unfavourable purchase rate +240k02m4m6m8m10m12mEBITDA nowEBITDA nowEBITDA now: 3.6m3.6mPrice reductions deeper than plannedPrice reductionsdeeper than plannedPrice reductions deeper than planned: +1.73m+1.73mSales lost to empty sizes (at gross margin)Sales lost to emptysizes (at gross…Sales lost to empty sizes (at gross margin): +1.21m+1.21mDead stock: storage and cost of moneyDead stock: storageand cost of moneyDead stock: storage and cost of money: +1.58m+1.58mReturns that did not go back to saleReturns that did notgo back to saleReturns that did not go back to sale: +900k+900kAdvertising above the target shareAdvertising abovethe target shareAdvertising above the target share: +1.73m+1.73mPlatform deductions and fines beyond the contractPlatform deductionsand fines beyond th…Platform deductions and fines beyond the contract: +360k+360kUnfavourable purchase rateUnfavourablepurchase rateUnfavourable purchase rate: +240k+240kDefects and claimsDefects and claimsDefects and claims: +281k+281kEBITDA after recoveryEBITDA afterrecoveryEBITDA after recovery: 11.6m11.6m₽
  • positive
  • negative
  • total
Data as a table
StepChangeLevel
EBITDA now—3.6m
Price reductions deeper than planned+1.73m5.33m
Sales lost to empty sizes (at gross margin)+1.21m6.54m
Dead stock: storage and cost of money+1.58m8.11m
Returns that did not go back to sale+900k9.01m
Advertising above the target share+1.73m10.7m
Platform deductions and fines beyond the contract+360k11.1m
Unfavourable purchase rate+240k11.3m
Defects and claims+281k11.6m
EBITDA after recovery—11.6m

Loss map in descending order

LineBaseLoss rateLossShare of lossesCumulative shareRecoverable
Price reductions deeper than planned36 m ₽12 %4.32 m ₽21 %21 %1.73 m ₽
Sales lost to empty sizes (at gross margin)7.2 m ₽48 %3.46 m ₽17 %38 %1.21 m ₽
Dead stock: storage and cost of money9 m ₽35 %3.15 m ₽15 %54 %1.58 m ₽
Returns that did not go back to sale15 m ₽20 %3 m ₽15 %68 %900,000 ₽
Advertising above the target share14.4 m ₽20 %2.88 m ₽14 %82 %1.73 m ₽
Platform deductions and fines beyond the contract9.6 m ₽15 %1.44 m ₽7 %90 %360,000 ₽
Unfavourable purchase rate40 m ₽3 %1.2 m ₽6 %95 %240,000 ₽
Defects and claims62.4 m ₽1.5 %936,000 ₽5 %100 %280,800 ₽

Losses from different lines partly overlap (a deep discount and lost revenue may describe the same situation), so the sum gives an order of magnitude, not an exact figure. First take the main line where the recoverable share is high: it gives the most per hour of work. For footwear and accessories the main losses are more often in stock and defects, for children’s in sizes and returns after the school season.

Nuances and limits

  • Adding up overlapping lines as independent: the sum is overstated.
  • Taking the recoverable share as “wished” and not from an action plan.
  • Starting with small lines because they are easier.

Terms used

Calculate on your data →