If possible please use excel and show formulas

CHAPTER 7: Interest rate and bond valuation 1. Weismann Co. issued 15-year bonds a year ago at a coupon rate of 4.9%. The bonds make semiannual payments and have a par of $1,000. If the YTM on these bonds is 4.5%, what is the current bond price? 2. Grabiele Enterprises has bonds on the market making annual payments, with eight years to maturity, a par value of 1,000, and selling for 948, At this price, the bonds yield 5.1%. What must the coupon rate be on the bonds? 3. A Japanese company has a bond outstanding that sells for 105.43% of its 100,000 par value. The bond has a coupon rate of 3.4% paid annually and matures in 16 years. What is the yield to maturity of this bond? 4. McConnell Corporation has bonds on the market with 14.5 years to maturity, a YTM of 5.3%, a par value of $1,000, and a current price of $1,045. The bonds make semiannual payments. What must the coupon rate be on these bonds? 5. If Treasury bills are currently paying 4.7% and the inflation rate is 2.2%, what is the approximate real rate of interest? The exact real rate