SQL Asset Performance Analysis

Asset Performance Analysis is a performance report that lists all assets held within a specific date range. Information on the report includes asset weighting, symbol/cusip, beginning and ending period value, inflows and outflows, unrealized and realized gains/loss, income/expenses and total gain/loss as expressed in dollars and as a percentage.

SQL Benchmark Comparison

Benchmark Comparison is a performance report that is run for either groups or clients. Each account within a group or client appears with a one line performance summarization for multiple time periods with an index comparison that is assigned at the account level. Information on the report includes account weighting as compared to the total of all accounts within the group/client, current market value, performance start date and 4 periods of returns for the portfolio and indexes.

SQL Category Performance Summary

Category Performance Summary is a performance report that groups assets together into major categories such as security type and asset class to provide activity and performance details for a specified date range. Information on the report includes category weighting, beginning and ending values, flows, gains/loss, income/expense and total gain/loss in terms of dollars and percentage.

SQL Executive Summary

Executive Summary is a performance report that provides an overview of account performance, asset allocation and portfolio vs. index performance comparisons on a single page report. The performance section provides detailing on 3 date ranges: from performance start date, last year and current year to date. The current asset allocation by major category is displayed in a 3-D pie chart and a line chart displays portfolio growth over time vs. relative indexes.

SQL Market Value vs. Net Invested

Market Value vs. Net Invested is a performance report that graphically represents account growth over time vs. net amount invested for a specified date range. Information on the report includes net flows, cumulative net invested, market value and cumulative gain/loss.

SQL Multi-Managed Performance Comparison

Multi-Managed Performance Comparison is a performance report that provides bottom line summary of individual account performance for multiple accounts within a specific date range. Information on the report includes account weight as compared to the total grouping of accounts, beginning and ending account values, flows (cash and securities), gains/loss, income/expense and total gains/loss both in dollars and percent change.

SQL Performance Summary

Performance Summary is a performance report that report lists all accounts with actual and annualized TWR returns within a specified date range. Information on the report includes beginning and ending market values, net flows (cash and securities) and both actual and annualized TWR.

SQL Return Detail

Return Detail is a performance report that summarizes activity and performance with index comparisons for (up to) eight time periods. Information on the report includes beginning and ending values, net flows, appreciation, income, expenses, investment gain and both actual and annualized TWR.

SQL Returns vs. Benchmarks

Returns vs. Benchmarks is a performance report that graphically represents portfolio returns vs. index returns for a specified date range. Information on the report includes a dual representation of portfolio returns in terms of growth based on an initial investment of $100 and on a percentage basis, index returns based on growth of $100 and both cumulative and annualized returns for the portfolio and indexes.