| RRBFlatPrice() function | |
RRBFlatPrice() functionRRBFlatPrice(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.