Interview Questions118

    Backlog Analysis and Book-to-Bill: Reading A&D Demand Signals

    How to analyze order backlogs, calculate book-to-bill ratios, and assess backlog quality for revenue forecasting.

    |
    8 min read
    |
    2 interview questions
    |

    Introduction

    In aerospace and defense, the order backlog is the single most important metric for understanding a company's revenue trajectory. Unlike cyclical capital goods companies where demand can shift within weeks, A&D companies operate with backlogs that represent years of contracted future revenue. Lockheed Martin's total backlog reached a record $194 billion at year-end 2025 (approximately 2.5 years of revenue). Boeing and Airbus hold combined aircraft order backlogs approaching 15,000 units (over 11 years of deliveries). These backlogs provide exceptional revenue visibility, but only if you know how to analyze them properly.

    For A&D investment bankers, backlog analysis enters virtually every work stream: modeling revenue in financial projections, supporting valuation multiples in sell-side processes, assessing demand sustainability for buy-side due diligence, and building pitch book narratives about a company's forward outlook. This article explains the key metrics, how to assess backlog quality, and how to translate backlog data into actionable revenue forecasts.

    The Core Metrics: Book-to-Bill and Backlog-to-Revenue

    Two ratios form the foundation of backlog analysis.

    Book-to-Bill Ratio

    New orders received during a period divided by revenue recognized during the same period. A ratio above 1.0 means the company is adding to its backlog (new orders exceed deliveries), signaling growing demand and future revenue expansion. A ratio below 1.0 means the backlog is shrinking (deliveries exceed new orders), signaling potential future revenue decline. In A&D, a sustained book-to-bill above 1.0 is the strongest positive demand signal, while a declining ratio is an early warning indicator that bankers watch closely.

    The backlog-to-revenue ratio expresses how many years of revenue the current backlog represents at the current delivery rate. A company with $50 billion in backlog and $20 billion in annual revenue has a 2.5-year backlog, meaning it would take 2.5 years to deliver all currently contracted work even if no new orders were received. Higher ratios generally indicate better revenue visibility and support premium valuations.

    These two metrics work together to paint a complete picture. A company with a high backlog-to-revenue ratio (strong visibility) but a book-to-bill below 1.0 (shrinking backlog) is depleting its forward demand without sufficient replenishment. Conversely, a company with a moderate backlog but a book-to-bill consistently above 1.2 is building future revenue capacity quickly.

    Beyond the Headlines: Assessing Backlog Quality

    The headline backlog figure can be misleading without deeper analysis. A $10 billion backlog is not equally valuable across all companies, because backlog quality varies along several dimensions that experienced bankers evaluate carefully.

    Contract type composition affects backlog margin quality. A backlog dominated by cost-plus contracts provides revenue visibility but caps margin upside. A backlog with substantial fixed-price content carries execution risk (cost overruns erode margins) but offers higher potential margins if managed well. Understanding the contract mix within the backlog is essential for projecting not just revenue but profitability.

    Customer and program concentration determines vulnerability. A backlog concentrated in two or three large programs is more risky than one diversified across dozens of contracts and agencies. If a single program representing 25% of backlog faces a budget cut or schedule delay, the revenue impact is material. Bankers assess concentration by examining the top 5-10 programs as a percentage of total backlog.

    Conversion timeline measures how quickly backlog translates into revenue. Some backlogs convert rapidly (government IT service contracts with 12-month task orders), while others convert slowly (defense production programs with multi-year manufacturing schedules). A $10 billion backlog that converts to revenue over two years is more immediately valuable than one that converts over seven years.

    Quality DimensionStronger BacklogWeaker Backlog
    Funded percentage>80% funded<50% funded
    Contract typeMix of cost-plus and fixed-priceConcentrated in cost-plus (margin cap)
    ConcentrationDiversified across 20+ programsTop 3 programs >50% of total
    Conversion speed2-3 year conversion cycle7-10 year conversion cycle
    Customer qualityDoD, intelligence, NATO alliesSingle agency, single program
    Margin profileImproving margins on maturing programsEarly-stage programs with development risk

    How to Build a Backlog-Based Revenue Forecast

    A&D analysts build revenue forecasts that are fundamentally different from the top-down market-sizing approaches used in many other industrial sub-sectors. The process is bottom-up, program by program.

    1

    Identify Key Programs

    List the company's top 10-15 programs by backlog value, noting funded/unfunded splits, contract types, and expected delivery schedules for each

    2

    Map to Budget Lines

    Link each program to specific defense budget line items to assess whether the funding source is growing, stable, or declining

    3

    Model Conversion Rates

    For each program, estimate the annual revenue conversion rate based on the production schedule, delivery timeline, and historical conversion patterns

    4

    Layer in New Orders

    Estimate future order intake based on pending contract awards, recompete probabilities (typically 80%+ win rates for incumbents), and identified new business opportunities

    5

    Stress Test the Forecast

    Model a downside scenario where specific programs face delays, budget cuts, or CR-driven interruptions to assess revenue vulnerability

    This program-level approach produces a revenue forecast with traceable assumptions that can be defended in buyer conversations and valuation discussions. It is significantly more reliable than applying a generic growth rate to the company's total revenue.

    Backlog Analysis Beyond Defense

    While backlog analysis is most critical in defense, it also applies to commercial aerospace (aircraft order backlogs exceeding 15,000 units), capital goods (unfilled orders for machinery and equipment, where the book-to-bill ratio is a leading indicator of cyclical turning points), and government IT services (IDIQ contract ceiling values and task order pipeline). The principles of analyzing funded percentage, conversion speed, concentration, and quality apply across all these contexts, though the specific metrics, data sources, and conversion timelines differ significantly by sub-sector.

    Interview Questions

    2
    Interview Question #1Medium

    A defense company reports $40 billion in total backlog, of which $25 billion is funded. How do you interpret this?

    Funded backlog ($25 billion) represents work for which Congress has appropriated and the agency has obligated money. This is the most reliable predictor of near-term revenue because the funds are committed.

    Unfunded backlog ($15 billion = $40B total minus $25B funded) represents the unfunded portions of multi-year contracts where funding has not yet been appropriated. This carries risk: if future defense budgets are cut or programs are restructured, the unfunded portion may not fully materialize.

    The 63% funded ratio ($25B / $40B) provides moderate revenue certainty. Compare this against peers: a company with 80% funded backlog has stronger near-term visibility. The backlog-to-revenue ratio tells you how many years of contracted work exist (if revenue is $20 billion, that is 2.0 years of total backlog or 1.25 years of funded backlog).

    In a valuation context, funded backlog supports stronger revenue projections and justifies a tighter multiple range. Unfunded backlog should be probability-weighted based on program importance, bipartisan support, and contract maturity.

    Interview Question #2Medium

    An A&D supplier reports a book-to-bill ratio of 1.3 for three consecutive quarters. What does this tell you, and how would you use it in a sell-side pitch?

    A sustained book-to-bill of 1.3 means the company is adding to its backlog at a rate 30% faster than it is delivering, signaling strong and accelerating demand. Three consecutive quarters of above-1.0 readings eliminates the possibility of a one-time large order distorting a single quarter.

    In a sell-side pitch, this data supports several arguments: (1) Revenue visibility: the growing backlog provides 12-36+ months of forward revenue certainty, de-risking the buyer's projections, (2) Pricing power: strong demand allows the company to negotiate favorable contract terms and pricing, supporting margin expansion, (3) Growth trajectory: the 1.3 ratio implies future revenue growth of approximately 8-10% annually as the backlog converts, assuming stable conversion rates, (4) Timing: the company's demand trajectory is strengthening, making this an attractive time for a buyer to acquire future earnings growth.

    The banker would present a chart showing the book-to-bill trend alongside revenue and backlog levels, demonstrating the relationship between order growth and future revenue acceleration.

    Explore More

    Sensitivity and Scenario Analysis in Financial Modeling

    How to use sensitivity and scenario analysis in financial models. Learn data tables, tornado charts, base/bull/bear cases, and what to sensitize in DCF, LBO, and merger models.

    March 3, 2026

    Introducing Our Industrials Guide for Investment Banking

    A comprehensive industrials IB guide with 101 articles covering cyclicality, aerospace and defense, capital goods, PE roll-ups, conglomerates, and valuation.

    April 1, 2026

    How to Answer "Where Do You See Yourself in 5 Years?" in IB

    Master the classic interview question about your five-year career vision for investment banking. Learn what interviewers actually want to hear, how to structure your answer, and see example responses that demonstrate commitment without overreaching.

    November 18, 2025

    Ready to Transform Your Interview Prep?

    Join 3,000+ students preparing smarter

    Join 3,000+ students who have downloaded this resource