How to Calculate Potential Revenue from an Order Book

You are looking at a construction company with an order book of 50,000 crore rupees and trying to figure out what that means for its future revenue. The company's marketing deck says "record order book!" but you need to translate that into actual revenue over the next few years. This is a common analysis challenge for anyone tracking infrastructure sector investments in India.

Here is a practical method to calculate potential revenue from any order book, with the adjustments that make the estimate realistic instead of optimistic.

Why order book analysis matters for investors

Order book is the pipeline of confirmed future work. For infrastructure and capital goods companies, it is the single most important forward-looking metric. A strong order book means revenue visibility for the next 2 to 4 years. A weak or shrinking one means the company may struggle to maintain growth.

The problem: order books are reported as a single number. You cannot plug that number into a revenue forecast directly. You have to break it into components and apply execution realities before it becomes useful.

Step 1 — understand what the order book actually contains

Before any calculation, know what is inside. Most company reports break the order book into:

• Executable orders — projects where work has started or can start immediately
• Projects awaiting clearance — land acquisition, environmental, or customer approvals pending
• L1 wins — declared lowest bidder but contract not yet awarded
• Framework orders — long-term agreements with uncertain drawdown timing

Executable orders are the most reliable for revenue forecasting. The others need discounting based on historical conversion rates.

Step 2 — calculate the book-to-bill ratio

Book-to-bill ratio = order book divided by trailing 12-month revenue. It tells you how many years of revenue are locked in.

Companies in the 2 to 3x range tend to deliver the most consistent revenue growth. Below 1.5x is a warning. Above 4x often signals projects that will slip or stall.

Step 3 — apply the execution timeline

Not all order book converts in a single year. Typical conversion patterns for Indian infrastructure:

1. Year 1: 30 to 40 percent of order book converts to revenue
2. Year 2: 30 to 35 percent converts
3. Year 3: 20 to 25 percent converts
4. Year 4 and beyond: 10 to 15 percent slow-burn projects

Use these percentages on the executable portion of the order book. If 50,000 crore rupees is the total order book and 40,000 crore rupees is executable, your Year 1 revenue estimate from that book is 12,000 to 16,000 crore rupees.

Step 4 — adjust for new order inflows

The order book also keeps refilling. Companies win new orders every quarter. For a full revenue forecast, add expected new wins to the conversion estimate.

A simple forecast looks like:

• Year 1 revenue = 35% of current executable book + 30% of expected new wins in the year
• Year 2 revenue = 30% of remaining book + 35% of Year 2 new wins
• Year 3 revenue = 25% of remaining book + 35% of Year 3 new wins

Use the trailing 4-quarter new order run-rate to estimate expected wins. Adjust for management guidance if provided.

Step 5 — apply the execution discount

Real life is messier than the model. Projects get delayed. Some orders never fully convert. Apply an execution discount to your estimate:

• 10 to 15 percent discount for well-run companies with strong execution history
• 20 to 25 percent discount for average execution
• 30 percent or more for companies with repeated delays or regulatory issues

The discount accounts for slippage, cancellations, and margin pressure during execution. It is the gap between the textbook calculation and reality.

A worked example

Take a company with these inputs:

• Total order book: 50,000 crore rupees
• Executable portion: 80 percent, so 40,000 crore rupees
• Expected new wins Year 1: 20,000 crore rupees
• Strong execution history (15 percent discount)

Year 1 revenue estimate = (35% of 40,000) + (30% of 20,000) = 14,000 + 6,000 = 20,000 crore rupees. Apply 15 percent execution discount and the final estimate drops to 17,000 crore rupees.

If the company reported 15,000 crore rupees in trailing 12 months, your estimate implies about 13 percent revenue growth — a realistic, defendable number.

Common mistakes in order book analysis

Watch out for these traps:

1. Treating all orders as equal — framework contracts convert much slower than fixed-scope projects
2. Ignoring margin differences — revenue is one thing; profit depends on margin per project
3. Not subtracting completed work — some reports still include finished portions
4. Assuming linear conversion — early project phases generate less revenue than later phases
5. Taking management guidance at face value — cross-check against historical execution

Tips for better order book analysis

A few habits improve the quality of every forecast you build:

• Track the quarter-on-quarter order book change — a flat or declining book is a red flag
• Read the management commentary on execution delays and payment milestones
• Compare order book across peers — a lone strong performer may be hiding issues
• Check working capital days — rising receivables often signal slow-paying government clients
• Model best-case and worst-case scenarios rather than a single number

These habits separate useful revenue forecasts from optimistic ones.

Where to find the right data

Quarterly investor presentations, annual reports, and concall transcripts are the main sources. Listed construction and capital goods companies usually disclose order book splits by segment and by geography.

For sector-level aggregate data on public infrastructure spending and project pipelines, the Ministry of Statistics and Programme Implementation publishes the National Infrastructure Pipeline dashboard at mospi.gov.in.