Airline Stocks Screener Excel: Summer 2026 Peak Travel Operating Metrics Dashboard

An airline stocks screener in Excel puts each carrier on one row with operating margin, revenue growth, EBITDA, net debt, valuation, and segment, so you can compare network, low-cost, ultra low-cost, and regional airlines side by side. This guide lists the MarketXLS formula behind every column (for example =OperatingMargin("DAL") and =TotalDebt("DAL")), walks through three educational scenarios for summer 2026, and links a free template covering ten US carriers. The template refreshes when Excel recalculates. Stock quotes are 15-minute delayed on the MarketXLS Standard plan and real-time on the Advanced and Business plans.

See it in actionMarketXLS video

The full MarketXLS demo

Watch full demoBook a demo

Try it in your own spreadsheet

Get the free MarketXLS sample workbook (.xlsx).

Email address

Download free workbook

No account needed. MarketXLS live data requires a paid plan. Preview workbook

Explore more videos +

IntroductionHistorical DataOptions DataUse-cases

MarketXLS access: Downloading a workbook does not include live data access. Refreshing MarketXLS formulas requires a paid MarketXLS subscription.

Airline equities are unusual. Industry operating margins are often in the single digits, so a one or two percentage point move in operating margin is the difference between a great quarter and a write-off. Net debt loads carried over from the pandemic still matter. Capacity discipline, jet fuel exposure, and segment mix decide who keeps the upside when planes are full. A spreadsheet that ranks carriers on those factors is a faster starting point than reading earnings press releases one by one.

The rest of this guide covers how to use the screener, which MarketXLS formulas drive each column, the three educational scenarios in the template, and common questions heading into Q2 earnings.

Why an Airline Stocks Screener Belongs in Excel

Airlines need their own screen because four features matter more for carriers than for most industrials: segment differences, thin margins, debt, and earnings timing. A spreadsheet handles all four on one sheet.

The first is segment heterogeneity. Network carriers, low-cost domestic operators, ULCCs, and regional carriers respond differently to the same shock. Fuel rises hurt thin-margin ULCCs the most. A corporate travel slowdown bites network carriers first. A spreadsheet lets you split the universe by segment and read each one on its own line.

The second is the slim margin profile. Industry operating margins are often in the single digits. Small changes in unit revenue or unit cost compound quickly into earnings surprises. Tracking operating margin alongside revenue growth and EBITDA, side by side, makes the relative quality of each carrier obvious.

The third is debt. The pandemic left several US carriers with elevated balance sheets. A screener that pulls total debt, total cash, and computes net debt gives you a fast read on which names enter the summer with cushion and which are still recovering. Pair that with interest coverage and the picture sharpens.

The fourth is timing. Q2 2026 earnings will land mid-July through early August. Setting up an airline stocks screener workbook in early June means you have a baseline to compare against as carriers report.

The Operating Metrics That Matter for Airlines

Five groups of numbers drive most airline stock analysis: operating margin, revenue growth, EBITDA, leverage, and valuation with momentum. Each one maps to a MarketXLS function.

Operating margin. Operating margin is the core profitability number for airlines. The press release headline is often unit revenue or capacity guidance, but the operating margin tells you whether each new seat the airline added is actually contributing dollars. In MarketXLS, the formula is =OperatingMargin("DAL").

Revenue and revenue growth. Top-line growth in airlines comes from a combination of capacity additions and yield. Both compound during peak season. The screener pulls trailing revenue with =Revenue("DAL") and year-over-year growth with =RevenueGrowth("DAL").

EBITDA and EBITDA margin. EBITDA strips out the heavy depreciation that comes with airframes. It is a cleaner read of cash earnings. The template pulls =EBITDA("DAL") and divides by revenue to derive a margin column.

Leverage and balance sheet. Net debt (=TotalDebt("DAL")-TotalCash("DAL")) and the ratio of net debt to EBITDA tell you who has the runway to absorb a bad quarter. Carriers running net debt over four to five times EBITDA enter peak season with less flexibility.

Valuation and momentum. Trailing and forward P/E, year-to-date return, and the percentage below 52-week high give you a quick read on where each carrier sits in its own price range. =PERatio("DAL"), =ForwardPE("DAL"), =ChangePercentYTD("DAL"), and =FiftyTwoWeekHigh("DAL") cover this in MarketXLS.

The dashboard inside the template puts all of these on a single line per carrier. That structure is the point of the spreadsheet. You are not trying to predict individual fares. You are trying to see, at a glance, which group of airlines has the best combination of margin, growth, leverage, and momentum heading into the busiest quarter of the year.

The Approach: A Three-Scenario Educational Framework

The template ships with a Strategy Notes sheet that lays out three hypotheses you can use to interpret the data. None of these are recommendations. They are research scaffolding.

Scenario 1: Peak Season Strength

The hypothesis is that summer 2026 travel demand surprises on the upside, network carriers retain pricing power on international and premium cabin, and capacity discipline holds at the industry level. Under this scenario, network carriers with the largest international exposure and the cleanest forward bookings outperform.

What the screener helps you watch:

• Operating margin expansion versus the prior year for DAL and UAL.
• Forward P/E compression as analyst earnings estimates rise.
• Year-to-date returns relative to the broader industrials index.

Formulas that drive this view: =OperatingMargin("UAL"), =ForwardPE("DAL"), =RevenueGrowth("DAL").

The risk to the thesis is a sudden softening in close-in bookings or carriers chasing market share with added capacity that pressures unit revenue.

Scenario 2: Fuel Cost Pressure

The hypothesis is that jet fuel costs rise sharply, hedge rolls fail to offset enough of the move, and operating margins compress across the industry. Carriers with the thinnest margin cushion absorb the shock first.

What the screener helps you watch:

• Operating margin levels at LUV, JBLU, and SAVE relative to the peer group.
• Interest coverage at carriers with elevated leverage.
• Cash balances relative to near-term debt maturities.

Formulas that drive this view: =OperatingMargin("LUV"), =TotalDebt("AAL"), =InterestCoverage("JBLU"), =TotalCash("SAVE").

The risk to the thesis is hedging gains, demand resilience that supports fare increases, or capacity cuts that stabilize unit revenue.

Scenario 3: Recession Demand Shift

The hypothesis is that discretionary travel softens, corporate travel slows, and ULCC traffic stays sticky on price. Network carriers feel the corporate slowdown most. ULCCs hold up better on volume but with weaker yields. Regional carriers tied to capacity-purchase contracts with majors are relatively insulated.

What the screener helps you watch:

• Beta values for downside sensitivity, captured with =Beta("DAL").
• Premium cabin exposure at network carriers.
• Return on equity stability at regional names like SKYW.

The risk to the thesis is a resilient consumer, fuel relief, or capacity cuts that stabilize the network carriers faster than expected.

These scenarios are not predictions. They are organizing structures. Once you have data flowing into the screener, you can pressure-test each scenario against the actual numbers.

MarketXLS Implementation: Real Formulas, Cell by Cell

Every data cell in the template version is a live MarketXLS formula. The sample file uses static values so you can see a finished workbook before connecting the add-in. The Price column uses =QM_Last, which returns 15-minute delayed quotes on the Standard plan and real-time quotes on Advanced and Business.

Below is the column layout for the Main Dashboard sheet, along with the formulas that drive each column.

The Operating Metrics sheet extends the view with balance sheet detail.

The Portfolio Sizing sheet pulls from input cells on the Main Dashboard so that changing portfolio size, risk tolerance, or maximum position weight cascades through the entire workbook. The position sizing formula is intentionally simple and educational:

Suggested Weight = MIN(MaxWeight, (1/n) * (1 + (RiskTolerance - 3) * 0.1))
$ Allocation     = PortfolioSize * Suggested Weight
Shares           = INT($ Allocation / QM_Last(Ticker))

Formula documentation: QM_Last

You can replace any column with your own preferred weighting rule. The structure is there so the rest of the sheet still flows when you do.

Inside the Template: Sheet by Sheet

The workbook has seven sheets. Each one is designed to answer a specific question.

How To Use. Orientation page with the structure of the workbook and the MarketXLS functions used across the file. It also includes the data refresh date at the top of the sample file.

Main Dashboard. Ten airlines, twelve columns, plus a small educational composite score that combines lower P/E, higher operating margin, and positive year-to-date return into a single number. The composite is illustrative only.

Operating Metrics. A deeper look at the profit and balance sheet profile per carrier. Revenue, revenue growth, EBITDA, total debt, total cash, net debt, ROE, EPS, and beta sit on a single row per carrier.

Peak Season Scenarios. A sensitivity grid for each carrier. Rows shift operating margin by between minus two and plus two percentage points. Columns shift revenue by between minus five and plus fifteen percent. Each cell shows the hypothetical operating profit at that combination. Green cells indicate positive operating profit; red cells indicate negative.

Strategy Notes. The three scenarios above, laid out with the watchlist of metrics for each and the MarketXLS formulas that drive them.

Portfolio Sizing. Position sizing on a $100,000 portfolio (default input) with a default 10% maximum position weight and a default risk tolerance of 3 out of 5. Every cell on this sheet flows from input cells on the Main Dashboard.

Correlation Matrix. A 10 by 10 correlation grid. Big 3 network carriers tend to move together; ULCC names show modest correlation among themselves and lower correlation with the network group; regional carriers like SKYW are often the least correlated with the rest of the basket. The sample uses illustrative correlations. The template version explains how to compute live correlations with =QM_GetHistory(ticker, startDate, endDate) and native =CORREL(...).

Tying the Screener to Q2 2026 Earnings

The airlines typically report Q2 earnings between mid-July and early August. The order is fairly stable from year to year. Delta tends to open the season. United, American, Alaska, Southwest, and the rest follow. By setting up the screener in early June, you have a baseline to compare against as each carrier prints.

A practical Q2 watchlist looks like this:

1. Did operating margin expand year over year? =OperatingMargin("DAL") versus the prior year.
2. What is the implied unit revenue trajectory in management commentary? Read alongside =RevenueGrowth("DAL").
3. How did capacity discipline hold up? Look at industry-wide ASM growth commentary versus the sequential change in =Revenue("DAL").
4. Is balance sheet quality improving? Track quarter-over-quarter movement in =TotalDebt("DAL") and =TotalCash("DAL").
5. How are analyst targets evolving? =OneYrTargetPrice("DAL") and =NumberOfAnalysts("DAL") give a fast read.

This is not a forecast exercise. The point is to have a consistent set of inputs flowing through one spreadsheet so you can recognize the changes when earnings hit.

A Note on the Universe

The template starts with ten US-listed airlines: DAL, UAL, AAL, LUV, ALK, JBLU, ALGT, SAVE, SKYW, and SNCY. You can extend it. The MarketXLS formulas work for any covered ticker. Add European carriers via ADRs (such as RYAAY for Ryanair), add cargo and logistics names (FDX, UPS) on a separate sheet if you want a transports view, or carve out a pure ULCC sub-screen if that is your focus.

Two reminders:

• This is an educational template. Tickers are examples of how MarketXLS formulas work, not recommendations.
• Some carriers in the universe have been through restructuring or are operating with elevated balance sheet risk. The screener is most useful when you read each row in context, including the segment label.

How to Build It Yourself in MarketXLS

If you would rather build the screener from scratch, the workflow is short.

1. Open Excel with the MarketXLS add-in active. On Mac or Excel for the web (the Microsoft 365 add-in), prefix each function with mxls., for example =mxls.Last(A8).
2. Type your ticker list down column A starting in row 8 (DAL, UAL, AAL, LUV, ALK, JBLU, ALGT, SAVE, SKYW, SNCY).
3. In row 7, type the headers: Ticker, Company, Segment, Price, Mkt Cap ($B), P/E, Fwd P/E, Op Margin, EBITDA ($B), Beta, YTD %, % Below 52W High.
4. In B8, paste =Name(A8). In D8, paste =QM_Last(A8). Continue across using the formula table earlier in this post.
5. Select B8:L8 and drag down through row 17 to cover all ten tickers.
6. Format the price columns as currency, the margin and percent columns as percentages, and the ratio columns to two decimal places.
7. Add a second sheet named Operating Metrics with the deeper balance sheet view.
8. Wire up an input cell for portfolio size and a Portfolio Sizing sheet that references it.

If a QM_ formula returns an error, the QuoteMedia session may need to be refreshed inside MarketXLS. Reopen Excel and reauthenticate from the add-in. Non-QuoteMedia formulas (PERatio, OperatingMargin, EBITDA, Revenue, Beta, and similar) continue to work even when the streaming session is between refreshes.

Internal Resources Worth Linking

While building or extending the screener, these MarketXLS pages and templates are useful next stops:

• The MarketXLS Excel stock screener guide covers how to scan thousands of tickers on the same inputs the airline screener uses on ten.
• The Portfolio Tracker walks through a multi-asset workbook that you can layer on top of the airline screener.
• The GARP Screener blog shows a parallel screening workflow for growth at a reasonable price.
• For options-aware tracking of any name on this list, see the MarketXLS Options Strategies feature page.
• For the broader transports view, the Refinery Stocks Screener covers the supply side of summer travel demand.

Download the Templates

Download the templates:

• - Pre-filled with illustrative values and the exact MarketXLS formulas labeled on every sheet
• - All data cells use live MarketXLS formulas that refresh on recalculation

Both files share the same seven-sheet layout. The sample is for inspection and offline review. The template is for live use with the MarketXLS add-in installed.

FAQ

What should an airline stocks screener in Excel include?

An airline stocks screener should include operating margin, revenue growth, EBITDA, net debt, and segment for each carrier. Airlines run thin margins, so a one or two percentage point shift in operating margin shows up directly in earnings. Put those metrics on one row per carrier so you can compare network carriers against ULCCs and regionals on the same inputs.

Which airline metrics should I track in Excel ahead of Q2 2026 earnings?

Five families: operating margin, revenue growth, EBITDA and EBITDA margin, net debt with interest coverage, and valuation plus momentum. Inside MarketXLS that translates to =OperatingMargin(ticker), =RevenueGrowth(ticker), =EBITDA(ticker), =TotalDebt(ticker) and =TotalCash(ticker), plus =PERatio(ticker), =ForwardPE(ticker), and =ChangePercentYTD(ticker). Wire all of those into one row per carrier in a single sheet so you can compare carriers head to head.

How do I screen US airlines by operating margin in Excel?

List your universe of tickers down column A. In the operating margin column, paste =OperatingMargin(A8) and drag down. Format as percentage. Sort the table descending on that column. The carriers with the strongest operating profile float to the top. Repeat the exercise sorted ascending to identify carriers with the most margin pressure.

Why are airline operating margins so low compared to other industries?

Airlines carry heavy fixed costs (aircraft, maintenance, labor) and operate in a commodity-priced output market (seat-miles). Pricing power is constrained on most routes. Fuel is the single largest variable cost and is exposed to commodity swings. The combination produces operating margins that routinely sit in the single digits even in good years. Carriers with disciplined cost structures and strong network economics tend to land at the top of the range.

Are network carriers or low-cost carriers better positioned for summer?

Neither group is better in every summer. Network carriers with international and premium cabin exposure tend to benefit when corporate and long-haul demand is healthy. Low-cost carriers benefit when domestic leisure travel is strong and fuel is contained. ULCCs are sensitive to fuel and price competition. The screener inside this template is built so you can compare both segments on the same metrics rather than relying on a single narrative.

How do I add European or Asian airlines to the screener?

Use ADR tickers where available (for example RYAAY for Ryanair). Add them as new rows in column A on the Main Dashboard. The MarketXLS formulas use the same syntax for ADR tickers, so the rest of the sheet fills in automatically. Note that some balance sheet items may report in the original local currency depending on the issuer; double-check the unit on EBITDA and revenue columns when comparing to US carriers.

What is the safest way to handle dividends on airlines?

Most US airlines do not currently pay a regular cash dividend. The Dividend Payer Snapshot section of the template flags this. Use =DividendYield(ticker) to confirm current yield and =DividendPerShare(ticker) for the dollar amount. Treat any future reinstatement as a meaningful signal about management confidence in cash generation.

Can I use this screener as a starting point for options strategies?

Yes. Once the Main Dashboard is populated with live data, you can layer in MarketXLS options functions on a separate sheet. =OPT_IMPLIEDVOLATILITY(ticker, expiration, strike, type) and =QM_GetOptionChainActive(ticker) are useful starting points. Build the options view in a separate sheet so the underlying screener stays clean.

The Bottom Line

An airline stocks screener in Excel does not predict which carrier will outperform. It puts the right numbers on the right rows so you can read the group the way the industry reads itself: operating margin, revenue trajectory, EBITDA, leverage, and segment exposure. With Q2 2026 earnings approaching and peak travel season just starting, having that view live in a spreadsheet is more useful than scrolling through earnings recaps after the fact.

If you build with MarketXLS, the formulas above plug straight into Excel and refresh on demand. If you would rather start from the finished file, the two templates linked above give you a working dashboard without building the columns yourself. Either way, the workflow is the same: list your universe, set your input cells, watch the screener update through the summer.

Try the template, plug it into your own watchlist, and browse the full function list at MarketXLS formulas. If you want a walkthrough of how MarketXLS fits into a full research workflow, book a demo and we can step through it together.