Net Working Capital in Project Analysis

Why Net Working Capital Matters in Project Analysis

A project can require more than equipment and other long-lived assets. It may also need resources tied up in day-to-day operations: customers may pay after receiving goods, inventory may need to be on hand before a sale, and suppliers may allow the business time to pay its invoices. Net working capital (NWC) summarizes these operating current assets and liabilities in a single balance-sheet measure.

In project analysis, the relevant quantity is not automatically the company’s total NWC. It is the amount attributable to the project: the project’s operating balances, or the change in company balances caused by undertaking it, compared with the no-project situation. This distinction keeps unrelated existing operations out of the project estimate.

Definition: For a project, net working capital is the project’s operating current assets minus its operating current liabilities. A common simplified measure is accounts receivable plus inventory minus accounts payable. Include other operating current assets or liabilities when the project directly requires or creates them. Exclude financing balances, such as short-term borrowing, from operating NWC.

Which Balances Belong in Project NWC?

The standard components reflect the operating cycle. Accounts receivable arise when the project makes sales on credit and has not yet collected the cash. Inventory includes goods held for sale or materials and work in process required to support the project. Accounts payable arise when the project receives goods or services from suppliers but has not yet paid for them.

Receivables and inventory are operating current assets: resources tied up in the business’s operations. Payables are operating current liabilities: supplier financing that reduces the net resources the business must provide. Other items can matter as well. For example, a project-specific prepaid operating expense may be a current asset, while project-related accrued operating costs may be current liabilities. The classification depends on the item’s operating role, not merely its account name.

Cash is usually excluded from this simplified operating measure. Including cash can make the estimate circular: a project’s cash balance is affected by the cash flows the analysis is trying to evaluate. Short-term debt and similar borrowing are also excluded because they are financing choices, not supplier-provided operating credit. The treatment should be consistent with the definition used in the analysis.

Balance	Typical project treatment	Reason
Accounts receivable	Include	Credit sales have been recognized, but cash has not yet been collected.
Inventory	Include	Operating goods or materials are held to support sales or production.
Accounts payable	Subtract	Supplier credit reduces the project’s net operating investment.
Cash	Usually exclude from operating NWC	It is a cash balance, not an operating asset requirement measured by these components.
Short-term borrowing	Exclude	It is a financing liability rather than an operating liability.

Measuring the Project’s Operating Balances

When a problem supplies target percentages or operating-day assumptions, those inputs can be used to estimate the balances needed to support project activity. Under a steady-activity approximation, a balance can be estimated as the relevant annual flow divided by the number of days in the year, multiplied by the number of operating days represented by the balance. The denominator must match the stated convention.

\begin{aligned} \text{Accounts receivable} &\approx \text{annual credit sales}\times \frac{\text{collection days}}{\text{days per year}},\\ \text{Inventory} &\approx \text{annual cost of goods sold}\times \frac{\text{inventory days}}{\text{days per year}},\\ \text{Accounts payable} &\approx \text{annual purchases}\times \frac{\text{payment days}}{\text{days per year}},\\ \text{Project NWC} &= \text{accounts receivable}+\text{inventory} -\text{accounts payable}. \end{aligned}

These operating-day estimates assume that activity is reasonably even during the year and that the specified days are measured on the same basis as the corresponding annual flow. Receivables are linked to credit sales, not automatically to total sales. Inventory is commonly related to cost of goods sold, while payables are related to purchases. If a problem provides a direct percentage or dollar balance instead, use that information rather than imposing a days-based estimate.

Why Payables Are Subtracted

The NWC formula follows from the resources tied up in operations. A project’s receivables represent sales for which cash is still outstanding, and its inventory represents goods or materials already held. Both require resources to support operations. If suppliers have not yet been paid, however, the business does not need to provide that same amount of resources immediately; the supplier has financed part of the operating requirement.

\begin{aligned} \text{Net operating resources tied up} &= \text{receivables}+\text{inventory}-\text{supplier credit}\\ &= \text{accounts receivable}+\text{inventory}-\text{accounts payable}. \end{aligned}

This explains why accounts payable is subtracted rather than added. The formula is a measure of a balance at a specified date or operating level; it is not itself a project cash-flow schedule. Identifying the correct project balances is the task here. A later cash-flow analysis must separately address how changes in those balances affect cash and when those changes occur.

Worked Example: Estimating NWC From Operating Days

A hypothetical project expects annual sales of $1,200,000, of which 90% are on credit. Its annual cost of goods sold is $720,000, and annual purchases are forecast at $690,000. Assume 360 days per year, 30 collection days, 45 inventory days, and 30 payment days. Estimate the project’s operating NWC.

Method. Estimate each operating balance using its relevant annual flow and operating days, then subtract accounts payable from receivables plus inventory. The 360-day convention is given, so use it consistently.

Step 1: Calculate annual credit sales.

\$1{,}200{,}000\times 0.90=\$1{,}080{,}000

Step 2: Estimate accounts receivable. Daily credit sales are $1,080,000 divided by 360, or $3,000. Thirty collection days imply receivables of $3,000 times 30, or $90,000.

Step 3: Estimate inventory. Daily cost of goods sold is $720,000 divided by 360, or $2,000. At 45 inventory days, inventory is $2,000 times 45, or $90,000.

Step 4: Estimate accounts payable. Daily purchases are $690,000 divided by 360, or $1,916.6667. At 30 payment days, accounts payable is $1,916.6667 times 30, or $57,500.

Step 5: Calculate NWC.

\$90{,}000+\$90{,}000-\$57{,}500=\boxed{\$122{,}500}

Check. The result exceeds receivables alone because inventory adds $90,000, but it is below the sum of receivables and inventory because suppliers provide $57,500 of operating credit. The common mistake of adding payables would produce $237,500, which incorrectly treats supplier financing as another resource tied up in the project.

Project Balances Versus Company Balances

A project is evaluated on an incremental basis. If existing operations already have receivables, inventory, and payables, those balances are not automatically assigned to a new project. Include only balances created by the project, or the project-caused changes in shared company balances. A useful way to check the calculation is to compare the company’s operating balances with the project against the balances without it.

Worked Example: Separating Project NWC From Existing NWC

A hypothetical business has company-wide operating balances of $500,000 in accounts receivable, $300,000 in inventory, and $210,000 in accounts payable before a proposed product launch. The launch requires additional balances of $40,000 in receivables, $36,000 in inventory, and $18,000 in payables. Calculate existing NWC, NWC after launch, and the project-attributable amount.

Method. First calculate NWC without the project. Then add only the project-caused balances to find the with-project total, and compare the two totals.

Step 1: Calculate NWC without the project.

\$500{,}000+\$300{,}000-\$210{,}000=\$590{,}000

Step 2: Calculate company balances with the project. Receivables become $500,000 + $40,000 = $540,000. Inventory becomes $300,000 + $36,000 = $336,000. Payables become $210,000 + $18,000 = $228,000.

Step 3: Calculate NWC with the project.

\$540{,}000+\$336{,}000-\$228{,}000=\$648{,}000

Step 4: Isolate the project amount. The difference is $648,000 - $590,000 = $58,000. Directly calculating the project components gives the same answer: $40,000 + $36,000 - $18,000 = $58,000.

Check. The company-wide balance after launch is $648,000, but the launch’s attributable NWC is $58,000. Using the whole $648,000 as the project amount would incorrectly charge the project for existing operations.

Reading Project Effects on Receivables, Inventory, and Payables

A forecast should connect each balance to a project operating cause. For receivables, ask whether sales are made on credit and what collection period is expected. For inventory, identify the goods or materials that must be held and the relevant inventory level. For payables, identify supplier purchases and the payment terms. These questions prevent a balance from being included merely because it appears on a company balance sheet.

When the project shares customers, suppliers, or facilities with existing operations, a project-related change may be smaller or larger than the project’s standalone balance. For instance, if the project changes how quickly existing customers pay, the resulting receivables change is relevant only to the extent it is caused by the project. Compare the forecast with the project to the forecast without it; do not simply attribute all company operating balances to the project.

Worked Example: Combining Operating-Day Estimates With Existing Balances

A hypothetical service-and-product project has annual credit sales of $730,000, annual cost of goods sold of $438,000, and annual purchases of $438,000. Assume a 365-day year, 20 collection days, 30 inventory days, and 15 payment days. The company’s existing NWC is $250,000. Estimate the project’s own NWC and the company’s NWC with the project, assuming these are the only project-caused balance changes.

Method. Estimate the three project balances from annual operating activity, calculate the project’s net amount, and add that amount to the existing NWC.

Step 1: Estimate accounts receivable. Annual credit sales per day are $730,000 divided by 365, or $2,000. Thus receivables are $2,000 times 20, or $40,000.

Step 2: Estimate inventory. Daily cost of goods sold is $438,000 divided by 365, or $1,200. Inventory at 30 days is $1,200 times 30, or $36,000.

Step 3: Estimate accounts payable. Daily purchases are $438,000 divided by 365, or $1,200. Payables at 15 days are $1,200 times 15, or $18,000.

Step 4: Calculate project NWC.

\$40{,}000+\$36{,}000-\$18{,}000=\boxed{\$58{,}000}

Step 5: Calculate company NWC with the project. Add the project amount to the existing $250,000: $250,000 + $58,000 = $308,000.

Check. The project’s calculated amount is $58,000, not $308,000; the latter is the company-wide total under the stated assumption. The common mistake avoided here is reporting the company total as if it were the project-specific requirement.

Common Classification and Calculation Traps

Adding rather than subtracting payables. Accounts payable represents operating credit from suppliers, so it reduces NWC.
Using total sales for receivables when only some sales are on credit. Apply collection days to credit sales unless the problem explicitly gives a different basis.
Using sales instead of cost of goods sold for inventory days. Use the flow specified by the problem; inventory days are commonly based on cost of goods sold.
Using a company-wide balance as a project balance. Compare with-project and without-project operating balances to isolate the project-caused amount.
Including financing accounts in operating NWC. Cash and short-term borrowing are generally excluded from the simplified operating measure used here.
Mixing day-count conventions. If the problem specifies 360 days, do not silently use 365; the assumed denominator changes every days-based estimate.

Key takeaway: Project NWC is operating current assets less operating current liabilities. Identify project-caused receivables and inventory, subtract project-caused payables, and distinguish that incremental amount from the company’s existing NWC.

Check Your Understanding

For each problem, identify the operating balances before calculating NWC. Use the stated day-count convention.

A hypothetical project has annual credit sales of $912,500, cost of goods sold of $547,500, and purchases of $730,000. With 365 days per year, estimate balances using 24 collection days, 36 inventory days, and 18 payment days. What is project NWC? (Answer: $78,000)
A project forecasts annual credit sales of $1,095,000, cost of goods sold of $730,000, and purchases of $657,000. Assume 365 days per year, 15 collection days, 50 inventory days, and 25 payment days. Calculate project NWC. (Answer: $100,000)
A project expects annual credit sales of $2,190,000, cost of goods sold of $1,460,000, and purchases of $1,095,000. Using 365 days, estimate receivables at 12 days, inventory at 28 days, and payables at 20 days. Find its operating NWC. (Answer: $124,000)
Before a hypothetical project, a company has receivables of $320,000, inventory of $250,000, and payables of $180,000. The project causes increases of $35,000 in receivables, $48,000 in inventory, and $22,000 in payables. Calculate the project-attributable NWC and the company’s NWC after the changes. (Answer: Project NWC $61,000; company NWC $451,000)
A project requires receivables of $80,000, inventory of $55,000, cash of $12,000, prepaid operating insurance of $8,000, payables of $31,000, short-term borrowing of $20,000, and accrued project payroll of $7,000. Under the operating NWC definition, include directly related operating current assets and liabilities but exclude cash and financing balances. Calculate project NWC. (Answer: $105,000)

What You'll Learn