Net realizable value inventory write-down · Calculation guide

One stock item. Estimate selling price less completion and selling costs per unit.

Calculation guide

Limit the inventory charge to its book cost.

expense = units*max(0,unitcost-max(0,sell-finish-fees)) · nrv = sell-finish-fees · ending = units*unitcost-expense

Inputs

Units on hand

Example entry 150.

Book cost per unit

Example entry 10 (in the selected currency).

Expected unit sale price

Example entry 11 (in the selected currency).

Completion cost per unit

Example entry 2 (in the selected currency).

Selling cost per unit

Example entry 1 (in the selected currency).

Worked example

InputValue
Units on hand150
Book cost per unit10
Expected unit sale price11
Completion cost per unit2
Selling cost per unit1
ResultValue
Total write-down300
Net realizable value per unit8
Closing inventory value1,200

Calculation steps

Total write-down = (Units on hand × max(0, (Book cost per unit − max(0, ((Expected unit sale price − Completion cost per unit) − Selling cost per unit)))))

(150 × max(0, (10 − max(0, ((11 − 2) − 1))))) = 300

Net realizable value per unit = ((Expected unit sale price − Completion cost per unit) − Selling cost per unit)

((11 − 2) − 1) = 8

Closing inventory value = ((Units on hand × Book cost per unit) − Total write-down)

((150 × 10) − 300) = 1,200

How each input affects this example

Each row starts from the worked example and changes one input.

InputOriginal inputNew inputAffected resultOriginal resultNew result
Units on hand150165Total write-down300330
Book cost per unit1011Total write-down300450
Expected unit sale price1112Total write-down300150
Completion cost per unit23Total write-down300450
Selling cost per unit12Total write-down300450
Net realizable value inventory write-down →

Sources