A company’s DSO jumped from 45 to 75 days while revenue grew only 5%. What could explain this, and what would you investigate to determine if it is a temporary or structural problem?
AdvancedModel answer
Possible explanations include loosening credit terms to stimulate sales, poor collection processes, channel stuffing (shipping goods but not booking true sales), a shift in customer mix toward slower‑paying clients, or the presence of one or two very large, late‑paying invoices. To assess whether it is temporary or structural, I would pull AR aging schedules to see if the increase is due to a few specific accounts that are past due but likely to pay soon, or broad‑based deterioration. I would compare the DSO increase to peers and industry averages; if the whole industry is stretching terms, it may be competitive. I would also talk to management about their credit policy changes and check if revenue guidance increased, if not, the looser terms didn’t stimulate growth, indicating a problem. If write‑offs are rising, the DSO increase is likely structural and will require an increase in bad‑debt expense.
Follow-up pressure:
- How would this alter your UFCF forecast? Would you simply project a higher DSO, or would you also build in higher bad debt?
- What if the company explains that they sold a large multi‑year contract with milestone payments that caused the spike? How would you separate that from the base DSO trend?
- If the DSO increase is due to channel stuffing, what other financial statement anomalies would you look for (e.g., inventory levels, accruals, cash flow vs. net income)?
This is an advanced Superday-level question with a full model answer, part of IB Atlas's practice bank.
Start freeRelated topics
- A company has net working capital of -$50M. Is that a sign of financial distress or operational efficiency? Explain the circumstances that lead to negative NWC and when it becomes a risk.
- A company reports $360M sales, $30M AR, $240M COGS, $60M inventory, $20M AP, and $10M accrued expenses (all operating and related to COGS). Using a 360‑day year, calculate DSO, DIO, DPO, and the cash conversion cycle. The company then pivots to a subscription model where customers pay $60M annually upfront. Qualitatively, how does this shift affect the CCC and why?
- Walk me through the three financial statements: what does each one measure, and over what time frame?
- What is the difference between COGS and SG&A? Give two examples of costs that belong in each for a manufacturing company.
- Walk me through the balance sheet: what are the major sections and how are line items ordered within each?