Treasury Model Structure

Institutional Definition¶

A treasury model forecasts a company's cash and liquidity position at a shorter horizon and finer granularity than the three-statement model it draws from, and adds cash-management mechanics the standard forecast does not need — a rolling daily or weekly cash position, cash pooling and intercompany funding between group entities, headroom against committed facilities, and FX and interest rate exposure on non-functional-currency balances. It is not a replacement for the three-statement cash flow statement; it is a specialization that takes the three-statement model's flows as an input and adds the timing and cash-management detail a periodic forecast does not represent.

Why It Matters¶

A three-statement model can be entirely correct about a period's net cash flow — the right revenue, the right costs, the right capital expenditure — while still missing an intra-period liquidity event that would matter enormously to the business: a large supplier payment falling due before a large customer receipt clears, a debt maturity landing in a week when seasonal cash is at its low point, or a subsidiary running short of local cash while the group as a whole holds ample cash trapped in another entity or currency. These are timing risks, not magnitude risks, and a monthly or quarterly three-statement forecast is not built at the granularity needed to catch them. A treasury model exists specifically to close that gap.

Getting the structure right matters because a treasury model introduces failure modes a single-entity three-statement build does not have to guard against. Cash pooling and intercompany funding, if modelled without the offsetting elimination, silently overstate group liquidity in the same way an incomplete intercompany elimination overstates group revenue in a consolidation model. Facility headroom sized against zero rather than a stated minimum buffer misses a breach that has already occurred on paper. And FX or interest rate exposure buried inside the forecast formula itself, rather than surfaced as a separate labelled sensitivity, becomes impossible to size or hedge independently.

Core Concepts¶

The cash position build. The core output of a treasury model — a rolling forecast of the cash balance itself, typically daily or weekly, distinct from the periodic net-change figure a cash flow statement shows.

Cash pooling and intercompany funding. Mechanisms that move cash between group entities to fund a deficit at one from a surplus at another, which must be modelled alongside the offsetting intercompany elimination so pooled cash is not double-counted at the group level.

Facility headroom. Available committed facility capacity net of drawn amounts, tested against a stated minimum liquidity buffer rather than zero — see Covenant Analysis and Headroom for the covenant-side treatment of the same concept.

FX and interest rate exposure. Non-functional-currency cash and debt balances and floating-rate exposure, surfaced as a labelled sensitivity rather than embedded in the base forecast, so the exposure can be assessed and hedged independently.

Technical Explanation¶

Structuring the Cash Position Build¶

A treasury model's cash position build starts from the three-statement model's operating, investing, and financing cash flows as its major inputs, then disaggregates them to a finer time granularity and adds the items a periodic statement does not track individually — the specific timing of large receipts and payments within the period, drawdowns and repayments on short-term facilities, and any cash pooling or intercompany transfers. The build should make the opening position, each major flow, and the closing position all independently traceable, rather than compressing the period into a single net movement figure.

Opening Cash Position
+ Operating Receipts (by expected date, not period total)
- Operating Payments (by expected date, not period total)
+/- Financing Flows (facility drawdowns, repayments, intercompany transfers)
= Closing Cash Position

Modelling Cash Pooling Without Double-Counting¶

Where a group operates a cash pool or notional pooling arrangement, each participating entity's contribution or draw creates both a change in that entity's own cash balance and an offsetting intercompany receivable or payable against the pool header account or the entity on the other side of the transfer. At the group consolidation level, these intercompany balances must net to zero — the same discipline required in a consolidation model's intercompany elimination. A treasury model that reports a subsidiary's pooled cash balance without the offsetting intercompany entry, or that aggregates entity-level cash positions into a group total without eliminating intercompany funding, will overstate the group's actual available liquidity.

Sizing Facility Headroom Against a Buffer, Not Zero¶

Facility headroom is the gap between a committed facility's total capacity and the amount currently drawn. The structural error to avoid is testing that headroom, or the cash position itself, only against zero. A business that maintains a stated minimum liquidity buffer — whether a self-imposed policy minimum or a covenant-required minimum — is already in breach of that policy or covenant the moment cash or headroom falls below the buffer, even though no balance in the model has actually gone negative. The model should carry the buffer as an explicit labelled assumption and test the cash position and headroom against it directly, rather than leaving the reader to infer the breach from a balance that still looks positive.

Surfacing FX and Interest Rate Exposure Separately¶

Cash and debt balances held in a currency other than the entity's functional currency, and any floating-rate debt or facility, create exposure that should be modelled as a distinct, labelled sensitivity rather than folded into the base cash forecast formula. Structuring it this way allows the exposure to be sized on its own terms — for example, the mark-to-market impact of a defined FX or rate move on the non-functional-currency balance — and lets a hedging decision be evaluated against that isolated figure, rather than requiring the base forecast itself to be rebuilt each time an exposure assumption is tested.

Relationship to the Debt Schedule¶

A treasury model does not re-model scheduled principal and interest by instrument — that remains the debt schedule's responsibility. The treasury model draws its debt service cash flows from the debt schedule as an input and adds only what the debt schedule does not cover: the short-term cash position, pooling and intercompany funding, and facility headroom against uncommitted or revolving short-term facilities the debt schedule may not model at the same granularity.

Common Structural Errors¶

Industry Applications¶

Treasury modelling matters most where a business holds cash and debt across multiple entities, currencies, or facilities — multinational corporates with subsidiaries in several jurisdictions, groups operating shared or notional cash pools, and businesses with meaningful revolving or short-term facility usage layered on top of longer-term structured debt. It is least necessary for a single-entity, single-currency business with no committed facilities beyond its core term debt, where the three-statement model's periodic cash flow statement is typically sufficient on its own.

Common Misconceptions¶

"The three-statement model's cash flow statement already covers this." It covers the period's net cash movement at a periodic granularity, but not the intra-period timing of individual receipts, payments, and facility drawdowns that a treasury model exists specifically to surface.

"Pooled cash is just cash — it doesn't need separate tracking." Pooled cash carries an offsetting intercompany balance the moment it moves between entities, and omitting that offsetting entry overstates group liquidity in exactly the way an incomplete intercompany elimination overstates group revenue.

"Facility headroom is fine as long as it's positive." Headroom that is positive but below a stated minimum buffer or covenant requirement is already a breach — testing only against zero misses it entirely.

Relationship to Financial Model Audit¶

A treasury model built to this structure is easier to review because its cash pooling, headroom, and exposure mechanics are each separately traceable rather than embedded inside a single cash forecast formula. Financial Model Audit for Corporate Finance sets out the independent audit-risk perspective for corporate models generally, including the intercompany-elimination failure mode this guide's cash-pooling discipline is designed to prevent; general-purpose governance content — Model Review and QA Workflow, Model Documentation Standards — applies equally here and is reused rather than duplicated.

References & Further Reading¶

• Association for Financial Professionals (AFP) — Treasury and Cash Management guidance
• ICAEW, Financial Modelling Code, Institute of Chartered Accountants in England and Wales

Continue Reading¶

Prerequisites¶

• Corporate Financial Modelling — the parent pillar
• Three-Statement Model
• Debt Schedule

Related Technical Guides¶

• How to Build a Debt Schedule
• Consolidation Model Structure
• Covenant Analysis and Headroom
• Capital Allocation Model Structure
• Financing Strategy Considerations

Related Glossary¶

• Intercompany Elimination
• Debt Schedule