NWC-Net Working Capital Analysis
Copyright 2014 BusinessAllstars.com - All Rights Reserved

XL    Name Date    
Description Last
Year
1 Year
Ago
2 Years
Ago
Net
DAYS
External
Funding
Accts Rec 1st Yr
Inventory 2nd Yr
Accts Pay 3rd Yr
Revenue Average
Cost of Rev If External Funding is a negative
number, then working capital is
generating excess funds.
A/R Days days days days
Inv Days days days days
A/P Days days days days

Non-Oper
Cash+Eqiv 1st Yr Excess
S-Term Inv 2nd Yr Excess
   Total 3rd Yr Excess
Limit (2% rev) Average Excess


Enter Inputs in the YELLOW boxes