X-ALM Cross ALM
Catalogue

The whole balance sheet, product by product.

Each product family has its own run-off, behaviours and new business. Each indicator has a single formula, identical whatever the product: only the principal trajectory changes.

Fixed rateFloating rateAssetsLiabilitiesExisting bookNew businessMulti-currencyMulti-entity
Amortising products

Loans, term deposits and market instruments.

The products that have a contractual schedule: the engine follows every cash flow, every step, every rate reset, and overlays the customer's decisions.

FamilyWhat it isEngine highlights
MortgagesHome loans: standard, adjustable, flexible, smoothed, subsidisedLevel instalments and steps, rate-sensitive prepayments, renegotiations, deferred drawdowns
Equipment loansInvestment loans to companies and professionalsFull loan engine: prepayments, renegotiations, drawdown
Zero-interest loansSubsidised loans with no customer interestZero customer rate, margin carried by funds transfer pricing, deferred amortisation
Personal loansConsumer creditLevel instalments, constant prepayment rate
Other itemsGuaranteed loans, treasury operations, structured financePrincipal steps, forced maturities
Term accountsDeposits locked until maturityInterest capitalisation, amortising schedule
InterbankLoans and borrowings between institutionsQuarterly or annual instalments, assets and liabilities
SecuritiesBonds, negotiable debt securities, floating-rate notesBullet repayment, coupon steps, premium and discount
SwapsFixed and floating legs of interest-rate swapsForced maturity, inflation-linked clones, reconstructed fixings
ReposRepos and reverse reposReconstructed fixings, floating-rate reference for the interest-rate view
Fixed or floating rate

A fixed-rate product stays in the interest-rate gap until maturity. A floating-rate product leaves it at each rate reset: its run-off in the interest-rate view is shorter than in the liquidity view. X-ALM keeps both views for every contract, with the actual fixing calendar, bank holidays and day-count conventions.

Savings and non-maturity deposits

What has no maturity still has a run-off.

Sight deposits, passbook accounts and regulated savings have no end date. The engine applies a conventional run-off by layer, separates the stable portion from the volatile one, and projects inflows and new business.

Livret A and LDDS

French regulated savings at a state-set rate. Layered run-off, dedicated new business.

LEP

Means-tested regulated savings with a subsidised rate.

PEL

Home savings plan: rate generations, closure-rate model, dedicated new business.

CEL

Liquid home savings account, with its new business.

Passbook accounts

Taxable bank savings accounts at a bank-set rate.

Sight deposits

Non-interest-bearing current accounts: stable and volatile portions, dedicated new business.

Modelled term deposits

Term deposits treated as a non-maturity balance, distinct from amortising term accounts.

Interest-rate options

Caps, floors and swaptions, marked to market.

Option instruments are priced at every projection date: caps and floors with the shifted Black or Bachelier model and interpolated volatility surfaces; swaptions with forward swap rate, annuity numeraire and Bachelier. The engine reports the market value, its time value, interest payments and the premium.

Forward rate curves, fixing calendars and accrual conventions are shared with the rest of the engine: the valuation of the options is consistent with the projection of the contracts they hedge.

Customer behaviour

What the customer can decide, the engine models.

  • Prepayments: constant rate per product, customer segment and maturity, or a model sensitive to the spread between the contract rate and the market rate, with burn-out effect, bounds and parameter sets per residual maturity.
  • Renegotiations: repricing of a book of loans to a lower rate when market rates make it worthwhile.
  • PEL closure rates: model per rate generation and plan age.
  • Deferred drawdowns: signed loans whose funds are released in tranches.
  • Deposit stability: stable and volatile profiles, inflows, layering by age.
Curves and scenarios

Curves built, then shocked, month by month.

Construction

Reference curves per currency, bootstrapping of zero-coupon curves, log-linear interpolation of discount factors, tenor filtering.

Calculated curves

Combinations of underlying curves, time shift, weighted moving averages, recursive curves defined by formula, evaluation order.

Shocks

Up, down, flattening, steepening, per curve, currency, maturity and month window. Liquidity, inflation and zero-coupon curve shocks.

Scenarios

A scenario assembles its shocks, its models, its new business and its recalculations by name. A run chains as many as needed, on the same book.

Funds transfer pricing

Funds transfer pricing and liquidity curves to split net interest income into a rate effect and a commercial-margin effect.

New business

Volumes, rates and run-off profiles per product and per month, new business for balance-sheet adjustment, new-business stress, overlays.

Indicators

Five families, some forty indicators, a single projection.

Each indicator is reported by category (existing book or new business), by mode (monthly value, forward view per window, annual contribution), with its window bounds and its sampling step.

FamilyIndicatorsWhat they are for
ClassicEnd-of-month and average-of-month balances in the liquidity and interest-rate views, net interest income and its rate / margin breakdown, liquidity, interest-rate, inflation and regulatory gaps, new-business volumes, customer ratesDay-to-day management of the balance sheet and the margin
LCR and NSFROutflows by time bucket, balance deltas, high-quality liquid assets (HQLA), net cash outflows, available and required stable fundingThe regulatory liquidity ratios, projected
Annual contributionsBalance, margin and breakdown of each new-business vintageWhat today's new business yields, year after year
EVEEconomic value of equity, discounted principal and interest cash flows, gaps in the EVE viewThe sensitivity of the balance sheet's value to rate shocks
Options and market valueMarket value, time value, interest payments, premiumThe valuation of option-based hedges
One principle

An indicator's formula does not change with the product. What changes is the principal trajectory and the rate scenario. That is what makes the figures reconcilable across products, across scenarios and across entities.

Extensibility

A product that is not in the list can be added without touching the rest.

A new product is described by its run-off, its rate rules and its behaviours, and is added without modifying existing products. A guide gives step-by-step instructions for amortising and non-maturity products alike.

That is how X-ALM can be adapted to an insurer's balance sheet, a specialist bank or a local product.

🧩

What you bring

  • Your contracts, one file per product and per entity
  • The mapping tables from your reference data
  • Your behavioural models, as Excel workbooks
  • Your market curves at the reporting date
See how the input data is organised →

A product missing? An indicator you are interested in?

Let's talk about your balance sheet. We will tell you what is covered out of the box, and what needs adapting.