End User Guide > The Focus > Profitability Analysis Presentation > Trends |
The Trends page provides an overview of the data included in Summary Stats analytic on the next two pages. This data includes:
The Institutional View page contains four graphs that illustrate an institution's trends over the past five quarters for the following areas:
Additionally a summary compares the current and previous quarters' trends to the right of the graphs.
These graphs display quarterly averages for each focus area, thereby allowing institutions to identify trends by viewing their average quarterly performance.
The summary displays comparative data that highlights the differences between the current quarter and the previous quarter. Within this summary:
![]() |
The formula to calculate percent change is (Current Qtr - Previous Qtr) / Current Qtr |
Note Box | ![]() |
![]() |
Negative values are indicated in parenthesis |
The Customer/Members Trend graph illustrates the quarterly-average number of customers/members open at a financial institution. Within this graph, the x-axis indicates the average number of customers/members over the last five quarters. The y-axis displays the average customer/member volume.
The Average Account Trend graph illustrates the quarterly-average number of deposit and loan accounts open at a financial institution. Within this graph, the x-axis indicates the average number of accounts over the last five quarters. The y-axis displays the average account volume.
The Period Average Balance Trend graph illustrates the quarterly average balance for deposit and loan products at a financial institution. Within this graph, the x-axis indicates the average number of deposits and loans open for each of the last five quarters. The y-axis displays the amount.
The Net Contribution Trend graph illustrates the quarterly net contribution average for deposit and loan products at a financial institution. Within this graph, the x-axis indicates the net contribution for each of the last five quarters. The y-axis displays the amount.
The Net Contribution Trend: Deposits and Loan page delves deeper into the net contribution data displayed in the Net Contribution Trend graph on the previous page. This graph illustrates the quarterly net contribution average for deposit and loan products at a financial institution. Within this graph, the x-axis indicates the net contribution for each of the last five quarters. The y-axis displays the amount.
The Net Contribution Trend data table illustrates the following summary:
Column | Description | Calculation |
Year | Indicates the year in which the customer data pertains to. | N/A |
Qtr | Indicates the quarter which the customer data pertains to. | N/A |
Deposits | Indicates the average deposit net contribution for the quarter. | SUM(DepNETCONT) for each period |
% Growth | Indicates the percent difference between the current and previous quarter's net contribution. | (Current Qtr Net Contribution - Prior Qtr Net Contribution) / Prior Qtr Net Contribution |
Loans | Indicates the average loan net contribution for the quarter. | SUM(LoanNETCONT) for each period |
% Growth | Indicates the percent difference between the current and previous quarter's net contribution. | (Current Qtr Net Contribution - Prior Qtr Net Contribution) / Prior Qtr Net Contribution |
Total | Indicates the total deposit and loan net contribution for the quarter. | LoanNetCont + DepNetCont |