search

Working Capital Analysis: How to Spot Liquidity Problems Early

5/21/2026

Working capital is the most-computed and least-understood figure in financial analysis. Current assets minus current liabilities produces a number, the number is compared to last year, and almost nothing is learned.

The reason is that the level tells you very little and the composition and velocity tell you nearly everything. Two companies with identical working capital can be in entirely different condition — one holding cash and current receivables, the other holding obsolete inventory and receivables nobody will pay. And the second company's current ratio may well be higher.

This post is about the analysis that actually detects a liquidity problem, ideally two quarters before the client notices it.

Why the Ratios Mislead

The current ratio — current assets over current liabilities — is the most cited and most easily inflated measure in finance. It rises when inventory builds because nothing is selling. It rises when receivables age because nobody is collecting. It rises when a company stops paying suppliers and then reclassifies nothing.

A rising current ratio can be a symptom rather than a strength, and this is the single most useful thing to understand about it. A ratio moving from 1.6 to 2.2 while sales are flat is not an improvement; it is a question.

The quick ratio removes inventory, which helps, and remains a point-in-time level measure that says nothing about how fast anything moves.

Working capital as a percentage of revenue is genuinely useful because it scales — it tells you how much working capital this business requires per dollar of sales, which is what determines whether growth will consume cash.

The cash conversion cycle is the measure that matters: days inventory outstanding plus days sales outstanding minus days payable outstanding. It converts the balance sheet into a duration — how many days of cash the business has tied up between paying for inputs and collecting from customers — and it is trendable, comparable, and directly actionable.

Diagnose the Components, Not the Total

Receivables

Read the aging, not the average. Days sales outstanding is an average, and averages conceal exactly what you are looking for. A portfolio with a good average DSO and a growing tail beyond ninety days has a collection problem the average is hiding.

Compute DSO properly. Dividing receivables by average daily revenue for a single recent period distorts badly where revenue is seasonal or growing. The more reliable approach is a countback: work backward from the balance, subtracting each prior period's revenue until the receivable balance is exhausted, and count the days. It takes five minutes and it produces a figure that survives seasonality.

Look at concentration. The proportion of receivables owed by the largest customers is a liquidity risk as well as a credit risk — one customer's payment delay becomes the company's cash crisis.

Watch credit memos and returns. Rising credit memo volume can indicate quality problems, billing disputes, or revenue recognized on terms customers are contesting — and each of those delays collection.

Check for receivables that will never be collected but remain on the balance sheet supporting a current ratio.

Inventory

Aging and turns by category, not in aggregate. Total inventory turns of five can comprise fast-moving stock turning twelve times and dead stock turning once.

Distinguish a demand miss from a deliberate build. Inventory rising is either a business that expected sales it did not get, or a business positioning for sales it expects. Those have opposite implications and the balance sheet cannot tell you which. Ask.

Assess the obsolescence reserve honestly. An aging inventory profile with an unchanged reserve percentage is a reserve that has not been revisited.

Watch for inventory rising faster than sales, which is the clearest single warning in the whole analysis.

Payables

The DPO trend and its cause. Extending payment terms is a legitimate working capital strategy when negotiated and a distress signal when unilateral. The distinguishing question: did the supplier agree?

Are early payment discounts still being taken? A company that stops taking discounts it previously took is telling you something about its cash position that nothing else on the balance sheet reveals. This is an unusually reliable and unusually early indicator.

Are there payables past due, and is the aging deteriorating?

The components nobody looks at

Deferred revenue and customer deposits are a source of cash that is not debt, and a falling deferred revenue balance is a leading indicator — bookings decline before revenue does, so this line turns down before the income statement does.

Prepaid expenses rising materially can indicate suppliers demanding payment in advance, which is a signal about how the company's credit is viewed.

Accrued liabilities, where a sudden decline may mean an accrual was released to support earnings.

The current portion of long-term debt, which is a call on the same cash and is frequently omitted from informal working capital discussions.

The Nine Early Warning Indicators, Ranked

If you monitor nothing else, monitor these — roughly in order of how reliably they precede trouble.

  1. DSO rising while revenue is flat or falling. Collection is deteriorating and the business cannot grow its way out of it.
  2. Inventory rising faster than sales.
  3. DPO rising with no negotiated change in terms.
  4. Revolver borrowings increasing while the company reports profits. Profitable and borrowing more is the signature of working capital consumption, and it is the pattern most often dismissed as growth.
  5. Early payment discounts no longer taken.
  6. Receivable concentration increasing, particularly where the largest customer is also slowing.
  7. Credit memos and returns rising as a proportion of sales.
  8. Deferred revenue or customer deposits declining.
  9. The gap between operating cash flow and net income widening, which is the aggregate expression of everything above and is covered in our post on reading the cash flow statement.

Any one of these deserves a question. Three of them together is a liquidity problem in progress, whatever the current ratio says.

The Growth Trap

The arithmetic worth explaining to every growing client, because it puts profitable businesses out of business.

A company with a cash conversion cycle of, say, ninety days has ninety days of sales tied up in working capital at all times. Growing revenue requires growing that investment proportionally. A business growing thirty percent has to fund thirty percent more working capital — before it collects any of the additional profit, which arrives later.

Which produces a hard limit: the rate at which a business can grow on internally generated cash is a function of its margin and its cash conversion cycle. A high-margin business with a short cycle can grow quickly self-funded. A thin-margin business with a long cycle cannot grow at all without external funding, regardless of how profitable it is.

The practical consequences for advising a client:

Model the working capital requirement of the growth plan before the growth happens. A revenue plan without a working capital projection attached is incomplete.

Recognize that shortening the cycle raises the self-funded growth rate more cheaply than borrowing does. Ten days off DSO is permanent and free; a line of credit is neither.

Understand that a fast-growing client asking for a bigger line is often correct. Working capital growth is a legitimate use of revolving credit, and denying it can force the client to slow growth. The question is whether the borrowing funds a cycle or a deficit — the first is fine and the second is not.

Seasonality Will Fool You

Point-in-time balance sheet analysis misleads in any seasonal business, and most businesses are more seasonal than they think.

The remedies: use average balances rather than period-end, look at the same period last year rather than the prior period, and where the data allows, build a rolling twelve or thirteen period view so the seasonal shape is visible.

A related caution: a period-end balance sheet may have been managed. Collections pushed hard in the final week, payments deferred to the following period, and inventory shipments timed — none of it improper, all of it making the period-end snapshot unrepresentative. Comparing period-end balances to mid-period balances, where available, reveals it.

Structured coverage is available through Analyzing Financial Statements, the Certificate in Financial Reporting and Analysis, the Business Credit Analysis Bootcamp, the Guide to Cash Management, and the financial statements training catalog.

The Levers, in Order of Speed and Cost

When a client has a working capital problem, the interventions available — cheapest and fastest first:

Collections discipline. Usually the largest immediate win and the most neglected. Invoice the day the work is complete rather than at month end, call before the due date rather than after, escalate on a schedule, and have one person accountable for the aging. Most small businesses recover a meaningful number of DSO days from process alone, with no change in terms.

Credit screening and terms. Stop extending open terms to customers who do not warrant them, and set limits.

Deposits and progress billing. For project work, this is transformative — the difference between funding a project and being funded by it.

Inventory reduction, starting with the dead stock that is consuming cash and space and generating an obsolescence reserve.

Payables terms, negotiated. Ask suppliers for longer terms explicitly. Many will agree, and it is materially better than stretching.

Financing. A revolving line is the right instrument for a working capital cycle and the wrong one for a structural deficit. A client borrowing to fund losses is not solving a working capital problem.

What a Lender Will Actually Count

Worth knowing because clients are surprised by it.

An asset-based lender's borrowing base excludes categories a client assumes are collateral: receivables past a stated age, balances from a customer exceeding a concentration limit, receivables from affiliates or from customers who also owe the client money, foreign receivables, unbilled amounts, and — on the inventory side — work in process, slow-moving categories, and consignment goods.

Which means a client with substantial receivables and inventory can have a much smaller borrowing base than they expect, and the way to avoid that conversation going badly is to run the eligibility test before applying.

Build the Dashboard

A practitioner can construct this monthly from data every client already has, and it is among the highest-value recurring services a small firm can offer.

Six lines, monthly, with twelve months of history: DSO (countback), DIO, DPO, cash conversion cycle, working capital as a percentage of trailing revenue, and revolver balance. Plus the receivable aging distribution and the largest-customer concentration.

That is one page, it takes an hour to build and fifteen minutes a month to update, and it will identify a deteriorating client before their bank does. Building it well is a spreadsheet exercise — Essential Excel Skills and High Impact Excel: Dashboard Edition cover the mechanics.

Where Analysis Goes Wrong

  • Reading the working capital total and stopping
  • Treating a rising current ratio as good news
  • Using average DSO instead of the aging distribution
  • Computing DSO on one period's revenue in a seasonal or growing business
  • Aggregate inventory turns, concealing dead stock
  • Missing the discount-no-longer-taken signal, which is one of the earliest available
  • Ignoring deferred revenue as a leading indicator
  • Point-in-time analysis in a seasonal business, or on a managed period-end balance sheet
  • No working capital projection attached to a growth plan
  • Recommending financing before collections process improvement
  • Not testing borrowing base eligibility before a client applies

The framing that makes this stick for a client: profit is an opinion about a period and working capital is a fact about right now. A business can be profitable and insolvent at the same time, and the cash conversion cycle is the number that tells you which way it is heading — long before the current ratio notices.

Frequently Asked Questions

Why is the current ratio a poor liquidity measure?

Because it rises for bad reasons. It increases when inventory builds because nothing is selling, when receivables age because nobody is collecting, and it is unaffected by a company that has simply stopped paying suppliers. A current ratio improving while sales are flat is a question rather than an improvement.

What is the most useful working capital measure?

The cash conversion cycle — days inventory plus days sales outstanding minus days payable outstanding. It converts balance sheet levels into a duration showing how many days of cash are tied up between paying for inputs and collecting from customers, and it is trendable, comparable, and directly actionable.

How should days sales outstanding be calculated?

By a countback rather than by dividing receivables by average daily revenue. Work backward from the receivable balance, subtracting each prior period's revenue until the balance is exhausted, and count the days. That method survives seasonality and growth, which the simple average does not.

What is the earliest warning sign of a cash problem?

Two compete. Days sales outstanding rising while revenue is flat or falling, and a company that has stopped taking early payment discounts it previously took. The second is unusually reliable and unusually early, because it reflects a cash decision management made before anything else on the balance sheet moved.

Why can a profitable company run out of cash while growing?

Because growth requires proportionally more working capital, funded before the additional profit is collected. The rate at which a business can grow on internal cash is a function of its margin and its cash conversion cycle — a thin-margin business with a long cycle cannot grow without external funding regardless of profitability. Any revenue plan should have a working capital projection attached.

What will a lender exclude from a borrowing base?

More than clients expect: receivables past a stated age, balances exceeding a customer concentration limit, affiliate receivables, accounts where the customer also owes the client money, foreign and unbilled receivables, and on the inventory side work in process, slow-moving categories, and consignment goods. Running the eligibility test before applying prevents an unpleasant conversation.

CPATrainingCenter.com 9715 Rod Road Suite A Alpharetta, GA 30022 1-770-410-1219 support@CPATrainingCenter.com
Certifications CPA CFP Enrolled Agent Payroll
Licensing & Events Securities Insurance Webinars Seminars
Stay Up To Date
Need Training Or Resources In Other Areas? Try Our Other Training Center Sites:
HR Banking Financial Services Insurance Mortgage Payroll Real Estate Safety
Training By Delivery Format & Subjects Covered:
Special Promotions Online Training Resource Materials Seminars Webinars All CPA/Accounting Subjects
Facebook Copyright CPATrainingCenter.com 2026