Using Custom Ratio Accounts

Strategic Finance automatically calculates 34 ratios. You can also use 10 Custom Ratio accounts (6400.00.000 through 6445.00.000) for customized calculations. Use Custom Ratio accounts to enter formulas that is used to calculate your own ratios. Custom Ratio accounts can be subaccounted 999 times to create additional Custom Ratios.

The Financial Ratios report displays all ratios calculated in an analysis—Custom Ratio accounts appear at the bottom. This enables you to distinguish between ratios defined by Strategic Finance and your individual ratios.

Formulas you can use to create Custom Ratios are similar to the Freeform Formula forecast method. You can use constant numbers or values from other accounts in Custom Ratio formulas. You can also use different functions in the formula.

  To use Custom Ratio accounts:

  1. From any Strategic Finance view, select Accounts, then User Defined Accounts.

  2. In User Defined Account, select Ratio.

  3. Select a ratio account from the drop-down list.

    To add ratio accounts or change descriptions, access the Accounts view spreadsheet or Subaccount Options dialog.

  4. In Value is, enter a ratio.

    Custom Ratios are calculated by a formula in all periods. Click Build.

  5. Specify the Calculate aggregate period value as option:

    • Last interim period value (i.e., Balance Sheet)

    • Sum of interim periods (i.e., Income Statement)

    • Weighted average based on the financial account you select from the account drop-down list. (i.e., discount rate)

    • None applies the formula in aggregate periods.

  6. Select the Output Type:

    • Currency

    • Items

    • Percent

    • Ratio


      Select Calculated by formula, and all Output Types are available. Select Input in history, and Output Types are limited to Currency and Items.

  7. Optional: If the Output Type is Currency or Items, the output value of the account can be shown in a denomination other than the Default Currency Units.

    You override the default setting by selecting an Output Units option: Ones, Thousands, Millions, Billions, or Trillions.

  8. Click OK.