Can you show me how to figure this out with excel and a graph?
1. A US Treasury STRIP with a face value of $1000 has 9 years to maturity. In excel, compute and graph the yields for prices of $500 to $1000, in $50 increments. Use annual compounding of interest.
2. You are given the following information from a T-Note quote: Settlement date: September 15, 2017
Maturity date: September 15, 2032
Price Quote: 102:9
In excel, compute and graph the coupon rates, duration, and current yields for yields-to- maturity of 1% to 20%, in 1% increments. Duration can be on a separate chart.