Skip to content

Record orders: inflow, book and what is actually executable

A press release announces the highest ever order inflow and a record order book at 2.4 times revenue. Four numbers reconcile a book, and running them shows the signed book grew by about one per cent.

Fundamental AnalysisAdvanced13 min read
Browse Fundamental Analysis(125)

The release runs to a page and a half. Highest ever order inflow of ₹9,400 crore. Order book at a record ₹31,000 crore, described as 2.4 times revenue. A quote about a strong pipeline and improving execution. The stock is up 6% by eleven o'clock and every headline repeats the same two figures. Nothing in the release is untrue, and an investor who reads only those two figures has still learned almost nothing, because an order book is not a single number with a single meaning. It is the closing balance of an account, and like any closing balance it can be reconciled against what went in and what came out. Doing that takes four numbers and about ten minutes, and on this release it produces a very different sentence: the value of signed, awarded work in hand grew by roughly one per cent.

Think of it like this
The tailor's pending book

A tailor keeps a book of pending orders. At the start of the month it lists forty suits. During the month he takes fifteen new orders and delivers twenty, and two customers cancel. So the book should read thirty-three. If he tells you it reads forty-eight, one of two things is true: either he has begun writing down the enquiries as well as the orders, or he has re-priced the existing ones. Both may be perfectly defensible. Neither is fifteen more suits to make.

In the market

An order book obeys the same arithmetic. Opening balance, plus what was won, less what was executed, less what was cancelled or de-scoped, equals closing balance. When the reported closing figure does not equal that, the difference is the whole story — and it is a difference the reconciliation makes visible in one line.

The three words that get used as one

TermWhat it isWhat it is not
Order inflowA flow. The value of new orders received during a period. Also called order intakeNot a balance. A record inflow in one year tells you nothing about the balance unless you also know what was executed and what was lost
Order book, or backlogA stock, at a date. The value of work awarded and not yet executedNot revenue, and not a promise about when. A ten-year concession and a six-month supply contract of the same value sit in it identically
Executable order bookThe part of the backlog the company expects to execute inside a stated period, usually the next twelve monthsNot the whole book. This is the figure that constrains next year's revenue, and it is the one least often put in the headline
RevenueWhat was actually recognised in the period, from the book and from anything short-cycle that never entered itNot the same as the book running down. Product and service revenue that is won and delivered inside a quarter usually never appears in a backlog at all
Closing book = Opening book + Inflow − Revenue executed from the book − Cancellations and de-scoping ± Re-measurement
Opening and closing book
Both disclosed, usually in the investor presentation rather than the accounts
Inflow
Announced through the year, and totalled in the presentation
Revenue executed from the book
Total revenue less any short-cycle business that never entered the book — the number you have to ask for
Re-measurement
Existing orders revalued for escalation, scope change or a currency move. Real, and not new work won

Example: Every term in this identity is disclosed by a company that wants to be understood, and the residual — the amount the identity cannot explain — is the first question to put on the call.

Worked example
Reconciling the record book
A capital goods and projects company, financial year just ended
Opening order book, 1 AprilFrom last year's presentation, which is why keeping the old presentations matters₹27,000 crore
Order inflow announced during the yearThe record figure in the release₹9,400 crore
Revenue for the yearFrom the audited accounts₹12,900 crore
Of which short-cycle product and service revenueWon and delivered inside the year, never routed through the backlog. Disclosed in the segment note₹2,500 crore
So revenue executed out of the book₹12,900 crore less ₹2,500 crore₹10,400 crore
Orders cancelled or de-scoped, as disclosedOne client dropped a phase₹500 crore
What the identity says the closing book should be27,000 + 9,400 − 10,400 − 500₹25,500 crore
What the release says it isA gap of ₹5,500 crore that orders won and work done cannot account for₹31,000 crore
On the call, the gap is explainedA single large tender where the company is the lowest evaluated bidder but has no letter of award, plus an agreed price escalation on contracts already in the book₹3,700 crore L1, ₹1,800 crore escalation
Signed, awarded work in hand₹25,500 crore plus the ₹1,800 crore of escalation, which is real value on real orders. The ₹3,700 crore is a bid, not an award₹27,300 crore
Growth in signed work in hand₹27,300 crore against ₹27,000 crore — against a headline book up 14.8%About 1.1%
The release is accurate and the reading it invites is wrong. A record inflow of ₹9,400 crore was very nearly matched by ₹10,400 crore of execution and ₹500 crore of cancellations, so the awarded book barely moved; the ₹4,000 crore of headline growth is ₹3,700 crore of a tender not yet awarded and ₹1,800 crore of escalation, less the ₹1,500 crore the book actually ran down by. Note what the reconciliation does not say. It does not say the company is misleading anybody — including L1 positions is a disclosed convention several companies follow, and escalation on existing contracts is genuine value. It says the two figures in the headline are the two least informative figures in the release, and that the number which governs next year is the executable portion, which the release did not mention at all.

Book-to-bill, and the two numbers inside it

The book-to-bill ratio is quoted everywhere as closing order book divided by the last twelve months' revenue, and read as "years of revenue visibility". On the company above that gives 31,000 ÷ 12,900 = 2.40. The trouble is that it divides a figure containing ₹3,700 crore of unawarded work by a figure containing ₹2,500 crore of revenue that never passed through the book. It is a ratio whose numerator and denominator describe different populations, and a mismatch of that kind does not reliably err in either direction.

Clean both and the answer is 27,300 ÷ 10,400 = 2.63 years of cover on the work that actually flows through the book — a higher figure than the headline, not a lower one. That is worth sitting with, because the instinct after any adjustment of this kind is to expect the flattering number to get worse. Here the standard formula understates the cover, because a large short-cycle business inflates the denominator with revenue the book was never asked to supply. The lesson is not that headline ratios flatter. It is that a ratio built from two mismatched populations is unreliable rather than optimistic, and that correcting it is the only way to find out which.

What to ask for, and what the answer means
Disclosure that makes a book readable
  • Opening book, inflow, execution and closing book, given as a reconciliation
  • The executable portion, with the period it refers to stated
  • Whether L1 positions and framework agreements are included, and how much they are
  • Slow-moving orders identified separately, with the reason they are not moving
  • Revenue split between backlog execution and short-cycle business
Disclosure that is decorative
  • A single closing figure and a growth percentage
  • A book-to-bill ratio with neither input defined
  • "Strong pipeline" and "healthy enquiry levels" — neither is an order
  • A book that grows every year while revenue and operating cash flow are flat
  • The same large project describable in three consecutive annual reports as recently won
◆ Your call

The inflow is a record and the executable book has shrunk

A projects company reports order inflow up 41%, a record closing book, and revenue up 3%. Buried on slide nineteen, the executable-in-twelve-months portion of the book has fallen from ₹9,100 crore to ₹7,600 crore. Management attributes flat revenue to a temporary monsoon effect.

Check yourself

A company's order book rises from ₹27,000 crore to ₹31,000 crore. Inflow during the year was ₹9,400 crore, ₹10,400 crore of revenue was executed out of the book, and ₹500 crore of orders were cancelled. What does the arithmetic establish?

Simple bhasha mein
Darzi ka pending register

Register mein saal ki shuruaat mein ₹27,000 crore ka kaam pending tha. Saal bhar mein naye order ₹9,400 crore, kaam nikala ₹10,400 crore (kul revenue ₹12,900 crore me se ₹2,500 crore chhote-chhote kaam the jo register mein hi nahi aaye), aur ₹500 crore cancel. Toh register mein bachna chahiye ₹25,500 crore — par press release bolti hai ₹31,000 crore. Farak ₹5,500 crore: ₹3,700 crore us tender ka jisme company L1 hai par letter of award aaya hi nahi, aur ₹1,800 crore purane orders ka escalation. Yaani asli mila hua kaam ₹25,500 + ₹1,800 = ₹27,300 crore — pichle saal ke ₹27,000 se sirf 1.1% zyada, jabki headline 14.8% bol raha hai.

What to remember
  • Inflow is a flow and the book is a balance — a record inflow says nothing until you know what was executed.
  • Opening book plus inflow, less execution and cancellations, plus re-measurement, equals the closing book. Run it.
  • L1 means the lowest bid, not an award: the letter of award may follow, or the tender may be re-floated.
  • Next year is constrained by the executable portion, which is rarely the figure in the headline.
  • A book-to-bill ratio built from mismatched numerator and denominator is unreliable in both directions, not merely flattering.
Finished this lesson?

Mark it done to track your progress through the curriculum.