must be done using excel and the formulas need to be shown so i can learn! if correct me and my class mayes will all like it l!! thank you so much for your help yall rock!!

1. Two 25-year maturity mortgage-backed bonds are issued. The first bond has a par value of $10,000 and promises to pay a 10.5 percent annual coupon, while the second is a zero coupon bond that promises to pay $10,000 (par) after 25 years, with interest accruing at 10 percent. At issue, bond market investors require a 12 percent interest rate on both bonds a. What is the initial price on each bond? . Now assume that both bonds promise interest at 10.5 percent, compounded semiannually. What will be the initial price for cach bond? c. If market interest rates fall to 95 percent at the end of the fifth year, what will be the value of each bond, assuming annual payments as in (o) (state both as a percentage of par value and actual dollar value)