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

The Rate Sheet Screen

Shows PrecisionLender Rate Sheets screen for Small Business Rate Table product

 

Sections:

 

Toolbar

Shows Rate Sheets toolbar with the following options

  • 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

Shows Rate Sheets header with the following options

  • 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

Shows Rate Sheets tabs with the following options

  • Add
    • The Add tab will allow you to add a new Rate Table to your Rate Sheet based on the available products. You can also use the search bar to quickly find the desired Rate Table.
    • 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

Shows Rate Sheets details with the following options

  • Table Name
    • This field sets the Table Name for the specific Rate Table in your Rate Sheet.
    • The left (Arrow pointing Left) and right (Arrow pointing right) arrows allow you to modify the position of the Rate Table in relation to other Rate Tables.
    • The copy icon (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 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 Fixed is selected, the Spread Locked field will appear allowing you to set a Fixed rate based on a curve plus a spread. The Default Spread applies to the entire table, however you can override this Spread within individual cells.
    • 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 can adjust the LTV (Loan to Value) and Recovery Rate for the collateral here. Note: If the Recovery Rate is set to 0%, changes in LTV will not affect the rate calculations.
  • 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.
  • Prepayment Option (Commercial Loan Rate Sheets)
    • If enabled, Prepayment Option will display in the Details section with a dropdown menu.
    • Available Prepayment Options:
      • 5-4-3-2-1
      • 3-2-1
      • Yield Maintenance
  • Funding Source
    • This field allows you to select different funding packages for your rate sheet as long as you don’t have an override set on the product you’re pricing, and as long as you have multiple funding packages set up.

 

Rate Table

Shows Rate Sheets Rate table with the following options

  • 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 (Trash can Icon) to delete a specified loan range.
    • Click on the plus icon (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
      • Amortization Term
      • Target ROE Adjustment
    • 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 (Trash can Icon).
    • Click on the plus icon (Plus Icon) in the top right to add a new product variation. (column)

Articles in this section