How to Calculate Basis Point (bps) Change in a Dynamic Report

To calculate basis point (bps) changes in a Dynamic Report, do the following:

1. Navigate to Reports, and open the Dynamic Report where you want to calculate the basis point change.

2. Click Formula, then select Insert Row/Column to add three new custom formula columns.

3. In the Insert Formula pane, enter a name for each column header and set the Function to Custom Formula.

4. Use the three columns for the following purposes:

   • Rate 1 Column: Convert the original rate to a percentage value (if it is not already in decimal format).

   • Rate 2 Column: Convert the new or updated rate to a percentage value.

   • Basis Point Change Column: Calculate the difference between the two rates in basis points.

5. In the report, activate the cell in each column and enter the corresponding formula:

   • Rate 1 Column: =CellNo/100

   • Rate 2 Column: =CellNo/100

   • Base Point Change: =Sum((Rate2CellNo - Rate1CellNo) * 10000)

6. Click Save to apply your changes.

Note:

• 1 basis point (bps) is 0.01% = 0.0001 in decimal form.

• If the value is stored as a raw percentage (e.g., 5 for 5%), divide it by 100 to convert it to decimal (0.05) before calculating basis point changes.

• If the value is already in decimal format (e.g., 0.045 for 4.5%), use it directly in the basis point formula. It is not required to convert the value using division by 100.

• If the value is an absolute number (e.g., 45356666 as a revenue figure), you must first calculate a rate (e.g., Revenue / Total Assets) before computing basis points.

• Always confirm whether the source values represent rates or amounts before applying basis point logic to avoid incorrect calculations.