Loading Data
You can leverage Eagle’s enterprise level workflow and operations tools to load data into Eagle’s data warehouse. You can load general financial information as well as performance related data, such as NAVs and distribution history, tax rates used to calculate SEC after-tax returns, and index data.
Retail Fund Performance provides specialized tools and reports to help you audit and maintain NAV and distribution data after you initially load it and on an ongoing basis. You can use the NAV report and the Net Asset Value Maintenance option to produce reports on uploaded NAV and distribution data, conduct detailed audits of NAV, distribution, and related data that you uploaded, and change the NAV and distribution data. You can review and maintain NAV data at different points in your overall workflow, depending on your preference.
Configuring the Performance Calculation Report
The Performance Calculation report is used to calculate and commit single-period NAV-based returns, which measure rates of return over a single holding period, such as a day, month, or quarter. Using the Performance Calculation report to commit returns is optional for Retail Fund Performance.
You can use the Dynamic NAV Returns report profile to calculate and commit NAV-based returns to the PERFORM database. Committing returns for retail funds lets you save that information for further analysis and reporting, and lets you take advantage of certain Eagle Performance features that rely on information stored in the PERFORM database. For example, if you plan to use the Performance Analysis report to calculate risk statistics for retail funds, that report requires single-period returns stored in the PERFORM database as the basis for calculating risk statistics.
If you plan to use the Performance Query Tool to analyze retail fund activity, the Performance Query Tool relies upon data stored in the PERFORM database to provide time series as well as interactive analysis of data. And if you use the GIPS Composite Management component to manage activity of composites that include retail fund data, Eagle requires single-period NAV-based returns stored in the PERFORM database as the basis for calculating composite level returns.
Otherwise, you can use Performance Analysis report to calculate both single-period and multi-period NAV-based returns, based on NAV holdings data. However, this approach does not allow you to take advantage of features that rely on information stored in the PERFORM database, such as risk statistics and the Performance Query Tool.
Configuring the Performance Analysis Report
The Performance Analysis report is used to calculate single-period and multi-period NAV-based returns. The Performance Analysis report uses single-period NAV-based retail fund returns stored in the PERFORM database to calculate multi-period returns or uses NAV data stored in the HOLDING database to calculate both single-period and multi-period NAV-based returns.
You can use the Performance Analysis report to calculate multi-period returns for retail funds using SEC calculation methodology. When you run the report, Eagle Performance can compound single-period returns into cumulative returns for longer time periods, and derive risk measures and risk-adjusted returns from single-period returns. After you generate the Performance Analysis report, you can use it to drill down into the fund to the security level to analyze prices, analytics, and other data.
Eagle recommends storing multi-period returns in Eagle’s Data Mart. See the Data Mart User Guide for detailed information.
Publishing Retail Fund Performance Reports
You can use Eagle’s analysis and reporting tools to communicate retail fund performance information to internal and external audiences. Eagle Performance includes standard retail fund reports as part of the Performance Toolkit, and lets you create customized reports for on-line drill down analysis. You can create OLAP drill down reports, presentation-quality Advanced Reports, and/or Portal views that use information stored in Eagle’s data warehouse or optionally, in Data Mart.
Many of Eagle’s Retail Fund Performance clients provide reports generated by Retail Fund Performance to outside auditors. Those auditors can review return information and provide feedback to your organization. Eagle provides the Mutual Fund Performance Audit report, a standard report that is part of the Performance Toolkit, for this purpose. The report displays the time series events that led to the calculated return as a series of data points. You can customize this report to meet your needs.
You can also use the Performance Query Tool to perform ad-hoc queries and report on multi-period performance. The Performance Query Tool additionally provides specialized time series and rolling period functionality that is not present in Performance Analysis reports.
See the PACE Reporting Reference Guide or OLAP Support for detailed information about OLAP reports. See the PACE Advanced Reporting User Guide Guide for detailed information on Advanced Reports. For more information on the Eagle Portal and Portal Administration, see the Eagle Portal V17.
Using the Performance Toolkit
Use the Performance Toolkit 2.0.
Retail Fund Toolkit provides a collection of components to enable a rapid implementation of retail performance reporting. Preconfigured metadata supports retail performance calculations and updated generic interfaces assist in the loading of retail fund characteristics and fund accounting NAV data.
The Toolkit supports Dynamic Return Calculations, including numerous return effects, convertible class returns, synthetic returns, and gross returns based on expense ratios. It also includes Dynamic NAV Returns (commit) reports to support calculation and storage of various returns to streamline daily, monthly, and quarterly workflows. Additional reports are provided for convertible returns, synthetic returns, gross returns based on annual expense ratios, and a report that includes NAV based benchmark relative fields. There is also a report that can decompose a series of rolling one year returns by displaying certain underlying calculated values.