Adding Ratios

You can add custom ratios to any of the six categories of ratios on the Ratios setup page.

1. Select Setup > Ratios from the menu.
2. Select Add.
   
   

   

   
   
3. Select Ratio or a user-defined ratio Category for Type.
4. Enter a unique Ratio Name or Category Name depending on the selection in the previous step.
   A recommended best practice for selecting a Ratio Name is to choose a name that is easily differentiated from the predefined ratios.
5. Choose the category for this ratio in the Belongs To drop-down list.
6. Select one of the following for Data Type:
   • Amount
   • Number
   • Rate
   This setting controls how the calculated results appear in various screens and in reports. After a ratio is saved, this setting cannot be changed.
7. Use Decimal Places to indicate the decimal precision to apply to this ratio.

   The effect of this setting can be seen on the Forecasting Ratios page and in reports that include ratios.

8. Select one of the following for Policy Limits:
   • Lower - Select Lower to set a minimum value for the ratio.
   • Upper - Select Upper to observe the maximum value of the ratio (for example, loans to deposits).
   • Range - Select Range when it is strategic to watch both the high and the low values.
   Limits are based on your institution's policy guidelines. Your selection depends on the characteristics of the current ratio.
9. Select Customize Formula to define a formula for the ratio on the Customize Formula page.
   1. Select Data or Functions for the Type.
   2. Enter the Formula.
      Use the Category or Function drop-down list to show more formula options.
   3. Select Results to review the formula results.
   4. Select Apply.
10. Select Save.