Summary
MindBridge's ratio builder is a robust tool that allows you to create your own financial ratios. Learn about the ratio builder and the important fields used in it.
Go to the Ratios tab
- Select the logo in the MindBridge sidebar.
You will go to the Organizations page. - Select View in line with the desired organization, or click anywhere in the organization row.
You will go to the Engagements page. - Select View in line with the desired engagement, or click anywhere in the engagement row.
You will go to the Data page. - Select View Analysis in line with the desired analysis.
You will go to the Analyze page. - Select the Ratios tab.
Tip: If you are already in an analysis, simply use the sidebar ( ) to open the Analyze menu (
), then select the name of the analysis you want to see and go to the Ratios tab.
Fields
When building a ratio, fields contain a term and an operator.
- Term: A quantifiable element in your ratio.
- Operator: The mathematical expression to be performed on the element (the only field that does not contain an operator is the first field of a row).
Example
In the image below:
- This field contains a term.
- This field contains a term and an operator.
The first term is being multiplied by 365, then divided by a third term: Days in the YTD period.
Account modifiers
When adding an account to a ratio you can select a modifier to change the values of the account. The following modifiers are available:
- Average Daily Balance: The average daily ending balance of the account throughout the period. This is calculated as (starting balance for the period + ending balance for the period) / 2.
- *Ending Balance: The balance of the account at the end of the period.
- Credit Amount: The sum of all credit entries to the account within the period.
- Debit Amount: The sum of all debit entries to the account within the period.
- Activity: The net activity (debits minus credits) within the period.
- Opening Balance: The balance of the account at the start of the period.
- Cumulative Year-to-Date Activity: The sum of all activity in the account (net debits minus credits) from the start of the analysis period to the end of the reporting period.
Add fields
- Select Add in the respective row.
- Choose the term you'd like to add to the row.
Add a new field between existing fields
- Open the more actions menu (
) beside the existing field to open a menu.
- Select Add new field left or Add new field right depending on where you want the new field to be created.
Replace and delete fields
Some complex ratios require a multitude of fields in each row. Replacing or deleting fields allows you to quickly and easily make adjustments.
- Open the more actions menu (
) beside the existing field to open a menu.
- Select Replace current field or Delete current field.
- You can also delete the entire row be selecting the delete icon (
) to the right of the row.
Define or change an operator
- Select the operator symbol to open a menu.
- Select the operator you want to use in the ratio:
- * (multiplication)
- / (division)
- + (addition)
- - (subtraction)
Bracket groups
To add a bracket group to your row:
- Select Add to open the menu.
- Select Bracket Group.
- Adjust the term and operator, and/or add more terms within the bracket group.
Anything else on your mind? Chat with us or submit a request for further assistance.