The Rate Sheet Screen

Sections

Toolbar

Header

Tabs

Details

Rate Table

Toolbar

Print Rate Sheet Printouts Troubleshooting Printouts Save This button allows you to save any changes you have made to the rate sheet. Publish When you click this button a snapshot of the Rate Sheet will be saved and made available to those members of your organization who have access to view Rate Sheets. Transfer Transfer a Rate Sheet (Same process as transferring an opportunity) Delete This allows you to delete a Rate Sheet. Be careful, because this process may be irreversible. Close The Close button will take you back to the summary page of all Rate Sheets. It will also prompt you asking to save and you may if you would like to keep your work.

Export This button exports the rate sheet in the XML format and lists each rate table as a separate sheet with aggregate information in the first sheet. Assumptions The Assumptions button will open the assumptions screen where you can view what product assumptions are used in order to set the rates for the rate sheet. The Assumptions Screen (Same screen as assumptions for opportunities) If you are an administrator, these assumptions can be modified in the Administration Section.

 

 

Header

Name This field sets the name of the Rate Sheet. Owner This field shows the owner of the Rate Sheet. This defaults to the person that created the Rate Sheet. Description This is a free form text field to specify notes regarding the Rate Sheet.

Pricing Date The Pricing Date determines the assumption set that is used to set the rates in the Rate Sheet. You can fast-forward the assumption set to the most current ones by clicking on the fast-forward button next to the pricing date field. Pricing Region This field sets the region that is used to specify any product assumption modifications

 

Tabs

Add The Add tab will allow you to add a new Rate Table to your Rate Sheet based on the available product. What is a Product? Product Tab(s) You can switch between multiple rate tables by clicking on each tab to specify the table you would like to modify.

Publishing History The Publishing History tab Properties Additional Rate Sheet Features (Properties)

 

Details

Table Name This field sets the Table Name for the specific Rate Table in your Rate Sheet. The left () and right () arrows allow you to modify the position of the Rate Table in relation to other Rate Tables. The copy icon () in between the arrows allows you to duplicate the Rate Table. Description This text box allows you to note any details specific to the Rate Table. Product Name This is field is automatically filled based on the Product Type selected in the Add drop down menu. Payment Type The Payment Type options that appear here are the ones selected for the chosen product and are fully configurable for each product in the Product Edit Screen. Rate Type This field allows the Rate Type to be specified and matches the types allowed by the Product Edit Screen. This can be: Fixed Floating Adjustable When Adjustable or Floating is chosen, additional fields will appear allowing you to set the following: Minimum Initial Rate Index Minimum Spread Floor/Cap Initial Period Adjustment Frequency Maximum Initial Adjustment Maximum Periodic Adjustment Maximum Lifetime Adjustment  Note: If you have set a Minimum Initial Rate or a Minimum Spread, you may see an orange warning from Andi® letting you know that your Minimum Rate is in effect. This will display when you are meeting your target, and reminds you that you should be able to quote a lower initial rate or spread, but doing so would violate your Minimum Initial Rate or Minimum Spread. Collateral This field allows you to specify the collateral properties for the Rate Table. You specify the LTV (Loan to Value) and Recovery for the collateral here. Target  The target is pulled from the Product definition but can be adjusted by clicking on this field.

Origination Channel Clicking in the Origination Channel field will open a popup where you can select the one time cost that will be incurred by the bank at closing: Origination Channel The options listed here are fully configurable at the product level in the Administration Section. Additional Origination Expenses that the bank has to pay out, as: A percentage of fees paid by the borrower A percentage of the amount of the loan A dollar amount All of these options may not be available since they are fully configurable at the product level in the Administration Section. Setting Up Origination and Servicing Channels Servicing Channel Clicking in the Servicing Channel field will open a popup where you can select the Annual cost that will be incurred by the bank at for the life of the loan. Servicing Channel The options listed here are fully configurable at the product level in the Administration Section. Additional Servicing Expenses that the bank will incur. All of these options may not be available since they are fully configurable at the product level in the Administration Section. Setting Up Origination and Servicing Channels Fees Clicking in the Fees field will open a popup where you can enter fees that will be paid by the Borrower to the Bank. You can enter: Initial fees Paid one time only at closing Annual Fees Paid every year of the loan Discounts Clicking in the Discounts field will open a popup where you can enter any discounts that are offered for this specific product. All of these options may not be available since they are fully configurable at the product level in the Administration Section. Options This field allows you to specify print grouping options for the columns in your Rate Table. Grouping Options: No Grouping Group by Maturity Group by Risk Rating Group by Expected Life There is also a checkbox to specify whether estimated APR is shown. If checked, the APR will display in parentheses to the right of the stated rate.

 

Rate Table

Loan Range(s) (Rows) Each row is headed with a loan range. If you click on a row header: A popup will allow you to edit the range. The successive row will automatically update to match the modification. The target can also be modified for the specific loan range. The calculation value is also specified in the popup. Click on the trash icon () to delete a specified loan range. Click on the plus icon () in the bottom left to add a new loan range. (row) Specified Rate (Cell) Using the specified parameters a rate is calculated at each cell. If you click on a cell: A popup will appear allowing you to modify the specified rate. An orange highlight will appear next to cells where an issue may have arisen. (e.g. The APR is above the Maximum APR) In such cases or for any other reason you can specify: The cell to remain blank The cell to meet at target (default) The cell to meet a set rate You can also specify a footnote for each cell which will appear below the Rate Table.

Product Variations (Columns) Each column is headed with a(n): Risk Rating Maturity Expected Life If you click on a column header: A popup will appear allowing you change any or all of the previous three parameters. You can move the columns with respect to the rest by clicking on the left or right arrows. You can delete a column by clicking on the trash icon (). Click on the plus icon () in the top right to add a new product variation. (column)