Union Local School District has a bond outstanding with a coupon rate of $2\mathrm{.}9$

$2$ percent paid semiannually and $16$ years to maturity. The yield to maturity on this bond is $2\mathrm{.}7$ percent, and the bond has a par value of $$5,000.$ What is the dollar price of the bond?

$3$

$4.$ Input area:

$5$

$6$

Settlement date

$\frac{1}{1}\frac{?}{2020}$

Maturity date

$\frac{1}{1}\frac{?}{2036}$

Coupon rate

$2\mathrm{.}90\%$

Coupons per year

$2$

Redemption value $(\%$ of par$)$

Yield to maturity

$100$

Par value

$

$2\mathrm{.}70\%$

$12$

$13$

$14($Use cells A$6$ to B$12$ from the given information to complete this question. You must

$15$

$16$

$17$ Output area:

$18$

$19$

Price $(\%)$

Price

PLEASE INCLUDE EXCEL FORMULAS.