7.1.7.2 Rate Calculation

The Trend Analysis Dashboard calculates portfolio rates as the Average Book Balance-weighted average of the underlying account-level rates. This calculation applies to Transfer Rate, Add-On Rate, and All-in Transfer Rate widgets.

Weighted Average Rate = Σ(Account-Level Rate × Average Book Balance) ÷ Σ(Average Book Balance)

Accounts with higher Average Book Balances contribute proportionately more to the portfolio rate. Balance weighting provides a more representative portfolio rate than a simple arithmetic average of account-level rates.

Figure 7-7 Review Trend Analysis rate widgets