P&L Insight
The new P&L Insight module gives users more information to better understand realized and unrealized P&L as well as the changes in these P&L values both daily and over longer periods.
The P&L impact screen shows both realized and unrealized assets by using different filters. Users can compare the P&L of any daily snapshot with that in any other daily snapshot, both on a summary level and in the drill down level of individual assets.
On a summary level grouped by position:
| • | Users can see the 3 summarized values of the realized, unrealized and combined P&L for both snapshots as well as the change between the 2 snapshots. |
| • | So for each of these 3 P&L values you can choose to see 3 different values: |
| o | the value for the main snapshot, |
| o | the compared value for the other snapshot, |
| o | and the change between the 2 snapshots. |
| • | So in total these are 9 columns with P&L information |
On the drill down level of individual assets:
| • | Users can see these same 9 columns for the individual contribution of every asset to the P&L values and to changes in the P&L values. |
| • | By clicking on any individual asset users can open a fully detailed field level comparison of that asset with the same asset in the compared snapshot. |
| • | In case an asset exists only in 1 of the 2 snapshots you will see that it is 0 valued in the other snapshot. |
All this data can be downloaded into an Excel file for further analysis. To support analysis, 2 more columns have been added to this export:
| • | the snapshot date – this allows you to easily combine multiple snapshot exports in one file and create a pivot table across data sets from different snapshots. |
| • | the realization date – this allows you to see the date the asset is marked as realized (which is not necessarily the same as the date on which the realization was recorded in the administration, e.g. execution dates are often in the past). |
The usage of the P&L Insight screen is completely the same as the Mark to Market screen. Both screen have search filters at the top of the list. The difference is that the P&L Insight default search is for realized assets of the current month, while Mark to Market default search is for unrealized assets.
Like on the Mark to Market screen, users can modify the view to their preferences and save it as their default view. They can:
- indicate which columns to display (right click the column headers),
- change the order of the columns (drag a column),
- group the data by specific columns (drag a column),
- sort the data (click a column header or group header)
This can be done separately on the summary and in the drill-down screens.
History/Comparison
History or a value comparison is now shown for all columns (when it exists). You should now select the line to see the information for all columns instead of hovering with the mouse to show an individual value.
P&L Insight Screen Permission
You will need to be granted the “View P&L Insight” permission to see the P&L Insight tile on the Home screen. This permission is located under the MTM section on the Role screen.