Versions Compared

Key

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

Eagle Accounting recognizes a security as a sinking fund bond when you set the security's Sink Flag (tag 1780) option to Yes. Also, when When the security master record has the Sink Flag field set to Yes, the system expects you to populate a sinking fund schedule, both in the Schedule table and in the Corporate Action table.

AlternativelyHowever, if you expect actual sinking fund payments to change from expected payments, and plan to use custom sinking fund schedules rather than sinking fund schedules, you must also set the security's Sink Flag (tag 1780) option to Yes. The system then allows you to define a custom sinking fund schedule in the Schedule table and the system, in turn, defines a corresponding sinking fund schedule in the Corporate Action table.


Panel
borderColor#9F9F9F
titleColor#F7F9F9
titleBGColor#B48436
borderStyledashed
titleContent on this page:

Table of Contents
maxLevel2
indent2 px


Set Up Securities

When you establish the SMF, the following options apply to sinking fund securities that use sinking fund schedules or custom sinking fund schedules. For general information on using Reference Data Center to set up securities, see Create and Delete Securities. Otherwise, if you use Issue Viewer to set up securities, see Set Up Securities in Issue Viewer.

You can use the following options when you set up sinking fund securities for use with Eagle Accounting. 

Option

Tag

Description

Sink Flag1780

Determines whether the security is eligible for sinking fund payments. Options include:

  • Yes. The security is eligible for sinking fund payments. You need to add sink information for the security so that the system can calculate the yield for the security during the earnings process. You must set this field to Yes to add a sink schedule corporate action or a custom sink corporate action.
  • No. The security is not eligible for sinking fund payments.

WRITERS NOTE: revised

Pro Rata Sink11304

Indicates whether the security is a Pro Rata sinking fund. The system uses this option in conjunction with the Sinking Fund Payment Redemptions Gain/Loss Flag field in the accounting basis to determine if the entity/accounting basis and security combination should use the Capitalization method or record cost reduction for sinking fund payments as Gain/Loss or as Accelerated Amortization. Options include Yes and No. For more information, see Set Up Entities for Sinking Funds.

WRITERS NOTE: should we suggest identifying the security as a Private Placement (tag 1421). 

Add a

Understand Custom Sinking Fund

Schedule

Schedules

WRITESR WRITERS NOTE: new section 

When you define a custom sinking fund schedule in the Schedule table, the schedule is based on the percentage sunk. For example, if the Original Issue Amount was $1,000,000, and the Sinking Fund Percentage is .1%, the amount posted is $1,000. For a typical sinking fund schedule, the entire Sinking Fund schedule must have Schedule Amount values that add up to 1.00 (100%). For a custom sinking fund schedule, you can set up the schedule to avoid the requirement that Schedule Amount values total to 1.00. 

For example, say you create a custom sink schedule for a security such as private placement where you do not know the full schedule at the time you create the schedule. While you initially expect four equal payments of 25% each, the actual payments may vary. For example, the first payment you actually receive is 26%, and the second payment you actually receive is 24%. While the four payments total to 1.0 (100%) by the final payment, you do not necessarily know all the actual payment amounts until the security is paid in full, and totals to 1.0 (100%). To accommodate this scenario, Eagle Accounting allows you to define a custom sink schedule that does not require all the payments to total to 1.0 (100%). 

When you receive an actual payment that does not correspond to the expected payment, you can modify the custom sinking fund schedule to reflect the actual payment. In this example, while you expect a first payment of 25%, you actually receive a first payment of 26%. You can change the custom sinking fund schedule to change the first payment from 25% to 26%. The system allows you to make this change because the schedule does not require all the payments to total to 100%. It anticipates that the payments will total to 100% by the time you receive the actual final payment. 

Add a Custom Sink Schedule

WRITERS NOTE: new section

In the Schedule tab of the Securities workspace, you can add a custom sink schedule for a sinking fund security. For more information about adding schedules in Reference Data Center, see Manage Schedules.

To add a custom sink schedule:

  1. In Reference Data Center's Reference Desk workspace, click Securities in the left navigation.
    You see the Securities workspace with all the available securities.
  2. Select a security, edit the security details, and then click the Schedule tab.
    The security must have the Sinking Flag option set to Yes for you to add a sink schedule or a custom sink schedule.
  3. Click Add Security Data.
    You see the Add Schedule dialog box.
  4. In the Schedule Type list
to CSTMSINK. For each entry in the sink schedule, you provide an Effective Date, Price/Rate, and Schedule Amount value. You can
  1. , click CSTMSINK.
    This allows you to add a custom sink schedule. 
  2. By default the Source Type box defaults to Gold Copy, but you can create new vendor data by selecting Vendor, and then selecting the corresponding Source.

  3. Click OK.
    You see the Add Schedule panel with specific fields corresponding to the type of schedule you selected. 
  4. In the Effective Date box, specify the effective date of the transaction.
  5. In the Schedule Amount box, specify the amount for the schedule. 
    For a custom sink schedule, the Schedule Amount values must add up to 1.0, or 100%. However, if you set the Bypass Sink Check
field
  1. option to Yes
to indicate that
  1. , the system does not require the Schedule Amount
Values do not need
  1. values or payments for the custom sink schedule to add up to 1.
00. Otherwise, if you leave this value null, the panel does not save the schedule unless the schedule amounts total 1.00, or 100%.

Change a Custom Sinking Fund Schedule

  1. 0, or 100%.
  2. In the Bypass Sink Check box, indicate 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%. 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%. 
  3. If you want to add one or more entries to the schedule, click Add Row, and complete the information for each additional row. 
  4. Click Save.
    The system saves the schedule to the database.

When you add a custom sink schedule, the system creates a custom sinking fund schedule in the Schedule table,The schedule has a Schedule Type of CSTMSINK. The system also creates a corresponding custom sinking fund schedule in the Corporate Action table. The sink schedule has a Transaction Type of PMT, a Reason of Custom Sink, and. Corporate Action Notes of CUSTOM_SINK.

Edit a Custom Sink Schedule

In the Schedule tab of the Securities workspace, you can edit a custom sink schedule for a sinking fund security. For more information about editing schedules in Reference Data Center, see Manage Schedules.

If you change a custom sink schedule entry because a schedule amount changes, you can click the Override Value button to allow you to change a payment amount or other value. AgainWhen you add or change the schedule, you can set the Bypass Sink Check field option to Yes to indicate that the Schedule Amount Values do not need to add up to 1.00. Otherwise, if you leave this value null, the panel does not save the edited schedule unless the schedule amounts total total  to 1.00, or 100%. For information about adding and changing schedules in Reference Data Center, see Manage Schedules.

WRITERS NOTE: cannot find in new UI to view Reason code

Create a Custom Sink Corporate Action Announcement


To edit a custom sink schedule:

  1. In Reference Data Center's Reference Desk workspace, click Securities in the left navigation.
    You see the Securities workspace with all the available securities.
  2. Select a security, edit the security details and then click the Schedule tab.
  3. Under Schedules, click the row for the schedule that you want to edit. 
    Select a row with a Schedule Sub Type of Custom Sink.
  4. Under Schedule Details, click the row you want to edit, and then click Override Value.
    You see the Override fields display.
  5. The Edit Type drop-down field defaults to Override.
  6. You can select a Reason code from the drop-down list and add an Attachment or any Comments.
  7. Update the fields as needed, and then click Apply and Close and then click Save.
    The revised record is saved to the database.

When you edit a custom sink schedule, the system updates the custom sinking fund schedule in the Schedule table, If you change a schedule amount, the system also updates the corresponding custom sinking fund schedule in the Corporate Action table. 

WRITERS NOTE: start with this section; test in working environment. see button behavior. verify everything and refer back to the Understand Sink Schedules section for details on when you change values

Understand Custom Sink Corporate Action Announcements

WRITERS NOTE: verify if you can create announcement created manual in panel or they'd need a new panel? Verify if you can see the BYpass value onscreen. 

When After you use the Add Schedule option panel or procedure to enter define a custom sink schedule in the Schedule table, Eagle Accounting automatically creates a corresponding custom sink schedule in the Corporate Action table The corporate action record has a a transaction type of PMT,, a Corporate Action Type (tag 1728) value of Custom Sink, and a Corporate Action Notes (tag 1740) value of CUSTOM_SINK. The Corporate Action table also stores the value set for the schedule's Bypass Sink Check option. 

When the system populates the Corporate Action table with the Custom Sink payment schedule, it bases the schedule on the percentage sunk. For example, if the Original Issue Amount is $1,000,000 and the Sinking Fund Percentage is .1%, the amount posted is $1,000. The entire If you did not select the Bypass Sink Check option for the custom sink schedule, the entire custom sinking fund schedule must add up to 1 (100%). However, if you selected the Bypass Sink Check option for the custom sink schedule, Eagle Accounting lifts the restriction that the payments must add up to 1. 

Info

The Create Sink Schedule panel allows you to manually add a sink schedule corporate action announcement associated with a sink schedule. You cannot use the Create Sink Schedule panel panel the corporate action announcement panels to manually add a custom sink schedule corporate action announcement associated with a custom sink schedule. Instead, when you create add the custom sink schedule, the system automatically creates a corporate action record for the announcement in the Corporate Action table. You can modify the corporate action announcement as needed

Change a Custom Sink Corporate Action Announcement

In the Modify Corporate Action Announcement panel, you can change a corporate action annoucement. 

WRITERS NOTE: can you modify a Custom SInk? It shows a Corporate Action Type (tag 1728) value of Custom Sink. You can't choose that value in the query filter. You see a message that the schedule should add up to 1. Will it let you bypass the restriction of 1? 

Process CA for custom sink schedules

?????

Eagle Accounting processes the sinking fund payment with a Transaction Type of Sink.

For more information about setting up and processing corporate actions for sinking fund schedules, see Manage Sinking Fund Payments. 

WRITERS NOTE: can you rebook? what Corporate Action Type (tag 1728) do you choose? 

WRITERS NOTE: revised intro and procedure. confirm that the manual panel cannot create an announcement that corresponds to a Custom Sink Schedule

. When you need to update the payment amounts for the custom sink schedule, you can override the Schedule Amount values for the schedule. The system then automatically updates the corresponding values in the Corporate Action table .

Process Custom Sink Payments

In the Global Process workspace's Sink Schedule Processing panel, you can process sinking fund payments globally. Global processing only uses sinking fund values in the Corporate Action table that have a corporate action status of Released.

The Sink Schedule Processing panel allows you to process sinking fund payments associated with custom sink schedules as well as with sink schedules. For more information about using this panel, see Process Sinking Fund Payments