Transportation earnings tracker excel is the research file to keep open this month, because the Q2 2026 reporting season for freight is arriving just as investors debate whether the long freight downturn is finally bottoming. J.B. Hunt traditionally reports first among the freight names in mid-July, and the Class I railroads, truckload and less-than-truckload carriers, freight brokers, and the parcel majors follow across the back half of July. Freight is the economy's early-warning system: carloads, tonnage, and shipment counts move before the broader macro data does. This guide explains how to organize that prep work in Excel using live MarketXLS formulas, walks through the metrics that actually move transportation stocks on earnings, and gives you a downloadable workbook so you can run the same workflow yourself.
| Window (illustrative) | Names reporting | Why it matters for Q2 2026 |
|---|---|---|
| Week of July 13-17 | JBHT, UNP, CSX | Intermodal volumes and rail pricing frame freight demand for the quarter |
| Week of July 20-24 | ODFL, KNX, CHRW, UPS | LTL pricing power, truckload spot rates, and parcel cost resets |
| Week of July 24 to Aug 1 | NSC, XPO, FDX | Rail operating ratios, LTL share gains, and parcel margin recovery |
Reporting dates shift from quarter to quarter, so always confirm the exact date for each name before you position around it. The template pulls each company's forward valuation and profitability with live MarketXLS formulas so you can anchor your own calendar and analysis to current data rather than stale screenshots.
Why a Transportation Earnings Tracker Excel Beats a Static Watchlist
Transportation is a cyclical, operationally dense group. A single earnings print can reprice a carrier by double digits because so much of the story lands in one release: revenue growth versus guidance, the operating ratio, volume trends, pricing or yield, and management commentary on the demand outlook for the second half. If you are trying to prep ten names by flipping between finance sites, you lose the ability to compare them on the same axes at the same moment.
A transportation earnings tracker excel workbook solves that by putting price, forward valuation, revenue growth, operating margin, operating ratio, and return on equity for every name in one grid that refreshes with live data. Instead of eyeballing ten separate pages, you scan one dashboard and immediately see which carriers are running the tightest operations, which are priced for a recovery that has not yet arrived, and which still have margin room if freight volumes turn.
The workbook attached to this post covers ten freight and transportation bellwethers across four sub-sectors:
- Class I railroads: Union Pacific (UNP), Norfolk Southern (NSC), CSX (CSX)
- Intermodal and truckload: J.B. Hunt (JBHT), Knight-Swift (KNX)
- Less-than-truckload (LTL): Old Dominion (ODFL), XPO (XPO)
- Freight brokerage and parcel: C.H. Robinson (CHRW), UPS (UPS), FedEx (FDX)
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.
The Freight Cycle: Why Q2 2026 Matters
Freight moves in long cycles, and the industry has spent much of the last two years in what carriers have openly called a freight recession: soft volumes, excess truckload capacity, and pricing that struggled to keep up with cost inflation. The question dominating Q2 2026 earnings calls is whether the trough is behind the industry. Analysts will be listening for three signals in particular.
- Volume stabilization. For the railroads, that means carload and intermodal trends; for truckers, loaded miles and tender rejection rates; for parcel, average daily package volume. Volumes turning from negative to flat to positive is the first sign a cycle is bottoming.
- Pricing and yield. In a soft market, carriers protect price and let volume soften. As demand returns, the mix of volume plus price is what drives revenue back to growth. Watch whether pricing is holding even where volume is still weak.
- Operating ratio direction. The single most important efficiency metric in freight. A carrier that defends its operating ratio through a downturn has pricing discipline and cost control; one whose operating ratio balloons is losing the operating-leverage battle.
An earnings tracker for this group therefore needs to watch revenue growth, margins, and the operating ratio together rather than any single headline number. The template is built to surface all of them in one glance, alongside valuation, so you can judge whether an improving quarter is already priced in.
Operating Ratio: The Number That Defines Freight
If you learn one metric before reading a transportation earnings release, make it the operating ratio. Operating ratio (OR) equals operating expenses divided by revenue. Lower is better. A railroad running a 60% operating ratio keeps 40 cents of every revenue dollar as operating profit; one at 70% keeps only 30 cents. Small changes matter enormously because of the operating leverage in an asset-heavy network.
MarketXLS does not ship a single OperatingRatio function, so the template derives it cleanly from a function that does exist:
Operating Ratio = 1 - Operating Margin
=(1-OperatingMargin("UNP"))*100
That formula gives you the operating ratio as a percentage for any ticker, and it is exactly how the Operating Ratio Lab sheet in the workbook ranks and grades every carrier. Because operating ratios differ structurally by sub-sector, you should compare like with like:
| Sub-sector | Typical operating ratio range | Read |
|---|---|---|
| Class I railroads | ~58% to 68% | Best-in-class efficiency; sub-60% is elite |
| LTL trucking | ~80% to 90% | Density and pricing discipline drive the gap |
| Truckload | ~90% to 96% | Thin margins, high sensitivity to spot rates |
| Freight brokerage | Asset-light; judged on net revenue margin | Flexes fastest on a volume recovery |
| Parcel | ~86% to 94% | Cost-reset and automation stories |
A railroad at an 80% operating ratio would be alarming; an LTL carrier at 80% would be excellent. The workbook grades each name against a transparent scale so you can see at a glance where each carrier sits relative to its own history and peers.
The Approach: Score the Freight Setup Before the Print
The core idea in this workbook is a transparent Freight Health Score on a zero to 100 scale. It is an educational framework for organizing your own analysis, not a buy or sell signal and not a prediction of how any stock will react. Each name accumulates points across four fundamental factors:
- Operating margin (up to 40 points). The efficiency backbone. Higher margin, more points, capped at 40.
- Revenue growth (up to 25 points). Rewards names that have already turned the corner on the top line. A carrier growing revenue scores higher than one still shrinking.
- Return on equity (up to 20 points). Captures how well management converts the asset base into shareholder returns.
- Valuation (up to 15 points). Rewards a more reasonable forward P/E, so a name is not penalized purely for being cheap or credited purely for being expensive.
The score sums to a letter grade (A through F) so you can rank the group in seconds. Crucially, every input is a live MarketXLS formula, so the score updates as fundamentals change. This keeps the analysis honest: you are scoring the actual numbers, not a hunch.
To be explicit about what this is not: the Freight Health Score does not tell you what a stock will do after earnings. Transportation stocks often move on forward guidance and volume commentary that no backward-looking metric captures. Use the score to organize the group and focus your reading, then do the qualitative work of listening to the call.
MarketXLS Implementation: Building the Tracker Formula by Formula
The strength of doing this in Excel is that every metric on the dashboard is a live formula you can audit and extend. Here are the verified MarketXLS functions the template uses, each shown with a real ticker.
Price and size
=QM_Last("UNP") Current share price
=MarketCapitalization("UNP") Market capitalization (divide by 1e9 for $B)
Valuation
=FORWARDPE("CSX") Forward price-to-earnings ratio
=PERatio("JBHT") Trailing P/E ratio
=PriceToBook("NSC") Price-to-book ratio
Profitability and efficiency
=OperatingMargin("ODFL") Operating margin
=(1-OperatingMargin("ODFL"))*100 Derived operating ratio as a percent
=ReturnOnEquity("UNP") Return on equity
=GrossMargin("XPO") Gross margin
=NetProfitMargin("UPS") Net profit margin
Growth
=REVENUEGROWTH("KNX") Revenue growth rate
=QUARTERLYREVENUEGROWTHYOY("FDX") Most recent quarterly revenue growth, year over year
Risk and income
=Beta("XPO") Beta versus the market
=DividendYield("UPS") Annual dividend yield
=DividendPerShare("UNP") Dividend per share
=TotalDebtToEquity("CSX") Debt-to-equity ratio
Every one of these functions was verified against the MarketXLS function library before it went into the workbook, so there are no invented formulas to trip over. If you want a single-cell operating ratio for a name not in the template, you only need the ticker: =(1-OperatingMargin("TICKER"))*100.
Inside the Template: Six Sheets, One Workflow
The workbook is organized into six sheets that flow from tutorial to screener to portfolio, so you can move from a broad scan down to a specific position size in one file.
1. How To Use. A plain-language tutorial that explains each sheet, defines the operating ratio, and reminds you that everything here is educational. It also lists the exact MarketXLS functions the workbook relies on.
2. Main Dashboard. The heart of the file. All ten carriers in one grid with price, market cap, forward P/E, revenue growth, operating margin, operating ratio, ROE, dividend yield, the Freight Health Score, and a letter grade. Yellow input cells at the top let you set your own screening thresholds for minimum operating margin, maximum forward P/E, and minimum revenue growth.
3. Scenario Analysis. A freight-demand model that projects revenue and operating profit across five scenarios, from a deep freight recession to a freight boom. It uses a simple operating-leverage assumption (each point of volume moves operating margin by roughly 0.4 points) so you can stress-test how a chosen carrier's profit responds when volumes turn. Every assumption is a yellow input you can change.
4. Operating Ratio Lab. The efficiency sheet. It ranks every carrier by operating ratio, derived live from operating margin, and assigns an elite-to-weak grade. This is where you see instantly which railroads are running sub-60% and which truckers have room to improve.
5. Portfolio Allocation. Turns the analysis into position sizing. Enter your portfolio size, maximum sector allocation, and number of positions, and the sheet computes an equal-weight dollar amount, share count, and projected annual dividend income for a sample basket of freight names.
6. Sub-Sector Comparison. A color-coded matrix that compares rail, truck, brokerage, and parcel on forward P/E, operating margin, ROE, beta, and dividend yield, with a written key insight so you compare like with like rather than judging a truckload carrier against a railroad.
Every sheet includes a "MarketXLS Functions Used in This Sheet" box at the bottom listing the exact formulas it relies on, so you always know how to reproduce any number.
Reading Q2 2026 Transportation Earnings: What to Watch
When the releases hit, the tracker helps you focus on what matters instead of drowning in the press release. A practical checklist as each name reports:
- Did volumes inflect? Compare the reported volume trend to the prior quarter. Flat is better than down; up is the signal cyclically minded investors wait for.
- Is pricing holding? Revenue can grow on price even when volume is soft. Falling price alongside falling volume is the worst combination; holding price through a soft patch signals discipline.
- Which way is the operating ratio moving? Plug the new margin into
=(1-OperatingMargin("TICKER"))*100after the quarter is reflected and see whether efficiency improved or slipped. - What did guidance say about the second half? Transportation stocks trade on the forward path. A backward-looking beat paired with cautious guidance often sells off; an in-line quarter with an improving outlook can rally.
- How does valuation compare to the group? Use the Sub-Sector Comparison sheet to check whether a name is expensive or cheap relative to peers on forward P/E before you react to the headline.
None of this is a recommendation about any specific stock. It is a repeatable process for turning a wall of earnings releases into an organized, comparable view.
Download the Templates
Download the templates:
- - Pre-filled with illustrative data and formula references so you can see the layout immediately
- - Live-updating formulas that pull current data through MarketXLS
The static version is a lead magnet: it shows the full layout with representative numbers and, next to them, the exact MarketXLS formula names that power each column. The template version contains only live formulas, so once you open it in Excel with the MarketXLS add-in connected and signed in, every price, margin, operating ratio, and valuation figure is current.
Frequently Asked Questions
What is a transportation earnings tracker excel?
A transportation earnings tracker excel is a spreadsheet that consolidates the key fundamentals for freight and transportation stocks (railroads, truckers, freight brokers, and parcel carriers) into one live dashboard. Instead of checking each company individually, you see price, valuation, revenue growth, operating margin, operating ratio, and profitability side by side, refreshed with live MarketXLS formulas so you can compare the group on the same axes at once.
How do I calculate operating ratio in Excel?
Operating ratio equals operating expenses divided by revenue, which is the same as one minus the operating margin. In MarketXLS you can compute it in a single cell with =(1-OperatingMargin("UNP"))*100, replacing UNP with any ticker. Lower operating ratios indicate more efficient operations, and railroads target the lowest ratios of any freight sub-sector.
Which transportation stocks report earnings in Q2 2026?
The Q2 2026 freight reporting season generally runs from mid-July into early August. J.B. Hunt typically reports first among the group, followed by the Class I railroads (Union Pacific, CSX, Norfolk Southern), LTL carriers (Old Dominion, XPO), truckload names (Knight-Swift), freight brokers (C.H. Robinson), and the parcel majors (UPS, FedEx). Always confirm each company's exact reporting date before positioning around it.
Why does freight matter as an economic indicator?
Freight volumes tend to move before broader economic data because goods must be shipped before they are sold. Carloads, tonnage, and package counts act as an early read on industrial and consumer demand, which is why investors and economists watch transportation earnings closely for signs of an inflection in the broader cycle.
Can I customize the tracker for other transportation stocks?
Yes. Every metric is a MarketXLS formula that takes a ticker as its argument, so you can add any transportation name by copying a row and changing the ticker. The workbook already covers ten bellwethers, and the formulas work identically for other carriers, airlines, logistics providers, or equipment makers you want to follow.
Is the Freight Health Score investment advice?
No. The Freight Health Score is an educational framework for organizing and comparing fundamentals across the group. It does not predict stock performance and is not a recommendation to buy or sell any security. Use it to structure your research, then do the qualitative work of reading each release and listening to management's outlook.
The Bottom Line
Transportation earnings tracker excel workflows turn the busiest stretch of the freight reporting calendar into an organized, comparable view. With the railroads, truckers, brokers, and parcel carriers all reporting within a few weeks of each other, the difference between reacting to headlines and analyzing the group on consistent metrics is a spreadsheet that refreshes with live data. The operating ratio tells you who runs the tightest network, revenue growth tells you who has turned the cycle, and the Freight Health Score ties it together so you can rank the group in seconds.
Build it once with verified MarketXLS formulas and you can reuse the same workbook every quarter. To explore the full library of live functions behind this template, visit MarketXLS, and if you want to see how it fits your own research process, book a demo. You can also compare plans on the MarketXLS pricing page.
Educational content only. This article and the attached templates are for informational and educational purposes and do not constitute investment advice or a recommendation to buy or sell any security. Tickers are used solely to demonstrate how the MarketXLS functions work.
