Working Capital

In this step, we compute net working capital, or NWC, which is the difference between non-cash current assets and non-debt current liabilities. The components of net working capital are often projected as percentages of sales or COGS, as we have projected them in our model. The accounts receivable days, accounts payable days, inventory days, and inventory turnover shown here are imputed. Alternatively, you could drive inventory projections from an assumed inventory days, and then impute the inventory/COGS ratio, for example. For simplicity, we assume that these ratios are flat over the projection period. In reality, these drivers could reflect seasonality, increasing leverage in the supply chain, etc.

 

Webinar: The AI Edge in Investment Banking

Presented By LSEG & Macabacus: Learn practical insights about AI’s influence on the future of banking.

Thursday, Oct 30th at 10AM EDT / 2PM GMT.

While we have built in a selector switch to toggle the P&L item (sales or COGS) driving each of these working capital components, the selection is not arbitrary. You would always express accounts receivable as a percentage of sales, inventory as a percentage of COGS, and accounts payable as a percentage of COGS, for example. Components of net working capital can vary from one company to another and one industry to another; for each such item, decide whether it is more intuitive to express the item as a percentage of sales or COGS. For public companies, detailed analyst/broker reports may offer clues on how to project the components of net working capital.

Once we have built our working capital schedule, we link it to the balance sheet.

Discover more topics

Webinar: The AI Edge in Investment Banking
Join experts from Macabacus & LSEG to learn practical insights about AI’s influence on the future of banking.
Read more
DCF Excel Template
Elevate your investment analysis with our free DCF model template. Understand discounted cash flow principles and perform accurate valuations in Excel.
Read more
Operating Model Excel Template
Download our free operating model Excel template. Forecast revenue, expenses, and key financial metrics for better decision-making.
Read more
LBO Excel Model
Try LBO modeling with our comprehensive Excel template. Understand key concepts, calculate returns, and gain actionable insights.
Read more