RRBSettlementPrice() function  Previous topicNext topicFirst topicLast topic

RRBSettlementPrice() function

RRBSettlementPrice(argument list…)

This function returns the actual (nominal) settlement price (including accrued interest and principal growth), taking into account the growth in the CPI index, for a Canadian real return bond (semi-annual), per $100 initial par. The result is simply the sum of the Flat Price, the Inflation Accrual, and the Coupon Accrual. 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.