ODDCOMPINT

Updated 2024-02-29 22:10:12.957000

Syntax

SELECT [westclintech].[wct].[ODDCOMPINT](
  <@Basis, nvarchar(4000),>
 ,<@Rate, float,>
 ,<@IssueDate, datetime,>
 ,<@Settlement, datetime,>
 ,<@Maturity, datetime,>
 ,<@FirstCouponDate, datetime,>
 ,<@LastCouponDate, datetime,>
 ,<@CompFreq, int,>)

Description

Use the scalar function ODDCOMPINT to calculate the accrued interest for a security with an odd first or an odd last coupon period (or both) where interest is compounded periodically and paid at maturity. If the settlement date is less than or equal to the first coupon date, then the accrued interest is the same as the value returned by AIFACTOR_OFC.

If the settlement date is greater than the first coupon date and less than the last coupon date or the last coupon date is than the accrued interest is:

\rm{ODDCOMPINT=\left(1+C_{odd}\right)*\left(1+\frac{R}{M}\right)^N*\left(1+\frac{R}{M}*\frac{A}{E}\right)-1}

If the settlement date is greater than the last coupon date, then accrued interest is:

\rm{ODDCOMPINT=\left(1+C_{odd}\right)*\left(1+\frac{R}{M}\right)^N*\left(1+A_{last}\right)-1}

Where:R = the coupon interest rate as a decimalM = the number of compounding periods per yearN = the number of whole coupons prior to the settlement dateA = the number of accrued days in the coupon period in which the settlement occursE = the number of days as specified by the basis code for the coupon period in which the settlement occurs.Codd = the accrued interest factor as calculated by AIFACTOR_OFCAlast = the accrued interest factor as calculated by AIFACTOR_OLC

Arguments

@FirstCouponDate

for bonds with an odd first coupon amount, the date of the coupon payment. @FirstCouponDate should only be used when the first interest payment is calculated and compounded on a date other than a regular, periodic coupon date. If @LastCouponDate is NULL, then the coupon dates are calculated backwards from @Maturity, otherwise @LastCouponDate is used to calculate the coupon dates. @FirstCouponDate is an expression of a datetime data type or of a type that can be implicitly converted to datetime.

@Basis

is the type of day count to use. @Basis is an expression of the character string data type category.

{"columns":[{"field":"Basis","headerClass":"ag-right-aligned-header","cellClass":"ag-right-aligned-cell","width":139},{"field":"Day count basis","width":174}],"rows":[{"Basis":"0","Day count basis":"US (NASD) 30/360"},{"Basis":"1","Day count basis":"Actual/Actual"},{"Basis":"2","Day count basis":"Actual/360"},{"Basis":"3","Day count basis":"Actual/365"},{"Basis":"4","Day count basis":"European 30/360"}]}

@LastCouponDate

for bonds with an odd last coupon amount, the last regular coupon date. @LastCouponDate should only be used when the last interest payment is calculated from a start date other than a regular, periodic coupon date calculated backwards from @Maturity. @LastCouponDate is an expression of a datetime data type or of a type that can be implicitly converted to datetime.

@Rate

the coupon rate of the security expressed in decimal terms. @Rate is an expression of type float or of a type that can be implicitly converted to float.

@IssueDate

the issue date of the security; the first interest accrual date. @IssueDate is an expression of a datetime data type or of a type that can be implicitly converted to datetime.

@CompFreq

the number of times the coupon are is compounded annually. For annual compounding, @CompFreq = 1; for semi-annual, @CompFreq = 2; for quarterly, @CompFreq = 4, and for monthly, @CompFreq = 12. @CompFreq is an expression of type float or of a type that can be implicitly converted to float.

@Settlement

the settlement date occurring within a coupon period of the security; interest is accrued from @IssueDate through to @Settlement. @Settlement is an expression of a datetime data type or of a type that can be implicitly converted to datetime.

@Maturity

the maturity date of the bond. @Maturity is used to determine the coupon dates. @Maturity is an expression of a datetime data type or of a type that can be implicitly converted to datetime.

Return Type

float

Remarks

If @CompFreq not 1, 2, 4 or 12 an error will be returned.

@IssueDate <= @Settlement <= @Maturity.

@IssueDate < @FirstCouponDate < @LastCouponDate < @Maturity.

For bonds with regular coupon payments, use COMPINT.

ODDCOMPINT returns a factor. To calculate the monetary value of the accrued interest, you should multiply this factor by the face amount of the bond.