Airline Earnings Tracker Excel: Q2 2026 Summer Travel Demand Watchlist

Airline earnings tracker excel is one of the most timely research files a self-directed investor or advisor can build this week, because the Q2 2026 reporting season for US carriers is about to begin at the peak of the summer travel period. Delta unofficially opens the airline calendar around July 10, and United, American, Southwest, Alaska, and the smaller carriers follow across the back half of the month. Summer is the quarter where airlines make most of their money, so Q2 results and the guidance that comes with them set the tone for the rest of the year. This guide explains how to organize that prep work in Excel using live MarketXLS formulas, walks through what actually moves airline earnings (hint: jet fuel and unit revenue), and gives you a downloadable workbook to run the same workflow yourself.

Reporting dates shift year to year, so always confirm the exact date for each name before you trade around it. The template pulls the prior report date with a MarketXLS formula so you can anchor your own calendar.

Why an Airline Earnings Tracker Excel Beats a Static Watchlist

Airlines are a uniquely quarter-driven, macro-sensitive group. A single earnings print can reprice a carrier by double digits because so much of the story lands in one release: unit revenue trends, cost per available seat mile, fuel expense, capacity growth, and forward guidance for the crucial summer-into-fall stretch. If you are trying to prep eight carriers by flipping between finance sites, you lose the ability to compare them on the same axes at the same moment.

An airline earnings tracker excel workbook solves that by putting price, forward valuation, consensus EPS, revenue estimates, the last earnings surprise, and margins for every carrier in one grid that refreshes with live data. Instead of eyeballing eight separate pages, you scan one dashboard and immediately see which names are priced for strength, which have a history of beating, and which are running into a tough fuel or demand backdrop.

The workbook attached to this post does exactly that for eight US carriers: Delta (DAL), United (UAL), American (AAL), Southwest (LUV), Alaska (ALK), JetBlue (JBLU), SkyWest (SKYW), and Frontier (ULCC). Every data cell in the template version is a MarketXLS formula, so the moment you open it with MarketXLS connected in Excel, the numbers are current.

What Actually Moves Airline Earnings in Q2 2026

Before you build a tracker, it helps to know which levers matter. For airlines, four forces dominate the quarterly print:

1. Jet fuel price. Fuel is typically the largest or second-largest operating cost for a carrier, often somewhere around a quarter to a third of operating expense depending on the airline and its hedging. A move in crude and refining spreads flows almost directly into the margin line. This is why two airlines with identical revenue can post very different profits in the same quarter.
2. Unit revenue (RASM). Revenue per available seat mile captures both fares and how full the planes are. Summer demand strength shows up here first. Rising RASM with flat costs is the ideal earnings setup; falling RASM into rising capacity is the danger zone.
3. Capacity discipline. When the whole industry adds too many seats, fares soften. When carriers hold capacity, pricing power improves. Guidance language on capacity growth is often more market-moving than the reported quarter itself.
4. Premium and loyalty mix. Network carriers increasingly lean on premium cabins and co-brand credit card economics, which are less cyclical than main-cabin fares. This is a growing differentiator between the legacy names and the low-cost carriers.

The template turns the first two forces into an interactive model. On the Scenario Analysis sheet you set a base operating margin, a fuel-as-percent-of-cost assumption, and a base RASM, then read a grid of estimated operating margins across jet fuel moves (from minus 20 percent to plus 20 percent) and unit revenue changes. It is a simplified educational model, not a forecast, but it makes the core sensitivity obvious: for most carriers, fuel is the single biggest swing factor on the earnings line.

The Q2 2026 Setup for Airlines

A few themes frame this particular reporting season, and they are worth keeping in mind as you populate the tracker. Summer is structurally the strongest demand quarter for US carriers, so Q2 and Q3 are where full-year profitability is largely decided. That makes the July prints and, more importantly, the accompanying guidance for the back half of the year the highest-signal moment of the airline calendar.

The debate this cycle centers on whether demand is broadening or narrowing. Premium cabin and international long-haul demand have been the stronger part of the mix for network carriers, while price-sensitive main-cabin and domestic leisure traffic is where softness tends to appear first. That split is exactly why comparing a legacy network carrier against an ultra-low-cost carrier on the same multiple can be misleading, and why the Peer Comparison sheet keeps margins, returns, and leverage side by side rather than reducing everything to a single valuation number.

Fuel is the other swing factor to watch. Because jet fuel is such a large share of operating cost, even a moderate move in crude and refining spreads can turn a projected margin expansion into a contraction. Carriers with stronger balance sheets and more disciplined capacity plans tend to weather that better. The Scenario Analysis sheet is built specifically so you can pressure-test each name against a fuel spike before the quarter lands, rather than being surprised by it afterward. Treat all of this as context for your own research, not as a forecast of where any stock is headed.

The Approach: A Repeatable Earnings-Prep Workflow

Here is the hypothesis behind the workbook, framed as an educational process rather than a recommendation to buy or sell anything. The idea is that disciplined, apples-to-apples preparation beats reacting to headlines after a print. The workflow has four steps:

1. Screen the group on the Main Dashboard. Sort by the composite score to see which carriers combine a positive surprise history, revenue growth, and healthy margins going into the quarter.
2. Stress the margin on the Scenario Analysis sheet. Ask what happens to a carrier you like if fuel jumps 10 or 20 percent, or if unit revenue rolls over. If the margin cushion is thin, the name is fragile into the print.
3. Size any earnings play on the Earnings Move Strategy sheet using the options-implied move, so position size reflects the risk the market is already pricing rather than a gut feel.
4. Compare fundamentals on the Peer Comparison sheet to confirm your read on relative quality: valuation, margins, return on equity, leverage, and liquidity side by side.

None of this predicts the result. Earnings are inherently uncertain, and airlines are more volatile than most. The goal is to be organized and to understand the risk you are taking, not to guarantee an outcome.

MarketXLS Implementation: The Formulas Behind the Tracker

Everything in the template is built from verified MarketXLS functions. Here are the core building blocks, all shown with Delta (DAL) as the example ticker. Swap in any US-listed carrier.

Pull the live quote and daily change:

=QM_Last("DAL")
=ChangeinPercent("DAL")

Pull valuation and the consensus estimates you are trading against this quarter:

=FORWARDPE("DAL")
=EPSESTIMATECURRENTQUARTER("DAL")
=REVENUEESTIMATEAVGCURRENTQUARTER("DAL")

Bring in the last earnings surprise and the prior report date to build your own calendar:

=EPSSURPRISEPERCENT("DAL")
=PREVIOUSEARNINGSREPORTDATE("DAL")

Layer on the profitability and quality metrics that separate strong carriers from fragile ones:

=OperatingMargin("DAL")
=NetProfitMargin("DAL")
=RevenueGrowth("DAL")
=ReturnOnEquity("DAL")
=TotalDebtToEquity("DAL")
=CURRENT_RATIO("DAL")
=Beta("DAL")

And finally the context around price - how far the stock sits from its 52-week high, plus the analyst mean target:

=ChangeFrom52_weekHigh("DAL")
=TargetPrice("DAL")

Because these are live functions, you are never copying and pasting stale numbers. Rebuild the grid once, and it stays current every time you open the file. If you want to go deeper on the analyst and estimate functions, the MarketXLS earnings and analyst function guide is a useful reference.

The Template: What Is Inside the Workbook

The download includes two files. The sample is pre-filled with illustrative values as of the publish date and shows the exact MarketXLS formula behind each number, so you can see how it is wired. The template version is all live formulas. Both contain six sheets.

Sheet 1 - How To Use

A plain-language guide to every sheet, the input cells, and the formulas. Start here.

Sheet 2 - Main Dashboard

The core screener. Eight carriers in one grid with live price, percent change, market cap, forward P/E, Q2 EPS and revenue estimates, last earnings surprise, revenue growth, operating and net margin, beta, distance from the 52-week high, and the analyst target. A composite Earnings-Readiness Score blends the surprise history, revenue growth, margins, and price position into a single 0-100 number so you can rank the group at a glance. The score is color-coded from red to green and is an educational ranking, not a buy or sell signal.

Sheet 3 - Scenario Analysis

The jet fuel and unit revenue sensitivity model. Set your base assumptions in the yellow cells and read a color-coded grid of estimated operating margins across five fuel-price scenarios and five RASM-change scenarios. This is the sheet that makes fuel risk tangible.

Sheet 4 - Earnings Move Strategy

An educational position-sizing aid for trading around a print. Enter the current price, the at-the-money straddle price, days to earnings, your account size, and your maximum risk per trade. The sheet returns the options-implied move in dollars and percent, the expected upper and lower price bounds, your maximum dollar risk, and a suggested contract count. Options carry substantial risk of loss - this is a sizing tool, not a recommendation.

Sheet 5 - Position Sizing

Enter your portfolio size and a maximum weight per name, and the sheet converts a diversified allocation across the watchlist into dollar amounts and estimated share counts using live prices.

Sheet 6 - Peer Comparison

A ten-metric fundamentals matrix with the carriers across the top and metrics down the side, color-coded so green is more favorable and red is less favorable within the group (valuation and leverage are reversed, since lower is better there). This is the fastest way to see relative quality.

Every sheet ends with a "MarketXLS Functions Used" box listing the exact formulas on that sheet, so you always know which function to reference when you extend the workbook yourself.

Download the templates:

• - Pre-filled with illustrative data and formula references
• - Live-updating formulas

Reading the Dashboard: What the Numbers Are Telling You

A few practical notes on interpreting the tracker during earnings season.

Watch the estimate, not just the print. A carrier can grow earnings year over year and still fall if it misses the consensus EPS estimate on the dashboard. The market trades the gap between the result and the expectation, which is why the EPS estimate and the last surprise columns sit side by side.

Distance from the 52-week high is a sentiment gauge. A name pressed against its high has a higher bar to clear; a beaten-down carrier can rally hard on a merely less-bad quarter. The ChangeFrom52_weekHigh column gives you that context without a separate chart.

Margins reveal fragility. Two carriers can trade at a similar forward P/E, but the one with a thin operating margin has far less cushion if fuel spikes or fares soften. Cross-reference the Main Dashboard margins with the Scenario Analysis grid before you decide a valuation is cheap.

Low-cost and legacy carriers are different animals. Legacy network carriers lean on premium cabins and loyalty economics; ultra-low-cost carriers live and die on cost per seat and fare levels. Do not compare their multiples in a vacuum - the Peer Comparison sheet helps you keep the comparison honest.

Extending the Tracker

The workbook ships with eight carriers, but the formulas work on any US-listed airline or travel-adjacent name. To add a ticker, copy a row on the Main Dashboard and change the symbol inside each formula. You can just as easily point the same structure at travel-services names, aircraft lessors, or airport operators if you want a broader travel-demand basket. For a deeper dive on building live financial models in Excel, see the MarketXLS features overview and the broader MarketXLS blog for more sector templates.

Frequently Asked Questions

What is an airline earnings tracker excel?

An airline earnings tracker excel is a spreadsheet that consolidates the key earnings-season data for a group of airlines - price, consensus EPS and revenue estimates, the last earnings surprise, margins, valuation, and analyst targets - into one live dashboard. With MarketXLS formulas, the numbers refresh automatically instead of being copied by hand.

When do airlines report Q2 2026 earnings?

The US airline earnings season typically opens in the second week of July, with Delta usually reporting first, followed by United, American, Alaska, Southwest, and the low-cost and regional carriers over the following two weeks. Exact dates move each year, so confirm the specific date for each carrier. The template pulls the prior report date so you can build an accurate calendar.

Why does jet fuel matter so much for airline earnings?

Jet fuel is one of the largest operating costs for an airline, often around a quarter to a third of operating expense. Because it is such a big line item, a swing in fuel prices flows almost directly into operating margin. The Scenario Analysis sheet in the template models exactly how margin shifts as fuel and unit revenue change.

Which airlines are in the template?

The workbook covers eight US carriers: Delta (DAL), United (UAL), American (AAL), Southwest (LUV), Alaska (ALK), JetBlue (JBLU), SkyWest (SKYW), and Frontier (ULCC). You can add or swap tickers by editing the symbol inside any MarketXLS formula.

Can I use this template to trade options around earnings?

The Earnings Move Strategy sheet is an educational position-sizing aid that uses the options-implied move to frame risk. It does not tell you whether to trade or which direction to take. Options involve substantial risk of loss, and nothing in this workbook is investment advice.

Do I need MarketXLS for the template to work?

The live template version relies on MarketXLS functions running inside Excel, so you need MarketXLS connected for the formulas to return data. The sample version works without it, showing illustrative values plus the formula references so you can see how everything is built.

The Bottom Line

An airline earnings tracker excel turns a chaotic two-week reporting stretch into a structured, comparable view of the entire US carrier group right when summer travel demand is at its peak. By combining live MarketXLS data with a fuel-and-demand sensitivity model, an earnings-move sizing sheet, and a peer-comparison matrix, you move from reacting to headlines toward understanding the risk in each print before it happens. It will not predict any result - earnings are uncertain and airlines are volatile - but it will make you organized and honest about what you are taking on.

Download the workbook above, connect MarketXLS in Excel, and you will have a living airline earnings dashboard you can reuse every quarter. To build your own live financial models with hundreds of functions like these, explore MarketXLS or book a demo to see it in action.

This article is for educational purposes only and is not investment advice. Data points are illustrative and should be independently verified. Investing in equities and options involves risk, including the possible loss of principal.