Inventory Valuation & Stock Adjustment Calculator
Compare recorded inventory with the physical stock count, identify shortages
or surpluses, and estimate the financial impact of inventory adjustments.
1. Inventory Details
Quantity currently recorded in the inventory system.
Quantity confirmed by the physical stock count.
Recorded cost per unit used to value the stock.
Optional write-down for damaged, obsolete or impaired stock. Leave blank if none.
Calculate Inventory Adjustment
Reset
Practical Example
A business records 1,000 units at ₹250 per unit. A physical count finds 960 units.
The business also identifies an additional inventory write-down of ₹5,000.
Step 1: Calculate Recorded Inventory Value
1,000 units × ₹250 = ₹2,50,000
Step 2: Calculate Physical Inventory Value
960 units × ₹250 = ₹2,40,000
Step 3: Calculate the Stock Variance
960 − 1,000 = −40 units
−40 units × ₹250 = −₹10,000
Step 4: Apply the Additional Write-down
₹2,40,000 − ₹5,000 = ₹2,35,000
Step 5: Calculate the Net Change
₹2,35,000 − ₹2,50,000 = −₹15,000
The adjusted inventory value is ₹2,35,000, representing a net decrease of ₹15,000
compared with the recorded inventory value.
How to Use This Calculator
- Enter the recorded inventory quantity.
- Enter the physical quantity confirmed by the stock count.
- Enter the book cost per unit.
- Enter an additional write-down if required; otherwise leave it blank.
- Click Calculate Inventory Adjustment to view the results.
- Click Reset to clear the fields and test another scenario.