Net Working Capital Template

This net working capital template allows you to compute the net working capital using the formula

Net Working Capital (NWC) is the difference between a company’s current assets (net of cash) and current liabilities (net of debt) on its balance sheet. It is the measure of a company’s liquidity and its ability to meet short-term obligations, as well as fund operations of the business. The ideal position is to have more current assets than current liabilities, and thus have a positive net working capital balance.

There are a few different methods for calculating net working capital, depending on what an analyst wants to include or exclude from the value.

Formula:

Net Working Capital = Current Assets (less cash) – Current Liabilities (less debt)

or

NWC = Accounts Receivable + Inventory – Accounts Payable

The first formula above is the broadest (as it includes all accounts) and the second formula is the most narrow (as it only includes three accounts).

Credits to :  Corporate Finance Institute