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
Three-Statement Model Architect
Builds a fully integrated three-statement financial model with linked schedules, drivers, and circularity controls.
Read prompt
DCF Valuation With Sensitivity Grid
Produces a defensible discounted cash flow valuation with WACC build, terminal value cross-check, and sensitivity tables.
Read prompt
Month-End Close Checklist Builder
Generates a sequenced, owner-assigned month-end close checklist with cutoffs, dependencies, and review gates.
Read prompt
Variance Analysis Narrative Writer
Turns budget-versus-actual numbers into a crisp executive variance narrative with drivers, materiality, and actions.
Read prompt