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.

Previous year
Latest year
Currency

The labels, workings and results use these words. Emberly Roasters’s figures are in dollars.

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.101481
0.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.084970
0.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.

Debtor days in each yearDebtor days: Previous year 31.01 days; Latest year 37.04 days. Lower is better, other things equal.0 days10 days20 days30 days40 daysPrevious yearPrevious year: 31.01 days31.01 daysLatest yearLatest year: 37.04 days37.04 daysLower is better, other things equal.
Chart Debtor days in each year, measured from zero. The latest year is the darker bar.
The chart’s figures as a table
Debtor days by year
YearDebtor days
Previous year31.01 days
Latest year37.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.

Debtor days, latest year, after a 10% change
Change10% lower10% higher
Debtors33.34 days40.74 days
Sales revenue41.16 days33.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