background
Welcome to Wall Street Prep! Use code at checkout for 15% off.
Wharton & Wall Street Prep Certificates
Now Enrolling for May 2024 for May 2024
:
Private EquityReal Estate Investing
Buy-Side InvestingFP&A
Wharton & Wall Street Prep Certificates:
Enrollment for May 2024 is Open
Wall Street Prep

Change in Net Working Capital (NWC)

Step-by-Step Guide to Understanding the Change in Net Working Capital (NWC)

Last Updated February 7, 2024

Learn Online Now

Change in Net Working Capital (NWC)

How to Calculate Change in Net Working Capital (NWC)

The net working capital (NWC) metric is a measure of liquidity that helps determine whether a company can pay off its current liabilities with its current assets on hand.

As a general rule, the more current assets a company has on its balance sheet relative to its current liabilities, the lower its liquidity risk (and the better off it’ll be).

  • Current Liabilities → The near-term obligations that a company is required to pay off (“outflow”) within the year – e.g. accounts payable and accrued expenses
  • Current Assets → The resources belonging to a company that represent monetary value (e.g. accounts receivable), or can be readily liquidated and converted into cash (“inflow”) or are expected to be used within the year – e.g. accounts receivable (A/R) and inventory

While certain accounting textbooks will define the change in net working capital as current assets minus current liabilities, the more practical formula excludes cash and short-term investments like marketable securities and commercial paper, as well as any interest-bearing debt such as loans and bonds.

Net Working Capital (NWC) = Operating Current Assets Operating Current Liabilities

The reason is that cash and debt are both non-operational and do not directly generate revenue.

In fact, cash and cash equivalents are more related to investing activities, because the company could benefit from interest income, while debt and debt-like instruments would fall into financing activities.

Since we have defined net working capital, we can now explain the importance of understanding the changes in net working capital (NWC).

On the cash flow statement, the changes in NWC are essential, because tracking these changes over time (e.g. year-over-year or quarter-over-quarter) helps assess the degree to which a company’s free cash flows will deviate from its accrual-based net income (“bottom line”).

To calculate the change in net working capital (NWC), the current period NWC balance is subtracted from the prior period NWC balance.

Change in Net Working Capital Formula (NWC)

The change in net working capital (NWC) formula is as follows.

Change in Net Working Capital (NWC) = Beginning NWC Ending NWC

Where:

  • Beginning NWC → Net Working Capital (NWC) at Beginning of Period (BoP)
  • Ending NWC → Net Working Capital (NWC) at End of Period (EoP)

As a sanity check, confirm that if the NWC is growing year-over-year, the change is negative (“cash outflow”).

Likewise, the change should be positive (“cash inflow”) if the NWC is declining year-over-year.

Change in Net Working Capital Calculator (NWC)

We’ll now move on to a modeling exercise, which you can access by filling out the form below.

dl

Get the Excel Template!

Submitting...

1. Balance Sheet Assumptions

In our hypothetical scenario, we’re looking at a company with the following balance sheet data (Year 0).

Selected Financial Data (Year 0)

  • Accounts Receivable (A/R) = $50mm
  • Inventory = $25mm
  • Accounts Payable = $40mm
  • Accrued Expenses = $20mm

Given those figures, we can calculate the net working capital (NWC) for Year 0 as $15mm.

  • Current Operating Assets = $50mm A/R + $25mm Inventory = $75mm
  • (–) Current Operating Liabilities = $40mm A/P + $20mm Accrued Expenses = $60mm
  • Net Working Capital (NWC) = $75mm – $60mm = $15mm

As for the rest of the forecast, we’ll use the following assumptions for each projected year:

  • Accounts Receivable (A/R) = (+) $10mm Growth YoY
  • Inventory = (+) $5mm Growth YoY
  • Accounts Payable = (+) $20mm Growth YoY
  • Accrued Expenses = (+) $10mm Growth YoY

2. Change in Net Working Capital Calculation Example (NWC)

Once the remaining years are populated with the stated numbers, we can calculate the change in NWC across the entire forecast.

Since the growth in operating liabilities is outpacing the growth in operating assets, we’d reasonably expect the change in NWC to be positive.

The change in NWC comes out to a positive $15mm YoY, which means the company retains more cash in its operations each year.

  • Change in Net Working Capital (NWC) = $15 million

In conclusion, our change in net working capital (NWC) exercise illustrates how increases in operating current assets are cash outflows, while increases in operating current liabilities are cash inflows.

Change in Net Working Capital Calculator (NWC)

What is a Good Change in NWC?

If a company’s change in NWC has increased year-over-year (YoY), this implies that either its operating assets have grown and/or its operating liabilities have declined from the preceding period.

An increase in the balance of an operating asset represents an outflow of cash – however, an increase in an operating liability represents an inflow of cash (and vice versa).

If calculating free cash flow – whether on an unlevered FCF or levered FCF basis – an increase in the change in NWC is subtracted from the cash flow amount.

But if the change in NWC is negative, the net effect from the two negative signs is that the amount is added to the cash flow amount.

  • Increase in Net Working Capital (NWC) → Less Free Cash Flows (FCFs)
  • Decrease in Net Working Capital (NWC) → More Free Cash Flows (FCFs)

For instance, suppose a company’s accounts receivables (A/R) balance has increased YoY, while its accounts payable (A/P) balance has increased under the same time span.

The net effect is that more customers have paid using credit as the form of payment, rather than cash, which reduces the liquidity (i.e. cash on hand) of the company.

As for accounts payables (A/P), delayed payments to suppliers and vendors likely caused the increase.

Even though the payment obligation is mandatory, the cash remains in the company’s possession for the time being, which increases its liquidity.

How to Interpret Negative Net Working Capital?

In the absence of further contextual details, negative net working capital (NWC) is not necessarily a concerning sign about the financial health of a company.

For instance, if NWC is negative due to the efficient collection of receivables from customers who paid on credit, quick inventory turnover, or the delay in supplier/vendor payments, that could be a positive sign.

However, negative working capital could also be a sign of worsening liquidity caused by the mismanagement of cash (e.g. upcoming supplier payments, inability to collect credit purchases, slow inventory turnover). In such circumstances, the company is in a troubling situation related to its working capital.

How to Find Change in NWC on Cash Flow Statement?

The cash flow statement (CFS) of Apple (NASDAQ: AAPL) is highlighted, to point out which line items measure the increase or decrease in Apple’s working capital assets and working capital liabilities.

Change in NWC Example

Screenshot from Apple 3-Statement Model (Source: WSP Premium Package)

Step-by-Step Online Course

Everything You Need To Master Financial Modeling

Enroll in The Premium Package: Learn Financial Statement Modeling, DCF, M&A, LBO and Comps. The same training program used at top investment banks.

Enroll Today
Comments
6 Comments
most voted
newest oldest
Inline Feedbacks
View all comments
Jon
March 4, 2022 7:27 am

Wanted to confirm Net Working Capital = Working Capital (Current Year) – Working Capital (Previous Year) ? In this article it states Change in Net Working Capital (NWC) = Prior Period NWC – Current Period NWC

At least that is what is outlined here https://www.wallstreetmojo.com/changes-in-net-working-capital/

Last edited 1 year ago by Jonathan Gutman
Adam O Donoghue
November 20, 2022 2:27 pm

Dear Sir/Madam, I hope you can offer some assistance with the following. Assuming I use the below formulas. I am wondering why a component in the operating cash flow formula, inventory in net working capital, has the effect of subtracting from the net income figure.  I am using the following formulas: Operating… Read more »

Brad Barlow
November 21, 2022 3:14 pm

Hi, Adam, I find it helpful to think of adjustments to net income to get to CFO in four quadrants: 1) subtract revenue that has not been collected (e.g., increase in A/R); 2) add back expenses that have not yet been paid in cash (e.g., increase in A/P) or that… Read more »

Adam O’Donoghue
December 14, 2022 4:20 pm
Reply to  Brad Barlow

Hi Brad, Definitely helpful. What gets me is the following: COGS = Beginning inventory + Purchases throughout year – Ending inventory. Gross income = Sales revenue – COGS. The amount of Ending inventory subtracted in COGS has the affect of reducing COGS and increasing gross income, and in turn net… Read more »

Brad Barlow
December 17, 2022 2:28 pm

Hi, Adam, I think the issue is how you are mentally conceptualizing what happens. Given beginning and purchases, the less ending inventory there is, the greater the amount of COGS and the lower gross and net income. However, if COGS was greater than purchases, then that amount must be added… Read more »

Learn Financial Modeling Online

Everything you need to master financial and valuation modeling: 3-Statement Modeling, DCF, Comps, M&A and LBO.

Learn More

The Wall Street Prep Quicklesson Series

7 Free Financial Modeling Lessons

Get instant access to video lessons taught by experienced investment bankers. Learn financial statement modeling, DCF, M&A, LBO, Comps and Excel shortcuts.