RRBFlatPrice() function  Previous topicNext topicFirst topicLast topic

RRBFlatPrice() function

RRBFlatPrice(argument list…)

This function returns the actual (nominal) flat price (excluding accrued interest and accrued principal growth since the last coupon date), taking into account 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
Real_Price is the real bond price price per $100 par > 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)

© 1995-98 Leap of Faith Research Inc.