Industrials Earnings Tracker Excel: Q1 2026 Tariff Exposure Watchlist Built in MarketXLS

Industrials earnings tracker excel is the right starting point if you want a single workbook to follow Q1 2026 reporting season for the U.S. industrials complex while also scoring each name on tariff exposure. This guide walks through the watchlist itself, the design choices behind the dashboard, the MarketXLS formulas powering every cell, and a downloadable pair of templates you can put to work immediately. The angle that makes this build different is the tariff overlay. Industrials sit at the intersection of every cross-border supply-chain decision being made right now, and the standard earnings dashboard misses that risk dimension entirely.

Q1 2026 reporting hits an industrial sector caught between three forces. Tariff policy is the first. Continued trade-policy uncertainty has turned every industrials earnings call into a guidance question, and management commentary on input costs, pricing actions, and supply-chain reroutes is the data point investors want most. The second force is the underlying global capex cycle. Aerospace deliveries, data-center buildouts, electrification spend, and freight volumes are all telegraphing different signals. The third is the rate path. With the Federal Reserve in pause mode and the long end of the curve still pricing higher-for-longer, capital intensity inside the industrial sector matters more than usual.

This week alone delivers earnings from GE Aerospace, RTX, Lockheed Martin, 3M, General Dynamics, Boeing, Honeywell, Northrop Grumman, CSX, Norfolk Southern, Union Pacific, Carrier, and UPS. Next week it gets even denser with Caterpillar, Cummins, Parker Hannifin, ITW, Paccar, and Emerson. That is twenty-plus industrial bellwethers in fifteen trading sessions. Without a structured tracker, the signal disappears into the noise.

Why an Industrials Earnings Tracker Excel Workbook Now

The case for building this in Excel rather than relying on a generic financial-news dashboard comes down to three things.

First, industrials are not a monolith. Heavy equipment behaves differently from aerospace and defense, which behaves differently from HVAC, which behaves differently from rail transports. A single sector heatmap hides the dispersion that matters. An Excel tracker lets you slice by sub-industry, weight differently, and rerun the comparison without waiting for someone else to publish a chart.

Second, tariff exposure is not a number you can pull from a single field. It is a composite of imported-component intensity, China revenue mix, pricing-power, and management's hedging discipline. Building it in MarketXLS lets you encode your own scoring rules, edit them as policy evolves, and tie them directly to live fundamentals.

Third, earnings season concentrates information in a narrow window. You need a workbook that updates as each name reports, lets you compare a beat or a miss against the rest of the cohort on the same metric set, and helps you decide whether to extend or trim positions. Excel is the right surface for that workflow because it is editable, auditable, and already part of every advisor and PM's stack. With MarketXLS, you also get formula-level access to fundamentals, estimates, and pricing without any web scraping.

What the Industrials Earnings Tracker Excel Workbook Includes

The downloadable workbook is built around six sheets. Each sheet pulls live data from MarketXLS formulas, and each contains a "MarketXLS Functions Used" reference block at the bottom so you know exactly which formula drives which cell.

Sheet 1: Main Dashboard

The dashboard is a 24-name screener spanning heavy equipment, aerospace and defense, diversified industrials, HVAC, and transports. Yellow input cells let you set portfolio size, tariff sensitivity weight, minimum analyst-consensus threshold, and risk tolerance. Every other column is a MarketXLS formula.

=QM_Last("CAT")                       Live intraday price
=QM_ChangePercent("CAT")              Day change %
=MarketCapitalization("CAT")          Market cap (USD)
=PERatio("CAT")                       Trailing 12-month P/E
=forwardPE("CAT")                     Forward P/E
=EPSEstimateCurrentQ("CAT")           Current quarter consensus EPS
=OperatingMargin("CAT")               Operating margin %
=QuarterlyRevenueGrowthYOY("CAT")     Quarterly revenue growth YoY

The composite Tariff Risk score in column M takes the input weight, multiplies by an exposure factor (1.2 for High, 1.0 for Medium, 0.7 for Low), and adds a margin penalty for thinner operating margins. The whole formula is editable, so you can tighten or loosen the scoring as your view of policy evolves. It is conditionally formatted with a green-yellow-red color scale so the worst offenders surface at a glance.

Sheet 2: Scenario Analysis

Earnings models that ignore policy regimes miss the dominant variable for industrials in 2026. The scenario sheet runs each name through four cases. Status quo holds current effective tariff rates. Escalation applies a broad ten-percentage-point increase, with a 15% EPS haircut for High-exposure names, 7% for Medium, and 3% for Low. Partial rollback applies a 5% lift across the board. Full rollback returns to a 2022 baseline with a 15% lift for High-exposure, 8% for Medium, and 3% for Low.

The base EPS is referenced directly from the Main Dashboard, so any change to your estimate (or any refresh of the underlying =EPSEstimateCurrentQ formula) cascades through. The "Worst-Best Range" column gives you an asymmetry check at a glance. Names where the spread between Escalation EPS and Full Rollback EPS is widest are the ones with the most policy-driven optionality - upside if relief comes, downside if escalation wins.

Sheet 3: Tariff Exposure Map

The exposure map breaks the universe into five sub-industries and scores each one on imported-component percentage, China revenue percentage, pricing power on a 1-10 scale, average operating margin, and hedge ability. The composite Risk Score is heat-mapped so you can see which sub-industries carry the most policy beta.

Aerospace and defense scores best on hedging because of long-cycle DoD contracts with cost pass-through clauses. Heavy equipment and diversified industrials carry the highest imported-component exposure. HVAC and building products carry both aluminum and copper exposure plus the indirect drag of tariff-driven CPI on housing demand. Transports take it differently. Direct exposure is lower, but earnings are tied to industrial activity and China-bound freight volumes.

Sheet 4: Earnings Calendar

The calendar sorts every name by reporting date, shows the day of week, sub-industry, and tariff-exposure label, and includes the previous quarter's surprise percentage as a quick read on the management team's track record. Use this sheet to plan your week, avoid earnings-date concentration risk, and see which days carry the heaviest cluster of high-exposure names. April 22, 23, 24, and 29 are the four densest days of the cycle.

Sheet 5: Portfolio Allocation

The allocation sheet takes the portfolio size from the Main Dashboard input cell and runs three weighting schemes side by side. Equal weight gives every name 1/N. Market-cap weight uses the live =MarketCapitalization formula to size positions proportionally. Risk-adjusted weight applies a tariff-exposure factor (0.7 for High, 1.0 for Medium, 1.3 for Low) so high-exposure names take smaller positions when you are tariff-defensive. The "Risk-Adj Shares" column divides risk-adjusted dollars by the live =QM_Last price to give you a round-number share count for each position.

Sheet 6: Sub-Industry Correlation

The correlation matrix uses 12-month return correlation across the five sub-industries to surface diversification gaps. The pattern that matters most for portfolio construction is that aerospace and defense is the lowest-correlated sub-industry to the rest of the complex. Heavy equipment, diversified, and transports all cluster above 0.65 correlation, which means over-allocating to all three concentrates your tariff and global-cycle risk into a single factor. Pairing a high-exposure heavy-equipment name with a low-correlation defense name reduces tracking error during trade-policy shocks.

The MarketXLS Formula Stack Behind the Industrials Earnings Tracker

Every data cell in the live template uses a verified MarketXLS function. Here is the complete stack with what each call returns and where it shows up in the workbook.

Live Pricing and Quote Data

=QM_Last("CAT")                Current price
=QM_ChangePercent("CAT")       Day change %
=QM_Volume("CAT")              Day volume
=QM_PreviousClose("CAT")       Previous close
=Last("CAT")                   Current price (alias for QM_Last)
=FiftyTwoWeekHigh("CAT")       52-week high
=FiftyTwoWeekLow("CAT")        52-week low

These power the Main Dashboard pricing columns and the share-count math on the Portfolio Allocation sheet. The QM-prefixed functions stream from QuoteMedia, so you get genuine tape rather than a delayed snapshot.

Valuation and Multiples

=PERatio("CAT")                Trailing P/E
=forwardPE("CAT")              Forward P/E (next 12 months)
=PEGRatio("CAT")               P/E to growth ratio
=MarketCapitalization("CAT")   Market capitalization in USD

Forward P/E carries more signal than trailing P/E during a rate-driven market because it incorporates analyst expectations for the upcoming year. The PEG ratio is a useful sanity check on whether forward valuation is fair against expected growth.

Profitability and Margin Quality

=OperatingMargin("CAT")        Operating margin %
=GrossMargin("CAT")            Gross margin %
=ProfitMargin("CAT")           Net profit margin %
=ReturnOnEquity("CAT")         Return on equity
=ReturnOnAssets("CAT")         Return on assets

Operating margin is the single most important field for tariff-exposure analysis. A name with thin operating margins that imports a meaningful share of its components has nowhere to absorb a tariff shock without taking pricing actions or eating the gross margin compression. The Tariff Risk score on the Main Dashboard penalizes operating margins below 15% and below 20% with successively larger adders.

Earnings Estimates and Growth

=EarningsPerShare("CAT")           Trailing 12-month EPS
=EPSEstimateCurrentQ("CAT")        Current quarter consensus
=EPSEstimateNextQ("CAT")           Next quarter consensus
=EPSEstimateCurrentY("CAT")        Current year consensus
=EPSEstimateNextY("CAT")           Next year consensus
=QuarterlyEarningsGrowthYOY("CAT") Quarterly EPS growth YoY
=QuarterlyRevenueGrowthYOY("CAT")  Quarterly revenue growth YoY
=RevenueGrowthFiveYearCAGR("CAT")  Revenue 5Y CAGR
=EBITDAGrowthFiveYearCAGR("CAT")   EBITDA 5Y CAGR

The estimate functions feed the Scenario Analysis sheet directly. By referencing EPSEstimateCurrentQ in the base column and applying haircuts/lifts in the scenario columns, the workbook gives you a live, refreshable view of the tariff sensitivity baked into each name's earnings.

Cash Flow and Balance Sheet

=OperatingCashFlow("CAT")      Operating cash flow
=CashFlowPerShare("CAT")       Cash flow per share
=EBITDA("CAT")                 EBITDA
=TotalDebt("CAT")              Total debt
=TotalDebtToEquity("CAT")      Debt-to-equity ratio

Cash flow durability matters more than reported EPS during a margin-compression cycle. A company with strong operating cash flow can self-fund the inventory builds and supply-chain reroutes that come with tariff shifts. Debt-to-equity tells you which names have the balance sheet room to weather a longer policy uncertainty window.

Sentiment and Risk

=AnalystConsensus("CAT")       Analyst consensus (1=Strong Sell, 5=Strong Buy)
=OneyrTargetPrice("CAT")       12-month consensus target price
=Beta("CAT")                   Beta vs market
=earnings_date("CAT")          Next scheduled earnings date
=PreviousEarningsReportDate("CAT") Last earnings report date

The analyst consensus field gates whether a name is included in the high-conviction allocation slice on the Portfolio Allocation sheet. The earnings_date function powers the calendar view.

Classification and Reference

=Sector("CAT")        Sector name
=Industry("CAT")      Industry name
=Name("CAT")          Company name

These let you build the sub-industry and sector grouping logic without manually maintaining a lookup table. If you extend the universe to 50 names, the sub-industry column populates automatically.

Building the Workbook from Scratch

If you want to build your own version rather than starting from the downloadable template, the construction order is straightforward.

Start with the input panel. Pick four to six variables you want as inputs. Portfolio size and tariff sensitivity weight are the obvious ones for this build. Use yellow fill, bold borders, and a centered cell so the input zone is visually distinct from the data zone.

Next, list the universe. Twenty to twenty-five tickers is the right breadth for an industrials tracker. Fewer and you miss sub-industry coverage, more and the dashboard gets unwieldy. Group by sub-industry to make scanning faster.

Then layer in the live MarketXLS formulas. The pattern is always the same: type = and the function name, pass the ticker as a string, hit enter, and let the add-in recalculate. Verify each formula in the Function Docs MCP if you are not sure of the exact spelling. Hallucinated function names are the single most common build-time error.

Add the Tariff Risk scoring formula in a new column. The version in the template uses an exposure factor multiplied by the input weight, plus a margin penalty. You can replace it with any composite that captures your view. Conditional-format with a color scale so the result is read in one glance.

Build the Scenario Analysis sheet by referencing the EPS estimate column from the Main Dashboard. Apply scenario-specific multipliers to that base value in each column. The "Worst-Best Range" column is the asymmetry indicator that tells you which names have the most tariff-policy optionality.

Finish with the Portfolio Allocation and Correlation sheets. The allocation sheet should pull market caps from the Main Dashboard, divide the input portfolio size by the relevant weight, and round to whole shares using the live price. The correlation matrix is best populated from a 12-month return series via =QM_GetHistory, then rendered as a heat-mapped matrix.

How to Use the Industrials Earnings Tracker During Q1 2026

The workbook is designed to be a living document during earnings season. The workflow that gets the most out of it looks like this.

Morning of an earnings release: open the dashboard, refresh, and look at the Tariff Risk column for the name reporting that day. Note where it sits relative to the rest of the cohort. Check the Scenario Analysis row for that name. The "Worst-Best Range" tells you how much policy-driven optionality is in the price.

After the report: update your own EPS estimate in the Main Dashboard if the company guides materially differently from consensus. The change cascades into the Scenario Analysis sheet automatically. Compare the company's commentary on tariffs against the exposure label in column D. If management is more optimistic about pricing than your model assumes, dial down the exposure factor in the scoring formula.

End of the week: open the Portfolio Allocation sheet, check the Risk-Adj Weight column against your current positions, and identify any names where your actual exposure is more than 50% off the model weight. Those are the candidates for trim or add. Use the Correlation sheet to make sure your trims are not all coming from the same sub-industry.

Tariff Risk Is Not the Only Risk - But It Is the Dominant One Right Now

A few caveats. The Tariff Risk scoring is a model output, not a forecast. The exposure labels are based on disclosed segment reporting and analyst commentary, both of which lag. Companies with global manufacturing footprints (Honeywell, MMM, ROK) can shift production faster than the headline exposure suggests. Long-cycle defense names (LMT, NOC, GD) carry the lowest direct exposure but are not immune to second-order effects through supplier networks.

The workbook also does not capture demand destruction. A heavy-equipment cycle that softens because of tariff-driven CPI compression hits revenue, not margins. That risk lives outside the scoring framework. Pair this tracker with a demand-side dashboard (machinery orders, freight rates, capex announcements) to capture the full picture.

Finally, the scenario analysis is rule-based, not stochastic. The 15% / 7% / 3% haircuts are a starting point. If you want a probability-weighted output, layer a Monte Carlo on top of the EPS series using the =QM_GetHistory history of EPS surprises and a tariff-regime probability distribution.

Download the Industrials Earnings Tracker Excel Templates

Download the templates:

• - Pre-filled with snapshot values as of 2026-04-22, with the source MarketXLS formula shown next to each cell so you know exactly what powers it.
• - Every data cell is a live MarketXLS formula. Open in Excel with the MarketXLS add-in installed and the workbook updates on demand.

Both files include all six sheets: How To Use, Main Dashboard, Scenario Analysis, Tariff Exposure Map, Earnings Calendar, Portfolio Allocation, and Sub-Industry Correlation. The "MarketXLS Functions Used" reference block on each sheet lists the exact formulas that drive that sheet so you can adapt the model to your own universe.

Frequently Asked Questions

What is an industrials earnings tracker excel workbook used for?

An industrials earnings tracker excel workbook is a structured dashboard that lets you follow earnings season for the industrials sector across multiple sub-industries (heavy equipment, aerospace and defense, diversified industrials, HVAC, transports) on the same metric set. It pulls live pricing, valuation, profitability, and earnings-estimate data through MarketXLS formulas and lets you score, sort, and allocate without leaving Excel. The version built here adds a tariff-exposure overlay because tariff policy is the dominant earnings variable for industrials in Q1 2026.

Which MarketXLS formulas does the industrials earnings tracker use?

The core formulas are =QM_Last for live price, =PERatio and =forwardPE for valuation, =EPSEstimateCurrentQ and =EPSEstimateNextQ for estimates, =OperatingMargin and =ProfitMargin for profitability, =MarketCapitalization for sizing, =QuarterlyRevenueGrowthYOY for growth, =AnalystConsensus and =OneyrTargetPrice for sentiment, and =earnings_date for calendar logic. Every formula is verified against the MarketXLS function library before being placed in the workbook.

How does the tariff risk score work?

The Tariff Risk score in the Main Dashboard is a composite that combines the user-selected tariff sensitivity weight (input cell), an exposure factor for the name's category (1.2 for High, 1.0 for Medium, 0.7 for Low), and a margin penalty for thinner operating margins (companies below 15% operating margin take a +25 adder, below 20% a +15 adder, otherwise +5). The output is a 1-100 score with a green-yellow-red color scale. The formula is editable, so you can replace the weights or exposure factors with your own.

Which industrials companies report in Q1 2026 earnings season?

The full Q1 2026 industrials reporting wave includes (in chronological order through early May): GE Aerospace, RTX, Lockheed Martin, 3M, Boeing, General Dynamics, Honeywell, Northrop Grumman, CSX, Norfolk Southern, Union Pacific, Carrier, UPS, Caterpillar, Cummins, Parker Hannifin, ITW, Paccar, Emerson, Rockwell, Johnson Controls, Dover, Deere, and FedEx. The Earnings Calendar sheet in the workbook lists all 24 in date-sorted order with the day of the week and the prior quarter's surprise percentage.

Can I extend the workbook beyond 24 names?

Yes. Add new ticker rows to the Main Dashboard, drag the formula range down so the live MarketXLS calls populate the new rows, and the Scenario Analysis, Earnings Calendar, and Portfolio Allocation sheets pick up the additions through their Main Dashboard references. The Sub-Industry Correlation matrix is rendered at the sub-industry level, so adding new tickers within an existing sub-industry does not require rebuilding the matrix. The =Sector and =Industry formulas auto-classify new names.

Is this investment advice?

No. The workbook is an educational and analytical tool. The Tariff Risk score, scenario haircuts, and allocation weights are model outputs based on inputs you control, not predictions or recommendations. No security mentioned in this post is being recommended for purchase or sale. Always do your own diligence and consult a licensed advisor before making investment decisions.

The Bottom Line

The industrials sector is the cleanest test case for tariff-policy beta in Q1 2026 earnings season. Twenty-plus bellwethers report in a fifteen-session window, and management commentary on tariffs, pricing actions, and supply-chain reroutes is the data point the market is paying for. A spreadsheet-native tracker that scores each name on tariff exposure alongside the standard fundamental and estimate fields turns earnings season from headline-chasing into a structured, repeatable workflow.

The MarketXLS template above gives you that workflow out of the box. Six sheets, twenty-four names, every cell powered by a live function, and a tariff-overlay scoring layer that you can edit as policy evolves. Whether you are an advisor managing client industrial allocations, a PM running a sector sleeve, or a self-directed investor trying to keep up with the cycle, the workbook puts the universe on one screen.

If you want to extend the framework or build a custom variant for your own universe, the MarketXLS platform gives you 1,100+ Excel functions for stocks, options, ETFs, and macroeconomic data. To see how the platform fits into a research workflow at scale, book a demo and walk through the build with the team.