Login Successful
Your login is successfull, please click here to stay signed in

Cash Flow and DSO

Explainer
Cash Flow and DSO
July 25, 2022 | 10 Min Read
Editor

www.highako.com


"You can be profitable and still be bankrupt. You must closely plan and monitor your cash flow to be successful and stay in business."
Tim Berry, author, president and founder, Palo Alto Software

Cash is King, or at least it should be, for all businesses - no matter the size. Still, many companies focus on profit, rather than on working capital (cash). Profit is important, but positive cash flow is what keeps the company going. By now, we should have all learned that lesson. A lack of working capital was the primary "cause of death" for many U.S. dot-coms in the early 2000s. The same issue was also the reason for many of the bankruptcies filed during the recent financial crisis. Therefore, the primary focus of any business should be positive cash flow management.

What is Cash Flow? Simply put, cash flow is the movement of money in and out of a business. The goal of cash flow management is to decrease the amount of time it takes to collect cash, while increasing the time interval for disbursing it.

The first step in improving cash flow is to determine why there's a cash flow problem. Where is cash tied up?

Some potential cash traps include:

  • Cash sitting in non-interest bearing accounts
  • Unnecessary or underused inventory
  • Fixed assets: building, equipment, cars, etc.
  • Loans to officers, employees, affiliated companies
  • Uncollected sales (accounts receivable)

One of the most common cash traps is uncollected credit sales, a.k.a. accounts receivable. The focus of this article is on how uncollected sales can negatively impact your cash flow and how the Days Sales Outstanding (DSO) calculation can give you an inside view of the cash trapped in your accounts receivable.

The Accounts Receivable Cash Trap
Selling on credit is a requirement in today's economy. Most companies can't compete domestically or globally unless they can offer credit terms. Unfortunately, too many credit buyers treat credit terms as if they were interest-free, perpetual loans. Their tactic is to drag out payment as long as possible. As a result, many sellers end up with an inordinate investment in accounts receivable tying up their cash flow.

Calculating just how much it costs to carry your receivables is relatively simple. Determine how much interest you would pay per day on your total annual receivables and multiply this by the average number of days it takes you to collect on credit sales (DSO).

You only need three numbers: your total annual receivables, your DSO and interest rate.

The interest rate could be the actual interest you pay for your line of credit, the prime rate, the marginal cost of capital, etc.

Example:
XYZ Company has $20,000,000 in annual credit sales and a DSO of 65 days. We'll use the current U.S. prime interest rate (federal funds rate) of 3.25% and round the results to the nearest dollar.

Cost of carrying receivables:

((Total Receivables x Interest Rate) / 365 (days)) x DSO

 

(($20,000,000 x 3.25% or 0.0325) / 365) x 65 = $115,753

 

Thus, it costs XYZ Company $115,753 in interest every 65 days (or $649,998 annually) to provide its customers $20,000,000 in annual credit facilities.

All well and good. But is this a reasonable investment? Here's one way to determine that. First, benchmark your DSO against the average DSO in your industry. Then, complete the worksheet below to determine your excess investment in receivables. (See Some Sources of Credit and Collection Benchmark Information below.)

Example:

We're assuming the average DSO in XYZ Company's industry is 50 days.

Excess Receivables Investment

XYZ's DSO 65 days
Industry DSO -50 days
Excess Investment in Receivables 15 days
1 Day's Sales (Annual Sales/365) x $54,795
Cash Invested in Excess Receivables $ 821,925
Cost of Borrowing x 3.25%
Annual Interest $ 26,713


In this example, XYZ Company has $821,925 cash invested in excess receivables, plus $26,713 in interest charges, for a total $848,638 cash flow trapped in receivables!

Improving Cash Flow by Reducing DSO
If XYZ Company can reduce its DSO by just 5 days, it can free up almost $283,000 in cash flow. Let's see how.

Example: XYZ Company

Excess Receivables Investment
with DSO = 65 days
Excess Receivables Investment
with DSO = 60 days
Improvement
XYZ's DSO
65 days
XYZ's DSO
60 days
5 days
Industry DSO
-50 days
Industry DSO
-50 days
 
Excess DSO
15 days
Excess DSO
10 days
 
1 Day's Sales
x $54,795
1 Day's Sales
x $54,795
 
Cash Invested
$821,925
Cash Invested
$547,950
$273,975
Cost of Borrowing
x 3.25%
Cost of Borrowing
x 3.25%
 
Annual Interest
$26,713
Annual Interest
$17,808
$8,905

 

If you add the $547,950 improvement in Cash Invested in Receivables with the $17,808 reduced interest costs, you get $565,758 cash flow trapped in receivables.

Now, compare this to the XYZ Company's original cash flow trapped in receivables, which was $848,638.

$848,638 - $565,759 = $282,879

 

XYZ Company was able to reduce their cash flow trapped in receivables by $282,879.

Reducing DSO
As you can see, DSO has a tremendous impact on cash flow. Reducing DSO, even slightly, can go a long way toward improving the health of your company.

The next step, of course, is to find ways to reduce DSO. Answer these questions in each area of your A/R management process to find holes that need to be plugged.

Credit Approval
Are you performing credit evaluations on all new customers? Are your credit terms appropriate and adhered to by your sales department? Do you have a procedure in place for updating credit information on a regular basis? Do you belong to an industry credit group?

Invoicing
Are your invoices accurate and prompt? Are payment terms clearly stated? Do you provide incentives for early pays? Have you considered EIPP (electronic invoice presentment and payment)?

Receivables Management
Do you have a collection process in place? Do you adequately follow-up on customer disputes and late pays? Are you measuring performance against goals? Do you regularly review aging reports? Do you have an understanding as to why customers are paying late (i.e. invoice discrepancies, quality issues, etc.)? Have you trained your customers to pay within terms?

Collections
Do you have employees focused on collections? Are they well trained? Do they have enough time to follow up on all past due accounts? Have you considered outsourcing part of your receivables portfolio (small balances, specific divisions, etc.) for 1st party collections follow-up? Should you consider using a professional 3rd party collection firm?

Just a small improvement in DSO can go a long way toward improving the health of your company -- and a healthy company is in a position to meet the needs of all its stakeholders and customers, making everybody happy.

              


Editor

www.highako.com

Highako.com is a video-first microlearning platform trusted by over 10,000+ Credit and Collections professionals.
Drive skill growth with role-specific, expert video lessons.
Measure practical expertise through hands-on assessments. Connect and collaborate with the largest credit community and get access to ready-to-use templates.

 

              

 

 

              

Related articles

       

blog

 

Explainer

 

10 Min Read
 
blog
blog