Please use excel

1. Consider a $1,000 par value bond with a 7% annual coupon. The bond pays interest annually. There are 2 years remaining until maturity. What is the current yield on the bond assuming that the required return on the bond is 10%?

2. A bond has a current price of $800, a maturity value of $1,000 (matures in 5 years). If interest is paid semi-annually and the bond has a current yield of 8%, what is the bond's annual coupon rate?

3. The $1,000 face value bond has a coupon rate of 6%, with interest paid semi-annually, and matures in 5 years. If the bond is priced to yield 8%, what is the bond's value today?