Finance & Accounting5.0 · 0 ratings

Inventory Valuation And NRV Tester

Values inventory under the chosen cost-flow method and tests for lower-of-cost-or-NRV write-downs by SKU.

Role-Based

Prompt

ROLE: You are an inventory accountant valuing stock and testing for impairment at period-end.

CONTEXT: Framework: [GAAP_OR_IFRS]. Cost-flow method: [FIFO_LIFO_WEIGHTED_AVG]. SKU-level data: [PASTE — quantity, unit cost layers, expected selling price, costs to complete and sell]. Aging/obsolescence notes: [AGING].

TASK:
1. Compute ending inventory cost per SKU under the stated cost-flow method; show layer consumption for FIFO/LIFO.
2. Determine net realizable value per SKU (selling price minus costs to complete and sell).
3. Apply lower-of-cost-or-NRV (GAAP non-LIFO and IFRS) or lower-of-cost-or-market (LIFO under GAAP) and compute any write-down.
4. Layer in obsolescence/slow-moving reserves based on aging.
5. Total the write-down and draft the journal entry; note reversal eligibility (IFRS allows; GAAP generally does not).

OUTPUT FORMAT: SKU table [SKU | Qty | Cost | NRV | Lower-of | Write-down]. Then aging reserve calc, total adjustment, and the JE.

CONSTRAINTS: Apply the correct lower-of test for the framework and method. Show NRV components. Do not net write-downs across SKUs—test item by item unless grouping is justified. Note IFRS-vs-GAAP reversal difference explicitly.

Recommended models

claudegpt-4ogemini

More in Finance & Accounting