Q1. A 10 year semiannual is selling at par and has a yield to maturity of 8.08 percent. What is the amount of each coupon payment if the face value of the bonds is $1,000?

Q2. A company offers 5.28 percent coupon bonds with semiannual payments and a yield to maturity of 6.43 percent. The bonds mature in 15 years. What is the market price per bond if the face value is $1,000?

Q3. A $1,000 par value bond sells for $990. It matures in 5 years and has a 5% coupon, paid semiannually. What is the bonds yield to maturity (YTM)?

Q4. Company ABC has 7 percent, semiannual, coupon bonds outstanding with a current market price of $1,023.46, a par value of $1,000, and a yield to maturity of 6.72 percent. How many years is it until these bonds mature?

Q5. A bond pays a coupon of 6.5% and matures in 10 years. The coupon is paid semi-annually on 1st January, and 1st July. The bond is quoted for 971 value on April 30, 2018. What is the dirty price if the par value is $1000?

ALL NEED TO SHOW FORMULAS AND WORK THROUGH EXCEL, PLEASE!