Historic Allocation Ratios Report

Owned by Tom Fahey (Unlicensed)
Last updated: Oct 25, 2016 by Former user (Deleted)
2 min read

The Historic 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 Historic Allocation Ratios report:

  1. From the Accounting Center window, click Reporting in the left navigation.
  2. Double click Investment Accounting, Mutual Fund Reports, and Allocation Ratios.
    You see the Allocation Ratios panel.
  3. Complete the fields on the Allocation Ratios panel.
  4. Click Submit and then click Advanced Report or Classic Grid Report.
    The report appears on your desktop for the view selected.

Historic Allocation Ratios Panel Options

A definition of the options on the Allocation Ratios panel follows.

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 for data entry.
    –  TA Billing Average Allocation Ratios.
  • 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.