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.
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.
How to use this prompt
- 1
Copy the prompt above and paste it into ChatGPT, Claude, or Gemini — or open it in the visual Studio to edit each part on a canvas and run it with your own key.
- 2
Replace any bracketed placeholders with your specifics. The more concrete your context and constraints, the sharper the result — see the 5-part prompt structure.
- 3
Run it, then refine. Ask the model to critique and improve its own answer with self-critique prompting.
Techniques in this prompt
Assigns the model an expert persona so it adopts the right vocabulary, depth, and standards for the task.
Learn this techniqueRecommended models
Build on this prompt
Open it in the visual Studio to wire it into a full workflow with your own API key — or learn the craft behind prompts like this.
More in Finance & Accounting
Three-Statement Model Architect
Builds a fully integrated three-statement financial model with linked schedules, drivers, and circularity controls.
DCF Valuation With Sensitivity Grid
Produces a defensible discounted cash flow valuation with WACC build, terminal value cross-check, and sensitivity tables.
Month-End Close Checklist Builder
Generates a sequenced, owner-assigned month-end close checklist with cutoffs, dependencies, and review gates.
Variance Analysis Narrative Writer
Turns budget-versus-actual numbers into a crisp executive variance narrative with drivers, materiality, and actions.