...
...
Processing a Convertible Bond Buy Examples
...
...
Entity Information
...
Entity ID(1163:S)
...
CBDEMO2 (CBDEMO2)
...
Entity Name(1164:S)
...
CBDEMO2
...
Base Currency(86:S)
...
USD
...
Issue Information
...
Trade Date(35:S)
...
2004 11 16
...
Accounting Date(36:S)
...
2004 11 16
...
Monthly Accounting Date(4733:S)
...
2004 11 16
...
Settlement Date(37:S)
...
2004 11 17
...
Event Type(55:S)
...
BUY
...
Long/Short Indicator(15:S)
...
L
...
Cross Reference Type(1234:S)
...
INTERNAL
...
Issue Name(961:S)
...
XYZ CONVERTIBLE BOND
...
Ticker(13:S)
...
mpsxyz
...
Cross Reference ID(1233:S)
...
XYZ CONVERTIBLE BOND (INTERNAL) (XYZ CONVERTIBLE BOND)
...
Instrument Type(11:S)
...
FI
...
Security Type(82:S)
...
...
Issue Currency(85:S)
...
USD
...
Maturity Date(38:S)
...
2012 01 15
...
Coupon Rate(70:S)
...
5.000000
...
Convertible Indicator(1531:S)
...
Y
...
Accounting Information
...
Select Values to be Calculated by STAR(7000:S)
...
Traded Interest/Amort Yield/OID Yield/Trade Yield
...
Accrued Interest Type(3715:S)
...
CUM
...
Par Value/Current Face(40:S)
...
1,000,000.000000
...
Price(45:S)
...
165.09300000
...
Amort Yield(75:S)
...
-3.060192856634
...
Trade Yield(9430:S)
...
-3.060192856634
...
OID Yield(39:S)
...
Principal(165:S)
...
1,650,930.000
...
Implied Commission Indicator(78:S)
...
NO
...
Commission(47:S)
...
0.00
...
Tax Amount(46:S)
...
0.00
...
Stamp Duty Tax(51:S)
...
0.00
...
Other Fee(3752:S)
...
0.00
...
Ex Interest Processing Flag(16311:S)
...
N
...
Traded Interest(49:S)
...
16,944.440
...
Local Net Amount(50:S)
...
1,667,874.440
...
Settlement Currency(63:S)
...
USD
...
Settlement Net Amount(64:S)
...
1,667,874.440
...
Local to Base FX Rate(87:S)
...
1.000000000000
...
Base Net Amount(478:S)
...
1,667,874.44
...
Underlying Security Market Price(319:S)
...
36.750000
...
Conversion Premium(5727:S)
...
Settlement Information
...
Settle Trade Indicator(58:S)
...
NO
...
Broker Name(1235:S)
...
EAGLE
...
Broker Code(88:S)
...
EAGLE
Example 1: SRPM with Same Asset Currency
Calculation of Stated Redemption Price and Conversion Premium for Trade Date of the purchase of a convertible bond, when the Asset Currency of the convertible bond equals the Asset Currency of the underlying security.
The Stated Redemption Price at Maturity (SRPM) is calculated using the formula:
Conversion Ratio * Market Price of Underlying Shares / 10
...
Note:
...
The reason for dividing by 10 in the prior calculation is that the Conversion Ratio is expressed in number of shares per 1,000 units of par, and the Stated Redemption Price at Maturity is expressed as a percentage. The result of the equation should be rounded to the same number of decimal places as the bond's Asset Currency.
The Conversion Premium is calculated using the following formula:
Purchase Price of the Bond - SRMP
- The Underlying Sec Market Price is the latest available price for the underlying security in relation to the Trade Date of the Convertible Bond. It is derived from a pricing date that is less than or equal to the Trade Date.
- The results of this formula should be rounded to the same number of decimal places as the Asset Currency of the convertible bond.
To illustrate, a portfolio with a Base Currency of USD buys a convertible bond for XYZ Corp., which has XYZ Corp. Common Stock as the underlying security. Both the bond and the stock have an Asset Currency of USD. The information related to the bond's conversion feature follows in the following figure.
Figure 36: Sample Bond Conversion Feature Related Information
Example 1: Equity Option Value with Same Asset Currency
If you wanted to use the same sample data found in Example 1: SRPM to achieve the same results in Eagle Accounting, you would need to enter a conversion premium of 54.74. This allows Eagle Accounting to calculate and set a target amortization price of 154.74 ( 100 maturity price value + 54.74 Embedded Option Value ).
Example 2: SRPM where Asset Currency Differs
The calculation of the Stated Redemption Price and Conversion Premium for Trade Date of the purchase of a convertible bond, when the Asset Currency of the convertible bond does not equal the Asset Currency of the underlying security follows:
The SRPM uses the following formula in this scenario:
Conversion Ratio * Market Price of Underlying Shares / 10 / Exchange Rate
The results of this formula should be rounded to the same number of decimal places as the Asset Currency for the convertible bond. The exchange rate represented in the formula above, is the rate of the bond currency, to the rate of the underlying security currency, on the date the SRPM is calculated for.
The Conversion Premium uses the following formula:
(Purchase Price of the Bond - SRPM)
The results of this formula should be rounded to the same number of decimal places as the Asset Currency for the convertible bond.
To illustrate, a portfolio with a Base Currency of USD buys a convertible bond for XYZ Corp., which has XYZ Corp. Common Stock as the underlying security. The bond has an Asset Currency of USD, and the stock has an Asset Currency of GBP. The information related to the bond's conversion feature follows in the following figure.
Figure 37: Sample Bond Conversion Feature Related Information
...
If you wanted to use the same sample data found in Example 2: SRPM to achieve the same results in Eagle Accounting, you would need to enter a conversion premium of 6.07. This allows Eagle Accounting to calculate and set a target amortization price of 106.07 ( 100 maturity price value + 6.07 Embedded Option Value ).
SRPM Convertible Bond Yield Calculation Examples
This section shows the impact of different prices and call features on yield calculations in Eagle Accounting when you use the SRPM convertible option price method with convertible bonds. All examples in this section use the following security master information, and assume that the Select Values to be Calculated by STAR field (tag 7000) is set to calculate Traded Interest/Amort Yield/OID Yield/Trade Yield on the Trade panel.
Security Master Information used for the examples follows.
...
Field Name
...
Value
...
Issue Name
...
XYZ Convertible Bond
...
Issue Description
...
XYZ Convertible Bond
...
Primary Asset ID
...
XYZCB1234
...
Processing Security Type
...
DBIBFD
...
Issue Country Code
...
US
...
Asset Currency
...
USD
...
Settlement Currency
...
USD
...
Income Currency
...
USD
...
Coupon
...
5%
...
Coupon Type Code
...
Fixed
...
Day Count Basis
...
30/360
...
Payment Frequency
...
Semi-annual
...
Issue Date
...
20040115
...
Dated Date
...
20040115
...
First Coupon Date
...
20040715
...
Last Coupon Date
...
20110715
...
Maturity Date
...
20120115
...
Maturity Price
...
100
...
Convertible Indicator
...
Y
...
Underlying Issue Name
...
XYZ Corp Equity
...
Index Offset
...
42.1052
Example 1: Convertible Bond Purchased at a Discount
Convertible XYZ Convertible Bond is bought at a Price of 99.7 and the current price of the underlying security is 24.00. Eagle Accounting only calculates a target amortization price utilizing the underlying equity price or embedded equity option value when security convertible bond is purchased at a premium.
In this example, Eagle Accounting calculates and sets a target amortization price to 100 and an Amort Yield of 5.046015424911 and amortizes to Maturity Date (1/15/2012).
Example 2: Convertible Bond Purchased at Premium with a Put Provision
XYZ Convertible Bond is bought at a Price of 101, and the current Price of the underlying security is 24.00. There is a Put provision on the bond for a price of 102 on 7/15/2006.
Calculated SRPM = 101.05 = (42.1052 * 24/10)
Eagle Accounting calculates an SRPM when the security is purchased at a premium. However, when there are call/put options, the call/put option price takes precedence over the SRPM in determining and calculating the amortization yield. Thus Eagle Accounting calculates an Amortization Yield of 5.326731234303 using the put price and date, and then amortizes out to the Put Date and Price, instead of the Maturity Date and SRPM. In the event that you do not "Put" the security on the Put Date, Eagle Accounting calculates a new yield based on existing reference data and the applicable amortization rule, and amortizes accordingly.
...
Note:
...
Eagle Accounting utilizes a Yield to Best approach when calculating a yield based on Put data. Yield to Best, as the name implies, is calculating the highest cash flow yield, or the best Put Price and Date information, that includes the Maturity Date.
Example 3: Convertible Bond Purchased at Premium with a Call Provision
...