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.
Ressources associées
Prêt à automatiser votre due diligence ?
Découvrez comment Datapack peut faire gagner 4 à 6 heures par engagement à votre équipe. Essai gratuit ou démonstration.