Setting Up Rate Sheets for Other Products

Use this information to set up rate sheets for fixed-rate loans, floating-rate loans, and adjustable-rate loans.

  1. Navigate to Pricing > Rate Sheets.
  2. Open the rate sheet that you want to work with by selecting its name in the Rate Sheet Set Name column.
    To create the rate sheet, select "" Add to open the Add Rate Sheet Set window.
  3. Select a situation and follow the corresponding steps.
    Situation Steps
    Fixed-Rate Loan Rate Sheets

    The structure of this loan product can be defined using the following fields.

    1. Select a rate type from the Rate Type drop-down menu.
    2. Select a payment type from the Payment Type drop-down menu.
    3. Enter a percentage in the Target ROE field.
    4. Enter a percentage in the Initial Percentage Fee field.
    5. Enter a dollar amount in the Initial Flat Fee field.
    6. Enter a dollar amount in the Annual Fee field.
    Floating-Rate Loan Rate Sheets

    The structure of this loan product can be defined using the following fields.

    1. Select a rate type from the Rate Type drop-down menu.
    2. Select a payment type from the Payment Type drop-down menu.
    3. Enter a percentage in the Target ROE field.
    4. Select an index option from the Index drop-down menu.
    5. Enter a percentage in the Initial Percentage Fee field.
    6. Enter a dollar amount in the Initial Flat Fee field.
    7. Enter a dollar amount in the Annual Fee field.
    Adjustable-Rate Loan Rate Sheets

    The structure of this loan product can be defined using the following fields.

    1. Select a rate type from the Rate Type drop-down menu.
    2. Select a payment type from the Payment Type drop-down menu.
    3. Enter a number in the Initial Period (months) field.
    4. Enter a number in the Adjustment Freq (months) field.
    5. Enter a percentage in the Target ROE field.
    6. Select an index option from the Index drop-down menu.
    7. Enter a percentage in the Spread to Index field.
    8. Enter a percentage in the Initial Percentage Fee field.
    9. Enter a dollar amount in the Initial Flat Fee field.
    10. Enter a dollar amount in the Annual Fee field.
  4. Select an editable cell in the tier table that you want to modify.
    • Select "" Add to add tiers.
    • Select "" Delete to remove tiers.

      You can edit the lower limit of the tiers to suit the financial institution's tier sets. The upper limit of each tier determines the lower limit of the next highest tier.

      Select "" Add or "" Delete to add or remove Amortization term and Expected Life combinations. Amortization terms are not needed for non-amortizing payment types.

  5. Select "" Save when the tiers and term combinations are set.
    The remaining rates that are required to meet the product's target ROE calculations appear.
Parent topic: Rate Sheets