Working Capital vs Net Working Capital: Which One To Use in Financial Modeling?

Ever seen a Shark Tank pitch where the sales sound amazing and then a Shark asks, “Okay, but where is the cash?” Now think about a restaurant on a Sunday night. Full tables, non-stop orders. So where did the money go? 

The delivery apps will pay in a couple of days. The paneer supplier wants his money on Friday. Salaries are due on the first. Money comes in slowly and goes out fast and that gap has a name: managing liquidity. And working capital and net working capital are two ways to measure it.

So let us sort out the HOW part. 

What Is Working Capital?

Think of your phone battery. Before you leave home, you check if it can last the whole day or not. Working capital is that check for a business. It answers one simple question: "Do we have enough to survive the next few months?" 

Working Capital Formula: Working capital = Current assets minus Current liabilities

The current assets above are things the business owns that turn into cash within a year and current liabilities are bills it must pay within a year. For our example of restaurant:

Fig 1: Our restaurant in Year 0: current assets of 10 lakh minus current liabilities of 3 lakh gives working capital of 7 lakh.

What Is Net Working Capital?

Now the tricky part. Ask five people for the NWC meaning and you may get two different answers. Funny thing is, both can be right.

In most textbooks, net working capital means exactly the same thing as working capital. The word net here only says that we already subtracted what we owe. So the net working capital formula in your book is the same as the working capital formula above.

In financial modeling, though, NWC means something narrower. Analysts only look at the money tied up in the daily running of the business. That means three things: what customers still owe us (receivables), what is sitting in the kitchen (inventory) and what we owe suppliers (payables). Cash and loans stay out. 

In this article, we call this one operating NWC. 

The NWC formula: Operating NWC = Receivables plus Inventory minus Payables

Let us do a quick net working capital calculation on our restaurant. We ignore the 5 lakh cash and the 1 lakh loan. Receivables of 2 lakh plus inventory of 3 lakh minus payables of 2 lakh gives 3 lakh. That is our net working capital example and it tells us how much money is stuck in the kitchen and in pending payouts just to keep the restaurant running.

Working Capital vs Net Working Capital: The Difference

Same restaurant, same Sunday night, two numbers: 7 lakh and 3 lakh. The 4 lakh gap is just the cash (5 lakh) minus the loan (1 lakh). That is the whole story of working capital vs net working capital.

Fig 2: Same restaurant, two numbers: working capital is 7 lakh and operating NWC is 3 lakh. 

Think of it this way. Working capital checks the whole wallet. Operating NWC checks only the money stuck in the kitchen and in other people's pockets.

How We Treat Working Capital in the Financial Model?

Moving from explanation to execution.In this section, we look at how an analyst estimates working capital and trace its impact through the balance sheet, the cash flow statement, and finally the DCF.

In the model: three little numbers run the show

We usually estimate Net Working Capital (NWC) in our financial models based on historical trends. We analyse how many days of sales remain blocked in receivables, how many days of inventory the business needs to maintain, and how long it takes to pay suppliers.

Let’s take the example of a restaurant:

1. Receivable Days (2 days): Food delivery apps pay the restaurant approximately 2 days after the sale.

2. Inventory Days (9 days): The restaurant maintains enough ingredients to meet approximately 9 days of consumption.

3. Payable Days (6 days): Suppliers allow the restaurant approximately 6 days to make payments.

These assumptions determine how much cash the restaurant needs to fund its day-to-day operations.

Now, here’s the important part: If the payment terms with delivery apps change, the restaurant decides to maintain more inventory, or suppliers offer a longer credit period, the working capital requirement will change.

For example, if receivable days increase from 2 to 5 days, more cash gets blocked in receivables. Similarly, if inventory days increase from 9 to 12 days, the restaurant needs to invest more money in inventory.

All these changes affect the projected Net Working Capital, cash flow and, ultimately, the valuation of the business.

That’s why working capital assumptions are an important driver in a financial model.

Receivables = Sales × Receivable days ÷ 365

Inventory = Cost of ingredients × Inventory days ÷ 365

Payables = Cost of ingredients × Payable days ÷ 365

Receivables use sales, but inventory and payables use the cost of ingredients. This is a mistake many students make. See, nobody pays the supplier based on the price of your biryani, only on what the ingredients cost.

If sales grow 20% in Year 1, here is what the schedule looks like:

Fig 3: The NWC schedule: receivables plus inventory minus payables gives operating NWC for each year. 

Impact on Balance Sheet

These three rows then link straight into the balance sheet. And the model shows us something funny though. In Year 1, working capital jumps from 7 lakh to about 62.6 lakh, while operating NWC moves only from 3 lakh to 3.6 lakh. Did the kitchen suddenly become 20 times healthier? No. Cash piled up from 5 lakh to about 59 lakh, because in our simple model the owner takes no money out.

That is exactly why models use operating NWC. Working capital moves with cash and loan decisions, while operating NWC moves only with the business. And the business is what we are trying to forecast. Also, the balance sheet has a check row at the bottom. If it does not say OK, something in the model is broken.

Impact on the Cash Flow Statement

Now for the owner’s favourite complaint: “Orders are up, so why does my cash feel tight?”

The income statement tells us the restaurant made a profit. The balance sheet tells us what it owns and owes. Neither one tells us where the cash went. That is the job of the cash flow statement, and it is where working capital finally touches real money.

Here is how an analyst builds it:

1. Take the receivables, inventory and payables rows from the NWC schedule.

2. For each row, subtract last year’s balance from this year’s balance.

3. Apply one rule: if an asset goes up, cash goes out. If a liability goes up, cash stays in.

Let us run Year 1 of our restaurant:

1. Receivables rise from 2.00 to 2.40 lakh. Customers owe us more, so cash is -0.400.

2. Inventory rises from 2.97 to 3.56 lakh. More money is sitting in the kitchen, so cash is -0.594.

3. Payables rise from 1.98 to 2.38 lakh. We are holding on to the supplier’s money a little longer, so cash is +0.396.

Add them up and we get about -0.598, which rounds to 0.60 lakh. Look at that number carefully. It is exactly the change in net working capital (3.59 minus 2.99). The cash flow statement is not a new calculation. It is the same change, split into three lines so we can see which habit caused it. Smart modelers add a check cell for this: the three lines must equal minus the change in NWC, or something is broken.

These lines sit under cash flow from operations, below net income and depreciation. In Year 1, net income is about 58.59 lakh, we add back 5.00 lakh of depreciation and subtract the 0.60 lakh stuck in working capital. That gives cash flow from operations of about 62.99 lakh. After capex of 8 lakh and the 1 lakh loan repayment, cash rises by about 53.99 lakh and that closing cash flows back to the balance sheet. This is how the three statements lock together.

Fig 4: Cash flow statement: higher receivables and inventory take cash out, and higher payables keep cash in.

Two things to watch while building it:

1. Use the three operating rows, not total working capital. Cash is the output of this statement. If we used working capital, which already contains cash, cash would depend on itself and the model would go circular.

2. Use the balance check to find mistakes. If one row is missing, the balance sheet is off by exactly that row’s change. If one sign is flipped, it is off by exactly twice that row’s change. That quick clue saves a lot of “why will this not balance” hours.

Impact on Free Cash Flow and the DCF

A DCF values the business, not the owner’s bank account, so it does not start from net income. It starts from free cash flow: the cash left after running and maintaining the restaurant, before any loan interest.

Free cash flow = NOPAT + Depreciation - Capex - Increase in NWC

In Year 1, that is 58.67 + 5.00 - 8.00 - 0.60, which gives 55.07 lakh. If NWC had fallen instead of risen, we would add it back. In our restaurant, the NWC line is only about 1% of free cash flow, because restaurants get paid fast. Nobody lets you eat biryani on credit, except the delivery apps. In a manufacturing or retail business, it can be much bigger, so check its size before forecasting.

Next, the model does two more steps:

1. Discounting: Cash in Year 5 is worth less than cash today, so each year’s free cash flow is multiplied by a discount factor at 12% WACC. The five forecast years together are worth about 254 lakh today.

2. Terminal value: After Year 5, the restaurant keeps going. We estimate that with Year 5 free cash flow × (1 + 4%) ÷ (12% - 4%), which is about 1,149 lakh or about 652 lakh in today’s money.

Add them and the enterprise value is about 906 lakh with about 72% of it coming from the terminal value.

Fig 5: DCF output: free cash flow is discounted at 12% and added to the terminal value to reach an enterprise value of about 906 lakh. 

This is where NWC deserves a second look. Because 72% of the value sits in the terminal value, whatever NWC outflow is in Year 5 gets repeated forever. With our assumptions, every extra 1 lakh of NWC outflow in Year 5 cuts the enterprise value by about 7.4 lakh (our calculation: 1 × 1.04 ÷ 0.08 × 0.567). That is why the last year’s NWC is never an afterthought.

There is one more point a careful analyst checks. Our Year 5 sales grow 8%, but the terminal value assumes 4%. So Year 5’s NWC increase (about 0.41 lakh) is too high for the terminal assumption. A deeper model would normalise it to NWC × terminal growth, about 5.49 × 4%, or 0.22 lakh. Our simple model does not do this, but it is a good habit for real work.

Stress Testing the Working Capital Assumptions

A forecast assumes the restaurant’s habits stay the same. Real life rarely cooperates. A delivery app can change its payout cycle, a supplier can tighten credit after one late payment, and the owner can overstock before a festival. A stress test asks one simple question: what does the model look like if the habits turn against us?

Here is how we build it:

1. The assumptions sheet has two columns of days, one for the base case and one for the stress case.

2. One selector cell picks which column the model uses, with =CHOOSE(selector, base, stress).

3. Every NWC row points to that live column, so flipping one cell updates the NWC schedule, the cash flow statement, free cash flow and the DCF together.

4. Year 0 always stays on base days. Otherwise, the first forecast year shows a fake jump caused by changing the past.

How do we pick the stress numbers? Not randomly. We look at the worst year of the last three to five years, check the contract terms and compare with similar businesses. For our restaurant, we assume the apps pay in 7 days instead of 2, like a friend who says “two minutes” and shows up an hour later. We also assume the supplier wants payment in 3 days instead of 6.

Before running it, it helps to know the price of one day in Year 1:

1. One receivable day equals sales ÷ 365, which is 438 ÷ 365, or 1.2 lakh.

2. One inventory day or payable day equals the cost of ingredients ÷ 365, which is about 0.40 lakh.

So receivable days going from 2 to 7 locks 5 × 1.2 = 6.0 lakh more cash. Payable days going from 6 to 3 removes 3 × 0.40 = about 1.2 lakh of supplier funding. Together, that is about 7.2 lakh. This also tells us something useful: receivable days are the expensive habit, so for a restaurant, the payout timing of the delivery apps is the first thing to watch.

Fig 6: Stress test: slower app payouts and a stricter supplier push NWC up and cut Year 1 cash.

Now follow the shock through the model:

1. Cash flow statement: The receivables line goes from -0.40 to about -6.40. The payables line flips from +0.40 to about -0.79, because we are now paying suppliers faster than our bills grow. The total NWC effect goes from -0.60 to about -7.79 lakh.

2. Free cash flow: Year 1 drops from 55.07 to 47.88 lakh.

3. DCF: Enterprise value falls from about 906 lakh to about 891 lakh, which is about 15 lakh or 1.7% lower.

Why does the valuation barely move? Because a restaurant carries very little NWC, and most of this shock hits in a single year. But look at the cash: the restaurant has about 7.2 lakh less cash in one year, with the same sales and the same profit. The valuation says the business is fine, but the cash box says otherwise. That is exactly what managing liquidity is about, and it is what a stress test is for.

Which One Should You Use?

It depends on who is asking.

1. A bank approving a loan: check the working capital requirement of the business to understand the liquidity position of the borrower and how sales convert into cash.

2. A quick health check of the balance sheet: look at working capital to understand where cash is getting tied up. If inventory keeps rising year over year or quarter over quarter, it can be a sign of dead stock sitting on the balance sheet.

3. A three statement model: forecast operating NWC to understand how much cash the business will need as it grows and when it may need extra funding.

4. A DCF: use the change in operating NWC to understand how much cash growth locks up, so free cash flow is not overstated.

5. A deal or acquisition: check operating NWC against the agreed normal level, often called the NWC peg, to understand whether the business is handed over with enough working capital to keep running.

Is This Only for Small Restaurants? NO

Restaurant owners are not the only ones who play this game. Apple does it too, just with bigger plates.

At the end of its 2024 financial year, Apple had about $153 billion in current assets and $176 billion in current liabilities, so its working capital was roughly negative $23.4 billion. That looks scary. But using the NWC formula on selected items, receivables plus inventory minus payables, we get about $4.6 billion. That is our own calculation using customer receivables of $33.4 billion, vendor non-trade receivables of $32.8 billion, inventory of $7.3 billion and accounts payable of $69.0 billion. It is not a figure Apple reports as its working capital.

Why so small? Look at the days. Apple collects from customers in about 31 days and sells its stock in about 13 days, but takes around 120 days to pay its suppliers. In restaurant terms, Apple eats first and pays the bill four months later. These are rough numbers because we used year end balances and models often use average balances instead. So a negative working capital number is a reason to look deeper not a reason to panic.

Fig 7: Apple FY2024: working capital is negative $23.4 billion, but the operating figure is about $4.6 billion. 

Source: Apple Inc., FY2024 Form 10-K and financial statements (net sales, cost of sales and balance sheet figures). The approximately $4.6 billion figure and the days are our own calculations, using year end balances.

Key Points You Should Remember

• Working capital is current assets minus current liabilities. That working capital formula has nothing extra.

• In textbooks, net working capital means the same thing. In financial models, the NWC formula is receivables plus inventory minus payables, with cash and debt left out.

• In working capital vs net working capital, working capital moves with cash and loans, while operating NWC moves only with the business.

• Receivables use sales. Inventory and payables use cost of goods sold.

• The change in net working capital flows into the cash flow statement. An increase absorbs cash and a decrease releases cash.

• In a DCF, an increase in NWC lowers free cash flow.

• The days assumptions can move cash and valuation even when sales do not change.

• When you compare companies, use the same net working capital formula for all of them.

Learn Financial Modeling the Easy Way

NWC is just the beginning. At The WallStreet School, we take you from the basics to full three statement models and DCFs, one simple example at a time. 

Visit The WallStreet School and start building models you actually understand.

People Also Ask About Working Capital vs Net Working Capital

1. What is the NWC meaning?
   Net working capital commonly means current assets minus current liabilities. In financial models, NWC may instead refer to operating working capital, so always check the definition.

2. What is the net working capital formula?
   The standard formula is current assets minus current liabilities. The operating NWC formula used in models is receivables plus inventory minus payables.

3. What is the working capital formula?
   Current assets minus current liabilities. Nothing extra.

4. How do we do a net working capital calculation in a model?
   Forecast receivables from sales and receivable days, then inventory and payables from cost of goods sold and their days. Add receivables and inventory, then subtract payables.

5. Why does the change in net working capital matter?
   It shows how much cash operating balances absorb or release each year. An increase lowers free cash flow, and a decrease raises it.

6. What is the difference in working capital vs net working capital?
   Working capital includes cash and debt, so it moves with financing decisions. Net working capital in a model includes only receivables, inventory and payables, so it shows the cash tied up in running the business.

7. How is net working capital used in a DCF?
   The increase in operating NWC is subtracted when we calculate free cash flow. Because the terminal value uses the final year's cash flow, the last year's NWC assumption matters a lot.