Q5-Consider a bond with a face value of $1000. Suppose this bond pays annual coupon for 7 years @ 3%. Assume a yield to maturity of 4%. Prepare a spreadsheet to accomplish the following tasks: 1. Determine the cash flows of this bond at each period. (5 pts.) 2. At what price should this bond be sold? (5 pts.) 3. Calculate the duration for this bond. (5 pts.) 4. Calculate the modified duration for this bond. (5 pts.) 5. What do you expect to the duration if the coupon payments increase to 9%? (10 pts.)