Please fill in the yellow boxes and show work

Coupon (%) Maturity date Settlement date Price (clean, $) Price/yield calculation basis Accrued interest rate calculation basis Accrued interest (AI, $) Dirty price ($) = Clean price + AI 8.3% 6/15/2013 10/22/2007 102.48 30/360 ACT/365 Last coupon Settlement 10/22/2007 6/15/2007 6/15/2008 6/15/2009 6/15/2010 6/15/2011 6/15/2012 6/15/2013 Date Number of years Cash flows ($) Discounted cash flows ($), using yield below Yield (%), using Goalseek Target cell for Goalseek Dirty price ($) 0.00 Check: Yield (%), using YIELD function Coupon (%) Maturity date Settlement date Price (clean, $) Price/yield calculation basis Accrued interest rate calculation basis Accrued interest (AI, $) Dirty price ($) = Clean price + AI 8.3% 6/15/2013 10/22/2007 102.48 30/360 ACT/365 Last coupon Settlement 10/22/2007 6/15/2007 6/15/2008 6/15/2009 6/15/2010 6/15/2011 6/15/2012 6/15/2013 Date Number of years Cash flows ($) Discounted cash flows ($), using yield below Yield (%), using Goalseek Target cell for Goalseek Dirty price ($) 0.00 Check: Yield (%), using YIELD function