In the Add Cash Flow screen, you can manually add a cash flow detail record.
| Info |
|---|
| Note: Only a cash flow set with a release status of pending approval or not released can have a cash flow record added. |
To add a third party cash flow detail record:
...
In the Reference Desk workspace
...
, in the left navigation pane, click Third Party Cash Flow
...
.
You see the Third Party Cash Flow workspace.Click the View Data By drop-down and then select Cash Flows and their Exceptions.
Complete the required search criteria and click the Search button.
...
From the list that displays, double-click the cash flow you wish to view.
You see the Edit Security window with the Third Party Cash Flows tab as the default.Click
...
a row in the Cash Flow Details section of the tab to activate it and then select Add Cash Flow from the right-click menu.
You see the Add Cash Flow Value screen.Complete the options on the Add Cash Flow Value screen.
Click Add.
The record is saved to the database.
Add Cash Flow Value Options
The following are the options in the Add Cash Flow Details panel.
| Info |
|---|
| Note, options Options may vary according to your selections. |
Option | Description |
|---|---|
Original Balance | Specifies the current face at the time of issuance. This value is used strictly for reporting. For TRAINS with a processing security type of DBIBTR, this value is optional, and is always equal to 100. |
Current Balance | Identifies the "current" current face balance. |
The Eagle product uses the Current Balance of the first effective flow for every effective date set to convert the dollar amount of each flow to a percentage format (that is, Flow / Current Balance * 100). When you enter multiple rows in the pane at the bottom of the |
window, the Current Balance |
should display 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 | Specifies the current pass thru rate that was used to calculate the interest cash flow. This field is used for reporting. |
Cash Flow Type | 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:
|
Speed Type | Specifies the speed type used to calculate the principal and interest cash flows. Options include:
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 | Specifies the prepayment speed used to calculate the future cash flow. This field is used for reporting. |
Payment Date | The date on which the security is expected to repay all outstanding principal and stop earning interest. |
Principal Flow | 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. For TRAINS, this field is stored as a percentage. For example, a value of .15 represents 15%. |
Interest Flow | 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. For TRAINS, this field is stored as a percentage. For example, a value of .15 represents 15%. |
Remaining Balance | 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. |
Total Principal and Interest | Displays the total principal and interest cash flow for the cash flows date. The Total and Principal field is used for reporting purposes. |
Write Down / Write Up | Specifies the write down or write up in the asset currency for each flow date. This field is used in reporting. A negative value represent a write up. |
Row ID | Specifies the identification number of the row. |
Original Flow Date | Specifies the effective date of the cash flow. |
Cash Flow Status | Indicates the cash flow status. Options include: Pending, Released, Not Processed. |