if possible, please use excel

1. (sh, 19) A 25 -year maturity mortgage-backed bond is issued. The bond has a par value of $10,000 and promises to pay an 8 percent annual coupon. At issue, bond market investors require a 12 percent interest rate on the bond. What is the initial price on the bond? (A) $588 (B) $6,835 (C) $6,863 (D) $14,270 2. (ch 19) Using the same information as the question above, assume that 20 years after the bond is issued, bond market investors require a 15 percent interest rate on the bond. What is the market price of the bond? (A) $6,835 (B) $6,863 (C) $7,653 (D) $14,270