input area:

years to maturity: $14\mathrm{.}5$

coupons per year: $2$

par value: $$1,000$

yield to maturity: $5\mathrm{.}3\%$

bond price: $$987$

find coupon rate on Excel with simple calculations and without using a function.