M&A Deal Modeling Tools

Working Capital PEG Calculator

Determine your trailing 12-month net working capital average. Model Accounts Receivable, Inventory, and Accounts Payable variations to forecast closing price adjustments.

Working Capital PEG Calculator

Model 12-Month Net Working Capital Pegs & Close Adjustments

1. Monthly Details

Editing Period: JanMonthly WC: $350k
Accounts Rec. ($k)
Inventory ($k)
Accounts Pay. ($k)
$650k

Trend analysis

NWC vs. PEG Target Baseline ($k)
PEG: $481kJan: $350kFeb: $360kMar: $370kApr: $380kMay: $410kJun: $500kJul: $530kAug: $500kSep: $480kOct: $510kNov: $580kDec: $600kActual Close: $650k$747k$0kJanFebMarAprMayJunJulAugSepOctNovDec
Working Capital PEG Target$481k
Actual Closing NWC$650k
Closing Day Adjustment+$169k (Due to Seller)
NWC Adjustment Rules

If the net working capital on closing day is higher than the PEG target, the buyer pays the excess cash to the seller. If it falls below, the purchase price is reduced to prevent balance sheet asset draining.

Sign in to save this net working capital benchmark simulation and run comprehensive QofE diagnostics.

AI Working Capital Adjustment Diagnostic

Get an instant AI NWC diagnostic identifying seasonal pitfalls and closing ledger valuation risks.

Working Capital PEG Base

The PEG is the normal level of operating working capital (AR + Inventory - AP) required to support daily business operations post-sale.

Closing Balance Audit Adjustments

On the closing day, actual delivered NWC is audited. A surplus increases the final sale price, while a deficit reduces it dollar-for-dollar.

Seasonal Balance Sheet Risks

Highly seasonal businesses command carefully modeled PEGs to ensure sellers are not penalized for low-season receivables collections.

The Mechanics of Net Working Capital in M&A

During a business sale, transactions are usually structured on a **cash-free, debt-free** basis, with a requirement that the seller delivers a **normal level of working capital**. This ensures the buyer inherits a company capable of operating from day one without requiring immediate equity injections to fund inventory or pay suppliers.

To establish this baseline, advisors calculate the **Net Working Capital (NWC)** average over a historical 12-month period, establishing the **PEG Target**.

Closing Day Price Adjustments

On the transaction closing date, actual balance sheet accounts are audited.

  • Working Capital Surplus: If actual NWC is higher than the PEG target, the buyer pays a dollar-for-dollar valuation premium to the seller.
  • Working Capital Deficit: If actual NWC falls short of the PEG target, the buyer reduces the purchase price by the gap size.

Seasonality plays a major role: businesses selling during their high-season peak typically deliver a large surplus, while those selling during low-seasons might deliver deficits. Understanding this flow prevents post-closing disputes.