What is the bond price of a $1,000 face value bond, with an 8% coupon rate paid semi-annually, that has a required return of 7.5% if A. The bond has 16 years maturity? B. The bond has 20 years maturity? C. What is the Duration of the bond with 16 years maturity, given the above information. D. What is the Duration of the bond with 20 years maturity, given the above information Please show how to do in Excel and what would be inputted in the formula bars for each calculation