Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

To create the Prepayment Analysis report:

  1. In Accounting Center, in the left navigation pane, click Reports > Investment Accounting Reports > Income > Prepayment Analysis Report.
    You see the Prepayment Analysis Report panel.

  2. Complete the options on the Prepayment Analysis Report panel.

  3. Under Result Options, click Advanced Report or Grid Report.

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

Prepayment Analysis Report Panel Options

A definition of the options on the Prepayment Analysis Report panel follows.

Option

Description

Required Parameters

Calculate Based On

Allows you to show/hide additional query filters. The system displays additional fields depending on your selection. Options include:

  • One Entity/One Security

  • One Entity/All Securities

  • Entity List/One Security

  • Entity List/All Securities

  • All Entities/One Security

Entity ID

Specifies the unique identifier of the entity. This field appears if you set the Calculate Based On field to a value for one entity.

Entity Name

Specifies the name of the entity. This field appears if you set the Calculate Based On field to a value for one entity.

Accounting Basis

Specifies the accounting basis for the entity.

Entity List Name

Specifies the name of the entity list. This field appears if you set the Calculate Based On field to a value for an entity list.

Entity List ID

Specifies the unique identifier of the entity list. This field appears if you set the Calculate Based On field to a value for an entity list.

Security Information

Issue Name

Specifies the name of the security. This field appears if you set the Calculate Based On field to a value for one security.

Primary Asset ID

Specifies the identification number of the primary asset ID type for the security. This field appears if you set the Calculate Based On field to a value for one security.

Asset ID

Displays the asset identifier of the selected security. This field appears if you set the Calculate Based On field to a value for one security.

Report View Options

View Report At

Specifies the level of the holdings. Options include:

  • Position Level (Default)

  • Lot level

Percentage Change

Specifies the percentage of local or base amortized cost difference to include in the report results. For example, displays all records with a 5 percent difference in amortized cost.

Amount Change

Specifies the amount of the local or base amortized cost difference to include in the report results. For example, displays all records with a 50,000 difference in amortized cost. If you specify both a Percentage Change value and an Amount Change value, the report displays all results that either have the amount difference or percent difference in amortized cost.

View Cashflows

Indicates whether to view the cash flow used to calculate the retrospective yield in the report results. Options include No (Default) and Yes.

Source Name

Specifies the source of the data.

Other Details

Earned Thru Date

Specifies the effective date of the earnings/income data.

Partition

Displays the entity partition code. This field appears if you set the Calculate Based On field for an entity list or all entities.