Inventory Write-Down Calculator

Calculate inventory write-down amounts when net realizable value drops below book value. Determine the impact on COGS and financial statements.

Write-Down per Unit
$7.00
NRV is 0.72% of book value
Total Write-Down
$3,500.00
Charge to COGS or inventory loss
Net Loss After Salvage
$2,000.00
$4.00 per unit after recovery
Salvage Recovery
$1,500.00
Recovers 0.43% of write-down
Original Carrying Value
$12,500.00
500.00 units at $25.00 each
New Carrying Value
$9,000.00
Write-down is 0.28% of original

Value Waterfall

Original Value
$12,500.00
Write-Down
$3,500.00
Salvage Recovery
$1,500.00
Net Loss
$2,000.00
New Carrying
$9,000.00

NRV Sensitivity Analysis

NRV / UnitWrite-Down / UnitTotal Write-DownNet Loss% of Book
$0.00$25.00$12,500.00$11,000.001.00%
$6.25$18.75$9,375.00$7,875.000.75%
$12.50$12.50$6,250.00$4,750.000.50%
$18.75$6.25$3,125.00$1,625.000.25%
$25.00$0.00$0.00-$1,500.000.00%

Typical Write-Down Rates by Category

CategoryAvg Annual Write-Down %Common ReasonsSalvage Rate
Electronics / Tech5-15%Obsolescence, model changes10-25%
Perishable / Food2-8%Expiry, spoilage, damage0-5%
Apparel / Fashion10-25%Seasonal, trend shifts15-40%
Industrial / Parts2-5%Slow-moving, design changes20-50%
General Merchandise3-10%Market decline, overstock10-30%
Planning notes, formulas, and examples

About the Inventory Write-Down Calculator

An inventory write-down is required when the net realizable value (NRV) of inventory falls below its book (carrying) value. Under both US GAAP (ASC 330) and IFRS (IAS 2), companies must report inventory at the lower of cost or net realizable value, recognizing any shortfall as a loss.

Write-downs commonly occur due to price erosion, damage, obsolescence, or changes in customer demand. The write-down amount equals the difference between book value and NRV multiplied by the number of units affected.

This calculator helps you determine the total write-down amount for a given inventory item or lot. Enter the book value per unit, the estimated NRV per unit, and the number of units to see the total adjustment and its impact on the income statement.

Use the result to compare operating scenarios, pressure-test assumptions, and rerun the model when volumes, rates, or service targets change.

When This Page Helps

Failing to write down impaired inventory overstates assets and profits. This calculator ensures you recognize the correct loss amount, supporting compliance with accounting standards and giving management accurate data for pricing, purchasing, and disposal decisions.

How to Use the Inputs

  1. Enter the book (carrying) value per unit of the inventory item.
  2. Enter the estimated net realizable value (NRV) per unit.
  3. Enter the number of units affected.
  4. Review the write-down per unit and total write-down amount.
  5. Record the adjustment as a charge to COGS or a separate loss line item.
  6. Reassess NRV at each reporting date and reverse if values recover (IFRS only).
Formula used
Write-Down per Unit = Book Value − NRV (if Book Value > NRV, otherwise 0) Total Write-Down = Write-Down per Unit × Units Affected New Carrying Value = NRV × Units

Example Calculation

Result: Total Write-Down = $3,500

Write-down per unit = $25 − $18 = $7. Total = $7 × 500 = $3,500. The inventory carrying value is reduced from $12,500 to $9,000, and $3,500 is charged to COGS or a loss account.

Tips & Best Practices

  • NRV = estimated selling price minus estimated costs to complete and sell.
  • Under US GAAP, write-downs are permanent; under IFRS, reversals are allowed if NRV recovers.
  • Assess NRV at the individual item level or by category if items are related.
  • Document NRV estimates with market data, recent sale prices, or appraisals for audit support.
  • Combine write-down analysis with obsolescence reserve calculations for comprehensive inventory management.
  • Review raw materials NRV too — not just finished goods.

Accounting Standards for Write-Downs

US GAAP (ASC 330) uses the "lower of cost or market" rule with a floor and ceiling. IFRS (IAS 2) uses the simpler "lower of cost or NRV" test. Both require write-down when carrying value exceeds recoverable value, but differ on reversibility.

Impact on Financial Statements

A write-down reduces both the balance sheet (lower inventory asset) and the income statement (higher COGS or loss). This can affect debt covenants, tax liability, and management bonuses tied to profitability metrics. Transparent disclosure is essential.

Preventing Excessive Write-Downs

Proactive inventory management — demand forecasting, regular ABC analysis, and slow-mover identification — reduces the frequency and magnitude of write-downs. Companies that track aging and turnover by SKU catch NRV issues early before they become material.

Sources & Methodology

Last updated:

Frequently Asked Questions

  • A write-down is triggered when the NRV of inventory drops below its book value. Common causes include price declines, product obsolescence, damage, changes in technology, and reduced market demand.