Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

You can establish a cap/floor Security Master File (SMF) record using the Caps & Floors panel in Issue Viewer.
A cap/floor must adhere to the same requirements as all fixed income securities. For example, the First Coupon Date and Last Coupon Date values must be in sync with the payment frequency of the bond, and you must enter all required fields before submitting the record. Also, the values for the First Coupon Date, Last Coupon Date, and Maturity Date must not include Delay Days.

Note:

Eagle Accounting determines the payment frequency of the bond from the Payment Frequency, Interest Payment Timing, Business Day Calendar, Business Day Adjustment, Coupon Day of Month, and Day of Month Override fields.

For more information about reference setup, see "Reference Data."

Set Up Caps & Floors Panel Options

When you use the Caps& Floors panel to set up a cap or floor security, the following setup information is specific to caps and floors:

  • Processing Security Type (tag 3931). To allow the system to recognize a security as a cap or floor, select:
    • OPIRCA (Interest Rate Option Caps) to establish a cap SMF record.
    • OPIRFL (Interest Rate Option Floors) to establish a floor SMF record.
  • Coupon Type (tag 97). Required. Eagle Accounting supports the following coupon types for cap/floor contracts:
    • Variable Rate. If you select this value, you need to populate coupon rates in the Variable Rate table to accrue interest income. Eagle Accounting uses the coupon rates directly from the Variable Rate table. The Strike Rate field is not used in the calculation of coupon rates.
    • Unscheduled Variable Rate. If you select this value, you need to populate coupon rates in the Variable Rate table to accrue interest income. Eagle Accounting uses the coupon rates directly from the Variable Rate table. The Strike Rate field is not used in the calculation of coupon rates.
    • Floating Rate. If you select this value, Eagle Accounting requires the following fields:
      • Underlying Issue Name (tag 1141)
      • Underlying Ticker (tag 1349)
      • Underlying Asset ID (tag 1348)
      • Underlying Security Asset ID (tag 1347)
      • First Rate Reset Date (tag 10911)
      • Reset Frequency Code (tag 1788)

For cap/floor security master records set up with a Floating Rate coupon type, Eagle Accounting uses the coupon rates of the attached underlying security on the Rate Reset Date from the Variable Rate table. Eagle Accounting then adds any applicable Index Offset (tag 215) to the coupon rate selected from the Variable Rate table. Eagle Accounting then compares the sum of the underlying security Coupon Rate and Index Offset with the Strike Rate to determine what the coupon rate should be.

    • Inverse Floating Rate. If you select this value, Eagle Accounting requires the following fields:
      • Underlying Issue Name (tag 1141)
      • Underlying Ticker (tag 1349)
      • Underlying Asset ID (tag 1348)
      • Underlying Security Asset ID (tag 1347)
      • First Rate Reset Date (tag 10911)
      • Reset Frequency Code (tag 1788)
      • Inverse Floater Rate (tag 1553)
      • Inverse Floater Multiple (tag 4532)
  • Maturity Price (tag 42). Required. The Maturity Price defaults to 0 because both cap and floor contracts are interest-only and there is no repayment of principal.
  • OID Indicator (tag 218). Required. Because the Maturity Price (tag 42) of a cap/floor defaults to 0; the OID Indicator is set to No.
  • Trading Flat (tag 3949). Required. As a general rule, cap and floor contracts trade without interest (trades flat). Therefore this field has a default value of Yes. In the event that a contract does trade with interest, you can change the value to No.
  • Strike Rate (tag 11850). Required. Stores the ceiling rate for cap contracts and stores the floor rate for floor contracts. If you set up the security with a Floating Rate or Inverse Floating Rate coupon type, Eagle Accounting uses the value in the Strike Rate field along with the rate of the underlying security on the reset date to determine at what rate the contract accrues interest. If the coupon type on the cap/floor contract is not Floating or Inverse Floating, the Strike Rate field is for reference only.

Cap Coupon Rate Example

A Cap Security has:

  • Strike Rate of 8%
  • Underlying Index on the cap contract is LIBOR
  • Index Offset is 250 basis points
  • The security Resets and Pays coupons on January 1, April 1, July 1, and October 1.

Rates are as follows.

Rate Reset Date

Coupon Rate

Index Offset

Total Rate

1-Jan

6.0

2.5

8.5

1-Apr

5.0

2.5

7.5

1-Jul

5.5

2.5

8.0

1-Oct

4.5

2.5

7.0

On January 1, Eagle Accounting compares the All in Rate (Total Rate), which is 8.5%, against the Strike Price of 8%. Because the security is a Cap contract and the All in Rate is greater than the Strike Price, Eagle Accounting accrues the difference between the All in Rate and the Strike Rate. In this example, Eagle Accounting accrues at a rate of .5% (8.5% - 8.0%).
In the following quarters, the rates are not greater than the Strike Rate, so Eagle Accounting accrues at a Coupon Rate of 0.00%.

Floor Coupon Rate Example

A Floor Security has:

  • Strike Rate of 8%
  • Underlying Index on the Cap Contract is LIBOR
  • Index Offset of 250 basis points
  • The security Resets on January 1, April 1, July 1, and October 1.

Rates are as follows.

Rate Reset Date

Coupon Rate

Index Offset

Total Rate

1-Jan

6.0

2.5

8.5

1-Apr

5.0

2.5

7.5

On January 1, Eagle Accounting compares the All in Rate (Total Rate), which is 8.5%, against the Strike Price of 8%. Because the security is a Floor contract and the All in Rate is greater than the Strike Price, Eagle Accounting accrues 0.00% for the period.
In the quarter starting April 1, the All in Rate is less than the Strike Rate. Therefore Eagle Accounting calculates a coupon rate using the following formula:
Strike Rate - All in Rate = Coupon Rate, or 8.0% - 7.5% = .5%
Inverse Floaters act in the similar manner with the following exception: the All in Rate is calculated using this formula:
All in Rate = Inverse Floating Rate - (Coupon Rate from the underlying security + Index Offset) * Inverse Multiplier

Note:

For more information on Floating Rate and Inverse Floating Rate Coupon Types, see "Reference Data."

Caps and Floors SMF Setup Example

The Caps & Floors panel's fields follow in this example.

Name

Value

SRM Status Flags

 

Release Status

 

Authorize Flag

 

Validation Process Flag

 

Cap/Floor Identification

 

Issue Name

strike rate test

Issue Description

strike rate test

Ticker

strike rate test

CUSIP/SEDOL Check Digit Control Flag

 

Primary Asset ID Type

INTERNAL

Primary Asset ID

STRIKE RATE TEST

Alt Asset ID Type

 

Alt Asset ID

 

Cap/Floor Xreference Identification

 

CUSIP

 

ISIN

 

Sedol

 

Reuters

 

Bloomberg ID

 

SICOVM

 

Valoren

 

CEDEL

 

CINS

 

XREF Exchange

BSE

Cap/Floor Details

 

Investment Type

OP

Processing Security Type

OPIRCA

Security Type

 

Sub Security Type

 

Quantity Type

CONTRACTS

Price Multiplier

0.0100

Quantity Scale

1.00

Country Of Risk

 

Country Of Risk Code

 

Issue Country

UNITED STATES

Issue Country Code

US

Asset Currency

USD

Settlement Currency

USD

Income Currency

USD

Issue Tax Type

SPECIAL

Primary Exchange

BOSTON STOCK EXCHANGE

Primary Exchange Code

BSE

Region

 

Cap/Floor Coupon Periods

 

Coupon

0.000000

Coupon Type Code

Floating Rate

Strike Rate

8.000000

Day Count Basis

ACT/360

Payment Frequency

Quarterly

Payment Frequency Code

3_M

Business Day Convention

 

Business Calendar Name

 

Day of Month Override

 

Interest Payment Timing

 

Delay Days

 

Cap/Floor Dates

 

Issue Price

0.00000000

Issue Date

20020101

Dated Date

20020101

First Coupon Date

20020401

Last Coupon Date

20040101

Maturity Date

20040101

Maturity Price

0.00

Variable Rate Next Reset Date

 

Calculate/Validate Last Coupon Date

Validate Last Coupon Date

Valid Last Normal Coupon Date

 

Cap/Floor Flags

 

Trading Flat

Yes

OID Indicator

No

Rate Reset Flag

Upfront

2a7 Flag

 

Inactive Flag

 

Floating Rate Information

 

First Rate Reset Date

20020401

Reset Frequency

QUARTERLY (QUARTERLY)

Reset Frequency Code

3_M

Reset Look Back Days

0

Underlying Information

 

Underlying Security ID

Libor

Underlying Issue Name

Libor

Underlying Ticker

Libor

Index Offset

250.0000

Issuer Information

 

Issuer ID Name

 

Issuer ID

 

Issuer Alias

 

Country Of Incorporation Code

 

Issuer Industry

 

  • No labels