Net Working Capital Analysis Template for deal teams.
A complete NWC workbook covering monthly balance tracking, seasonality patterns, peg calculation, and target-to-actual variance analysis. Built for buy-side and sell-side due diligence.
Downloaded 500+ times
Monthly NWC tracking
24-month balance sheet component tracking with automatic NWC calculation and trend analysis.
Seasonality analysis
Built-in seasonality detection with monthly deviation from average and high/low flagging.
Peg calculation
Multiple peg methodologies (average, median, normalized) with sensitivity analysis.
Variance reporting
Target vs. actual NWC at close with component-level waterfall breakdown.
Datapack-NWC-Analysis-Template.xlsx
XLSX · 1.9 MB
Get the NWC template
Enter your details to download the template.
Recursos relacionados
Pronto para automatizar sua due diligence?
Veja como o Datapack pode economizar 4-6 horas por engagement para sua equipe. Teste gratuito ou agende uma demo.