Obsolescence Reserve Calculator

About the Obsolescence Reserve Calculator

An obsolescence reserve (also called E&O reserve — excess and obsolete) is an accounting provision that estimates the portion of inventory likely to become unsalable. Companies calculate this reserve using age-based tiers: the older the inventory, the higher the risk factor applied.

Typical age factors increase in steps — for example, 0% for items under 6 months old, 25% for 6–12 months, 50% for 12–18 months, 75% for 18–24 months, and 100% for items over 24 months. The reserve for each tier equals Units × Unit Cost × Age Factor.

This calculator applies a four-tier aging model to estimate total obsolescence reserve. Enter the units and unit cost for each age bracket along with the corresponding risk factor to see the total reserve amount and its percentage of total inventory value.

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

Obsolescence reserves protect financial statements from overvalued inventory and ensure timely action on aging stock. This calculator quantifies the reserve across multiple age tiers, helping controllers set appropriate provisions and giving operations teams targets for liquidation or disposal.

How to Use the Inputs

1. Enter the number of units and unit cost for each age tier.
2. Adjust the age factor percentage for each tier (default tiers provided).
3. Review the reserve amount calculated for each tier.
4. Check the total obsolescence reserve across all tiers.
5. Compare the reserve to total inventory value to assess exposure.
6. Update quarterly as inventory ages and new stock arrives.

Example Calculation

Tips & Best Practices

• Calibrate age factors to your industry — electronics age faster than hardware supplies.
• Review and adjust factors annually based on actual write-off experience.
• Combine obsolescence reserve with NRV write-down analysis for comprehensive coverage.
• Use the reserve trend as an early warning indicator of excess purchasing.
• Segregate reserve by product family to identify which lines drive the most exposure.
• Some industries add a demand-based factor alongside age for more accurate reserves.

Setting Up an E&O Reserve Policy

A well-defined policy specifies age brackets, risk factors, review frequency, and approval authority for reserve adjustments. Document the rationale for each factor and review actual write-offs annually to validate assumptions. Auditors expect consistency and evidence-based factor selection.

Reserve vs. Write-Down vs. Write-Off

The reserve is a balance sheet provision — an estimate of future loss. A write-down reduces the carrying value of specific items when NRV drops below cost. A write-off removes inventory from the books entirely when it is scrapped or donated. All three work together to keep inventory valuation accurate.

Reducing Obsolescence Through Demand Planning

The best reserve is a small one. Companies that invest in accurate demand forecasting, shorter lead times, and postponement strategies carry less excess inventory and therefore need lower obsolescence provisions. Prevention is always cheaper than writing off dead stock.

Frequently Asked Questions

• What is an obsolescence reserve?

  An obsolescence reserve is an accounting provision that estimates the value of inventory expected to become unsalable due to age, technology changes, or market shifts. It is recorded as a contra-asset on the balance sheet.

• How do you determine the age factors?

  Age factors are typically set by finance and operations based on historical write-off patterns. A common starting point is 0% for fresh stock, 25% at 6 months, 50% at 12 months, 75% at 18 months, and 100% at 24 months.

• What is the difference between excess and obsolete inventory?

  Excess inventory exceeds foreseeable demand but may still sell over time. Obsolete inventory has no reasonable demand at any price. Both contribute to the E&O reserve but may require different disposal strategies.

• How often should the reserve be updated?

  Most companies update the obsolescence reserve quarterly as part of the financial close process. Fast-moving industries like electronics or fashion may update monthly due to rapid product life cycles.

• Does the reserve affect taxes?

  Accounting reserves are not always tax-deductible until the inventory is actually disposed of or sold at a loss. Tax treatment varies by jurisdiction — consult a tax advisor for your specific situation.

• Can I customize the age tiers?

  Yes. The four-tier model in this calculator is a common framework, but you can adjust the age breakpoints and factors to match your company's policy. Some companies use five or six tiers for greater granularity.