## oBond1_CFM( ) Example

 Description Consider a 10-year bond that has a semi-annual coupon of 8.25%, a dated date of 1 June 1998, a maturity date of 1 June 2008, and a face value of \$100,000. The bond discounts all cash flows on an Actual/365 JGB basis and accrues interest on a Actual/Actual (bond) basis. Yield is calculated on an annual compounding basis. There is no ex-dividend period, cash flows are rounded to 12dp, and cash flows that fall on a non-business day are not adjusted. Coupons are equal and the bond is priced using the ISMA formula. Generate the cash flow map of this bond assuming a settlement date of 1 March 2003. Function Specification =oBond1_CFM("1/3/2003", "1/6/1998", "1/6/2008", 100000, 0.0825, 2,{6, 2}, 0) Parameter Name Parameter Value Settlement Date 1/3/2003 Dated Date 1/6/1998 Maturity Date 1/6/2008 Face Value 100000 Coupon Rate 0.0825 Coupon Frequency 2 Discount Basis 6 Accrual Basis 2 Output Flag 0 Solution The following results are obtained: Nominal Date Actual Date Coupon Amount (\$) Face Value (\$) Total Cash Flow (\$) Number of Days 1/6/03 1/6/03 4,125.0000 0.0000 4,125.0000 182 1/12/03 1/12/03 4,125.0000 0.0000 4,125.0000 183 1/6/04 1/6/04 4,125.0000 0.0000 4,125.0000 183 1/12/04 1/12/04 4,125.0000 0.0000 4,125.0000 183 1/6/05 1/6/05 4,125.0000 0.0000 4,125.0000 182 1/12/05 1/12/05 4,125.0000 0.0000 4,125.0000 183 1/6/06 1/6/06 4,125.0000 0.0000 4,125.0000 182 1/12/06 1/12/06 4,125.0000 0.0000 4,125.0000 183 1/6/07 1/6/07 4,125.0000 0.0000 4,125.0000 182 1/12/07 1/12/07 4,125.0000 0.0000 4,125.0000 183 1/6/08 1/6/08 4,125.0000 100,000.0000 104,125.0000 183