Inventory Accounting: FIFO, LIFO, Weighted Average & Valuation
Value an outdoor retailer's stock with periodic FIFO, LIFO and weighted average, a perpetual moving-average stock card, NRV write-downs and count adjustments, then read turnover and GMROI, every cell checked live.
The first lesson is free — no account needed.
About this course
An inventory accounting course that values one outdoor retailer's stock with every common cost formula, each lab built and checked in a spreadsheet. You allocate the units sold to cost layers oldest first for periodic FIFO, value the same backpacks with LIFO and measure the LIFO reserve, build landed cost from list price, trade discount and freight-in for a weighted average, keep a perpetual moving-average stock card, compare gross profit and income tax under FIFO, weighted average and LIFO when prices rise, test six product lines for a write-down to net realisable value item by item and by group, including the later reversal, book stock count adjustments and shrinkage and finish with inventory turnover, days in inventory and GMROI. For accounting students, bookkeepers and retail finance teams. The first lab is free.
Lessons
- Periodic FIFO: Cost Layers, COGS & Ending InventoryFree
- Periodic LIFO and the LIFO Reserve Pro
- Weighted Average Cost with Landed Cost (Discounts & Freight-in) Pro
- Perpetual Moving Average: the Running Stock Card Pro
- FIFO vs Weighted Average vs LIFO: Profit & Tax in Rising Prices Pro
- Lower of Cost and NRV: Item by Item, by Group, and the Reversal Pro
- Stock Count Adjustments & Shrinkage Pro
- Inventory Ratios: Turnover, Days in Inventory & GMROI Pro