RoutineMetric

M&A Purchase Price Adjustment & Working Capital Collar Simulator

Model Cash-Free, Debt-Free M&A transactions, simulate Net Working Capital (NWC) true-ups, and calculate escrow releases under custom collar & basket parameters.

Select Transaction Scenario Preset

Core LOI parameters

$
The base valuation of the business as agreed in the LOI before adjustments.
$
$
Target Working Capital Peg is the standard level of working capital delivered at close. Escrow Holdback secures the post-closing true-up.

Adjustment collar terms

$
Establishes a safe-harbor band of $1,800,000 to $2,200,000.
Sellers are only adjusted for dollars exceeding the collar boundary.

Balance Sheet Inputs

Closing Estimates (At Closing)
Post-Closing Actuals (True-Up)
Estimated Cash at Close$45,700,000
Paid to Seller on Closing Day (net of Escrow Holdback)
Net Post-Closing True-Up
-$220,000
Seller owes Buyer refund
Escrow Holdback Released$280,000
Seller receives 56% of escrow

Net Working Capital Collar Gauge

EST
ACT
$1,600,000 (Deficit Risk)Lower Bound: $1,800,000Target Peg: $2,000,000Upper Bound: $2,200,000$2,400,000 (Surplus Zone)

Status: Estimated NWC is $2,300,000 (Deviation of +$300,000). Actual closing NWC is $2,120,000 (Deviation of +$120,000).

Actual NWC landed inside the collar band. No adjustment is triggered on the post-closing true-up.

Enterprise to Equity Value Bridge

At Closing
Calculation Line ItemEstimated AmountNotes / Explanations
Base Enterprise Value (EV)$50,000,000LOI locked valuation of business operations
+ Cash Adjustment$1,500,000Estimated cash retained by target at close
- Debt Adjustment($5,000,000)Estimated closing balance of funded debt
- Unpaid Transaction Expenses($400,000)Investment banking, legal & advisory fees unpaid
+Working Capital Adjustment$100,000Est. NWC: $2,300,000 vs Target: $2,000,000 (Collar applied)
Estimated Closing Equity Value$46,200,000The net purchase price for target equity shares
- Escrow Holdback($500,000)Deposited in 3rd-party escrow for post-close true-ups
Cash Paid to Seller at Close$45,700,000Wire transfer paid to sellers on closing day

Post-Closing Reconciliation & Delta Sheet

True-Up Stage
Balance Sheet ItemEstimate (Close)Actual (Audited)Adjustment DeltaFin. Effect
Cash$1,500,000$1,450,000-$50,000Seller refunding buyer
Funded Debt$5,000,000$5,050,000-$50,000Higher debt is Seller deduction
Unpaid transaction expenses$400,000$420,000-$20,000Unestimated fees reduces EV
Operating Current Assets$4,200,000$4,100,000-$100,000Operating receivables, prepaids, inventory
Operating Current Liabilities$1,900,000$1,980,000-$80,000Accounts payable, accrued liabilities
Net Working Capital (Calculated)$2,300,000$2,120,000-$180,000NWC actual vs estimate delta
NWC Post-Collar Adjustment$100,000$0-$100,000Adjusted true-up after collar constraints
Net Post-Closing True-Up Settlement Due-$220,000Clawback by Buyer from Seller

Final Escrow Settlement & Seller Proceeds

Escrow Distribution Breakdown

Total Escrow Pool:$500,000
Released to Seller:$280,000
Clawed Back by Buyer:$220,000
Escrow covers adjustments up to the holdback limit.

Additional Cash Transfers

Direct Out-of-Pocket:$0

The negative adjustment of $220,000 is fully covered by the escrow account. Seller writes no out-of-pocket check.

Subject to caps and baskets in the Stock Purchase Agreement (SPA).
Total Net Cash Proceeds Retained by SellerClosing Payment + Escrow Payout + Direct Settlements
$45,980,000($220,000 vs Closing Est.)
Advertisement
Bottom Banner Ad (728x90)

Understanding Net Working Capital (NWC) Adjustments in Private M&A

In private company acquisitions, the price agreed upon in a Letter of Intent (LOI) is based on a fundamental assumption: the business will be delivered to the buyer with a "normal" level of working capital necessary to run the business. Without a working capital adjustment, a seller could deplete the company's cash, accelerate collections of receivables, and delay payables prior to close—effectively selling a hollowed-out corporate shell.

To protect both parties, corporate acquisitions employ a Net Working Capital (NWC) Adjustment mechanism. This mechanism compares the NWC delivered on the closing day against a negotiated baseline, referred to as the Target Working Capital Peg.

The M&A Definition of Net Working Capital

While standard accounting textbooks define working capital as current assets minus current liabilities, transaction NWC strictly excludes cash, debt, and debt-like items. This is because cash and debt are adjusted separately under the cash-free, debt-free deal terms.

The typical M&A definition is:

Transaction NWC = (Accounts Receivable + Inventory + Prepaid Expenses) - (Accounts Payable + Accrued Liabilities + Deferred Revenue)

By excluding cash and interest-bearing debt, the calculation isolates the operational assets and liabilities needed to generate ongoing revenues, preventing arbitrary adjustments from capital structure decisions.

Advertisement