4050|Periodic Report By RM

Menu location

FTP4 >> FTP Profitability Analysis >> Periodic Report By RM

Applicable for roles

• RMUSER (RM USER)
• RMUSER_M (RMUSER Maker)
• RMUSER_C (RMUSER Checker)

Parameters

Global

#	Parameters	Example
1	✅ AsOn	dd-mm-yyyy
2	✅ Denomination	Thousands

Local

#	Parameters	Example
1	✅ From Date	January 2020
2	✅ To Date	December 2020
3	✅ Hierarchy	All
4	✅ Display	Profitability and Margin

Report specific

• This report is generated for consolidated currency.

• No currency filter is applied for this report.

  .

Report details

Screenshot

Report Behaviour

1. In case data does not exist for the selected Period, a custom exception is thrown and export and print buttons are hidden.
2. In case Hierarchy is not defined for the RM, 'ALL' is the only binded hierarchy.
3. In case Display Dropdown in not bound, it throws application error.

Logic

Formulas

#	Value	Formula
1	Net Interest Income	Interest Income - Interest Expense
2	FTP Margin	FTP Income - FTP Expense
3	Net Margin	Asset Margin + Liability Margin
4	Asset Average Balance	Sum(BalAmtHCY) where AorL == 'A'
5	Interest Income	Sum(IntAmtHCY) where AorL == 'A'
6	FTP Expense	Sum(FTPAmtHCY) where AorL == 'A'
7	Asset Margin	Interest Income - FTP Expense
8	Interest Income Rate	Sum(BalAmtHCY * AvgIntRate) / Sum(BalAmtHCY) where AorL == 'A'
9	FTP Expense Rate	Sum(BalAmtHCY * AvgFTPRate) / Sum(BalAmtHCY) where AorL == 'A'
10	Asset Spread	Interest Income Rate - FTP Expense Rate
11	Liability Average Balance	Sum(BalAmtHCY) where AorL == 'L'
12	Interest Expense	Sum(IntAmtHCY) where AorL == 'L'
13	FTP Income	Sum(FTPAmtHCY) where AorL == 'L'
14	Liability Margin	FTP Income - Interest Expense
15	Interest Expense Rate	Sum(BalAmtHCY * AvgIntRate) / Sum(BalAmtHCY) where AorL == 'L'
16	FTP Income Rate	Sum(BalAmtHCY * AvgFTPRate) / Sum(BalAmtHCY) where AorL == 'L'
17	Liability Spread	FTP Income Rate - Interest Expense Rate

Export

Export button at top right corner gives the option to download the report in 4 formats #|Format| ----|-------| 1|EXCEL| 2|PDF| 3|CSV| 4|TXT|

Dependencies:

#	Search/Dropdown Field	Table Or view Used	Screen available to add/edit	Screen details
1	Display	tblCommonCodes	No	------
2	From	tblCommonCodes	No	------
3	To	tblCommonCodes	No	------
4	Hierarchy	DimHierarchyDef	Yes	FTP >> Parameter-MC >> FTP Reports Paramete >> Report Hierarchy Builder

Drill Down Reports

Product Level report

Possible errors:

ErrorCode	ErrorMessage	Cause of error
BLF02032	Data does not exist for {0}.	If Records not present for selected period