Monthly Breakdown: LFP Net Relationship

Screen ID:	ILFPNRAD-01
Screen Title:	Contact Information
Panel ID:	6036
Tool Number:	431
		Click here to magnify

Access this screen by selecting a credit union and then "Monthly Breakdown" on the entry Learn from a Peer Net Relationship Dashboard.

Provides a Monthly comparison of loans, savings, interest collected, and dividends paid for a select year.  A net calculation is also provided.  This indicates which months the credit union was a net borrower and net saver.  You have the option to include or exclude participation loan data.  Highlighted numbers are negative.

Where is the data from and how it is calculated?

• Loans and savings are end-of-month balances from MBRBAL

• Interest collected is accumulated using INTAMT from HTRANS (where TRANCD first digit is 2 or 5)

• Dividends paid is accumulated using TRAMTP from HTRANS (where TRTYPE = 9).