Allocation Ratios Report

Owned by Copy Page Tree (Unlicensed)
Last updated: Oct 13, 2023 by Nancy Cohn (Deactivated)
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. In Accounting Center, in the left navigation pane, click Reports > Fund Accounting Reports > Mutual Fund - Valuation > Allocation Ratios Report. 
    You see the Allocation Ratios Report panel.

  2. Complete the options on the Allocation Ratios Report panel.

  3. Under Result Options, click Grid or Advanced Report for the report view you want.

  4. Click Submit.
    The report appears on your desktop for the view selected.

Allocation Ratios Report Panel Options

A definition of the options on the 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 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.

Â