Add a Schedule for a Security in Issue Viewer

You can use the Add, Change, Delete, and List Schedule panels to maintain schedule information for a security. The system allows you to manually add and change a call, put, sink, custom sink, pre-refund, coupon/reset, and PIK receivable mark to market schedule. It uses this information during the earnings process to calculate a yield for the security. You can also add ex interest schedules to process accruals on the ex-date of a bond.

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 schedules when you use Eagle Accounting, but continues to provide access to Issue Viewer while existing clients transition to RDC. For more information, see Manage Schedules.

Add Schedules

In the Add Schedule panel, you can create a schedule for a security. 

To add a schedule:

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

  2. Open Schedules, and then select Add Schedule.
    You see the Add Schedule panel.
    NOTE: If you are adding a swap reset schedule, you can either use this panel to enter one date at a time, or you can select the Generate Swap Reset Schedule panel to project the full schedule.

  3. Complete the options on the Add Schedule panel.

  4. Click Submit.

Add Schedule Panel Options

The following are the options in the Add Schedule panel.

Option

Tag

Description

Option

Tag

Description

Lookup Security

 

 

Source Name

1102

Specifies the source name.

Asset ID Type

1432

Specifies the cross reference or primary asset identifier type for the security, such as CUSIP, ISIN, and SEDOL.

Asset ID

14

Specifies the identification number of the cross reference or primary asset ID for the security.

Issue Name

961

Specifies the name of the security.

Processing Security Type

3931

Specifies the processing security type.

Maturity Date

38

Specifies the date the final principal payment is due on the security.

Issue Date

68

Displays the date the security was issued.

Call Flag

1182

Displays the call flag value that was entered for the security. This value must be set to Yes to add a call schedule.

Put Flag

1546

Displays the put flag value that was entered for the security. This value must be set to Yes to add a put schedule.

Sinking Flag

1780

Displays the sinking flag value that was entered for the security. This value must be set to Yes to add a sink schedule or a custom sink schedule.

Refund Indicator

3132

Displays the pre-refund indicator value that was entered for the security. This value must be set to Yes to add a refund schedule.

Schedule Information

 

 

Schedule Type

1250

Specifies the type of schedule you are adding. Options include:

  • Call. Identifies a call schedule.

  • Put. Identifies a put schedule.

  • Sink. Identifies a sink schedule.

  • Refund. Identifies a pre-refunded security, mandatory put, and entire issue call.

  • Coupon/Reset. Identifies a coupon and swap reset schedule. For swap reset schedules, this is the date that you plan to run the global reset process.

  • PIK Receivable Mark to Market. Identifies the PIK (payment in kind bond) is paying in shares for a given coupon period.

  • Ex Interest Schedule. Identifies an ex interest processing schedule for use by entities eligible to use ex interest processing to process accruals on the ex-date of a bond. 

  • Custom Sink. Identifies a custom sink schedule.

Effective Date

1109

Specifies the effective date of the transaction.

End Date

73

Specifies the end date of the specific schedule type. The field appears if you add a schedule for a coupon/reset schedule or a schedule for a PIK receivable mark to market.

For a coupon/reset schedule, the End Date is the reset/payment date, or the contractual day when the payment is due, not including delay days, for the selected total return swap leg. If you change the end date for a schedule entry, you must also change the following entry's effective date.

Price/Rate

1249

Specifies the price/rate. The field appears if you add a schedule for a call, put, refund, coupon/reset.

Schedule Amount

1669

Specifies the amount for the schedule. The field appears if you add a schedule for a sink, PIK receivable mark to market, or custom sink. For a sink schedule, the Schedule Amount values must add up to 1.0, or 100%.

For a custom sink schedule, the Schedule Amount values also must add up to 1.0, or 100%. However, if you set the Bypass Sink Check option to Yes for a custom sink schedule, the system does not require the Schedule Amount values or payments for the custom sink schedule to add up to 1.0, or 100%.

For a PIK receivable mark to market schedule, a nonzero PIKMTM schedule amount is required to post URGL. When you enter the schedule for a coupon period, you can enter the amount as the coupon rate / frequency (that is, .05 / 2 = .025).

Schedule Subtype

3678

Indicates the type of refund schedule. The field appears if you add a schedule type of Refund. Options include:

  • Entire Issue Call

  • Mandatory Put

  • Pre-Refunded

Announcement Date

1247

Identifies the announcement date for the refund schedule. The field appears if you add a schedule type of Refund. If you define an amortization rule with Recognize Prerefunded (tag 3860) set to Recognize Pre-refunded Date using Announcement Date, Eagle Accounting uses this date as the pre-refunding announcement date when it calculates amortization yield.

Corporate Action Status

54

Indicates the status of the schedule. The field appears if you add a schedule for a sink or custom sink. Options include:

  • Incomplete

  • Pending

  • Released

Bypass Sink Check

17479

Indicates whether the system bypasses the sink check, and ignores the restriction that requires the custom sink schedule entries to have Schedule Amount values for payments that total to a value of 1.0, or 100%. Schedule amounts for sink schedules must always total to a value of 1.0, or 100%. Options include:

  • Yes. The system bypasses the sink check. The system does not require the custom sink schedule entries to total to a value of 1.0, or 100%. 

  • Null. Default. The system does not bypass the sink check. The system requires the custom sink schedule entries to total to a value of 1.0, or 100%. 

Valuation Date

16409

Specifies the date that the system can select and use the underlying price in the calculation of return for the selected total return swap's equity/return leg. The field appears if you add a coupon/reset schedule for a swap leg with a processing security type (PST) of Swap Leg Total Rate Return on Equity (SWLXEQ).

Fixing Date

16410

Specifies the date that the system can select and use the interest rate, that is, the floating rate, in the calculation of return for the selected total return swap's finance leg. The field appears if you add a coupon/reset schedule for a swap leg with a processing security type (PST) of Swap Leg Interest Accrual (SWLEAC).

Cash Payment Date

16411

Specifies the expected date of the cash payment for the selected total return swap leg. The system calculates the cash payment date by adding any applicable delay days to the payment date, or End Date. The field appears if you add a coupon/reset schedule.

Reset Date

16408

Specifies the date on which the system can update the notional value/price/interest rate based on change in market condition for the selected total return swap leg. If you select a swap leg with a processing security type (PST) of Swap Leg Total Rate Return on Equity (SWLXEQ), the End Date and the Reset Date must have the same date. The field appears if you add a coupon/reset schedule.

Ex Interest Date

3669

Specifies the date that each coupon period begins to trade ex-interest to use for the corresponding effective date in the Ex Interest schedule. If you do not set up an Ex Interest schedule for the security, the system uses the security-level Ex-Interest Days field to identify the ex interest date. 

Change Schedules

In the Change Schedule panel, you can edit the schedule for a security. Any time you change information in the Schedule table, Eagle Accounting recalculates the amortization yield the next time you run earnings, using the new values. If a value has changed in the Schedule table for a prior coupon period, you should Rollback and Replay earnings, or run a Retrospective Amortization event. If you change a schedule record that you already processed, then you need to rerun the global panel/query.

To change a schedule:

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

  2. Open Schedules, and then select Change Schedule.
    You see the Change Schedule panel.

  3. Complete the options on the Change Schedule panel to identify the schedules that you want to change.

  4. Click Submit.
    You see the schedules that met your criteria in the Show All tab.

  5. Select the row for each schedule you want to change so that a check mark appears in the Select column, and click Change Schedule Records.
    You see a row for each schedule you selected.

  6. Click the row for each schedule you want to update, and change the schedule information. For a: 
    - Call schedule, you can change the Price/Rate, Scrub Status, and Number of Exceptions field values.  
    - Put schedule, you can change the Price/Rate, Scrub Status, and Number of Exceptions field values.  
    - Sink schedule, you can change the Schedule Amount, Scrub Status, and Number of Exceptions field values. The Schedule Amount values for a sink schedule add up to 1. 
    - Refund schedule, you can change the Scrub Status, Number of Exceptions, Schedule Subtype, Announcement Date, and Business Date field values. 
    - Coupon/reset schedule, you can change the Effective Date, End Date, Scrub Status, Number of Exceptions, Valuation Date, Fixing Date, Cash Payment Date, and Reset Date field values. If you change the end date for an entry, you must also change the following entry's effective date.
    - PIK mark to market receivable schedule, you can change the End Date, Schedule Amount, Scrub Status, and Number of Exceptions field values. 
    - Ex Interest Schedule. you can change the Schedule Amount, Scrub Status, Number of Exceptions, and Ex Interest Date field values.
    - Custom Sink schedule, you can change the Schedule Amount, Scrub Status, Number of Exceptions, and the Bypass Sink Check values. 

  7. Click Submit.