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.
-
Navigate to .
-
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.
-
Locate the rate sheet product tier that you want to set up.
-
Select an editable cell in the product's tier table that you want to modify.
-
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.