1. On 15 March 2003, Jimmy purchased a three-year Treasury bond with face value $1000 and a 5% coupon (payable semiannually starting on 15 September 2003). The price of the bond was $875. Jimmy sold the bond on 15 March 2004 (i.e., 1-year later) for $925 after receiving the bond's coupon. What was Jimmy's ex-post annualized yield and what was Jimmy's ex-post monthly yield? (Use Excel to show all relevant cash flows and how the equations used to compute Ex-port annualized yield. If you use macros, please indicate them clearly in your excel and you may earn extra points). See Excel template.

B Cash flows A 1 Date 2 15-Mar-03 15-Sep-03 15-Mar-04 5 16 Semiannual IRR 17 | 8 Annualized Yield 9 Monthly Yield