The Amortization Schedule report allows you to report amortization on debt securities and displays projected principal and gains/losses. The Amortization Schedule report displays and projects the amortization of discount or premium for debt securities, including mortgaged backed and asset backed securities, as well as provides amortization yield. It incorporates the elements needed to project a security’s future cash flows, such as principal payments and yields, when generating the amortization schedule. You can run the report at a security, position, and fund level. The report can also include pending transactions.
To create the Amortization Schedule report:
- In Accounting Center, in the left navigation pane, click Reports > Investment Accounting Reports > Income > Amortization Schedule Report.
You see the Amortization Schedule Report panel. - Complete the options on the Amortization Schedule Report panel.
- Under Result Options, click Advanced Report or Grid Report for the report view you want.
- Click Submit.
The report results appear on your desktop for the view selected.
Amortization Schedule Report Panel Options
A definition of the options on the Amortization Schedule Report panel follows.
| Option | Description |
|---|---|
| Entity Details | |
| Calculate Based On | Allows you to show/hide additional query filters. The system displays additional fields depending on your selection. Options include:
|
| 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. |
| Base Currency | Displays the base currency of the entity. |
| Primary Amortization Rule | Displays the identifier of the amortization/accretion rule for the primary accounting basis that the system uses to process earnings. |
| Primary Amortization/Accretion Rule | Displays the amortization/accretion rule for the primary accounting basis that the system uses to process earnings. |
| Run Report Based On | Determines whether the report reflects the original or current holding amounts. Options include:
|
| View Historical Data | Determines whether the results include historical amortization projections. When you project from the current date, you can include historical values that occurred that occurred from settlement date. This field appears if you set the Run Report Based On field to a value of Current Holding Amounts. Options include Yes and No. |
| Amort Start Date | Specifies the beginning date for the historical amortization projection data to include in the report results. This field appears if you set the View Historical Data field to a value of Yes. |
| Hypothetical Mode | Indicates whether you want to calculate hypothetical retrospective amortization for pending transactions, enabling you to calculate retrospective amortization for securities not held by the entity. This field appears if you set the Calculate On field to a value of One Entity - One Security. Options include:
|
| Third Party Cash Flow Status | Indicates whether to generate amortization schedule data based on third-party cash flows with a released or pending status. This field appears if you set the Calculate On field to a value of One Entity - One Security. Options include:
|
| Time Series Release Status | Indicates whether to generate amortization schedule data based on prepayment time series information with a released or pending status. Options include:
|
| Show Cashflows | Indicates whether to show the cash flow projection used to calculate the retrospective amortization yield and values. Options include No (Default) and Yes. |
| Alternative Amort Rule Projection | Determines whether the report uses an amortization rule that differs from the entity's primary amortization/accretion rule. Options include Yes and No. |
| Alternative Amort Accr Rule | Identifies the amortization rule that the report uses in place of the entity's primary amortization/accretion rule. This field appears if you set the Alternative Amort Rule Projection field to a value of Yes. |
| Issue Details | |
| 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. |
| Ticker | Specifies the trade ticker 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. |
| Pool Number | Specifies the pool number of the security. This field appears if you set the Calculate Based On field to a value for one security. |
| Sub Security Type | Displays the sub security type of the security. This field appears if you set the Calculate Based On field to a value for one security. |
| Issue Description | Displays the description of the security. This field appears if you set the Calculate Based On field to a value for one security. |
| Security Alias | 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. |
| Trade Details | |
| Position or Lot Level | Specifies the level of the holdings. This field appears if you set the Calculate On field to a value of One Entity - One Security. While you can run this report for entities that use an average or identified cost method, you cannot view this report at the lot level for average cost positions. Options include:
|
| Open Event ID | Specifies the open event ID for the open lot. |
| Original Quantity | Displays the original quantity for the open lot. |
| Purchase Price | Displays the purchase price for the open lot. |
| Original Cost Local | Displays the total cost of the executed trade. |
| Currency Quantity | Displays the current quantity for the open lot. |
| Current Cost Local | Displays the current identified cost basis in local currency. |
| Adjusted OID Price | Displays the adjusted OID price. |
| Amortization Method | Displays the amortization/accretion method for the open lot. |
| Post Date | Displays the post date of the trade. |
| Trade Date | Displays the effective date of the trade. |
| Accounting Date | Displays the date the trade is reported and has an effect on the entity's holdings and cash balances. |
| Settlement Date | Displays the date the trade is settled. |
| Purchase Yield | Displays the purchase yield for the open lot. |
| Select Pending Trade | Specifies the event ID of the pending transaction for which you are calculating retrospective amortization. If you track pending transactions, a pending transaction requires evaluation before you release it to the STAR accounting engine for processing. The lookup displays the event ID/trade ticket number/units/event type for pending transactions associated with the selected security. This field appears if you set the Hypothetical Mode field to a value of Yes. |
| Pending Trade ID | Specifies the unique identifier of the pending transaction for which you are calculating retrospective amortization. This field appears if you set the Hypothetical Mode field to a value of Yes. |
| Default Values | |
| Partition | Displays the entity partition code. This field appears if you set the Calculate Based On field for an entity list or all entities. |
Add Comment