I need the "Input area" filled in which will find the asnwer for me on excel that already has the forumla built in so that the answer is automatically calculcated and filled into the "Output area".

11.) Union Local School District has a bond outstanding with a coupon rate of 2.9 percent paid semiannually and 16 years to maturity. The yield to maturity on this bond is 2.7 percent, and the bond has a par value of $5,000. What is the dollar price of the bond? Chapter 7 Question 11 Input area: Settlement date Maturity date Coupon rate Coupons per year Redemption value (\% of par) Yield to maturity Par value Output area: Price (\%) #NUM! Price #NUMI