JJJ bond has a face value of $1,000 with a coupon rate of 7%, and matures in 10 years. The coupon payment is paid semiannualy and the yield to maturity (YTM) is 8%. What is the bond's value today (weight: 10%)? (Excel model/command is required) Please create a sensitivity analysis (Excel Data Table) of bond price by YTM from 0% to 10% (weight: 5%) and briefly explain your observations (<100 words) (weight: 5%).

c