Tutorials › VEE Accounting and Finance › Recovering Net Working Capital at Project End

VEE Accounting and Finance · Project Cash-Flow Estimation · Tutorial 417 of 996

Recovering Net Working Capital at Project End

Calculate the terminal cash released from project working capital and distinguish that recovery from working-capital changes already included in operating cash flows.

Intermediate 10 min read

What You'll Learn

  • Define project net working capital using operating current assets and operating current liabilities.
  • Calculate the cash inflow from collecting receivables, realizing inventory, and settling liabilities.
  • Distinguish terminal liquidation from working-capital changes during the final operating period.
  • Identify when full recovery at carrying value is a reasonable assumption.
  • Avoid sign errors and double-counting prior operating cash flows.

Why Working Capital Has a Terminal Cash Flow

A project may require cash to support its day-to-day operations. For example, it may need inventory on hand and may wait to collect customer invoices, while also owing suppliers for materials. That cash is tied up while the project operates. When the project concludes, collecting outstanding receivables, disposing of remaining inventory, and paying operating liabilities can release some or all of the amount invested.

This release is a project cash flow, even though it is not a new sale of equipment or another operating year. Its amount depends on the project-related balances at the end and, where applicable, on the cash actually realized from those balances. The central task is to use consistent timing: account for changes during the final operating period once, then account for the remaining balances as they are liquidated.

Definition: Project net working capital (NWC) is the project’s operating current assets minus its operating current liabilities. A common measure is receivables plus inventory, less operating payables and accrued operating expenses. Include only balances caused by the project and exclude cash and interest-bearing debt from this operating measure.

The exact accounts depend on the forecast. Receivables represent amounts customers owe the project; inventory represents goods or materials held for project operations; and operating payables and accruals represent amounts the project owes suppliers or employees for operating inputs. The key is consistency: include the relevant operating balances on both the investment and recovery sides, and do not include financing balances such as loans in operating NWC.

Calculating the Terminal Release

If the project’s remaining receivables are collected at face value, its inventory is converted to cash at carrying value, and all operating liabilities are settled for their recorded amounts, the terminal release equals the NWC just before liquidation. This is the full-recovery assumption. It is useful for a clean forecast, but it is an assumption, not a guarantee.

$$ \text{NWC}_t = \text{Operating current assets}_t - \text{Operating current liabilities}_t $$
$$ \text{Terminal release at } T = \text{NWC}_{T^-} \quad\text{if all included balances are realized and settled at carrying value} $$

Here \(T^-\) denotes the time immediately before the terminal release. If collections are delayed or incomplete, inventory is sold for less than its carrying amount, or liabilities require a different cash settlement, calculate the actual cash flow from those amounts instead:

$$ \text{Terminal cash release} = \text{Cash collected from project receivables} + \text{Cash realized from project inventory} - \text{Cash paid to settle project operating liabilities} $$

This cash calculation is not always equal to the balance-sheet NWC. The difference can arise because the actual cash received or paid differs from the recorded balances. Any applicable tax consequences of terminal realizations must also be reflected in the project’s cash flows; the examples below explicitly state when they assume no separate tax adjustment.

Why a Decrease in NWC Produces a Cash Inflow

The sign follows from the way changes in working capital enter project cash flows. An increase in NWC uses cash: more cash is tied up in operating assets, net of operating liabilities. A decrease releases cash. If \(\text{NWC}_{t-1}\) is the balance before a period and \(\text{NWC}_t\) is the balance after it, the cash-flow effect of that change is:

$$ \text{Cash-flow effect of NWC change at } t = -\left(\text{NWC}_t-\text{NWC}_{t-1}\right) $$

At the terminal date, suppose the project has NWC of \(W\) immediately before liquidation and zero NWC immediately after all included balances have been collected, realized, or settled. The change caused by liquidation is \(0-W=-W\). Applying the cash-flow rule gives \(-(-W)=W\): a cash inflow. If actual realizations differ from carrying values, use the actual net terminal cash instead of assuming that it equals \(W\).

1
Measure the final operating balance.
Calculate project NWC immediately before terminal liquidation, using the operating accounts included in the forecast.
2
Separate the final-period change.
If the balance changed during the final operating period, include that change through the usual cash-flow effect of \(-\Delta\text{NWC}\).
3
Calculate the terminal realization.
Collect receivables, realize inventory, and settle operating liabilities. Use actual cash amounts if they differ from carrying values.
4
Check for duplication.
Do not count the same collection, inventory cash receipt, or liability payment both in operating cash flows and again as a terminal release.

Worked Example: Full Recovery at Carrying Value

A hypothetical four-year project has, immediately before liquidation, receivables of $84,000, inventory of $126,000, supplier payables of $51,000, and accrued operating expenses of $9,000. Assume all receivables are collected at face value, all inventory is converted to cash for its carrying value, and both liabilities are paid in full. Assume there are no separate tax consequences from these collections, realizations, or settlements. Calculate the terminal release.

Method. Calculate operating NWC from the project balances, then verify it by calculating the actual net cash released.

Step 1: Total operating current assets. Receivables plus inventory are \(84{,}000+126{,}000=\$210{,}000\).

Step 2: Total operating current liabilities. Payables plus accruals are \(51{,}000+9{,}000=\$60{,}000\).

Step 3: Calculate NWC. The project’s NWC immediately before liquidation is \(210{,}000-60{,}000=\$150{,}000\).

Step 4: Verify the cash released. Cash collected and realized is $210,000. Cash paid to settle liabilities is $60,000. Therefore, the net terminal cash release is \(210{,}000-60{,}000=\$150{,}000\).

Check. The calculated cash release equals NWC because the problem assumes full realization and settlement at carrying value. A common mistake is to add receivables and inventory but omit operating liabilities, overstating the release by $60,000.

Keep Final-Period Changes Separate

The terminal release is based on the balances still present immediately before liquidation. It is not necessarily the only NWC-related cash flow in the final year. NWC may increase or decrease as the project operates during that year. That change affects operating-period cash flow; liquidation then releases the balance that remains.

Worked Example: Final-Year Change Plus Terminal Recovery

A hypothetical project has NWC of $148,000 at the end of Year 3. During Year 4, its operating balances change to receivables of $92,000, inventory of $73,000, payables of $38,000, and accrued operating expenses of $7,000, measured immediately before terminal liquidation. Assume the final balances are collected, realized, and settled at carrying value, with no separate tax consequences. Find (1) the Year 4 operating-period cash-flow effect of the NWC change, (2) the terminal release, and (3) their combined Year 4 NWC-related cash flow.

Method. First calculate Year 4 ending NWC and compare it with Year 3 NWC. Then add the liquidation of the ending balance.

Step 1: Calculate Year 4 NWC. Operating current assets are \(92{,}000+73{,}000=\$165{,}000\). Operating current liabilities are \(38{,}000+7{,}000=\$45{,}000\). Thus Year 4 NWC before liquidation is \(165{,}000-45{,}000=\$120{,}000\).

Step 2: Calculate the operating-period change. NWC changes by \(120{,}000-148{,}000=-\$28{,}000\). The cash-flow effect is the negative of that change, so \(-(-28{,}000)=+\$28{,}000\). The operating-period decrease releases $28,000.

Step 3: Calculate terminal recovery. The remaining $120,000 of NWC is released at liquidation under the stated assumptions.

Step 4: Combine the effects. The total Year 4 NWC-related cash flow is \(28{,}000+120{,}000=\$148{,}000\).

Check. The combined amount equals the $148,000 balance at the end of Year 3: the project releases the reduction during Year 4 and then releases what remains. A common mistake is to report the $120,000 terminal release as the entire Year 4 NWC effect, ignoring the $28,000 released as NWC fell during operations.

When Cash Realization Differs from NWC

A project can finish with positive book NWC but recover a different amount in cash. Some customers may not pay their full invoices; inventory may need to be sold below its carrying value; or the cash required to settle an operating liability may differ from its recorded balance. In those cases, do not force the terminal cash flow to equal book NWC. Estimate the actual collections, proceeds, and settlements specified by the project forecast.

This distinction also helps prevent double counting. If a forecast already includes a customer collection as an operating cash receipt, that same collection is not a second terminal receipt. Likewise, an inventory sale already included in forecast operating revenue should not be added again as a separate terminal inventory realization. The terminal calculation should cover only cash flows not already recorded elsewhere in the project timeline.

Worked Example: Partial Receivable Collection and Inventory Realization

A hypothetical project is closing with receivables of $80,000, inventory carried at $110,000, supplier payables of $32,000, and accrued operating expenses of $12,000. The project expects to collect 95% of receivables and to sell the remaining inventory for $92,000. It will settle both operating liabilities in full. Assume no separate tax adjustment for these terminal amounts and that none of the receipts or payments has already been included in another project cash flow. Calculate the actual terminal cash release and compare it with book NWC.

Method. Calculate actual cash from each balance rather than assuming full recovery at carrying value; then compare the result with NWC.

Step 1: Calculate receivable collections. The collection is \(0.95\times80{,}000=\$76{,}000\).

Step 2: Identify inventory proceeds. The stated cash proceeds are $92,000, which is $18,000 below the $110,000 carrying amount.

Step 3: Calculate liability settlement. Total operating liabilities are \(32{,}000+12{,}000=\$44{,}000\), paid in full.

Step 4: Calculate actual terminal cash release. Net cash released is \(76{,}000+92{,}000-44{,}000=\$124{,}000\).

Step 5: Compare with book NWC. Book NWC is \((80{,}000+110{,}000)-44{,}000=\$146{,}000\). The cash release is \(146{,}000-124{,}000=\$22{,}000\) below book NWC. This difference consists of $4,000 of uncollected receivables and $18,000 less cash from inventory than its carrying value.

Check. The shortfall reconciles to \(4{,}000+18{,}000=\$22{,}000\). A common mistake is to report book NWC of $146,000 as cash received despite the stated collection rate and inventory proceeds.

Common Exam Traps

  • Reversing the sign. A decrease in NWC is a cash inflow, not an outflow: its cash-flow effect is \(-\Delta\text{NWC}\).
  • Subtracting liabilities twice. If NWC is already calculated as operating assets less operating liabilities, do not subtract those liabilities again from NWC. In a direct cash calculation, subtract the settlement payments once.
  • Including financing balances. Interest-bearing debt is financing, not an operating current liability in this NWC calculation.
  • Assuming book balances equal cash. Full recovery at carrying value requires an explicit assumption. Otherwise use the expected cash collections, realization proceeds, and settlements.
  • Double-counting cash flows. Include each final collection, sale, or payment once, either within forecast operating cash flows or as part of the terminal release.
Key takeaway: First identify the project’s operating NWC immediately before closure. Then calculate what the remaining balances actually produce or require in cash. Add that terminal release to the cash-flow timeline only once, alongside any separate NWC change during the final operating period.

Check Your Understanding

For each problem, calculate the requested terminal release or NWC cash-flow effect. Unless stated otherwise, assume all balances are project-related, no separate tax adjustment applies, and no amount is duplicated in another cash flow.

  1. A project closes with receivables of $63,000, inventory of $47,000, payables of $22,000, and accrued operating expenses of $8,000. All balances are collected, realized, or settled at carrying value. What is the terminal release? (Answer: $80,000)
  2. A project has terminal receivables of $120,000, inventory of $90,000, payables of $35,000, and accrued operating expenses of $10,000. All balances are realized and settled at carrying value. Calculate its terminal NWC recovery. (Answer: $165,000)
  3. NWC was $96,000 at the end of Year 2 and is $111,000 immediately before liquidation at the end of Year 3. Assume full recovery at carrying value. Find the Year 3 operating-period NWC cash-flow effect, the terminal release, and their combined amount. (Answer: a $15,000 operating-period outflow, a $111,000 terminal inflow, and a net $96,000 inflow)
  4. At closure, receivables of $75,000 will produce $72,000 in cash, inventory carried at $130,000 will produce $105,000, and operating payables and accruals of $48,000 and $12,000 will be paid in full. Find the terminal cash release and its shortfall relative to book NWC. (Answer: $117,000 release; $28,000 shortfall)
  5. A project has receivables of $50,000, inventory carried at $80,000, payables of $30,000, and accrued expenses of $5,000. It will collect 90% of receivables, realize $70,000 from inventory, and settle both liabilities in full. Calculate the actual terminal cash release and compare it with book NWC. (Answer: $80,000 release; $15,000 below book NWC)
Clinical Biostats