PLEASE SHOW WORK IN EXCEL SO I CAN LEARN FROM THIS

Problems

1.What is the yield to maturity on a 20-year zero coupon bond with a $1000 and a price of $800?

2.Terrapins has a bond issue outstanding with 9 years remaining to maturity, a coupon rate of 10% with interest paid semi-annually, and a par value of $1,000. If the current market price of the bond issue is $814.45, what is the yield to maturity?

3.What is the price of a bond with a coupon rate of 4.50%, a yield to maturity of 4.25%, a future value of $1000, semi-annual coupon payments, and 9 years until maturity?

4.What is the coupon rate on a bond with a par value of $1,000, semi-annual coupons, 8 years until maturity, yield to maturity of 8.50 %, and price of $925.64?