Capital Structure [Done]

The Capital Structure or Tranche Tab is located in the Capital Structure section of the platform. Tranche types and functionality are specified within this tab. The mandatory fields are Name, Type, Balance ($), Coupon (%), and a Settlement Date.   Tranche Types Overview * P&I: A tranche that has both Principal and

Capital Structure Tranche Terms Field Definitions:  Name of Field: Definition of Field: Name The Name field is the placeholder for the naming of the Tranche.  Type The Type field allows users to define the type of tranche. T-REX provides options for tranche types: P&I, P&I Pass-Through,

Within the Capital Structure Settings tab, the user can define capital structure specific settings and optional termination terms.  Capital Structure Settings:   * 1st Interest Payment Date: The first date in which the interest payments are due. The date must be after the earliest tranche settlement date (defined in the tranches tab)

The Collateral Collection Accounts Table shows all of the existing accounts within the deal. The user can name new accounts and choose their Account Type. T-REX supports Collection Accounts, Overdraft Accounts, and Revolving Accounts.  See Revolvers page for more information on Revolving Accounts.  The user must press Save the Collection

The Structured Parameters table allows the user to pre-define any variables that may be useful while using the Dynamic Expressions. See Dynamic Expressions page for further details. These are usually parameters which are set in the deal and are useful to have access to. The user can define each parameter

All securitization models require some form of input to create the calculated outputs.  Some are on the asset/loans side, and some are on the bond side.  Currently, on the bonds side, our model supports structured parameters for fixed values in a model. Model inputs are for inputs with changeable

Within the Expenses tab, the user can define expenses that will go into structuring a deal; for example, accounting costs, legal fees, etc. The Expenses tab is divided into two different sections: Upfront Expenses and Ongoing Expenses.  Upfront Expenses: The user can document any Upfront Expenses. The names of the

Within the Reserve tab, users can define multiple reserves within their deal. The user can define different reserve accounts that depend on the target balance on different units. The user can define a Reserve based on % Collateral, Amount ($), or Months of Interest.  The user can define the initial Balance, the

Within the Capital Structure section of the platform, the tab Combo Tranches allows users to aggregate existing tranches into a new display tranche. Having combination tranches gives users structuring flexibility to separate tranches for calculations yet also aggregate tranches for reporting. Examples are shown below: To make a combination tranche,

Within the Digital Waterfall, the user can build out the structure of the payments within the deal. The Digital Waterfall will run through each of the steps for each period of the deal, in the order that they are defined, for the number of periods defined under Portfolio > Settings.

Dynamic Expressions allow users to define necessary functions with great flexibility quickly. These expressions can be used in the Waterfall tab, or can be seen easily in Reports, thus giving the user quick access to different aspects of the deal at any given time. See the Dynamic Expression Syntax for

General Operands: The following operands are supported in the Dynamic Expressions: Functions:  OFFSET: Find an expression or variable’s value(s) in certain point(s) in time. The OFFSET function can be used to get a prior value or a range of value for a variable or expression. Usage: OFFSET(