Show me how to do this problem in excel. Horrigan Ltd$.\text{'}$s outstanding bonds have a $$1,000$ par value, and they mature in $25$ years. Their nominal annual yield to maturity is $7\%,$ they pay interest semiannually, and they sell at a price of $$929\mathrm{.}63.$ What is the bond's nominal coupon rate?

a$.3\mathrm{.}20\%$

b$.4\mathrm{.}25\%$

c$.5\mathrm{.}45\%$

d$.6\mathrm{.}00\%$

e$.6\mathrm{.}40\%$