You have just purchased a municipal bond with a $$10,000$ par value for $$9,500.$ You purchased it immediately after the previous owner received a semiannual interest payment. The bond rate is $6\mathrm{.}6$ percent per year payable semiannually. You plan to hold the bond for $5$ years, selling the bond immediately after you receive the interest payment. If your desired nominal yield is $12$ percent per year compounded semiannually, what will be your minimum selling price for the bond?

how to solve using excel function