Financial Laboratory · Ratios

Creditor days

How long does the business take to pay its suppliers?

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
Trade creditors, the suppliers waiting to be paid.
Latest year
Trade creditors, the suppliers waiting to be paid.
Currency

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

The figures

Creditors, previous year
$52,100
Cost of sales, previous year
$462,000
Creditors, latest year
$72,600
Cost of sales, latest year
$541,500

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.

Creditor days, latest year

48.94 days

+7.78 days on the previous year; a matter of judgement

Creditor days, previous year
41.16 days
Change, other things equal
A matter of judgementwhether higher is better depends on the business

Section 01: The formula and the working

Each formula in the guide’s words, then the working with the figures above, step by step.

Creditor days ratio (number of days) = (creditors) ÷ (cost of sales) × 365

As printed on the guide’s formula sheet (p. 64).

Creditor days, latest year

Given
  • Creditors ($): 72,600
  • Cost of sales ($): 541,500
Formula
Creditor days = (creditors ÷ cost of sales) × 365
Substitution
= (72,600 ÷ 541,500) × 365
Working
72,600 ÷ 541,500 = 0.134072
0.134072 × 365 = 48.94
Answer
48.94 days
Unit
days
Interpretation
The business takes 48.94 days on average to pay its suppliers.
Business implication
Creditor days rose from 41.16 days in the previous year to 48.94 days in the latest year, a change of 7.78 days.
Creditor days, previous year
Given
  • Creditors ($): 52,100
  • Cost of sales ($): 462,000
Formula
Creditor days = (creditors ÷ cost of sales) × 365
Substitution
= (52,100 ÷ 462,000) × 365
Working
52,100 ÷ 462,000 = 0.112771
0.112771 × 365 = 41.16
Answer
41.16 days
Unit
days
Interpretation
The business takes 41.16 days on average to pay its suppliers.
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.

Creditor days in each yearCreditor days: Previous year 41.16 days; Latest year 48.94 days. Whether higher is better depends on the business.0 days20 days40 days60 daysPrevious yearPrevious year: 41.16 days41.16 daysLatest yearLatest year: 48.94 days48.94 daysWhether higher is better depends on the business.
Chart Creditor days in each year, measured from zero. The latest year is the darker bar.
The chart’s figures as a table
Creditor days by year
YearCreditor days
Previous year41.16 days
Latest year48.94 days

Section 03: What moves the ratio

The latest year’s creditor days (48.94 days) when one figure, or one pair of figures, changes by 10 per cent and the rest stay as entered.

Creditor days, latest year, after a 10% change
Change10% lower10% higher
Creditors44.04 days53.83 days
Cost of sales54.37 days44.49 days

Reading. Of these, a change in cost of sales moves it most: from 54.37 days at 10% lower to 44.49 days at 10% higher. A higher figure is neither good nor bad in itself: it is cash kept, at the cost of goodwill and possibly of discounts.

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

The business takes 48.94 days on average to pay its suppliers.

What to compare it with

Creditor days rose from 41.16 days in the previous year to 48.94 days in the latest year, a change of 7.78 days. Compare it with the credit terms suppliers offer, and with debtor days: paying suppliers later than customers pay you keeps cash in the business.

Why benchmarks vary

A large retailer may negotiate long credit periods from its suppliers; a small business may be given little credit at all. Paying later keeps cash in the business, but suppliers may withdraw credit, raise prices or put orders on hold if payments are late, and paying small suppliers late raises ethical questions.

What a manager might do

Options for a manager, not IB requirements; each has a cost or a risk to weigh.

  • Creditor days have risen: check whether that is longer credit the suppliers agreed to, or late payment, which costs goodwill and can be a sign of strain.
  • Negotiate longer credit terms with suppliers, agreed in advance rather than taken by paying late.
  • Pay on time where a discount for prompt payment is worth more than the cash held.

Section 05: Learn more