BondAccrued() function

BondAccrued() function

BondAccrued(argument list…)

This function returns the accrued interest per $100 par for a level-coupon bond. The function uses the following arguments:

Argument	Description	Restrictions
Settlement_Date	bond settlement date	valid Excel date number
Maturity_Date	bond maturity date	valid Excel date number >= Settlement_Date
Coupon_Rate	annual bond coupon rate in decimal form (e.g. six percent entered as 0.06)	>= 0
Frequency	number of bond coupons per annum	1, 2, 4, or 12
DCB	day count basis	0 = 30/360 (US) 1 = act/act for US T-Bonds 2 = act/360 3 = act/365 4 = 30/360 (European) 5 = CAD modified act/365 (CAD T-bonds)