BondCoupon() function

BondCoupon() function

BondCoupon(argument list…)

This function allows the user to choose from six different bond coupon-related calculations, indexed by a numeric Output_Type code. The function uses the following arguments:

Argument	Description	Restrictions
Output_Type	output returned from the function	0 = last coupon date 1 = next coupon date 2 = # of remaining coupons 3 = days in current coupon period 4 = accrued days 5 = days until next coupon
Settlement_Date	bond settlement date	valid Excel date number
Maturity_Date	bond maturity date	valid Excel date number >= Settlement_Date
Frequency	number of bond coupons per annum (in the case of zero coupon bonds, indicates the compounding frequency)	1, 2, 4, or 12
DCB	day count basis	0 = 30/360 (US) 1 = act/act for CAD/US T-Bonds 2 = act/360 3 = act/365 4 = 30/360 (European)