Financial Impact of Supply Chains

Quantifying the Financial Impact of Supply Chains

Small Changes in COGS, Big Impacts

Mini Project - Supply Chain Analytics

Bennett Gaskins

Course Participant

1

1/18

Project Outline

Objective: This project analyzes the financial impact of supply chains by quantifying the effect of cost efficiency on profitability and market valuation.

Part 1: Revenue Breakdown and COGS Impact

Analyze revenue structures for multiple country-industry combinations and estimate how a 1% reduction in COGS improves net income margins.

Part 2: Industry-Level Market Capitalization and Net Income Correlation

Study the relationship between total market capitalization and total net income at the industry level using trend analysis.

Part 3: Company-Level Correlation and Regression Analysis

Examine the relationship between market capitalization and net income for selected companies using different trend lines and linear regression, including R-squared analysis.

Expected Insights (What you seek to learn)

How supply chain efficiency drives financial performance and market valuation.

2

2/18

Industrial Breakdown - Cost of Revenue or COGS for United States

3

In the United States, cost of goods makes up the largest portion of revenue across the industrial sector, leaving relatively thin margins. Labor, materials, and overhead costs remain significant drivers of total cost. Since margins are tight, even small improvements in supply chain efficiency or input sourcing have a massive impact on profitability.

3/18

Industrial Breakdown - Revenue for China

4

China's industrial sector shows a high concentration of costs in COGS, which is largely drive by manufacturing inputs and production scale. While average industrial wages in China and India are lower than in the United States, rising input prices, infrastructure constraints, and efficiency gaps can offset some of this cost advantage. This highlights the importance of efficiency, scale, and supplier coordination in maintaining competitiveness in the market.

4/18

Industrial Breakdown - Cost of Revenue or COGS for India

5

India's industrial cost structure reflects a heavy reliance on COGS, but with relatively lower labor costs compared to the US and China. However, infrastructure constraints and supply chain inefficiencies can usually offset these advantages.  Improvements in logistics, sourcing, and production processes could significantly improve margins over time.

5/18

Notes & Insights - Part 1 (COGS Impact)

In the industrial sectors of the United States, China, and India, the costs of goods sold (COGS) constitute the most significant portion of revenue, while net income margins remain quite narrow. This means that even small improvements in supply chain efficiency can have an outsized impact of profitability. A 1% reduction in COGS can lead to a noticeable percentage increase in net income, especially in countries or industries where costs are high and margins are tight.

In practice, this relationship underscores why supply chain strategy is a key financial lever rather than just an operational concern. Reductions in COGS can come from improved supplier negotiations, more efficient transportation networks, automation, or better inventory management. Since these changes directly reduce operating costs without requiring additional revenue growth, they tend to translate almost one-for-one into higher profitability. This dynamic becomes important in capital-intensive industrial sectors, where margins are narrow and revenue and growth along may not be sufficient enough to significantly improve financial performance.

6

6/18

Market Cap Trend- Industrials (United States)

7

The valuation trend shows steady growth in total market capitalization for the U.S. Industrials sector over time, with noticeable fluctuations which reflect broader market conditions. Overall trend suggests increasing investor confidence in the sector.

7/18

Net Income Trend- Industrials (United States)

8

Profitability trend indicates a generally increasing pattern in total net income for the U.S. industrials sector. While growth is not perfectly smooth, long-term trend aligns with increases in market capitalization, suggesting a positive relationship between profitability and firm valuation.

8/18

Market Cap Trend- Industrials (China)

9

The market capitalization of China's Industrials sector shows growth over time but with much greater volatility compared to the US. You can see noticeable swings from year to year, which suggests that factors beyond company profits, like broader economic conditions and policy changes, play a bigger role in his these firms are valued.

9/18

Net Income Trend- Industrials (China)

10

Net Income in China's Industrials sector displays an uneven growth pattern, with periods of expansion followed by slowdowns. Profitability clearly matters for valuation, but outside factors like the economy and policy shifts create noticeable swings and add volatility.

10/18

Market Cap Trend- Industrials (India)

11

India's Industrials sector shows strong and consistent growth in market capitalization over the period analyzed. The upward trend suggests increasing investor confidence and expanding industrial activity, with less volatility compared to China.

11/18

Net Income Trend- Industrials (India)

12

Net Income for India's Industrials sector trends upward over time, closely aligning with the growth in the markets. This suggests a stronger correlation between profitability and valuation, with relatively lower market noise compared to more mature economies like China or the US.

12/18

Notes & Insights - Part 2 (Market Cap & Net Income)

Across the Industrials sectors in United States, China, and India, market capitalization usually moves in the same direction as net income over time, which helps indicate a clear relationship between profitability and firm valuation. When companies generate higher net income, then the market cap typically increases as well, although the magnitude of this response varies across countries.

The United States shows the most stable and consistent, with steady long-term growth and relatively limited volatility. China is quite the contrary; China exhibits more pronounced fluctuations, suggesting that market valuation is more sensitive to external influences. India shows strong upward trends in both market cap and net income, which does a great job reflecting rapid industrial growth and increasing investor confidence in an emerging market environment.

13

13/18

Honeywell- Enterprise Trend

14

Honeywell displays steady growth in both net income and market capitalization over the period analyzed. The trends move closely together, reflecting consistent financial performance and a relatively stable business model. This suggests that profitability is an important factor in shaping investor valuation.

14/18

Boeing- Enterprise Trend

15

Boeing’s enterprise trend shows significant volatility in both net income and market capitalization. Unlike Caterpillar and Honeywell, the movements are less synchronized, particularly during periods of operational disruption. This indicates that market value is influenced by factors beyond current profitability.

15/18

Caterpillar- Enterprise Trend

16

Caterpillar’s market capitalization and net income generally move in the same direction over time. Periods of higher profitability align with increases in market value, suggesting that earnings performance plays an important role in how investors value the company. While there are some fluctuations, the overall trend shows a fairly stable relationship.

16/18

Value Driver Analysis

17

This value driver analysis shows a strong positive relationship between net income and market capitalization across Caterpillar, Honeywell, and Boeing, with an R^2 of 0.928. Caterpillar demonstrates the strongest alignment between profitability and firm value, reflecting investor confidence in consistent earnings. Honeywell follows the same trend, though with slightly lower valuation relative to net income. Boeing stand out as an outlier, they maintain a high market capitalization despite negative net income, suggesting that investor expectations and long-term recovery prospects may play a significant role in its valuation.

17/18

Notes & Insights - Part 3 (Market Cap vs. Net Income)

This section analyzes the relationship between market capitalization and net income for three major US Industrial Companies: Caterpillar, Honeywell, and Boeing, using both enterprise trend charts and linear regression analysis. Across all three companies there is a positive relationship between net income and market capitalization, but the strength of that relationship varies noticeably.

For Caterpillar, the company shows a much stronger and more consistent relationship between net income and market capitalization. Even though the company has faced legal and regulatory challenges, its core business operations have remained stable, and demand for heavy equipment has continued. As a result, profitability remains a key factor in how the market values the firm.

Honeywell shows a similar pattern to that of Caterpillars, though slightly less tight than theirs. Net income still matters a lot, but its diversified business model means valuation is not driven by just earnings alone. Even so, the overall trend shows that higher profitability generally leads to higher market value.

Boeing stands out as the outlier, as its market capitalization remains relatively high during periods of weak or negative net income. This disconnect can be linked to a series of major safety and regulatory issues that significantly impact short-term earning but did not eliminate long-term demand for the company's products. Investor valuation appears to be drive more by expectations of recovery and future contracts than by current profitability in the market.

18

18/18

Financial Impact of Supply Chains

Primary Modal