background
Welcome to Wall Street Prep! Use code at checkout for 15% off.
Wharton & Wall Street PrepWSP Certificates Now Enrolling for February 2025:
Private EquityReal Estate InvestingApplied Value InvestingFP&A
Wharton & Wall Street Prep Certificates:
Enrollment for February 2025 is Open
Wall Street Prep

Net Working Capital (NWC)

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

Net Working Capital (NWC)

  Generating
  Generate Key Takeaways
  • Net working capital (NWC) compares a company’s operating current assets (excluding cash and cash equivalents) to its operating current liabilities (excluding debt and interest-bearing securities).
  • The formula to calculate net working capital (NWC) subtracts operating current liabilities from operating current assets.
  • A positive NWC value implies the company can pay off its short-term obligations by liquidating its current assets, while a negative NWC signals potential near-term insolvency risk.
  • An increase in operating current assets like accounts receivable represents a “use” of cash, while an increase in operating current liabilities like accounts payable is a “source” of cash.

How to Calculate Net Working Capital (NWC)

Net working capital, often abbreviated as “NWC”, is a financial metric used to evaluate a company’s near-term liquidity risk.

The net working capital (NWC) metric is the ratio between a company’s operating current assets and operating current liabilities.

  • Operating Current Assets ➝ The short-term assets belonging to a company that can be converted into cash within the next twelve months (i.e. “cash inflow”).
  • Operating Current Liabilities ➝ The short-term liabilities of a company represent the obligations coming due within the next twelve months (i.e. “cash outflow”).

A company with more operating current assets than operating current liabilities is considered to be in a more favorable financial state from a liquidity standpoint, where near-term insolvency is unlikely to occur.

The most common examples of operating current assets include accounts receivable (A/R), inventory, and prepaid expenses.

On the other hand, examples of operating current liabilities include obligations due within one year, such as accounts payable (A/P) and accrued expenses (e.g. accrued wages).

  • Positive Net Working Capital (NWC) ➝ If the ratio of current operating assets to current liabilities is 1.0 or higher, the net working capital (NWC) is positive. Hypothetically, the company can sufficiently pay off its short-term obligations by liquidating its current operating assets, if necessary.
  • Negative Net Working Capital (NWC) ➝ The company’s short-term liabilities exceed the value of the company’s current assets, which signals that external financing might urgently be required.

In particular, creditors such as bank lenders pay close attention to a company’s net working capital (NWC) to understand the borrower’s creditworthiness and borrowing capacity, i.e. quantify the risk of providing debt financing to the company.

Aside from gauging a company’s liquidity, the NWC metric can also provide insights into the efficiency at which operations are managed, such as ensuring short-term liabilities are kept to a reasonable level.

Net Working Capital Formula (NWC)

The net working capital (NWC) formula subtracts operating current assets by operating current liabilities.

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

To reiterate, a positive NWC value is perceived favorably, whereas a negative NWC presents a potential risk of near-term insolvency.

The NWC metric is often calculated to determine the effect that a company’s operations had on its free cash flow (FCF).

Since we’re measuring the increase (or decrease) in free cash flow, i.e. across two periods, the “Change in Net Working Capital” is the right metric to calculate here.

Change in Net Working Capital (NWC) = Prior Period NWC Current Period NWC

The rationale for subtracting the current period NWC from the prior period NWC, instead of the other way around, is to understand the impact on free cash flow (FCF) in the given period.

An increase in an operating current asset (e.g. accounts receivable) from one period to the next represents a “use” of cash, while an increase in an operating current liability (e.g. accounts payable) is a “source” of cash (and vice versa).

With that in mind, the change in NWC is interpreted using the following rules:

  • Negative Change in NWC ➝ More Free Cash Flow (FCF)
  • Positive Change in NWC ➝ Less Free Cash Flow (FCF)

Net Working Capital (NWC) vs. Working Capital: What is the Difference?

The textbook definition of working capital is defined as current assets minus current liabilities.

Working Capital = Current Assets Current Liabilities

However, the more practical metric is net working capital (NWC), which excludes any non-operating current assets and non-operating current liabilities.

  • Non-Operating Current Assets → Cash and cash equivalents, such as marketable securities, must be excluded in the net working capital (NWC) calculation. Unlike a current asset like accounts receivable—the uncollected cash proceeds from credit sales—cash itself and short-term investments are not directly a part of a company’s core operations. Rather, those two items are closer to investing activities, given that interest income can be earned.
  • Non-Operating Current Liabilities → Similarly, debt and any interest-bearing securities with debt-like features should be removed from any NWC calculation under the same logic. Contrary to a current liability, such as accounts payable—the unmet payment obligations to suppliers and vendors—debt is a source of financing (and not directly related to a company’s operations).

The interpretation of either working capital or net working capital is nearly identical, as a positive (and higher) value implies the company is financially stable, all else being equal.

The distinction is that net working capital (NWC) focuses on a company’s operational efficiency and the impact on free cash flow (FCF).

Net Working Capital Calculator (NWC) — Excel Template

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

dl

Excel Template | File Download Form

By submitting this form, you consent to receive email from Wall Street Prep and agree to our terms of use and privacy policy.

Submitting...

1. Balance Sheet Assumptions

Suppose we’re tasked with calculating the net working capital (NWC) of a company with the following balance sheet data.

Selected Financial Data
($ in millions) Year 0 Year 1 Year 2
Accounts Receivable (A/R) $40 $44 $48
Inventory 10 12 14
Current Operating Assets $50 $56 $62
Accounts Payable (A/P) $30 $35 $40
Accrued Expense 10 13 16
Current Operating Liabilities $40 $48 $56

2. Net Working Capital Calculation Example (NWC)

Since a company’s net working capital (NWC) is the difference between its operating current assets and operating current liabilities, we can subtract the two in each period to arrive at the following NWC values:

  • Year 0 = $50 million – $40 million = $10 million
  • Year 1 = $56 million – $48 million = $8 million
  • Year 2 = $62 million – $56 million = $6 million

From Year 0 to Year 2, the company’s NWC reduced from $10 million to $6 million, reflecting less liquidity (and more credit risk).

3. Change in NWC Calculation Example

In the final part of our exercise, we’ll calculate how the company’s net working capital (NWC) impacted its free cash flow (FCF), which is determined by the change in NWC.

  • Change in NWC, Year 0 to Year 1 = $10 million – $8 million = $2 million
  • Change in NWC, Year 1 to Year 2 = $8 million – $6 million = $2 million

Therefore, the impact on the company’s free cash flow (FCF) is +$2 million across both periods.

The issue, however, is that an increasing accounts receivable balance implies the company’s cash collection processes might be inefficient, and a rising inventory balance means more inventory is piling up (and not sold).

While A/R and inventory are frequently considered to be highly liquid assets to creditors, uncollectible A/R will NOT be converted into cash. In addition, the liquidated value of inventory is specific to the situation, i.e. the collateral value can vary substantially.

The positive impact on free cash flow (FCF) stems from the growth in accounts payable and accrued expenses year over year (YoY), outpacing the growth in operating current assets.

Since the company is holding off on issuing payments, the increase in payables and accrued expenses tends to be perceived positively.

Until the payment is fulfilled, the cash remains in the possession of the company, hence the increase in liquidity. But it is important to note that those unmet payment obligations must eventually be settled, or else issues could soon emerge.

Net Working Capital Calculator (NWC)

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
Subscribe
Notify of
4 Comments
most voted
newest oldest
Inline Feedbacks
View all comments
Ash
July 10, 2024 5:14 pm

Hi, is it possible to calculate the financing charge associated with the capital we have invested in NWC? Would we apply the WACC on the invested capital? i.e. can we quantify how much it costs the company to have more capital tied up in working capital

Hussam
February 22, 2024 6:16 am

Do we need to deduct Capital lease obligations also from current liabilities to get to operating current liability?

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.