Net Working Capital
Current assets less current liabilities
Current assets less current liabilities
Simply put, Net Working Capital (NWC) is the difference between a company’s current assets (net of cash) and current liabilities (net of debt) on its balance sheet. It is a measure of a company’s liquidity and its ability to meet short-term obligations, as well as fund operations of the business. The ideal position is to have more current assets than current liabilities, and thus have a positive net working capital balance.
Approaches to calculating NWC are to exclude cash and debt (current portion), or to only include accounts receivable, inventory, and accounts payable.
There are a few different methods for calculating net working capital, depending on what an analyst wants to include or exclude from the value.
Net Working Capital = Current Assets (less cash) – Current Liabilities (less debt)
NWC = Accounts Receivable + Inventory – Accounts Payable
The first formula above is the broadest (as it includes all accounts) and the second formula is the most narrow (as it only includes 3 accounts).
Enter your name and email in the form below and download the free template now!
Below are the steps an analyst would take to forecast NWC using a schedule in Excel.
At the very top of the working capital schedule, reference sales and cost of goods sold from the income statementfor all relevant periods. These will be used later to calculate drivers to forecast the working capital accounts.
Under sales and cost of goods sold, lay out the relevant balance sheet accounts. Separate current assets and current liabilities into two sections. Remember to exclude cash under current assets and to exclude any current portions of debt from current liabilities. For clarity and consistency, lay out the accounts in the order they appear in the balance sheet.
Create subtotals for total non-cash current assets and total non-debt current liabilities. Subtract the latter from the former to create a final total for net working capital. If the following will be valuable, create another line to calculate the increase or decrease of net working capital in the current period and the previous period.
Populate the schedule with historic data, either by referencing the corresponding data in the balance sheet, or by inputting hardcoded data into the net working capital schedule. If a balance sheet has been prepared with future forecasted periods already available, populate the schedule with forecast data as well, by referencing the balance sheet.
If future periods for the current accounts are not available, create a section to outline the drivers and assumptions for the main assets. Use the historic data to calculate drivers and assumptions for future periods. See the table below for common drivers used in calculating specific line items. Finally, use the prepared drivers and assumptions to calculate future values for the line items.
Belos is a list of assumptions that are used in a financial model to forecast NWC:
Accounts receivable days, inventory days and accounts payable days all rely on sales or cost of goods sold to calculate. If either sales or COGS is unavailable, the “days” metrics cannot be calculated. When this happens, it may be easier to calculate accounts receivables, inventory and accounts payables by analyzing the past trend and estimating a future value.
Changes in net working capital impact cash flow in financial modeling.
Look closely at the image of the model below and you will see a line called “Less Changes in Working Capital”…
… to learn more, launch our financial modeling courses now!
Thank you for reading this guide to net working capital. CFI is the official provider of the FMVA Financial Modeling Certification, designed to transform anyone into a world-class financial analyst. To advance your career as an analyst, read more about the other elements that populate financial statements:
Get world-class financial training with CFI’s online certified financial analyst training program!
Gain the confidence you need to move up the ladder in a high powered corporate finance career path.
Learn financial modeling and valuation in Excel the easy way, with step-by-step training.