Manage Third Party Cash Flows in Issue Viewer

Third party cash flows, previously called vendor provided cash flows, are cash flows provided by vendors or third parties in the asset currency of the security that Eagle Accounting can utilize to generate amortization yields and cash flow projections. You can set up Amortization/Accretion Rules to use third party cash flows.

Accounting Center includes Issue Viewer, Eagle's legacy security master tool that allows you to perform a variety of security master related functions. Reference Data Center (RDC), which replaces Issue Viewer, along with other legacy data management tools, is Eagle's current and more powerful solution for centralizing and managing security reference data. Eagle recommends that you use RDC to set up and manage third party cash flows when you use Eagle Accounting, but continues to provide access to Issue Viewer while existing clients transition to RDC. For more information, see Manage Third Party Cash Flows.

Add a Third Party Cash Flow

In the Add Third Party Cash Flow panel, you can manually create third party cash flows.

To manually add a third party cash flow:

  1. In Accounting Center, in the left navigation pane, click Setup > Securities > Manage Securities > Issue Viewer.
    You see the Issue Viewer tool.

  2. In the left navigation, double click Third Party Cash Flow and Add Third Party Cash Flow.
    You see the Add Third Party Cash Flow panel.

  3. Complete the options on the Add Third Party Cash Flow panel.
    In order for Eagle Accounting to utilize the data in the Vendor Cash Flow table, the Security Alias, the Source Name, Cash Flow Type, and requested Speed Type in the Vendor Cash Flow table must match the Third Party Cash Flows Source Name, Cash Flow Type, and requested Speed Type for the entity's Amortization Rules table.

  4. If you want to add additional rows to the Add Third Party Cash Flow panel, click in the bottom half of the panel, right-click, and select Add Rows.

  5. Click Submit.

Change a Third Party Cash Flow

In the Change Third Party Cash Flow panel, you can manually edit third party cash flows. 

To manually change a third party cash flow:

  1. In Accounting Center, in the left navigation pane, click Setup > Securities > Manage Securities > Issue Viewer.
    You see the Issue Viewer tool.

  2. In the left navigation, double click Third Party Cash Flow and Change Third Party Cash Flow.
    You see the Change Third Party Cash Flow panel.

  3. Complete the options to identify the cash flow you want to change.
    You must specify the Asset ID at a minimum. You can additionally identify criteria such as the source name, pool number, cash flow type, requested speed, and begin/end effective dates.

  4. Click Submit.
    You see information for the cash flows that met your criteria in the Show All tab. 

  5. Select the row for each cash flow you want to change and click Change Third Party Cash Flow Record.
    You see a row for each cash flow you selected. Eagle Accounting brings all records returned from the query on the Show All tab to the third panel of the Change Third Party Cash Flow. The reason for this is that Eagle Accounting needs to pull the complete record of cash flows over, in order to ensure that the cash flow principal cash flow records sum up to the current face as of the effective date of the record.

  6. Update the record with the correct Principal Flow, Interest Flow, and Write Down/Write Up values.
    Note that the Effective Date, Source, Cash Flow Type, and Requested Speed Type values are part of the primary key and you cannot change them. If you need to change the Effective Date, Source, Cash Flow Type, and/or Requested Speed Type, you must delete the record and re-enter the data.

  7. Click Submit.

If you change a Third Party Cash Flow record for the current coupon period, Eagle Accounting recalculates the amortization yield the next time the system invokes the earnings process. If you change the Third Party Cash Flow record for a prior period, the earnings process needs to be rolled back to the effective date of the Third Party Cash Flow record change, and replayed forward to correctly reflect the positions earnings value.

Delete a Third Party Cash Flow

In the Delete Third Party Cash Flow panel, you can manually delete third party cash flows.

To manually delete a third party cash flow:

  1. In Accounting Center, in the left navigation pane, click Setup > Securities > Manage Securities > Issue Viewer.
    You see the Issue Viewer tool.

  2. In the left navigation, double click Third Party Cash Flow and Delete Third Party Cash Flow.
    You see the Delete Third Party Cash Flow panel.

  3. Complete the options to identify the cash flow you want to delete, and click Submit.
    You must identify the Asset ID at a minimum. You can additionally identify criteria such as the source name, pool number, cash flow type, requested speed, and begin/end effective dates. You see information for the cash flows that met your criteria in the Show All tab.

  4. Select the row for each cash flow you want to delete and click Delete Third Party Cash Flow Record.
    In the lower pane, you see a row for each cash flow record you selected. The fields describing the cash flow are locked, and are for information only. Eagle Accounting brings all records returned from the query on the first panel to the third panel of the Delete Third Party Cash Flow. The reason for this is that Eagle Accounting needs to pull the complete record of cash flows over, in order to ensure that the cash flow principal cash flow records sum up to the current face as of the effective date of the record.

  5. Click Submit to delete the selected cash flows.

If a Third Party Cash flow Record is changed for the current coupon period, Eagle Accounting recalculates the amortization yield the next time the system invokes the earnings process. If the Third Party Cash Flow record is changed for a prior period, the earnings process needs to be rolled back to the effective date of the Third Party Cash Flow record change, and replayed forward to correctly reflect the positions earnings value.

Third Party Cash Flow Panel Options

The following are the options in the Add Third Party Cash Flows panel. Note options may vary according to your selections.

Option

Tag

Description

Option

Tag

Description

Lookup Security

 

 

Source Name

1102

Specifies the source name for the cash flow. This value must match the Third Party Cash Flows Source Name (tag 1102) value in the amortization rule utilized by the entity's accounting basis in order for the Eagle Accounting's earnings process to utilize the cash flows in the Vendor Provided Cash Flow table. If the source on the amortization rule does not match the source in the Vendor Cash Flow table, Eagle Accounting does not utilize the cash flow in the earnings process..

Asset ID Type

1432

Specifies the primary asset identifier type for the security. The lookup shows the values for the iXREFTYPE code category. A value appears when you enter Asset ID or Issue Name.

Asset ID

14

Specifies the primary asset identifier for the security. The lookup shows all Primary Asset IDs with a processing security type eligible for variable rate processing. A value appears when you enter Issue Name and Asset ID Type.

Issue Name

961

Specifies the name of the security. When you select a value, you see the related Asset ID and Asset ID Type values.

Pool Number

1439

Specifies the pool number of the security. When you select a value, you see the related Asset ID and Asset ID Type values.

Issue Date

68

Specifies the original date of issue of the security.

Maturity Date

38

Displays the stated maturity date that the security is expected to repay all outstanding principal and stop earning interest.

Third Party Cash Flows

 

 

Effective Date

1109

Specifies the first date for which the cash flow is effective. The effective date should be the start of the coupon period and not include delay days.

Original Balance

11757

Specifies the current face at the time of issuance. This value is used strictly for reporting.

Current Balance

11758

Identifies the "current" current face balance. This field is used for reporting. When you enter multiple rows in the pane at the bottom of the panel, the Current Balance displays the remaining balance from the previous flow row.
For TRAINS, this value is equal to the Current Face divided by the Original Face, and is stored as a percentage. For example, a value of 74 represents 74%.

Effective Cash Flow Coupon

11759

Specifies the current pass thru rate that was used to calculate the interest cash flow. This field is used for reporting

Cash Flow Type

11760

Specifies the prepayment model used to create the cash flow. This value is provided by the third party/vendor. The Cash Flow Type is used as part of the key to determine which third party cash flow record the accounting basis's amortization rule should utilize when calculating an Amortization or Trade Yield. Options include:

  • ABS. Absolute Prepayment Speed. 

  • CPR. Constant Prepayment Rate. 

  • FINCAD. FinCad Generated Cash Flows. 

  • FMED. FFIEC Median.

  • MHP. Manufactured Housing Prepayment Curve. 

  • PSA. Public Securities Association Convention. 

  • TRAIN. Trains. If you add the cash flow for a TRAIN with a PST of DBIBTR, the system sets this value to TRAIN.

Requested Speed Type

11761

Specifies the speed type used to calculate the principal and interest cash flows. Options include:

  • 1 Month- 1 Month

  • 12 Month - 12 Month

  • 3 Month - 3 Month

  • 6 Month - 6 Month

  • ABS – ABS.

  • BMA Med +300 - BMA Med +300

  • BMA Med -300 - BMA Med -300

  • BMA Median - BMA Median

  • FFIEC Median - FFIEC Median

  • FMED +100 - FMED +100

  • FMED +200 - FMED +200

  • FMED +300 - FMED +300

  • FMED -100 - FMED -100

  •  FMED -200 - FMED -200

  • FMED -300 - FMED -300

  • NONE – None. If you add the cash flow for a TRAINS with a PST of DBIBTR, the system sets this value to NONE.

Requested Speed Value

11762

Specifies the prepayment speed used to calculate the future cash flow. This field is used for reporting.

Flow Date

11763

Specifies the effective date of the cash flow. This field should be a coupon date and not include delay days.

Principal Flow

11764

Specifies the principal cash flow in the asset currency for each flow date. This data is used in the calculation of amortizations, trade yield retrospective amortization, and cash flow projections. 

Interest Flow

11765

Specifies the interest cash flow for each flow date in the asset currency of the security. This data is used in the calculation of amortizations, trade yield retrospective amortization, and cash flow projections. 

Write Down / Write Up

16138

Specifies the write down or write up in the asset currency for each flow date. This field is used in reporting. A negative value represents a write up.

Total Principal and Interest

11766

Displays the total principal and interest cash flow for the cash flows date. The Total and Principal field is used for reporting purposes.

Remaining Balance

11767

Specifies the calculated remaining balance after the calculated principal cash flow. The value in the Remaining Balance field is calculated as the previous beginning balance minus the calculated principal balance minus the calculated write down/write up value. The last cash flow entry must have a Remaining Balance that is equal to 0.00. This field is used for reporting.

Third Party Cash Flow Status

11795

Specifies the status of the third party cash flow record in the Vendor Cash Flow table. Eagle Accounting only uses records with a status of Released. It does not use records with a Pending release status in the processing of amortization or cash flows. The Amortization Schedule report allows you to generate amortization schedule data based on third-party cash flows with a Released or Pending status. Options include:

  • Pending. Third party cash flow data is not used in the Earnings process, but is available for reporting. 

  • Released. Default. Third party cash flow data is available for use in the Earnings process and for reporting. 

  • Not Processed. Third party cash flow data is not used in the Earnings process, and is not available for reporting.

Â