Commodity Price and Exchange Rate Sensitivity Analysis

Welcome back. In our previous lesson, you mastered the calculation of key static metrics like operating margin and free cash flow, giving you a financial "snapshot" of a company at a single point in time. While essential, this snapshot doesn't tell the whole story, especially in the volatile world of commodities.

Today, we transition from this static picture to a dynamic analysis. The profitability of a mining company is heavily dependent on external factors it cannot control—namely, the market price of the commodities it sells and the exchange rates between its currency of revenue (usually USD) and its currencies of cost (local currencies). This lesson will teach you how to build a sensitivity table to model and quantify the impact of these changes on a company's financial performance.

This skill is fundamental to risk management and thesis development for your 3-12 month trading horizon. By understanding how sensitive a company's earnings are to these variables, you can better assess potential returns and, just as importantly, potential risks.

The "Why": Visualizing Uncertainty

Before we construct a table, let's build an intuition for why this analysis is so critical. A mining operation's value is not a fixed number; it's a moving target, constantly buffeted by market forces.

Professor Aswath Damodaran's presentation on valuing a Vale iron ore mine provides powerful visualisations of this concept. Please review the two slides linked below.

These charts make it clear: small changes in external variables can lead to dramatic swings in financial outcomes. Our goal is to quantify these swings for an entire company, not just a single project.

The "What": A Professional-Grade Example

So, what does this analysis look like in practice? Major mining companies provide this information directly to their investors. Let's examine a real-world example from Anglo American.

This table is the end product of a detailed internal model. It's a powerful tool for an analyst. A company with high sensitivity to a commodity you are bullish on might offer more upside (and vice versa). Now, let's learn how to construct a simplified version of this model ourselves.

The "How": Building a Sensitivity Table

At its core, a sensitivity table is a structured way to run multiple "what-if" scenarios. The logic is very similar to building a data-driven component in software development: you define inputs, an output, and a function that maps one to the other.

The process is methodical:

1. Establish a Base Case: Define your initial assumptions for production, prices, and costs.
2. Define Inputs (Drivers): Identify the key variables you want to test (e.g., copper price, AUD/USD exchange rate).
3. Define Outputs: Select the financial metric you want to measure (e.g., Revenue, Operating Profit).
4. Calculate Scenarios: Systematically change the input variables and record the effect on the output.

For a hands-on guide to the mechanics, particularly how this is implemented in a spreadsheet environment like Excel, the following video is an excellent primer.

Step-by-Step Construction

Let's build a model for a hypothetical Australian copper miner.

1. Base Case Assumptions:

• Annual Production: 100,000 tonnes of copper.
• Realised Copper Price: $8,500 USD per tonne.
• Unit Production Cost: $8,000 AUD per tonne.
• AUD/USD Exchange Rate: 0.66 (i.e., 1 AUD = 0.66 USD).

2. Base Case Calculation:
First, let's calculate the operating profit for our base case. We need all figures in a common currency, typically USD, as this is the standard for commodity pricing.

• Revenue: $100,000\text{ tonnes}\times \$8,500/\text{tonne}=\$850,000,000$
• Costs (in USD): The costs are incurred in AUD, so we must convert them to USD. $$\text{Total Cost (AUD)}=100,000\text{ tonnes}\times 8,000\text{ AUD}/\text{tonne}=800,000,000\text{ AUD}$$ $$\text{Total Cost (USD)}=800,000,000\text{ AUD}\times 0.66\text{ USD/AUD}=\$528,000,000$$
• Operating Profit: $$\$850,000,000-\$528,000,000=\$322,000,000$$

3. Building the Two-Variable Table
Now, let's see how this operating profit changes when both the copper price and the AUD/USD exchange rate fluctuate. We will create a table with copper prices on the rows and exchange rates on the columns.

• Copper Price Scenarios: $8,000, $8,500 (Base), $9,000
• AUD/USD FX Scenarios: 0.64 (weaker AUD), 0.66 (Base), 0.68 (stronger AUD)

The calculation for each cell is:

$$\text{Operating Profit}=(\text{Production}\times \text{Copper Price})-(\text{Production}\times \text{AUD Cost}\times \text{FX Rate})$$

Let's calculate the profit for the top-left cell (Price = $8,000, FX = 0.64):

• Revenue: $100,000\times \$8,000=\$800\text{m}$
• Cost (USD): $100,000\times 8,000\text{ AUD}\times 0.64=\$512\text{m}$
• Operating Profit: $\$800\text{m}-\$512\text{m}=\$288\text{m}$

By repeating this calculation for every combination, we get our sensitivity table:

	AUD/USD = 0.64	AUD/USD = 0.66 (Base)	AUD/USD = 0.68
Price = $8,000	$288m	$272m	$256m
Price = $8,500 (Base)	$338m	$322m	$306m
Price = $9,000	$388m	$372m	$356m
(All figures in millions of USD)

Interpreting the Table:

• Reading Horizontally: For any given copper price, as the AUD strengthens (FX rate increases), the USD value of the costs rises, and profits fall.
• Reading Vertically: For any given exchange rate, as the copper price rises, revenues increase directly, and profits rise significantly.
• Leverage: Notice how a relatively small percentage change in the inputs creates a much larger percentage change in the operating profit. This operational leverage is a key characteristic of miners.

Conclusion

In this lesson, you have learned to move beyond static financial metrics and build a dynamic model of a company's profitability. You now understand how to quantify the impact of the two most critical drivers for a commodity producer: the price of its product and its local exchange rate.

Key takeaways from today's session:

• Sensitivity analysis is a crucial tool for understanding the risks and potential returns of investing in commodity-linked companies.
• A company's profits are often highly leveraged to changes in commodity prices and foreign exchange rates.
• Costs are often incurred in a local currency, while revenues are tied to a USD benchmark price. A weaker local currency (fewer USD per unit of local currency) is generally beneficial for a producer's margins.
• Building a two-variable sensitivity table provides a clear, structured map of how profits react to different market scenarios.

You have now added a powerful quantitative tool to your analytical arsenal. This ability to model scenarios is a stepping stone to making more informed valuation judgments. In our next lesson, we will address valuation directly by learning to calculate and compare enterprise-value-based multiples, while considering whether a company's current performance is sustainable or simply a product of the current point in the commodity cycle.