RRBCouponAccrual() function

RRBCouponAccrual() function

RRBCouponAccrual(argument list…)

This function returns the actual (nominal) accrued interest, taking into account the real accrued interest and the growth in the CPI index, for a Canadian real return bond (semi-annual), per $100 initial par. The function uses the following arguments:

Argument	Description	Restrictions
Base_Date	CPI base date for the bond	valid Excel date number
Settlement_Date	bond settlement date	valid Excel date number >= Base_Date
Maturity_Date	bond maturity date	valid Excel date number >= Settlement_Date
Coupon	annual real bond coupon in decimal form (e.g. six percent entered as 0.06). For zero coupon (strip) bonds, enter 0.	>= 0
CPI_Dates	array of dates for the CPI table	strictly ascending order
CPI_Values	array of CPI (Consumer Price Index) levels corresponding to CPI_Dates	> 0 (typically rising, if inflation exists)