A Walk-Through Video of the NBFC ALM Application.
View the Help Video on YouTube that walks through the use of the application or just watch the video to get a quick overview of the application.
https://www.youtube.com/watch?v=YijSTJBtkj8
Two zipped pdf documents. One to help understand the workings of the application and calculations and the other provides more insight into the Portfolio spreadsheet and the Acceptable Values spreadsheet.
Download these two spreadsheets via the button in the Download Acceptable Values section, below.
Two templates are available: One has fields for all 6 of the instrument types, and the other has all fields, except for interest-rate swaps.
The templates include sample bonds, loans, and other fixed income instruments with proper formatting for ALM analysis.
These templates can be uploaded to run on the ALM application, for an initial testing. Users can base the formatting of their own data on these formats.
This spreadsheet provides the acceptable values for each instrument type in the Portfolio Spreadsheet, including the required formatting of values, correct spelling of required inputs, such as "12-month", and "Actual/365".
Most importantly, the template instructs, per asset-type and liability-type, which fields are required input fields, which fields are results fields, and which fields may be left blank if not applicable, such as for adjustable-rate loan information.