Bond Prices $[$LO$2]$ Weismann Co$.$ issued $15-$year bonds a year ago at a coupon rate of $4\mathrm{.}9$ percent. The bonds make semiannual payments and have a par value of $$1,000.$ If the YTM on these bonds is $4\mathrm{.}5$ percent, what is the current bond price?

Input area:

$\backslash$table$[[\backslash$table$[[$Settlement date$],[$Maturity date$],[$Coupon rate$],[$Coupons per year$],[$Par value $($$$)],[$Yield to maturity$],[$Years to maturity$]],,\frac{1}{1}\frac{?}{2000}$

I have posted this questions $5$ times now. I need the solution on excel please do it on EXCEL. NO PAPER SOLUTION