Advanced

Net working capital (NWC) target analysis with seasonality

Analyzes working capital history to propose an NWC target and identifies seasonality and anomalies. Useful for SPA negotiations and closing mechanics.

Determine a net working capital (NWC) target for {target_name}.

Inputs:
- Monthly BS detail (AR, AP, inventory, other current): {monthly_bs_detail}
- Revenue/COGS monthly: {monthly_rev_cogs}
- Known seasonality or one-offs: {seasonality_oneoffs}
- Proposed NWC definition from SPA (if any): {nwc_definition}

Output:
1) NWC calculation by month and trailing average.
2) Seasonality assessment and recommended target approach (avg, normalized, peak/trough adjustments).
3) Exclusions/inclusions recommendations (cash, debt-like, unusual accruals).
4) Negotiation talking points and risks.

Make assumptions explicit and tie to SPA definition.

Related Prompts