| RRBSettlementPrice() function | |
RRBSettlementPrice() functionRRBSettlementPrice(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.