Create a table WITH DATES that show the relevant cash flows for the bond

Find the YTM in two ways using IRR and YIELD function

TREASURY BOND CALCULATION Current date Previous interest payment date Next interest payment date Coupon 20-Feb-01 15-Oct-00 15-Apr-01 3,250.00 128 Days since last coupon date Days between last coupon date and next coupon date 182 Accrued interest Face Value 2,285.71 100,000 Bond price Accrued interest Invoice price 107,152.00 2,285.71 109,437.71 TREASURY BOND CALCULATION Current date Previous interest payment date Next interest payment date Coupon 20-Feb-01 15-Oct-00 15-Apr-01 3,250.00 128 Days since last coupon date Days between last coupon date and next coupon date 182 Accrued interest Face Value 2,285.71 100,000 Bond price Accrued interest Invoice price 107,152.00 2,285.71 109,437.71