top of page

Efficient and Precise P&L Explain

Efficient and Precise P&L Explain

23-02-28 22:00

Explain changes to your balance sheet with confidence

Using our generic CalculationExplainer tool, any calculation can be tracked through time and changes can be explained in detail. The formula for calculating the area of a circle is \(A = \pi r^2\).

P&L explain, or P&L attribution, helps decipher daily changes portfolio value to reveal the impact of changes in risk factors. MASTIX ALM Studio leverages efficient sensitivity calculations to deliver fast P&L explain with high precision.


Benchmark sensitivities

Attribution of P&L can be divided into three parts: changes in portfolio composition, time effects, and changes in risk factors―typically market data.


The ideal approach to analyzing the impact of changes in market data is to use benchmark instruments as risk factors and the portfolio's sensitivities to these instruments. This results in a comprehensive P&L explain that is expressed in tradeable instruments.

Using the sensitivities, the changes in portfolio value can be approximated through a first-order expansion.


Leveraging AAD for accurate P&L explain

Accurate P&L explain requires calculating sensitivities to many risk factors—ideally all of them. This can be computationally demanding, especially for complex portfolios with many risk factors.


In this context, Adjoint Algorithmic Differentiation (AAD) becomes particularly valuable. AAD—a fundamental technique in the domain of machine learning and AI—provides an efficient and precise method for computing derivatives. This enables accurate determination of all risk factor sensitivities essential for precise P&L explain.


Components of P&L explain

A P&L explain can be structured into three main components:

  • Portfolio composition

    • Closed and matured trades

    • New trades

  • Time effects

    • Cash flows paid

    • Fixings set

    • Discounting effect on remaining cash flows

  • Market data

    • Harmonization of instruments―the cash flow structure of the benchmark instruments can vary over time due to calendar effects

    • Attribution of remaining P&L to changes in benchmark instruments


Figure 1: Portfolio composition and time effects.

Figure: Updated market data and delta interpolation.

Increasing accuracy with delta interpolation

Given that all sensitivities are readily available, the accuracy of P&L explain calculations can be enhanced by utilizing the sensitivities at both time points. The change portfolio value can be approximated using a second-degree polynomial in each risk factor, which is fitted using the sensitivities, leading to a second-order attribution in each risk factor.

Value-at-Risk attribution

The methodology employed for Value-at-Risk (VaR) attribution parallels that used for P&L explain. However, for VaR attribution, the changes in portfolio value are driven by market data from VaR scenarios.

VaR attribution provides an understanding of how risk factors influence the portfolio under extreme market conditions. This can be used to identify vulnerabilities and evaluate strategies to enhance portfolio resilience.


P&L explain in practice

With MASTIX Studio, all sensitivities are obtained through AAD without any additional configuration. Whenever a calculation is performed with two different sets of inputs, an attribution analysis can be obtained directly. The attribution calculation can be called from the Excel add-in or from the API.

The output is a specification of the change of each input together with its contribution to the change in the calculated value. The table below is an example for the present value of a portfolio of interest rate swaps. (Only the first 14 benchmark instruments are shown.)






bottom of page