Please use excel

1. A 2-year zero-coupon note was issued on December 1, 2019. If its YTM is 1.95%, what is its current market value?

2. The $1,000 face value bond has a coupon of 10% (paid semi-annually), matures in 4 years, and has current price of $1,140. What is the bond's yield to maturity?

3. Find the yield to maturity on a semiannual coupon bond you are thinking of buying today. The bond price is $1128, the coupon rate is 6.5%, the face value is $1000, and was issued on Aug 15, 2013, maturing in 13 years.

4. Suppose you purchase a 25-year, $1000-face value, zero coupon bond for $357.80 when issued on 3/1/2020. What is the bond's YTM?