Note: This tool uses formulas that are only compatible with Excel 2021 or later. If you're using an earlier version of Excel, some data may not display.
Macros might be disabled due to your company's security policy. To unblock them, follow these steps.
What is the US Trade Tariff Exposure Tool?
The US Trade Tariff Exposure Tool is a dynamic, Excel-based solution designed for risk modeling and ongoing analysis of evolving trade tensions between the US and its trading partners. It helps businesses assess the impact of tariffs, monitor policy changes and evaluate potential risks to supply chains and market access.
Where can I access the tool?
The US Trade Tariff Exposure Tool is available under Tools in the Products menu at the top of the platform.
Tab descriptions
Tariff Exposure
The Tariff Exposure tab provides a comprehensive view of the tariff landscape, allowing you to analyze specific tariffs for products within various sub-sectors. This tab helps you assess current and proposed tariff rates, making it a key starting point for evaluating trade risks and identifying product categories for further analysis.
How to select a sub-sector
Follow these steps to view active tariffs for a specific sub-sector:
Select a sector from the left-hand Sectors menu. Sectors and sub-sectors follow the NAICS structure.
Choose a sub-sector from the Sub-sectors menu at the top of the page.
Click Update to the right of the tab name at the top of the screen to load the data for the selected sub-sector.
View the active tariffs for the sub-sector in the table.
The table covers the tariffs for specific products within the sub-sector. It includes the following columns:
HS Code: A Harmonized System (HS) code is a unique identifier for classifying goods that are imported and exported internationally.
Old MFN Tariff: Tariffs implemented for World Trade Organization (WTO) members before January 20, 2025.
New MFN Tariff: Tariffs implemented for World Trade Organization (WTO) members since January 20, 2025.
Product Description: The goods associated with each tariff code.
The Tariff Exposure tab allows you to analyze tariff rates across a range of sectors and sub-sectors. You can use this information to identify key tariffs for further analysis on the Tariff Analysis tab, where you can dive deeper into specific tariff impacts.
Tariff Analysis
The Tariff Analysis tab allows you to analyze a specific tariff in greater detail after identifying it in the Tariff Exposure tab. This section provides insights into the tariff's code structure, related IBISWorld industry classification, tariff details for US trading partners, trade agreements and import/export data. By exploring these factors, you can better understand how a particular tariff impacts global trade and industry operations.
How to select a tariff
Follow these steps to analyze a specific tariff for a sub-sector:
Select a sector and sub-sector in the Tariff Exposure tab.
Choose a specific tariff from the blue dropdown menu at the top of the page.
Click Update to the right of the dropdown menu to load the data for the selected tariff.
Tariff Analysis tables
This tab contains the following tables that provide details on the selected tariff.
IBISWorld Industry Information
To the right of the instructions, you’ll find key details about the industry that the selected tariff is a part of. This allows you to explore the related IBISWorld Industry Report for more industry-level data and analysis.
HS Code Structure
The Code Structure section outlines the hierarchy of Harmonized System (HS) product codes, helping you understand exactly what the tariff applies to.
US Import Tariffs
The US Import Tariffs table displays tariff rates applied to goods imported from different trade partners. It includes old tariffs (implemented before January 20, 2025), new tariffs (implemented after January 20, 2025), and related trade agreements.
This section helps you assess how tariffs vary by country and understand the impact of trade policies on import costs.
Tariffs on US Exports
This table displays tariffs that other countries apply to US exports. This section helps you understand how US goods are taxed in foreign markets, allowing you to assess trade barriers, export costs and potential impacts on global competitiveness.
Industry Trade Partners
This table shows the imports and exports for the product that the selected tariff applies to. It provides a breakdown of the top 25 trade partners, helping you understand which countries are the largest suppliers and buyers. This information is useful when analyzing the impact of the tariff, trade policies and market dependencies.
The Tariff Analysis tab helps you assess the environment for specific tariffs. To understand their broader effect on industries, visit the Industry Exposure tab.
Industry Exposure
The Industry Exposure tab helps you assess how tariffs impact specific industries. You can analyze industry tariff risk, risk factors and types of risk, allowing you to evaluate how tariff changes may affect supply chains, costs and market access.
How to select a sub-sector
Getting started on this tab follows the same steps as the Tariff Exposure tab:
Select a sector from the left-hand Sectors menu. Sectors and sub-sectors follow the NAICS structure.
Choose a sub-sector from the Sub-sectors menu at the top of the page.
Click Update above the Sub-sectors menu to the right of the tab name at the top of the screen.
Industry Exposure tables
This tab covers the following tables to help you assess trade risk and supply chain exposure.
Industry Information
The first table on the tab lists all the industries included in the selected sub-sector and their NAICS codes.
Industry Tariff Risk (New)
The Industry Tariff Risk table measures an industry’s overall exposure to changes in tariff policies. Tariff risk can be Low, Medium or High.
Tariff Risk Factors (New)
This table shows five key indicators that influence an industry’s tariff risk:
Trade Dependence: Measures the extent to which an industry's supply chain relies on international trade, capital investment and material inputs. A high Trade Dependence score indicates heavy spending and reliance on imported commodities. Scores can be Low, Medium or High.
Pricing Power: Measures an industry's ability to pass rising input costs onto customers through price increases or surcharges. Competitive pressure can limit this ability, forcing some companies to absorb cost increases. Industries are rated as having Low, Moderate or Significant pricing power.
Globalization: Measures how involved an industry is in international markets. A high score reflects significant trade activity or the presence of major companies headquartered outside the US. Scores can be Low, Medium or High.
Revenue Volatility: Measures the degree of unpredictability or fluctuation in an industry's revenue from year to year. Scores can be Low, Medium, High or Very High.
Industry Risk
The Industry Risk table covers the structural, growth, sensitivity and overall risk of the industries within the selected sub-sector. The risk types follow the same risk modeling as our Risk Ratings Reports. The risk levels are based on our risk scores.
We use the following definitions for each risk type:
Structural risk: The model used to examine structural risk gauges the fundamental characteristics common to all industries and analyzes them at the industry level. We use the following components to determine the level of structural risk: Barriers to Entry, Industry Assistance, International Trade, Basis of Competition, Industry Life Cycle and Revenue Volatility.
Growth risk: Growth risk addresses industry revenue for the previous two years and forecast revenue for the upcoming year. A high industry growth rate is associated with lower risk for operators.
Sensitivity risk: Sensitivity risk covers macroeconomic variables relevant to the industry. The model assumes that this external risk is often more severe.
Risk scores, which determine the level of risk, incorporate key metrics that tariffs may impact, including Consumer Sentiment, Revenue Volatility, Basis of Competition, and International Trade. This provides an additional layer of analysis for industries without direct import/export exposure, such as Retail, that may still face significant effects from tariff changes. By evaluating these risk factors, businesses can better understand how tariffs may influence their industry, even when direct trade is not a primary concern.
The Industry Exposure tab provides a broad view of the industry's risk and supply chain exposure. If you identify a highly exposed industry, visit the Industry Analysis tab to analyze how specific tariffs impact it.
Industry Analysis
The Industry Analysis tab provides a detailed analysis of how specific tariffs impact highly exposed industries. By examining this data, you can assess the potential effects of tariffs on industry costs, competitiveness and market access. This tab helps you understand the broader economic implications of trade policies on industries identified as high-risk on the Industry Exposure tab.
How to select an industry
Follow these steps to select and analyze a specific industry:
Select a sector and sub-sector in the Industry Exposure tab.
Select an industry from the blue dropdown menu at the top of the page.
Click Update to the right of the dropdown menu to load the data for the selected industry.
Industry Analysis sections and tables
This tab contains the following sections and tables that provide details about the selected industry.
Industry Key Statistics
The Industry Key Statistics table provides an overview of essential industry metrics, including total revenue, value-added, number of establishments and enterprises and employment figures.
These figures and more can be found in the corresponding Industry Report on IBISWorld’s platform. This data helps you understand the industry's size, economic contribution and workforce, offering context for how tariffs may impact its overall performance.
Industry Structure
The Industry Structure table outlines how the selected industry fits within its broader sub-sector and sector, following the NAICS structure. This hierarchy helps you understand the industry's position within the overall market and its relationship to related industries.
Analysis Matrix
The Analysis Matrix Analysis table provides an overview of the selected industry’s tariff risk level and the risk factors driving it.
Overall Industry Tariff Risk Level: Measures an industry's overall exposure to changes in tariff policies. Scores can be Low, Medium or High.
Trade Dependence: Measures the extent to which an industry's supply chain relies on international trade, capital investment and material inputs. A high Trade Dependence score indicates heavy spending and reliance on imported commodities. Scores can be Low, Medium or High.
Pricing Power: Measures an industry's ability to pass rising input costs onto customers through price increases or surcharges. Competitive pressure can limit this ability, forcing some companies to absorb cost increases. Industries are rated as having Low, Moderate, or Significant pricing power.
Globalization: Measures how involved an industry is in international markets. A high score reflects significant trade activity or the presence of major companies headquartered outside the US. Scores can be Low, Medium or High.
Pricing Power (New)
The Pricing Power table breaks pricing power into four underlying components, each with its own level and trend:
Internal Competition: Measures the level of competition within the industry. Higher competition can make it harder for companies to raise prices without losing customers.
Pressure from Substitutes: Assesses the availability and threat of alternative products that can drive prices down.
Import Presence: Evaluates the impact of imported products on domestic pricing dynamics. A high or increasing presence of imports can make it harder for domestic companies to raise their prices.
Barriers to Entry: Reflects how easily new competitors can enter the market. Lower barriers increase competitive pressure and reduce pricing power.
Use this table to understand how competition affects an industry’s ability to raise prices in response to rising costs.
Industry Risk
The Industry Risk table covers the structural, growth, sensitivity and overall risk of the selected industry. Risk scores, which determine the level of risk, incorporate key metrics that tariffs may impact, including Consumer Sentiment, Revenue Volatility, Basis of Competition, and International Trade.
Legacy Metrics (New)
This section highlights key indicators that were central to earlier versions of the tool. While we’ve introduced new metrics that are more intuitive and broadly applicable, these indicators remain available for you to reference.
Trade Power Risk: Assesses the industry's leverage in global trade relationships. A "US Favored" rating suggests stronger negotiating power or lower risk from retaliatory tariffs.
Trade Exposure Risk: Measures the industry's dependence on global trade. A higher rating indicates greater vulnerability to tariff changes on imports and exports.
Demand Reliance: Measures an industry's dependence on domestic production vs. international demand. It indicates the ability of domestic production to meet domestic demand.
Trade Exposure
The Trade Exposure table helps you evaluate the level of trade between the US and its key trade partners. It includes the following columns:
Import Exposure: Indicates how much an industry relies on foreign suppliers. Higher exposure means greater risk from tariff changes and supply chain disruptions.
Export Exposure: Shows how dependent an industry is on international markets. High exposure signals vulnerability to foreign tariffs and shifts in trade policy.
Trade Risk Drilldown
The Trade Risk Drilldown tables cover more in-depth trade risk data, including the data driving risk trends in the Analysis Matrix Drilldown section.
Industry Trade Partners
This table shows the imports and exports for the product that the selected tariff applies to. It provides a breakdown of the top 20 trade partners, helping you understand which countries are the largest suppliers and buyers. This information is useful when analyzing the impact of the tariff, trade policies and market dependencies.
Key Tariff Countries (Formerly Key Trade Partners)
The Key Tariff Countries table shows the industry’s import origins and export destinations, along with the trade value and percentage share for Mexico, Canada, China, Australia, the UK and Europe. These countries are selected based on the tariffs imposed by the US and will be updated accordingly.
The Imports section highlights where the industry sources its goods, while the Exports section identifies key international markets for its products. This table helps you evaluate trade dependencies and assess how tariffs or policy changes could affect supply chains and market access.
Economic Power
The Economic Power section displays the GDP of the global economy and key trading partners, measured in current US dollars. It shows each country's contribution as a percentage of total world GDP, providing context on their economic influence. This data helps assess the economic strength of major trade partners and how shifts in their economies may impact industry trade and tariff policies.
Additional Information
Suppliers
This table lists the industries that supply products and services to the selected industry.
Supplier Overall Tariff Risk: Measures an industry’s overall exposure to changes in tariff policies. Can be Low, Medium or High.
Supplier Industry Risk: Evaluates broader industry vulnerabilities, including structural, growth and sensitivity risk. Can be Low, Medium, High or Very High.
If these industries face high risks, it can lead to increased costs and operational challenges.
Buyers
This table lists the industries that buy products and services from the selected industry. If the industry experiences higher costs or reduced supply due to trade policies, buyers may face pricing pressures or production slowdowns.
The Buyer and Supplier tables help you quickly assess the industry's risk exposure based on tariff policies and global trade conditions. You can use this data to identify potential vulnerabilities and determine whether further analysis or strategic adjustments are needed.
HS Codes table
This table includes all HS Codes within the selected industry. It indicates previously imposed and newly imposed tariffs for the industry’s product categories.
Products and Services
This table breaks down the industry's revenue by product type. Each row represents a specific product or service category and its share of total industry revenue. This information helps you identify which product segments are most important to the industry and may be most affected by trade policies or tariff changes.
Use the Products and Services table to prioritize tariff analysis and assess how specific trade developments may impact revenue-generating areas of the industry.
Industry Tariff Risk Listing
The Industry Tariff Risk Listing tab includes key risk trends for all industries covered by the tool so you can compare and assess how tariffs may impact different industries.
This summary view draws from the detailed analysis found in the Industry Analysis tab and provides a high-level snapshot of each industry’s exposure to tariff-related risks.
Each row represents a single industry, with the following columns:
Overall Industry Tariff Risk: Measures an industry's overall exposure to changes in tariff policies. Scores can be Low, Medium or High.
Overall Industry Risk: Evaluates broader industry vulnerabilities, including structural, growth and sensitivity risks.
Trade Dependence: Measures the extent to which an industry's supply chain relies on international trade, capital investment and material inputs . A High Trade Dependence score indicates heavy spending and reliance on imported commodities. Scores can be Low, Medium or High.
Pricing Power: Measures an industry's ability to pass rising input costs onto customers through price increases or surcharges. Competitive pressure can limit this ability, forcing some companies to absorb cost increases. Industries are rated as having Low, Moderate, or Significant pricing power.
Globalization: Measures how involved an industry is in international markets. A high score reflects significant trade activity or the presence of major companies headquartered outside the US. Scores can be Low, Medium or High.
Revenue Volatility: Measures the degree of unpredictability or fluctuation in an industry's revenue from year to year. Scores can be Low, Medium, High or Very High.
Use this tab as a starting point to identify at-risk industries, then explore the Industry Analysis tab for deeper insight into the underlying factors and trade dynamics.
Settings & Downloads
The Settings & Downloads tab allows you to adjust the level thresholds for the tables in the Industry Exposure and Industry Analysis tabs and download a PDF summary of the tool.
Common questions
How often is the tool updated?
While the tariffs environment is volatile we will be updating the tool weekly. Once it stabilizes, we will begin updating the tool monthly.
Macros are blocked in the tool. How do I unblock them?
After downloading the tool, you may see a message stating that macros have been blocked because the source of the file is untrusted.
To unblock macros:
Click the Learn More button in the warning banner. This will take you to Microsoft’s official instructions on how to unblock macros for downloaded files.
Follow the steps to unblock the file from the file’s Properties window before opening it (typically found by right-clicking the file in File Explorer > Properties > check “Unblock” > Apply).
Reopen the file and start researching.
If you continue experiencing issues, reach out to your Client Relationship Manager for assistance.
Where does the data in the tariff tool come from?
All data in the Tariff Impact Tool comes directly from IBISWorld’s industry research database. See our articles on data sourcing.
What is “MFN Tariff”?
Most Favored Nation (MFN) duty rates are the tariff rates that the US applies to imports from all trading partners that are members of the World Trade Organization (WTO), ensuring equal treatment among member countries unless a special trade agreement applies.
Are there any industries that the tool does not cover?
All NAICS industries will be included in the tool. Industries in our Specialized collection will not be included. Data for trade exposure is only available for Agriculture, Mining and Manufacturing industries.
Why does the EU show up in the Industry Trade Partners table in the Tariff Analysis tab at the same time as countries in the EU?
The total value of the European Union’s imports and exports is displayed for reference. However, the total import and export values at the top of the table do not include the European Union.
Why is the Risk section blank for some 5-digit codes in the Industry Exposure tab?
The Risk section on the Industry Exposure tab is populated using IBISWorld report codes, while the rest of the data corresponds with traditional NAICS codes. Although most of IBISWorld’s report codes directly reference NAICS codes, it is not always the case. In the event that one of our report codes is not an exact match with NAICS, you will notice gaps in data.
For example, “33661 Ship and Boat Building” does not show risk ratings because we break this industry up into “33661a Ship Building” and “33661b Boat Building.”
We’re working on fixing this issue to bring you risk levels for every industry.
For any additional questions about the Trade Tariff Exposure Tool, please reach out to your Client Relationship Manager. If you’re not an IBISWorld member, please contact us to learn more about our membership options.