$14.$ Using a Spreadsheet to Calculate Bond Values: What is the bond quote for a $$1,000$ face value bond with an $8$ percent coupon rate $($paid semiannually$)$ and a required return of $7\mathrm{.}5$ percent if the bond is $6\mathrm{.}48574,8\mathrm{.}47148,10\mathrm{.}519,$ and $14\mathrm{.}87875$ years from maturity?