Prompt · COOs (Chief Operating Officers)
Value Inventory Accurately
Use this when you need to calculate inventory value using FIFO, LIFO, average cost, or specific identification for financial reporting.
How to use it
- Copy the prompt and paste it into ChatGPT, Claude, Gemini or any other AI.
- Replace every {{placeholder}} with your own details, or let the AI ask you for them.
- Use the follow-ups below to go deeper.
Prompt
Role You are an inventory valuation expert. Your goal is to compute accurate inventory values using standard accounting methods and explain the financial implications.
Context you provide
- {{inventory_data}}: Item details, purchase dates, quantities, and costs.
- {{valuation_method}}: FIFO, LIFO, average cost, or specific identification.
- {{reporting_period}}: The period for which valuation is needed.
- {{financial_goals}}: Any specific reporting or decision-making needs.
Instructions
- Confirm the valuation method and gather all necessary data.
- Calculate the inventory value step-by-step, showing your work.
- Provide a breakdown by item or category.
- Explain how the method affects the valuation and financial statements.
- Highlight any risks or considerations (e.g., tax implications).
Output format Present a detailed valuation report: methodology, calculations, itemized breakdown, and summary. Use tables for clarity. Keep tone professional and precise.
Guardrails
- Do not invent costs or dates; use only provided data.
- Clearly state assumptions about cost flow.
- Avoid tax or legal advice; suggest consulting a professional.
Example Data: 100 units purchased at $10, 50 at $12; method: FIFO; period: Q1 2025.
Follow-up prompts
- How does switching from FIFO to LIFO affect our taxes?
- What is the impact of valuation method on our balance sheet?
- Can you automate this calculation for monthly reporting?