Syntha Lab RU

Inventory write-down: cost against net realizable value

For stock groups compares cost with net realizable value (expected price less costs to sell), calculates the write-down, stock at the lower of the two and how much to add to the reserve already created.

Stock and turnover For whom: Finance directors, chief accountants and stock managers when valuing closing stock.

Calculate on your data →

At a glance

What question does it answer?
How much stock is worth less than its recorded cost and how much reserve must be added.
What data is needed?
By group: quantity, unit cost, expected unit price excl. VAT.
How to read the result?
On the default data (three groups, stock at cost 7,260,000) the write-down is 1,542,000, which is 21.2% of stock; 2 of 3 groups are written down. The most is on outerwear of the past season: 990,000 (net realizable value 2,340 against cost 3,000). Footwear leftovers 552,000. Stock at the lower of the two 5,718,000. With a reserve already created of 600,000 add 942,000. Example on the default values: Stock at cost: RUB 7.26 million; Write-down required: RUB 1.54 million; Write-down share of stock: 21.2%; Stock at the lower of cost and NRV: RUB 5.72 million. The figures are illustrative: enter your own to see your result.

Why and how to reason

Stock in the accounts is shown at the lower of two valuations: cost and net realizable value (NRV). Net price is what you will receive on sale, less the costs of selling. If it is below cost, part of the value is already lost and has to be recognized as a provision. Example: last season’s outerwear, cost 3,000, expected price 2,600, selling costs 10%. NRV equals 2,600 × 0.9 = 2,340, provision per unit 660, for 1,500 units 990 thousand. Knitwear with a price above cost needs no provision, and footwear leftovers give another 552 thousand. The total is 1.54 million on stock of 7.26 million. 600 thousand has already been created, so 942 thousand needs to be added.

When to use it

It comes in handy before closing a period and when reviewing the provisioning policy. It does not replace accounting policy or the accountant’s decision: rules and methods are set by standards and your documents, check them against the current text. Assumptions: one selling price per group, selling costs given as a percentage and per unit, previous provisions entered by you. It also helps plan clearance: it shows at what price the provision disappears, and so where a markdown adds no loss.

How to read the result

Look at three numbers. Compare the provision required (1.54 million) with what is already created: adding 942 thousand means stock was valued higher than it should be. The share of provision in stock (21%) shows the scale of the problem; if it rises from period to period, change buying, not the provision. Stock at the lower of valuations (5.72 million) is the sum that can be shown in the accounts. If the provision is excessive (a minus sign), it needs to be reduced, but under the rules and with justification. It is worth matching the result with the clearance and buying plans: the provision tells which group should be sold first.

Common mistakes

The usual mistakes: taking the expected price with VAT, not subtracting selling costs, computing the provision by group instead of each lot where prices differ widely, using the retail price before markdowns. If part of the stock went to clearance after the date of calculation, use actual prices.

What data is needed?

  • By group: quantity, unit cost, expected unit price excl. VAT.
  • Costs to sell: a percentage of price and money per unit.
  • The reserve already created at the calculation date.

Inputs

FieldUnitValue in the exampleMeaning
Reserve already created₽600,000The reserve balance in the books at the calculation date. Empty: 0. The example value is illustrative. Agree the accounting treatment with your accountant.

How it is calculated

StepFormula
Net realisable value (NRV)price × (1 − costs %) − costs per unit
Write-down per unitmax(0; cost − NRV)
Group write-downwrite-down per unit × quantity
To addtotal write-down − reserve already created

Worked numbers

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

Stock at cost
7.26 m ₽
Write-down required
1.54 m ₽Sum by group: max(0; cost − NRV) × quantity.
Write-down share of stock
21.2 %
Stock at the lower of cost and NRV
5.72 m ₽
Groups with a write-down
2
Add to the reserve created (minus: excess)
942,000 ₽
Largest write-down
990,000 ₽ · Outerwear of the past season

Stock groups

GroupQuantityCostNRV per unitWrite-downStock after write-down
Outerwear of the past season1,5004.5 m ₽2,340 ₽990,000 ₽3.51 m ₽
Core knitwear8001.44 m ₽2,610 ₽0 ₽1.44 m ₽
Footwear, leftovers6001.32 m ₽1,280 ₽552,000 ₽768,000 ₽

2 of 3 groups are written down: a reserve of 1.54 m ₽ on stock of 7.26 m ₽. Already created 600,000 ₽, to add 942,000 ₽.

The calculation shows the order of magnitude under the rule “the lower of cost and net realisable value”. The timing and procedure for creating the reserve, the tax effect and the accounting policy are set by you with your accountant. Price and costs to sell are your estimates; amounts excl. VAT.

Nuances and limits

  • Take the price after the markdown plan, not the list price: otherwise the reserve is invisible.
  • Costs to sell are your estimates: commission, handling and delivery reduce the net price.
  • Assess footwear, children’s and accessories as separate groups: they have their own timing and depth of clearance.
  • The accounting of the reserve and the tax effect are set with your accountant.

Terms used

Calculate on your data →