1. You have purchased a $10,000 Face Value 10-year U.S. Treasury Note (T-Note). The T-Note purchased has a 2% coupon rate (compounded semi-annually) and the current market Yield to Maturity (YTM) is also 2%. What is the market price of this 10-year T- note? 0.00 =YEARFRAC(B5,B6,1) Years to Maturity = Clean or Flat Bond Price (as a % of Face or Par Value) = Face or Par Value = Clean Price per Unit of Face Value = #NUM! Note or Bond Price - Given Yield to Maturity Settlement Date Maturity Date Coupon Rate (%) YTM (%) Maturity Value (As % of Par Value) 100 # coupon payments 2 Day count basis US (NASD) 30/360 Actual/actual Actual/360 Actual/365 3 European 30/360 4 FACE VALUE $10,000 =PRICE(B5, B6, B7, B8, B9, B10, B15) $10,000 #NUM! 1 2 1. You have purchased a $10,000 Face Value 10-year U.S. Treasury Note (T-Note). The T-Note purchased has a 2% coupon rate (compounded semi-annually) and the current market Yield to Maturity (YTM) is also 2%. What is the market price of this 10-year T- note? 0.00 =YEARFRAC(B5,B6,1) Years to Maturity = Clean or Flat Bond Price (as a % of Face or Par Value) = Face or Par Value = Clean Price per Unit of Face Value = #NUM! Note or Bond Price - Given Yield to Maturity Settlement Date Maturity Date Coupon Rate (%) YTM (%) Maturity Value (As % of Par Value) 100 # coupon payments 2 Day count basis US (NASD) 30/360 Actual/actual Actual/360 Actual/365 3 European 30/360 4 FACE VALUE $10,000 =PRICE(B5, B6, B7, B8, B9, B10, B15) $10,000 #NUM! 1 2