Working Capital Assumptions

Our next step is to forecast working capital on the balance sheet. Working capital is typically forecast using historical working capital items as percentages of sales or COGS, as applicable. You should use LTM sales and COGS figures, as well as working capital items from the LTM date. Note that we have explicitly stated whether we are using percentages of sales or COGS for each working capital item we are forecasting. Be very careful to use the proper method when entering the equations in your spreadsheet (i.e. don’t use Ctrl+d to propagate the equation at the top of the selected range of cells downward).

 

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.

Use the spreadsheet below as a guide to which method (e.g. percent of sales or percent of COGS) to use. It should be intuitive why we chose to forecast accounts receivable as a percent of sales, and inventory as a percent of COGS, for example. Once we have forecasted these working capital items, we link our balance sheet directly to these cells. Note that we have also calculated the change in net working capital, since this figure will be used later in cash flow calculations.

Download Template

Download Template

Working Capital Assumptions

Try Macabacus for free to accelerate financial modeling in Excel.

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