Financial Laboratory · Ratios
Debtor days
How long do customers take to pay?
Back to 3.6 Efficiency ratio analysis
- IB 3.6 Efficiency ratio analysis
- HL only
- Formula as on the guide’s formula sheet
- Simulated data Example: Emberly Roasters, fictional
As printed on the guide’s formula sheet (p. 64), including its definitions. The 365 in the formula assumes a full year’s figures.
The calculator
Example figures: Emberly Roasters, a fictional business. Simulated data.
The calculator could not start. The worked example below uses the example figures.
The figures
- Debtors, previous year
- $72,700
- Sales revenue, previous year
- $855,600
- Debtors, latest year
- $97,300
- Sales revenue, latest year
- $958,800
Changing these figures needs JavaScript. With it switched off, the page shows the full worked example for the figures above.
Result
These results are for the last complete figures. Correct the figure marked in the inputs to update them.
Debtor days, latest year
37.04 days
+6.03 days on the previous year; worse
- Debtor days, previous year
- 31.01 days
- Change, other things equal
- Worselower is better
Section 01: The formula and the working
Each formula in the guide’s words, then the working with the figures above, step by step.
Debtor days ratio (number of days) = (debtors) ÷ (total sales revenue) × 365
As printed on the guide’s formula sheet (p. 64).
Debtor days, latest year
- Given
- Debtors ($): 97,300
- Total sales revenue ($): 958,800
- Formula
- Debtor days = (debtors ÷ total sales revenue) × 365
- Substitution
- = (97,300 ÷ 958,800) × 365
- Working
- 97,300 ÷ 958,800 = 0.1014810.101481 × 365 = 37.04
- Answer
- 37.04 days
The guide divides by total sales revenue. A business that sells partly for cash would collect its credit sales more slowly than this suggests.
- Unit
- days
- Interpretation
- Customers take 37.04 days on average to pay what they owe.
- Business implication
- Debtor days rose from 31.01 days in the previous year to 37.04 days in the latest year, a change of 6.03 days.
Debtor days, previous year
- Given
- Debtors ($): 72,700
- Total sales revenue ($): 855,600
- Formula
- Debtor days = (debtors ÷ total sales revenue) × 365
- Substitution
- = (72,700 ÷ 855,600) × 365
- Working
- 72,700 ÷ 855,600 = 0.0849700.084970 × 365 = 31.01
- Answer
- 31.01 days
The guide divides by total sales revenue. A business that sells partly for cash would collect its credit sales more slowly than this suggests.
- Unit
- days
- Interpretation
- Customers take 31.01 days on average to pay what they owe.
- Business implication
- Compare it with the latest year’s working above.
Section 02: The chart
Drawn from the figures above, with every value also in a table.
The chart’s figures as a table
| Year | Debtor days |
|---|---|
| Previous year | 31.01 days |
| Latest year | 37.04 days |
Section 03: What moves the ratio
The latest year’s debtor days (37.04 days) when one figure, or one pair of figures, changes by 10 per cent and the rest stay as entered.
| Change | 10% lower | 10% higher |
|---|---|---|
| Debtors | 33.34 days | 40.74 days |
| Sales revenue | 41.16 days | 33.67 days |
Reading. Of these, a change in sales revenue moves it most: from 41.16 days at 10% lower to 33.67 days at 10% higher. Debtors are a balance on one day; a large sale just before the year end can raise debtor days without any change in how fast customers pay.
Section 04: What it means
For the figures above: the reading, the comparisons that give it meaning, and what a manager might do.
What the number means
Customers take 37.04 days on average to pay what they owe.
What to compare it with
Debtor days rose from 31.01 days in the previous year to 37.04 days in the latest year, a change of 6.03 days. Compare it with the credit period the business offers, such as 30 days: a figure well above it means customers are paying late. Compare it with creditor days: a business that waits longer for its customers than it takes to pay its suppliers is, in effect, financing its customers.
Why benchmarks vary
A business that sells for cash, such as a shop, has few debtors; one that sells to other businesses usually gives credit, often a month or two. The guide divides by total sales revenue, so a business that sells partly for cash collects its credit sales more slowly than the ratio suggests.
What a manager might do
Options for a manager, not IB requirements; each has a cost or a risk to weigh.
- Chase late payers and invoice promptly.
- Shorten credit terms, or offer a small discount for prompt payment; customers may move to rivals with better terms.
- Use debt factoring for cash now, at the cost of the factor’s fee.
Section 05: Learn more
- Notes 3.6 Efficiency ratio analysis The full notes for the subtopic.
- Formula sheet The formula sheet The formulae the examination provides, and the ones to learn, on one printable page.
- Practice Debtor days, a practice question Fresh fictional figures, checked as you answer, with the working and the usual slips. Paper 2 style, the platform’s own.
- On a case Ratio desk (Halden Distribution) The same idea worked on a fictional case at the Finance Desk.
- Register Debtor days, worked on a case The calculation in eight parts, with the errors that cost marks.
Arjun Agrawal | The Business Brief, https://the-business-brief-dun.vercel.app/finance-desk/lab/debtor-days/. Original teaching material, not an IB publication. The organizations in the teaching cases are fictional unless a case says otherwise.