SOLVE USING EXCEL:

Working as an investment analyst for a fund that invests in fixed$-$income assets, you are tasked with evaluating the efficacy of a potential investment. You are given a bond that has a $4\%$ coupon rate and matures in $5$ years. Assume comparable debt yields $6\%$ and that the bond is sold in increments of $$1,000.$ What is the value of one increment of the bond?

a$.$ $$168\mathrm{.}49$

b$.$ $$885\mathrm{.}86$

c$.$ $$1,200\mathrm{.}00$

d$.$ $$915\mathrm{.}75$