calculate using excel

#1. An annual bond has 12 years to maturity, a $1,000 face value, and a coupon rate of 7%. If the required rate of retun is 5%, what should the current market price of the bond be? (5 points) #2. An annual bond has 12 years to maturity, a $1,000 face value, and a coupon rate of 7%. If the required rate of retun is 9%, what should the current market price of the bond be? (5 points) #3. An annual bond has 7 years to maturity, a $1,000 face value, and a coupon rate of 6%. If the bond has a current market price of $1,145, what is the yield to maturity? (5 points) #4. An annual bond has 7 years to maturity, a $1,000 face value, and a coupon rate of 6%. If the bond has a current market price of $945, what is the yield to maturity? (5 points)