# Commodity Hedging Model Design and monitor commodity hedges that lock in margins and smooth volatility without relying on spreadsheet trial-and-error. Match physical exposure to financial instruments, track basis risk and carry costs, and measure hedge effectiveness over time. - Canonical: https://finamodel.com/templates/commodity-hedging-model - Excel download: https://finamodel.com/templates/commodity-hedging.xlsx - Category: Energy - Model type: Portfolio - Difficulty: Advanced - Audiences: Investors & analysts, CFOs & FP&A, Procurement teams, Producers, Hedging officers, Operations - Tags: Risk management, Hedging, Commodity, Margin ## Overview This commodity hedging model evaluates the cost-benefit of locking in copper producer margins using forward contracts and put options across three price scenarios (base, high, low). The model hedges 50% of annual copper production (500,000 tonnes) using forwards at $8,500/tonne and buys 20% put options at $8,000/tonne strike with a $150/tonne premium. It then measures the variance reduction (percentage decrease in earnings volatility) that hedging delivers across the three scenarios, accounting for the real cash cost of put premium. The model includes a price scenario builder showing base case ($8,500/tonne starting, +2% annual growth), high case (+8% growth), and low case (−5% decline), with all three scenarios wired to separate P&L columns simultaneously. A hedge portfolio sheet calculates forward settlement (difference between forward price and realised spot) and put payoff for each scenario and year. Two P&L sections (unhedged and hedged) feed to a hedge effectiveness sheet that computes standard deviation of net income across scenarios and calculates variance reduction = 1 − (StdDev Hedged / StdDev Unhedged) as a percentage. This model is used by mining finance teams demonstrating covenant compliance and lender appeal through hedging, treasurers budgeting operations around hedged margin assumptions, and investors assessing the downside protection and cost of hedging programmes. It converts abstract hedging concepts into concrete earnings volatility metrics, helping boards balance margin certainty against hedging costs. ## What's included - Physical exposure profile by commodity and term - Hedging instrument selection and sizing - Basis risk modeling and cost-benefit analysis - Daily mark-to-market of hedged position - Hedge effectiveness ratio and earnings impact ## Commodity Hedging Model: How the Template Locks In Copper Margins For a mid-tier copper producer weighing whether to lock in margins, this commodity hedging model shows how a forward-and-put programme affects revenue and earnings across price scenarios. It models 50% of production hedged with forwards and 20% with bought puts, then measures volatility reduction year by year using cross-scenario statistics. Rates and financial results described here reflect illustrative model settings, not industry benchmarks. ### Operating Drivers Behind the Hedge Decision The template begins with a single producing asset: 500,000 tonnes per annum, growing 3% annually, sold at an active LME spot price in US dollars per tonne. A scenario toggle on the assumptions sheet selects one of three price paths. - All three start from the same Year 1 spot, then diverge through annual growth rates. That shared starting point matters because the hedge book is struck against Year 1 conditions, so notional divergence begins only from Year 2. - Costs are captured as a per-tonne stack with separate lines for C1 cash cost, treatment and refining charges, and site G&A, each inflated annually at a common rate. This separation lets you see each component rather than a single collapsed cost figure. Corporate admin is a fixed dollar amount that does not scale with volume, which creates operating leverage when prices move. ### How the Hedge Portfolio Settles The hedge overlay has two instruments. A forward covers 50% of annual production at a fixed price equal to the Year 1 base spot, with no contango premium added. - Settlement is the hedged volume multiplied by the difference between that fixed price and the active spot. The sign is two-sided: a gain when spot falls below the forward, an opportunity cost when spot rises above it. - A bought put covers 20% of production at a strike below spot, with the premium expensed in full in the first year rather than amortised. The put payoff is the maximum of zero and the difference between strike and spot, multiplied by hedged put volume. Total hedge settlement equals forward settlement plus put payoff minus the first-year premium. Because only a bought put is used, upside above the strike remains unhedged, which is deliberate: selling a call to finance the put would cap the high-price scenario and muddy the effectiveness comparison. Calculation summary: ```text Total hedge settlement = forward settlement + put payoff − the first-year premium ``` ### Calculation Flow and Financial Statements Revenue on the hedged statement equals unhedged revenue plus hedge settlement. That effective revenue figure then drives several downstream items: capital expenditure is a percentage of effective revenue, receivables are calculated on effective revenue, and inventory and payables are calculated on the C1 cost stack. - From effective revenue the model deducts the three cost lines and corporate admin to reach EBITDA, then depreciation, interest and commitment fees to reach pre-tax profit. Tax applies only when pre-tax profit is positive, with no refund modelled. - Net income feeds dividends at a fixed payout when positive, and retained earnings roll forward. Cash flow is built indirectly, with working capital changes based on opening balances rather than the full first-year balance. A term loan amortises straight-line, while a revolver with a cash sweep repays drawn balances when operating cash exceeds a minimum floor, or draws when it falls short. The balance sheet carries no derivative asset or liability line because settlements flow through profit and loss rather than sitting as open mark-to-market positions. Calculation summary: ```text Revenue on the hedged statement = unhedged revenue + hedge settlement ``` ### Outputs and Practical Use The primary analytical output is a hedge effectiveness sheet that reads all three price scenarios simultaneously through independent helper rows, so it does not depend on the active toggle. For each year it computes the standard deviation of unhedged and hedged revenue, EBITDA and net income across the scenarios, then expresses variance reduction as one minus the ratio of hedged to unhedged standard deviation. - A positive figure means hedging dampens volatility; averaging across years gives a single headline number per metric. Validation checks confirm the balance sheet balances each year, cash stays non-negative, the revolver remains within its limit, forward and put hedge ratios hold at their target percentages, the effective revenue reconciliation ties, and the put payoff is never negative. - Practically, this helps a producer test whether locking in margins via forwards and buying price-floor protection actually smooths earnings across bull and bear cases. Note that the public download is a values-only preview; the live model captures these relationships. ## Layered hedging and timing risk Model dollar-cost-averaging or tranched hedging programs that reduce timing risk and smooth entry prices across the exposure period. ## Scenario comparison across hedge ratios Compare outcomes under unhedged, partially hedged, and fully hedged paths to identify the optimal hedge ratio for your risk appetite. ## Accounting treatment and P&L timing Flag hedges eligible for hedge accounting under IFRS 9 or ASC 815 and model the impact on P&L recognition timing. ## Layered hedging and timing risk Model dollar-cost-averaging or tranched hedging programs that reduce timing risk and smooth entry prices across the exposure period. ## Scenario comparison across hedge ratios Compare outcomes under unhedged, partially hedged, and fully hedged paths to identify the optimal hedge ratio for your risk appetite. ## Accounting treatment and P&L timing Flag hedges eligible for hedge accounting under IFRS 9 or ASC 815 and model the impact on P&L recognition timing. ## Features - **Layered hedging:** Model dollar cost averaging or tranched hedging programs that reduce timing risk. - **Scenario comparison:** Compare outcomes under unhedged, partially hedged, and fully hedged paths to find the optimal hedge ratio. - **Accounting treatment:** Flag hedges eligible for hedge accounting and model impacts on P&L timing. ## Use cases - **Margin protection for manufacturers:** Lock in input costs and model the hedge cost as a margin insurance premium. - **Producer revenue hedging:** Structure commodity price floors that protect against downside while preserving upside participation. - **Supply chain optimization:** Model where and when to hedge in your supply chain, balancing cost and execution complexity. ## Frequently asked questions ### What is a commodity hedging model? It is a model that matches physical commodity exposure to financial instruments, sizes hedge positions, and tracks effectiveness and mark-to-market P&L over time. ### How do I size a hedge correctly? Match the quantity and tenor of financial instruments to your physical exposure. The model calculates the optimal hedge ratio for your volume and timing. ### What is basis risk? Basis risk is the difference between your local commodity price and the benchmark futures price. It is often the largest residual risk in a hedging program. ### Can I model dynamic hedging? Yes. Set rebalancing rules and the model tracks how margin calls and P&L changes affect your hedge ratio over time. ### Who uses commodity hedging models? Procurement teams, commodity producers, hedging officers, and finance teams use them for margin protection, revenue hedging, and supply chain cost management. ## Related templates - [Commodities Trading Model](https://finamodel.com/templates/commodities-trading-model) - [Oil & Gas Upstream Model](https://finamodel.com/templates/oil-gas-upstream-model)