Q1. A bond has 8 years until maturity, a semi-annual coupon of 8%, and sells for 110. What is its yield to maturity? (solve using excel) please show how

Q2. A General Electric bond pays an annual coupon of 8%, has 9 years until maturity, and is trading with a yield of 7%.

a. What payment do bondholders receive each year per 100 invested?

b. At what price must the bond be trading? (calculate using the bond price formula from lectures)

c. If the bond were to trade at 120, what would be the yield of the bond? (solve using excel)