A rolling treasury exposure forecast turns changing sales, purchasing, debt, and cash-flow expectations into a repeatable hedging decision. This guide shows how to consolidate exposures, remove natural offsets, separate committed transactions from uncertain forecasts, calculate hedge coverage, and document the approvals and exceptions that keep a corporate hedging program disciplined.
Overview
Treasury teams rarely hedge a fixed picture of the business. Customer receipts move, suppliers change delivery dates, interest payments reset, and forecast sales are revised. A hedge that was correctly sized last month can therefore become too large, too small, or mismatched to the underlying exposure.
The solution is a rolling exposure forecast: a monthly process that looks forward over a defined horizon, such as the next 12 months, and updates the expected currency, commodity, interest-rate, or cash-flow exposure. The objective is not to predict markets. It is to make the company’s risk position visible and apply consistent rules to the portion management has decided to protect.
A useful workflow answers five questions:
- What cash receipts and payments are expected, in which currency or price index, and in which period?
- Which exposures are committed, highly probable, or merely budget assumptions?
- Can receipts and payments naturally offset one another before derivatives are used?
- What percentage of the remaining exposure should be hedged?
- What changed from the previous forecast, and who approved the resulting hedge or exception?
This process supports currency hedging for importers and exporters, commodity hedging for fuel or raw materials, and interest rate hedging for floating-rate debt. The instruments may differ, but the decision architecture is similar.
How to estimate
Start with a time-bucketed exposure schedule. Monthly buckets are usually practical for a rolling forecast, although weekly buckets may be appropriate for near-term liquidity or highly volatile commodities. For each business unit, record expected inflows and outflows before considering any hedge.
A simple exposure calculation is:
Net exposure for a period = expected receipts − expected payments
Calculate this separately by currency, commodity, interest-rate basis, and settlement month. Do not combine exposures merely because they are economically related. A euro receipt in March may not offset a dollar payment in April, and a forecast fuel requirement may not track the exact price of the company’s physical supply contract.
Next, apply natural offsets. For example, if a company expects foreign-currency sales of 2 million units and foreign-currency supplier payments of 1.2 million units in the same month, the initial net exposure is 800,000 units. Only the net amount needs to be considered for an external hedge, subject to timing, liquidity, and policy constraints.
Then classify the exposure:
- Committed: supported by an executed contract, purchase order, invoice, debt agreement, or other sufficiently firm obligation.
- Highly probable: expected to occur based on an approved plan or recurring business pattern, but not yet contractually fixed.
- Forecast or budget: useful for planning, but more exposed to changes in volume, timing, or business assumptions.
Apply the approved hedge ratio to each category. A basic formula is:
Hedge coverage = notional amount of hedge ÷ forecast exposure
If the forecast exposure is 1 million units and the policy calls for 70% coverage, the target hedge notional is 700,000 units. If 400,000 units are already hedged, the additional target is 300,000 units, before considering existing commitments, minimum trade sizes, or permitted ranges.
For a more detailed sizing approach, teams may use a hedge ratio that reflects contract specifications, price sensitivity, or historical relationship between the hedge instrument and the exposure. The hedge ratio formula guide explains how this differs for futures and options.
Inputs and assumptions
The forecast is only as reliable as its inputs. Create one controlled template or treasury-system view with a clear owner for each data field. At minimum, include:
- Exposure owner and legal entity
- Exposure type: currency, commodity, interest rate, or other risk
- Settlement or reset month
- Expected amount and transaction currency
- Confidence category
- Natural offsets and intercompany netting
- Existing hedge notional, instrument, maturity, and strike or fixed rate where relevant
- Policy hedge ratio and permitted minimum or maximum
- Forecast version and date
- Reason for any manual adjustment
Make assumptions visible rather than burying them in formulas. A currency forecast may assume a customer invoice settles on its contractual due date; a commodity forecast may assume a particular production volume; an interest-rate forecast may assume debt remains outstanding through the projected period. Each assumption can create a different form of basis risk, meaning the hedge may not move perfectly with the exposure.
Also distinguish economic exposure from accounting treatment. A derivative can reduce cash-flow uncertainty without automatically receiving a particular hedge-accounting designation. If hedge accounting is relevant, coordinate the forecast, designation documents, effectiveness methodology, and month-end evidence with accounting advisers and the company’s policy. The cash flow hedge accounting workflow covers documentation and effectiveness review in more detail.
A practical rolling template can use these columns:
Month | Gross receipts | Gross payments | Natural offset | Net exposure | Confidence | Policy coverage | Existing hedge | Proposed trade | Variance from prior forecast | Approval status
Keep forecast volume and market inputs separate. The volume forecast determines how much risk exists; the market rate, forward points, option premium, commodity basis, or interest-rate assumption helps estimate the financial effect. Updating one should not silently overwrite the other.
Worked examples
Example 1: Foreign-currency operating cash flow
Assume an exporter forecasts a receipt of EUR 1.5 million in month one and a payment of EUR 500,000 to a supplier during the same month. The net exposure is a EUR 1 million receipt. Under a policy of 80% coverage for committed receipts, the target hedge is EUR 800,000.
If EUR 300,000 is already covered by a forward contract, the proposed additional hedge is EUR 500,000. The treasury team should verify that both transactions settle in the same period and that the payment is genuinely available as an offset. If the customer receipt becomes less certain, the exposure may move from committed to forecast, potentially changing the permitted coverage.
For a small business, the same logic can be applied with fewer currency pairs and shorter horizons. The FX hedging template for small businesses provides a related way to organize importer and exporter exposures.
Example 2: Forecast fuel requirement
Suppose a fleet expects to consume 600,000 gallons of fuel over a quarter. A policy permits 50% coverage for forecast consumption and 80% for contracted deliveries. If 200,000 gallons are contractually committed and 400,000 gallons remain forecast, the policy targets 160,000 gallons of coverage on the committed portion and 200,000 gallons on the forecast portion, for a total target of 360,000 gallons.
The calculation does not eliminate basis risk. A futures contract may reference a different grade, location, or pricing point than the physical fuel. Record that mismatch and monitor it rather than treating the notional amount as a perfect offset. For context on this issue, see the fuel hedging strategy guide.
Example 3: Floating-rate debt
Assume a company expects average floating-rate debt of 10 million currency units for the next six months. Its policy calls for 60% coverage, so the target protected notional is 6 million. If an existing interest-rate swap covers 4 million, the forecast proposes another 2 million, subject to debt maturity, covenant restrictions, counterparty limits, and the company’s approved instrument range.
When debt balances may be repaid early or drawn down unpredictably, a cap or collar may offer a different risk profile from a swap. Recalculate the exposure when the debt forecast changes, not only when market rates move. A quarterly review framework is described in the floating-rate debt hedge review.
When to recalculate
Run the core process at every monthly forecast close. Recalculate sooner when a material event changes the amount, timing, or certainty of cash flows. Useful triggers include a major customer order or cancellation, a revised procurement plan, an acquisition or divestiture, a refinancing, a debt drawdown or repayment, a change in production volume, or a large invoice moving between settlement months.
Market changes are also a review trigger, but they should not become an excuse for discretionary market timing outside policy. Reprice open positions and update expected costs when relevant rates, forward curves, volatility, or option premiums change. Keep the exposure decision separate from the market view: first determine how much risk exists, then decide which permitted instrument provides the intended protection.
At each monthly meeting, compare actual results with the prior forecast. Track forecast accuracy by entity, currency, commodity, and confidence category. Repeated over-forecasting or under-forecasting may justify a lower coverage ratio, a shorter hedge horizon, better data controls, or a revised forecasting method. Document why the change was made.
Finish with a short approval checklist:
- Reconcile the forecast to the general ledger, approved budget, sales plan, procurement data, and debt schedule.
- Confirm that natural offsets and intercompany netting have been applied once, not twice.
- Review committed, highly probable, and forecast exposures separately.
- Calculate target coverage and subtract existing hedges by settlement period.
- Check maturity, counterparty, liquidity, legal, and accounting constraints.
- Record proposed trades, rejected trades, overrides, and the person approving each exception.
- Archive the forecast version and compare it with the next month’s actual outcome.
A rolling treasury exposure forecast works best as a controlled operating routine rather than a one-time spreadsheet. Revisit the assumptions whenever business plans, benchmarks, rates, or pricing inputs change, and keep the policy coverage rules stable enough that the resulting hedging decisions can be explained and repeated.