PLEASE ANSWER VIA EXCEL SHEET AND SHOW FORMULAS. Thank you

Calculating Bond Issuance Prices

Presented below are annual coupon rates, yield rates, and expected duration for a series of debentures.

Calculate the issuance price for each debenture assuming that the face value of each bond is $$1,000$ and that interest is paid semiannually.

BondCoupon RateYield RateDurationA$5\mathrm{.}5\%5\mathrm{.}0\%5$yearsB$3\mathrm{.}5\%4\mathrm{.}0\%6$yearsC$4\mathrm{.}5\%5\mathrm{.}0\%10$yearsD$0\mathrm{.}0\%6\mathrm{.}0\%15$yearsE$6\mathrm{.}0\%6\mathrm{.}0\%10$years

Do not round until your final answer.$$Round your answer to the nearest dollar.

ABCDE