Historical Average Allocation Ratios Report

The Historical Average Allocation Ratios report displays proportional ratios by share class for Fair Value Settled Shares and Settled Shares calculations, using the ESTAR_NAV table of the ESTAR database to derive:

Calculation of Relative Net Assets at Market Value – the change in SHARES_OUTSTANDING multiplied by the prior day's NAV_AMOUNT_PER_SHARE, then added to the prior day's NET_ASSET_AMOUNT.
Calculation of Fair Value Settled Shares apportionments – the current day's SHARES_SETTLED amount multiplied by the prior day's NAV_AMOUNT_PER_SHARE.

Grid and advanced report views available for this report include:

Historic Allocation Ratios. This view displays allocation ratios by class, share class, and date.
Historic Allocation Ratios Average Calculations. This view displays allocation ratios averages by share class.
Transfer Agent (TA) Billing Allocation Average Ratios. This view displays billing allocation average ratios by share class.

To create the Historical Average Allocation Ratios report:

In Accounting Center, in the left navigation pane, click Reports > Fund Accounting Reports > Mutual Fund - Valuation > Historical Average Allocation Ratios Report.
You see the Historical Average Allocation Ratios Report panel.
Complete the options on the Historical Average Allocation Ratios Report panel.
Under Result Options, click Grid or Advanced Report for the report view you want.
Click Submit.
The report appears on your desktop for the view selected.

Historical Average Allocation Ratios Report Panel Options

A definition of the options on the Historical Average Allocation Ratios Report panel follows.

Option	Description

Option	Description
Search Criteria
Entity ID	Specifies a portfolio, sector portfolio, composite portfolio, or Master Fund by the entity ID of the entity.
Entity Name	Specifies a portfolio, sector portfolio, composite portfolio, or Master Fund by name of the entity.
Report Name	Specifies the type of report by name. Options include: Historical Allocation Ratios By Class. Default. If you select this option, the panel unhides the Advanced Report Options field for data entry. TA Billing Average Allocation Ratios. If you select this option, the panel unhides the Class Selection field for data entry.
Class Selection	Specifies the share class selection method for your report. Options include: Default. The system selects the default share classes for your report. All. Default. The system selects all share classes for your report. List. The system selects share classes listed in the List of Share Classes field for your report.
List of Share Classes	Specifies the list of share classes for your report. This field appears if you set the Class Selection field to List.
Report Period	Specifies the time period, date range, or particular date for your report. The time period may be entity specific or security specific, such as fiscal year. Options include: Daily Activity Date Range (Default) Fiscal Year to Date Life to Date Calendar Year to Date Inception to Date Month to Date
Report Start Date	Specifies the start date for your report results. The default is first day of the current month. To use this option, you must select Date Range as your report period.
Report End Date	Specifies the ending date for your report results. The default is today's date.
Selection Criteria
Advanced Report Options	Allows you to show/hide advanced report sort and format options. The default is No.
Sort by Class or Date	Allows you to sort report results by share class or effective date.
Shading	Specifies where to add shading to the report. Options include: None Every Other Line Every Three Lines Every Five Lines