Please show how to solve using EXCEL ONLY.

7. Carol Chastain purchases a 1year discount bond with a $1,000 face value for $862.07. What is the yield of the bond?

8. David Hoffman purchases a $1,000 20year bond with an 8 percent coupon rate (annual payments). Yields on comparable bonds are 10 percent. David expects that, 2 years from now, yields on comparable bonds will have declined to 9 percent. Find his expected yield, assuming the bond is sold in 2 years.