background
Welcome to Wall Street Prep! Use code at checkout for 15% off.
Wharton & Wall Street Prep Certificates
Now Enrolling for May 2024 for May 2024
:
Private EquityReal Estate Investing
Buy-Side InvestingFP&A
Wharton & Wall Street Prep Certificates:
Enrollment for May 2024 is Open
Wall Street Prep

Working Capital Turnover

Step-by-Step Guide to Understanding the Working Capital Turnover Ratio

Last Updated December 6, 2023

Learn Online Now

Working Capital Turnover

How to Calculate Working Capital Turnover?

The working capital turnover ratio compares a company’s net sales to its net working capital (NWC) in an effort to gauge its operating efficiency.

In practice, the working capital turnover metric is a useful tool for evaluating how efficiently a company uses its working capital to produce more revenue.

To calculate the turnover ratio, a company’s net sales (i.e. “turnover”) must be divided by its net working capital (NWC).

While the working capital metric can be used – i.e. current assets minus current liabilities – the net working capital (NWC) is a more practical measure, since only operating assets and liabilities are included.

  • Non-Operating Assets → Cash and cash equivalents like marketable securities are excluded in the calculation of NWC.
  • Non-Operating Liabilities → Debt and any interest-bearing securities are also removed because they represent financial liabilities.

Working Capital Turnover Formula

The formula for calculating the working capital turnover is as follows.

Working Capital Turnover = Net Sales ÷ Net Working Capital (NWC)

The sales of a business are reported on its income statement, which tracks activity over a period of time.

To match the time period of the numerator with the denominator, using the average NWC balances between the beginning and ending periods is recommended.

However, unless the company’s NWC has changed drastically over time, the difference between using the average NWC value and the ending balance value is rarely significant.

What is a Good Working Capital Turnover Ratio?

The NWC turnover ratio can be interpreted as the dollar amount of sales created for each dollar of working capital owned.

  • High Turnover → Since a higher turnover ratio implies the company’s working capital management is more efficient, most companies aim to increase the number of “turns.”
  • Low Turnover → On the other hand, a lower turnover ratio would suggest the opposite, i.e. the company’s working capital spending and day-to-day management are inefficient.

If a company’s turnover ratio is trailing behind its peers, this may be a sign it may need to further optimize its operational practices, as its sales are insufficient compared to the amount of working capital put to use.

For instance, an NWC turnover ratio of 3.0x indicates that the company generates $3 of sales per dollar of working capital employed.

The turnover ratio portrays the efficiency at which a company’s operations can create sales, which supports the statement from earlier about net working capital (NWC) being preferable over working capital.

In order words, assets such as cash and liabilities such as debt are financial assets that are not necessarily tied to the core operations of a company.

In particular, comparisons among different companies can be less meaningful if the effects of discretionary financing choices by management are included.

Working Capital Turnover Calculator

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

dl

Get the Excel Template!

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

Submitting...

Working Capital Turnover Calculation Example

Suppose a business had $200,000 in gross sales in the past year, with $10,000 in returns.

That said, the business made $190,000 in net sales.

  • Net Sales = $200,000 – $10,000 = $190,000

The average balances of the company’s net working capital (NWC) line items – i.e. calculated as the sum of the ending and beginning balance divided by two – are shown below.

  • Accounts Receivable = $60,000
  • Inventory = $80,000
  • Accounts Payable = $40,000
  • Accrued Expenses = $5,000

Using the assumptions above, the net working capital (NWC) equals the difference between operating current assets minus operating current liabilities, which comes out to be $95,000.

  • Net Working Capital (NWC) = ($60,000 + $80,000) – ($40,000 + $5,000) = $95,000

Since we now have the two necessary inputs to calculate the turnover ratio, the remaining step is to divide net sales by NWC.

  • NWC Turnover = $190,000 / $95,000 = 2.0x

The 2.0x working capital turnover ratio we arrived at implies that the business generates $2.00 in net sales for each dollar of net working capital (NWC) employed.

Working Capital Turnover Ratio Calculator

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
0 Comments
Inline Feedbacks
View all comments
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.