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.

How to use this prompt

  1. 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. 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. 3

    Run it, then refine. Ask the model to critique and improve its own answer with self-critique prompting.

Techniques in this prompt

Role-Based

Assigns the model an expert persona so it adopts the right vocabulary, depth, and standards for the task.

Learn this technique

Recommended models

claudegpt-4ogemini

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