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.
Risorse correlate
Pronto ad automatizzare la tua due diligence?
Scopri come Datapack può far risparmiare al tuo team 4-6 ore per engagement. Prova gratuita o prenota una demo.