Using excel answer the following question and show all steps

15 A) You are given responsibility of determining what to offer for many bonds from a local company. You do some research and find out that the bonds have a face amount of $1,000 and make coupon payments of $52.50 twice a year. There are 20 years to go until maturity and the current yield is 7.25%. How much should you offer for each bond?

15 B) If your firm decides to wait one year before making the investment and the current yield changes to 8.75%, what should you offer the company now for each bond?