Introducing EXCEL spreadsheet functions for solving bond valuation problems. There are several spreadsheet questions, which allow you to practice using those EXCEL functions. Please complete the following:

1.Use EXCEL to solve spreadsheet questions 1, 2, 3, and 4

2.For question 2, you should use the YIELD function. Only use EXCEL functions to solve assigned problems.I am assuming that the way to gather this information to answer the questions is in the questions themselves. Can anyone help?

1. (PRICE) In February 2009, Treasury 8.5s of 2020 yielded 3.2976%. What was their price? If the yield rose to 4%, what would happen to the price? 2. (YLD) On the same day Treasury 3.5s of 2018 were priced at 107.46875%. What was their yield to maturity? Suppose that the price was 110.0%. What would happen to the yield? 3. (DURATION) What was the duration of the Trea- sury 8.5s? How would duration change if the yield rose to 4%? Can you explain why? (MDURATION) What was the modified duration of the Treasury 8.5s? How would modified duration differ if the coupon were only 7.5%