Xerox issued bonds that pay a 6.75% coupon each year and mature in 5 years. If the required rate of return is 5.00% per annum, what is the price, first assuming interest is paid annually and the required rate of return is compounded annually, and then assuming interest is paid semi-annually and the required rate of return is compounded semi-annually. Solve using excel and show step by step how to do so by calculating.