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

Advisory & Consulting
Advanced

DCF valuation model blueprint with assumptions checklist

Outlines a DCF model structure, key assumptions, and validation checks. Useful for valuation analysts producing defensible valuations for boards, investors, or disputes.

GPT-5.2 Thinking; GPT-4.1; o3-mini
0
0
27
Advisory & Consulting
Advanced

Operating model: unit economics to financial statements

Connects unit economics (volume, pricing, conversion) to full financial statements and cash. Useful for SaaS/e-commerce and growth-stage models.

GPT-5.2 Thinking; GPT-4.1; o3-mini
0
0
25
Advisory & Consulting
Beginner

Retail: Inventory Turnover by Category

Identifies the 'hero' and 'zero' products based on velocity.

GPT-4oGemini 1.5 Pro
0
0
18