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.
Related resources
Ready to automate your due diligence workflow?
See how Datapack can save your team 4-6 hours per engagement. Start a free trial or book a demo with our team.