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.
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
| Field | Unit | Value in the example | Meaning |
|---|---|---|---|
| Revenue for the period excluding VAT | ₽ | 120,000,000 | Revenue 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,000 | Operating profit before depreciation from the management report for the same period; may be negative. The example value is illustrative. |
| Target EBITDA margin | % | 8 | The margin you aim for. Empty: the comparison with the target is not calculated. The example value is illustrative. |
How it is calculated
| Step | Formula |
|---|---|
| Loss of a line | loss = base × loss rate |
| Recoverable part | recovery = loss × recoverable share |
| Concentration | sort losses in descending order and count the cumulative share: Pareto |
| EBITDA after | EBITDA now + the sum of the recoverable parts |
| Comparison with the target | gap = 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 %
- Loss
- Recoverable
Data as a table
| Measure | Loss | Recoverable |
|---|---|---|
| Price reductions deeper than planned | 4.32m | 1.73m |
| Sales lost to empty sizes (at gross margin) | 3.46m | 1.21m |
| Dead stock: storage and cost of money | 3.15m | 1.58m |
| Returns that did not go back to sale | 3m | 900k |
| Advertising above the target share | 2.88m | 1.73m |
| Platform deductions and fines beyond the contract | 1.44m | 360k |
| Unfavourable purchase rate | 1.2m | 240k |
| Defects and claims | 936k | 281k |
- positive
- negative
- total
Data as a table
| Step | Change | Level |
|---|---|---|
| EBITDA now | — | 3.6m |
| Price reductions deeper than planned | +1.73m | 5.33m |
| Sales lost to empty sizes (at gross margin) | +1.21m | 6.54m |
| Dead stock: storage and cost of money | +1.58m | 8.11m |
| Returns that did not go back to sale | +900k | 9.01m |
| Advertising above the target share | +1.73m | 10.7m |
| Platform deductions and fines beyond the contract | +360k | 11.1m |
| Unfavourable purchase rate | +240k | 11.3m |
| Defects and claims | +281k | 11.6m |
| EBITDA after recovery | — | 11.6m |
Loss map in descending order
| Line | Base | Loss rate | Loss | Share of losses | Cumulative share | Recoverable |
|---|---|---|---|---|---|---|
| Price reductions deeper than planned | 36 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 money | 9 m ₽ | 35 % | 3.15 m ₽ | 15 % | 54 % | 1.58 m ₽ |
| Returns that did not go back to sale | 15 m ₽ | 20 % | 3 m ₽ | 15 % | 68 % | 900,000 ₽ |
| Advertising above the target share | 14.4 m ₽ | 20 % | 2.88 m ₽ | 14 % | 82 % | 1.73 m ₽ |
| Platform deductions and fines beyond the contract | 9.6 m ₽ | 15 % | 1.44 m ₽ | 7 % | 90 % | 360,000 ₽ |
| Unfavourable purchase rate | 40 m ₽ | 3 % | 1.2 m ₽ | 6 % | 95 % | 240,000 ₽ |
| Defects and claims | 62.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.