There's no foolproof way to know the future for Northwest Pipe
A cloudy crystal ball
In this series, we use accounts receivable and days sales outstanding to judge a company's current health and future prospects. It's an important step in separating the pretenders from the market's best stocks. Alone, AR -- the amount of money owed the company -- and DSO -- the number of days' worth of sales owed to the company -- don't tell you much. However, by considering the trends in AR and DSO, you can sometimes get a window onto the future.
Sometimes, problems with AR or DSO simply indicate a change in the business (like an acquisition), or lax collections. However, AR that grows more quickly than revenue, or ballooning DSO, can, at times, suggest a desperate company that's trying to boost sales by giving its customers overly generous payment terms. Alternately, it can indicate that the company sprinted to book a load of sales at the end of the quarter, like used-car dealers on the 29th of the month. (Sometimes, companies do both.)
Why might an upstanding firm like Northwest Pipe do this? For the same reason any other company might: to make the numbers. Investors don't like revenue shortfalls, and employees don't like reporting them to their superiors.
Is Northwest Pipe sending any potential warning signs? Take a look at the chart below, which plots revenue growth against AR growth, and DSO:
Source: S&P Capital IQ. Data is current as of last fully reported fiscal quarter. FQ = fiscal quarter.
The standard way to calculate DSO uses average accounts receivable. I prefer to look at end-of-quarter receivables, but I've plotted both above.
Watching the trends
When that red line (AR growth) crosses above the green line (revenue growth), I know I need to consult the filings. Similarly, a spike in the blue bars indicates a trend worth worrying about. Northwest Pipe's latest average DSO stands at 57.2 days, and the end-of-quarter figure is 56.7 days. Differences in business models can generate variations in DSO, and business needs can require occasional fluctuations, but all things being equal, I like to see this figure stay steady. So, let's get back to our original question: Based on DSO and sales, does Northwest Pipe look like it might miss its numbers in the next quarter or two?
The numbers don't paint a clear picture. For the last fully reported fiscal quarter, Northwest Pipe's year-over-year revenue shrank 17.4%, and its AR dropped 16.7%. That looks ok, but end-of-quarter DSO increased 0.8% over the prior-year quarter. It was up 13.1% versus the prior quarter. That demands a good explanation. Still, I'm no fortuneteller, and these are just numbers. Investors putting their money on the line always need to dig into the filings for the root causes and draw their own conclusions.
If you're interested in companies like Northwest Pipe, you might want to check out the jaw-dropping technology that's about to put 100 million Chinese factory workers out on the street – and the 3 companies that control it. We'll tell you all about them in "The Future is Made in America." Click here for instant access to this free report.
- Add Northwest Pipe to My Watchlist.