Adding a Basic Prepay Table and Scenarios

Use this information to add new basic prepay tables and scenarios.

  1. Navigate to Setup > Prepay Tables > Basic Tables.
  2. Select the What If model that the table belongs to.
  3. Select Add..
  4. Enter a unique Table Name for the table.
  5. Select Scenarios to associate with the table if there are existing scenarios.
  6. Select the prepayment Method.
    • SMM (Single Monthly Mortality)
    • PSA (Public Securities Association)
    • CPR (Constant Prepayment Rate)
    • % of Total Balance
  7. Select Manage Scenarios.
  8. Select Add. to add a rate shock.
  9. Enter a whole number value from -1000 through 1000 in the Scenarios field.

    You can add up to 22 unique scenarios.

    Scenarios appear as columns in the grid. If several tables previously existed in the grid, then adding a scenario makes it available for each table. If needed, you can edit individual tables to control the scenarios that they use.

  10. Select Apply.
  11. Enter rate speeds for the table in the appropriate rate shock cells.
    It is important to make sure that the values are appropriate for the prepayment method the table is using. You can only use values from 0 through 100 percent for the SMM, CPR, and % of Total Balance methods. PSA only accepts whole numbers from 0 through 1600.
    For example, use monthly speeds for a table associated with the SMM method, and use annual values with a table set up with the CPR method.
  12. Select Save.
After a basic prepay table is set up, you can assign it individually to specific accounts on Setup > Chart of Accounts > Prepayments.