M&A · Closing mechanics
Working capital pegs that end the argument.
Load the target's monthly NWC, mark the one-offs and debt-like items, and see every methodology — LTM average, weighted, median, quarter-ends, seasonalized — side by side. Walk into the next call with a number you can defend.
01
Load the schedule
Enter or paste monthly balances for AR, Inventory, AP and the rest of working capital. Add custom lines for anything deal-specific.
02
Normalize
Strip out one-offs, reclassify miscoded items, and flag debt-like balances so they show up in the bridge — not the peg.
03
Compare methodologies
Seven peg calculations on the same screen, plus DSO / DPO / DIO sanity checks. Pick a peg, set a collar, export the memo.
What you get
- · LTM 12-month simple average
- · 3 / 6 / 24-month averages
- · Linearly-weighted recent-months average
- · Median (outlier-robust)
- · Quarter-ends only (US deal convention)
- · Seasonalized same-month average
- · P25–P75 negotiation band + collar
- · DSO / DPO / DIO sanity checks