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).

 

Build Financial Models in Minutes

Enterprise-Grade Financial Modeling used by 80,000+ professionals across Investment Banking, Private Equity, and Corporate Finance. Ensure consistency, accuracy, and efficiency across your entire organization.

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

Download The State of M&A Transactions
Download this report for expert guidance on innovative structures, cost-effective financing, and antitrust strategies to accelerate deals.
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