Setting Up Rate Sheet Tiers

Use this information to set up rate sheet tiers when adding a product to a rate sheet.

When you add a product to a rate sheet, an initial set of tiers also appears. Corresponding rates do not calculate until you select "" Save.
  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. Locate the rate sheet product tier that you want to set up.

    Rate Sheet Set Tiers

  4. Select an editable cell in the product's tier table that you want to modify.
    • Select "" Add to add rows and sometimes columns (depending on the product).
    • Select "" Delete to remove rows and sometimes columns (depending on the product).

      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.


      Rate Sheet Set Tiers - Lower Limit and Upper Limit Tiers

  5. Select "" Save.
    The application fills in the rates that are necessary to meet the target ROE.
    Tip: Rates calculate using the midpoint dollar amount for each tier. For example, in the $20,000 to $29,999 tier, the midpoint is $25,000.

    Rate Sheet Set Tiers - Midpoint Dollar Amount