VALID CALCULATION TYPES - Betandbetter

VALID CALCULATION TYPES

26 September 2014

Note: This document may not necessarily include all valid calculation types. Please contact your sales representative if you have any questions.

2

1: Notes and Bonds, Street Convention Standard yield formula used most commonly on US Treasuries, corporate securities, and Eurobonds. Yields are calculated on a compounded basis on the same frequency as the coupon frequency for all periods except the last period. In the last period simple yield is applied. Coupon amounts for standard coupon periods are calculated as coupon / coupon frequency * face regardless of day count. Settlement defaults to T+1 for US Treasuries and Agencies, T+3 for all others. However there may be individual securities that apply their own specific market convention.

2: When-Issued U.S. Treasuries Used for when-issued US Treasury notes/bonds issued without accrued interest (i.e., the Issue

Date and Interest Accrual Dates match). Primary price/yield calculation is Auction Yield on ticketing functions. Auction Yield is the

calculation used to calculate the price of a new Treasury note/bond from the winning auction yield. Auction Yield is same as the CD-Compound discount method

Where: CF = cash flow y = yield in percentage form d = days in the period using the applicable day count b = day count basis using the applicable day count

5: Zero-Coupon Bonds that Calculate a Simple Discount Yield Used for Zero-Coupon bonds that are quoted on a discount to par basis. This is the convention used for US Treasury bills

6: Discounted Commercial Paper Used for Zero-Coupon bond commercial paper Primary valuation is on a discount to par basis. Applies T+0

7: CD/Interest at Maturity

Used for zero coupon bonds or bonds that pay all interest at maturity. Yields are calculated on simple interest basis.

3

For bonds that pay interest at maturity the coupon rate is stated as an annual rate. The coupon value is accumulated over the period from issue to maturity

Settlement differs depending on conventions of the particular security. For compounded yields, see Calc Type 269.

8: Converts a Discount Rate into a Simple (MMKT) Yield

13: Short Last Coupon Period Similar to calc type 1 For issues that pay interest on non-anniversary dates of the maturity with a short last coupon. Yields are calculated on a compounded basis on the same frequency as the coupon frequency for all periods except the last period. In the last period simple yield is applied. Coupon amounts for standard coupon periods are calculated as coupon / coupon frequency * face regardless of day count. Can also be used for securities with long first coupons. Settlement defaults to T+1 for US Agencies, T+3 for all others. However there may be individual securities that apply their own specific market convention.

17: Money Market Floaters Used for standard Money Market floating-rate notes created through PGM or MMPL Note these securities must have a floating coupon history page updated in order for the Yield Analysis function (YA) to function properly. Calculates price to discount margin. Discounts first period on a simple yield basis at index to next refix plus discount margin. Discounts all future periods on a compound basis at assumed rate plus discount margin. Index to next refix and Repo to next refix may default to the interpolated value of the underlying benchmark curve at the time to next refix or may be simply the current value of the underlying benchmark, depending on the applicable underlying benchmark. Assumes future cash flows are based on a flat rate calculated as assumed index plus quoted margin, or assumed index * factor on leveraged structures. For securities with caps the future projected coupons will be calculated at the cap if the assumed index plus quoted margin margin (or assumed index * factor on leveraged structures) exceeds the cap. For securities with floors the future projected coupons will be calculated at the floor if the assumed index plus quoted margin (or assumed index * factor on leveraged structures) is below the floor. However, in both cases, the future periods will still be discounted at the current assumed rate plus discount margin, and the first period will still be discounted at the current index to next refix plus discount margin. Unlike Calc 21 there is no leap year adjustment factor in the discount formula for ACT/XX day accounts.

4

For issues using day types of {xxx}/ACT, BLOOMBERG PROFESSIONAL? service uses a denominator of 366 when the current period ends in a leap year.

For trade dates when the first coupon rate is not known, for standard length first periods future coupon rates are estimated as assumed rate +/- quoted margin. For odd first periods (long or short) future coupons are estimated as index to next +/- quoted margin. Note: the rate used to estimate future coupon rates needs to be the same rate used in discounting the cash flows in order for price to equal 100 when quoted margin equals discount margin on first settlement.

BC5 applies this calc.

21: Corporate Floaters Used for standard floating-rate notes. Calculates price to discount margin. Discounts first period on a simple yield basis at index to next refix plus discount margin. Discounts all future periods on a compound basis at assumed rate plus discount margin. Index to next refix and Repo to next refix may default to the interpolated value of the underlying benchmark curve at the time to next refix or may be simply the current value of the underlying benchmark, depending on the applicable underlying benchmark. Assumes future cash flows are based on a flat rate calculated as assumed index plus quoted margin, or assumed index * factor on leveraged structures. For securities with caps the future projected coupons will be calculated at the cap if the assumed index plus quoted margin margin (or assumed index * factor on leveraged structures) exceeds the cap. For securities with floors the future projected coupons will be calculated at the floor if the assumed index plus quoted margin (or assumed index * factor on leveraged structures) is below the floor. However, in both cases, the future periods will still be discounted at the current assumed rate plus discount margin, and the first period will still be discounted at the current index to next refix plus discount margin. A leap year adjustment factor is applied to discount formula for ACT/XX day accounts. For issues using day types of {xxx}/ACT, BLOOMBERG PROFESSIONAL? service uses a denominator of 366 when the current period ends in a leap year. For trade dates when the first coupon rate is not known, for standard length first periods future coupon rates are estimated as assumed rate +/- quoted margin. For odd first periods (long or short) future coupons are estimated as index to next +/- quoted margin. Note: the rate used to estimate future coupon rates needs to be the same rate used in discounting the cash flows in order for price to equal 100 when quoted margin equals discount margin on first settlement. BC13 applies this calc.

22: Certificates of Deposit Used for fixed rate CDs that have a tenor length greater than one year and pay interest annually or more on a more frequent basis. Applies CD compounding yield convention.

5

Where: CF = cash flow y = yield in percentage form d = days in the period using the applicable day count b = day count basis using the applicable day count

Settlement is T+3.

23: Australian Government Bonds, 7-Day Ex-Dividend Used for Australian government and corporate issues that use the 7-day ex-dividend rule. However, it can be adjusted to accommodate other ex-dividend rules. Applies compound yields, compounding on the same frequency as the coupon frequency. However, when settlement occurs in the last period yields are calculated on a simple basis using an ACT/365 day count and if maturity falls on a non-business day it is bumped to the next business day when considering the ACT/365 period. Quotes are by yield with priced being either gross (dirty) or capital (clean). Yields are rounded to 6 decimals Prices are rounded to 3 decimals on except in the last period when they are not rounded. Triggers T+3 settlement. Method of accrual: AI = (Days Elapsed/Days In Period) * (Coupon / Coupon Freq) * 100 (Round to three decimals)

AI per Face = AI * (Face/100) Price formula in last period:

(100+ Periodic Coupon) / (1 +(Days Remaining to Maturity/365)*Annual Yield *If maturity lands on a non-business day, count the days from settle to the bumped maturity date.

26: U.K. Domestic Notes and Bonds (Consortium Method) Used for the United Kingdom domestic government bonds (Gilts) and corporate bonds as well as Bulldog issues. Pays even S/A coupons. An ex-dividend schedule must be filled out. Gilts trigger next day settlement and go 7 business days ex-dividend. Corporate issues have a settlement of T+3 business days and ex-dividend periods vary.

6

Bulldog issues also trigger next day settlement and have varying ex-dividend periods.

33: Mortgage Securities No longer in use Routed to the mortgage calc code.

34: Mortgage Securities No longer in use Routed to the mortgage calc code.

35: Term Debenture Bonds Used for issues which have no accrued interest for the first period or more and then step up to a fixed rate.

41: Perpetual Bonds Used for any issue that has no final maturity. The maturity date must include the day of 29 and a maturity year of 2049. The month can vary.

42: Perpetual Ex-Dividend Bonds Used for any issue that would normally use calc type 26 but has no final maturity. Yield to call is calculated on a compounded basis on the same frequency as the coupon frequency for all periods except the last period. In the last period simple yield is applied. Yield to perpetuity is calculated using the formula for Undated Gilts provided by the UK DMO in the Formulae for Calculating Gilt Prices from Yields document. Yield to worst is the worst of yield to call or yield to perpetuity. The maturity date must include the day of 29 and a maturity year of 2049. The month can vary. Most, but not all, government bonds go 7 business days ex-dividend. Corporate bond exdividend periods vary. UK Gilts apply T+1 settlement, Corps apply T+3 settlement

44: Index-Linked Gilts and UK RPI Corporate Bonds with an Eight-Month Indexation Lag The coupon and redemption are inflation adjusted and linked to the UK RPI Index. (UKRPI Index). There is no deflation floor on either the coupon rate or the principal redemption, i.e., they can both fall below par in case of deflation. The default yield is "real yield" (not inflation adjusted). Quoted price includes the inflation adjustment. Therefore on a security that does not include a sinking fund total payment equals price + inflation adjusted accrued * face. On sinking fund

7

securities price includes the inflation adjustment, but excludes the principal factor. Therefore total payment equals price + inflation adjusted accrued * current factor * face. Gilts apply an 8 day ex-dividend period, corporate issues may vary. T+1 settlement.

46: Municipal Bonds Used for long-term fixed-rate municipal bonds that pay interest regularly. Applies MSRB accuracy & truncation rules No adjustment is made for long/short first/last coupon periods per MSRB's G33 rule Used for most zero coupon bonds that compound interest regularly Used for some adjustable coupon bonds that are in a fixed-rate mode currently

48: Canadian Bonds Used for Canadian government and corporate issues. Yields are compounded on the same frequency as the coupon frequency using an ACT/ACT day count, except in the last period. In the last period, or in the last year for zero coupons, simple interest is applied using an ACT/365 day count. For discounting purposes maturity is adjusted to the next business day if the original maturity falls on a non-business day. Standard period coupon payments are calculated as coupon / coupon frequency * face. Odd periods are calculated on an ACT/365 basis. Partial period accrued for invoicing is calculated on an ACT/365 basis. For most settlement scenarios accrued is calculated as (number of days from previous coupon to settlement) / (365 / coupon frequency) * (coupon / coupon frequency) * face. However for scenarios where accrued days is greater than (365 / coupon frequency) accrued is calculated as (1-(days from settle to next coupon payment) / (365 / coupon frequency)) * (coupon / coupon frequency) * face Note that accrued applied in the discount formula to derive clean price applies and Act/Act day count For sinking fund bonds, workout flag defaults to principal weighted average life. This provides the same price/yield calculation as average life to par, meaning interest and principal cash flows are discounted to the dates they are received. However the average life date is derived as the weighted average time to receipt all principal cash flows See Calc Type 197 for further information regarding government issues.

49: USD Convertible Bonds Uses the same calculations as Calc Type 1, but handles the convertible components.

51: Japanese Government Bonds

8

Regular or short last coupons - Simple (ticker: JGB) Used for Japanese Government Bonds which have either a normal or a short last coupon

period. JGBs issued prior to March 1, 2001 include both start and end dates for the first coupon period. Bonds issued after March 1, 2001 have a full semi-annual coupon payment at the first coupon

date regardless of the issue date. The interest accrued period always starts six months prior to the first coupon payment date. When a coupon date falls on non-business day, payment will be made next business day with no amount adjustment. CSHF will show unadjusted dates. Accrued includes February 29, while simple yield does not unless settled on February 29 or if there is less than one year to maturity. For trade dates prior to April 23, 2012 settlement is T+3 and T+2 on or after. The trade suspension period starts five business days prior to each coupon payment. The accrued interest factor is truncated and calculated as follows: Accrued Interest Factor (X): 100*(Coupon)*(Days Held/Days in Year) = Y Y is truncated after 7 decimal places to result in X. For example, if Y =0.123456789, X = 0.1234567, not 0.1234568 Accrued Interest: (Face/100)*X, truncate decimals to 1 yen BXT allows users to calculate invoice values net of accrued tax. Users can enable commission information on BXT by selecting 97) settings, then the Trade Numbers tab then the Enable Commission check box.

52: Japanese Government Strips and When Issued Japanese Government Bonds Used for Japanese Strip Bonds and When Issued Japanese Government Bonds. Yield is calculated on a semi-annual compound basis. For STRIPS, simple yield is applied when time to maturity is less than six months. Users can enable commission information on BXT by selecting 97) settings, then the Trade Numbers tab then the Enable Commission check box. For trade dates prior to April 23, 2012 settlement is T+3 and T+2 on or after.

54: Japanese Discount Bonds (No Bills) Used for Japanese government long term zero coupon bonds (ticker: JDGB). Price and yield calculation includes only one end. Yield calculation includes February 29 only if there is less than one year to maturity. Compound Yield. For trade dates prior to April 23, 2012 settlement is T+3 and T+2 on or after. Users can enable commission information on BXT by selecting 97) settings, then the Trade Numbers tab then the Enable Commission check box.

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download