Free workbook

The cash trapped
on your shelves.

Inventory is cash you already spent, sitting still. Paste your item list and this workbook finds how much of it is working and how much is stuck: the dead stock, the slow movers, and the excess above a coverage target you set, priced as the cash a workdown would free.

What's inside

  • Days on hand and inventory turns for every item, calculated from quantity and annual usage
  • Automatic flags: DEAD for anything that moved nothing in a year, SLOW past your days-on-hand line, OK for the rest
  • An excess-value column: the cash carried above your coverage target, even on healthy items, so you can work the list by dollars
  • A one-number cash-release figure on the Summary tab: dead stock plus excess, the cash a workdown frees without touching a moving item
  • No macros, no lock-in. Opens in Excel and imports cleanly into Google Sheets

Get the workbook

We only use this to send the workbook and occasional operator notes. Unsubscribe anytime.

How to use it

  1. Export your inventory list: SKU, description, unit cost, quantity on hand, and annual unit usage. Paste up to 150 rows on the Items tab.
  2. Set two targets on the Summary tab: the coverage you actually need in days, and the days-on-hand line past which an item is a slow mover.
  3. Read the cash-release number, then work the item list top to bottom by excess value. The first ten lines usually hold most of it.
  4. Re-run it quarterly. Dead stock that keeps reappearing is a purchasing problem, not an inventory problem.

This is the inventory leg of the working-capital picture. The receivables side is the A/R collections dashboard, and the whole cycle lives in the working capital & CCC workbook. If the trapped cash is large enough to matter to your revolver, start a conversation.