Calculate the current price of a $1,000 par value bond that has a coupon rate of 5% that pays coupon interest semi-annually (i.e., every 6 months), has 15 years remaining to maturity, and has a yield to maturity of 7 percent. (Your calculation must be completed using Excel -- please upload Excel spreadsheet -- and must show your work.) (Use of Financial Calculator is not permitted).