Inventory reserve calculator for obsolescence and NRV.

What do the numbers come to once the work is shown?

Aging buckets times reserve rates for slow-moving and obsolete stock, plus item-level lower of cost and net realizable value tests, compared with the recorded reserve.

  • Runs in your browser
  • Nothing stored or sent
  • Free, no sign-up
1. Slow-moving and obsolescence reserve

Enter inventory cost by age since last movement (or last sale) and the reserve percentage the policy applies. Leave out items you test for NRV below.

Aging bucketCostReserve %Reserve
No movement 0–6 months$0
6–12 months$42,000
12–24 months$63,000
Over 24 months$71,250
Discontinued / obsolete$40,000
Total$3,585,0006%$216,250
2. Lower of cost and net realizable value

NRV = estimated selling price in the ordinary course of business − reasonably predictable costs of completion, disposal and transportation (ASC 330-10-20).

ItemQtyUnit costSelling price / unitCosts to complete & sell / unitNRV / unitWrite-down
$78.00$7,200
$6.60$0
Total LCNRV write-down$7,200
3. Compare with the books
Required reserve
$223,450
Aging $216,250 + LCNRV $7,200
Recorded reserve
$110,000
Under-reserved by
$113,450
Required − recorded
Watch
Recorded reserve is below the recalculation by $113,450
Understand the client's policy and data before concluding. An estimate difference is a judgmental misstatement for the summary of uncorrected misstatements.
How this was worked out
Work shownrecomputed as you type
Aging reserve = Σ bucket cost × reserve % = $216,250
Model X200 finished units: NRV $89.00 − $11.00 = $78.00; write-down = max(0, $84.00 − $78.00) × 1,200 = $7,200.00
Raw resin (lot 44): NRV $6.90 − $0.30 = $6.60; write-down = max(0, $6.20 − $6.60) × 5,000 = $0.00
Required = $216,250 + $7,200 = $223,450; difference = $223,450 − $110,000 = $113,450

Inventory measured at FIFO or average cost is carried at the lower of cost and net realizable value (ASC 330-10-35-1B); LIFO and retail-method inventory still uses lower of cost or market (330-10-35-1C), which this tool does not model. A write-down sets a new cost basis and is not reversed for later recoveries in annual statements (330-10-35-14). Keep items written down to NRV out of the aging buckets so the same cost is not reserved twice.

Testing the inventory reserve

Inventory is carried at the lower of cost and net realizable value (ASC 330-10-35-1B). Two procedures cover most of the risk: a pricing test comparing unit cost with recent selling prices less costs to sell, and an evaluation of excess and obsolete stock using an aging or movement report. Both are estimates, so the auditor tests the data (aging report completeness and accuracy), the method and the assumptions (reserve percentages against history and subsequent sales).

Keep the two halves separate so the same cost is not reserved twice: items written down to NRV come out of the aging buckets. A difference from the recorded reserve is usually a judgmental misstatement; carry it to the summary of uncorrected misstatements.

Common questions

How is an inventory obsolescence reserve calculated?

A common method ages inventory by time since last movement or sale, then applies a reserve percentage to each bucket based on history, product life cycles and expected sales. Reserve = Σ bucket cost × reserve %.

What is net realizable value?

The estimated selling price in the ordinary course of business less reasonably predictable costs of completion, disposal and transportation (ASC 330-10-20).

Does lower of cost and net realizable value apply to all inventory?

It applies to inventory measured using FIFO or average cost (ASC 330-10-35-1B). Inventory measured using LIFO or the retail inventory method stays on lower of cost or market (330-10-35-1C).

Can an inventory write-down be reversed?

Not in annual financial statements. A write-down to NRV creates a new cost basis that is not marked back up if prices recover (ASC 330-10-35-14). Interim periods have a narrow exception.

Runs in your browser. The figures you type are not sent to CORAA or stored. Check the result against your firm's methodology before relying on it.

Related audit calculators

For US CPA firms

Join the CORAA waitlist

CORAA AI drafts audit working papers from your client’s QuickBooks books and does the first pass: lead schedules, tie-out, memos, draft notes and letters. CORAA Network reviewers clear every finding. Your firm reviews and signs.

  • First audit free, so you can judge the quality on a real file
  • Flat fee by entity size; messy books included
  • We work only with CPA firms, never their clients
See how it works →

* required