1. Support Center
  2. Rate Sheets
  3. Rate Sheets

The Rate Sheet Screen

RateSheetsAnnotated.png

Sections

Toolbar

Header

Tabs

Details

Rate Table

Toolbar

  • Print
  • 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
  • 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 allows you to set the region which will determine 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 products.
    • 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.

 

Details

  • Table Name
    • This field sets the Table Name for the specific Rate Table in your Rate Sheet.
    • The left (RateSheetLeftIcon.png) and right (RateSheetRightIcon.png) arrows allow you to modify the position of the Rate Table in relation to other Rate Tables.
    • The copy icon (RateSheetCopyIcon.png) 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 field is automatically filled based on the Product Type selected in the Add drop down menu.
  • Payment Type
  • 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
    • Some 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.
    • Some 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.
    • Some 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 (RateSheetTrashIcon.png) to delete a specified loan range.
    • Click on the plus icon (RateSheetPlusIcon.png) 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 (RateSheetTrashIcon.png).
    • Click on the plus icon (RateSheetPlusIcon.png) in the top right to add a new product variation. (column)

Articles in this section